APPS.PO_REQAPPROVAL_ACTION dependencies on PO_WF_DEBUG_PKG

Line 328: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

324: BEGIN
325:
326: x_progress := 'PO_REQAPPROVAL_ACTION.State_Check_approve: 01';
327: IF (g_po_wf_debug = 'Y') THEN
328: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
329: END IF;
330:
331:
332: -- Do nothing in cancel or timeout mode

Line 397: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

393:
394:
395: x_progress := 'PO_REQAPPROVAL_ACTION.State_Check_approve: 02. RESULT= ' || x_resultout;
396: IF (g_po_wf_debug = 'Y') THEN
397: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
398: END IF;
399:
400:
401: EXCEPTION

Line 437: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

433: BEGIN
434:
435: x_progress := 'PO_REQAPPROVAL_ACTION.State_Check_reject: 01';
436: IF (g_po_wf_debug = 'Y') THEN
437: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
438: END IF;
439:
440:
441: -- Do nothing in cancel or timeout mode

Line 477: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

473:
474:
475: x_progress := 'PO_REQAPPROVAL_ACTION.State_Check_reject: 02. RESULT= ' || x_resultout;
476: IF (g_po_wf_debug = 'Y') THEN
477: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
478: END IF;
479:
480:
481: EXCEPTION

Line 522: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

518: BEGIN
519:
520: x_progress := 'PO_REQAPPROVAL_ACTION.Doc_complete_check: 01';
521: IF (g_po_wf_debug = 'Y') THEN
522: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
523: END IF;
524:
525:
526: -- Do nothing in cancel or timeout mode

Line 613: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

609: --
610:
611: x_progress := 'PO_REQAPPROVAL_ACTION.Doc_complete_check: 02. RESULT= ' || x_resultout;
612: IF (g_po_wf_debug = 'Y') THEN
613: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
614: END IF;
615:
616:
617: EXCEPTION

Line 666: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

662: BEGIN
663:
664: x_progress := 'PO_REQAPPROVAL_ACTION.Approve_doc: 01';
665: IF (g_po_wf_debug = 'Y') THEN
666: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
667: END IF;
668:
669:
670: -- Do nothing in cancel or timeout mode

Line 734: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

730: END IF;
731:
732: x_progress := 'PO_REQAPPROVAL_ACTION.Approve_doc: 02. RESULT= ' || x_resultout;
733: IF (g_po_wf_debug = 'Y') THEN
734: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
735: END IF;
736:
737:
738: EXCEPTION

Line 779: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

775: BEGIN
776:
777: x_progress := 'PO_REQAPPROVAL_ACTION.Approve_and_forward_doc: 01';
778: IF (g_po_wf_debug = 'Y') THEN
779: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
780: END IF;
781:
782:
783: -- Do nothing in cancel or timeout mode

Line 844: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

840: END IF;
841:
842: x_progress := 'PO_REQAPPROVAL_ACTION.Approve_and_forward_doc: 02. RESULT= ' || x_resultout;
843: IF (g_po_wf_debug = 'Y') THEN
844: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
845: END IF;
846:
847: EXCEPTION
848:

Line 891: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

887: BEGIN
888:
889: x_progress := 'PO_REQAPPROVAL_ACTION.Forward_doc_inprocess: 01';
890: IF (g_po_wf_debug = 'Y') THEN
891: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
892: END IF;
893:
894:
895: -- Do nothing in cancel or timeout mode

Line 958: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

954: END IF;
955:
956: x_progress := 'PO_REQAPPROVAL_ACTION.Forward_doc_inprocess: 02. RESULT= ' || x_resultout;
957: IF (g_po_wf_debug = 'Y') THEN
958: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
959: END IF;
960:
961: EXCEPTION
962: WHEN doc_manager_exception THEN

Line 1002: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

998: BEGIN
999:
1000: x_progress := 'PO_REQAPPROVAL_ACTION.Forward_doc_preapproved: 01';
1001: IF (g_po_wf_debug = 'Y') THEN
1002: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
1003: END IF;
1004:
1005:
1006: -- Do nothing in cancel or timeout mode

Line 1066: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

1062: END IF;
1063:
1064: x_progress := 'PO_REQAPPROVAL_ACTION.Forward_doc_preapproved: 02. RESULT= ' || x_resultout;
1065: IF (g_po_wf_debug = 'Y') THEN
1066: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
1067: END IF;
1068:
1069: EXCEPTION
1070: WHEN doc_manager_exception THEN

Line 1102: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

1098: BEGIN
1099:
1100: x_progress := 'PO_REQAPPROVAL_ACTION.Reject_Doc: 01';
1101: IF (g_po_wf_debug = 'Y') THEN
1102: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
1103: END IF;
1104:
1105:
1106: -- Do nothing in cancel or timeout mode

Line 1129: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

1125: resultout := wf_engine.eng_completed || ':' || l_doc_mgr_return_val;
1126:
1127: x_progress := 'PO_REQAPPROVAL_ACTION.Reject_Doc: 02. RESULT= ' || l_doc_mgr_return_val;
1128: IF (g_po_wf_debug = 'Y') THEN
1129: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
1130: END IF;
1131:
1132: EXCEPTION
1133:

Line 1169: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

1165: BEGIN
1166:
1167: x_progress := 'PO_REQAPPROVAL_ACTION.Verify_authority: 01';
1168: IF (g_po_wf_debug = 'Y') THEN
1169: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
1170: END IF;
1171:
1172:
1173: -- Do nothing in cancel or timeout mode

Line 1201: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

1197:
1198:
1199: x_progress := 'PO_REQAPPROVAL_ACTION.Verify_authority: 02. RESULT= ' || x_resultout;
1200: IF (g_po_wf_debug = 'Y') THEN
1201: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
1202: END IF;
1203:
1204: EXCEPTION
1205: WHEN doc_manager_exception THEN

Line 1240: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

1236: BEGIN
1237:
1238: x_progress := 'PO_REQAPPROVAL_ACTION.Open_Doc_State: 01';
1239: IF (g_po_wf_debug = 'Y') THEN
1240: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
1241: END IF;
1242:
1243:
1244: -- Do nothing in cancel or timeout mode

Line 1273: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

1269: END IF;
1270:
1271: x_progress := 'PO_REQAPPROVAL_ACTION.Open_Doc_State 02. RESULT= ' || x_resultout;
1272: IF (g_po_wf_debug = 'Y') THEN
1273: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
1274: END IF;
1275:
1276: EXCEPTION
1277:

Line 1316: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

1312: BEGIN
1313:
1314: x_progress := 'PO_REQAPPROVAL_ACTION.Reserve_Doc: 01';
1315: IF (g_po_wf_debug = 'Y') THEN
1316: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
1317: END IF;
1318:
1319:
1320: -- Do nothing in cancel or timeout mode

Line 1398: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

1394: x_resultout := l_doc_mgr_return_val;
1395:
1396: x_progress := 'PO_REQAPPROVAL_ACTION.Reserve_Doc 02. RESULT= ' || x_resultout;
1397: IF (g_po_wf_debug = 'Y') THEN
1398: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
1399: END IF;
1400:
1401: EXCEPTION
1402: -- WHEN doc_manager_exception THEN

Line 1460: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

1456: l_document_type || ' Subtype= ' || l_document_subtype ||
1457: ' Doc_id= ' || to_char(l_document_id);
1458:
1459: IF (g_po_wf_debug = 'Y') THEN
1460: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
1461: END IF;
1462:
1463: PO_DOCUMENT_ACTION_PVT.check_doc_status_approve(
1464: p_document_id => l_document_id

Line 1487: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

1483: ELSE
1484:
1485: x_progress := 'PO_REQAPPROVAL_ACTION.StateCheckApprove: Returned_code= ' || l_ret_code;
1486: IF (g_po_wf_debug = 'Y') THEN
1487: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
1488: END IF;
1489:
1490: return('N');
1491:

Line 1498: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

1494: ELSE
1495:
1496: x_progress := 'PO_REQAPPROVAL_ACTION.StateCheckApprove: action call returned with: ' || l_ret_sts;
1497: IF (g_po_wf_debug = 'Y') THEN
1498: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
1499: END IF;
1500:
1501: doc_mgr_err_num := 3;
1502: sysadmin_err_msg := l_exc_msg;

Line 1557: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

1553: l_document_type || ' Subtype= ' || l_document_subtype ||
1554: ' Doc_id= ' || to_char(l_document_id);
1555:
1556: IF (g_po_wf_debug = 'Y') THEN
1557: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
1558: END IF;
1559:
1560: PO_DOCUMENT_ACTION_PVT.check_doc_status_reject(
1561: p_document_id => l_document_id

Line 1584: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

1580: ELSE
1581:
1582: x_progress := 'PO_REQAPPROVAL_ACTION.StateCheckReject: Returned_code= ' || l_ret_code;
1583: IF (g_po_wf_debug = 'Y') THEN
1584: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
1585: END IF;
1586:
1587: return('N');
1588:

Line 1595: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

1591: ELSE
1592:
1593: x_progress := 'PO_REQAPPROVAL_ACTION.StateCheckReject: action call returned with: ' || l_ret_sts;
1594: IF (g_po_wf_debug = 'Y') THEN
1595: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
1596: END IF;
1597:
1598: doc_mgr_err_num := 3;
1599: sysadmin_err_msg := l_exc_msg;

Line 1672: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

1668: l_document_Type || ' Subtype= ' || l_document_subtype ||
1669: ' Doc_id= ' || to_char(l_document_Id);
1670:
1671: IF (g_po_wf_debug = 'Y') THEN
1672: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
1673: END IF;
1674:
1675: -- <2757450 START>: If user chose to Create Sourcing Rule at the time
1676: -- of Approval, do not run the ASL Submission Checks.

Line 1722: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

1718:
1719:
1720:
1721: IF (g_po_wf_debug = 'Y') THEN
1722: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
1723: END IF;
1724:
1725: --
1726: l_conterms_yn:= PO_wf_Util_Pkg.GetItemAttrText(

Line 1751: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

1747: IF (l_error = 'W') then
1748: x_progress := 'PO_REQAPPROVAL_ACTION.DocCompleteCheck: Only Warnings found. Return success';
1749:
1750: IF (g_po_wf_debug = 'Y') THEN
1751: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
1752: END IF;
1753: return (FND_API.G_RET_STS_SUCCESS);
1754: END IF; --l_error=W
1755: END IF;-- l_conterms_yn

Line 1780: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

1776: x_progress := 'PO_REQAPPROVAL_ACTION.DocCompleteCheck: po_submission_check returned with: ' ||
1777: x_return_status ;
1778:
1779: IF (g_po_wf_debug = 'Y') THEN
1780: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
1781: END IF;
1782:
1783: sysadmin_err_msg := x_msg_data;
1784:

Line 1789: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

1785: x_progress := 'PO_REQAPPROVAL_ACTION.DocCompleteCheck: po_submission_check error msg is: ' ||
1786: x_msg_data;
1787:
1788: IF (g_po_wf_debug = 'Y') THEN
1789: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
1790: END IF;
1791:
1792: return(FND_API.G_RET_STS_UNEXP_ERROR);
1793:

Line 1829: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

1825:
1826: x_progress := 'PO_REQAPPROVAL_ACTION.InsertHistForOwnerApprove begin';
1827:
1828: IF (g_po_wf_debug = 'Y') THEN
1829: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
1830: END IF;
1831:
1832: -- get data from last entry in po_action_history
1833: select sequence_num,

Line 1852: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey, x_progress);

1848:
1849: x_progress := 'PO_REQAPPROVAL_ACTION.InsertHistForOwnerApprove action_code: ' || l_action_code;
1850:
1851: IF (g_po_wf_debug = 'Y') THEN
1852: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey, x_progress);
1853: END IF;
1854:
1855: -- if last entry into po_action_history is submit or reserve, then
1856: -- req is self-approved. Insert approval entry.

Line 1874: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey, x_progress);

1870:
1871: x_progress := 'PO_REQAPPROVAL_ACTION.InsertHistForOwnerApprove employee_id: ' || l_employee_id;
1872:
1873: IF (g_po_wf_debug = 'Y') THEN
1874: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey, x_progress);
1875: END IF;
1876:
1877: INSERT into PO_ACTION_HISTORY
1878: (object_id,

Line 1929: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

1925:
1926: x_progress := 'PO_REQAPPROVAL_ACTION.InsertHistForOwnerApprove end';
1927:
1928: IF (g_po_wf_debug = 'Y') THEN
1929: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
1930: END IF;
1931:
1932: EXCEPTION
1933:

Line 1993: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

1989: || ' Subtype= ' || l_document_subtype
1990: || ' Doc_id= ' || to_char(l_document_id);
1991:
1992: IF (g_po_wf_debug = 'Y') THEN
1993: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
1994: END IF;
1995:
1996: ApproveAutonomous(
1997: p_document_id => l_document_id

Line 2038: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

2034: x_progress := 'PO_REQAPPROVAL_ACTION.ApproveDoc: ApproveAutonomous returned with: '
2035: || l_ret_sts;
2036:
2037: IF (g_po_wf_debug = 'Y') THEN
2038: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
2039: END IF;
2040:
2041: doc_mgr_err_num := 3;
2042: sysadmin_err_msg := l_exc_msg;

Line 2115: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

2111: l_document_type || ' Subtype= ' || l_document_subtype ||
2112: ' Doc_id= ' || to_char(l_document_id);
2113:
2114: IF (g_po_wf_debug = 'Y') THEN
2115: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
2116: END IF;
2117:
2118: ForwardAutonomous(
2119: p_document_id => l_document_id

Line 2148: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

2144: -- fatal exception, l_ret_sts = 'U'
2145:
2146: x_progress := 'PO_REQAPPROVAL_ACTION.ApproveAndForward: ForwardAutonomous returned with: ' || l_ret_sts;
2147: IF (g_po_wf_debug = 'Y') THEN
2148: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
2149: END IF;
2150:
2151: doc_mgr_err_num := 3;
2152: sysadmin_err_msg := l_exc_msg;

Line 2226: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

2222: l_document_type || ' Subtype= ' || l_document_subtype ||
2223: ' Doc_id= ' || to_char(l_document_id);
2224:
2225: IF (g_po_wf_debug = 'Y') THEN
2226: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
2227: END IF;
2228:
2229: ForwardAutonomous(
2230: p_document_id => l_document_id

Line 2258: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

2254: -- fatal exception, l_ret_sts = 'U'
2255:
2256: x_progress := 'PO_REQAPPROVAL_ACTION.ForwardDocInProcess: ForwardAutonomous returned with: ' || l_ret_sts;
2257: IF (g_po_wf_debug = 'Y') THEN
2258: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
2259: END IF;
2260:
2261: doc_mgr_err_num := 3;
2262: sysadmin_err_msg := l_exc_msg;

Line 2337: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

2333: l_document_type || ' Subtype= ' || l_document_subtype ||
2334: ' Doc_id= ' || to_char(l_document_id);
2335:
2336: IF (g_po_wf_debug = 'Y') THEN
2337: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
2338: END IF;
2339:
2340: ForwardAutonomous(
2341: p_document_id => l_document_id

Line 2369: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

2365: -- fatal exception, l_ret_sts = 'U'
2366:
2367: x_progress := 'PO_REQAPPROVAL_ACTION.ForwardDocPreApproved: ForwardAutonomous returned with: ' || l_ret_sts;
2368: IF (g_po_wf_debug = 'Y') THEN
2369: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
2370: END IF;
2371:
2372: doc_mgr_err_num := 3;
2373: sysadmin_err_msg := l_exc_msg;

Line 2464: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

2460: l_document_type || ' Subtype= ' || l_document_subtype ||
2461: ' Doc_id= ' || to_char(l_document_id);
2462:
2463: IF (g_po_wf_debug = 'Y') THEN
2464: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
2465: END IF;
2466:
2467:
2468: RejectAutonomous(

Line 2506: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

2502:
2503: x_progress := 'PO_REQAPPROVAL_ACTION.RejectDoc: Returned_code= ' ||
2504: l_ret_code ;
2505: IF (g_po_wf_debug = 'Y') THEN
2506: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
2507: END IF;
2508:
2509: return('N');
2510:

Line 2520: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

2516:
2517: x_progress := 'PO_REQAPPROVAL_ACTION.RejectDoc: RejectAutonomous returned with: ' || l_ret_sts;
2518:
2519: IF (g_po_wf_debug = 'Y') THEN
2520: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
2521: END IF;
2522:
2523:
2524: doc_mgr_err_num := 3;

Line 2584: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

2580: l_document_type || ' Subtype= ' || l_document_subtype ||
2581: ' Doc_id= ' || to_char(l_document_id);
2582:
2583: IF (g_po_wf_debug = 'Y') THEN
2584: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
2585: END IF;
2586:
2587:
2588: PO_DOCUMENT_ACTION_PVT.verify_authority(

Line 2619: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

2615: -- fatal exceptionl; l_ret_sts := 'U';
2616:
2617: x_progress := 'PO_REQAPPROVAL_ACTION.VerifyAuthority: action call returned with: ' || l_ret_sts;
2618: IF (g_po_wf_debug = 'Y') THEN
2619: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
2620: END IF;
2621:
2622: doc_mgr_err_num := 3;
2623: sysadmin_err_msg := l_exc_msg;

Line 2676: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

2672: l_document_type || ' Subtype= ' || l_document_subtype ||
2673: ' Doc_id= ' || to_char(l_document_id);
2674:
2675: IF (g_po_wf_debug = 'Y') THEN
2676: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
2677: END IF;
2678:
2679: AutoUpdateCloseAutonomous(
2680: p_document_id => l_document_id

Line 2701: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

2697:
2698: x_progress := 'PO_REQAPPROVAL_ACTION.OpenDocumentState: Returned_code= ' ||
2699: l_ret_code ;
2700: IF (g_po_wf_debug = 'Y') THEN
2701: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
2702: END IF;
2703:
2704: return('N');
2705:

Line 2718: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

2714:
2715: x_progress := 'PO_REQAPPROVAL_ACTION.OpenDocumentState: auto_close_update_autonomous returned with: ' ||
2716: l_ret_sts;
2717: IF (g_po_wf_debug = 'Y') THEN
2718: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
2719: END IF;
2720:
2721: doc_mgr_err_num := 3;
2722: sysadmin_err_msg := l_exc_msg;

Line 2767: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

2763: BEGIN
2764:
2765: x_progress := 'ReserveDoc 001';
2766: IF (g_po_wf_debug = 'Y') THEN
2767: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
2768: END IF;
2769:
2770: l_doc_type := wf_engine.GetItemAttrText(
2771: itemtype => itemtype,

Line 2783: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

2779:
2780: x_progress := 'ReserveDoc 010: '|| 'Doc Type = '|| l_doc_type ||
2781: ' Doc Subtype = '|| l_doc_subtype;
2782: IF (g_po_wf_debug = 'Y') THEN
2783: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
2784: END IF;
2785:
2786: -- If the Document type is Contract Agreement, then don't reserve
2787:

Line 2801: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

2797: aname => 'DOCUMENT_ID');
2798:
2799: x_progress := 'ReserveDoc 020: ' || 'Doc Header Id = ' || to_char(l_doc_id);
2800: IF (g_po_wf_debug = 'Y') THEN
2801: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
2802: END IF;
2803:
2804: IF (l_doc_type = 'REQUISITION') THEN
2805: l_employee_id := wf_engine.GetItemAttrNumber(

Line 2832: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

2828:
2829: x_progress := 'ReserveDoc 030: ReserveAutonomous return code = ' ||
2830: l_po_return_code;
2831: IF (g_po_wf_debug = 'Y') THEN
2832: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
2833: END IF;
2834:
2835: IF (l_po_return_code = PO_DOCUMENT_FUNDS_PVT.g_return_SUCCESS) THEN
2836:

Line 2866: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

2862: -- Read note below about why the setting of this attribute was moved here from below.
2863:
2864: x_progress := 'ReserveDoc 100 Advisory Message: '||l_warning_mesg;
2865: IF (g_po_wf_debug = 'Y') THEN
2866: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
2867: END IF;
2868:
2869: get_advisory_warning( itemtype => itemType
2870: , itemkey => itemkey

Line 2905: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

2901: -- no warning.
2902:
2903: x_progress := 'ReserveDoc 999';
2904: IF (g_po_wf_debug = 'Y') THEN
2905: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
2906: END IF;
2907:
2908: return(l_return);
2909:

Line 3105: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

3101: x_progress := 'PO_REQAPPROVAL_ACTION.set_report_attr_text.030.ON_LINE_REPORT_ID= '
3102: || to_char(p_online_report_id);
3103:
3104: IF (g_po_wf_debug = 'Y') THEN
3105: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
3106: END IF;
3107:
3108: EXCEPTION
3109: WHEN OTHERS THEN

Line 3138: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

3134: x_progress := 'PO_REQAPPROVAL_ACTION.set_doc_mgr_context. USER_ID= ' || to_char(l_user_id)
3135: || ' APPLICATION_ID= ' || to_char(l_application_id) ||
3136: 'RESPONSIBILITY_ID= ' || to_char(l_responsibility_id);
3137: IF (g_po_wf_debug = 'Y') THEN
3138: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
3139: END IF;
3140:
3141: EXCEPTION
3142:

Line 3227: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

3223: x_progress := 'PO_REQAPPROVAL_ACTION.set_responder_doc_mgr_context. USER_ID= ' || to_char(l_user_id)
3224: || ' APPLICATION_ID= ' || to_char(l_application_id) ||
3225: 'RESPONSIBILITY_ID= ' || to_char(l_responsibility_id);
3226: IF (g_po_wf_debug = 'Y') THEN
3227: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
3228: END IF;
3229:
3230: EXCEPTION
3231:

Line 3266: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

3262: BEGIN
3263:
3264: x_progress := 'PO_REQAPPROVAL_ACTION.Reserve_doc_Override: 01';
3265: IF (g_po_wf_debug = 'Y') THEN
3266: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
3267: END IF;
3268:
3269: -- Do nothing in cancel or timeout mode
3270: --

Line 3308: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

3304: l_doc_mgr_return_val := ReserveDoc(itemtype, itemkey, 'Y');
3305:
3306: x_progress := 'PO_REQAPPROVAL_ACTION.Reserve_doc_Override 10. RESULT= ' || x_resultout;
3307: IF (g_po_wf_debug = 'Y') THEN
3308: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
3309: END IF;
3310:
3311: --
3312: -- Commenting the Doc manager Handling

Line 3325: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

3321: x_resultout := l_doc_mgr_return_val;
3322:
3323: x_progress := 'PO_REQAPPROVAL_ACTION.Reserve_doc_Override 99';
3324: IF (g_po_wf_debug = 'Y') THEN
3325: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
3326: END IF;
3327:
3328: EXCEPTION
3329: -- WHEN doc_manager_exception THEN