DBA Data[Home] [Help]

APPS.PO_DOCUMENT_ACTION_CLOSE dependencies on PO_CORE_S

Line 222: RAISE PO_CORE_S.g_early_return_exc;

218: THEN
219: d_progress := 20;
220: l_ret_sts := 'U';
221: d_msg := 'user id not found';
222: RAISE PO_CORE_S.g_early_return_exc;
223: END IF;
224:
225: d_progress := 30;
226:

Line 257: RAISE PO_CORE_S.g_early_return_exc;

253: THEN
254: d_progress := 60;
255: l_ret_sts := 'U';
256: d_msg := 'get_employee_id not successful';
257: RAISE PO_CORE_S.g_early_return_exc;
258: END IF;
259:
260: IF (NOT l_emp_flag)
261: THEN

Line 267: -- RAISE PO_CORE_S.g_early_return_exc;

263: -- See Bug 236640; in Pro*C, we just set to NULL
264: -- commenting out exception raising
265: -- l_ret_sts := 'U';
266: -- d_msg := 'user is not an employee';
267: -- RAISE PO_CORE_S.g_early_return_exc;
268:
269: d_progress := 70;
270: l_emp_id := NULL;
271:

Line 295: RAISE PO_CORE_S.g_early_return_exc;

291: THEN
292: d_progress := 90;
293: l_ret_sts := 'U';
294: d_msg := 'manual_close_state_check not successful';
295: RAISE PO_CORE_S.g_early_return_exc;
296: END IF;
297:
298: IF (NOT l_state_check_ok)
299: THEN

Line 304: RAISE PO_CORE_S.g_early_return_exc;

300: d_progress := 100;
301: l_ret_sts := 'S';
302: d_msg := 'document state is not valid for action';
303: p_action_ctl_rec.return_code := 'STATE_FAILED';
304: RAISE PO_CORE_S.g_early_return_exc;
305: END IF;
306:
307: d_progress := 110;
308: IF (PO_LOG.d_stmt) THEN

Line 330: RAISE PO_CORE_S.g_early_return_exc;

326: THEN
327: d_progress := 120;
328: l_ret_sts := 'U';
329: d_msg := 'manual_close_submission_check not successful';
330: RAISE PO_CORE_S.g_early_return_exc;
331: END IF;
332:
333: IF (NOT l_sub_check_ok)
334: THEN

Line 339: RAISE PO_CORE_S.g_early_return_exc;

335: d_progress := 130;
336: l_ret_sts := 'S';
337: d_msg := 'document submission check failed';
338: p_action_ctl_rec.return_code := 'SUBMISSION_FAILED';
339: RAISE PO_CORE_S.g_early_return_exc;
340: END IF;
341:
342: d_progress := 140;
343: IF (PO_LOG.d_stmt) THEN

Line 399: RAISE PO_CORE_S.g_early_return_exc;

395: THEN
396: d_progress := 230;
397: l_ret_sts := 'U';
398: d_msg := 'unexpected error in handle_close_encumbrance';
399: RAISE PO_CORE_S.g_early_return_exc;
400: END IF;
401:
402: IF (l_ret_code IS NOT NULL)
403: THEN

Line 408: RAISE PO_CORE_S.g_early_return_exc;

404: d_progress := 240;
405: l_ret_sts := 'S';
406: p_action_ctl_rec.return_code := l_ret_code;
407: d_msg := 'encumbrance handling not fully successful';
408: RAISE PO_CORE_S.g_early_return_exc;
409: END IF;
410:
411: END IF; -- if p_action = FINALLY CLOSE or ...
412:

Line 436: RAISE PO_CORE_S.g_early_return_exc;

432: THEN
433: d_progress := 260;
434: l_ret_sts := 'U';
435: d_msg := 'unexpected error in updating closed status';
436: RAISE PO_CORE_S.g_early_return_exc;
437: END IF;
438:
439: d_progress := 270;
440:

Line 462: RAISE PO_CORE_S.g_early_return_exc;

458: THEN
459: d_progress := 280;
460: l_ret_sts := 'U';
461: d_msg := 'unexpected error in rolling up closed status';
462: RAISE PO_CORE_S.g_early_return_exc;
463: END IF;
464:
465: d_progress := 290;
466:

Line 488: RAISE PO_CORE_S.g_early_return_exc;

484: THEN
485: d_progress := 310;
486: l_ret_sts := 'U';
487: d_msg := 'unexpected error in handling mtl supply';
488: RAISE PO_CORE_S.g_early_return_exc;
489: END IF;
490:
491: END IF; -- p_document_type <> 'PA' and ...
492:

Line 513: RAISE PO_CORE_S.g_early_return_exc;

509: EXCEPTION
510: WHEN OTHERS THEN
511: l_ret_sts := 'U';
512: d_msg := 'unexpected error while call to ICX_CAT_INTERMEDIA_INDEX_PVT.rebuild_index';
513: RAISE PO_CORE_S.g_early_return_exc;
514: END;
515:
516: END IF;
517: --Bug10212404

Line 557: WHEN PO_CORE_S.g_early_return_exc THEN

553: p_action_ctl_rec.return_code := NULL;
554: l_ret_sts := 'S';
555:
556: EXCEPTION
557: WHEN PO_CORE_S.g_early_return_exc THEN
558: IF (l_ret_sts = 'S') THEN
559: IF (PO_LOG.d_stmt) THEN
560: PO_LOG.stmt(d_module, d_progress, d_msg);
561: END IF;

Line 688: RAISE PO_CORE_S.g_early_return_exc;

684: THEN
685: d_progress := 7;
686: l_ret_sts := 'S';
687: d_msg := 'do nothing for a PA';
688: RAISE PO_CORE_S.g_early_return_exc;
689: END IF;
690:
691: d_progress := 10;
692:

Line 700: RAISE PO_CORE_S.g_early_return_exc;

696: THEN
697: d_progress := 20;
698: l_ret_sts := 'U';
699: d_msg := 'user id not found';
700: RAISE PO_CORE_S.g_early_return_exc;
701: END IF;
702:
703: d_progress := 30;
704:

Line 737: RAISE PO_CORE_S.g_early_return_exc;

733: THEN
734: d_progress := 60;
735: l_ret_sts := 'U';
736: d_msg := 'get_employee_id not successful';
737: RAISE PO_CORE_S.g_early_return_exc;
738: END IF;
739:
740: IF (NOT l_emp_flag)
741: THEN

Line 767: RAISE PO_CORE_S.g_early_return_exc;

763: THEN
764: d_progress := 90;
765: l_ret_sts := 'U';
766: d_msg := 'auto_close_state_check not successful';
767: RAISE PO_CORE_S.g_early_return_exc;
768: END IF;
769:
770: IF (NOT l_state_check_ok)
771: THEN

Line 776: RAISE PO_CORE_S.g_early_return_exc;

772: d_progress := 100;
773: l_ret_sts := 'S';
774: d_msg := 'document state is not valid for action';
775: p_action_ctl_rec.return_code := 'STATE_FAILED';
776: RAISE PO_CORE_S.g_early_return_exc;
777: END IF;
778:
779: d_progress := 110;
780: IF (PO_LOG.d_stmt) THEN

Line 802: RAISE PO_CORE_S.g_early_return_exc;

798: THEN
799: d_progress := 120;
800: l_ret_sts := 'U';
801: d_msg := 'unexpected error in updating closed status';
802: RAISE PO_CORE_S.g_early_return_exc;
803: END IF;
804:
805: d_progress := 130;
806:

Line 828: RAISE PO_CORE_S.g_early_return_exc;

824: THEN
825: d_progress := 140;
826: l_ret_sts := 'U';
827: d_msg := 'unexpected error in rolling up closed status';
828: RAISE PO_CORE_S.g_early_return_exc;
829: END IF;
830:
831:
832: IF (p_action_ctl_rec.calling_mode <> 'AP')

Line 850: RAISE PO_CORE_S.g_early_return_exc;

846: THEN
847: d_progress := 160;
848: l_ret_sts := 'U';
849: d_msg := 'unexpected error in handling mtl supply';
850: RAISE PO_CORE_S.g_early_return_exc;
851: END IF;
852:
853: END IF; -- if p_action_ctl_rec.calling_mode <> 'AP'
854:

Line 874: WHEN PO_CORE_S.g_early_return_exc THEN

870: p_action_ctl_rec.return_code := NULL;
871: l_ret_sts := 'S';
872:
873: EXCEPTION
874: WHEN PO_CORE_S.g_early_return_exc THEN
875: IF (l_ret_sts = 'S') THEN
876: IF (PO_LOG.d_stmt) THEN
877: PO_LOG.stmt(d_module, d_progress, d_msg);
878: END IF;

Line 1054: RAISE PO_CORE_S.g_early_return_exc;

1050: d_progress := 30;
1051: l_ret_sts := 'S';
1052: d_msg := 'line is finally closed for this shipment';
1053: l_ret_val := FALSE;
1054: RAISE PO_CORE_S.g_early_return_exc;
1055: END IF;
1056:
1057: END IF; -- p_calling_mode = 'AP' AND p_action = 'INVOICE OPEN'
1058:

Line 1130: RAISE PO_CORE_S.g_early_return_exc;

1126:
1127: d_progress := 50;
1128: l_ret_sts := 'U';
1129: d_msg := 'unsupported close action';
1130: RAISE PO_CORE_S.g_early_return_exc;
1131:
1132: END IF; -- p_action = ...
1133:
1134: d_progress := 60;

Line 1150: RAISE PO_CORE_S.g_early_return_exc;

1146: THEN
1147: d_progress := 70;
1148: l_ret_sts := 'U';
1149: d_msg := 'check_doc_state not successful';
1150: RAISE PO_CORE_S.g_early_return_exc;
1151: END IF;
1152:
1153: d_progress := 80;
1154: l_ret_val := l_state_check_ok;

Line 1158: WHEN PO_CORE_S.g_early_return_exc THEN

1154: l_ret_val := l_state_check_ok;
1155: l_ret_sts := 'S';
1156:
1157: EXCEPTION
1158: WHEN PO_CORE_S.g_early_return_exc THEN
1159: IF (l_ret_sts = 'S') THEN
1160: IF (PO_LOG.d_stmt) THEN
1161: PO_LOG.stmt(d_module, d_progress, d_msg);
1162: END IF;

Line 1311: RAISE PO_CORE_S.g_early_return_exc;

1307: THEN
1308: d_progress := 30;
1309: l_ret_sts := 'U';
1310: d_msg := 'check_doc_state not successful';
1311: RAISE PO_CORE_S.g_early_return_exc;
1312: END IF;
1313:
1314: d_progress := 40;
1315: l_ret_val := l_state_check_ok;

Line 1319: WHEN PO_CORE_S.g_early_return_exc THEN

1315: l_ret_val := l_state_check_ok;
1316: l_ret_sts := 'S';
1317:
1318: EXCEPTION
1319: WHEN PO_CORE_S.g_early_return_exc THEN
1320: IF (l_ret_sts = 'S') THEN
1321: IF (PO_LOG.d_stmt) THEN
1322: PO_LOG.stmt(d_module, d_progress, d_msg);
1323: END IF;

Line 1469: RAISE PO_CORE_S.g_early_return_exc;

1465: x_online_report_id := NULL;
1466: l_ret_sts := 'S';
1467: l_ret_val := TRUE;
1468: d_msg := 'No submission checks needed.';
1469: RAISE PO_CORE_S.g_early_return_exc;
1470:
1471: END IF;
1472:
1473: d_progress := 100;

Line 1524: RAISE PO_CORE_S.g_early_return_exc;

1520: THEN
1521: d_progress := 120;
1522: l_ret_sts := 'U';
1523: d_msg := 'unexpected error in po_submission_check';
1524: RAISE PO_CORE_S.g_early_return_exc;
1525: END IF;
1526:
1527: IF (l_sub_check_sts <> FND_API.G_RET_STS_SUCCESS)
1528: THEN

Line 1533: RAISE PO_CORE_S.g_early_return_exc;

1529: d_progress := 130;
1530: l_ret_sts := 'S';
1531: l_ret_val := FALSE;
1532: d_msg := 'submission check failed';
1533: RAISE PO_CORE_S.g_early_return_exc;
1534: END IF;
1535:
1536: d_progress := 140;
1537:

Line 1559: RAISE PO_CORE_S.g_early_return_exc;

1555: THEN
1556: d_progress := 160;
1557: l_ret_sts := 'U';
1558: d_msg := 'unexpected error in chk_drop_ship';
1559: RAISE PO_CORE_S.g_early_return_exc;
1560: END IF;
1561:
1562: IF (l_dropship_chk_retcode = 'SUBMISSION_FAILED')
1563: THEN

Line 1568: RAISE PO_CORE_S.g_early_return_exc;

1564: d_progress := 170;
1565: l_ret_sts := 'S';
1566: l_ret_val := FALSE;
1567: d_msg := 'dropship check failed';
1568: RAISE PO_CORE_S.g_early_return_exc;
1569: END IF;
1570:
1571: END IF; -- if p_document_type = 'RELEASE' ...
1572:

Line 1579: WHEN PO_CORE_S.g_early_return_exc THEN

1575: l_ret_sts := 'S';
1576: l_ret_val := TRUE;
1577:
1578: EXCEPTION
1579: WHEN PO_CORE_S.g_early_return_exc THEN
1580: IF (l_ret_sts = 'S') THEN
1581: IF (PO_LOG.d_stmt) THEN
1582: PO_LOG.stmt(d_module, d_progress, d_msg);
1583: END IF;

Line 1735: l_enc_flag := PO_CORE_S.is_encumbrance_on(

1731: BEGIN
1732:
1733: d_progress := 10;
1734:
1735: l_enc_flag := PO_CORE_S.is_encumbrance_on(
1736: p_doc_type => p_document_type
1737: , p_org_id => NULL
1738: );
1739:

Line 1796: RAISE PO_CORE_S.g_early_return_exc;

1792: d_msg := 'encumbrance action not required';
1793: x_return_code := NULL;
1794: x_online_report_id := NULL;
1795: l_ret_sts := 'S';
1796: RAISE PO_CORE_S.g_early_return_exc;
1797: END IF;
1798:
1799: d_progress := 80;
1800:

Line 1867: RAISE PO_CORE_S.g_early_return_exc;

1863:
1864: d_progress := 110;
1865: l_ret_sts := 'U';
1866: d_msg := 'unexpected error in encumbrance action';
1867: RAISE PO_CORE_S.g_early_return_exc;
1868:
1869: END IF;
1870:
1871: d_progress := 120;

Line 1913: RAISE PO_CORE_S.g_early_return_exc;

1909:
1910: d_progress := 160;
1911: l_ret_sts := 'U';
1912: d_msg := 'Bad return code from encumbrance call';
1913: RAISE PO_CORE_S.g_early_return_exc;
1914:
1915: END IF; -- if l_enc_ret_code IN (...)
1916:
1917: IF (PO_LOG.d_stmt) THEN

Line 1924: WHEN PO_CORE_S.g_early_return_exc THEN

1920:
1921: l_ret_sts := 'S';
1922:
1923: EXCEPTION
1924: WHEN PO_CORE_S.g_early_return_exc THEN
1925: IF (l_ret_sts = 'S') THEN
1926: IF (PO_LOG.d_stmt) THEN
1927: PO_LOG.stmt(d_module, d_progress, d_msg);
1928: END IF;