39:
40: ELSIF p_mode <> 'R' THEN
41:
42: Fnd_Message.Set_Name('FND','SYSTEM-INVALID ARGS');
43: App_Exception.Raise_Exception;
44:
45: END IF;
46:
47: INSERT INTO igw_prop_science_codes
125: ELSIF p_mode <> 'R' THEN
126:
127: Fnd_Message.Set_Name('FND','SYSTEM-INVALID ARGS');
128: Fnd_Msg_Pub.Add;
129: App_Exception.Raise_Exception;
130:
131: END IF;
132:
133: UPDATE igw_prop_science_codes
142: IF SQL%NotFound THEN
143:
144: Fnd_Message.Set_Name('IGW','IGW_SS_RECORD_CHANGED');
145: Fnd_Msg_Pub.Add;
146: App_Exception.Raise_Exception;
147:
148: END IF;
149:
150: EXCEPTION
185: IF SQL%NotFound THEN
186:
187: Fnd_Message.Set_Name('IGW','IGW_SS_RECORD_CHANGED');
188: Fnd_Msg_Pub.Add;
189: App_Exception.Raise_Exception;
190:
191: END IF;
192:
193: EXCEPTION