63: WHEN others THEN
64:
65: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;
66:
67: Fnd_Msg_Pub.Add_Exc_Msg
68: (
69: p_pkg_name => G_PKG_NAME,
70: p_procedure_name => l_api_name
71: );
111: WHEN no_data_found THEN
112:
113: x_return_status := Fnd_Api.G_Ret_Sts_Error;
114: Fnd_Message.Set_Name('IGW','IGW_SS_RECORD_CHANGED');
115: Fnd_Msg_Pub.Add;
116:
117: WHEN others THEN
118:
119: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;
117: WHEN others THEN
118:
119: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;
120:
121: Fnd_Msg_Pub.Add_Exc_Msg
122: (
123: p_pkg_name => G_PKG_NAME,
124: p_procedure_name => l_api_name
125: );
177: x_return_status := Fnd_Api.G_Ret_Sts_Success;
178:
179: IF Fnd_Api.To_Boolean(p_init_msg_list) THEN
180:
181: Fnd_Msg_Pub.Initialize;
182:
183: END IF;
184:
185:
211: = 'N' THEN
212:
213: x_return_status := Fnd_Api.G_Ret_Sts_Error;
214: Fnd_Message.Set_Name('IGW','IGW_SS_SEC_NO_MODIFY_RIGHTS');
215: Fnd_Msg_Pub.Add;
216: RAISE Fnd_Api.G_Exc_Error;
217:
218: END IF;
219:
266: ** Discontinue processing if any error has been encountered during
267: ** the earlier stages
268: */
269:
270: IF Fnd_Msg_Pub.Count_Msg > 0 THEN
271:
272: RAISE Fnd_Api.G_Exc_Error;
273:
274: END IF;
281: p_application_date => p_application_date,
282: x_return_status =>l_return_status
283: );
284:
285: IF Fnd_Msg_Pub.Count_Msg > 0 THEN
286:
287: RAISE Fnd_Api.G_Exc_Error;
288:
289: END IF;
338: ROLLBACK TO Create_Prop_Spl_Review_Pvt;
339:
340: x_return_status := Fnd_Api.G_Ret_Sts_Error;
341:
342: Fnd_Msg_Pub.Count_And_Get
343: (
344: p_count => x_msg_count,
345: p_data => x_msg_data
346: );
350: ROLLBACK TO Create_Prop_Spl_Review_Pvt;
351:
352: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;
353:
354: Fnd_Msg_Pub.Count_And_Get
355: (
356: p_count => x_msg_count,
357: p_data => x_msg_data
358: );
362: ROLLBACK TO Create_Prop_Spl_Review_Pvt;
363:
364: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;
365:
366: Fnd_Msg_Pub.Add_Exc_Msg
367: (
368: p_pkg_name => G_PKG_NAME,
369: p_procedure_name => l_api_name
370: );
368: p_pkg_name => G_PKG_NAME,
369: p_procedure_name => l_api_name
370: );
371:
372: Fnd_Msg_Pub.Count_And_Get
373: (
374: p_count => x_msg_count,
375: p_data => x_msg_data
376: );
428: x_return_status := Fnd_Api.G_Ret_Sts_Success;
429:
430: IF Fnd_Api.To_Boolean(p_init_msg_list) THEN
431:
432: Fnd_Msg_Pub.Initialize;
433:
434: END IF;
435:
436:
450:
451: END IF;
452:
453:
454: IF Fnd_Msg_Pub.Count_Msg > 0 THEN
455:
456: RAISE Fnd_Api.G_Exc_Error;
457:
458: END IF;
472: = 'N' THEN
473:
474: x_return_status := Fnd_Api.G_Ret_Sts_Error;
475: Fnd_Message.Set_Name('IGW','IGW_SS_SEC_NO_MODIFY_RIGHTS');
476: Fnd_Msg_Pub.Add;
477: RAISE Fnd_Api.G_Exc_Error;
478:
479: END IF;
480:
498: ** the earlier stages
499: */
500:
501:
502: IF Fnd_Msg_Pub.Count_Msg > 0 THEN
503:
504: RAISE Fnd_Api.G_Exc_Error;
505:
506: END IF;
552: ** Discontinue processing if any error has been encountered during
553: ** the earlier stages
554: */
555:
556: IF Fnd_Msg_Pub.Count_Msg > 0 THEN
557:
558: RAISE Fnd_Api.G_Exc_Error;
559:
560: END IF;
567: p_application_date => p_application_date,
568: x_return_status =>l_return_status
569: );
570:
571: IF Fnd_Msg_Pub.Count_Msg > 0 THEN
572:
573: RAISE Fnd_Api.G_Exc_Error;
574:
575: END IF;
625: ROLLBACK TO Update_Prop_Spl_Reviews_Pvt;
626:
627: x_return_status := Fnd_Api.G_Ret_Sts_Error;
628:
629: Fnd_Msg_Pub.Count_And_Get
630: (
631: p_count => x_msg_count,
632: p_data => x_msg_data
633: );
637: ROLLBACK TO Update_Prop_Spl_Reviews_Pvt;
638:
639: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;
640:
641: Fnd_Msg_Pub.Count_And_Get
642: (
643: p_count => x_msg_count,
644: p_data => x_msg_data
645: );
649: ROLLBACK TO Update_Prop_Spl_Reviews_Pvt;
650:
651: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;
652:
653: Fnd_Msg_Pub.Add_Exc_Msg
654: (
655: p_pkg_name => G_PKG_NAME,
656: p_procedure_name => l_api_name
657: );
655: p_pkg_name => G_PKG_NAME,
656: p_procedure_name => l_api_name
657: );
658:
659: Fnd_Msg_Pub.Count_And_Get
660: (
661: p_count => x_msg_count,
662: p_data => x_msg_data
663: );
699: x_return_status := Fnd_Api.G_Ret_Sts_Success;
700:
701: IF Fnd_Api.To_Boolean(p_init_msg_list) THEN
702:
703: Fnd_Msg_Pub.Initialize;
704:
705: END IF;
706:
707: /*
719: = 'N' THEN
720:
721: x_return_status := Fnd_Api.G_Ret_Sts_Error;
722: Fnd_Message.Set_Name('IGW','IGW_SS_SEC_NO_MODIFY_RIGHTS');
723: Fnd_Msg_Pub.Add;
724: RAISE Fnd_Api.G_Exc_Error;
725:
726: END IF;
727: */
741: ** Discontinue processing if any error has been encountered during
742: ** the earlier stages
743: */
744:
745: IF Fnd_Msg_Pub.Count_Msg > 0 THEN
746:
747: RAISE Fnd_Api.G_Exc_Error;
748:
749: END IF;
789: ROLLBACK TO Delete_Prop_Spl_Reviews_Pvt;
790:
791: x_return_status := Fnd_Api.G_Ret_Sts_Error;
792:
793: Fnd_Msg_Pub.Count_And_Get
794: (
795: p_count => x_msg_count,
796: p_data => x_msg_data
797: );
801: ROLLBACK TO Delete_Prop_Spl_Reviews_Pvt;
802:
803: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;
804:
805: Fnd_Msg_Pub.Count_And_Get
806: (
807: p_count => x_msg_count,
808: p_data => x_msg_data
809: );
813: ROLLBACK TO Delete_Prop_Spl_Reviews_Pvt;
814:
815: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;
816:
817: Fnd_Msg_Pub.Add_Exc_Msg
818: (
819: p_pkg_name => G_PKG_NAME,
820: p_procedure_name => l_api_name
821: );
819: p_pkg_name => G_PKG_NAME,
820: p_procedure_name => l_api_name
821: );
822:
823: Fnd_Msg_Pub.Count_And_Get
824: (
825: p_count => x_msg_count,
826: p_data => x_msg_data
827: );