48:
49: ELSIF p_mode <> 'R' THEN
50:
51: Fnd_Message.Set_Name('FND','SYSTEM-INVALID ARGS');
52: App_Exception.Raise_Exception;
53:
54: END IF;
55:
56: SELECT Nvl(Max(person_sequence) + 1,1)
162: ELSIF p_mode <> 'R' THEN
163:
164: Fnd_Message.Set_Name('FND','SYSTEM-INVALID ARGS');
165: Fnd_Msg_Pub.Add;
166: App_Exception.Raise_Exception;
167:
168: END IF;
169:
170: UPDATE igw_prop_persons
187: IF SQL%NotFound THEN
188:
189: Fnd_Message.Set_Name('IGW','IGW_SS_RECORD_CHANGED');
190: Fnd_Msg_Pub.Add;
191: App_Exception.Raise_Exception;
192:
193: END IF;
194:
195: EXCEPTION
230: IF SQL%NotFound THEN
231:
232: Fnd_Message.Set_Name('IGW','IGW_SS_RECORD_CHANGED');
233: Fnd_Msg_Pub.Add;
234: App_Exception.Raise_Exception;
235:
236: END IF;
237:
238: EXCEPTION