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 497: WHEN PO_CORE_S.g_early_return_exc THEN

493: p_action_ctl_rec.return_code := NULL;
494: l_ret_sts := 'S';
495:
496: EXCEPTION
497: WHEN PO_CORE_S.g_early_return_exc THEN
498: IF (l_ret_sts = 'S') THEN
499: IF (PO_LOG.d_stmt) THEN
500: PO_LOG.stmt(d_module, d_progress, d_msg);
501: END IF;

Line 626: RAISE PO_CORE_S.g_early_return_exc;

622: THEN
623: d_progress := 7;
624: l_ret_sts := 'S';
625: d_msg := 'do nothing for a PA';
626: RAISE PO_CORE_S.g_early_return_exc;
627: END IF;
628:
629: d_progress := 10;
630:

Line 638: RAISE PO_CORE_S.g_early_return_exc;

634: THEN
635: d_progress := 20;
636: l_ret_sts := 'U';
637: d_msg := 'user id not found';
638: RAISE PO_CORE_S.g_early_return_exc;
639: END IF;
640:
641: d_progress := 30;
642:

Line 675: RAISE PO_CORE_S.g_early_return_exc;

671: THEN
672: d_progress := 60;
673: l_ret_sts := 'U';
674: d_msg := 'get_employee_id not successful';
675: RAISE PO_CORE_S.g_early_return_exc;
676: END IF;
677:
678: IF (NOT l_emp_flag)
679: THEN

Line 705: RAISE PO_CORE_S.g_early_return_exc;

701: THEN
702: d_progress := 90;
703: l_ret_sts := 'U';
704: d_msg := 'auto_close_state_check not successful';
705: RAISE PO_CORE_S.g_early_return_exc;
706: END IF;
707:
708: IF (NOT l_state_check_ok)
709: THEN

Line 714: RAISE PO_CORE_S.g_early_return_exc;

710: d_progress := 100;
711: l_ret_sts := 'S';
712: d_msg := 'document state is not valid for action';
713: p_action_ctl_rec.return_code := 'STATE_FAILED';
714: RAISE PO_CORE_S.g_early_return_exc;
715: END IF;
716:
717: d_progress := 110;
718: IF (PO_LOG.d_stmt) THEN

Line 740: RAISE PO_CORE_S.g_early_return_exc;

736: THEN
737: d_progress := 120;
738: l_ret_sts := 'U';
739: d_msg := 'unexpected error in updating closed status';
740: RAISE PO_CORE_S.g_early_return_exc;
741: END IF;
742:
743: d_progress := 130;
744:

Line 766: RAISE PO_CORE_S.g_early_return_exc;

762: THEN
763: d_progress := 140;
764: l_ret_sts := 'U';
765: d_msg := 'unexpected error in rolling up closed status';
766: RAISE PO_CORE_S.g_early_return_exc;
767: END IF;
768:
769:
770: IF (p_action_ctl_rec.calling_mode <> 'AP')

Line 788: RAISE PO_CORE_S.g_early_return_exc;

784: THEN
785: d_progress := 160;
786: l_ret_sts := 'U';
787: d_msg := 'unexpected error in handling mtl supply';
788: RAISE PO_CORE_S.g_early_return_exc;
789: END IF;
790:
791: END IF; -- if p_action_ctl_rec.calling_mode <> 'AP'
792:

Line 797: WHEN PO_CORE_S.g_early_return_exc THEN

793: p_action_ctl_rec.return_code := NULL;
794: l_ret_sts := 'S';
795:
796: EXCEPTION
797: WHEN PO_CORE_S.g_early_return_exc THEN
798: IF (l_ret_sts = 'S') THEN
799: IF (PO_LOG.d_stmt) THEN
800: PO_LOG.stmt(d_module, d_progress, d_msg);
801: END IF;

Line 977: RAISE PO_CORE_S.g_early_return_exc;

973: d_progress := 30;
974: l_ret_sts := 'S';
975: d_msg := 'line is finally closed for this shipment';
976: l_ret_val := FALSE;
977: RAISE PO_CORE_S.g_early_return_exc;
978: END IF;
979:
980: END IF; -- p_calling_mode = 'AP' AND p_action = 'INVOICE OPEN'
981:

Line 1053: RAISE PO_CORE_S.g_early_return_exc;

1049:
1050: d_progress := 50;
1051: l_ret_sts := 'U';
1052: d_msg := 'unsupported close action';
1053: RAISE PO_CORE_S.g_early_return_exc;
1054:
1055: END IF; -- p_action = ...
1056:
1057: d_progress := 60;

Line 1073: RAISE PO_CORE_S.g_early_return_exc;

1069: THEN
1070: d_progress := 70;
1071: l_ret_sts := 'U';
1072: d_msg := 'check_doc_state not successful';
1073: RAISE PO_CORE_S.g_early_return_exc;
1074: END IF;
1075:
1076: d_progress := 80;
1077: l_ret_val := l_state_check_ok;

Line 1081: WHEN PO_CORE_S.g_early_return_exc THEN

1077: l_ret_val := l_state_check_ok;
1078: l_ret_sts := 'S';
1079:
1080: EXCEPTION
1081: WHEN PO_CORE_S.g_early_return_exc THEN
1082: IF (l_ret_sts = 'S') THEN
1083: IF (PO_LOG.d_stmt) THEN
1084: PO_LOG.stmt(d_module, d_progress, d_msg);
1085: END IF;

Line 1234: RAISE PO_CORE_S.g_early_return_exc;

1230: THEN
1231: d_progress := 30;
1232: l_ret_sts := 'U';
1233: d_msg := 'check_doc_state not successful';
1234: RAISE PO_CORE_S.g_early_return_exc;
1235: END IF;
1236:
1237: d_progress := 40;
1238: l_ret_val := l_state_check_ok;

Line 1242: WHEN PO_CORE_S.g_early_return_exc THEN

1238: l_ret_val := l_state_check_ok;
1239: l_ret_sts := 'S';
1240:
1241: EXCEPTION
1242: WHEN PO_CORE_S.g_early_return_exc THEN
1243: IF (l_ret_sts = 'S') THEN
1244: IF (PO_LOG.d_stmt) THEN
1245: PO_LOG.stmt(d_module, d_progress, d_msg);
1246: END IF;

Line 1392: RAISE PO_CORE_S.g_early_return_exc;

1388: x_online_report_id := NULL;
1389: l_ret_sts := 'S';
1390: l_ret_val := TRUE;
1391: d_msg := 'No submission checks needed.';
1392: RAISE PO_CORE_S.g_early_return_exc;
1393:
1394: END IF;
1395:
1396: d_progress := 100;

Line 1447: RAISE PO_CORE_S.g_early_return_exc;

1443: THEN
1444: d_progress := 120;
1445: l_ret_sts := 'U';
1446: d_msg := 'unexpected error in po_submission_check';
1447: RAISE PO_CORE_S.g_early_return_exc;
1448: END IF;
1449:
1450: IF (l_sub_check_sts <> FND_API.G_RET_STS_SUCCESS)
1451: THEN

Line 1456: RAISE PO_CORE_S.g_early_return_exc;

1452: d_progress := 130;
1453: l_ret_sts := 'S';
1454: l_ret_val := FALSE;
1455: d_msg := 'submission check failed';
1456: RAISE PO_CORE_S.g_early_return_exc;
1457: END IF;
1458:
1459: d_progress := 140;
1460:

Line 1482: RAISE PO_CORE_S.g_early_return_exc;

1478: THEN
1479: d_progress := 160;
1480: l_ret_sts := 'U';
1481: d_msg := 'unexpected error in chk_drop_ship';
1482: RAISE PO_CORE_S.g_early_return_exc;
1483: END IF;
1484:
1485: IF (l_dropship_chk_retcode = 'SUBMISSION_FAILED')
1486: THEN

Line 1491: RAISE PO_CORE_S.g_early_return_exc;

1487: d_progress := 170;
1488: l_ret_sts := 'S';
1489: l_ret_val := FALSE;
1490: d_msg := 'dropship check failed';
1491: RAISE PO_CORE_S.g_early_return_exc;
1492: END IF;
1493:
1494: END IF; -- if p_document_type = 'RELEASE' ...
1495:

Line 1502: WHEN PO_CORE_S.g_early_return_exc THEN

1498: l_ret_sts := 'S';
1499: l_ret_val := TRUE;
1500:
1501: EXCEPTION
1502: WHEN PO_CORE_S.g_early_return_exc THEN
1503: IF (l_ret_sts = 'S') THEN
1504: IF (PO_LOG.d_stmt) THEN
1505: PO_LOG.stmt(d_module, d_progress, d_msg);
1506: END IF;

Line 1658: l_enc_flag := PO_CORE_S.is_encumbrance_on(

1654: BEGIN
1655:
1656: d_progress := 10;
1657:
1658: l_enc_flag := PO_CORE_S.is_encumbrance_on(
1659: p_doc_type => p_document_type
1660: , p_org_id => NULL
1661: );
1662:

Line 1719: RAISE PO_CORE_S.g_early_return_exc;

1715: d_msg := 'encumbrance action not required';
1716: x_return_code := NULL;
1717: x_online_report_id := NULL;
1718: l_ret_sts := 'S';
1719: RAISE PO_CORE_S.g_early_return_exc;
1720: END IF;
1721:
1722: d_progress := 80;
1723:

Line 1790: RAISE PO_CORE_S.g_early_return_exc;

1786:
1787: d_progress := 110;
1788: l_ret_sts := 'U';
1789: d_msg := 'unexpected error in encumbrance action';
1790: RAISE PO_CORE_S.g_early_return_exc;
1791:
1792: END IF;
1793:
1794: d_progress := 120;

Line 1836: RAISE PO_CORE_S.g_early_return_exc;

1832:
1833: d_progress := 160;
1834: l_ret_sts := 'U';
1835: d_msg := 'Bad return code from encumbrance call';
1836: RAISE PO_CORE_S.g_early_return_exc;
1837:
1838: END IF; -- if l_enc_ret_code IN (...)
1839:
1840: IF (PO_LOG.d_stmt) THEN

Line 1847: WHEN PO_CORE_S.g_early_return_exc THEN

1843:
1844: l_ret_sts := 'S';
1845:
1846: EXCEPTION
1847: WHEN PO_CORE_S.g_early_return_exc THEN
1848: IF (l_ret_sts = 'S') THEN
1849: IF (PO_LOG.d_stmt) THEN
1850: PO_LOG.stmt(d_module, d_progress, d_msg);
1851: END IF;