DBA Data[Home] [Help]

APPS.PO_REQAPPROVAL_FINDAPPRV1 dependencies on PO_WF_DEBUG_PKG

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

72: BEGIN
73:
74: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Set_Forward_To_From_App_fwd: 01';
75: IF (g_po_wf_debug = 'Y') THEN
76: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
77: END IF;
78:
79:
80: -- Do nothing in cancel or timeout mode

Line 96: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress || l_error_msg);

92: itemkey => itemkey,
93: aname => 'WRONG_FORWARD_TO_MSG');
94: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Set_Forward_To_From_App_fwd: l_error_msg: ';
95: IF (g_po_wf_debug = 'Y') THEN
96: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress || l_error_msg);
97: END IF;
98:
99: IF l_error_msg is NULL THEN
100: l_forward_to_username_response := wf_engine.GetItemAttrText(itemtype => itemtype,

Line 109: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,

105: l_forward_to_username:= wf_engine.GetItemAttrText (itemtype => itemtype,
106: itemkey => itemkey,
107: aname => 'FORWARD_TO_USERNAME');
108: IF (g_po_wf_debug = 'Y') THEN
109: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,
110: 'l_forward_to_username: ' || l_forward_to_username);
111: END IF;
112:
113: IF l_forward_to_username is NOT NULL THEN

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

196: resultout := 'COMPLETE' ;
197:
198: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Set_Forward_To_From_App_fwd: 02';
199: IF (g_po_wf_debug = 'Y') THEN
200: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
201: END IF;
202:
203:
204: EXCEPTION

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

236: BEGIN
237:
238: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Set_Fwd_To_From_App_timeout: 01';
239: IF (g_po_wf_debug = 'Y') THEN
240: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
241: END IF;
242:
243:
244: -- Do nothing in cancel or timeout mode

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

394: resultout := 'COMPLETE' ;
395:
396: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Set_Fwd_To_From_App_timeout: 02';
397: IF (g_po_wf_debug = 'Y') THEN
398: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
399: END IF;
400:
401: EXCEPTION
402:

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

453: BEGIN
454:
455: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Is_Forward_To_Valid: 01';
456: IF (g_po_wf_debug = 'Y') THEN
457: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
458: END IF;
459:
460:
461: -- Do nothing in cancel or timeout mode

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

504:
505: x_progress := 'Set_Forward_To_From_App_fwd: 02';
506: x_progress := x_progress || ' Forward-To=' || l_forward_to_username_response;
507: IF (g_po_wf_debug = 'Y') THEN
508: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
509: END IF;
510:
511: IF CheckForwardTo(l_forward_to_username_response, x_user_id) = 'Y' THEN
512:

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

512:
513: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Is_Forward_To_Valid: 010 '||
514: 'x_user_id: ' ||x_user_id;
515: IF (g_po_wf_debug = 'Y') THEN
516: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
517: END IF;
518:
519: /* The FORWARD-FROM is now the old FORWARD-TO and the NEW FORWARD-TO is set
520: ** to what the user entered in the response

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

570: ** to the responder with Invalid Forward to Message
571: */
572: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Is_Forward_To_Valid: 015';
573: IF (g_po_wf_debug = 'Y') THEN
574: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
575: END IF;
576:
577: l_preparer_id := wf_engine.GetItemAttrText(itemtype => itemtype,
578: itemkey => itemkey,

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

584:
585: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Is_Forward_To_Valid: 020 ' ||
586: 'x_CanOwnerApproveFlag: '||x_CanOwnerApproveFlag;
587: IF (g_po_wf_debug = 'Y') THEN
588: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
589: END IF;
590:
591: if x_CanOwnerApproveFlag = 'N' then
592:

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

591: if x_CanOwnerApproveFlag = 'N' then
592:
593: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Is_Forward_To_Valid: 025';
594: IF (g_po_wf_debug = 'Y') THEN
595: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
596: END IF;
597:
598: fnd_message.set_name('PO', 'PO_WF_NOTIF_INVALID_FORWARD');
599: l_error_msg := fnd_message.get;

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

611: resultout := wf_engine.eng_completed || ':' || 'N';
612:
613: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Is_Forward_To_Valid: 050';
614: IF (g_po_wf_debug = 'Y') THEN
615: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
616: END IF;
617:
618: return;
619: end if;

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

622: /* end fix Bug# 1496490 */
623:
624: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Is_Forward_To_Valid: 060';
625: IF (g_po_wf_debug = 'Y') THEN
626: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
627: END IF;
628:
629:
630: /* Set the FORWARD_FROM */

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

785: BEGIN
786:
787: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Is_forward_to_provided: 01';
788: IF (g_po_wf_debug = 'Y') THEN
789: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
790: END IF;
791:
792:
793: -- Do nothing in cancel or timeout mode

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

822:
823:
824: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Is_forward_to_provided: 03';
825: IF (g_po_wf_debug = 'Y') THEN
826: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
827: END IF;
828:
829: EXCEPTION
830:

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

863: BEGIN
864:
865: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Is_forward_to_user_name_valid: 01';
866: IF (g_po_wf_debug = 'Y') THEN
867: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
868: END IF;
869:
870:
871: -- Do nothing in cancel or timeout mode

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

916: END IF;
917:
918: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Is_forward_to_user_name_valid: 02';
919: IF (g_po_wf_debug = 'Y') THEN
920: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
921: END IF;
922:
923: EXCEPTION
924:

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

955: BEGIN
956:
957: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Get_approval_path_id: 01';
958: IF (g_po_wf_debug = 'Y') THEN
959: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
960: END IF;
961:
962:
963: -- Do nothing in cancel or timeout mode

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

996: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
997: --
998: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Get_approval_path_id: 02';
999: IF (g_po_wf_debug = 'Y') THEN
1000: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
1001: END IF;
1002:
1003:
1004: EXCEPTION

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

1033: BEGIN
1034:
1035: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Get_Forward_mode: 01';
1036: IF (g_po_wf_debug = 'Y') THEN
1037: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
1038: END IF;
1039:
1040:
1041: -- Do nothing in cancel or timeout mode

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

1081: END IF;
1082:
1083: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Get_Forward_mode: 02';
1084: IF (g_po_wf_debug = 'Y') THEN
1085: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
1086: END IF;
1087:
1088:
1089: EXCEPTION

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

1117: BEGIN
1118:
1119: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Use_Position_flag: 01';
1120: IF (g_po_wf_debug = 'Y') THEN
1121: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
1122: END IF;
1123:
1124:
1125: -- Do nothing in cancel or timeout mode

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

1164: END IF;
1165:
1166: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Use_Position_flag: 02';
1167: IF (g_po_wf_debug = 'Y') THEN
1168: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
1169: END IF;
1170:
1171: EXCEPTION
1172:

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

1202: BEGIN
1203:
1204: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.GetMgr_hr_hier: 01';
1205: IF (g_po_wf_debug = 'Y') THEN
1206: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
1207: END IF;
1208:
1209:
1210: -- Do nothing in cancel or timeout mode

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

1252:
1253: END IF;
1254:
1255: IF (g_po_wf_debug = 'Y') THEN
1256: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
1257: END IF;
1258:
1259: EXCEPTION
1260:

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

1291: BEGIN
1292:
1293: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.GetMgr_po_hier: 01';
1294: IF (g_po_wf_debug = 'Y') THEN
1295: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
1296: END IF;
1297:
1298:
1299: -- Do nothing in cancel or timeout mode

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

1339:
1340: END IF;
1341:
1342: IF (g_po_wf_debug = 'Y') THEN
1343: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
1344: END IF;
1345:
1346: EXCEPTION
1347:

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

1383: */
1384:
1385: x_progress :='In IsForwardToProvided. x_progress= 001';
1386: IF (g_po_wf_debug = 'Y') THEN
1387: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
1388: END IF;
1389:
1390: /* Get_employee_id(), should set the item attribute FORWARD_TO_ID
1391: ** to the id of the username supplied as a forward_to in the notification

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

1405: IF l_forward_to_username_response is NOT NULL THEN
1406:
1407: x_progress :='In IsForwardToProvided. x_progress= 002';
1408: IF (g_po_wf_debug = 'Y') THEN
1409: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
1410: END IF;
1411:
1412:
1413: /* Set the forward_to username so they would get the notification */

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

1421:
1422: x_progress := '003';
1423: x_progress :='In IsForwardToProvided. x_progress= 003';
1424: IF (g_po_wf_debug = 'Y') THEN
1425: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
1426: END IF;
1427:
1428: wf_engine.SetItemAttrText ( itemtype => itemType,
1429: itemkey => itemkey,

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

1438: ELSE
1439:
1440: x_progress :='In IsForwardToProvided. x_progress= 004';
1441: IF (g_po_wf_debug = 'Y') THEN
1442: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
1443: END IF;
1444:
1445: RETURN('N'); -- If no valid user provide, then return 'NO FORWARD-TO'
1446:

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

1449: ELSE
1450:
1451: x_progress :='In IsForwardToProvided. x_progress= 005';
1452: IF (g_po_wf_debug = 'Y') THEN
1453: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
1454: END IF;
1455:
1456: l_forward_to_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1457: itemkey => itemkey,

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

1483: ELSE
1484:
1485: x_progress :='In IsForwardToProvided. x_progress= 007';
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: END IF;

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

1619: END IF;
1620:
1621: x_progress := 'Procedure GetApprovalPathId(). PATH_ID= ' || to_char(l_approval_path_id);
1622: IF (g_po_wf_debug = 'Y') THEN
1623: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
1624: END IF;
1625:
1626: EXCEPTION
1627:

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

1831: x_progress := x_progress || ' employee_id=' || to_char(l_empid) ||
1832: ' supervisor_id=' || to_char(l_superior_id);
1833:
1834: IF (g_po_wf_debug = 'Y') THEN
1835: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
1836: END IF;
1837:
1838: IF l_superior_id IS NOT NULL THEN
1839:

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

2089: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.GetMgrPOHier: approval_path_id= ' ||
2090: to_char(l_approval_path_id) || ' employee_id=' ||
2091: to_char(l_empid) || ' supervisor_id=' || to_char(l_superior_id);
2092: IF (g_po_wf_debug = 'Y') THEN
2093: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
2094: END IF;
2095:
2096:
2097: IF C1%FOUND THEN