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

Line 37: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);

33:
34:
35: l_progress := 'PO_APPROVAL_REMINDER_SV.Select_Unapprove_docs: 01 - BEGIN ';
36: IF (g_po_wf_debug = 'Y') THEN
37: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);
38: END IF;
39:
40:
41: Process_unapprove_reqs;

Line 57: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);

53: process_po_temp_labor_lines; --
54:
55: l_progress := 'PO_APPROVAL_REMINDER_SV.Select_Unapprove_docs: 900 - END ';
56: IF (g_po_wf_debug = 'Y') THEN
57: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);
58: END IF;
59:
60:
61: EXCEPTION

Line 69: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);

65: wf_core.context ('PO_APPROVAL_REMINDER_SV','Select_Unapprove_docs ' || l_progress);
66: l_progress := 'PO_APPROVAL_REMINDER_SV.Select_Unapprove_docs: 990 - ' ||
67: 'EXCEPTION sql error: ' || sqlcode;
68: IF (g_po_wf_debug = 'Y') THEN
69: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);
70: END IF;
71:
72: RAISE;
73:

Line 128: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);

124:
125:
126: l_progress := 'PO_APPROVAL_REMINDER_SV.Process unapprove_reqs: 01 - BEGIN ';
127: IF (g_po_wf_debug = 'Y') THEN
128: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);
129: END IF;
130:
131:
132: l_itemkey := ' ';

Line 174: -- /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);

170: NULL;
171:
172: l_progress := 'PO_APPROVAL_REMINDER_SV.Process_unapprove_reqs: 05 ' ||
173: 'open WF item key exists ' ||l_itemkey;
174: -- /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);
175:
176: ELSE
177:
178:

Line 201: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);

197:
198: l_progress := 'PO_APPROVAL_REMINDER_SV.Process_unapprove_reqs: 10 ' ||
199: 'Start WF item key =' ||l_itemkey;
200: IF (g_po_wf_debug = 'Y') THEN
201: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);
202: END IF;
203:
204: PO_APPROVAL_REMINDER_SV.Start_Approval_Reminder (l_doc_header_id,
205: l_doc_number,

Line 231: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);

227:
228:
229: l_progress := 'PO_APPROVAL_REMINDER_SV.Process unapprove_reqs: 900 - END ';
230: IF (g_po_wf_debug = 'Y') THEN
231: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);
232: END IF;
233:
234:
235: EXCEPTION

Line 241: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);

237: wf_core.context ('PO_APPROVAL_REMINDER_SV','Process_Unapprove_reqs','No data found');
238: l_progress := 'PO_APPROVAL_REMINDER_SV.Process unapprove_reqs: 901 - ' ||
239: 'EXCEPTION - no data found sql error: ' || sqlcode;
240: IF (g_po_wf_debug = 'Y') THEN
241: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);
242: END IF;
243:
244:
245: WHEN OTHERS THEN

Line 250: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);

246: wf_core.context ('PO_APPROVAL_REMINDER_SV','Process_Unapprove_reqs','SQL error ' || sqlcode);
247: l_progress := 'PO_APPROVAL_REMINDER_SV.Process unapprove_reqs: 990 - ' ||
248: 'EXCEPTION - sql error: ' || sqlcode;
249: IF (g_po_wf_debug = 'Y') THEN
250: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);
251: END IF;
252:
253: RAISE;
254:

Line 311: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);

307:
308:
309: l_progress := 'PO_APPROVAL_REMINDER_SV.Process unapprove_pos: 01 - BEGIN ';
310: IF (g_po_wf_debug = 'Y') THEN
311: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);
312: END IF;
313:
314:
315: l_itemkey := ' ';

Line 364: -- /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);

360: NULL;
361:
362: l_progress := 'PO_APPROVAL_REMINDER_SV.Process_unapprove_pos: 05 ' ||
363: 'open WF item key exists ' ||l_itemkey;
364: -- /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);
365:
366: ELSE
367:
368:

Line 390: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);

386:
387: l_progress := 'PO_APPROVAL_REMINDER_SV.Process_unapprove_pos: 10 ' ||
388: 'Start WF item key =' ||l_itemkey;
389: IF (g_po_wf_debug = 'Y') THEN
390: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);
391: END IF;
392:
393: PO_APPROVAL_REMINDER_SV.Start_Approval_Reminder (l_doc_header_id,
394: l_doc_number,

Line 421: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);

417:
418:
419: l_progress := 'PO_APPROVAL_REMINDER_SV.Process unapprove_pos: 900 - END ';
420: IF (g_po_wf_debug = 'Y') THEN
421: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);
422: END IF;
423:
424: EXCEPTION
425: WHEN NO_DATA_FOUND THEN

Line 431: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);

427:
428: l_progress := 'PO_APPROVAL_REMINDER_SV.Process unapprove_pos: 901 - ' ||
429: 'EXCEPTION - no data found sql error: ' || sqlcode;
430: IF (g_po_wf_debug = 'Y') THEN
431: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);
432: END IF;
433:
434: WHEN OTHERS THEN
435: wf_core.context ('PO_APPROVAL_REMINDER_SV','Process_Unapprove_pos','SQL error ' || sqlcode);

Line 440: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);

436:
437: l_progress := 'PO_APPROVAL_REMINDER_SV.Process unapprove_pos: 990 - ' ||
438: 'EXCEPTION - sql error: ' || sqlcode;
439: IF (g_po_wf_debug = 'Y') THEN
440: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);
441: END IF;
442:
443:
444: RAISE;

Line 504: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);

500:
501:
502: l_progress := 'PO_APPROVAL_REMINDER_SV.Process_unapprove_releases: 01 - BEGIN ';
503: IF (g_po_wf_debug = 'Y') THEN
504: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);
505: END IF;
506:
507: l_itemkey := ' ';
508:

Line 556: -- /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);

552: NULL;
553:
554: l_progress := 'PO_APPROVAL_REMINDER_SV.Process_unapprove_releases: 05 ' ||
555: 'open WF item key exists ' ||l_itemkey;
556: -- /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);
557:
558:
559: ELSE
560:

Line 584: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);

580:
581: l_progress := 'PO_APPROVAL_REMINDER_SV.Process_unapprove_releases: 10 ' ||
582: 'Start WF item key =' ||l_itemkey;
583: IF (g_po_wf_debug = 'Y') THEN
584: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);
585: END IF;
586:
587: PO_APPROVAL_REMINDER_SV.Start_Approval_Reminder (l_doc_header_id,
588: l_doc_number,

Line 613: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);

609: CLOSE Unapprove_REL;
610:
611: l_progress := 'PO_APPROVAL_REMINDER_SV.Process unapprove_releases: 900 - END ';
612: IF (g_po_wf_debug = 'Y') THEN
613: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);
614: END IF;
615:
616: EXCEPTION
617: WHEN NO_DATA_FOUND THEN

Line 622: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);

618: wf_core.context ('PO_APPROVAL_REMINDER_SV','Process_Unapprove_releases','No data found');
619: l_progress := 'PO_APPROVAL_REMINDER_SV.Process_Unapprove_releases: 901 - ' ||
620: 'EXCEPTION - no data found sql error: ' || sqlcode;
621: IF (g_po_wf_debug = 'Y') THEN
622: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);
623: END IF;
624:
625:
626: WHEN OTHERS THEN

Line 631: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);

627: wf_core.context ('PO_APPROVAL_REMINDER_SV','Process_Unapprove_releases','SQL error ' || sqlcode);
628: l_progress := 'PO_APPROVAL_REMINDER_SV.Process_Unapprove_releases: 990 - ' ||
629: 'EXCEPTION - sql error: ' || sqlcode;
630: IF (g_po_wf_debug = 'Y') THEN
631: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);
632: END IF;
633:
634: RAISE;
635:

Line 706: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);

702:
703:
704: l_progress := 'PO_APPROVAL_REMINDER_SV.Process_po_acceptance: 01 - BEGIN ';
705: IF (g_po_wf_debug = 'Y') THEN
706: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);
707: END IF;
708:
709:
710: l_itemkey := '';

Line 761: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);

757:
758: -- bug 3896181
759: l_progress := 'PO_APPROVAL_REMINDER_SV.Process_po_acceptance: 02 - item key exists ';
760: IF (g_po_wf_debug = 'Y') THEN
761: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);
762: end if;
763: -- bug 3896181
764:
765: IF trunc(l_acceptance_due_date) > trunc(sysdate) THEN

Line 770: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);

766:
767: -- bug 3896181
768: l_progress := 'PO_APPROVAL_REMINDER_SV.Process_po_acceptance: 03 - acc_due_date > sysdate ';
769: IF (g_po_wf_debug = 'Y') THEN
770: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);
771: END IF;
772: IF l_Item_end_date is not null then
773: l_progress := 'PO_APPROVAL_REMINDER_SV.Process_po_acceptance: 04 - end_date not null';
774: IF (g_po_wf_debug = 'Y') THEN

Line 775: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);

771: END IF;
772: IF l_Item_end_date is not null then
773: l_progress := 'PO_APPROVAL_REMINDER_SV.Process_po_acceptance: 04 - end_date not null';
774: IF (g_po_wf_debug = 'Y') THEN
775: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);
776: END IF;
777: -- bug 3896181
778: PO_APPROVAL_REMINDER_SV.Cancel_Notif (l_doc_type,
779: l_doc_header_id,

Line 799: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);

795: COMMIT;
796: ELSE -- l_Item_end_date is not null
797: l_progress := 'PO_APPROVAL_REMINDER_SV.Process_po_acceptance: 05 - end_date is null';
798: IF (g_po_wf_debug = 'Y') THEN
799: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);
800: -- bug 3896181
801: END IF;
802:
803: -- bug 3896181

Line 814: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);

810: IF l_message_name = 'PO_ACCEPTANCE_PAST_DUE' then
811: l_progress := 'PO_APPROVAL_REMINDER_SV.Process_po_acceptance: 06 - PO_ACCEPTANCE_PAST_DUE';
812: -- bug 3896181
813: IF (g_po_wf_debug = 'Y') THEN
814: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);
815: END IF;
816: -- bug 3896181
817: PO_APPROVAL_REMINDER_SV.Cancel_Notif (l_doc_type,
818: l_doc_header_id,

Line 845: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);

841: ELSE -- l_acceptance_due_date) > trunc(sysdate)
842: l_progress := 'PO_APPROVAL_REMINDER_SV.Process_po_acceptance: 07 - acc_due_date < sysdate';
843: -- bug 3896181
844: IF (g_po_wf_debug = 'Y') THEN
845: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);
846: END IF;
847:
848: -- bug 3896181
849: IF l_Item_end_date is not NULL THEN

Line 852: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);

848: -- bug 3896181
849: IF l_Item_end_date is not NULL THEN
850: l_progress := 'PO_APPROVAL_REMINDER_SV.Process_po_acceptance: 08 - end_date is not null';
851: IF (g_po_wf_debug = 'Y') THEN
852: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);
853: END IF;
854: PO_APPROVAL_REMINDER_SV.Cancel_Notif (l_doc_type,
855: l_doc_header_id,
856: NULL);

Line 881: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);

877: -- bug 3896181
878: ELSE -- l_Item_end_date is not NULL
879: l_progress := 'PO_APPROVAL_REMINDER_SV.Process_po_acceptance: 09 - end_date is null';
880: IF (g_po_wf_debug = 'Y') THEN
881: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);
882: -- bug 3896181
883: END IF;
884: -- bug 3896181
885: select wfn.MESSAGE_NAME

Line 894: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);

890: and wias.item_key = l_ItemKey ;
891: IF l_message_name = 'PO_ACCEPTANCE_REQUIRED' then
892: l_progress := 'PO_APPROVAL_REMINDER_SV.Process_po_acceptance: 10 - PO_ACCEPTANCE_REQUIRED';
893: IF (g_po_wf_debug = 'Y') THEN
894: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);
895: END IF;
896: PO_APPROVAL_REMINDER_SV.Cancel_Notif (l_doc_type,
897: l_doc_header_id,
898: NULL);

Line 922: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);

918: ELSE -- l_item_exist = 'Y'
919: l_progress := 'PO_APPROVAL_REMINDER_SV.Process_po_acceptance: 11 - l_item_exists is N';
920: -- bug 3896181
921: IF (g_po_wf_debug = 'Y') THEN
922: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);
923: END IF;
924: -- bug 3896181
925: PO_APPROVAL_REMINDER_SV.Start_Approval_Reminder (l_doc_header_id,
926: l_doc_number,

Line 951: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);

947:
948:
949: l_progress := 'PO_APPROVAL_REMINDER_SV.Process_po_acceptance: 900 - END ';
950: IF (g_po_wf_debug = 'Y') THEN
951: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);
952: END IF;
953:
954: EXCEPTION
955: WHEN NO_DATA_FOUND THEN

Line 960: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);

956: wf_core.context ('PO_APPROVAL_REMINDER_SV','Process_po_acceptance','No data found');
957: l_progress := 'PO_APPROVAL_REMINDER_SV.Process_po_acceptance: 901 - ' ||
958: 'EXCEPTION - no data found sql error: ' || sqlcode;
959: IF (g_po_wf_debug = 'Y') THEN
960: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);
961: END IF;
962:
963: WHEN OTHERS THEN
964: wf_core.context ('PO_APPROVAL_REMINDER_SV','Process_po_acceptance','SQL error ' || sqlcode);

Line 968: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);

964: wf_core.context ('PO_APPROVAL_REMINDER_SV','Process_po_acceptance','SQL error ' || sqlcode);
965: l_progress := 'PO_APPROVAL_REMINDER_SV.Process_po_acceptance: 990 - ' ||
966: 'EXCEPTION - sql error: ' || sqlcode;
967: IF (g_po_wf_debug = 'Y') THEN
968: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);
969: END IF;
970:
971: RAISE;
972:

Line 1048: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);

1044: BEGIN
1045:
1046: l_progress := 'PO_APPROVAL_REMINDER_SV.Process_rel_acceptance: 01 - BEGIN ';
1047: IF (g_po_wf_debug = 'Y') THEN
1048: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);
1049: END IF;
1050:
1051: l_itemkey := '';
1052:

Line 1105: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);

1101:
1102: --bug 3896181
1103: l_progress := 'PO_APPROVAL_REMINDER_SV.Process_rel_acceptance: 02 - item key exists ';
1104: IF (g_po_wf_debug = 'Y') THEN
1105: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);
1106: END IF;
1107: IF trunc(l_acceptance_due_date) > trunc(sysdate) THEN
1108: l_progress := 'PO_APPROVAL_REMINDER_SV.Process_rel_acceptance: 03 - acc_due_date > sysdate ';
1109: IF (g_po_wf_debug = 'Y') THEN

Line 1110: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);

1106: END IF;
1107: IF trunc(l_acceptance_due_date) > trunc(sysdate) THEN
1108: l_progress := 'PO_APPROVAL_REMINDER_SV.Process_rel_acceptance: 03 - acc_due_date > sysdate ';
1109: IF (g_po_wf_debug = 'Y') THEN
1110: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);
1111: END IF;
1112: IF l_Item_end_date is not null then
1113: l_progress := 'PO_APPROVAL_REMINDER_SV.Process_rel_acceptance: 04 - end_date not null';
1114: IF (g_po_wf_debug = 'Y') THEN

Line 1115: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);

1111: END IF;
1112: IF l_Item_end_date is not null then
1113: l_progress := 'PO_APPROVAL_REMINDER_SV.Process_rel_acceptance: 04 - end_date not null';
1114: IF (g_po_wf_debug = 'Y') THEN
1115: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);
1116: END IF;
1117: --bug 3896181
1118:
1119: PO_APPROVAL_REMINDER_SV.Cancel_Notif (l_doc_type,

Line 1139: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);

1135: COMMIT;
1136: ELSE -- l_Item_end_date is not null
1137: l_progress := 'PO_APPROVAL_REMINDER_SV.Process_rel_acceptance: 05 - end_date is null';
1138: IF (g_po_wf_debug = 'Y') THEN
1139: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);
1140: --bug 3896181
1141: END IF;
1142:
1143: --bug 3896181

Line 1159: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);

1155: IF l_message_name = 'REL_ACCEPTANCE_PAST_DUE' then
1156: l_progress := 'PO_APPROVAL_REMINDER_SV.Process_rel_acceptance: 06 - REL_ACCEPTANCE_PAST_DUE';
1157: --bug 3896181
1158: IF (g_po_wf_debug = 'Y') THEN
1159: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);
1160: END IF;
1161: --bug 3896181
1162: PO_APPROVAL_REMINDER_SV.Cancel_Notif (l_doc_type,
1163: l_doc_header_id,

Line 1190: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);

1186: ELSE -- trunc(l_acceptance_due_date) > trunc(sysdate)
1187: l_progress := 'PO_APPROVAL_REMINDER_SV.Process_rel_acceptance: 07 - acc_due_date < sysdate';
1188: --bug 3896181
1189: IF (g_po_wf_debug = 'Y') THEN
1190: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);
1191: END IF;
1192:
1193: --bug 3896181
1194: IF l_Item_end_date is not NULL THEN

Line 1197: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);

1193: --bug 3896181
1194: IF l_Item_end_date is not NULL THEN
1195: l_progress := 'PO_APPROVAL_REMINDER_SV.Process_rel_acceptance: 08 - end_date is not null';
1196: IF (g_po_wf_debug = 'Y') THEN
1197: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);
1198: END IF;
1199: PO_APPROVAL_REMINDER_SV.Cancel_Notif (l_doc_type,
1200: l_doc_header_id,
1201: NULL);

Line 1226: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);

1222: --bug 3896181
1223: ELSE -- l_Item_end_date is not NULL
1224: l_progress := 'PO_APPROVAL_REMINDER_SV.Process_rel_acceptance: 09 - end_date is null';
1225: IF (g_po_wf_debug = 'Y') THEN
1226: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);
1227: --bug 3896181
1228: END IF;
1229:
1230: --bug 3896181

Line 1245: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);

1241: end ;
1242: If l_message_name = 'REL_ACCEPTANCE_REQUIRED' then
1243: l_progress := 'PO_APPROVAL_REMINDER_SV.Process_rel_acceptance: 10 - REL_ACCEPTANCE_REQUIRED';
1244: IF (g_po_wf_debug = 'Y') THEN
1245: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);
1246: END IF;
1247: PO_APPROVAL_REMINDER_SV.Cancel_Notif (l_doc_type,
1248: l_doc_header_id,
1249: NULL);

Line 1272: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);

1268: ELSE -- l_item_exist = 'Y'
1269: l_progress := 'PO_APPROVAL_REMINDER_SV.Process_rel_acceptance: 11 - l_item_exists is N';
1270: --bug 3896181
1271: IF (g_po_wf_debug = 'Y') THEN
1272: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);
1273: END IF;
1274: --bug 3896181
1275: PO_APPROVAL_REMINDER_SV.Start_Approval_Reminder (l_doc_header_id,
1276: l_doc_number,

Line 1301: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);

1297: CLOSE REL_acceptance;
1298:
1299: l_progress := 'PO_APPROVAL_REMINDER_SV.Process_rel_acceptance: 900 - END ';
1300: IF (g_po_wf_debug = 'Y') THEN
1301: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);
1302: END IF;
1303:
1304:
1305: EXCEPTION

Line 1311: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);

1307: wf_core.context ('PO_APPROVAL_REMINDER_SV','Process_rel_acceptance','No data found');
1308: l_progress := 'PO_APPROVAL_REMINDER_SV.Process_rel_acceptance: 901 - ' ||
1309: 'EXCEPTION - no data found sql error: ' || sqlcode;
1310: IF (g_po_wf_debug = 'Y') THEN
1311: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);
1312: END IF;
1313:
1314: WHEN OTHERS THEN
1315: wf_core.context ('PO_APPROVAL_REMINDER_SV','Process_rel_acceptance','SQL error ' || sqlcode);

Line 1319: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);

1315: wf_core.context ('PO_APPROVAL_REMINDER_SV','Process_rel_acceptance','SQL error ' || sqlcode);
1316: l_progress := 'PO_APPROVAL_REMINDER_SV.Process_rel_acceptance: 990 - ' ||
1317: 'EXCEPTION - sql error: ' || sqlcode;
1318: IF (g_po_wf_debug = 'Y') THEN
1319: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);
1320: END IF;
1321:
1322:
1323: RAISE;

Line 1406: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);

1402: BEGIN
1403:
1404: l_progress := 'PO_APPROVAL_REMINDER_SV.Process_rfq_quote: 01 - BEGIN ';
1405: IF (g_po_wf_debug = 'Y') THEN
1406: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);
1407: END IF;
1408:
1409: l_itemkey := ' ';
1410:

Line 1468: --/* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);

1464:
1465:
1466: l_progress := 'PO_APPROVAL_REMINDER_SV.Process_rfq_quote: 02 - sysdate : '||
1467: to_char(SYSDATE,'DD/MM/YYYY');
1468: --/* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);
1469:
1470:
1471: l_progress := 'PO_APPROVAL_REMINDER_SV.Process_rfq_quote: 02 - quote end date active : '||
1472: to_char(l_quote_end_date_active,'DD/MM/YYYY');

Line 1473: --/* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);

1469:
1470:
1471: l_progress := 'PO_APPROVAL_REMINDER_SV.Process_rfq_quote: 02 - quote end date active : '||
1472: to_char(l_quote_end_date_active,'DD/MM/YYYY');
1473: --/* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);
1474:
1475: l_progress := 'PO_APPROVAL_REMINDER_SV.Process_rfq_quote: 02 - quote warning delay : '||
1476: l_quote_warning_delay;
1477: --/* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);

Line 1477: --/* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);

1473: --/* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);
1474:
1475: l_progress := 'PO_APPROVAL_REMINDER_SV.Process_rfq_quote: 02 - quote warning delay : '||
1476: l_quote_warning_delay;
1477: --/* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);
1478:
1479:
1480: l_progress := 'PO_APPROVAL_REMINDER_SV.Process_rfq_quote: 02 - quote end date temp : '||
1481: to_char(l_quote_end_date_temp,'DD/MM/YYYY');

Line 1482: --/* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);

1478:
1479:
1480: l_progress := 'PO_APPROVAL_REMINDER_SV.Process_rfq_quote: 02 - quote end date temp : '||
1481: to_char(l_quote_end_date_temp,'DD/MM/YYYY');
1482: --/* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);
1483:
1484:
1485: -- check for Quotation date range
1486: IF to_date(to_char(SYSDATE,'DD/MM/YYYY'),'DD/MM/YYYY') <=

Line 1495: --/* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);

1491: l_start_ntfn_wf_ok := 'Y';
1492:
1493: l_progress := 'PO_APPROVAL_REMINDER_SV.Process_rfq_quote: 02-set l_start_ntfn_wf_ok: '||
1494: l_start_ntfn_wf_ok;
1495: --/* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);
1496:
1497: END IF;
1498:
1499: ELSE

Line 1511: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);

1507:
1508: l_progress := 'PO_APPROVAL_REMINDER_SV.Process_rfq_quote: 03 - l_start_ntfn_wf_ok: '||
1509: l_start_ntfn_wf_ok;
1510: IF (g_po_wf_debug = 'Y') THEN
1511: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);
1512: END IF;
1513:
1514:
1515: IF l_start_ntfn_wf_ok = 'Y' THEN

Line 1536: -- /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);

1532: NULL;
1533:
1534: l_progress := 'PO_APPROVAL_REMINDER_SV.Process_rfq_quote: 05 ' ||
1535: 'open WF item key exists ' ||l_itemkey;
1536: -- /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);
1537:
1538: ELSE
1539: -- Workflow item does not exist
1540: -- Invoke the Start_Approval_Reminder workflow

Line 1546: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);

1542:
1543: l_progress := 'PO_APPROVAL_REMINDER_SV.Process_rfq_quote: 10 ' ||
1544: 'Start WF item key =' ||l_itemkey;
1545: IF (g_po_wf_debug = 'Y') THEN
1546: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);
1547: END IF;
1548:
1549: PO_APPROVAL_REMINDER_SV.Start_Approval_Reminder (l_doc_header_id,
1550: l_doc_number,

Line 1580: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);

1576:
1577:
1578: l_progress := 'PO_APPROVAL_REMINDER_SV.Process_rfq_quote: 900 - END ';
1579: IF (g_po_wf_debug = 'Y') THEN
1580: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);
1581: END IF;
1582:
1583:
1584: EXCEPTION

Line 1590: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);

1586: wf_core.context ('PO_APPROVAL_REMINDER_SV','Process_rfq_quote','No data found');
1587: l_progress := 'PO_APPROVAL_REMINDER_SV.Process_rfq_quote: 901 - ' ||
1588: 'EXCEPTION - no data found sql error: ' || sqlcode;
1589: IF (g_po_wf_debug = 'Y') THEN
1590: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);
1591: END IF;
1592:
1593: WHEN OTHERS THEN
1594: wf_core.context ('PO_APPROVAL_REMINDER_SV','Process_rfq_quote','SQL error ' || sqlcode);

Line 1598: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);

1594: wf_core.context ('PO_APPROVAL_REMINDER_SV','Process_rfq_quote','SQL error ' || sqlcode);
1595: l_progress := 'PO_APPROVAL_REMINDER_SV.Process_rfq_quote: 990 - ' ||
1596: 'EXCEPTION - sql error: ' || sqlcode;
1597: IF (g_po_wf_debug = 'Y') THEN
1598: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);
1599: END IF;
1600:
1601: RAISE;
1602:

Line 1640: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);

1636: BEGIN
1637:
1638: l_progress := 'PO_APPROVAL_REMINDER_SV.Start_Approval_Reminder: 01 ';
1639: IF (g_po_wf_debug = 'Y') THEN
1640: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);
1641: END IF;
1642:
1643: fnd_profile.get('RESP_ID', l_responsibility_id);
1644: fnd_profile.get('RESP_APPL_ID', l_application_id);

Line 1730: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);

1726: ItemKey => l_ItemKey );
1727:
1728: l_progress := 'PO_APPROVAL_REMINDER_SV.Start_Approval_Reminder: 900 ';
1729: IF (g_po_wf_debug = 'Y') THEN
1730: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);
1731: END IF;
1732:
1733:
1734: EXCEPTION

Line 1741: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);

1737: wf_core.context ('PO_APPROVAL_REMINDER_SV','Start_Approval_Reminder','SQL error ' || sqlcode);
1738: l_progress := 'PO_APPROVAL_REMINDER_SV.Start_Approval_Reminder: 990 - ' ||
1739: 'EXCEPTION - sql error: ' || sqlcode;
1740: IF (g_po_wf_debug = 'Y') THEN
1741: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);
1742: END IF;
1743:
1744:
1745: RAISE;

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

1798: BEGIN
1799:
1800: l_progress := 'PO_APPROVAL_REMINDER_SV.Set_Doc_Type: 01 ';
1801: IF (g_po_wf_debug = 'Y') THEN
1802: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1803: END IF;
1804:
1805:
1806: IF ( funmode = 'RUN' ) THEN

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

2071:
2072: l_progress := 'PO_APPROVAL_REMINDER_SV.Set_Doc_Type: 05 RESULT ' ||
2073: l_doc_type;
2074: IF (g_po_wf_debug = 'Y') THEN
2075: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2076: END IF;
2077:
2078:
2079: ELSIF ( funmode = 'CANCEL' ) THEN

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

2084:
2085:
2086: l_progress := 'PO_APPROVAL_REMINDER_SV.Set_Doc_Type: 900 ';
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:
2092: EXCEPTION

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

2094: wf_core.context ('PO_APPROVAL_REMINDER_SV','Set_Doc_Type','No data found');
2095: l_progress := 'PO_APPROVAL_REMINDER_SV.Set_Doc_Type: 901 - ' ||
2096: 'EXCEPTION - no data found sql error: ' || sqlcode;
2097: IF (g_po_wf_debug = 'Y') THEN
2098: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2099: END IF;
2100:
2101: WHEN OTHERS THEN
2102: wf_core.context ('PO_APPROVAL_REMINDER_SV','Set_Doc_Type','SQL error ' || sqlcode);

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

2102: wf_core.context ('PO_APPROVAL_REMINDER_SV','Set_Doc_Type','SQL error ' || sqlcode);
2103: l_progress := 'PO_APPROVAL_REMINDER_SV.Set_Doc_Type: 990 - ' ||
2104: 'EXCEPTION - sql error: ' || sqlcode;
2105: IF (g_po_wf_debug = 'Y') THEN
2106: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2107: END IF;
2108:
2109:
2110: RAISE;

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

2149: BEGIN
2150:
2151: l_progress := 'PO_APPROVAL_REMINDER_SV.Start_Doc_Approval: 01 ';
2152: IF (g_po_wf_debug = 'Y') THEN
2153: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2154: END IF;
2155:
2156:
2157: IF ( funmode = 'RUN' ) THEN

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

2281:
2282:
2283: l_progress := 'PO_APPROVAL_REMINDER_SV.Start_Doc_Approval: 900 - END ';
2284: IF (g_po_wf_debug = 'Y') THEN
2285: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2286: END IF;
2287:
2288:
2289: EXCEPTION

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

2291: wf_core.context ('PO_APPROVAL_REMINDER_SV','Start_Doc_Approval','No data found');
2292: l_progress := 'PO_APPROVAL_REMINDER_SV.Start_Doc_Approval: 901 - ' ||
2293: 'EXCEPTION - no data found sql error: ' || sqlcode;
2294: IF (g_po_wf_debug = 'Y') THEN
2295: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2296: END IF;
2297:
2298:
2299: WHEN OTHERS THEN

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

2300: wf_core.context ('PO_APPROVAL_REMINDER_SV','Start_Doc_Approval','SQL error ' || sqlcode);
2301: l_progress := 'PO_APPROVAL_REMINDER_SV.Start_Doc_Approval: 990 - ' ||
2302: 'EXCEPTION - sql error: ' || sqlcode;
2303: IF (g_po_wf_debug = 'Y') THEN
2304: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2305: END IF;
2306:
2307:
2308: RAISE;

Line 2379: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug('APVRMDER',NULL,l_progress);

2375:
2376: l_progress := 'PO_APPROVAL_REMINDER_SV.SetUpWorkFlow: 01 ' ||
2377: p_DocumentTypeCode || p_DocumentSubtype || p_DocumentNumber;
2378: IF (g_po_wf_debug = 'Y') THEN
2379: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug('APVRMDER',NULL,l_progress);
2380: END IF;
2381:
2382:
2383: PO_REQAPPROVAL_INIT1.get_multiorg_context (p_DocumentTypeCode, p_DocumentID, l_orgid);

Line 2416: PO_WF_DEBUG_PKG.insert_debug('POXWARMB',NULL,l_progress);

2412: l_progress := 'PO_APPROVAL_REMINDER_SV.SetUpWorkFlow: 02 ' ||
2413: p_DocumentTypeCode || p_DocumentSubtype ||
2414: p_DocumentNumber;
2415: IF (g_po_wf_debug = 'Y') THEN
2416: PO_WF_DEBUG_PKG.insert_debug('POXWARMB',NULL,l_progress);
2417: END IF;
2418:
2419: PO_VENDOR_SITES_SV.Get_Transmission_Defaults(
2420: p_document_id => p_DocumentID,

Line 2461: PO_WF_DEBUG_PKG.insert_debug('POXWARMB',NULL,l_progress);

2457: l_progress := 'PO_APPROVAL_REMINDER_SV.SetUpWorkFlow: 03 ' ||
2458: p_DocumentTypeCode || p_DocumentSubtype ||
2459: p_DocumentNumber;
2460: IF (g_po_wf_debug = 'Y') THEN
2461: PO_WF_DEBUG_PKG.insert_debug('POXWARMB',NULL,l_progress);
2462: END IF;
2463: po_approve_sv.get_document_types(
2464: p_document_type_code => p_DocumentTypeCode,
2465: p_document_subtype => p_DocumentSubtype,

Line 2527: PO_WF_DEBUG_PKG.insert_debug('POXWARMB',NULL,l_progress);

2523: l_progress := 'PO_APPROVAL_REMINDER_SV.SetUpWorkFlow: 04 ' ||
2524: p_DocumentTypeCode || p_DocumentSubtype ||
2525: p_DocumentNumber;
2526: IF (g_po_wf_debug = 'Y') THEN
2527: PO_WF_DEBUG_PKG.insert_debug('POXWARMB',NULL,l_progress);
2528: END IF;
2529: PO_REQAPPROVAL_INIT1.Start_WF_Process ( ItemType => l_ItemType,
2530: ItemKey => l_ItemKey,
2531: WorkflowProcess => l_WorkflowProcess,

Line 2553: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug('APVRMDER',l_itemkey,l_progress);

2549:
2550: l_progress := 'PO_APPROVAL_REMINDER_SV.SetUpWorkFlow: 900 ' ||
2551: p_DocumentTypeCode || p_DocumentSubtype || p_DocumentNumber;
2552: IF (g_po_wf_debug = 'Y') THEN
2553: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug('APVRMDER',l_itemkey,l_progress);
2554: END IF;
2555:
2556:
2557:

Line 2565: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug('APVRMDER',l_itemkey,l_progress);

2561: wf_core.context ('PO_APPROVAL_REMINDER_SV','SetUpWorkFlow','SQL error ' || sqlcode);
2562: l_progress := 'PO_APPROVAL_REMINDER_SV.SetUpWorkFlow: 990 - ' ||
2563: 'EXCEPTION - sql error: ' || sqlcode;
2564: IF (g_po_wf_debug = 'Y') THEN
2565: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug('APVRMDER',l_itemkey,l_progress);
2566: END IF;
2567:
2568: RAISE;
2569:

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

2598: BEGIN
2599:
2600: x_progress := 'PO_APPROVAL_REMINDER_SV.Is_Forward_To_Valid: 01';
2601: IF (g_po_wf_debug = 'Y') THEN
2602: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
2603: END IF;
2604:
2605:
2606: -- Do nothing in cancel or timeout mode

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

2627:
2628: x_progress := 'PO_APPROVAL_REMINDER_SV.Is_Forward_To_Valid: 02';
2629: x_progress := x_progress || ' Forward-To=' || l_forward_to_username_response;
2630: IF (g_po_wf_debug = 'Y') THEN
2631: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
2632: END IF;
2633:
2634: IF l_forward_to_username_response is NULL THEN
2635:

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

2753:
2754:
2755: x_progress := 'PO_APPROVAL_REMINDER_SV.Is_Forward_To_Valid: 900';
2756: IF (g_po_wf_debug = 'Y') THEN
2757: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
2758: END IF;
2759:
2760:
2761: EXCEPTION

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

2764: wf_core.context ('PO_APPROVAL_REMINDER_SV','Is_Forward_To_Valid','SQL error ' || sqlcode);
2765: x_progress := 'PO_APPROVAL_REMINDER_SV.Is_Forward_To_Valid: 990 - ' ||
2766: 'EXCEPTION - sql error: ' || sqlcode;
2767: IF (g_po_wf_debug = 'Y') THEN
2768: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
2769: END IF;
2770:
2771:
2772: RAISE;

Line 3055: PO_WF_DEBUG_PKG.insert_debug(null,null,x_progress);

3051:
3052: EXCEPTION
3053: WHEN OTHERS THEN
3054: IF (g_po_wf_debug = 'Y') THEN
3055: PO_WF_DEBUG_PKG.insert_debug(null,null,x_progress);
3056: END IF;
3057: wf_core.context ('PO_APPROVAL_REMINDER_SV','Process_Cancel_notification','SQL error ' || sqlcode);
3058: RAISE;
3059:

Line 3105: PO_WF_DEBUG_PKG.insert_debug(null,null,x_progress);

3101: WHEN NO_DATA_FOUND THEN
3102: return FALSE;
3103: WHEN OTHERS THEN
3104: IF (g_po_wf_debug = 'Y') THEN
3105: PO_WF_DEBUG_PKG.insert_debug(null,null,x_progress);
3106: END IF;
3107: wf_core.context ('PO_APPROVAL_REMINDER_SV','Process_Check_Status','SQL error ' || sqlcode);
3108: RAISE;
3109: return FALSE;

Line 3136: -- /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(p_itemtype,p_itemkey,l_progress);

3132: BEGIN
3133:
3134:
3135: l_progress := 'PO_APPROVAL_REMINDER_SV.Item_Exist: 01';
3136: -- /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(p_itemtype,p_itemkey,l_progress);
3137:
3138: -- initialize the return variables
3139: p_item_exist := NULL;
3140: p_item_end_date := NULL;

Line 3150: -- /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(p_itemtype,p_itemkey,l_progress);

3146: AND WI.ITEM_KEY = p_ItemKey;
3147:
3148:
3149: l_progress := 'PO_APPROVAL_REMINDER_SV.Item_Exist: 900 ';
3150: -- /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(p_itemtype,p_itemkey,l_progress);
3151:
3152:
3153: EXCEPTION
3154: WHEN NO_DATA_FOUND THEN

Line 3166: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(p_itemtype,p_itemkey,l_progress);

3162: wf_core.context ('PO_APPROVAL_REMINDER_SV','Item_exist','SQL error ' || sqlcode);
3163: l_progress := 'PO_APPROVAL_REMINDER_SV.Item_Exist: 990 - ' ||
3164: 'EXCEPTION - sql error: ' || sqlcode;
3165: IF (g_po_wf_debug = 'Y') THEN
3166: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(p_itemtype,p_itemkey,l_progress);
3167: END IF;
3168:
3169: RAISE;
3170: