eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_DOCUMENT_ACTION_UTIL dependencies on PO_DOCUMENT_ACTION_PVT

Line 263: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, 'Bad Document Type');

259: ELSE
260:
261: d_progress := 140;
262: l_ret_sts := 'U';
263: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, 'Bad Document Type');
264: IF (PO_LOG.d_exc) THEN
265: PO_LOG.exc(d_module, d_progress, 'Bad Document Type');
266: END IF;
267: RAISE PO_CORE_S.g_early_return_exc;

Line 471: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);

467: END IF;
468:
469: x_return_status := 'U';
470:
471: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);
472: IF (PO_LOG.d_exc) THEN
473: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
474: PO_LOG.proc_end(d_module, 'x_return_status', x_return_status);
475: PO_LOG.proc_return(d_module, l_ret_val);

Line 558: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, 'Bad Document Type');

554:
555: l_ret_sts := 'U';
556:
557: d_progress := 80;
558: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, 'Bad Document Type');
559: IF (PO_LOG.d_exc) THEN
560: PO_LOG.exc(d_module, d_progress, 'Bad Document Type');
561: END IF;
562:

Line 581: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);

577:
578: WHEN OTHERS THEN
579: x_return_status := 'U';
580:
581: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);
582: IF (PO_LOG.d_exc) THEN
583: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
584: PO_LOG.proc_end(d_module, 'x_return_status', x_return_status);
585: PO_LOG.proc_end(d_module);

Line 725: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);

721: EXCEPTION
722: WHEN OTHERS THEN
723: x_return_status := 'U';
724:
725: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);
726: IF (PO_LOG.d_exc) THEN
727: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
728: PO_LOG.proc_end(d_module, 'x_return_status', x_return_status);
729: PO_LOG.proc_end(d_module);

Line 795: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);

791: EXCEPTION
792: WHEN OTHERS THEN
793: x_return_status := 'U';
794:
795: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);
796: IF (PO_LOG.d_exc) THEN
797: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
798: PO_LOG.proc_end(d_module, 'x_return_status', x_return_status);
799: PO_LOG.proc_end(d_module);

Line 914: SELECT NVL(poh.authorization_status, PO_DOCUMENT_ACTION_PVT.g_doc_status_INCOMPLETE),

910: THEN
911:
912: d_progress := 60;
913:
914: SELECT NVL(poh.authorization_status, PO_DOCUMENT_ACTION_PVT.g_doc_status_INCOMPLETE),
915: poh.creation_date,
916: poh.revision_num
917: INTO l_old_status,
918: l_creation_date,

Line 928: SELECT NVL(por.authorization_status, PO_DOCUMENT_ACTION_PVT.g_doc_status_INCOMPLETE),

924: THEN
925:
926: d_progress := 70;
927:
928: SELECT NVL(por.authorization_status, PO_DOCUMENT_ACTION_PVT.g_doc_status_INCOMPLETE),
929: por.creation_date,
930: por.revision_num
931: INTO l_old_status,
932: l_creation_date,

Line 1009: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, l_err_msg);

1005:
1006: EXCEPTION
1007: WHEN PO_CORE_S.g_early_return_exc THEN
1008: l_ret_sts := 'U';
1009: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, l_err_msg);
1010: IF (PO_LOG.d_exc) THEN
1011: PO_LOG.exc(d_module, d_progress, l_err_msg);
1012: END IF;
1013:

Line 1029: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);

1025: EXCEPTION
1026: WHEN OTHERS THEN
1027: x_return_status := 'U';
1028:
1029: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);
1030: IF (PO_LOG.d_exc) THEN
1031: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
1032: PO_LOG.proc_end(d_module, 'x_return_status', x_return_status);
1033: PO_LOG.proc_end(d_module);

Line 1325: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, d_msg);

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

Line 1344: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);

1340: EXCEPTION
1341: WHEN OTHERS THEN
1342: x_return_status := 'U';
1343:
1344: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);
1345: IF (PO_LOG.d_exc) THEN
1346: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
1347: PO_LOG.proc_end(d_module, 'x_return_status', x_return_status);
1348: PO_LOG.proc_end(d_module);

Line 1403: IF (p_old_status IN (PO_DOCUMENT_ACTION_PVT.g_doc_status_RETURNED,

1399: d_progress := 10;
1400:
1401: BEGIN
1402:
1403: IF (p_old_status IN (PO_DOCUMENT_ACTION_PVT.g_doc_status_RETURNED,
1404: PO_DOCUMENT_ACTION_PVT.g_doc_status_REJECTED,
1405: PO_DOCUMENT_ACTION_PVT.g_doc_status_INCOMPLETE,
1406: PO_DOCUMENT_ACTION_PVT.g_doc_status_REAPPROVAL))
1407: THEN

Line 1404: PO_DOCUMENT_ACTION_PVT.g_doc_status_REJECTED,

1400:
1401: BEGIN
1402:
1403: IF (p_old_status IN (PO_DOCUMENT_ACTION_PVT.g_doc_status_RETURNED,
1404: PO_DOCUMENT_ACTION_PVT.g_doc_status_REJECTED,
1405: PO_DOCUMENT_ACTION_PVT.g_doc_status_INCOMPLETE,
1406: PO_DOCUMENT_ACTION_PVT.g_doc_status_REAPPROVAL))
1407: THEN
1408:

Line 1405: PO_DOCUMENT_ACTION_PVT.g_doc_status_INCOMPLETE,

1401: BEGIN
1402:
1403: IF (p_old_status IN (PO_DOCUMENT_ACTION_PVT.g_doc_status_RETURNED,
1404: PO_DOCUMENT_ACTION_PVT.g_doc_status_REJECTED,
1405: PO_DOCUMENT_ACTION_PVT.g_doc_status_INCOMPLETE,
1406: PO_DOCUMENT_ACTION_PVT.g_doc_status_REAPPROVAL))
1407: THEN
1408:
1409: insert_auth_action_history(

Line 1406: PO_DOCUMENT_ACTION_PVT.g_doc_status_REAPPROVAL))

1402:
1403: IF (p_old_status IN (PO_DOCUMENT_ACTION_PVT.g_doc_status_RETURNED,
1404: PO_DOCUMENT_ACTION_PVT.g_doc_status_REJECTED,
1405: PO_DOCUMENT_ACTION_PVT.g_doc_status_INCOMPLETE,
1406: PO_DOCUMENT_ACTION_PVT.g_doc_status_REAPPROVAL))
1407: THEN
1408:
1409: insert_auth_action_history(
1410: p_document_id => p_document_id

Line 1454: ELSIF (p_old_status IN (PO_DOCUMENT_ACTION_PVT.g_doc_status_INPROCESS,

1450: END IF;
1451:
1452: END IF; -- p_action <> 'SUBMIT'
1453:
1454: ELSIF (p_old_status IN (PO_DOCUMENT_ACTION_PVT.g_doc_status_INPROCESS,
1455: PO_DOCUMENT_ACTION_PVT.g_doc_status_PREAPPROVED))
1456: THEN
1457:
1458: update_auth_action_history(

Line 1455: PO_DOCUMENT_ACTION_PVT.g_doc_status_PREAPPROVED))

1451:
1452: END IF; -- p_action <> 'SUBMIT'
1453:
1454: ELSIF (p_old_status IN (PO_DOCUMENT_ACTION_PVT.g_doc_status_INPROCESS,
1455: PO_DOCUMENT_ACTION_PVT.g_doc_status_PREAPPROVED))
1456: THEN
1457:
1458: update_auth_action_history(
1459: p_document_id => p_document_id

Line 1474: ELSIF (p_old_status IN (PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED))

1470: IF (l_ret_sts <> 'S') THEN
1471: RAISE PO_CORE_S.g_early_return_exc;
1472: END IF;
1473:
1474: ELSIF (p_old_status IN (PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED))
1475: THEN
1476:
1477: insert_auth_action_history(
1478: p_document_id => p_document_id

Line 1525: IF ((p_old_status = PO_DOCUMENT_ACTION_PVT.g_doc_status_PREAPPROVED)

1521: IF (l_ret_sts <> 'S') THEN
1522: RAISE PO_CORE_S.g_early_return_exc;
1523: END IF;
1524:
1525: IF ((p_old_status = PO_DOCUMENT_ACTION_PVT.g_doc_status_PREAPPROVED)
1526: AND (p_action = PO_DOCUMENT_ACTION_PVT.g_doc_action_RESERVE))
1527: THEN
1528:
1529: update_auth_action_history(

Line 1526: AND (p_action = PO_DOCUMENT_ACTION_PVT.g_doc_action_RESERVE))

1522: RAISE PO_CORE_S.g_early_return_exc;
1523: END IF;
1524:
1525: IF ((p_old_status = PO_DOCUMENT_ACTION_PVT.g_doc_status_PREAPPROVED)
1526: AND (p_action = PO_DOCUMENT_ACTION_PVT.g_doc_action_RESERVE))
1527: THEN
1528:
1529: update_auth_action_history(
1530: p_document_id => p_document_id

Line 1533: , p_action => PO_DOCUMENT_ACTION_PVT.g_doc_action_APPROVE

1529: update_auth_action_history(
1530: p_document_id => p_document_id
1531: , p_revision_num => p_revision_num
1532: , p_document_type => p_document_type
1533: , p_action => PO_DOCUMENT_ACTION_PVT.g_doc_action_APPROVE
1534: , p_approval_path_id => p_approval_path_id
1535: , p_note => p_note
1536: , p_user_id => p_user_id
1537: , x_return_status => l_ret_sts

Line 1547: ELSIF ((p_old_status = PO_DOCUMENT_ACTION_PVT.g_doc_status_INPROCESS)

1543: END IF;
1544:
1545: END IF; -- p_old_status = ... and p_action =
1546:
1547: ELSIF ((p_old_status = PO_DOCUMENT_ACTION_PVT.g_doc_status_INPROCESS)
1548: AND (p_action in (PO_DOCUMENT_ACTION_PVT.g_doc_action_RESERVE,
1549: PO_DOCUMENT_ACTION_PVT.g_doc_action_UNRESERVE)))
1550: THEN
1551:

Line 1548: AND (p_action in (PO_DOCUMENT_ACTION_PVT.g_doc_action_RESERVE,

1544:
1545: END IF; -- p_old_status = ... and p_action =
1546:
1547: ELSIF ((p_old_status = PO_DOCUMENT_ACTION_PVT.g_doc_status_INPROCESS)
1548: AND (p_action in (PO_DOCUMENT_ACTION_PVT.g_doc_action_RESERVE,
1549: PO_DOCUMENT_ACTION_PVT.g_doc_action_UNRESERVE)))
1550: THEN
1551:
1552: -- bug4363736

Line 1549: PO_DOCUMENT_ACTION_PVT.g_doc_action_UNRESERVE)))

1545: END IF; -- p_old_status = ... and p_action =
1546:
1547: ELSIF ((p_old_status = PO_DOCUMENT_ACTION_PVT.g_doc_status_INPROCESS)
1548: AND (p_action in (PO_DOCUMENT_ACTION_PVT.g_doc_action_RESERVE,
1549: PO_DOCUMENT_ACTION_PVT.g_doc_action_UNRESERVE)))
1550: THEN
1551:
1552: -- bug4363736
1553: -- when inserting NULL action row, we should populate revision_num

Line 1582: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, 'Insert or update action history not successful');

1578:
1579: EXCEPTION
1580: WHEN PO_CORE_S.g_early_return_exc THEN
1581: l_ret_sts := 'U';
1582: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, 'Insert or update action history not successful');
1583: IF (PO_LOG.d_exc) THEN
1584: PO_LOG.exc(d_module, d_progress, 'Insert or update action history not successful');
1585: END IF;
1586:

Line 1602: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);

1598: EXCEPTION
1599: WHEN OTHERS THEN
1600: x_return_status := 'U';
1601:
1602: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);
1603: IF (PO_LOG.d_exc) THEN
1604: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
1605: PO_LOG.proc_end(d_module, 'x_return_status', x_return_status);
1606: PO_LOG.proc_end(d_module);

Line 1658: PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED,

1654: --Bug 5151097 : Update Approved Date when Approved
1655: UPDATE PO_REQUISITION_HEADERS porh
1656: SET porh.authorization_status = p_new_status
1657: , porh.approved_date = DECODE (p_new_status,
1658: PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED,
1659: SYSDATE,null)
1660: , porh.last_update_date = SYSDATE
1661: , porh.last_updated_by = p_user_id
1662: , porh.last_update_login = p_login_id

Line 1690: PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED, 'Y',

1686:
1687: UPDATE PO_HEADERS poh
1688: SET poh.authorization_status = p_new_status,
1689: poh.approved_flag = DECODE(p_new_status,
1690: PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED, 'Y',
1691: PO_DOCUMENT_ACTION_PVT.g_doc_status_REAPPROVAL, 'R',
1692: PO_DOCUMENT_ACTION_PVT.g_doc_status_REJECTED, 'F',
1693: PO_DOCUMENT_ACTION_PVT.g_doc_status_RETURNED, 'F',
1694: PO_DOCUMENT_ACTION_PVT.g_doc_status_INCOMPLETE, 'N',

Line 1691: PO_DOCUMENT_ACTION_PVT.g_doc_status_REAPPROVAL, 'R',

1687: UPDATE PO_HEADERS poh
1688: SET poh.authorization_status = p_new_status,
1689: poh.approved_flag = DECODE(p_new_status,
1690: PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED, 'Y',
1691: PO_DOCUMENT_ACTION_PVT.g_doc_status_REAPPROVAL, 'R',
1692: PO_DOCUMENT_ACTION_PVT.g_doc_status_REJECTED, 'F',
1693: PO_DOCUMENT_ACTION_PVT.g_doc_status_RETURNED, 'F',
1694: PO_DOCUMENT_ACTION_PVT.g_doc_status_INCOMPLETE, 'N',
1695: PO_DOCUMENT_ACTION_PVT.g_doc_status_INPROCESS, 'N',

Line 1692: PO_DOCUMENT_ACTION_PVT.g_doc_status_REJECTED, 'F',

1688: SET poh.authorization_status = p_new_status,
1689: poh.approved_flag = DECODE(p_new_status,
1690: PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED, 'Y',
1691: PO_DOCUMENT_ACTION_PVT.g_doc_status_REAPPROVAL, 'R',
1692: PO_DOCUMENT_ACTION_PVT.g_doc_status_REJECTED, 'F',
1693: PO_DOCUMENT_ACTION_PVT.g_doc_status_RETURNED, 'F',
1694: PO_DOCUMENT_ACTION_PVT.g_doc_status_INCOMPLETE, 'N',
1695: PO_DOCUMENT_ACTION_PVT.g_doc_status_INPROCESS, 'N',
1696: PO_DOCUMENT_ACTION_PVT.g_doc_status_PREAPPROVED, 'N'),

Line 1693: PO_DOCUMENT_ACTION_PVT.g_doc_status_RETURNED, 'F',

1689: poh.approved_flag = DECODE(p_new_status,
1690: PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED, 'Y',
1691: PO_DOCUMENT_ACTION_PVT.g_doc_status_REAPPROVAL, 'R',
1692: PO_DOCUMENT_ACTION_PVT.g_doc_status_REJECTED, 'F',
1693: PO_DOCUMENT_ACTION_PVT.g_doc_status_RETURNED, 'F',
1694: PO_DOCUMENT_ACTION_PVT.g_doc_status_INCOMPLETE, 'N',
1695: PO_DOCUMENT_ACTION_PVT.g_doc_status_INPROCESS, 'N',
1696: PO_DOCUMENT_ACTION_PVT.g_doc_status_PREAPPROVED, 'N'),
1697: poh.approved_date = DECODE(p_new_status,

Line 1694: PO_DOCUMENT_ACTION_PVT.g_doc_status_INCOMPLETE, 'N',

1690: PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED, 'Y',
1691: PO_DOCUMENT_ACTION_PVT.g_doc_status_REAPPROVAL, 'R',
1692: PO_DOCUMENT_ACTION_PVT.g_doc_status_REJECTED, 'F',
1693: PO_DOCUMENT_ACTION_PVT.g_doc_status_RETURNED, 'F',
1694: PO_DOCUMENT_ACTION_PVT.g_doc_status_INCOMPLETE, 'N',
1695: PO_DOCUMENT_ACTION_PVT.g_doc_status_INPROCESS, 'N',
1696: PO_DOCUMENT_ACTION_PVT.g_doc_status_PREAPPROVED, 'N'),
1697: poh.approved_date = DECODE(p_new_status,
1698: PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED, SYSDATE,

Line 1695: PO_DOCUMENT_ACTION_PVT.g_doc_status_INPROCESS, 'N',

1691: PO_DOCUMENT_ACTION_PVT.g_doc_status_REAPPROVAL, 'R',
1692: PO_DOCUMENT_ACTION_PVT.g_doc_status_REJECTED, 'F',
1693: PO_DOCUMENT_ACTION_PVT.g_doc_status_RETURNED, 'F',
1694: PO_DOCUMENT_ACTION_PVT.g_doc_status_INCOMPLETE, 'N',
1695: PO_DOCUMENT_ACTION_PVT.g_doc_status_INPROCESS, 'N',
1696: PO_DOCUMENT_ACTION_PVT.g_doc_status_PREAPPROVED, 'N'),
1697: poh.approved_date = DECODE(p_new_status,
1698: PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED, SYSDATE,
1699: poh.approved_date),

Line 1696: PO_DOCUMENT_ACTION_PVT.g_doc_status_PREAPPROVED, 'N'),

1692: PO_DOCUMENT_ACTION_PVT.g_doc_status_REJECTED, 'F',
1693: PO_DOCUMENT_ACTION_PVT.g_doc_status_RETURNED, 'F',
1694: PO_DOCUMENT_ACTION_PVT.g_doc_status_INCOMPLETE, 'N',
1695: PO_DOCUMENT_ACTION_PVT.g_doc_status_INPROCESS, 'N',
1696: PO_DOCUMENT_ACTION_PVT.g_doc_status_PREAPPROVED, 'N'),
1697: poh.approved_date = DECODE(p_new_status,
1698: PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED, SYSDATE,
1699: poh.approved_date),
1700: poh.last_update_date = SYSDATE,

Line 1698: PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED, SYSDATE,

1694: PO_DOCUMENT_ACTION_PVT.g_doc_status_INCOMPLETE, 'N',
1695: PO_DOCUMENT_ACTION_PVT.g_doc_status_INPROCESS, 'N',
1696: PO_DOCUMENT_ACTION_PVT.g_doc_status_PREAPPROVED, 'N'),
1697: poh.approved_date = DECODE(p_new_status,
1698: PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED, SYSDATE,
1699: poh.approved_date),
1700: poh.last_update_date = SYSDATE,
1701: poh.last_updated_by = p_user_id,
1702: poh.last_update_login = p_login_id,

Line 1704: PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED,

1700: poh.last_update_date = SYSDATE,
1701: poh.last_updated_by = p_user_id,
1702: poh.last_update_login = p_login_id,
1703: poh.pending_signature_flag = DECODE(p_new_status,
1704: PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED,
1705: DECODE(poh.acceptance_required_flag, 'S', 'Y', 'N'),
1706: poh.pending_signature_flag)
1707: WHERE poh.po_header_id = p_document_id;
1708:

Line 1710: IF (p_new_status = PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED)

1706: poh.pending_signature_flag)
1707: WHERE poh.po_header_id = p_document_id;
1708:
1709:
1710: IF (p_new_status = PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED)
1711: THEN
1712:
1713: d_progress := 30;
1714:

Line 1766: SET poh.authorization_status = PO_DOCUMENT_ACTION_PVT.g_doc_status_PREAPPROVED

1762:
1763: d_progress := 80;
1764:
1765: UPDATE PO_HEADERS poh
1766: SET poh.authorization_status = PO_DOCUMENT_ACTION_PVT.g_doc_status_PREAPPROVED
1767: , poh.approved_flag = 'N'
1768: , poh.last_update_date = SYSDATE
1769: , poh.last_updated_by = p_user_id
1770: , poh.last_update_login = p_login_id

Line 1794: IF (p_new_status = PO_DOCUMENT_ACTION_PVT.g_doc_status_REAPPROVAL)

1790: AND NVL(poh.pending_signature_flag, 'N') <> 'Y');
1791:
1792: END IF; -- p_new_status = g_doc_status_APPROVED
1793:
1794: IF (p_new_status = PO_DOCUMENT_ACTION_PVT.g_doc_status_REAPPROVAL)
1795: THEN
1796:
1797: d_progress := 100;
1798:

Line 1818: PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED, 'Y',

1814:
1815: UPDATE PO_RELEASES por
1816: SET por.authorization_status = p_new_status,
1817: por.approved_flag = DECODE(p_new_status,
1818: PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED, 'Y',
1819: PO_DOCUMENT_ACTION_PVT.g_doc_status_REAPPROVAL, 'R',
1820: PO_DOCUMENT_ACTION_PVT.g_doc_status_REJECTED, 'F',
1821: PO_DOCUMENT_ACTION_PVT.g_doc_status_RETURNED, 'F',
1822: PO_DOCUMENT_ACTION_PVT.g_doc_status_INCOMPLETE, 'N',

Line 1819: PO_DOCUMENT_ACTION_PVT.g_doc_status_REAPPROVAL, 'R',

1815: UPDATE PO_RELEASES por
1816: SET por.authorization_status = p_new_status,
1817: por.approved_flag = DECODE(p_new_status,
1818: PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED, 'Y',
1819: PO_DOCUMENT_ACTION_PVT.g_doc_status_REAPPROVAL, 'R',
1820: PO_DOCUMENT_ACTION_PVT.g_doc_status_REJECTED, 'F',
1821: PO_DOCUMENT_ACTION_PVT.g_doc_status_RETURNED, 'F',
1822: PO_DOCUMENT_ACTION_PVT.g_doc_status_INCOMPLETE, 'N',
1823: PO_DOCUMENT_ACTION_PVT.g_doc_status_INPROCESS, 'N',

Line 1820: PO_DOCUMENT_ACTION_PVT.g_doc_status_REJECTED, 'F',

1816: SET por.authorization_status = p_new_status,
1817: por.approved_flag = DECODE(p_new_status,
1818: PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED, 'Y',
1819: PO_DOCUMENT_ACTION_PVT.g_doc_status_REAPPROVAL, 'R',
1820: PO_DOCUMENT_ACTION_PVT.g_doc_status_REJECTED, 'F',
1821: PO_DOCUMENT_ACTION_PVT.g_doc_status_RETURNED, 'F',
1822: PO_DOCUMENT_ACTION_PVT.g_doc_status_INCOMPLETE, 'N',
1823: PO_DOCUMENT_ACTION_PVT.g_doc_status_INPROCESS, 'N',
1824: PO_DOCUMENT_ACTION_PVT.g_doc_status_PREAPPROVED, 'N'),

Line 1821: PO_DOCUMENT_ACTION_PVT.g_doc_status_RETURNED, 'F',

1817: por.approved_flag = DECODE(p_new_status,
1818: PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED, 'Y',
1819: PO_DOCUMENT_ACTION_PVT.g_doc_status_REAPPROVAL, 'R',
1820: PO_DOCUMENT_ACTION_PVT.g_doc_status_REJECTED, 'F',
1821: PO_DOCUMENT_ACTION_PVT.g_doc_status_RETURNED, 'F',
1822: PO_DOCUMENT_ACTION_PVT.g_doc_status_INCOMPLETE, 'N',
1823: PO_DOCUMENT_ACTION_PVT.g_doc_status_INPROCESS, 'N',
1824: PO_DOCUMENT_ACTION_PVT.g_doc_status_PREAPPROVED, 'N'),
1825: por.approved_date = DECODE(p_new_status,

Line 1822: PO_DOCUMENT_ACTION_PVT.g_doc_status_INCOMPLETE, 'N',

1818: PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED, 'Y',
1819: PO_DOCUMENT_ACTION_PVT.g_doc_status_REAPPROVAL, 'R',
1820: PO_DOCUMENT_ACTION_PVT.g_doc_status_REJECTED, 'F',
1821: PO_DOCUMENT_ACTION_PVT.g_doc_status_RETURNED, 'F',
1822: PO_DOCUMENT_ACTION_PVT.g_doc_status_INCOMPLETE, 'N',
1823: PO_DOCUMENT_ACTION_PVT.g_doc_status_INPROCESS, 'N',
1824: PO_DOCUMENT_ACTION_PVT.g_doc_status_PREAPPROVED, 'N'),
1825: por.approved_date = DECODE(p_new_status,
1826: PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED, SYSDATE,

Line 1823: PO_DOCUMENT_ACTION_PVT.g_doc_status_INPROCESS, 'N',

1819: PO_DOCUMENT_ACTION_PVT.g_doc_status_REAPPROVAL, 'R',
1820: PO_DOCUMENT_ACTION_PVT.g_doc_status_REJECTED, 'F',
1821: PO_DOCUMENT_ACTION_PVT.g_doc_status_RETURNED, 'F',
1822: PO_DOCUMENT_ACTION_PVT.g_doc_status_INCOMPLETE, 'N',
1823: PO_DOCUMENT_ACTION_PVT.g_doc_status_INPROCESS, 'N',
1824: PO_DOCUMENT_ACTION_PVT.g_doc_status_PREAPPROVED, 'N'),
1825: por.approved_date = DECODE(p_new_status,
1826: PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED, SYSDATE,
1827: por.approved_date),

Line 1824: PO_DOCUMENT_ACTION_PVT.g_doc_status_PREAPPROVED, 'N'),

1820: PO_DOCUMENT_ACTION_PVT.g_doc_status_REJECTED, 'F',
1821: PO_DOCUMENT_ACTION_PVT.g_doc_status_RETURNED, 'F',
1822: PO_DOCUMENT_ACTION_PVT.g_doc_status_INCOMPLETE, 'N',
1823: PO_DOCUMENT_ACTION_PVT.g_doc_status_INPROCESS, 'N',
1824: PO_DOCUMENT_ACTION_PVT.g_doc_status_PREAPPROVED, 'N'),
1825: por.approved_date = DECODE(p_new_status,
1826: PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED, SYSDATE,
1827: por.approved_date),
1828: por.last_update_date = SYSDATE,

Line 1826: PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED, SYSDATE,

1822: PO_DOCUMENT_ACTION_PVT.g_doc_status_INCOMPLETE, 'N',
1823: PO_DOCUMENT_ACTION_PVT.g_doc_status_INPROCESS, 'N',
1824: PO_DOCUMENT_ACTION_PVT.g_doc_status_PREAPPROVED, 'N'),
1825: por.approved_date = DECODE(p_new_status,
1826: PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED, SYSDATE,
1827: por.approved_date),
1828: por.last_update_date = SYSDATE,
1829: por.last_updated_by = p_user_id,
1830: por.last_update_login = p_login_id

Line 1833: IF (p_new_status = PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED)

1829: por.last_updated_by = p_user_id,
1830: por.last_update_login = p_login_id
1831: WHERE por.po_release_id = p_document_id;
1832:
1833: IF (p_new_status = PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED)
1834: THEN
1835:
1836: d_progress := 120;
1837:

Line 1849: IF (p_new_status = PO_DOCUMENT_ACTION_PVT.g_doc_status_REAPPROVAL)

1845: AND NVL(poll.approved_flag, 'N') <> 'Y';
1846:
1847: END IF; -- p_new_status = g_doc_status_APPROVED
1848:
1849: IF (p_new_status = PO_DOCUMENT_ACTION_PVT.g_doc_status_REAPPROVAL)
1850: THEN
1851:
1852: d_progress := 130;
1853:

Line 1878: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, l_err_msg);

1874:
1875: EXCEPTION
1876: WHEN PO_CORE_S.g_early_return_exc THEN
1877: l_ret_sts := 'U';
1878: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, l_err_msg);
1879: IF (PO_LOG.d_exc) THEN
1880: PO_LOG.exc(d_module, d_progress, l_err_msg);
1881: END IF;
1882: END;

Line 1898: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);

1894: EXCEPTION
1895: WHEN OTHERS THEN
1896: x_return_status := 'U';
1897:
1898: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);
1899: IF (PO_LOG.d_exc) THEN
1900: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
1901: PO_LOG.proc_end(d_module, 'x_return_status', x_return_status);
1902: PO_LOG.proc_end(d_module);

Line 2002: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);

1998: EXCEPTION
1999: WHEN OTHERS THEN
2000: x_return_status := 'U';
2001:
2002: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);
2003: IF (PO_LOG.d_exc) THEN
2004: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
2005: PO_LOG.proc_end(d_module, 'x_return_status', x_return_status);
2006: PO_LOG.proc_end(d_module);

Line 2138: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);

2134: EXCEPTION
2135: WHEN OTHERS THEN
2136: x_return_status := 'U';
2137:
2138: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);
2139: IF (PO_LOG.d_exc) THEN
2140: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
2141: PO_LOG.proc_end(d_module, 'x_return_status', x_return_status);
2142: PO_LOG.proc_end(d_module);

Line 2205: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);

2201: EXCEPTION
2202: WHEN OTHERS THEN
2203: x_return_status := 'U';
2204:
2205: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);
2206: IF (PO_LOG.d_exc) THEN
2207: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
2208: PO_LOG.proc_end(d_module, 'x_return_status', x_return_status);
2209: PO_LOG.proc_end(d_module);