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_APPROVAL_LIST_WF1S dependencies on PO_WF_DEBUG_PKG

Line 39: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

35: IF (funcmode='RUN') THEN
36:
37: l_progress := 'Is_Document_Manager_Error_1_2: 001';
38: IF (g_po_wf_debug = 'Y') THEN
39: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
40: END IF;
41:
42: l_error_number:=
43: wf_engine.GetItemAttrNumber ( itemtype => itemType,

Line 50: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

46:
47: l_progress := 'Is_Document_Manager_Error_1_2: 002 - '||
48: to_char(l_error_number);
49: IF (g_po_wf_debug = 'Y') THEN
50: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
51: END IF;
52:
53: IF (l_error_number = 1 or l_error_number = 2) THEN
54: resultout:='COMPLETE:'||'Y';

Line 99: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

95: IF (funcmode='RUN') THEN
96:
97: l_progress := 'Does_Approval_List_Exist: 001';
98: IF (g_po_wf_debug = 'Y') THEN
99: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
100: END IF;
101:
102: l_approval_list_header_id:=
103: wf_engine.GetItemAttrNumber ( itemtype => itemType,

Line 111: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

107: l_progress := 'Does_Approval_List_Exist: 002 - '||
108: 'l_approval_list_header_id: '||
109: to_char(l_approval_list_header_id);
110: IF (g_po_wf_debug = 'Y') THEN
111: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
112: END IF;
113:
114: IF l_approval_list_header_id IS NOT NULL THEN
115: resultout:='COMPLETE:'||'Y';

Line 171: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

167: --set_doc_mgr_context(itemtype, itemkey);
168:
169: l_progress := 'Find_Approval_List: 001';
170: IF (g_po_wf_debug = 'Y') THEN
171: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
172: END IF;
173:
174: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
175: itemkey => itemkey,

Line 201: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

197:
198: l_progress := 'Find_Approval_List: 002-'||to_char(l_document_id)||'-'||
199: l_document_type||'-'||l_document_subtype;
200: IF (g_po_wf_debug = 'Y') THEN
201: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
202: END IF;
203:
204: /* Pass null for itemtype and itemkey to find
205: ** new approval list.

Line 221: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

217: to_char(l_return_code)||
218: ', l_approval_list_header_id: '||
219: to_char(l_approval_list_header_id);
220: IF (g_po_wf_debug = 'Y') THEN
221: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
222: END IF;
223:
224: IF l_return_code = PO_APPROVALLIST_S1.E_SUCCESS THEN
225: wf_engine.SetItemAttrNumber ( itemtype => itemType,

Line 232: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

228: avalue => l_approval_list_header_id);
229:
230: l_progress := 'Find_Approval_List: 004';
231: IF (g_po_wf_debug = 'Y') THEN
232: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
233: END IF;
234:
235: PO_APPROVALLIST_S1.update_approval_list_itemkey(
236: p_approval_list_header_id=>l_approval_list_header_id,

Line 244: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

240:
241: l_progress := 'Find_Approval_List: 005- update_approval_list_itemkey - '||
242: to_char(l_return_code);
243: IF (g_po_wf_debug = 'Y') THEN
244: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
245: END IF;
246:
247: IF l_return_code = PO_APPROVALLIST_S1.E_SUCCESS THEN
248:

Line 323: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

319: IF (funcmode='RUN') THEN
320:
321: l_progress := 'Build_Default_Approval_list: 001';
322: IF (g_po_wf_debug = 'Y') THEN
323: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
324: END IF;
325:
326: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
327: itemkey => itemkey,

Line 342: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

338: l_progress := 'Build_Default_Approval_list: 002-'||
339: to_char(l_document_id)||'-'||
340: l_document_type||'-'||l_document_subtype;
341: IF (g_po_wf_debug = 'Y') THEN
342: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
343: END IF;
344:
345: l_preparer_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
346: itemkey => itemkey,

Line 379: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

375: to_char(l_preparer_id)||'-'||
376: to_char(l_approval_path_id)||'-'||
377: to_char(l_first_approver_id);
378: IF (g_po_wf_debug = 'Y') THEN
379: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
380: END IF;
381:
382: PO_APPROVALLIST_S1.get_default_approval_list(
383: p_first_approver_id=>l_first_approver_id,

Line 396: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

392:
393: l_progress := 'Build_Default_Approval_list: 004-get_default_approval_list-'||
394: to_char(l_return_code);
395: IF (g_po_wf_debug = 'Y') THEN
396: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
397: END IF;
398:
399: IF l_return_code = PO_APPROVALLIST_S1.E_SUCCESS THEN
400:

Line 403: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

399: IF l_return_code = PO_APPROVALLIST_S1.E_SUCCESS THEN
400:
401: l_progress := 'Build_Default_Approval_list: 006-print_approval_list';
402: IF (g_po_wf_debug = 'Y') THEN
403: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
404: END IF;
405:
406: PO_APPROVALLIST_S1.print_approval_list(l_approval_list);
407: PO_APPROVALLIST_S1.save_approval_list(p_document_id=>l_document_id,

Line 421: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

417:
418: l_progress := 'Build_Default_Approval_list: 008-save_approval_list-'||
419: to_char(l_return_code);
420: IF (g_po_wf_debug = 'Y') THEN
421: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
422: END IF;
423:
424: IF l_return_code = PO_APPROVALLIST_S1.E_SUCCESS THEN
425:

Line 430: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

426: l_progress := 'Build_Default_Approval_list: 009-'||
427: 'l_approval_list_header_id: '||
428: to_char(l_approval_list_header_id);
429: IF (g_po_wf_debug = 'Y') THEN
430: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
431: END IF;
432:
433: PO_APPROVALLIST_S1.update_approval_list_itemkey(
434: p_approval_list_header_id=>l_approval_list_header_id,

Line 443: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

439: l_progress := 'Build_Default_Approval_list: 010 '||
440: '- update_approval_list_itemkey-'||
441: to_char(l_return_code);
442: IF (g_po_wf_debug = 'Y') THEN
443: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
444: END IF;
445:
446: IF l_return_code = PO_APPROVALLIST_S1.E_SUCCESS THEN
447: wf_engine.SetItemAttrNumber(itemtype => itemType,

Line 460: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

456: END IF;
457:
458: l_progress := 'Build_Default_Approval_list: 015';
459: IF (g_po_wf_debug = 'Y') THEN
460: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
461: END IF;
462:
463: ELSE
464:

Line 467: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

463: ELSE
464:
465: l_progress := 'Build_Default_Approval_list: 020 ' ||to_char(l_return_code);
466: IF (g_po_wf_debug = 'Y') THEN
467: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
468: END IF;
469:
470:
471: IF l_return_code in

Line 478: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

474:
475: l_progress := 'Build_Default_Approval_list: 021'||
476: '- E_NO_SUPERVISOR_FOUND OR E_NO_ONE_HAS_AUTHORITY';
477: IF (g_po_wf_debug = 'Y') THEN
478: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
479: END IF;
480:
481: resultout:='COMPLETE:'||'FAILURE';
482: return;

Line 496: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

492:
493: ELSE
494: l_progress := 'Build_Default_Approval_list: 022-E_APPROVAL_LIST_BUILD_FAIL';
495: IF (g_po_wf_debug = 'Y') THEN
496: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
497: END IF;
498:
499: raise E_APPROVAL_LIST_BUILD_FAIL;
500: END IF;

Line 507: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

503:
504: l_progress := 'Build_Default_Approval_list: 030 - Build_Default_Approval_list'||
505: ' - SUCCESS';
506: IF (g_po_wf_debug = 'Y') THEN
507: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
508: END IF;
509:
510: resultout:='COMPLETE:'||'SUCCESS';
511: return;

Line 560: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

556: IF (funcmode = 'RUN') THEN
557:
558: l_progress := 'Rebuild_List_Forward: 001';
559: IF (g_po_wf_debug = 'Y') THEN
560: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
561: END IF;
562:
563: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
564: itemkey => itemkey,

Line 590: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

586:
587: l_progress := 'Rebuild_List_Forward: 002-'||to_char(l_document_id)||'-'||
588: l_document_type||'-'||l_document_subtype;
589: IF (g_po_wf_debug = 'Y') THEN
590: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
591: END IF;
592:
593: PO_APPROVALLIST_S1.rebuild_approval_list(
594: p_document_id=>l_document_id,

Line 605: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

601:
602: l_progress := 'Rebuild_List_Forward: 003- rebuild_approval_list - '||
603: l_rebuild_code||'-'||to_char(l_return_code);
604: IF (g_po_wf_debug = 'Y') THEN
605: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
606: END IF;
607:
608:
609: IF l_return_code=PO_APPROVALLIST_S1.E_SUCCESS THEN

Line 676: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

672: IF (funcmode = 'RUN') THEN
673:
674: l_progress := 'Rebuild_List_Doc_Changed: 001';
675: IF (g_po_wf_debug = 'Y') THEN
676: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
677: END IF;
678:
679: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
680: itemkey => itemkey,

Line 706: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

702:
703: l_progress := 'Rebuild_List_Doc_Changed: 002-'||to_char(l_document_id)||'-'||
704: l_document_type||'-'||l_document_subtype;
705: IF (g_po_wf_debug = 'Y') THEN
706: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
707: END IF;
708:
709: PO_APPROVALLIST_S1.rebuild_approval_list(
710: p_document_id=>l_document_id,

Line 721: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

717:
718: l_progress := 'Rebuild_List_Doc_Changed: 003- rebuild_approval_list - '
719: ||l_rebuild_code||'-'||to_char(l_return_code);
720: IF (g_po_wf_debug = 'Y') THEN
721: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
722: END IF;
723:
724: IF l_return_code=PO_APPROVALLIST_S1.E_SUCCESS THEN
725: wf_engine.SetItemAttrNumber ( itemtype => itemType,

Line 792: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

788: IF (funcmode = 'RUN') THEN
789:
790: l_progress := 'Rebuild_List_Invalid_Approver: 001';
791: IF (g_po_wf_debug = 'Y') THEN
792: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
793: END IF;
794:
795: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
796: itemkey => itemkey,

Line 823: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

819: l_progress := 'Rebuild_List_Invalid_Approver: 002-'||
820: to_char(l_document_id)||'-'||
821: l_document_type||'-'||l_document_subtype;
822: IF (g_po_wf_debug = 'Y') THEN
823: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
824: END IF;
825:
826: PO_APPROVALLIST_S1.rebuild_approval_list(
827: p_document_id=>l_document_id,

Line 838: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

834:
835: l_progress := 'Rebuild_List_Invalid_Approver: 003- rebuild_approval_list - '
836: ||l_rebuild_code||'-'||to_char(l_return_code);
837: IF (g_po_wf_debug = 'Y') THEN
838: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
839: END IF;
840:
841: IF l_return_code=PO_APPROVALLIST_S1.E_SUCCESS THEN
842: wf_engine.SetItemAttrNumber ( itemtype => itemType,

Line 913: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

909: IF (funcmode = 'RUN') THEN
910:
911: l_progress := 'Get_Next_Approver: 001';
912: IF (g_po_wf_debug = 'Y') THEN
913: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
914: END IF;
915:
916: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
917: itemkey => itemkey,

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

939:
940: l_progress := 'Get_Next_Approver: 002-'||to_char(l_document_id)||'-'||
941: l_document_type||'-'||l_document_subtype;
942: IF (g_po_wf_debug = 'Y') THEN
943: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
944: END IF;
945:
946: PO_APPROVALLIST_S1.get_next_approver(l_document_id,
947: l_document_type,

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

954: l_progress := 'Get_Next_Approver: 003- get_next_approver - '||
955: to_char(l_next_approver_id)||'-'||
956: to_char(l_return_code);
957: IF (g_po_wf_debug = 'Y') THEN
958: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
959: END IF;
960:
961:
962: IF l_return_code = PO_APPROVALLIST_S1.E_SUCCESS THEN

Line 985: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

981:
982: l_progress := 'Get_Next_Approver: 004- GetUserName - '||
983: l_next_approver_user_name;
984: IF (g_po_wf_debug = 'Y') THEN
985: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
986: END IF;
987:
988: wf_engine.SetItemAttrText( itemtype => itemType,
989: itemkey => itemkey,

Line 1069: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

1065:
1066: BEGIN
1067: l_progress := 'Is_Approval_List_Empty: 001';
1068: IF (g_po_wf_debug = 'Y') THEN
1069: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1070: END IF;
1071:
1072: IF (funcmode='RUN') THEN
1073:

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

1098:
1099: l_progress := 'Is_Approval_List_Empty: 002-'||to_char(l_document_id)||'-'||
1100: l_document_type||'-'||l_document_subtype;
1101: IF (g_po_wf_debug = 'Y') THEN
1102: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1103: END IF;
1104:
1105:
1106: PO_APPROVALLIST_S1.is_approval_list_exhausted(p_document_id=>l_document_id,

Line 1117: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

1113:
1114: l_progress := 'Is_Approval_List_Empty: 005- is_approval_list_exhausted -'||
1115: to_char(l_return_code);
1116: IF (g_po_wf_debug = 'Y') THEN
1117: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1118: END IF;
1119:
1120: IF l_return_code = PO_APPROVALLIST_S1.E_SUCCESS THEN
1121: IF l_result THEN

Line 1171: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

1167: BEGIN
1168:
1169: l_progress := 'Insert_Action_History: 001';
1170: IF (g_po_wf_debug = 'Y') THEN
1171: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1172: END IF;
1173:
1174: IF (funcmode='RUN') THEN
1175:

Line 1209: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

1205: x_approval_path_id=>l_approval_path_id);
1206:
1207: l_progress := 'Insert_Action_History: 005 - Forward_Action_History';
1208: IF (g_po_wf_debug = 'Y') THEN
1209: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1210: END IF;
1211:
1212: /* Reset the FORWARD_TO_USERNAME_RESPONSE attribute */
1213: wf_engine.SetItemAttrText (itemtype => itemtype,

Line 1231: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

1227: END IF; -- run mode
1228:
1229: l_progress := 'Insert_Action_History: 999';
1230: IF (g_po_wf_debug = 'Y') THEN
1231: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1232: END IF;
1233:
1234: EXCEPTION
1235: WHEN OTHERS THEN

Line 1269: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

1265: BEGIN
1266:
1267: l_progress := 'Update_Action_History_Approve: 001';
1268: IF (g_po_wf_debug = 'Y') THEN
1269: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1270: END IF;
1271:
1272: IF (funcmode='RUN') THEN
1273:

Line 1306: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

1302: l_progress := 'Update_Action_History_Approve: 002-'||
1303: to_char(l_document_id)||'-'||
1304: l_document_type||'-'||l_document_subtype;
1305: IF (g_po_wf_debug = 'Y') THEN
1306: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1307: END IF;
1308:
1309: /* update po action history */
1310: PO_APPROVAL_LIST_HISTORY_SV.Update_Action_History(itemtype=>itemtype,

Line 1319: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

1315: x_note=>l_note);
1316:
1317: l_progress := 'Update_Action_History_Approve: 005 - Update_Action_History';
1318: IF (g_po_wf_debug = 'Y') THEN
1319: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1320: END IF;
1321:
1322: /* need to release locks for doc mgr */
1323: -- commit;

Line 1327: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

1323: -- commit;
1324:
1325: l_progress := 'Update_Action_History_Approve: 006';
1326: IF (g_po_wf_debug = 'Y') THEN
1327: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1328: END IF;
1329:
1330: resultout:='COMPLETE' || ':' || 'ACTIVITY_PERFORMED';
1331: return;

Line 1337: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

1333: END IF; -- run mode
1334:
1335: l_progress := 'Update_Action_History_Approve: 999';
1336: IF (g_po_wf_debug = 'Y') THEN
1337: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1338: END IF;
1339:
1340:
1341: EXCEPTION

Line 1376: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

1372:
1373: BEGIN
1374: l_progress := 'Update_Action_History_Timeout: 001';
1375: IF (g_po_wf_debug = 'Y') THEN
1376: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1377: END IF;
1378:
1379: IF (funcmode='RUN') THEN
1380:

Line 1410: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

1406: to_char(l_document_id)||'-'||
1407: l_document_type||'-'||l_document_subtype;
1408:
1409: IF (g_po_wf_debug = 'Y') THEN
1410: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1411: END IF;
1412:
1413: /* update po action history */
1414: PO_APPROVAL_LIST_HISTORY_SV.Update_Action_History(itemtype=>itemtype,

Line 1424: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

1420:
1421: l_progress := 'Update_Action_History_Timeout: 003- Update_Action_History';
1422:
1423: IF (g_po_wf_debug = 'Y') THEN
1424: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1425: END IF;
1426:
1427: l_progress := 'Update_Action_History_App_Fwd: 004';
1428:

Line 1430: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

1426:
1427: l_progress := 'Update_Action_History_App_Fwd: 004';
1428:
1429: IF (g_po_wf_debug = 'Y') THEN
1430: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1431: END IF;
1432:
1433: resultout:='COMPLETE' || ':' || 'ACTIVITY_PERFORMED';
1434: return;

Line 1440: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

1436: END IF; -- run mode
1437:
1438: l_progress := 'Update_Action_History_Timeout: 999';
1439: IF (g_po_wf_debug = 'Y') THEN
1440: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1441: END IF;
1442:
1443: EXCEPTION
1444: WHEN OTHERS THEN

Line 1478: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

1474:
1475: BEGIN
1476: l_progress := 'Update_Action_History_App_Fwd: 001';
1477: IF (g_po_wf_debug = 'Y') THEN
1478: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1479: END IF;
1480:
1481: IF (funcmode='RUN') THEN
1482:

Line 1515: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

1511: l_progress := 'Update_Action_History_App_Fwd: 002-'||
1512: to_char(l_document_id)||'-'||
1513: l_document_type||'-'||l_document_subtype;
1514: IF (g_po_wf_debug = 'Y') THEN
1515: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1516: END IF;
1517:
1518: /* update po action history */
1519: PO_APPROVAL_LIST_HISTORY_SV.Update_Action_History(itemtype=>itemtype,

Line 1528: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

1524: x_note=>l_note);
1525:
1526: l_progress := 'Update_Action_History_App_Fwd: 005- Update_Action_History';
1527: IF (g_po_wf_debug = 'Y') THEN
1528: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1529: END IF;
1530:
1531: /* need to release locks for doc mgr */
1532: -- commit;

Line 1536: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

1532: -- commit;
1533:
1534: l_progress := 'Update_Action_History_App_Fwd: 006';
1535: IF (g_po_wf_debug = 'Y') THEN
1536: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1537: END IF;
1538:
1539: resultout:='COMPLETE' || ':' || 'ACTIVITY_PERFORMED';
1540: return;

Line 1546: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

1542: END IF; -- run mode
1543:
1544: l_progress := 'Update_Action_History_App_Fwd: 999';
1545: IF (g_po_wf_debug = 'Y') THEN
1546: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1547: END IF;
1548:
1549: EXCEPTION
1550: WHEN OTHERS THEN

Line 1583: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

1579:
1580: BEGIN
1581: l_progress := 'Update_Action_History_Forward: 001';
1582: IF (g_po_wf_debug = 'Y') THEN
1583: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1584: END IF;
1585:
1586: IF (funcmode='RUN') THEN
1587:

Line 1620: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

1616: l_progress := 'Update_Action_History_Forward: 002-'||
1617: to_char(l_document_id)||'-'||
1618: l_document_type||'-'||l_document_subtype;
1619: IF (g_po_wf_debug = 'Y') THEN
1620: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1621: END IF;
1622:
1623: /* update po action history */
1624: PO_APPROVAL_LIST_HISTORY_SV.Update_Action_History(itemtype=>itemtype,

Line 1633: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

1629: x_note=>l_note);
1630:
1631: l_progress := 'Update_Action_History_Forward: 005- Update_Action_History';
1632: IF (g_po_wf_debug = 'Y') THEN
1633: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1634: END IF;
1635:
1636: /* need to release locks for doc mgr */
1637: -- commit;

Line 1641: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

1637: -- commit;
1638:
1639: l_progress := 'Update_Action_History_Forward: 006';
1640: IF (g_po_wf_debug = 'Y') THEN
1641: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1642: END IF;
1643:
1644: resultout:='COMPLETE' || ':' || 'ACTIVITY_PERFORMED';
1645: return;

Line 1650: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

1646:
1647: END IF; -- run mode
1648: l_progress := 'Update_Action_History_Forward: 999';
1649: IF (g_po_wf_debug = 'Y') THEN
1650: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1651: END IF;
1652:
1653: EXCEPTION
1654: WHEN OTHERS THEN

Line 1687: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

1683:
1684: BEGIN
1685: l_progress := 'Update_Action_History_Reject: 001';
1686: IF (g_po_wf_debug = 'Y') THEN
1687: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1688: END IF;
1689:
1690: IF (funcmode='RUN') THEN
1691:

Line 1724: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

1720: l_progress := 'Update_Action_History_Reject: 002-'||
1721: to_char(l_document_id)||'-'||
1722: l_document_type||'-'||l_document_subtype;
1723: IF (g_po_wf_debug = 'Y') THEN
1724: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1725: END IF;
1726:
1727: /* update po action history */
1728: PO_APPROVAL_LIST_HISTORY_SV.Update_Action_History(itemtype=>itemtype,

Line 1737: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

1733: x_note=>l_note);
1734:
1735: l_progress := 'Update_Action_History_Reject: 005 - Update_Action_History';
1736: IF (g_po_wf_debug = 'Y') THEN
1737: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1738: END IF;
1739:
1740: /* need to release locks for doc mgr */
1741: -- commit;

Line 1745: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

1741: -- commit;
1742:
1743: l_progress := 'Update_Action_History_Reject: 006';
1744: IF (g_po_wf_debug = 'Y') THEN
1745: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1746: END IF;
1747:
1748: resultout:='COMPLETE' || ':' || 'ACTIVITY_PERFORMED';
1749: return;

Line 1754: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

1750:
1751: END IF; -- run mode
1752: l_progress := 'Update_Action_History_Reject: 999';
1753: IF (g_po_wf_debug = 'Y') THEN
1754: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1755: END IF;
1756:
1757: EXCEPTION
1758: WHEN OTHERS THEN

Line 1877: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

1873: BEGIN
1874:
1875: l_progress := 'Update_Approval_List_Response: 001- at beginning of function';
1876: IF (g_po_wf_debug = 'Y') THEN
1877: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1878: END IF;
1879:
1880: /* Bug# 1431401: kagarwal
1881: ** Desc: We need to set the doc manager context as the response may

Line 1923: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

1919:
1920: l_progress := 'Update_Approval_List_Response : 001-2'||
1921: 'exp_result: ' || exp_result || ' actid: ' || to_char(actid);
1922: IF (g_po_wf_debug = 'Y') THEN
1923: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1924: END IF;
1925:
1926: if exp_result = 'PO_SUCCESS_FAILURE' then
1927: retnew := TRUE;

Line 1943: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

1939: END IF;
1940:
1941: l_progress := 'Update_Approval_List_Response: 002';
1942: IF (g_po_wf_debug = 'Y') THEN
1943: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1944: END IF;
1945:
1946: OPEN c_group_id(itemtype, itemkey, 'PO_REQ_APPROVE');
1947: FETCH c_group_id INTO l_group_id;

Line 1952: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

1948: CLOSE c_group_id;
1949:
1950: l_progress := 'Update_Approval_List_Response: 003';
1951: IF (g_po_wf_debug = 'Y') THEN
1952: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1953: END IF;
1954:
1955: /* start of fix for 1263201 */
1956: OPEN c_canceled_notif (l_group_id);

Line 1966: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

1962: CLOSE c_canceled_notif;
1963:
1964: l_progress := 'Update_Approval_List_Response: 0031';
1965: IF (g_po_wf_debug = 'Y') THEN
1966: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1967: END IF;
1968:
1969: l_group_id := NULL;
1970:

Line 1977: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

1973: CLOSE c_group_id;
1974:
1975: l_progress := 'Update_Approval_List_Response: 0032';
1976: IF (g_po_wf_debug = 'Y') THEN
1977: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1978: END IF;
1979:
1980: OPEN c_canceled_notif (l_group_id);
1981: FETCH c_canceled_notif into is_notif_canceled;

Line 1990: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

1986: CLOSE c_canceled_notif;
1987:
1988: l_progress := 'Update_Approval_List_Response: 0033';
1989: IF (g_po_wf_debug = 'Y') THEN
1990: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1991: END IF;
1992:
1993: l_group_id := NULL;
1994:

Line 2001: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

1997: CLOSE c_group_id;
1998:
1999: l_progress := 'Update_Approval_List_Response: 0034';
2000: IF (g_po_wf_debug = 'Y') THEN
2001: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2002: END IF;
2003:
2004: OPEN c_canceled_notif (l_group_id);
2005: FETCH c_canceled_notif into is_notif_canceled;

Line 2009: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

2005: FETCH c_canceled_notif into is_notif_canceled;
2006:
2007: l_progress := 'Update_Approval_List_Response: 00341';
2008: IF (g_po_wf_debug = 'Y') THEN
2009: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2010: END IF;
2011:
2012: -- check if PO_REQ_REMINDER1 notification is canceled
2013:

Line 2042: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

2038: /* end of fix for 1263201 */
2039:
2040: l_progress := 'Update_Approval_List_Response: 0035';
2041: IF (g_po_wf_debug = 'Y') THEN
2042: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2043: END IF;
2044:
2045: IF l_group_id is NOT NULL THEN
2046: OPEN c_response(l_group_id);

Line 2052: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

2048: CLOSE c_response;
2049:
2050: l_progress := 'Update_Approval_List_Response: 004';
2051: IF (g_po_wf_debug = 'Y') THEN
2052: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2053: END IF;
2054:
2055: IF l_group_id is NOT NULL THEN
2056:

Line 2088: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

2084:
2085:
2086: l_progress := 'Update_Approval_List_Response: 005';
2087: IF (g_po_wf_debug = 'Y') THEN
2088: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2089: END IF;
2090:
2091: wf_engine.SetItemAttrNumber(itemtype => itemType,
2092: itemkey => itemkey,

Line 2105: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

2101: l_responder_disp_name);
2102:
2103: l_progress := 'Update_Approval_List_Response: 007 -' || l_responder_user_name;
2104: IF (g_po_wf_debug = 'Y') THEN
2105: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2106: END IF;
2107:
2108: wf_engine.SetItemAttrText( itemtype => itemType,
2109: itemkey => itemkey,

Line 2120: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

2116: avalue => l_responder_disp_name);
2117:
2118: l_progress := 'Update_Approval_List_Response: 008' ;
2119: IF (g_po_wf_debug = 'Y') THEN
2120: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2121: END IF;
2122:
2123: IF (INSTR(l_value, 'FORWARD') > 0) THEN
2124: l_forward_to_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

Line 2131: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

2127: END IF;
2128:
2129: l_progress := 'Update_Approval_List_Response: 009' ;
2130: IF (g_po_wf_debug = 'Y') THEN
2131: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2132: END IF;
2133:
2134: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
2135: itemkey => itemkey,

Line 2159: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

2155: to_char(l_approver_id)||
2156: ' RES'||to_char(l_responder_id)||
2157: ' FWD'||to_char(l_forward_to_id);
2158: IF (g_po_wf_debug = 'Y') THEN
2159: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2160: END IF;
2161:
2162: PO_APPROVALLIST_S1.update_approval_list_response(
2163: p_document_id=>l_document_id,

Line 2178: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

2174: p_return_code=>l_return_code);
2175:
2176: l_progress := 'Update_Approval_List_Response: 011'||to_char(l_return_code);
2177: IF (g_po_wf_debug = 'Y') THEN
2178: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2179: END IF;
2180:
2181: IF l_return_code = PO_APPROVALLIST_S1.E_SUCCESS THEN
2182:

Line 2188: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

2184: IF l_value in ('FORWARD', 'APPROVE_AND_FORWARD') THEN
2185:
2186: l_progress := 'Update_Approval_List_Response: 012';
2187: IF (g_po_wf_debug = 'Y') THEN
2188: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2189: END IF;
2190:
2191: PO_APPROVALLIST_S1.rebuild_approval_list(
2192: p_document_id=>l_document_id,

Line 2202: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

2198: p_approval_list_header_id=>l_approval_list_header_id);
2199:
2200: l_progress := 'Update_Approval_List_Response : 013'||to_char(l_return_code);
2201: IF (g_po_wf_debug = 'Y') THEN
2202: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2203: END IF;
2204:
2205: IF l_return_code = PO_APPROVALLIST_S1.E_SUCCESS THEN
2206: wf_engine.SetItemAttrNumber(itemtype => itemType,

Line 2249: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

2245: ELSE
2246: /* no need to rebuild for approve or reject actions */
2247: l_progress := 'Update_Approval_List_Response : 100';
2248: IF (g_po_wf_debug = 'Y') THEN
2249: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2250: END IF;
2251:
2252: /* Bug# 1712121 */
2253: if retnew = TRUE then

Line 2269: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

2265:
2266: END IF; -- c_group_id
2267: l_progress := 'Update_Approval_List_Response : 999';
2268: IF (g_po_wf_debug = 'Y') THEN
2269: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2270: END IF;
2271:
2272: RAISE E_UPDATE_RESPONSE_FAIL;
2273: END IF; -- run mode

Line 2405: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

2401: BEGIN
2402:
2403: l_progress := 'Update_App_List_Resp_Success: 001- at beginning of function';
2404: IF (g_po_wf_debug = 'Y') THEN
2405: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2406: END IF;
2407:
2408: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => itemType,
2409: itemkey => itemkey,

Line 2425: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

2421: avalue => fnd_global.RESP_APPL_ID);
2422:
2423: l_progress := 'Update_App_List_Resp_Success: 002';
2424: IF (g_po_wf_debug = 'Y') THEN
2425: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2426: END IF;
2427:
2428: OPEN c_group_id(itemtype, itemkey, 'PO_REQ_APPROVE', 'PO_REQ_INVALID_FORWARD', 'UNABLE_TO_RESERVE', 'PO_REQ_APPROVE_SIMPLE');
2429:

Line 2435: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

2431: CLOSE c_group_id;
2432:
2433: l_progress := 'Update_App_List_Resp_Success: 003';
2434: IF (g_po_wf_debug = 'Y') THEN
2435: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2436: END IF;
2437:
2438: /* start of fix for 1263201 */
2439: OPEN c_canceled_notif (l_group_id);

Line 2450: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

2446: CLOSE c_canceled_notif;
2447:
2448: l_progress := 'Update_App_List_Resp_Success: 0031';
2449: IF (g_po_wf_debug = 'Y') THEN
2450: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2451: END IF;
2452:
2453: l_group_id := NULL;
2454:

Line 2461: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

2457: CLOSE c_group_id;
2458:
2459: l_progress := 'Update_App_List_Resp_Success: 0032';
2460: IF (g_po_wf_debug = 'Y') THEN
2461: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2462: END IF;
2463:
2464: OPEN c_canceled_notif (l_group_id);
2465: FETCH c_canceled_notif into is_notif_canceled;

Line 2474: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

2470: CLOSE c_canceled_notif;
2471:
2472: l_progress := 'Update_App_List_Resp_Success: 0033';
2473: IF (g_po_wf_debug = 'Y') THEN
2474: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2475: END IF;
2476: l_group_id := NULL;
2477:
2478: OPEN c_group_id(itemtype, itemkey, 'PO_REQ_REMINDER1', 'PO_REQ_INVALID_FORWARD_R2','UNABLE_TO_RESERVE', 'PO_REQ_APPROVE_SIMPLE');

Line 2484: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

2480: CLOSE c_group_id;
2481:
2482: l_progress := 'Update_App_List_Resp_Success: 0034';
2483: IF (g_po_wf_debug = 'Y') THEN
2484: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2485: END IF;
2486:
2487: OPEN c_canceled_notif (l_group_id);
2488: FETCH c_canceled_notif into is_notif_canceled;

Line 2492: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

2488: FETCH c_canceled_notif into is_notif_canceled;
2489:
2490: l_progress := 'Update_App_List_Resp_Success: 00341';
2491: IF (g_po_wf_debug = 'Y') THEN
2492: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2493: END IF;
2494:
2495: -- check if PO_REQ_REMINDER1 notification is canceled
2496:

Line 2525: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

2521: /* end of fix for 1263201 */
2522:
2523: l_progress := 'Update_App_List_Resp_Success: 0035';
2524: IF (g_po_wf_debug = 'Y') THEN
2525: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2526: END IF;
2527:
2528: IF l_group_id is NOT NULL THEN
2529: OPEN c_response(l_group_id);

Line 2535: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

2531: CLOSE c_response;
2532:
2533: l_progress := 'Update_App_List_Resp_Success: 004';
2534: IF (g_po_wf_debug = 'Y') THEN
2535: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2536: END IF;
2537:
2538: -- IF l_group_id is NOT NULL THEN
2539:

Line 2570: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

2566: END IF;
2567:
2568: l_progress := 'Update_App_List_Resp_Success: 005';
2569: IF (g_po_wf_debug = 'Y') THEN
2570: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2571: END IF;
2572:
2573: wf_engine.SetItemAttrNumber(itemtype => itemType,
2574: itemkey => itemkey,

Line 2587: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

2583: l_responder_disp_name);
2584:
2585: l_progress := 'Update_App_List_Resp_Success: 007 -' || l_responder_user_name;
2586: IF (g_po_wf_debug = 'Y') THEN
2587: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2588: END IF;
2589:
2590: wf_engine.SetItemAttrText( itemtype => itemType,
2591: itemkey => itemkey,

Line 2602: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

2598: avalue => l_responder_disp_name);
2599:
2600: l_progress := 'Update_App_List_Resp_Success: 008' ;
2601: IF (g_po_wf_debug = 'Y') THEN
2602: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2603: END IF;
2604:
2605: IF (INSTR(response, 'FORWARD') > 0) THEN
2606: forwardToId := wf_engine.GetItemAttrNumber (itemtype => itemtype,

Line 2613: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

2609: END IF;
2610:
2611: l_progress := 'Update_App_List_Resp_Success: 009' ;
2612: IF (g_po_wf_debug = 'Y') THEN
2613: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2614: END IF;
2615:
2616:
2617: END IF; -- c_group_id

Line 2620: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

2616:
2617: END IF; -- c_group_id
2618: l_progress := 'Update_App_List_Resp_Success : 999';
2619: IF (g_po_wf_debug = 'Y') THEN
2620: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2621: END IF;
2622:
2623: EXCEPTION
2624:

Line 2700: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

2696: BEGIN
2697:
2698: l_progress := 'Update_App_List_Resp_Success: 001- at beginning of function';
2699: IF (g_po_wf_debug = 'Y') THEN
2700: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2701: END IF;
2702:
2703: IF (funcmode='RUN') THEN
2704:

Line 2750: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

2746: to_char(l_approver_id)||
2747: ' RES'||to_char(l_responder_id)||
2748: ' FWD'||to_char(l_forward_to_id);
2749: IF (g_po_wf_debug = 'Y') THEN
2750: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2751: END IF;
2752:
2753: PO_APPROVALLIST_S1.update_approval_list_response(
2754: p_document_id=>l_document_id,

Line 2769: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

2765: p_return_code=>l_return_code);
2766:
2767: l_progress := 'Update_App_List_Resp_Success: 011'||to_char(l_return_code);
2768: IF (g_po_wf_debug = 'Y') THEN
2769: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2770: END IF;
2771:
2772: IF l_return_code = PO_APPROVALLIST_S1.E_SUCCESS THEN
2773:

Line 2779: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

2775: IF l_value in ('FORWARD', 'APPROVE_AND_FORWARD') THEN
2776:
2777: l_progress := 'Update_App_List_Resp_Success: 012';
2778: IF (g_po_wf_debug = 'Y') THEN
2779: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2780: END IF;
2781: PO_APPROVALLIST_S1.rebuild_approval_list(
2782: p_document_id=>l_document_id,
2783: p_document_type=>l_document_type,

Line 2792: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

2788: p_approval_list_header_id=>l_approval_list_header_id);
2789:
2790: l_progress := 'Update_App_List_Resp_Success : 013'||to_char(l_return_code);
2791: IF (g_po_wf_debug = 'Y') THEN
2792: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2793: END IF;
2794:
2795: IF l_return_code = PO_APPROVALLIST_S1.E_SUCCESS THEN
2796: wf_engine.SetItemAttrNumber(itemtype => itemType,

Line 2845: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

2841: END IF; -- update success
2842:
2843: l_progress := 'Update_App_List_Resp_Success : 999';
2844: IF (g_po_wf_debug = 'Y') THEN
2845: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2846: END IF;
2847:
2848: RAISE E_UPDATE_RESPONSE_FAIL;
2849: END IF; -- run mode

Line 3011: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

3007:
3008: BEGIN
3009: l_progress := 'set_doc_mgr_err: 001';
3010: IF (g_po_wf_debug = 'Y') THEN
3011: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
3012: END IF;
3013:
3014: IF p_return_code = PO_APPROVALLIST_S1.E_DOC_MGR_TIMEOUT THEN
3015: PO_REQAPPROVAL_ACTION.doc_mgr_err_num := 1;

Line 3025: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

3021:
3022: l_progress := 'set_doc_mgr_err: 020: error number = '||
3023: to_char(PO_REQAPPROVAL_ACTION.doc_mgr_err_num);
3024: IF (g_po_wf_debug = 'Y') THEN
3025: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
3026: END IF;
3027:
3028: IF (p_error_stack.COUNT > 0) THEN
3029: PO_APPROVALLIST_S1.retrieve_messages(p_error_stack,

Line 3042: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

3038:
3039: l_progress := 'set_doc_mgr_err: 050: error msg = '||
3040: PO_REQAPPROVAL_ACTION.sysadmin_err_msg;
3041: IF (g_po_wf_debug = 'Y') THEN
3042: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
3043: END IF;
3044:
3045: End If;
3046:

Line 3053: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

3049: END IF;
3050:
3051: l_progress := 'set_doc_mgr_err: 999';
3052: IF (g_po_wf_debug = 'Y') THEN
3053: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
3054: END IF;
3055:
3056: EXCEPTION
3057: WHEN OTHERS THEN

Line 3086: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

3082: BEGIN
3083:
3084: l_progress := 'Insert_Res_Action_History: 001';
3085: IF (g_po_wf_debug = 'Y') THEN
3086: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
3087: END IF;
3088:
3089: IF (funcmode='RUN') THEN
3090:

Line 3122: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

3118: x_approver_id =>l_approver_id);
3119:
3120: l_progress := 'Insert_Res_Action_History: 005 - Reserve_Action_History';
3121: IF (g_po_wf_debug = 'Y') THEN
3122: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
3123: END IF;
3124:
3125: resultout:='COMPLETE' || ':' || 'ACTIVITY_PERFORMED';
3126: return;

Line 3132: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

3128: END IF; -- run mode
3129:
3130: l_progress := 'Insert_Res_Action_History: 999';
3131: IF (g_po_wf_debug = 'Y') THEN
3132: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
3133: END IF;
3134:
3135: EXCEPTION
3136: WHEN OTHERS THEN