23: /*
24: ** Initialize
25: */
26:
27: x_return_status := Fnd_Api.G_Ret_Sts_Success;
28:
29: IF p_rowid IS NOT NULL AND p_record_version_number IS NOT NULL THEN
30:
31: SELECT 'N'
39: EXCEPTION
40:
41: WHEN no_data_found THEN
42:
43: x_return_status := Fnd_Api.G_Ret_Sts_Error;
44: Fnd_Message.Set_Name('IGW','IGW_SS_RECORD_CHANGED');
45: Fnd_Msg_Pub.Add;
46:
47: WHEN others THEN
45: Fnd_Msg_Pub.Add;
46:
47: WHEN others THEN
48:
49: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;
50:
51: Fnd_Msg_Pub.Add_Exc_Msg
52: (
53: p_pkg_name => G_PKG_NAME,
53: p_pkg_name => G_PKG_NAME,
54: p_procedure_name => l_api_name
55: );
56:
57: RAISE Fnd_Api.G_Exc_Unexpected_Error;
58:
59: END Check_Lock;
60:
61: ---------------------------------------------------------------------------
154: /*
155: ** Initialize
156: */
157:
158: x_return_status := Fnd_Api.G_Ret_Sts_Success;
159:
160: IF Fnd_Api.To_Boolean(p_init_msg_list) THEN
161:
162: Fnd_Msg_Pub.Initialize;
156: */
157:
158: x_return_status := Fnd_Api.G_Ret_Sts_Success;
159:
160: IF Fnd_Api.To_Boolean(p_init_msg_list) THEN
161:
162: Fnd_Msg_Pub.Initialize;
163:
164: END IF;
183: END IF;
184:
185: IF Fnd_Msg_Pub.Count_Msg > 0 THEN
186:
187: RAISE Fnd_Api.G_Exc_Error;
188:
189: END IF;
190:
191:
201: p_user_id => Fnd_Global.User_Id
202: )
203: = 'N' THEN
204:
205: x_return_status := Fnd_Api.G_Ret_Sts_Error;
206: Fnd_Message.Set_Name('IGW','IGW_SS_SEC_NO_MODIFY_RIGHTS');
207: Fnd_Msg_Pub.Add;
208: RAISE Fnd_Api.G_Exc_Error;
209:
204:
205: x_return_status := Fnd_Api.G_Ret_Sts_Error;
206: Fnd_Message.Set_Name('IGW','IGW_SS_SEC_NO_MODIFY_RIGHTS');
207: Fnd_Msg_Pub.Add;
208: RAISE Fnd_Api.G_Exc_Error;
209:
210: END IF;
211:
212: */
211:
212: */
213: IF Fnd_Msg_Pub.Count_Msg > 0 THEN
214:
215: RAISE Fnd_Api.G_Exc_Error;
216:
217: END IF;
218:
219:
236:
237:
238: IF Fnd_Msg_Pub.Count_Msg > 0 THEN
239:
240: RAISE Fnd_Api.G_Exc_Error;
241:
242: END IF;
243:
244:
268: */
269:
270: IF Fnd_Msg_Pub.Count_Msg > 0 THEN
271:
272: RAISE Fnd_Api.G_Exc_Error;
273:
274: END IF;
275:
276:
277: /*
278: ** Discontinue processing if API invoked in validation mode
279: */
280:
281: IF Fnd_Api.To_Boolean(p_validate_only) THEN
282:
283: RETURN;
284:
285: END IF;
320: /*
321: ** Commit data if API invoked in commit mode
322: */
323:
324: IF Fnd_Api.To_Boolean(p_commit) THEN
325:
326: COMMIT;
327:
328: END IF;
329:
330:
331: EXCEPTION
332:
333: WHEN Fnd_Api.G_Exc_Error THEN
334:
335: ROLLBACK TO Update_Prop_Abstract_Pvt;
336:
337: x_return_status := Fnd_Api.G_Ret_Sts_Error;
333: WHEN Fnd_Api.G_Exc_Error THEN
334:
335: ROLLBACK TO Update_Prop_Abstract_Pvt;
336:
337: x_return_status := Fnd_Api.G_Ret_Sts_Error;
338:
339: Fnd_Msg_Pub.Count_And_Get
340: (
341: p_count => x_msg_count,
341: p_count => x_msg_count,
342: p_data => x_msg_data
343: );
344:
345: WHEN Fnd_Api.G_Exc_Unexpected_Error THEN
346:
347: ROLLBACK TO Update_Prop_Abstract_Pvt;
348:
349: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;
345: WHEN Fnd_Api.G_Exc_Unexpected_Error THEN
346:
347: ROLLBACK TO Update_Prop_Abstract_Pvt;
348:
349: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;
350:
351: Fnd_Msg_Pub.Count_And_Get
352: (
353: p_count => x_msg_count,
357: WHEN others THEN
358:
359: ROLLBACK TO Update_Prop_Abstract_Pvt;
360:
361: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;
362:
363: Fnd_Msg_Pub.Add_Exc_Msg
364: (
365: p_pkg_name => G_PKG_NAME,