64:
65: BEGIN
66:
67: -- Initialize the Error Stack
68: PA_DEBUG.init_err_stack('PA_PROGRESS_REPORT_PUB.Create_REPORT_REGION');
69:
70: -- Initialize the return status to success
71: x_return_status := FND_API.G_RET_STS_SUCCESS;
72:
190: );
191: END IF;
192:
193: -- Reset the error stack when returning to the calling program
194: PA_DEBUG.Reset_Err_Stack;
195:
196:
197: -- Put any message text from message stack into the Message ARRAY
198: EXCEPTION
200: rollback;
201:
202: -- Set the excetption Message and the stack
203: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROGRESS_REPORT_PUB.Create_REPORT_REGION'
204: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
205: --
206: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
207: RAISE; -- This is optional depending on the needs
208:
271: l_msg_index_out NUMBER;
272: BEGIN
273:
274: -- Initialize the Error Stack
275: PA_DEBUG.init_err_stack('PA_PROGRESS_REPORT_PUB.Update_REPORT_REGION');
276:
277: -- Initialize the return status to success
278: x_return_status := FND_API.G_RET_STS_SUCCESS;
279:
356: );
357: END IF;
358:
359: -- Reset the error stack when returning to the calling program
360: PA_DEBUG.Reset_Err_Stack;
361:
362:
363: -- Put any message text from message stack into the Message ARRAY
364: EXCEPTION
366: rollback;
367:
368: -- Set the excetption Message and the stack
369: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROGRESS_REPORT_PUB.Update_REPORT_REGION'
370: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
371: --
372: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
373: RAISE; -- This is optional depending on the needs
374: END Update_REPORT_REGION;
396: l_msg_index_out NUMBER;
397: BEGIN
398:
399: -- Initialize the Error Stack
400: PA_DEBUG.init_err_stack('PA_PROGRESS_REPORT_PUB.Delete_Progress_Report');
401:
402: -- Initialize the return status to success
403: x_return_status := FND_API.G_RET_STS_SUCCESS;
404:
441: );
442: END IF;
443:
444: -- Reset the error stack when returning to the calling program
445: PA_DEBUG.Reset_Err_Stack;
446:
447:
448: -- Put any message text from message stack into the Message ARRAY
449: EXCEPTION
451: rollback;
452:
453: -- Set the excetption Message and the stack
454: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROGRESS_REPORT_PUB.Delete_Progress_Report'
455: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
456: --
457: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
458: RAISE; -- This is optional depending on the needs
459: END Delete_Report_Region;
502: l_msg_index_out NUMBER;
503: BEGIN
504:
505: -- Initialize the Error Stack
506: PA_DEBUG.init_err_stack('PA_PROGRESS_REPORT_PUB.define_progress_report_setup');
507:
508: -- Initialize the return status to success
509: x_return_status := FND_API.G_RET_STS_SUCCESS;
510:
568: );
569: END IF;
570:
571: -- Reset the error stack when returning to the calling program
572: PA_DEBUG.Reset_Err_Stack;
573:
574:
575: -- Put any message text from message stack into the Message ARRAY
576: EXCEPTION
578: rollback;
579:
580: -- Set the excetption Message and the stack
581: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROGRESS_REPORT_PUB.define_progress_report_setup'
582: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
583: --
584: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
585: RAISE; -- This is optional depending on the needs
586: END define_progress_report_setup;
606: l_msg_index_out NUMBER;
607: BEGIN
608:
609: -- Initialize the Error Stack
610: PA_DEBUG.init_err_stack('PA_PROGRESS_REPORT_PUB.create_report');
611:
612: -- Initialize the return status to success
613: x_return_status := FND_API.G_RET_STS_SUCCESS;
614:
650: );
651: END IF;
652:
653: -- Reset the error stack when returning to the calling program
654: PA_DEBUG.Reset_Err_Stack;
655:
656:
657: -- Put any message text from message stack into the Message ARRAY
658: EXCEPTION
660: rollback;
661:
662: -- Set the excetption Message and the stack
663: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROGRESS_REPORT_PUB.create_report'
664: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
665: --
666: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
667: RAISE; -- This is optional depending on the needs
668:
691: l_msg_index_out NUMBER;
692: BEGIN
693:
694: -- Initialize the Error Stack
695: PA_DEBUG.init_err_stack('PA_PROGRESS_REPORT_PUB.change_report_status');
696:
697: -- Initialize the return status to success
698: x_return_status := FND_API.G_RET_STS_SUCCESS;
699:
818: );
819: END IF;
820:
821: -- Reset the error stack when returning to the calling program
822: PA_DEBUG.Reset_Err_Stack;
823:
824:
825: -- Put any message text from message stack into the Message ARRAY
826: EXCEPTION
828: rollback;
829:
830: -- Set the excetption Message and the stack
831: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROGRESS_REPORT_PUB.change_report_status'
832: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
833: --
834: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
835: RAISE; -- This is optional depending on the needs
836:
861: l_msg_index_out NUMBER;
862: BEGIN
863:
864: -- Initialize the Error Stack
865: PA_DEBUG.init_err_stack('PA_PROGRESS_REPORT_PUB.update_report_details');
866:
867: -- Initialize the return status to success
868: x_return_status := FND_API.G_RET_STS_SUCCESS;
869:
909: );
910: END IF;
911:
912: -- Reset the error stack when returning to the calling program
913: PA_DEBUG.Reset_Err_Stack;
914:
915:
916: -- Put any message text from message stack into the Message ARRAY
917: EXCEPTION
919: rollback;
920:
921: -- Set the excetption Message and the stack
922: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROGRESS_REPORT_PUB.update_report_details'
923: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
924: --
925: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
926: RAISE; -- This is optional depending on the needs
927:
946: l_msg_index_out NUMBER;
947: BEGIN
948:
949: -- Initialize the Error Stack
950: PA_DEBUG.init_err_stack('PA_PROGRESS_REPORT_PUB.delete_report');
951:
952: -- Initialize the return status to success
953: x_return_status := FND_API.G_RET_STS_SUCCESS;
954:
988: );
989: END IF;
990:
991: -- Reset the error stack when returning to the calling program
992: PA_DEBUG.Reset_Err_Stack;
993:
994:
995: -- Put any message text from message stack into the Message ARRAY
996: EXCEPTION
998: rollback;
999:
1000: -- Set the excetption Message and the stack
1001: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROGRESS_REPORT_PUB.delete_report'
1002: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1003: --
1004: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1005: RAISE; -- This is optional depending on the needs
1006: END delete_report;
1026: l_msg_index_out NUMBER;
1027: BEGIN
1028:
1029: -- Initialize the Error Stack
1030: PA_DEBUG.init_err_stack('PA_PROGRESS_REPORT_PUB.submit_report');
1031:
1032: -- Initialize the return status to success
1033: x_return_status := FND_API.G_RET_STS_SUCCESS;
1034:
1068: );
1069: END IF;
1070:
1071: -- Reset the error stack when returning to the calling program
1072: PA_DEBUG.Reset_Err_Stack;
1073:
1074:
1075: -- Put any message text from message stack into the Message ARRAY
1076: EXCEPTION
1078: rollback;
1079:
1080: -- Set the excetption Message and the stack
1081: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROGRESS_REPORT_PUB.submit_report'
1082: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1083: --
1084: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1085: RAISE; -- This is optional depending on the needs
1086: END submit_report;
1105: l_msg_index_out NUMBER;
1106: BEGIN
1107:
1108: -- Initialize the Error Stack
1109: PA_DEBUG.init_err_stack('PA_PROGRESS_REPORT_PUB.cancel_report');
1110:
1111: -- Initialize the return status to success
1112: x_return_status := FND_API.G_RET_STS_SUCCESS;
1113:
1148: );
1149: END IF;
1150:
1151: -- Reset the error stack when returning to the calling program
1152: PA_DEBUG.Reset_Err_Stack;
1153:
1154:
1155: -- Put any message text from message stack into the Message ARRAY
1156: EXCEPTION
1158: rollback;
1159:
1160: -- Set the excetption Message and the stack
1161: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROGRESS_REPORT_PUB.cancel_report'
1162: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1163: --
1164: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1165: RAISE; -- This is optional depending on the needs
1166: END cancel_report;
1184: l_msg_index_out NUMBER;
1185: BEGIN
1186:
1187: -- Initialize the Error Stack
1188: PA_DEBUG.init_err_stack('PA_PROGRESS_REPORT_PUB.rework_report');
1189:
1190: -- Initialize the return status to success
1191: x_return_status := FND_API.G_RET_STS_SUCCESS;
1192:
1226: );
1227: END IF;
1228:
1229: -- Reset the error stack when returning to the calling program
1230: PA_DEBUG.Reset_Err_Stack;
1231:
1232:
1233: -- Put any message text from message stack into the Message ARRAY
1234: EXCEPTION
1236: rollback;
1237:
1238: -- Set the excetption Message and the stack
1239: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROGRESS_REPORT_PUB.rework_report'
1240: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1241: --
1242: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1243: RAISE; -- This is optional depending on the needs
1244: END rework_report;
1262: l_msg_index_out NUMBER;
1263: BEGIN
1264:
1265: -- Initialize the Error Stack
1266: PA_DEBUG.init_err_stack('PA_PROGRESS_REPORT_PUB.publish_report');
1267:
1268: -- Initialize the return status to success
1269: x_return_status := FND_API.G_RET_STS_SUCCESS;
1270:
1305: );
1306: END IF;
1307:
1308: -- Reset the error stack when returning to the calling program
1309: PA_DEBUG.Reset_Err_Stack;
1310:
1311:
1312: -- Put any message text from message stack into the Message ARRAY
1313: EXCEPTION
1315: rollback;
1316:
1317: -- Set the excetption Message and the stack
1318: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROGRESS_REPORT_PUB.publish_report'
1319: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1320: --
1321: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1322: RAISE; -- This is optional depending on the needs
1323: END publish_report;
1339: l_msg_index_out NUMBER;
1340: BEGIN
1341:
1342: -- Initialize the Error Stack
1343: PA_DEBUG.init_err_stack('PA_PROGRESS_REPORT_PUB.approve_report');
1344:
1345: -- Initialize the return status to success
1346: x_return_status := FND_API.G_RET_STS_SUCCESS;
1347:
1381: );
1382: END IF;
1383:
1384: -- Reset the error stack when returning to the calling program
1385: PA_DEBUG.Reset_Err_Stack;
1386:
1387:
1388: -- Put any message text from message stack into the Message ARRAY
1389: EXCEPTION
1391: rollback;
1392:
1393: -- Set the excetption Message and the stack
1394: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROGRESS_REPORT_PUB.approve_report'
1395: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1396: --
1397: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1398: RAISE; -- This is optional depending on the needs
1399: END approve_report;
1416: l_msg_index_out NUMBER;
1417: BEGIN
1418:
1419: -- Initialize the Error Stack
1420: PA_DEBUG.init_err_stack('PA_PROGRESS_REPORT_PUB.reject_report');
1421:
1422: -- Initialize the return status to success
1423: x_return_status := FND_API.G_RET_STS_SUCCESS;
1424:
1458: );
1459: END IF;
1460:
1461: -- Reset the error stack when returning to the calling program
1462: PA_DEBUG.Reset_Err_Stack;
1463:
1464:
1465: -- Put any message text from message stack into the Message ARRAY
1466: EXCEPTION
1468: rollback;
1469:
1470: -- Set the excetption Message and the stack
1471: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROGRESS_REPORT_PUB.reject_report'
1472: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1473: --
1474: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1475: RAISE; -- This is optional depending on the needs
1476: END reject_report;