DBA Data[Home] [Help]

APPS.PO_REQAPPROVAL_FINDAPPRV1 dependencies on PO_WF_DEBUG_PKG

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

66: BEGIN
67:
68: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Set_Forward_To_From_App_fwd: 01';
69: IF (g_po_wf_debug = 'Y') THEN
70: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
71: END IF;
72:
73:
74: -- Do nothing in cancel or timeout mode

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

102: resultout := 'COMPLETE' ;
103:
104: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Set_Forward_To_From_App_fwd: 02';
105: IF (g_po_wf_debug = 'Y') THEN
106: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
107: END IF;
108:
109:
110: EXCEPTION

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

137: BEGIN
138:
139: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Set_Fwd_To_From_App_timeout: 01';
140: IF (g_po_wf_debug = 'Y') THEN
141: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
142: END IF;
143:
144:
145: -- Do nothing in cancel or timeout mode

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

276: resultout := 'COMPLETE' ;
277:
278: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Set_Fwd_To_From_App_timeout: 02';
279: IF (g_po_wf_debug = 'Y') THEN
280: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
281: END IF;
282:
283: EXCEPTION
284:

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

330: BEGIN
331:
332: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Is_Forward_To_Valid: 01';
333: IF (g_po_wf_debug = 'Y') THEN
334: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
335: END IF;
336:
337:
338: -- Do nothing in cancel or timeout mode

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

381:
382: x_progress := 'Set_Forward_To_From_App_fwd: 02';
383: x_progress := x_progress || ' Forward-To=' || l_forward_to_username_response;
384: IF (g_po_wf_debug = 'Y') THEN
385: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
386: END IF;
387:
388: IF CheckForwardTo(l_forward_to_username_response, x_user_id) = 'Y' THEN
389:

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

389:
390: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Is_Forward_To_Valid: 010 '||
391: 'x_user_id: ' ||x_user_id;
392: IF (g_po_wf_debug = 'Y') THEN
393: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
394: END IF;
395:
396: /* The FORWARD-FROM is now the old FORWARD-TO and the NEW FORWARD-TO is set
397: ** to what the user entered in the response

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

447: ** to the responder with Invalid Forward to Message
448: */
449: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Is_Forward_To_Valid: 015';
450: IF (g_po_wf_debug = 'Y') THEN
451: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
452: END IF;
453:
454: l_preparer_id := wf_engine.GetItemAttrText(itemtype => itemtype,
455: itemkey => itemkey,

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

461:
462: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Is_Forward_To_Valid: 020 ' ||
463: 'x_CanOwnerApproveFlag: '||x_CanOwnerApproveFlag;
464: IF (g_po_wf_debug = 'Y') THEN
465: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
466: END IF;
467:
468: if x_CanOwnerApproveFlag = 'N' then
469:

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

468: if x_CanOwnerApproveFlag = 'N' then
469:
470: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Is_Forward_To_Valid: 025';
471: IF (g_po_wf_debug = 'Y') THEN
472: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
473: END IF;
474:
475: fnd_message.set_name('PO', 'PO_WF_NOTIF_INVALID_FORWARD');
476: l_error_msg := fnd_message.get;

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

488: resultout := wf_engine.eng_completed || ':' || 'N';
489:
490: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Is_Forward_To_Valid: 050';
491: IF (g_po_wf_debug = 'Y') THEN
492: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
493: END IF;
494:
495: return;
496: end if;

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

499: /* end fix Bug# 1496490 */
500:
501: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Is_Forward_To_Valid: 060';
502: IF (g_po_wf_debug = 'Y') THEN
503: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
504: END IF;
505:
506:
507: /* Set the FORWARD_FROM */

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

643: BEGIN
644:
645: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Is_forward_to_provided: 01';
646: IF (g_po_wf_debug = 'Y') THEN
647: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
648: END IF;
649:
650:
651: -- Do nothing in cancel or timeout mode

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

680:
681:
682: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Is_forward_to_provided: 03';
683: IF (g_po_wf_debug = 'Y') THEN
684: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
685: END IF;
686:
687: EXCEPTION
688:

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

721: BEGIN
722:
723: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Is_forward_to_user_name_valid: 01';
724: IF (g_po_wf_debug = 'Y') THEN
725: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
726: END IF;
727:
728:
729: -- Do nothing in cancel or timeout mode

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

774: END IF;
775:
776: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Is_forward_to_user_name_valid: 02';
777: IF (g_po_wf_debug = 'Y') THEN
778: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
779: END IF;
780:
781: EXCEPTION
782:

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

813: BEGIN
814:
815: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Get_approval_path_id: 01';
816: IF (g_po_wf_debug = 'Y') THEN
817: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
818: END IF;
819:
820:
821: -- Do nothing in cancel or timeout mode

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

854: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
855: --
856: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Get_approval_path_id: 02';
857: IF (g_po_wf_debug = 'Y') THEN
858: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
859: END IF;
860:
861:
862: EXCEPTION

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

891: BEGIN
892:
893: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Get_Forward_mode: 01';
894: IF (g_po_wf_debug = 'Y') THEN
895: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
896: END IF;
897:
898:
899: -- Do nothing in cancel or timeout mode

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

939: END IF;
940:
941: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Get_Forward_mode: 02';
942: IF (g_po_wf_debug = 'Y') THEN
943: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
944: END IF;
945:
946:
947: EXCEPTION

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

975: BEGIN
976:
977: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Use_Position_flag: 01';
978: IF (g_po_wf_debug = 'Y') THEN
979: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
980: END IF;
981:
982:
983: -- Do nothing in cancel or timeout mode

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

1022: END IF;
1023:
1024: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Use_Position_flag: 02';
1025: IF (g_po_wf_debug = 'Y') THEN
1026: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
1027: END IF;
1028:
1029: EXCEPTION
1030:

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

1060: BEGIN
1061:
1062: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.GetMgr_hr_hier: 01';
1063: IF (g_po_wf_debug = 'Y') THEN
1064: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
1065: END IF;
1066:
1067:
1068: -- Do nothing in cancel or timeout mode

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

1110:
1111: END IF;
1112:
1113: IF (g_po_wf_debug = 'Y') THEN
1114: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
1115: END IF;
1116:
1117: EXCEPTION
1118:

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

1149: BEGIN
1150:
1151: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.GetMgr_po_hier: 01';
1152: IF (g_po_wf_debug = 'Y') THEN
1153: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
1154: END IF;
1155:
1156:
1157: -- Do nothing in cancel or timeout mode

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

1197:
1198: END IF;
1199:
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:

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

1241: */
1242:
1243: x_progress :='In IsForwardToProvided. x_progress= 001';
1244: IF (g_po_wf_debug = 'Y') THEN
1245: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
1246: END IF;
1247:
1248: /* Get_employee_id(), should set the item attribute FORWARD_TO_ID
1249: ** to the id of the username supplied as a forward_to in the notification

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

1263: IF l_forward_to_username_response is NOT NULL THEN
1264:
1265: x_progress :='In IsForwardToProvided. x_progress= 002';
1266: IF (g_po_wf_debug = 'Y') THEN
1267: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
1268: END IF;
1269:
1270:
1271: /* Set the forward_to username so they would get the notification */

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

1279:
1280: x_progress := '003';
1281: x_progress :='In IsForwardToProvided. x_progress= 003';
1282: IF (g_po_wf_debug = 'Y') THEN
1283: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
1284: END IF;
1285:
1286: wf_engine.SetItemAttrText ( itemtype => itemType,
1287: itemkey => itemkey,

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

1296: ELSE
1297:
1298: x_progress :='In IsForwardToProvided. x_progress= 004';
1299: IF (g_po_wf_debug = 'Y') THEN
1300: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
1301: END IF;
1302:
1303: RETURN('N'); -- If no valid user provide, then return 'NO FORWARD-TO'
1304:

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

1307: ELSE
1308:
1309: x_progress :='In IsForwardToProvided. x_progress= 005';
1310: IF (g_po_wf_debug = 'Y') THEN
1311: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
1312: END IF;
1313:
1314: l_forward_to_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1315: itemkey => itemkey,

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

1341: ELSE
1342:
1343: x_progress :='In IsForwardToProvided. x_progress= 007';
1344: IF (g_po_wf_debug = 'Y') THEN
1345: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
1346: END IF;
1347:
1348: RETURN('N');
1349: END IF;

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

1477: END IF;
1478:
1479: x_progress := 'Procedure GetApprovalPathId(). PATH_ID= ' || to_char(l_approval_path_id);
1480: IF (g_po_wf_debug = 'Y') THEN
1481: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
1482: END IF;
1483:
1484: EXCEPTION
1485:

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

1679: x_progress := x_progress || ' employee_id=' || to_char(l_empid) ||
1680: ' supervisor_id=' || to_char(l_superior_id);
1681:
1682: IF (g_po_wf_debug = 'Y') THEN
1683: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
1684: END IF;
1685:
1686: IF l_superior_id IS NOT NULL THEN
1687:

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

1903: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.GetMgrPOHier: approval_path_id= ' ||
1904: to_char(l_approval_path_id) || ' employee_id=' ||
1905: to_char(l_empid) || ' supervisor_id=' || to_char(l_superior_id);
1906: IF (g_po_wf_debug = 'Y') THEN
1907: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
1908: END IF;
1909:
1910:
1911: IF C1%FOUND THEN