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 332: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, 'Bad Document Type');

328: ELSE
329:
330: d_progress := 140;
331: l_ret_sts := 'U';
332: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, 'Bad Document Type');
333: IF (PO_LOG.d_exc) THEN
334: PO_LOG.exc(d_module, d_progress, 'Bad Document Type');
335: END IF;
336: RAISE PO_CORE_S.g_early_return_exc;

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

550: END IF;
551:
552: x_return_status := 'U';
553:
554: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);
555: IF (PO_LOG.d_exc) THEN
556: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
557: PO_LOG.proc_end(d_module, 'x_return_status', x_return_status);
558: PO_LOG.proc_return(d_module, l_ret_val);

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

679:
680: l_ret_sts := 'U';
681:
682: d_progress := 80;
683: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, 'Bad Document Type');
684: IF (PO_LOG.d_exc) THEN
685: PO_LOG.exc(d_module, d_progress, 'Bad Document Type');
686: END IF;
687:

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

702:
703: WHEN OTHERS THEN
704: x_return_status := 'U';
705:
706: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);
707: IF (PO_LOG.d_exc) THEN
708: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
709: PO_LOG.proc_end(d_module, 'x_return_status', x_return_status);
710: PO_LOG.proc_end(d_module);

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

846: EXCEPTION
847: WHEN OTHERS THEN
848: x_return_status := 'U';
849:
850: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);
851: IF (PO_LOG.d_exc) THEN
852: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
853: PO_LOG.proc_end(d_module, 'x_return_status', x_return_status);
854: PO_LOG.proc_end(d_module);

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

916: EXCEPTION
917: WHEN OTHERS THEN
918: x_return_status := 'U';
919:
920: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);
921: IF (PO_LOG.d_exc) THEN
922: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
923: PO_LOG.proc_end(d_module, 'x_return_status', x_return_status);
924: PO_LOG.proc_end(d_module);

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

1084: WHERE poh.po_header_id = p_document_id
1085: AND poh.draft_id = p_draft_id;
1086:
1087: ELSE
1088: SELECT NVL(poh.authorization_status, PO_DOCUMENT_ACTION_PVT.g_doc_status_INCOMPLETE),
1089: poh.creation_date,
1090: poh.revision_num
1091: INTO l_old_status,
1092: l_creation_date,

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

1100: THEN
1101:
1102: d_progress := 70;
1103:
1104: SELECT NVL(por.authorization_status, PO_DOCUMENT_ACTION_PVT.g_doc_status_INCOMPLETE),
1105: por.creation_date,
1106: por.revision_num
1107: INTO l_old_status,
1108: l_creation_date,

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

1183:
1184: EXCEPTION
1185: WHEN PO_CORE_S.g_early_return_exc THEN
1186: l_ret_sts := 'U';
1187: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, l_err_msg);
1188: IF (PO_LOG.d_exc) THEN
1189: PO_LOG.exc(d_module, d_progress, l_err_msg);
1190: END IF;
1191:

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

1203: EXCEPTION
1204: WHEN OTHERS THEN
1205: x_return_status := 'U';
1206:
1207: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);
1208: IF (PO_LOG.d_exc) THEN
1209: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
1210: PO_LOG.proc_end(d_module, 'x_return_status', x_return_status);
1211: PO_LOG.proc_end(d_module);

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

1499:
1500: EXCEPTION
1501: WHEN PO_CORE_S.g_early_return_exc THEN
1502: l_ret_sts := 'U';
1503: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, d_msg);
1504: IF (PO_LOG.d_exc) THEN
1505: PO_LOG.exc(d_module, d_progress, d_msg);
1506: END IF;
1507: END;

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

1518: EXCEPTION
1519: WHEN OTHERS THEN
1520: x_return_status := 'U';
1521:
1522: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);
1523: IF (PO_LOG.d_exc) THEN
1524: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
1525: PO_LOG.proc_end(d_module, 'x_return_status', x_return_status);
1526: PO_LOG.proc_end(d_module);

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

1579: d_progress := 10;
1580:
1581: BEGIN
1582:
1583: IF (p_old_status IN (PO_DOCUMENT_ACTION_PVT.g_doc_status_RETURNED,
1584: PO_DOCUMENT_ACTION_PVT.g_doc_status_REJECTED,
1585: PO_DOCUMENT_ACTION_PVT.g_doc_status_INCOMPLETE,
1586: PO_DOCUMENT_ACTION_PVT.g_doc_status_DRAFT, -- CLM apprvl
1587: PO_DOCUMENT_ACTION_PVT.g_doc_status_REAPPROVAL))

Line 1584: PO_DOCUMENT_ACTION_PVT.g_doc_status_REJECTED,

1580:
1581: BEGIN
1582:
1583: IF (p_old_status IN (PO_DOCUMENT_ACTION_PVT.g_doc_status_RETURNED,
1584: PO_DOCUMENT_ACTION_PVT.g_doc_status_REJECTED,
1585: PO_DOCUMENT_ACTION_PVT.g_doc_status_INCOMPLETE,
1586: PO_DOCUMENT_ACTION_PVT.g_doc_status_DRAFT, -- CLM apprvl
1587: PO_DOCUMENT_ACTION_PVT.g_doc_status_REAPPROVAL))
1588: THEN

Line 1585: PO_DOCUMENT_ACTION_PVT.g_doc_status_INCOMPLETE,

1581: BEGIN
1582:
1583: IF (p_old_status IN (PO_DOCUMENT_ACTION_PVT.g_doc_status_RETURNED,
1584: PO_DOCUMENT_ACTION_PVT.g_doc_status_REJECTED,
1585: PO_DOCUMENT_ACTION_PVT.g_doc_status_INCOMPLETE,
1586: PO_DOCUMENT_ACTION_PVT.g_doc_status_DRAFT, -- CLM apprvl
1587: PO_DOCUMENT_ACTION_PVT.g_doc_status_REAPPROVAL))
1588: THEN
1589:

Line 1586: PO_DOCUMENT_ACTION_PVT.g_doc_status_DRAFT, -- CLM apprvl

1582:
1583: IF (p_old_status IN (PO_DOCUMENT_ACTION_PVT.g_doc_status_RETURNED,
1584: PO_DOCUMENT_ACTION_PVT.g_doc_status_REJECTED,
1585: PO_DOCUMENT_ACTION_PVT.g_doc_status_INCOMPLETE,
1586: PO_DOCUMENT_ACTION_PVT.g_doc_status_DRAFT, -- CLM apprvl
1587: PO_DOCUMENT_ACTION_PVT.g_doc_status_REAPPROVAL))
1588: THEN
1589:
1590: insert_auth_action_history(

Line 1587: PO_DOCUMENT_ACTION_PVT.g_doc_status_REAPPROVAL))

1583: IF (p_old_status IN (PO_DOCUMENT_ACTION_PVT.g_doc_status_RETURNED,
1584: PO_DOCUMENT_ACTION_PVT.g_doc_status_REJECTED,
1585: PO_DOCUMENT_ACTION_PVT.g_doc_status_INCOMPLETE,
1586: PO_DOCUMENT_ACTION_PVT.g_doc_status_DRAFT, -- CLM apprvl
1587: PO_DOCUMENT_ACTION_PVT.g_doc_status_REAPPROVAL))
1588: THEN
1589:
1590: insert_auth_action_history(
1591: p_document_id => p_document_id

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

1633: END IF;
1634:
1635: END IF; -- p_action <> 'SUBMIT'
1636:
1637: ELSIF (p_old_status IN (PO_DOCUMENT_ACTION_PVT.g_doc_status_INPROCESS,
1638: PO_DOCUMENT_ACTION_PVT.g_doc_status_PREAPPROVED,
1639: PO_DOCUMENT_ACTION_PVT.g_doc_status_COMPLETED)) --Bug 13444730
1640: THEN
1641:

Line 1638: PO_DOCUMENT_ACTION_PVT.g_doc_status_PREAPPROVED,

1634:
1635: END IF; -- p_action <> 'SUBMIT'
1636:
1637: ELSIF (p_old_status IN (PO_DOCUMENT_ACTION_PVT.g_doc_status_INPROCESS,
1638: PO_DOCUMENT_ACTION_PVT.g_doc_status_PREAPPROVED,
1639: PO_DOCUMENT_ACTION_PVT.g_doc_status_COMPLETED)) --Bug 13444730
1640: THEN
1641:
1642: update_auth_action_history(

Line 1639: PO_DOCUMENT_ACTION_PVT.g_doc_status_COMPLETED)) --Bug 13444730

1635: END IF; -- p_action <> 'SUBMIT'
1636:
1637: ELSIF (p_old_status IN (PO_DOCUMENT_ACTION_PVT.g_doc_status_INPROCESS,
1638: PO_DOCUMENT_ACTION_PVT.g_doc_status_PREAPPROVED,
1639: PO_DOCUMENT_ACTION_PVT.g_doc_status_COMPLETED)) --Bug 13444730
1640: THEN
1641:
1642: update_auth_action_history(
1643: p_document_id => p_document_id

Line 1659: ELSIF (p_old_status IN (PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED, PO_DOCUMENT_ACTION_PVT.g_doc_status_APP_AND_PROCESSED))

1655: IF (l_ret_sts <> 'S') THEN
1656: RAISE PO_CORE_S.g_early_return_exc;
1657: END IF;
1658: -- CLM apprvl, for mods the status becomes 'completed' after approval
1659: ELSIF (p_old_status IN (PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED, PO_DOCUMENT_ACTION_PVT.g_doc_status_APP_AND_PROCESSED))
1660: THEN
1661:
1662: insert_auth_action_history(
1663: p_document_id => p_document_id

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

1708: IF (l_ret_sts <> 'S') THEN
1709: RAISE PO_CORE_S.g_early_return_exc;
1710: END IF;
1711:
1712: IF ((p_old_status = PO_DOCUMENT_ACTION_PVT.g_doc_status_PREAPPROVED)
1713: AND (p_action = PO_DOCUMENT_ACTION_PVT.g_doc_action_RESERVE))
1714: THEN
1715:
1716: update_auth_action_history(

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

1709: RAISE PO_CORE_S.g_early_return_exc;
1710: END IF;
1711:
1712: IF ((p_old_status = PO_DOCUMENT_ACTION_PVT.g_doc_status_PREAPPROVED)
1713: AND (p_action = PO_DOCUMENT_ACTION_PVT.g_doc_action_RESERVE))
1714: THEN
1715:
1716: update_auth_action_history(
1717: p_document_id => p_document_id

Line 1721: , p_action => PO_DOCUMENT_ACTION_PVT.g_doc_action_APPROVE

1717: p_document_id => p_document_id
1718: , p_revision_num => p_revision_num
1719: , p_document_type => p_document_type
1720: , p_draft_id => p_draft_id --CLM Apprvl
1721: , p_action => PO_DOCUMENT_ACTION_PVT.g_doc_action_APPROVE
1722: , p_approval_path_id => p_approval_path_id
1723: , p_note => p_note
1724: , p_user_id => p_user_id
1725: , x_return_status => l_ret_sts

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

1731: END IF;
1732:
1733: END IF; -- p_old_status = ... and p_action =
1734:
1735: ELSIF ((p_old_status = PO_DOCUMENT_ACTION_PVT.g_doc_status_INPROCESS)
1736: AND (p_action in (PO_DOCUMENT_ACTION_PVT.g_doc_action_RESERVE,
1737: PO_DOCUMENT_ACTION_PVT.g_doc_action_UNRESERVE)))
1738: THEN
1739:

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

1732:
1733: END IF; -- p_old_status = ... and p_action =
1734:
1735: ELSIF ((p_old_status = PO_DOCUMENT_ACTION_PVT.g_doc_status_INPROCESS)
1736: AND (p_action in (PO_DOCUMENT_ACTION_PVT.g_doc_action_RESERVE,
1737: PO_DOCUMENT_ACTION_PVT.g_doc_action_UNRESERVE)))
1738: THEN
1739:
1740: -- bug4363736

Line 1737: PO_DOCUMENT_ACTION_PVT.g_doc_action_UNRESERVE)))

1733: END IF; -- p_old_status = ... and p_action =
1734:
1735: ELSIF ((p_old_status = PO_DOCUMENT_ACTION_PVT.g_doc_status_INPROCESS)
1736: AND (p_action in (PO_DOCUMENT_ACTION_PVT.g_doc_action_RESERVE,
1737: PO_DOCUMENT_ACTION_PVT.g_doc_action_UNRESERVE)))
1738: THEN
1739:
1740: -- bug4363736
1741: -- when inserting NULL action row, we should populate revision_num

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

1767:
1768: EXCEPTION
1769: WHEN PO_CORE_S.g_early_return_exc THEN
1770: l_ret_sts := 'U';
1771: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, 'Insert or update action history not successful');
1772: IF (PO_LOG.d_exc) THEN
1773: PO_LOG.exc(d_module, d_progress, 'Insert or update action history not successful');
1774: END IF;
1775:

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

1787: EXCEPTION
1788: WHEN OTHERS THEN
1789: x_return_status := 'U';
1790:
1791: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);
1792: IF (PO_LOG.d_exc) THEN
1793: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
1794: PO_LOG.proc_end(d_module, 'x_return_status', x_return_status);
1795: PO_LOG.proc_end(d_module);

Line 1853: PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED,

1849: --Bug 5151097 : Update Approved Date when Approved
1850: UPDATE PO_REQUISITION_HEADERS porh
1851: SET porh.authorization_status = p_new_status
1852: , porh.approved_date = DECODE (p_new_status,
1853: PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED,
1854: SYSDATE,null)
1855: , porh.last_update_date = SYSDATE
1856: , porh.last_updated_by = p_user_id
1857: , porh.last_update_login = p_login_id

Line 1905: PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED, 'Y',

1901:
1902: /* UPDATE PO_HEADERS_DRAFT_ALL poh
1903: SET poh.authorization_status = p_new_status,
1904: poh.approved_flag = DECODE(p_new_status,
1905: PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED, 'Y',
1906: PO_DOCUMENT_ACTION_PVT.g_doc_status_REAPPROVAL, 'R',
1907: PO_DOCUMENT_ACTION_PVT.g_doc_status_REJECTED, 'F',
1908: PO_DOCUMENT_ACTION_PVT.g_doc_status_RETURNED, 'F',
1909: PO_DOCUMENT_ACTION_PVT.g_doc_status_INCOMPLETE, 'N',

Line 1906: PO_DOCUMENT_ACTION_PVT.g_doc_status_REAPPROVAL, 'R',

1902: /* UPDATE PO_HEADERS_DRAFT_ALL poh
1903: SET poh.authorization_status = p_new_status,
1904: poh.approved_flag = DECODE(p_new_status,
1905: PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED, 'Y',
1906: PO_DOCUMENT_ACTION_PVT.g_doc_status_REAPPROVAL, 'R',
1907: PO_DOCUMENT_ACTION_PVT.g_doc_status_REJECTED, 'F',
1908: PO_DOCUMENT_ACTION_PVT.g_doc_status_RETURNED, 'F',
1909: PO_DOCUMENT_ACTION_PVT.g_doc_status_INCOMPLETE, 'N',
1910: PO_DOCUMENT_ACTION_PVT.g_doc_status_INPROCESS, 'N',

Line 1907: PO_DOCUMENT_ACTION_PVT.g_doc_status_REJECTED, 'F',

1903: SET poh.authorization_status = p_new_status,
1904: poh.approved_flag = DECODE(p_new_status,
1905: PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED, 'Y',
1906: PO_DOCUMENT_ACTION_PVT.g_doc_status_REAPPROVAL, 'R',
1907: PO_DOCUMENT_ACTION_PVT.g_doc_status_REJECTED, 'F',
1908: PO_DOCUMENT_ACTION_PVT.g_doc_status_RETURNED, 'F',
1909: PO_DOCUMENT_ACTION_PVT.g_doc_status_INCOMPLETE, 'N',
1910: PO_DOCUMENT_ACTION_PVT.g_doc_status_INPROCESS, 'N',
1911: PO_DOCUMENT_ACTION_PVT.g_doc_status_PREAPPROVED, 'N'),

Line 1908: PO_DOCUMENT_ACTION_PVT.g_doc_status_RETURNED, 'F',

1904: poh.approved_flag = DECODE(p_new_status,
1905: PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED, 'Y',
1906: PO_DOCUMENT_ACTION_PVT.g_doc_status_REAPPROVAL, 'R',
1907: PO_DOCUMENT_ACTION_PVT.g_doc_status_REJECTED, 'F',
1908: PO_DOCUMENT_ACTION_PVT.g_doc_status_RETURNED, 'F',
1909: PO_DOCUMENT_ACTION_PVT.g_doc_status_INCOMPLETE, 'N',
1910: PO_DOCUMENT_ACTION_PVT.g_doc_status_INPROCESS, 'N',
1911: PO_DOCUMENT_ACTION_PVT.g_doc_status_PREAPPROVED, 'N'),
1912: poh.approved_date = DECODE(p_new_status,

Line 1909: PO_DOCUMENT_ACTION_PVT.g_doc_status_INCOMPLETE, 'N',

1905: PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED, 'Y',
1906: PO_DOCUMENT_ACTION_PVT.g_doc_status_REAPPROVAL, 'R',
1907: PO_DOCUMENT_ACTION_PVT.g_doc_status_REJECTED, 'F',
1908: PO_DOCUMENT_ACTION_PVT.g_doc_status_RETURNED, 'F',
1909: PO_DOCUMENT_ACTION_PVT.g_doc_status_INCOMPLETE, 'N',
1910: PO_DOCUMENT_ACTION_PVT.g_doc_status_INPROCESS, 'N',
1911: PO_DOCUMENT_ACTION_PVT.g_doc_status_PREAPPROVED, 'N'),
1912: poh.approved_date = DECODE(p_new_status,
1913: PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED, SYSDATE,

Line 1910: PO_DOCUMENT_ACTION_PVT.g_doc_status_INPROCESS, 'N',

1906: PO_DOCUMENT_ACTION_PVT.g_doc_status_REAPPROVAL, 'R',
1907: PO_DOCUMENT_ACTION_PVT.g_doc_status_REJECTED, 'F',
1908: PO_DOCUMENT_ACTION_PVT.g_doc_status_RETURNED, 'F',
1909: PO_DOCUMENT_ACTION_PVT.g_doc_status_INCOMPLETE, 'N',
1910: PO_DOCUMENT_ACTION_PVT.g_doc_status_INPROCESS, 'N',
1911: PO_DOCUMENT_ACTION_PVT.g_doc_status_PREAPPROVED, 'N'),
1912: poh.approved_date = DECODE(p_new_status,
1913: PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED, SYSDATE,
1914: poh.approved_date),

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

1907: PO_DOCUMENT_ACTION_PVT.g_doc_status_REJECTED, 'F',
1908: PO_DOCUMENT_ACTION_PVT.g_doc_status_RETURNED, 'F',
1909: PO_DOCUMENT_ACTION_PVT.g_doc_status_INCOMPLETE, 'N',
1910: PO_DOCUMENT_ACTION_PVT.g_doc_status_INPROCESS, 'N',
1911: PO_DOCUMENT_ACTION_PVT.g_doc_status_PREAPPROVED, 'N'),
1912: poh.approved_date = DECODE(p_new_status,
1913: PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED, SYSDATE,
1914: poh.approved_date),
1915: poh.last_update_date = SYSDATE,

Line 1913: PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED, SYSDATE,

1909: PO_DOCUMENT_ACTION_PVT.g_doc_status_INCOMPLETE, 'N',
1910: PO_DOCUMENT_ACTION_PVT.g_doc_status_INPROCESS, 'N',
1911: PO_DOCUMENT_ACTION_PVT.g_doc_status_PREAPPROVED, 'N'),
1912: poh.approved_date = DECODE(p_new_status,
1913: PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED, SYSDATE,
1914: poh.approved_date),
1915: poh.last_update_date = SYSDATE,
1916: poh.last_updated_by = p_user_id,
1917: poh.last_update_login = p_login_id,

Line 1919: PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED,

1915: poh.last_update_date = SYSDATE,
1916: poh.last_updated_by = p_user_id,
1917: poh.last_update_login = p_login_id,
1918: poh.pending_signature_flag = DECODE(p_new_status,
1919: PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED,
1920: DECODE(poh.acceptance_required_flag, 'S', 'Y', 'N'),
1921: poh.pending_signature_flag)
1922: WHERE poh.po_header_id = p_document_id
1923: AND poh.draft_id = p_draft_id;*/

Line 1935: PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED, 'Y',

1931:
1932: UPDATE PO_HEADERS poh
1933: SET poh.authorization_status = p_new_status,
1934: poh.approved_flag = DECODE(p_new_status,
1935: PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED, 'Y',
1936: PO_DOCUMENT_ACTION_PVT.g_doc_status_REAPPROVAL, 'R',
1937: PO_DOCUMENT_ACTION_PVT.g_doc_status_REJECTED, 'F',
1938: PO_DOCUMENT_ACTION_PVT.g_doc_status_RETURNED, 'F',
1939: PO_DOCUMENT_ACTION_PVT.g_doc_status_INCOMPLETE, 'N',

Line 1936: PO_DOCUMENT_ACTION_PVT.g_doc_status_REAPPROVAL, 'R',

1932: UPDATE PO_HEADERS poh
1933: SET poh.authorization_status = p_new_status,
1934: poh.approved_flag = DECODE(p_new_status,
1935: PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED, 'Y',
1936: PO_DOCUMENT_ACTION_PVT.g_doc_status_REAPPROVAL, 'R',
1937: PO_DOCUMENT_ACTION_PVT.g_doc_status_REJECTED, 'F',
1938: PO_DOCUMENT_ACTION_PVT.g_doc_status_RETURNED, 'F',
1939: PO_DOCUMENT_ACTION_PVT.g_doc_status_INCOMPLETE, 'N',
1940: PO_DOCUMENT_ACTION_PVT.g_doc_status_INPROCESS, 'N',

Line 1937: PO_DOCUMENT_ACTION_PVT.g_doc_status_REJECTED, 'F',

1933: SET poh.authorization_status = p_new_status,
1934: poh.approved_flag = DECODE(p_new_status,
1935: PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED, 'Y',
1936: PO_DOCUMENT_ACTION_PVT.g_doc_status_REAPPROVAL, 'R',
1937: PO_DOCUMENT_ACTION_PVT.g_doc_status_REJECTED, 'F',
1938: PO_DOCUMENT_ACTION_PVT.g_doc_status_RETURNED, 'F',
1939: PO_DOCUMENT_ACTION_PVT.g_doc_status_INCOMPLETE, 'N',
1940: PO_DOCUMENT_ACTION_PVT.g_doc_status_INPROCESS, 'N',
1941: PO_DOCUMENT_ACTION_PVT.g_doc_status_PREAPPROVED, 'N'),

Line 1938: PO_DOCUMENT_ACTION_PVT.g_doc_status_RETURNED, 'F',

1934: poh.approved_flag = DECODE(p_new_status,
1935: PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED, 'Y',
1936: PO_DOCUMENT_ACTION_PVT.g_doc_status_REAPPROVAL, 'R',
1937: PO_DOCUMENT_ACTION_PVT.g_doc_status_REJECTED, 'F',
1938: PO_DOCUMENT_ACTION_PVT.g_doc_status_RETURNED, 'F',
1939: PO_DOCUMENT_ACTION_PVT.g_doc_status_INCOMPLETE, 'N',
1940: PO_DOCUMENT_ACTION_PVT.g_doc_status_INPROCESS, 'N',
1941: PO_DOCUMENT_ACTION_PVT.g_doc_status_PREAPPROVED, 'N'),
1942: poh.approved_date = DECODE(p_new_status,

Line 1939: PO_DOCUMENT_ACTION_PVT.g_doc_status_INCOMPLETE, 'N',

1935: PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED, 'Y',
1936: PO_DOCUMENT_ACTION_PVT.g_doc_status_REAPPROVAL, 'R',
1937: PO_DOCUMENT_ACTION_PVT.g_doc_status_REJECTED, 'F',
1938: PO_DOCUMENT_ACTION_PVT.g_doc_status_RETURNED, 'F',
1939: PO_DOCUMENT_ACTION_PVT.g_doc_status_INCOMPLETE, 'N',
1940: PO_DOCUMENT_ACTION_PVT.g_doc_status_INPROCESS, 'N',
1941: PO_DOCUMENT_ACTION_PVT.g_doc_status_PREAPPROVED, 'N'),
1942: poh.approved_date = DECODE(p_new_status,
1943: PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED, SYSDATE, poh.approved_date),

Line 1940: PO_DOCUMENT_ACTION_PVT.g_doc_status_INPROCESS, 'N',

1936: PO_DOCUMENT_ACTION_PVT.g_doc_status_REAPPROVAL, 'R',
1937: PO_DOCUMENT_ACTION_PVT.g_doc_status_REJECTED, 'F',
1938: PO_DOCUMENT_ACTION_PVT.g_doc_status_RETURNED, 'F',
1939: PO_DOCUMENT_ACTION_PVT.g_doc_status_INCOMPLETE, 'N',
1940: PO_DOCUMENT_ACTION_PVT.g_doc_status_INPROCESS, 'N',
1941: PO_DOCUMENT_ACTION_PVT.g_doc_status_PREAPPROVED, 'N'),
1942: poh.approved_date = DECODE(p_new_status,
1943: PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED, SYSDATE, poh.approved_date),
1944: poh.clm_effective_date = DECODE(poh.clm_effective_date,

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

1937: PO_DOCUMENT_ACTION_PVT.g_doc_status_REJECTED, 'F',
1938: PO_DOCUMENT_ACTION_PVT.g_doc_status_RETURNED, 'F',
1939: PO_DOCUMENT_ACTION_PVT.g_doc_status_INCOMPLETE, 'N',
1940: PO_DOCUMENT_ACTION_PVT.g_doc_status_INPROCESS, 'N',
1941: PO_DOCUMENT_ACTION_PVT.g_doc_status_PREAPPROVED, 'N'),
1942: poh.approved_date = DECODE(p_new_status,
1943: PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED, SYSDATE, poh.approved_date),
1944: poh.clm_effective_date = DECODE(poh.clm_effective_date,
1945: NULL,DECODE(p_new_status,

Line 1943: PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED, SYSDATE, poh.approved_date),

1939: PO_DOCUMENT_ACTION_PVT.g_doc_status_INCOMPLETE, 'N',
1940: PO_DOCUMENT_ACTION_PVT.g_doc_status_INPROCESS, 'N',
1941: PO_DOCUMENT_ACTION_PVT.g_doc_status_PREAPPROVED, 'N'),
1942: poh.approved_date = DECODE(p_new_status,
1943: PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED, SYSDATE, poh.approved_date),
1944: poh.clm_effective_date = DECODE(poh.clm_effective_date,
1945: NULL,DECODE(p_new_status,
1946: PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED, SYSDATE,
1947: poh.approved_date),

Line 1946: PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED, SYSDATE,

1942: poh.approved_date = DECODE(p_new_status,
1943: PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED, SYSDATE, poh.approved_date),
1944: poh.clm_effective_date = DECODE(poh.clm_effective_date,
1945: NULL,DECODE(p_new_status,
1946: PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED, SYSDATE,
1947: poh.approved_date),
1948: poh.clm_effective_date),
1949: poh.last_update_date = SYSDATE,
1950: poh.last_updated_by = p_user_id,

Line 1953: PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED,

1949: poh.last_update_date = SYSDATE,
1950: poh.last_updated_by = p_user_id,
1951: poh.last_update_login = p_login_id,
1952: poh.pending_signature_flag = DECODE(p_new_status,
1953: PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED,
1954: DECODE(poh.acceptance_required_flag, 'S', 'Y',
1955: DECODE( poh.pending_signature_flag, 'E', 'E','N')),
1956: poh.pending_signature_flag)
1957: WHERE poh.po_header_id = p_document_id;

Line 1962: IF (p_new_status = PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED)

1958: END IF;
1959:
1960: -- CLM Apprvl end
1961:
1962: IF (p_new_status = PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED)
1963: THEN
1964:
1965: d_progress := 30;
1966:

Line 2021: SET poh.authorization_status = PO_DOCUMENT_ACTION_PVT.g_doc_status_PREAPPROVED

2017:
2018: d_progress := 80;
2019:
2020: UPDATE PO_HEADERS poh
2021: SET poh.authorization_status = PO_DOCUMENT_ACTION_PVT.g_doc_status_PREAPPROVED
2022: , poh.approved_flag = 'N'
2023: , poh.last_update_date = SYSDATE
2024: , poh.last_updated_by = p_user_id
2025: , poh.last_update_login = p_login_id

Line 2099: IF (p_new_status = PO_DOCUMENT_ACTION_PVT.g_doc_status_REAPPROVAL)

2095: END IF;
2096:
2097: END IF; -- p_new_status = g_doc_status_APPROVED
2098:
2099: IF (p_new_status = PO_DOCUMENT_ACTION_PVT.g_doc_status_REAPPROVAL)
2100: THEN
2101:
2102: d_progress := 100;
2103:

Line 2123: PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED, 'Y',

2119:
2120: UPDATE PO_RELEASES por
2121: SET por.authorization_status = p_new_status,
2122: por.approved_flag = DECODE(p_new_status,
2123: PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED, 'Y',
2124: PO_DOCUMENT_ACTION_PVT.g_doc_status_REAPPROVAL, 'R',
2125: PO_DOCUMENT_ACTION_PVT.g_doc_status_REJECTED, 'F',
2126: PO_DOCUMENT_ACTION_PVT.g_doc_status_RETURNED, 'F',
2127: PO_DOCUMENT_ACTION_PVT.g_doc_status_INCOMPLETE, 'N',

Line 2124: PO_DOCUMENT_ACTION_PVT.g_doc_status_REAPPROVAL, 'R',

2120: UPDATE PO_RELEASES por
2121: SET por.authorization_status = p_new_status,
2122: por.approved_flag = DECODE(p_new_status,
2123: PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED, 'Y',
2124: PO_DOCUMENT_ACTION_PVT.g_doc_status_REAPPROVAL, 'R',
2125: PO_DOCUMENT_ACTION_PVT.g_doc_status_REJECTED, 'F',
2126: PO_DOCUMENT_ACTION_PVT.g_doc_status_RETURNED, 'F',
2127: PO_DOCUMENT_ACTION_PVT.g_doc_status_INCOMPLETE, 'N',
2128: PO_DOCUMENT_ACTION_PVT.g_doc_status_INPROCESS, 'N',

Line 2125: PO_DOCUMENT_ACTION_PVT.g_doc_status_REJECTED, 'F',

2121: SET por.authorization_status = p_new_status,
2122: por.approved_flag = DECODE(p_new_status,
2123: PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED, 'Y',
2124: PO_DOCUMENT_ACTION_PVT.g_doc_status_REAPPROVAL, 'R',
2125: PO_DOCUMENT_ACTION_PVT.g_doc_status_REJECTED, 'F',
2126: PO_DOCUMENT_ACTION_PVT.g_doc_status_RETURNED, 'F',
2127: PO_DOCUMENT_ACTION_PVT.g_doc_status_INCOMPLETE, 'N',
2128: PO_DOCUMENT_ACTION_PVT.g_doc_status_INPROCESS, 'N',
2129: PO_DOCUMENT_ACTION_PVT.g_doc_status_PREAPPROVED, 'N'),

Line 2126: PO_DOCUMENT_ACTION_PVT.g_doc_status_RETURNED, 'F',

2122: por.approved_flag = DECODE(p_new_status,
2123: PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED, 'Y',
2124: PO_DOCUMENT_ACTION_PVT.g_doc_status_REAPPROVAL, 'R',
2125: PO_DOCUMENT_ACTION_PVT.g_doc_status_REJECTED, 'F',
2126: PO_DOCUMENT_ACTION_PVT.g_doc_status_RETURNED, 'F',
2127: PO_DOCUMENT_ACTION_PVT.g_doc_status_INCOMPLETE, 'N',
2128: PO_DOCUMENT_ACTION_PVT.g_doc_status_INPROCESS, 'N',
2129: PO_DOCUMENT_ACTION_PVT.g_doc_status_PREAPPROVED, 'N'),
2130: por.approved_date = DECODE(p_new_status,

Line 2127: PO_DOCUMENT_ACTION_PVT.g_doc_status_INCOMPLETE, 'N',

2123: PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED, 'Y',
2124: PO_DOCUMENT_ACTION_PVT.g_doc_status_REAPPROVAL, 'R',
2125: PO_DOCUMENT_ACTION_PVT.g_doc_status_REJECTED, 'F',
2126: PO_DOCUMENT_ACTION_PVT.g_doc_status_RETURNED, 'F',
2127: PO_DOCUMENT_ACTION_PVT.g_doc_status_INCOMPLETE, 'N',
2128: PO_DOCUMENT_ACTION_PVT.g_doc_status_INPROCESS, 'N',
2129: PO_DOCUMENT_ACTION_PVT.g_doc_status_PREAPPROVED, 'N'),
2130: por.approved_date = DECODE(p_new_status,
2131: PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED, SYSDATE,

Line 2128: PO_DOCUMENT_ACTION_PVT.g_doc_status_INPROCESS, 'N',

2124: PO_DOCUMENT_ACTION_PVT.g_doc_status_REAPPROVAL, 'R',
2125: PO_DOCUMENT_ACTION_PVT.g_doc_status_REJECTED, 'F',
2126: PO_DOCUMENT_ACTION_PVT.g_doc_status_RETURNED, 'F',
2127: PO_DOCUMENT_ACTION_PVT.g_doc_status_INCOMPLETE, 'N',
2128: PO_DOCUMENT_ACTION_PVT.g_doc_status_INPROCESS, 'N',
2129: PO_DOCUMENT_ACTION_PVT.g_doc_status_PREAPPROVED, 'N'),
2130: por.approved_date = DECODE(p_new_status,
2131: PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED, SYSDATE,
2132: por.approved_date),

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

2125: PO_DOCUMENT_ACTION_PVT.g_doc_status_REJECTED, 'F',
2126: PO_DOCUMENT_ACTION_PVT.g_doc_status_RETURNED, 'F',
2127: PO_DOCUMENT_ACTION_PVT.g_doc_status_INCOMPLETE, 'N',
2128: PO_DOCUMENT_ACTION_PVT.g_doc_status_INPROCESS, 'N',
2129: PO_DOCUMENT_ACTION_PVT.g_doc_status_PREAPPROVED, 'N'),
2130: por.approved_date = DECODE(p_new_status,
2131: PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED, SYSDATE,
2132: por.approved_date),
2133: por.last_update_date = SYSDATE,

Line 2131: PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED, SYSDATE,

2127: PO_DOCUMENT_ACTION_PVT.g_doc_status_INCOMPLETE, 'N',
2128: PO_DOCUMENT_ACTION_PVT.g_doc_status_INPROCESS, 'N',
2129: PO_DOCUMENT_ACTION_PVT.g_doc_status_PREAPPROVED, 'N'),
2130: por.approved_date = DECODE(p_new_status,
2131: PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED, SYSDATE,
2132: por.approved_date),
2133: por.last_update_date = SYSDATE,
2134: por.last_updated_by = p_user_id,
2135: por.last_update_login = p_login_id

Line 2138: IF (p_new_status = PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED)

2134: por.last_updated_by = p_user_id,
2135: por.last_update_login = p_login_id
2136: WHERE por.po_release_id = p_document_id;
2137:
2138: IF (p_new_status = PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED)
2139: THEN
2140:
2141: d_progress := 120;
2142:

Line 2154: IF (p_new_status = PO_DOCUMENT_ACTION_PVT.g_doc_status_REAPPROVAL)

2150: AND NVL(poll.approved_flag, 'N') <> 'Y';
2151:
2152: END IF; -- p_new_status = g_doc_status_APPROVED
2153:
2154: IF (p_new_status = PO_DOCUMENT_ACTION_PVT.g_doc_status_REAPPROVAL)
2155: THEN
2156:
2157: d_progress := 130;
2158:

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

2178:
2179: EXCEPTION
2180: WHEN PO_CORE_S.g_early_return_exc THEN
2181: l_ret_sts := 'U';
2182: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, l_err_msg);
2183: IF (PO_LOG.d_exc) THEN
2184: PO_LOG.exc(d_module, d_progress, l_err_msg);
2185: END IF;
2186: END;

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

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

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

2302: EXCEPTION
2303: WHEN OTHERS THEN
2304: x_return_status := 'U';
2305:
2306: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);
2307: IF (PO_LOG.d_exc) THEN
2308: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
2309: PO_LOG.proc_end(d_module, 'x_return_status', x_return_status);
2310: PO_LOG.proc_end(d_module);

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

2449: EXCEPTION
2450: WHEN OTHERS THEN
2451: x_return_status := 'U';
2452:
2453: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);
2454: IF (PO_LOG.d_exc) THEN
2455: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
2456: PO_LOG.proc_end(d_module, 'x_return_status', x_return_status);
2457: PO_LOG.proc_end(d_module);

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

2533: EXCEPTION
2534: WHEN OTHERS THEN
2535: x_return_status := 'U';
2536:
2537: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);
2538: IF (PO_LOG.d_exc) THEN
2539: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
2540: PO_LOG.proc_end(d_module, 'x_return_status', x_return_status);
2541: PO_LOG.proc_end(d_module);

Line 2655: IF p_po_mode = po_document_action_pvt.g_doc_action_APPROVE THEN

2651: PO_LOG.stmt(d_module, d_progress, 'l_line_quantity', l_line_quantity);
2652: PO_LOG.stmt(d_module, d_progress, 'l_line_amount', l_line_amount);
2653:
2654: END IF;
2655: IF p_po_mode = po_document_action_pvt.g_doc_action_APPROVE THEN
2656:
2657: d_progress := 20;
2658: IF (p_draft_id IS NULL OR p_draft_id = -1) THEN -- Main PO
2659: -- Changed the above line to handle the BPA case only

Line 2729: /*ELSIF (p_po_mode = po_document_action_pvt.g_doc_action_CANCEL) THEN

2725: WHEN No_Data_Found THEN
2726: PO_LOG.stmt(d_module, d_progress, 'Line is not modified ', p_po_line_id);
2727: END;
2728: END IF;
2729: /*ELSIF (p_po_mode = po_document_action_pvt.g_doc_action_CANCEL) THEN
2730:
2731: d_progress := 60;
2732: FOR c_get_dist_rec IN c_get_dist(p_po_line_id) LOOP
2733: SELECT quantity_cancelled, amount_cancelled INTO l_dist_qty_cancel, l_dist_amt_cancel FROM po_distributions_all