77:
78: ELSIF p_mode <> 'R' THEN
79:
80: Fnd_Message.Set_Name('FND','SYSTEM-INVALID ARGS');
81: App_Exception.Raise_Exception;
82:
83: END IF;
84:
85: INSERT INTO igw_prop_comments
174: ELSIF p_mode <> 'R' THEN
175:
176: Fnd_Message.Set_Name('FND','SYSTEM-INVALID ARGS');
177: Fnd_Msg_Pub.Add;
178: App_Exception.Raise_Exception;
179:
180: END IF;
181:
182: UPDATE igw_prop_comments
194: IF SQL%NotFound THEN
195:
196: Fnd_Message.Set_Name('IGW','IGW_SS_RECORD_CHANGED');
197: Fnd_Msg_Pub.Add;
198: App_Exception.Raise_Exception;
199:
200: END IF;
201:
202: Update_Prop_Sponsor_Action(p_proposal_id);
240: IF SQL%NotFound THEN
241:
242: Fnd_Message.Set_Name('IGW','IGW_SS_RECORD_CHANGED');
243: Fnd_Msg_Pub.Add;
244: App_Exception.Raise_Exception;
245:
246: END IF;
247:
248: Update_Prop_Sponsor_Action(p_proposal_id);