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
48:
49: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;
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,
54: p_procedure_name => l_api_name
55: );
98: x_return_status := Fnd_Api.G_Ret_Sts_Success;
99:
100: IF Fnd_Api.To_Boolean(p_init_msg_list) THEN
101:
102: Fnd_Msg_Pub.Initialize;
103:
104: END IF;
105:
106:
133: = 'N' THEN
134:
135: x_return_status := Fnd_Api.G_Ret_Sts_Error;
136: Fnd_Message.Set_Name('IGW','IGW_SS_SEC_NO_MODIFY_RIGHTS');
137: Fnd_Msg_Pub.Add;
138: RAISE Fnd_Api.G_Exc_Error;
139:
140: END IF;
141: */
185: ROLLBACK TO CREATE_SPONSOR_ACTION_PVT;
186:
187: x_return_status := Fnd_Api.G_Ret_Sts_Error;
188:
189: Fnd_Msg_Pub.Count_And_Get
190: (
191: p_count => x_msg_count,
192: p_data => x_msg_data
193: );
197: ROLLBACK TO CREATE_SPONSOR_ACTION_PVT;
198:
199: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;
200:
201: Fnd_Msg_Pub.Count_And_Get
202: (
203: p_count => x_msg_count,
204: p_data => x_msg_data
205: );
209: ROLLBACK TO CREATE_SPONSOR_ACTION_PVT;
210:
211: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;
212:
213: Fnd_Msg_Pub.Add_Exc_Msg
214: (
215: p_pkg_name => G_PKG_NAME,
216: p_procedure_name => l_api_name
217: );
215: p_pkg_name => G_PKG_NAME,
216: p_procedure_name => l_api_name
217: );
218:
219: Fnd_Msg_Pub.Count_And_Get
220: (
221: p_count => x_msg_count,
222: p_data => x_msg_data
223: );
266: x_return_status := Fnd_Api.G_Ret_Sts_Success;
267:
268: IF Fnd_Api.To_Boolean(p_init_msg_list) THEN
269:
270: Fnd_Msg_Pub.Initialize;
271:
272: END IF;
273:
274:
289: );
290:
291: END IF;
292:
293: IF Fnd_Msg_Pub.Count_Msg > 0 THEN
294:
295: RAISE Fnd_Api.G_Exc_Error;
296:
297: END IF;
311: = 'N' THEN
312:
313: x_return_status := Fnd_Api.G_Ret_Sts_Error;
314: Fnd_Message.Set_Name('IGW','IGW_SS_SEC_NO_MODIFY_RIGHTS');
315: Fnd_Msg_Pub.Add;
316: RAISE Fnd_Api.G_Exc_Error;
317:
318: END IF;
319:
337: ** the earlier stages
338: */
339:
340:
341: IF Fnd_Msg_Pub.Count_Msg > 0 THEN
342:
343: RAISE Fnd_Api.G_Exc_Error;
344:
345: END IF;
349: ** Discontinue processing if any error has been encountered during
350: ** the earlier stages
351: */
352:
353: IF Fnd_Msg_Pub.Count_Msg > 0 THEN
354:
355: RAISE Fnd_Api.G_Exc_Error;
356:
357: END IF;
403: ROLLBACK TO UPDATE_SPONSOR_ACTION_PVT;
404:
405: x_return_status := Fnd_Api.G_Ret_Sts_Error;
406:
407: Fnd_Msg_Pub.Count_And_Get
408: (
409: p_count => x_msg_count,
410: p_data => x_msg_data
411: );
415: ROLLBACK TO UPDATE_SPONSOR_ACTION_PVT;
416:
417: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;
418:
419: Fnd_Msg_Pub.Count_And_Get
420: (
421: p_count => x_msg_count,
422: p_data => x_msg_data
423: );
427: ROLLBACK TO UPDATE_SPONSOR_ACTION_PVT;
428:
429: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;
430:
431: Fnd_Msg_Pub.Add_Exc_Msg
432: (
433: p_pkg_name => G_PKG_NAME,
434: p_procedure_name => l_api_name
435: );
433: p_pkg_name => G_PKG_NAME,
434: p_procedure_name => l_api_name
435: );
436:
437: Fnd_Msg_Pub.Count_And_Get
438: (
439: p_count => x_msg_count,
440: p_data => x_msg_data
441: );
477: x_return_status := Fnd_Api.G_Ret_Sts_Success;
478:
479: IF Fnd_Api.To_Boolean(p_init_msg_list) THEN
480:
481: Fnd_Msg_Pub.Initialize;
482:
483: END IF;
484:
485: /*
497: = 'N' THEN
498:
499: x_return_status := Fnd_Api.G_Ret_Sts_Error;
500: Fnd_Message.Set_Name('IGW','IGW_SS_SEC_NO_MODIFY_RIGHTS');
501: Fnd_Msg_Pub.Add;
502: RAISE Fnd_Api.G_Exc_Error;
503:
504: END IF;
505: */
520: ** Discontinue processing if any error has been encountered during
521: ** the earlier stages
522: */
523:
524: IF Fnd_Msg_Pub.Count_Msg > 0 THEN
525:
526: RAISE Fnd_Api.G_Exc_Error;
527:
528: END IF;
569: ROLLBACK TO DELETE_SPONSOR_ACTION_PVT;
570:
571: x_return_status := Fnd_Api.G_Ret_Sts_Error;
572:
573: Fnd_Msg_Pub.Count_And_Get
574: (
575: p_count => x_msg_count,
576: p_data => x_msg_data
577: );
581: ROLLBACK TO DELETE_SPONSOR_ACTION_PVT;
582:
583: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;
584:
585: Fnd_Msg_Pub.Count_And_Get
586: (
587: p_count => x_msg_count,
588: p_data => x_msg_data
589: );
593: ROLLBACK TO DELETE_SPONSOR_ACTION_PVT;
594:
595: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;
596:
597: Fnd_Msg_Pub.Add_Exc_Msg
598: (
599: p_pkg_name => G_PKG_NAME,
600: p_procedure_name => l_api_name
601: );
599: p_pkg_name => G_PKG_NAME,
600: p_procedure_name => l_api_name
601: );
602:
603: Fnd_Msg_Pub.Count_And_Get
604: (
605: p_count => x_msg_count,
606: p_data => x_msg_data
607: );