A variable number is required for a script tile to work, and if you're hacking Fire Red, the list of safe variable numbers are from 4011 to 40FF with some exceptions like:
'---------------------------------
0x4020 - 0x4024 are all pedometers, the first of them controlling REPEL expiration.
0x4036 is used for Selphy's Pokemon-fetching game. (She's the woman at Resort Gorgeous). I don't know what modifies this var -- possibly the game engine itself?
0x403A is used in elevator scripts and is directly modified when special 0xD8 is called. Don't store anything that you want to be permanent in this variable.
Vars 0x4064 through 0x4066 are used as part of the boulder puzzles in Victory Road. They're also cleared upon entering Route 23, along with 0x4067.
0x4069 sets which fossil is being revived in Cinnabar Island, and 0x406A sets the progress (1 = active, 2 = complete).
'---------------------------------
This thread covers this topic very well and could be useful:
https://www.pokecommunity.com/threads/302347
But essentially, your script is correct (I tested it out), but you have to put a variable number (note the exceptions above) in "Var number" box in Advance Map.
If you want to have your event repeat every time, you'd leave your script as it is, but if you only want it to happen once, you need to use a "setvar" command like so:
#dynamic 0x800000
#org @start
lock
special 0x113
applymovement 0x7F @camera1
waitmovement 0x0
applymovement 0x7F @camera2
waitmovement 0x0
special 0x114
setvar 0x4025 0x1 '--------- Here I used var 0x4025, you can use any from the safe range (don't use exceptions mentioned earlier). This sets variable
value to 0x1, meaning it will no longer activate. You can see by default that the "Var Value" box in Advance Map is 0000, and if
you put variable number" 4025 in "Var Number" box, the event will always activate unless you change the "Var Value" by
script to any value other than 0000.
release
end
#org @camera1
#raw 0x11
#raw 0x11
#raw 0xFE
#org @camera2
#raw 0x10
#raw 0x10
#raw 0xFE
'-------------------------
To sum it up, it seems like you either don't have a variable number in the "Var Number" box, or you are using a wrong variable. You can try using one from the safe range (4011 - 40FF while noting exceptions mentioned earlier).