DBA Data[Home] [Help]

APPS.PA_PROGRESS_REPORT_PUB dependencies on FND_MSG_PUB

Line 75: FND_MSG_PUB.initialize;

71: x_return_status := FND_API.G_RET_STS_SUCCESS;
72:
73: --Clear the global PL/SQL message table
74: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
75: FND_MSG_PUB.initialize;
76: END IF;
77: /** CAll the Create Region only if any of the attribute values is not null.
78: Reason, it is creating empty records only with PK values populated **/
79: if ( p_attribute1 is not null OR

Line 184: x_msg_count := FND_MSG_PUB.Count_Msg;

180: -- IF the number of messaages is 1 then fetch the message code from the stack
181: -- and return its text
182: --
183:
184: x_msg_count := FND_MSG_PUB.Count_Msg;
185: IF x_msg_count = 1 THEN
186: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
187: ,p_msg_index => 1
188: ,p_data => x_msg_data

Line 203: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROGRESS_REPORT_PUB.Create_REPORT_REGION'

199: WHEN OTHERS THEN
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

Line 282: FND_MSG_PUB.initialize;

278: x_return_status := FND_API.G_RET_STS_SUCCESS;
279:
280: --Clear the global PL/SQL message table
281: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
282: FND_MSG_PUB.initialize;
283: END IF;
284:
285:
286: pa_progress_report_pvt.Update_REPORT_REGION

Line 350: x_msg_count := FND_MSG_PUB.Count_Msg;

346: -- IF the number of messaages is 1 then fetch the message code from the stack
347: -- and return its text
348: --
349:
350: x_msg_count := FND_MSG_PUB.Count_Msg;
351: IF x_msg_count = 1 THEN
352: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
353: ,p_msg_index => 1
354: ,p_data => x_msg_data

Line 369: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROGRESS_REPORT_PUB.Update_REPORT_REGION'

365: WHEN OTHERS THEN
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

Line 407: FND_MSG_PUB.initialize;

403: x_return_status := FND_API.G_RET_STS_SUCCESS;
404:
405: --Clear the global PL/SQL message table
406: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
407: FND_MSG_PUB.initialize;
408: END IF;
409:
410:
411: pa_progress_report_pvt.delete_report_region

Line 435: x_msg_count := FND_MSG_PUB.Count_Msg;

431: -- IF the number of messaages is 1 then fetch the message code from the stack
432: -- and return its text
433: --
434:
435: x_msg_count := FND_MSG_PUB.Count_Msg;
436: IF x_msg_count = 1 THEN
437: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
438: ,p_msg_index => 1
439: ,p_data => x_msg_data

Line 454: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROGRESS_REPORT_PUB.Delete_Progress_Report'

450: WHEN OTHERS THEN
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

Line 513: FND_MSG_PUB.initialize;

509: x_return_status := FND_API.G_RET_STS_SUCCESS;
510:
511: --Clear the global PL/SQL message table
512: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
513: FND_MSG_PUB.initialize;
514: END IF;
515:
516:
517: pa_progress_report_pvt.define_progress_report_setup

Line 562: x_msg_count := FND_MSG_PUB.Count_Msg;

558: -- IF the number of messaages is 1 then fetch the message code from the stack
559: -- and return its text
560: --
561:
562: x_msg_count := FND_MSG_PUB.Count_Msg;
563: IF x_msg_count = 1 THEN
564: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
565: ,p_msg_index => 1
566: ,p_data => x_msg_data

Line 581: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROGRESS_REPORT_PUB.define_progress_report_setup'

577: WHEN OTHERS THEN
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

Line 617: FND_MSG_PUB.initialize;

613: x_return_status := FND_API.G_RET_STS_SUCCESS;
614:
615: --Clear the global PL/SQL message table
616: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
617: FND_MSG_PUB.initialize;
618: END IF;
619:
620:
621: pa_progress_report_pvt.create_report

Line 644: x_msg_count := FND_MSG_PUB.Count_Msg;

640: -- IF the number of messaages is 1 then fetch the message code from the stack
641: -- and return its text
642: --
643:
644: x_msg_count := FND_MSG_PUB.Count_Msg;
645: IF x_msg_count = 1 THEN
646: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
647: ,p_msg_index => 1
648: ,p_data => x_msg_data

Line 663: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROGRESS_REPORT_PUB.create_report'

659: WHEN OTHERS THEN
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

Line 702: FND_MSG_PUB.initialize;

698: x_return_status := FND_API.G_RET_STS_SUCCESS;
699:
700: --Clear the global PL/SQL message table
701: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
702: FND_MSG_PUB.initialize;
703: END IF;
704:
705: IF (p_action = 'SUBMIT') THEN
706: pa_progress_report_pvt.submit_report

Line 812: x_msg_count := FND_MSG_PUB.Count_Msg;

808: -- IF the number of messaages is 1 then fetch the message code from the stack
809: -- and return its text
810: --
811:
812: x_msg_count := FND_MSG_PUB.Count_Msg;
813: IF x_msg_count = 1 THEN
814: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
815: ,p_msg_index => 1
816: ,p_data => x_msg_data

Line 831: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROGRESS_REPORT_PUB.change_report_status'

827: WHEN OTHERS THEN
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

Line 872: FND_MSG_PUB.initialize;

868: x_return_status := FND_API.G_RET_STS_SUCCESS;
869:
870: --Clear the global PL/SQL message table
871: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
872: FND_MSG_PUB.initialize;
873: END IF;
874:
875:
876: pa_progress_report_pvt.update_report_details

Line 903: x_msg_count := FND_MSG_PUB.Count_Msg;

899: -- IF the number of messaages is 1 then fetch the message code from the stack
900: -- and return its text
901: --
902:
903: x_msg_count := FND_MSG_PUB.Count_Msg;
904: IF x_msg_count = 1 THEN
905: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
906: ,p_msg_index => 1
907: ,p_data => x_msg_data

Line 922: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROGRESS_REPORT_PUB.update_report_details'

918: WHEN OTHERS THEN
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

Line 957: FND_MSG_PUB.initialize;

953: x_return_status := FND_API.G_RET_STS_SUCCESS;
954:
955: --Clear the global PL/SQL message table
956: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
957: FND_MSG_PUB.initialize;
958: END IF;
959:
960:
961: pa_progress_report_pvt.delete_report

Line 982: x_msg_count := FND_MSG_PUB.Count_Msg;

978: -- IF the number of messaages is 1 then fetch the message code from the stack
979: -- and return its text
980: --
981:
982: x_msg_count := FND_MSG_PUB.Count_Msg;
983: IF x_msg_count = 1 THEN
984: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
985: ,p_msg_index => 1
986: ,p_data => x_msg_data

Line 1001: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROGRESS_REPORT_PUB.delete_report'

997: WHEN OTHERS THEN
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

Line 1037: FND_MSG_PUB.initialize;

1033: x_return_status := FND_API.G_RET_STS_SUCCESS;
1034:
1035: --Clear the global PL/SQL message table
1036: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
1037: FND_MSG_PUB.initialize;
1038: END IF;
1039:
1040:
1041: pa_progress_report_pvt.submit_report

Line 1062: x_msg_count := FND_MSG_PUB.Count_Msg;

1058: -- IF the number of messaages is 1 then fetch the message code from the stack
1059: -- and return its text
1060: --
1061:
1062: x_msg_count := FND_MSG_PUB.Count_Msg;
1063: IF x_msg_count = 1 THEN
1064: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
1065: ,p_msg_index => 1
1066: ,p_data => x_msg_data

Line 1081: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROGRESS_REPORT_PUB.submit_report'

1077: WHEN OTHERS THEN
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

Line 1116: FND_MSG_PUB.initialize;

1112: x_return_status := FND_API.G_RET_STS_SUCCESS;
1113:
1114: --Clear the global PL/SQL message table
1115: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
1116: FND_MSG_PUB.initialize;
1117: END IF;
1118:
1119:
1120: pa_progress_report_pvt.cancel_report

Line 1142: x_msg_count := FND_MSG_PUB.Count_Msg;

1138: -- IF the number of messaages is 1 then fetch the message code from the stack
1139: -- and return its text
1140: --
1141:
1142: x_msg_count := FND_MSG_PUB.Count_Msg;
1143: IF x_msg_count = 1 THEN
1144: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
1145: ,p_msg_index => 1
1146: ,p_data => x_msg_data

Line 1161: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROGRESS_REPORT_PUB.cancel_report'

1157: WHEN OTHERS THEN
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

Line 1195: FND_MSG_PUB.initialize;

1191: x_return_status := FND_API.G_RET_STS_SUCCESS;
1192:
1193: --Clear the global PL/SQL message table
1194: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
1195: FND_MSG_PUB.initialize;
1196: END IF;
1197:
1198:
1199: pa_progress_report_pvt.rework_report

Line 1220: x_msg_count := FND_MSG_PUB.Count_Msg;

1216: -- IF the number of messaages is 1 then fetch the message code from the stack
1217: -- and return its text
1218: --
1219:
1220: x_msg_count := FND_MSG_PUB.Count_Msg;
1221: IF x_msg_count = 1 THEN
1222: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
1223: ,p_msg_index => 1
1224: ,p_data => x_msg_data

Line 1239: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROGRESS_REPORT_PUB.rework_report'

1235: WHEN OTHERS THEN
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

Line 1273: FND_MSG_PUB.initialize;

1269: x_return_status := FND_API.G_RET_STS_SUCCESS;
1270:
1271: --Clear the global PL/SQL message table
1272: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
1273: FND_MSG_PUB.initialize;
1274: END IF;
1275:
1276:
1277: pa_progress_report_pvt.publish_report

Line 1299: x_msg_count := FND_MSG_PUB.Count_Msg;

1295: -- IF the number of messaages is 1 then fetch the message code from the stack
1296: -- and return its text
1297: --
1298:
1299: x_msg_count := FND_MSG_PUB.Count_Msg;
1300: IF x_msg_count = 1 THEN
1301: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
1302: ,p_msg_index => 1
1303: ,p_data => x_msg_data

Line 1318: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROGRESS_REPORT_PUB.publish_report'

1314: WHEN OTHERS THEN
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

Line 1350: FND_MSG_PUB.initialize;

1346: x_return_status := FND_API.G_RET_STS_SUCCESS;
1347:
1348: --Clear the global PL/SQL message table
1349: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
1350: FND_MSG_PUB.initialize;
1351: END IF;
1352:
1353:
1354: pa_progress_report_pvt.approve_report

Line 1375: x_msg_count := FND_MSG_PUB.Count_Msg;

1371: -- IF the number of messaages is 1 then fetch the message code from the stack
1372: -- and return its text
1373: --
1374:
1375: x_msg_count := FND_MSG_PUB.Count_Msg;
1376: IF x_msg_count = 1 THEN
1377: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
1378: ,p_msg_index => 1
1379: ,p_data => x_msg_data

Line 1394: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROGRESS_REPORT_PUB.approve_report'

1390: WHEN OTHERS THEN
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

Line 1427: FND_MSG_PUB.initialize;

1423: x_return_status := FND_API.G_RET_STS_SUCCESS;
1424:
1425: --Clear the global PL/SQL message table
1426: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
1427: FND_MSG_PUB.initialize;
1428: END IF;
1429:
1430:
1431: pa_progress_report_pvt.reject_report

Line 1452: x_msg_count := FND_MSG_PUB.Count_Msg;

1448: -- IF the number of messaages is 1 then fetch the message code from the stack
1449: -- and return its text
1450: --
1451:
1452: x_msg_count := FND_MSG_PUB.Count_Msg;
1453: IF x_msg_count = 1 THEN
1454: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
1455: ,p_msg_index => 1
1456: ,p_data => x_msg_data

Line 1471: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROGRESS_REPORT_PUB.reject_report'

1467: WHEN OTHERS THEN
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