DBA Data[Home] [Help]

APPS.PO_DOCUMENT_ACTION_CHECK dependencies on PO_CORE_S

Line 226: RAISE PO_CORE_S.g_early_return_exc;

222: THEN
223:
224: d_progress := 30;
225: d_msg := 'check_doc_state not successful';
226: RAISE PO_CORE_S.g_early_return_exc;
227:
228: END IF;
229:
230: d_progress := 40;

Line 247: WHEN PO_CORE_S.g_early_return_exc THEN

243:
244: l_ret_sts := 'S';
245:
246: EXCEPTION
247: WHEN PO_CORE_S.g_early_return_exc THEN
248: l_ret_sts := 'U';
249: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, d_msg);
250: IF (PO_LOG.d_exc) THEN
251: PO_LOG.exc(d_module, d_progress, d_msg);

Line 332: RAISE PO_CORE_S.g_early_return_exc;

328: THEN
329:
330: d_progress := 30;
331: d_msg := 'check_doc_state not successful';
332: RAISE PO_CORE_S.g_early_return_exc;
333:
334: END IF;
335:
336: d_progress := 40;

Line 353: WHEN PO_CORE_S.g_early_return_exc THEN

349:
350: l_ret_sts := 'S';
351:
352: EXCEPTION
353: WHEN PO_CORE_S.g_early_return_exc THEN
354: l_ret_sts := 'U';
355: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, d_msg);
356: IF (PO_LOG.d_exc) THEN
357: PO_LOG.exc(d_module, d_progress, d_msg);

Line 439: RAISE PO_CORE_S.g_early_return_exc;

435: IF (l_ret_sts = 'U')
436: THEN
437: d_progress := 20;
438: d_msg := 'unexpected error in authority_checks_setup';
439: RAISE PO_CORE_S.g_early_return_exc;
440: END IF;
441:
442: IF (l_ret_sts = 'E')
443: THEN

Line 446: RAISE PO_CORE_S.g_early_return_exc;

442: IF (l_ret_sts = 'E')
443: THEN
444: d_progress := 30;
445: d_msg := 'functional error in authority_checks_setup';
446: RAISE PO_CORE_S.g_early_return_exc;
447: END IF;
448:
449: d_progress := 40;
450:

Line 464: RAISE PO_CORE_S.g_early_return_exc;

460: THEN
461: d_progress := 50;
462: l_ret_sts := 'U';
463: d_msg := 'populate_session_gt not successful';
464: RAISE PO_CORE_S.g_early_return_exc;
465: END IF;
466:
467: d_progress := 60;
468:

Line 487: RAISE PO_CORE_S.g_early_return_exc;

483: IF (l_ret_sts <> 'S')
484: THEN
485: d_progress := 80;
486: d_msg := 'check_doc_total_limit not successful';
487: RAISE PO_CORE_S.g_early_return_exc;
488: END IF;
489:
490: IF (l_authorized_yn <> 'Y')
491: THEN

Line 495: RAISE PO_CORE_S.g_early_return_exc;

491: THEN
492: d_progress := 90;
493: d_msg := 'functional error in check_doc_total_limit';
494: p_action_ctl_rec.functional_error := fnd_message.get_string('PO', 'PO_AUT_DOC_TOT_FAIL');
495: RAISE PO_CORE_S.g_early_return_exc;
496: END IF;
497:
498: d_progress := 100;
499: IF (PO_LOG.d_stmt) THEN

Line 523: RAISE PO_CORE_S.g_early_return_exc;

519: IF (l_ret_sts <> 'S')
520: THEN
521: d_progress := 120;
522: d_msg := 'check_account_exists not successful';
523: RAISE PO_CORE_S.g_early_return_exc;
524: END IF;
525:
526: IF (l_authorized_yn <> 'Y')
527: THEN

Line 531: RAISE PO_CORE_S.g_early_return_exc;

527: THEN
528: d_progress := 130;
529: d_msg := 'functional error in check_account_exists';
530: p_action_ctl_rec.functional_error := fnd_message.get_string('PO', 'PO_AUT_ACCOUNT_NOT_EXISTS');
531: RAISE PO_CORE_S.g_early_return_exc;
532: END IF;
533:
534: d_progress := 140;
535: IF (PO_LOG.d_stmt) THEN

Line 553: RAISE PO_CORE_S.g_early_return_exc;

549: IF (l_ret_sts <> 'S')
550: THEN
551: d_progress := 150;
552: d_msg := 'check_account_limit not successful';
553: RAISE PO_CORE_S.g_early_return_exc;
554: END IF;
555:
556: IF (l_authorized_yn <> 'Y')
557: THEN

Line 561: RAISE PO_CORE_S.g_early_return_exc;

557: THEN
558: d_progress := 160;
559: d_msg := 'functional error in check_account_limit';
560: p_action_ctl_rec.functional_error := fnd_message.get_string('PO', 'PO_AUT_ACCOUNT_LIMIT_FAIL');
561: RAISE PO_CORE_S.g_early_return_exc;
562: END IF;
563:
564: d_progress := 170;
565: IF (PO_LOG.d_stmt) THEN

Line 589: RAISE PO_CORE_S.g_early_return_exc;

585: IF (l_ret_sts <> 'S')
586: THEN
587: d_progress := 190;
588: d_msg := 'check_location_limit not successful';
589: RAISE PO_CORE_S.g_early_return_exc;
590: END IF;
591:
592: IF (l_authorized_yn <> 'Y')
593: THEN

Line 597: RAISE PO_CORE_S.g_early_return_exc;

593: THEN
594: d_progress := 200;
595: d_msg := 'functional error in check_location_limit';
596: p_action_ctl_rec.functional_error := fnd_message.get_string('PO', 'PO_AUT_LOC_LIMIT_FAIL');
597: RAISE PO_CORE_S.g_early_return_exc;
598: END IF;
599:
600: d_progress := 210;
601: IF (PO_LOG.d_stmt) THEN

Line 625: RAISE PO_CORE_S.g_early_return_exc;

621: IF (l_ret_sts <> 'S')
622: THEN
623: d_progress := 230;
624: d_msg := 'check_item_limit not successful';
625: RAISE PO_CORE_S.g_early_return_exc;
626: END IF;
627:
628: IF (l_authorized_yn <> 'Y')
629: THEN

Line 633: RAISE PO_CORE_S.g_early_return_exc;

629: THEN
630: d_progress := 240;
631: d_msg := 'functional error in check_item_limit';
632: p_action_ctl_rec.functional_error := fnd_message.get_string('PO', 'PO_AUT_ITEM_LIMIT_FAIL');
633: RAISE PO_CORE_S.g_early_return_exc;
634: END IF;
635:
636: d_progress := 250;
637: IF (PO_LOG.d_stmt) THEN

Line 661: RAISE PO_CORE_S.g_early_return_exc;

657: IF (l_ret_sts <> 'S')
658: THEN
659: d_progress := 270;
660: d_msg := 'check_category_limit not successful';
661: RAISE PO_CORE_S.g_early_return_exc;
662: END IF;
663:
664: IF (l_authorized_yn <> 'Y')
665: THEN

Line 669: RAISE PO_CORE_S.g_early_return_exc;

665: THEN
666: d_progress := 280;
667: d_msg := 'functional error in check_category_limit';
668: p_action_ctl_rec.functional_error := fnd_message.get_string('PO', 'PO_AUT_CATEGORY_LIMIT_FAIL');
669: RAISE PO_CORE_S.g_early_return_exc;
670: END IF;
671:
672: d_progress := 290;
673: IF (PO_LOG.d_stmt) THEN

Line 683: WHEN PO_CORE_S.g_early_return_exc THEN

679: d_progress := 300;
680: l_authority_verified := 'Y';
681:
682: EXCEPTION
683: WHEN PO_CORE_S.g_early_return_exc THEN
684: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, d_msg);
685: IF ((l_ret_sts = 'U') and (PO_LOG.d_exc)) THEN
686: PO_LOG.exc(d_module, d_progress, d_msg);
687: END IF;

Line 807: RAISE PO_CORE_S.g_early_return_exc;

803: THEN
804: d_progress := 20;
805: l_ret_sts := 'U';
806: d_msg := 'get_employee_id not successful';
807: RAISE PO_CORE_S.g_early_return_exc;
808: END IF;
809:
810: IF (NOT l_emp_flag)
811: THEN

Line 816: RAISE PO_CORE_S.g_early_return_exc;

812: d_progress := 30;
813: l_ret_sts := 'E';
814: d_msg := 'No employee flag returned';
815: x_functional_error := fnd_message.get_string('PO', 'PO_ALL_NO_EMP_ID_FOR_USER_ID');
816: RAISE PO_CORE_S.g_early_return_exc;
817: END IF;
818:
819: ELSE
820:

Line 885: RAISE PO_CORE_S.g_early_return_exc;

881: d_progress := 90;
882: l_ret_sts := 'E';
883: d_msg := 'position_id is 0';
884: x_functional_error := fnd_message.get_string('PO', 'PO_ALL_NO_POSITION_ID');
885: RAISE PO_CORE_S.g_early_return_exc;
886: END IF;
887:
888: x_auth_check_ids.job_id := NULL;
889:

Line 910: RAISE PO_CORE_S.g_early_return_exc;

906: d_progress := 110;
907: l_ret_sts := 'E';
908: d_msg := 'job_id is 0';
909: x_functional_error := fnd_message.get_string('PO', 'PO_ALL_NO_JOB_ID');
910: RAISE PO_CORE_S.g_early_return_exc;
911: END IF;
912:
913: x_auth_check_ids.position_id := NULL;
914:

Line 940: RAISE PO_CORE_S.g_early_return_exc;

936: d_progress := 125;
937: l_ret_sts := 'E';
938: d_msg := 'no control function id available';
939: x_functional_error := fnd_message.get_string('PO', 'PO_ALL_NO_CONTROL_FUCNTION_ID');
940: RAISE PO_CORE_S.g_early_return_exc;
941: END;
942:
943: d_progress := 130;
944: IF (PO_LOG.d_stmt) THEN

Line 990: RAISE PO_CORE_S.g_early_return_exc;

986:
987: d_progress := 180;
988: l_ret_sts := 'U';
989: d_msg := 'bad document type or subtype';
990: RAISE PO_CORE_S.g_early_return_exc;
991:
992: END IF; -- p_document_type IN ...
993:
994: IF (PO_LOG.d_stmt) THEN

Line 1005: WHEN PO_CORE_S.g_early_return_exc THEN

1001:
1002: l_ret_sts := 'S';
1003:
1004: EXCEPTION
1005: WHEN PO_CORE_S.g_early_return_exc THEN
1006: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, d_msg);
1007: IF ((l_ret_sts = 'U') and (PO_LOG.d_exc)) THEN
1008: PO_LOG.exc(d_module, d_progress, d_msg);
1009: END IF;

Line 1313: RAISE PO_CORE_S.g_early_return_exc;

1309: IF (l_ret_sts <> 'S')
1310: THEN
1311: d_msg := 'get_range_limit_sql not successful';
1312: l_ret_sts := 'U';
1313: RAISE PO_CORE_S.g_early_return_exc;
1314: END IF;
1315:
1316: IF (PO_LOG.d_stmt) THEN
1317: PO_LOG.stmt(d_module, d_progress, 'l_sql', l_sql);

Line 1341: WHEN PO_CORE_S.g_early_return_exc THEN

1337:
1338: l_ret_sts := 'S';
1339:
1340: EXCEPTION
1341: WHEN PO_CORE_S.g_early_return_exc THEN
1342: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, d_msg);
1343: IF (PO_LOG.d_exc) THEN
1344: PO_LOG.exc(d_module, d_progress, d_msg);
1345: END IF;

Line 1428: RAISE PO_CORE_S.g_early_return_exc;

1424: IF (l_ret_sts <> 'S')
1425: THEN
1426: d_msg := 'get_range_exists_sql not successful';
1427: l_ret_sts := 'U';
1428: RAISE PO_CORE_S.g_early_return_exc;
1429: END IF;
1430:
1431: IF (PO_LOG.d_stmt) THEN
1432: PO_LOG.stmt(d_module, d_progress, 'l_sql', l_sql);

Line 1456: WHEN PO_CORE_S.g_early_return_exc THEN

1452:
1453: l_ret_sts := 'S';
1454:
1455: EXCEPTION
1456: WHEN PO_CORE_S.g_early_return_exc THEN
1457: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, d_msg);
1458: IF (PO_LOG.d_exc) THEN
1459: PO_LOG.exc(d_module, d_progress, d_msg);
1460: END IF;

Line 1545: RAISE PO_CORE_S.g_early_return_exc;

1541: IF (l_ret_sts <> 'S')
1542: THEN
1543: d_msg := 'get_range_limit_sql not successful';
1544: l_ret_sts := 'U';
1545: RAISE PO_CORE_S.g_early_return_exc;
1546: END IF;
1547:
1548: IF (PO_LOG.d_stmt) THEN
1549: PO_LOG.stmt(d_module, d_progress, 'l_sql', l_sql);

Line 1573: WHEN PO_CORE_S.g_early_return_exc THEN

1569:
1570: l_ret_sts := 'S';
1571:
1572: EXCEPTION
1573: WHEN PO_CORE_S.g_early_return_exc THEN
1574: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, d_msg);
1575: IF (PO_LOG.d_exc) THEN
1576: PO_LOG.exc(d_module, d_progress, d_msg);
1577: END IF;

Line 1662: RAISE PO_CORE_S.g_early_return_exc;

1658: IF (l_ret_sts <> 'S')
1659: THEN
1660: d_msg := 'get_range_limit_sql not successful';
1661: l_ret_sts := 'U';
1662: RAISE PO_CORE_S.g_early_return_exc;
1663: END IF;
1664:
1665: IF (PO_LOG.d_stmt) THEN
1666: PO_LOG.stmt(d_module, d_progress, 'l_sql', l_sql);

Line 1690: WHEN PO_CORE_S.g_early_return_exc THEN

1686:
1687: l_ret_sts := 'S';
1688:
1689: EXCEPTION
1690: WHEN PO_CORE_S.g_early_return_exc THEN
1691: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, d_msg);
1692: IF (PO_LOG.d_exc) THEN
1693: PO_LOG.exc(d_module, d_progress, d_msg);
1694: END IF;

Line 1811: RAISE PO_CORE_S.g_early_return_exc;

1807:
1808: d_progress := 40;
1809: l_ret_sts := 'U';
1810: d_msg := 'check type not supported';
1811: RAISE PO_CORE_S.g_early_return_exc;
1812:
1813: END IF;
1814:
1815: IF (PO_LOG.d_stmt) THEN

Line 1835: RAISE PO_CORE_S.g_early_return_exc;

1831:
1832: d_progress := 60;
1833: l_ret_sts := 'U';
1834: d_msg := 'get_flex_where_sql not successful';
1835: RAISE PO_CORE_S.g_early_return_exc;
1836:
1837: END IF;
1838:
1839: d_progress := 70;

Line 1881: WHEN PO_CORE_S.g_early_return_exc THEN

1877: d_progress := 80;
1878: l_ret_sts := 'S';
1879:
1880: EXCEPTION
1881: WHEN PO_CORE_S.g_early_return_exc THEN
1882: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, d_msg);
1883: IF (PO_LOG.d_exc) THEN
1884: PO_LOG.exc(d_module, d_progress, d_msg);
1885: END IF;

Line 1961: RAISE PO_CORE_S.g_early_return_exc;

1957:
1958: d_progress := 20;
1959: l_ret_sts := 'U';
1960: d_msg := 'check type not supported';
1961: RAISE PO_CORE_S.g_early_return_exc;
1962:
1963: END IF;
1964:
1965: IF (PO_LOG.d_stmt) THEN

Line 1984: RAISE PO_CORE_S.g_early_return_exc;

1980:
1981: d_progress := 40;
1982: l_ret_sts := 'U';
1983: d_msg := 'get_flex_where_sql not successful';
1984: RAISE PO_CORE_S.g_early_return_exc;
1985:
1986: END IF;
1987:
1988: d_progress := 50;

Line 2030: WHEN PO_CORE_S.g_early_return_exc THEN

2026: d_progress := 60;
2027: l_ret_sts := 'S';
2028:
2029: EXCEPTION
2030: WHEN PO_CORE_S.g_early_return_exc THEN
2031: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, d_msg);
2032: IF (PO_LOG.d_exc) THEN
2033: PO_LOG.exc(d_module, d_progress, d_msg);
2034: END IF;

Line 2129: RAISE PO_CORE_S.g_early_return_exc;

2125: ELSE
2126:
2127: d_progress := 40;
2128: d_msg := 'check type not supported';
2129: RAISE PO_CORE_S.g_early_return_exc;
2130:
2131: END IF; -- p_check_type = ...
2132:
2133: IF (PO_LOG.d_stmt) THEN

Line 2439: RAISE PO_CORE_S.g_early_return_exc;

2435:
2436: ELSE
2437:
2438: d_progress := 70;
2439: RAISE PO_CORE_S.g_early_return_exc;
2440:
2441: END IF; -- p_document_type
2442:
2443: --add by Xiao Lv for PO Notification 14-Apr-2009, begin