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_AME_WF_PVT dependencies on PO_REQAPPROVAL_INIT1

Line 404: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);

400:
401: RETURN;
402: EXCEPTION
403: WHEN OTHERS THEN
404: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
405: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
406: WF_CORE.context(g_pkg_name, l_api_name, l_progress, sqlerrm);
407: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, l_progress, l_document_id);
408: IF (g_po_wf_debug = 'Y') THEN

Line 405: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);

401: RETURN;
402: EXCEPTION
403: WHEN OTHERS THEN
404: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
405: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
406: WF_CORE.context(g_pkg_name, l_api_name, l_progress, sqlerrm);
407: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, l_progress, l_document_id);
408: IF (g_po_wf_debug = 'Y') THEN
409: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_log_head||':'||l_progress);

Line 407: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, l_progress, l_document_id);

403: WHEN OTHERS THEN
404: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
405: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
406: WF_CORE.context(g_pkg_name, l_api_name, l_progress, sqlerrm);
407: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, l_progress, l_document_id);
408: IF (g_po_wf_debug = 'Y') THEN
409: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_log_head||':'||l_progress);
410: END IF;
411: resultout:= wf_engine.eng_completed||':'||'INVALID_APPROVER';

Line 473: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);

469: END IF;
470:
471: EXCEPTION
472: WHEN OTHERS THEN
473: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
474: wf_core.context(g_pkg_name, l_api_name, 'Unexpected Exception:', l_progress, SQLERRM);
475: IF (g_po_wf_debug = 'Y') THEN
476: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey, l_log_head||':'||l_progress||':'||SQLERRM);
477: END IF;

Line 1093: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);

1089: RETURN;
1090:
1091: EXCEPTION
1092: WHEN OTHERS THEN
1093: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1094: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1095: WF_CORE.context(g_pkg_name, l_api_name, l_progress, sqlerrm);
1096: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, l_progress, l_document_id);
1097: IF (g_po_wf_debug = 'Y') THEN

Line 1094: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);

1090:
1091: EXCEPTION
1092: WHEN OTHERS THEN
1093: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1094: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1095: WF_CORE.context(g_pkg_name, l_api_name, l_progress, sqlerrm);
1096: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, l_progress, l_document_id);
1097: IF (g_po_wf_debug = 'Y') THEN
1098: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_log_head||':'||l_progress);

Line 1096: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, l_progress, l_document_id);

1092: WHEN OTHERS THEN
1093: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1094: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1095: WF_CORE.context(g_pkg_name, l_api_name, l_progress, sqlerrm);
1096: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, l_progress, l_document_id);
1097: IF (g_po_wf_debug = 'Y') THEN
1098: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_log_head||':'||l_progress);
1099: END IF;
1100: RAISE;

Line 1523: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);

1519: RETURN;
1520:
1521: EXCEPTION
1522: WHEN OTHERS THEN
1523: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1524: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1525: WF_CORE.context(g_pkg_name, l_api_name, l_progress, sqlerrm);
1526: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, l_progress, l_document_id);
1527: IF (g_po_wf_debug = 'Y') THEN

Line 1524: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);

1520:
1521: EXCEPTION
1522: WHEN OTHERS THEN
1523: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1524: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1525: WF_CORE.context(g_pkg_name, l_api_name, l_progress, sqlerrm);
1526: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, l_progress, l_document_id);
1527: IF (g_po_wf_debug = 'Y') THEN
1528: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_log_head||':'||l_progress);

Line 1526: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, l_progress, l_document_id);

1522: WHEN OTHERS THEN
1523: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1524: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1525: WF_CORE.context(g_pkg_name, l_api_name, l_progress, sqlerrm);
1526: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, l_progress, l_document_id);
1527: IF (g_po_wf_debug = 'Y') THEN
1528: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_log_head||':'||l_progress);
1529: END IF;
1530: RAISE;

Line 1629: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);

1625: resultout := wf_engine.eng_completed||':'||'ACTIVITY_PERFORMED';
1626:
1627: EXCEPTION
1628: WHEN OTHERS THEN
1629: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1630: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1631: WF_CORE.context(g_pkg_name, l_api_name, l_progress, sqlerrm);
1632: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, l_progress, l_document_id);
1633: IF (g_po_wf_debug = 'Y') THEN

Line 1630: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);

1626:
1627: EXCEPTION
1628: WHEN OTHERS THEN
1629: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1630: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1631: WF_CORE.context(g_pkg_name, l_api_name, l_progress, sqlerrm);
1632: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, l_progress, l_document_id);
1633: IF (g_po_wf_debug = 'Y') THEN
1634: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_log_head||':'||l_progress||' Exception:'||sqlerrm);

Line 1632: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, l_progress, l_document_id);

1628: WHEN OTHERS THEN
1629: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1630: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1631: WF_CORE.context(g_pkg_name, l_api_name, l_progress, sqlerrm);
1632: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, l_progress, l_document_id);
1633: IF (g_po_wf_debug = 'Y') THEN
1634: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_log_head||':'||l_progress||' Exception:'||sqlerrm);
1635: END IF;
1636: RAISE;

Line 1753: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);

1749: RETURN;
1750:
1751: EXCEPTION
1752: WHEN OTHERS THEN
1753: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1754: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1755: WF_CORE.context(g_pkg_name, l_api_name, l_progress, sqlerrm);
1756: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, l_progress, l_document_id);
1757: IF (g_po_wf_debug = 'Y') THEN

Line 1754: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);

1750:
1751: EXCEPTION
1752: WHEN OTHERS THEN
1753: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1754: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1755: WF_CORE.context(g_pkg_name, l_api_name, l_progress, sqlerrm);
1756: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, l_progress, l_document_id);
1757: IF (g_po_wf_debug = 'Y') THEN
1758: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_log_head||':'||l_progress);

Line 1756: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, l_progress, l_document_id);

1752: WHEN OTHERS THEN
1753: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1754: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1755: WF_CORE.context(g_pkg_name, l_api_name, l_progress, sqlerrm);
1756: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, l_progress, l_document_id);
1757: IF (g_po_wf_debug = 'Y') THEN
1758: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_log_head||':'||l_progress);
1759: END IF;
1760: RAISE;

Line 1875: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);

1871: resultout := wf_engine.eng_completed||':'|| 'ACTIVITY_PERFORMED';
1872:
1873: EXCEPTION
1874: WHEN OTHERS THEN
1875: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1876: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1877: WF_CORE.context(g_pkg_name, l_api_name, l_progress, sqlerrm);
1878: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, l_progress, l_document_id);
1879: IF (g_po_wf_debug = 'Y') THEN

Line 1876: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);

1872:
1873: EXCEPTION
1874: WHEN OTHERS THEN
1875: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1876: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1877: WF_CORE.context(g_pkg_name, l_api_name, l_progress, sqlerrm);
1878: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, l_progress, l_document_id);
1879: IF (g_po_wf_debug = 'Y') THEN
1880: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_log_head||':'||l_progress);

Line 1878: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, l_progress, l_document_id);

1874: WHEN OTHERS THEN
1875: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1876: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1877: WF_CORE.context(g_pkg_name, l_api_name, l_progress, sqlerrm);
1878: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, l_progress, l_document_id);
1879: IF (g_po_wf_debug = 'Y') THEN
1880: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_log_head||':'||l_progress);
1881: END IF;
1882: RAISE;

Line 1983: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);

1979: RETURN;
1980:
1981: EXCEPTION
1982: WHEN OTHERS THEN
1983: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1984: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1985: WF_CORE.context(g_pkg_name, l_api_name, l_progress, sqlerrm);
1986: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, l_progress, l_document_id);
1987: IF (g_po_wf_debug = 'Y') THEN

Line 1984: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);

1980:
1981: EXCEPTION
1982: WHEN OTHERS THEN
1983: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1984: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1985: WF_CORE.context(g_pkg_name, l_api_name, l_progress, sqlerrm);
1986: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, l_progress, l_document_id);
1987: IF (g_po_wf_debug = 'Y') THEN
1988: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_log_head||':'||l_progress);

Line 1986: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, l_progress, l_document_id);

1982: WHEN OTHERS THEN
1983: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1984: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1985: WF_CORE.context(g_pkg_name, l_api_name, l_progress, sqlerrm);
1986: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, l_progress, l_document_id);
1987: IF (g_po_wf_debug = 'Y') THEN
1988: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_log_head||':'||l_progress);
1989: END IF;
1990: RAISE;

Line 2091: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);

2087: RETURN;
2088:
2089: EXCEPTION
2090: WHEN OTHERS THEN
2091: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
2092: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
2093: WF_CORE.context(g_pkg_name, l_api_name, l_progress, sqlerrm);
2094: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, l_progress, l_document_id);
2095: IF (g_po_wf_debug = 'Y') THEN

Line 2092: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);

2088:
2089: EXCEPTION
2090: WHEN OTHERS THEN
2091: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
2092: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
2093: WF_CORE.context(g_pkg_name, l_api_name, l_progress, sqlerrm);
2094: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, l_progress, l_document_id);
2095: IF (g_po_wf_debug = 'Y') THEN
2096: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_log_head||':'||l_progress);

Line 2094: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, l_progress, l_document_id);

2090: WHEN OTHERS THEN
2091: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
2092: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
2093: WF_CORE.context(g_pkg_name, l_api_name, l_progress, sqlerrm);
2094: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, l_progress, l_document_id);
2095: IF (g_po_wf_debug = 'Y') THEN
2096: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_log_head||':'||l_progress);
2097: END IF;
2098: RAISE;

Line 4010: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);

4006: RETURN;
4007:
4008: EXCEPTION
4009: WHEN OTHERS THEN
4010: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
4011: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
4012: WF_CORE.context(g_pkg_name, l_api_name, l_progress, sqlerrm);
4013: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, l_progress, l_po_header_id);
4014: IF (g_po_wf_debug = 'Y') THEN

Line 4011: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);

4007:
4008: EXCEPTION
4009: WHEN OTHERS THEN
4010: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
4011: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
4012: WF_CORE.context(g_pkg_name, l_api_name, l_progress, sqlerrm);
4013: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, l_progress, l_po_header_id);
4014: IF (g_po_wf_debug = 'Y') THEN
4015: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_log_head||':'||l_progress);

Line 4013: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, l_progress, l_po_header_id);

4009: WHEN OTHERS THEN
4010: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
4011: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
4012: WF_CORE.context(g_pkg_name, l_api_name, l_progress, sqlerrm);
4013: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, l_progress, l_po_header_id);
4014: IF (g_po_wf_debug = 'Y') THEN
4015: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_log_head||':'||l_progress);
4016: END IF;
4017: RAISE;

Line 4297: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);

4293: p_current_approver => l_current_approver);
4294:
4295: EXCEPTION
4296: WHEN OTHERS THEN
4297: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
4298: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
4299: WF_CORE.context(g_pkg_name, l_api_name, l_progress, sqlerrm);
4300: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, l_progress, l_document_id);
4301: IF (g_po_wf_debug = 'Y') THEN

Line 4298: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);

4294:
4295: EXCEPTION
4296: WHEN OTHERS THEN
4297: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
4298: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
4299: WF_CORE.context(g_pkg_name, l_api_name, l_progress, sqlerrm);
4300: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, l_progress, l_document_id);
4301: IF (g_po_wf_debug = 'Y') THEN
4302: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_log_head||':'||l_progress);

Line 4300: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, l_progress, l_document_id);

4296: WHEN OTHERS THEN
4297: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
4298: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
4299: WF_CORE.context(g_pkg_name, l_api_name, l_progress, sqlerrm);
4300: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, l_progress, l_document_id);
4301: IF (g_po_wf_debug = 'Y') THEN
4302: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_log_head||':'||l_progress);
4303: END IF;
4304: RAISE;

Line 4740: PO_REQAPPROVAL_INIT1.get_user_name(emp_rc.employee_id , l_emp_user_name, l_emp_disp_name);

4736: CLOSE employee_to_send_notif;
4737: EXIT;
4738: END IF;
4739:
4740: PO_REQAPPROVAL_INIT1.get_user_name(emp_rc.employee_id , l_emp_user_name, l_emp_disp_name);
4741:
4742: l_progress := '003';
4743: IF g_debug_stmt THEN
4744: PO_DEBUG.debug_begin(p_log_head => l_log_head );

Line 4913: PO_REQAPPROVAL_INIT1.get_user_name(p_current_employee_id, l_current_user_name, l_disp_name);

4909: p_token => l_progress,
4910: p_message => 'itemkey is ' || l_item_key);
4911: END IF;
4912:
4913: PO_REQAPPROVAL_INIT1.get_user_name(p_current_employee_id, l_current_user_name, l_disp_name);
4914:
4915: l_progress := '002';
4916:
4917: IF g_debug_stmt THEN

Line 5793: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemtype, itemkey);

5789: IF (g_po_wf_debug = 'Y') THEN
5790: PO_WF_DEBUG_PKG.INSERT_DEBUG(itemtype, itemkey, 'End erecords_exception:PO_AME_WF_PVT.CREATE_ERECORD ');
5791: PO_WF_DEBUG_PKG.INSERT_DEBUG(itemtype, itemkey, 'ERROR RETURNED '||l_msg_data || 'error is ' || SQLERRM || ' code is ' || SQLCODE);
5792: END IF;
5793: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemtype, itemkey);
5794: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemtype, itemkey);
5795: wf_core.context('PO_AME_WF_PVT', 'Create_Erecord', 'l_erecords_exception');
5796:
5797: PO_REQAPPROVAL_INIT1.send_error_notif(itemtype, itemkey, l_preparer_user_name, l_doc_string, l_msg_data,'PO_AME_WF_PVT.Create_Erecord', l_document_id);

Line 5794: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemtype, itemkey);

5790: PO_WF_DEBUG_PKG.INSERT_DEBUG(itemtype, itemkey, 'End erecords_exception:PO_AME_WF_PVT.CREATE_ERECORD ');
5791: PO_WF_DEBUG_PKG.INSERT_DEBUG(itemtype, itemkey, 'ERROR RETURNED '||l_msg_data || 'error is ' || SQLERRM || ' code is ' || SQLCODE);
5792: END IF;
5793: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemtype, itemkey);
5794: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemtype, itemkey);
5795: wf_core.context('PO_AME_WF_PVT', 'Create_Erecord', 'l_erecords_exception');
5796:
5797: PO_REQAPPROVAL_INIT1.send_error_notif(itemtype, itemkey, l_preparer_user_name, l_doc_string, l_msg_data,'PO_AME_WF_PVT.Create_Erecord', l_document_id);
5798: RAISE;

Line 5797: PO_REQAPPROVAL_INIT1.send_error_notif(itemtype, itemkey, l_preparer_user_name, l_doc_string, l_msg_data,'PO_AME_WF_PVT.Create_Erecord', l_document_id);

5793: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemtype, itemkey);
5794: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemtype, itemkey);
5795: wf_core.context('PO_AME_WF_PVT', 'Create_Erecord', 'l_erecords_exception');
5796:
5797: PO_REQAPPROVAL_INIT1.send_error_notif(itemtype, itemkey, l_preparer_user_name, l_doc_string, l_msg_data,'PO_AME_WF_PVT.Create_Erecord', l_document_id);
5798: RAISE;
5799: END CREATE_ERECORD;
5800:
5801: --------------------------------------------------------------------------------

Line 6142: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemtype, itemkey);

6138: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_log_head || ' in binding excpetion with error messsage ' || x_error_msg);
6139: END IF;
6140:
6141: WHEN OTHERS THEN
6142: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemtype, itemkey);
6143: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemtype, itemkey);
6144: WF_CORE.context(g_pkg_name, l_api_name, l_progress, sqlerrm);
6145: PO_REQAPPROVAL_INIT1.send_error_notif(itemtype, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, l_progress, l_document_id);
6146: IF (g_po_wf_debug = 'Y') THEN

Line 6143: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemtype, itemkey);

6139: END IF;
6140:
6141: WHEN OTHERS THEN
6142: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemtype, itemkey);
6143: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemtype, itemkey);
6144: WF_CORE.context(g_pkg_name, l_api_name, l_progress, sqlerrm);
6145: PO_REQAPPROVAL_INIT1.send_error_notif(itemtype, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, l_progress, l_document_id);
6146: IF (g_po_wf_debug = 'Y') THEN
6147: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_log_head||':'||l_progress);

Line 6145: PO_REQAPPROVAL_INIT1.send_error_notif(itemtype, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, l_progress, l_document_id);

6141: WHEN OTHERS THEN
6142: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemtype, itemkey);
6143: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemtype, itemkey);
6144: WF_CORE.context(g_pkg_name, l_api_name, l_progress, sqlerrm);
6145: PO_REQAPPROVAL_INIT1.send_error_notif(itemtype, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, l_progress, l_document_id);
6146: IF (g_po_wf_debug = 'Y') THEN
6147: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_log_head||':'||l_progress);
6148: END IF;
6149: RAISE;