DBA Data[Home] [Help]

APPS.PO_DOCUMENT_ACTION_CHECK dependencies on PO_CORE_S

Line 212: RAISE PO_CORE_S.g_early_return_exc;

208: THEN
209:
210: d_progress := 30;
211: d_msg := 'check_doc_state not successful';
212: RAISE PO_CORE_S.g_early_return_exc;
213:
214: END IF;
215:
216: d_progress := 40;

Line 233: WHEN PO_CORE_S.g_early_return_exc THEN

229:
230: l_ret_sts := 'S';
231:
232: EXCEPTION
233: WHEN PO_CORE_S.g_early_return_exc THEN
234: l_ret_sts := 'U';
235: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, d_msg);
236: IF (PO_LOG.d_exc) THEN
237: PO_LOG.exc(d_module, d_progress, d_msg);

Line 316: RAISE PO_CORE_S.g_early_return_exc;

312: THEN
313:
314: d_progress := 30;
315: d_msg := 'check_doc_state not successful';
316: RAISE PO_CORE_S.g_early_return_exc;
317:
318: END IF;
319:
320: d_progress := 40;

Line 337: WHEN PO_CORE_S.g_early_return_exc THEN

333:
334: l_ret_sts := 'S';
335:
336: EXCEPTION
337: WHEN PO_CORE_S.g_early_return_exc THEN
338: l_ret_sts := 'U';
339: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, d_msg);
340: IF (PO_LOG.d_exc) THEN
341: PO_LOG.exc(d_module, d_progress, d_msg);

Line 423: RAISE PO_CORE_S.g_early_return_exc;

419: IF (l_ret_sts = 'U')
420: THEN
421: d_progress := 20;
422: d_msg := 'unexpected error in authority_checks_setup';
423: RAISE PO_CORE_S.g_early_return_exc;
424: END IF;
425:
426: IF (l_ret_sts = 'E')
427: THEN

Line 430: RAISE PO_CORE_S.g_early_return_exc;

426: IF (l_ret_sts = 'E')
427: THEN
428: d_progress := 30;
429: d_msg := 'functional error in authority_checks_setup';
430: RAISE PO_CORE_S.g_early_return_exc;
431: END IF;
432:
433: d_progress := 40;
434:

Line 448: RAISE PO_CORE_S.g_early_return_exc;

444: THEN
445: d_progress := 50;
446: l_ret_sts := 'U';
447: d_msg := 'populate_session_gt not successful';
448: RAISE PO_CORE_S.g_early_return_exc;
449: END IF;
450:
451: d_progress := 60;
452:

Line 471: RAISE PO_CORE_S.g_early_return_exc;

467: IF (l_ret_sts <> 'S')
468: THEN
469: d_progress := 80;
470: d_msg := 'check_doc_total_limit not successful';
471: RAISE PO_CORE_S.g_early_return_exc;
472: END IF;
473:
474: IF (l_authorized_yn <> 'Y')
475: THEN

Line 479: RAISE PO_CORE_S.g_early_return_exc;

475: THEN
476: d_progress := 90;
477: d_msg := 'functional error in check_doc_total_limit';
478: p_action_ctl_rec.functional_error := fnd_message.get_string('PO', 'PO_AUT_DOC_TOT_FAIL');
479: RAISE PO_CORE_S.g_early_return_exc;
480: END IF;
481:
482: d_progress := 100;
483: IF (PO_LOG.d_stmt) THEN

Line 507: RAISE PO_CORE_S.g_early_return_exc;

503: IF (l_ret_sts <> 'S')
504: THEN
505: d_progress := 120;
506: d_msg := 'check_account_exists not successful';
507: RAISE PO_CORE_S.g_early_return_exc;
508: END IF;
509:
510: IF (l_authorized_yn <> 'Y')
511: THEN

Line 515: RAISE PO_CORE_S.g_early_return_exc;

511: THEN
512: d_progress := 130;
513: d_msg := 'functional error in check_account_exists';
514: p_action_ctl_rec.functional_error := fnd_message.get_string('PO', 'PO_AUT_ACCOUNT_NOT_EXISTS');
515: RAISE PO_CORE_S.g_early_return_exc;
516: END IF;
517:
518: d_progress := 140;
519: IF (PO_LOG.d_stmt) THEN

Line 537: RAISE PO_CORE_S.g_early_return_exc;

533: IF (l_ret_sts <> 'S')
534: THEN
535: d_progress := 150;
536: d_msg := 'check_account_limit not successful';
537: RAISE PO_CORE_S.g_early_return_exc;
538: END IF;
539:
540: IF (l_authorized_yn <> 'Y')
541: THEN

Line 545: RAISE PO_CORE_S.g_early_return_exc;

541: THEN
542: d_progress := 160;
543: d_msg := 'functional error in check_account_limit';
544: p_action_ctl_rec.functional_error := fnd_message.get_string('PO', 'PO_AUT_ACCOUNT_LIMIT_FAIL');
545: RAISE PO_CORE_S.g_early_return_exc;
546: END IF;
547:
548: d_progress := 170;
549: IF (PO_LOG.d_stmt) THEN

Line 573: RAISE PO_CORE_S.g_early_return_exc;

569: IF (l_ret_sts <> 'S')
570: THEN
571: d_progress := 190;
572: d_msg := 'check_location_limit not successful';
573: RAISE PO_CORE_S.g_early_return_exc;
574: END IF;
575:
576: IF (l_authorized_yn <> 'Y')
577: THEN

Line 581: RAISE PO_CORE_S.g_early_return_exc;

577: THEN
578: d_progress := 200;
579: d_msg := 'functional error in check_location_limit';
580: p_action_ctl_rec.functional_error := fnd_message.get_string('PO', 'PO_AUT_LOC_LIMIT_FAIL');
581: RAISE PO_CORE_S.g_early_return_exc;
582: END IF;
583:
584: d_progress := 210;
585: IF (PO_LOG.d_stmt) THEN

Line 609: RAISE PO_CORE_S.g_early_return_exc;

605: IF (l_ret_sts <> 'S')
606: THEN
607: d_progress := 230;
608: d_msg := 'check_item_limit not successful';
609: RAISE PO_CORE_S.g_early_return_exc;
610: END IF;
611:
612: IF (l_authorized_yn <> 'Y')
613: THEN

Line 617: RAISE PO_CORE_S.g_early_return_exc;

613: THEN
614: d_progress := 240;
615: d_msg := 'functional error in check_item_limit';
616: p_action_ctl_rec.functional_error := fnd_message.get_string('PO', 'PO_AUT_ITEM_LIMIT_FAIL');
617: RAISE PO_CORE_S.g_early_return_exc;
618: END IF;
619:
620: d_progress := 250;
621: IF (PO_LOG.d_stmt) THEN

Line 645: RAISE PO_CORE_S.g_early_return_exc;

641: IF (l_ret_sts <> 'S')
642: THEN
643: d_progress := 270;
644: d_msg := 'check_category_limit not successful';
645: RAISE PO_CORE_S.g_early_return_exc;
646: END IF;
647:
648: IF (l_authorized_yn <> 'Y')
649: THEN

Line 653: RAISE PO_CORE_S.g_early_return_exc;

649: THEN
650: d_progress := 280;
651: d_msg := 'functional error in check_category_limit';
652: p_action_ctl_rec.functional_error := fnd_message.get_string('PO', 'PO_AUT_CATEGORY_LIMIT_FAIL');
653: RAISE PO_CORE_S.g_early_return_exc;
654: END IF;
655:
656: d_progress := 290;
657: IF (PO_LOG.d_stmt) THEN

Line 667: WHEN PO_CORE_S.g_early_return_exc THEN

663: d_progress := 300;
664: l_authority_verified := 'Y';
665:
666: EXCEPTION
667: WHEN PO_CORE_S.g_early_return_exc THEN
668: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, d_msg);
669: IF ((l_ret_sts = 'U') and (PO_LOG.d_exc)) THEN
670: PO_LOG.exc(d_module, d_progress, d_msg);
671: END IF;

Line 791: RAISE PO_CORE_S.g_early_return_exc;

787: THEN
788: d_progress := 20;
789: l_ret_sts := 'U';
790: d_msg := 'get_employee_id not successful';
791: RAISE PO_CORE_S.g_early_return_exc;
792: END IF;
793:
794: IF (NOT l_emp_flag)
795: THEN

Line 800: RAISE PO_CORE_S.g_early_return_exc;

796: d_progress := 30;
797: l_ret_sts := 'E';
798: d_msg := 'No employee flag returned';
799: x_functional_error := fnd_message.get_string('PO', 'PO_ALL_NO_EMP_ID_FOR_USER_ID');
800: RAISE PO_CORE_S.g_early_return_exc;
801: END IF;
802:
803: ELSE
804:

Line 869: RAISE PO_CORE_S.g_early_return_exc;

865: d_progress := 90;
866: l_ret_sts := 'E';
867: d_msg := 'position_id is 0';
868: x_functional_error := fnd_message.get_string('PO', 'PO_ALL_NO_POSITION_ID');
869: RAISE PO_CORE_S.g_early_return_exc;
870: END IF;
871:
872: x_auth_check_ids.job_id := NULL;
873:

Line 894: RAISE PO_CORE_S.g_early_return_exc;

890: d_progress := 110;
891: l_ret_sts := 'E';
892: d_msg := 'job_id is 0';
893: x_functional_error := fnd_message.get_string('PO', 'PO_ALL_NO_JOB_ID');
894: RAISE PO_CORE_S.g_early_return_exc;
895: END IF;
896:
897: x_auth_check_ids.position_id := NULL;
898:

Line 924: RAISE PO_CORE_S.g_early_return_exc;

920: d_progress := 125;
921: l_ret_sts := 'E';
922: d_msg := 'no control function id available';
923: x_functional_error := fnd_message.get_string('PO', 'PO_ALL_NO_CONTROL_FUCNTION_ID');
924: RAISE PO_CORE_S.g_early_return_exc;
925: END;
926:
927: d_progress := 130;
928: IF (PO_LOG.d_stmt) THEN

Line 974: RAISE PO_CORE_S.g_early_return_exc;

970:
971: d_progress := 180;
972: l_ret_sts := 'U';
973: d_msg := 'bad document type or subtype';
974: RAISE PO_CORE_S.g_early_return_exc;
975:
976: END IF; -- p_document_type IN ...
977:
978: IF (PO_LOG.d_stmt) THEN

Line 989: WHEN PO_CORE_S.g_early_return_exc THEN

985:
986: l_ret_sts := 'S';
987:
988: EXCEPTION
989: WHEN PO_CORE_S.g_early_return_exc THEN
990: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, d_msg);
991: IF ((l_ret_sts = 'U') and (PO_LOG.d_exc)) THEN
992: PO_LOG.exc(d_module, d_progress, d_msg);
993: END IF;

Line 1297: RAISE PO_CORE_S.g_early_return_exc;

1293: IF (l_ret_sts <> 'S')
1294: THEN
1295: d_msg := 'get_range_limit_sql not successful';
1296: l_ret_sts := 'U';
1297: RAISE PO_CORE_S.g_early_return_exc;
1298: END IF;
1299:
1300: IF (PO_LOG.d_stmt) THEN
1301: PO_LOG.stmt(d_module, d_progress, 'l_sql', l_sql);

Line 1325: WHEN PO_CORE_S.g_early_return_exc THEN

1321:
1322: l_ret_sts := 'S';
1323:
1324: EXCEPTION
1325: WHEN PO_CORE_S.g_early_return_exc THEN
1326: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, d_msg);
1327: IF (PO_LOG.d_exc) THEN
1328: PO_LOG.exc(d_module, d_progress, d_msg);
1329: END IF;

Line 1412: RAISE PO_CORE_S.g_early_return_exc;

1408: IF (l_ret_sts <> 'S')
1409: THEN
1410: d_msg := 'get_range_exists_sql not successful';
1411: l_ret_sts := 'U';
1412: RAISE PO_CORE_S.g_early_return_exc;
1413: END IF;
1414:
1415: IF (PO_LOG.d_stmt) THEN
1416: PO_LOG.stmt(d_module, d_progress, 'l_sql', l_sql);

Line 1440: WHEN PO_CORE_S.g_early_return_exc THEN

1436:
1437: l_ret_sts := 'S';
1438:
1439: EXCEPTION
1440: WHEN PO_CORE_S.g_early_return_exc THEN
1441: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, d_msg);
1442: IF (PO_LOG.d_exc) THEN
1443: PO_LOG.exc(d_module, d_progress, d_msg);
1444: END IF;

Line 1529: RAISE PO_CORE_S.g_early_return_exc;

1525: IF (l_ret_sts <> 'S')
1526: THEN
1527: d_msg := 'get_range_limit_sql not successful';
1528: l_ret_sts := 'U';
1529: RAISE PO_CORE_S.g_early_return_exc;
1530: END IF;
1531:
1532: IF (PO_LOG.d_stmt) THEN
1533: PO_LOG.stmt(d_module, d_progress, 'l_sql', l_sql);

Line 1557: WHEN PO_CORE_S.g_early_return_exc THEN

1553:
1554: l_ret_sts := 'S';
1555:
1556: EXCEPTION
1557: WHEN PO_CORE_S.g_early_return_exc THEN
1558: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, d_msg);
1559: IF (PO_LOG.d_exc) THEN
1560: PO_LOG.exc(d_module, d_progress, d_msg);
1561: END IF;

Line 1646: RAISE PO_CORE_S.g_early_return_exc;

1642: IF (l_ret_sts <> 'S')
1643: THEN
1644: d_msg := 'get_range_limit_sql not successful';
1645: l_ret_sts := 'U';
1646: RAISE PO_CORE_S.g_early_return_exc;
1647: END IF;
1648:
1649: IF (PO_LOG.d_stmt) THEN
1650: PO_LOG.stmt(d_module, d_progress, 'l_sql', l_sql);

Line 1674: WHEN PO_CORE_S.g_early_return_exc THEN

1670:
1671: l_ret_sts := 'S';
1672:
1673: EXCEPTION
1674: WHEN PO_CORE_S.g_early_return_exc THEN
1675: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, d_msg);
1676: IF (PO_LOG.d_exc) THEN
1677: PO_LOG.exc(d_module, d_progress, d_msg);
1678: END IF;

Line 1787: RAISE PO_CORE_S.g_early_return_exc;

1783:
1784: d_progress := 40;
1785: l_ret_sts := 'U';
1786: d_msg := 'check type not supported';
1787: RAISE PO_CORE_S.g_early_return_exc;
1788:
1789: END IF;
1790:
1791: IF (PO_LOG.d_stmt) THEN

Line 1811: RAISE PO_CORE_S.g_early_return_exc;

1807:
1808: d_progress := 60;
1809: l_ret_sts := 'U';
1810: d_msg := 'get_flex_where_sql not successful';
1811: RAISE PO_CORE_S.g_early_return_exc;
1812:
1813: END IF;
1814:
1815: d_progress := 70;

Line 1855: WHEN PO_CORE_S.g_early_return_exc THEN

1851: d_progress := 80;
1852: l_ret_sts := 'S';
1853:
1854: EXCEPTION
1855: WHEN PO_CORE_S.g_early_return_exc THEN
1856: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, d_msg);
1857: IF (PO_LOG.d_exc) THEN
1858: PO_LOG.exc(d_module, d_progress, d_msg);
1859: END IF;

Line 1935: RAISE PO_CORE_S.g_early_return_exc;

1931:
1932: d_progress := 20;
1933: l_ret_sts := 'U';
1934: d_msg := 'check type not supported';
1935: RAISE PO_CORE_S.g_early_return_exc;
1936:
1937: END IF;
1938:
1939: IF (PO_LOG.d_stmt) THEN

Line 1958: RAISE PO_CORE_S.g_early_return_exc;

1954:
1955: d_progress := 40;
1956: l_ret_sts := 'U';
1957: d_msg := 'get_flex_where_sql not successful';
1958: RAISE PO_CORE_S.g_early_return_exc;
1959:
1960: END IF;
1961:
1962: d_progress := 50;

Line 2003: WHEN PO_CORE_S.g_early_return_exc THEN

1999: d_progress := 60;
2000: l_ret_sts := 'S';
2001:
2002: EXCEPTION
2003: WHEN PO_CORE_S.g_early_return_exc THEN
2004: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, d_msg);
2005: IF (PO_LOG.d_exc) THEN
2006: PO_LOG.exc(d_module, d_progress, d_msg);
2007: END IF;

Line 2102: RAISE PO_CORE_S.g_early_return_exc;

2098: ELSE
2099:
2100: d_progress := 40;
2101: d_msg := 'check type not supported';
2102: RAISE PO_CORE_S.g_early_return_exc;
2103:
2104: END IF; -- p_check_type = ...
2105:
2106: IF (PO_LOG.d_stmt) THEN

Line 2402: RAISE PO_CORE_S.g_early_return_exc;

2398:
2399: ELSE
2400:
2401: d_progress := 70;
2402: RAISE PO_CORE_S.g_early_return_exc;
2403:
2404: END IF; -- p_document_type
2405:
2406: x_return_status := 'S';