DBA Data[Home] [Help]

APPS.PO_CHORD_WF6 dependencies on PO_WF_DEBUG_PKG

Line 93: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

89:
90: BEGIN
91:
92: IF (g_po_wf_debug = 'Y') THEN
93: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
94: '*** In Procedure: standard_po_reapproval ***');
95: END IF;
96:
97: IF funcmode <> 'RUN' THEN

Line 130: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

126: END IF;
127:
128: IF (g_po_wf_debug = 'Y') THEN
129: if l_is_complex_work_po then
130: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
131: 'l_is_complex_work_po - Yes');
132: else
133: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
134: 'l_is_complex_work_po - No');

Line 133: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

129: if l_is_complex_work_po then
130: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
131: 'l_is_complex_work_po - Yes');
132: else
133: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
134: 'l_is_complex_work_po - No');
135: end if;
136: END IF;
137:

Line 174: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

170: if (l_autoapprove_retro = 'Y') AND (l_actionoriginated_from = 'RETRO') THEN
171:
172:
173: IF (g_po_wf_debug = 'Y') THEN
174: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
175: '$$$$$$$ Document requires full approval = N $$$$$$');
176: END IF;
177:
178: RESULT := 'N';

Line 225: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

221: OR (x_header_control.po_total_change >
222: nvl(x_tolerance_control.h_po_total_t,0))
223: THEN
224: IF (g_po_wf_debug = 'Y') THEN
225: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
226: '########## header_require_reapproval result: Y');
227: END IF;
228: x_result:='Y';
229: ELSE

Line 231: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

227: END IF;
228: x_result:='Y';
229: ELSE
230: IF (g_po_wf_debug = 'Y') THEN
231: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
232: '########## header_require_reapproval result: N');
233: END IF;
234: x_result:='N';
235: END IF;

Line 273: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

269: OR (x_lines_control.amount_change >
270: nvl(x_tolerance_control.l_amount_t,0)) --
271: THEN
272: IF (g_po_wf_debug = 'Y') THEN
273: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
274: '########## lines_require_reapproval result: Y');
275: END IF;
276: x_result:='Y';
277: ELSE

Line 279: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

275: END IF;
276: x_result:='Y';
277: ELSE
278: IF (g_po_wf_debug = 'Y') THEN
279: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
280: '########## lines_require_reapproval result: N');
281: END IF;
282: x_result:='N';
283: END IF;

Line 318: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

314: (x_shipments_control.price_override_change > nvl(x_tolerance_control.p_price_override_t,0)))
315: --
316: THEN
317: IF (g_po_wf_debug = 'Y') THEN
318: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
319: '########## shipments_require_reapproval result: Y');
320: END IF;
321: x_result:='Y';
322: ELSE

Line 324: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

320: END IF;
321: x_result:='Y';
322: ELSE
323: IF (g_po_wf_debug = 'Y') THEN
324: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
325: '########## shipments_require_reapproval result: N');
326: END IF;
327: x_result:='N';
328: END IF;

Line 351: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

347: OR (x_dist_control.amount_ordered_change >
348: nvl(x_tolerance_control.d_amount_ordered_t,0)) --
349: THEN
350: IF (g_po_wf_debug = 'Y') THEN
351: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
352: '########## dist_require_reapproval result: Y');
353: END IF;
354: x_result:='Y';
355: ELSE

Line 357: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

353: END IF;
354: x_result:='Y';
355: ELSE
356: IF (g_po_wf_debug = 'Y') THEN
357: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
358: '########## dist_require_reapproval result: N');
359: END IF;
360: x_result:='N';
361: END IF;

Line 374: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

370: END IF;
371: --
372: IF x_result = 'Y' THEN
373: IF (g_po_wf_debug = 'Y') THEN
374: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
375: '$$$$$$$ Document requires full approval = Y $$$$$$');
376: END IF;
377: RESULT := 'Y';
378: ELSE

Line 380: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

376: END IF;
377: RESULT := 'Y';
378: ELSE
379: IF (g_po_wf_debug = 'Y') THEN
380: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
381: '$$$$$$$ Document requires full approval = N $$$$$$');
382: END IF;
383: RESULT := 'N';
384: END IF;

Line 387: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

383: RESULT := 'N';
384: END IF;
385:
386: IF (g_po_wf_debug = 'Y') THEN
387: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
388: '*** Finish: standard_po_reapproval ***');
389: END IF;
390:
391: return;

Line 422: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

418: x_result VARCHAR2(1);
419: BEGIN
420:
421: IF (g_po_wf_debug = 'Y') THEN
422: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
423: '*** In Procedure: planned_po_reapproval ***');
424: END IF;
425:
426: IF funcmode <> 'RUN' THEN

Line 462: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

458: OR (x_header_control.amount_limit_change >
459: nvl(x_tolerance_control.h_amount_limit_t,0))
460: THEN
461: IF (g_po_wf_debug = 'Y') THEN
462: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
463: '########## header_require_reapproval result: Y');
464: END IF;
465: x_result:='Y';
466: ELSE

Line 468: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

464: END IF;
465: x_result:='Y';
466: ELSE
467: IF (g_po_wf_debug = 'Y') THEN
468: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
469: '########## header_require_reapproval result: N');
470: END IF;
471: x_result:='N';
472: END IF;

Line 495: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

491: OR (x_lines_control.unit_price_change >
492: nvl(x_tolerance_control.l_unit_price_t,0))
493: THEN
494: IF (g_po_wf_debug = 'Y') THEN
495: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
496: '########## lines_require_reapproval result: Y');
497: END IF;
498: x_result:='Y';
499: ELSE

Line 501: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

497: END IF;
498: x_result:='Y';
499: ELSE
500: IF (g_po_wf_debug = 'Y') THEN
501: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
502: '########## lines_require_reapproval result: N');
503: END IF;
504: x_result:='N';
505: END IF;

Line 525: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

521: OR (x_shipments_control.quantity_change >
522: nvl(x_tolerance_control.s_quantity_t,0))
523: THEN
524: IF (g_po_wf_debug = 'Y') THEN
525: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
526: '########## shipments_require_reapproval result: Y');
527: END IF;
528: x_result:='Y';
529: ELSE

Line 531: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

527: END IF;
528: x_result:='Y';
529: ELSE
530: IF (g_po_wf_debug = 'Y') THEN
531: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
532: '########## shipments_require_reapproval result: N');
533: END IF;
534: x_result:='N';
535: END IF;

Line 556: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

552: OR (x_dist_control.quantity_ordered_change >
553: nvl(x_tolerance_control.d_quantity_ordered_t,0))
554: THEN
555: IF (g_po_wf_debug = 'Y') THEN
556: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
557: '########## dist_require_reapproval result: Y');
558: END IF;
559: x_result:='Y';
560: ELSE

Line 562: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

558: END IF;
559: x_result:='Y';
560: ELSE
561: IF (g_po_wf_debug = 'Y') THEN
562: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
563: '########## dist_require_reapproval result: N');
564: END IF;
565: x_result:='N';
566: END IF;

Line 571: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

567: END IF;
568:
569: IF x_result = 'Y' THEN
570: IF (g_po_wf_debug = 'Y') THEN
571: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
572: '$$$$$$$ Document requires full approval = Y $$$$$$');
573: END IF;
574: RESULT := 'Y';
575: ELSE

Line 577: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

573: END IF;
574: RESULT := 'Y';
575: ELSE
576: IF (g_po_wf_debug = 'Y') THEN
577: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
578: '$$$$$$$ Document requires full approval = N $$$$$$');
579: END IF;
580: RESULT := 'N';
581: END IF;

Line 585: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

581: END IF;
582:
583:
584: IF (g_po_wf_debug = 'Y') THEN
585: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
586: '*** Finish: planned_po_reapproval ***');
587: END IF;
588: return;
589:

Line 620: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

616:
617: BEGIN
618:
619: IF (g_po_wf_debug = 'Y') THEN
620: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
621: '*** In Procedure: blanket_po_reapproval ***');
622: END IF;
623:
624: IF funcmode <> 'RUN' THEN

Line 667: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

663: OR (x_header_control.blanket_total_change >
664: nvl(x_tolerance_control.h_blanket_total_t,0)) -- Bug 5166228
665: THEN
666: IF (g_po_wf_debug = 'Y') THEN
667: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
668: '########## header_require_reapproval result: Y');
669: END IF;
670: x_result:='Y';
671: ELSE

Line 673: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

669: END IF;
670: x_result:='Y';
671: ELSE
672: IF (g_po_wf_debug = 'Y') THEN
673: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
674: '########## header_require_reapproval result: N');
675: END IF;
676: x_result:='N';
677: END IF;

Line 706: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

702: OR (x_lines_control.committed_amount_change >
703: nvl(x_tolerance_control.l_committed_amount_t,0))
704: THEN
705: IF (g_po_wf_debug = 'Y') THEN
706: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
707: '########## lines_require_reapproval result: Y');
708: END IF;
709: x_result:='Y';
710: ELSE

Line 712: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

708: END IF;
709: x_result:='Y';
710: ELSE
711: IF (g_po_wf_debug = 'Y') THEN
712: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
713: '########## lines_require_reapproval result: N');
714: END IF;
715: x_result:='N';
716: END IF;

Line 737: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

733: OR (x_shipments_control.quantity_change >
734: nvl(x_tolerance_control.s_quantity_t,0))
735: THEN
736: IF (g_po_wf_debug = 'Y') THEN
737: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
738: '########## shipments_require_reapproval result: Y');
739: END IF;
740: x_result:='Y';
741: ELSE

Line 743: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

739: END IF;
740: x_result:='Y';
741: ELSE
742: IF (g_po_wf_debug = 'Y') THEN
743: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
744: '########## shipments_require_reapproval result: N');
745: END IF;
746: x_result:='N';
747: END IF;

Line 758: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

754: l_ga_org_assign_change :=
755: PO_WF_UTIL_PKG.GetItemAttrText (itemtype , itemkey,'GA_ORG_ASSIGN_CHANGE');
756: IF l_ga_org_assign_change = 'Y' THEN
757: IF (g_po_wf_debug = 'Y') THEN
758: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
759: '########## GA org assignments require reapproval result: Y');
760: END IF;
761: x_result:='Y';
762: ELSE

Line 764: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

760: END IF;
761: x_result:='Y';
762: ELSE
763: IF (g_po_wf_debug = 'Y') THEN
764: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
765: '########## GA org assignments require reapproval result: N');
766: END IF;
767: x_result:='N';
768: END IF;

Line 781: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

777: END IF;
778: --
779: IF x_result = 'Y' THEN
780: IF (g_po_wf_debug = 'Y') THEN
781: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
782: '$$$$$$$ Document requires full approval = Y $$$$$$');
783: END IF;
784: RESULT := 'Y';
785: ELSE

Line 787: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

783: END IF;
784: RESULT := 'Y';
785: ELSE
786: IF (g_po_wf_debug = 'Y') THEN
787: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
788: '$$$$$$$ Document requires full approval = N $$$$$$');
789: END IF;
790: RESULT := 'N';
791: END IF;

Line 795: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

791: END IF;
792:
793:
794: IF (g_po_wf_debug = 'Y') THEN
795: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
796: '*** Finish: blanket_po_reapproval ***');
797: END IF;
798:
799: END;

Line 818: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

814: x_tolerance_control t_tolerance_control_type;
815: BEGIN
816:
817: IF (g_po_wf_debug = 'Y') THEN
818: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
819: '*** In Procedure: contract_po_reapproval ***');
820: END IF;
821:
822: IF funcmode <> 'RUN' THEN

Line 859: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

855: OR (x_header_control.blanket_total_change >
856: nvl(x_tolerance_control.h_blanket_total_t,0))
857: THEN
858: IF (g_po_wf_debug = 'Y') THEN
859: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
860: '########## header_require_reapproval result: Y');
861: END IF;
862: result:='Y';
863: ELSE

Line 865: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

861: END IF;
862: result:='Y';
863: ELSE
864: IF (g_po_wf_debug = 'Y') THEN
865: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
866: '########## header_require_reapproval result: N');
867: END IF;
868: result:='N';
869: END IF;

Line 881: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

877: -- Adding the following debug stmt to indicate the final result
878: -- now that the contract terms are also there
879: IF (g_po_wf_debug = 'Y') THEN
880: IF result = 'Y' THEN
881: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
882: '$$$$$$$ Document requires full approval = Y $$$$$$');
883: ELSE
884: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
885: '$$$$$$$ Document requires full approval = N $$$$$$');

Line 884: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

880: IF result = 'Y' THEN
881: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
882: '$$$$$$$ Document requires full approval = Y $$$$$$');
883: ELSE
884: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
885: '$$$$$$$ Document requires full approval = N $$$$$$');
886: END IF; -- if result <>'Y'
887: END IF; -- if debug 'Y'
888:

Line 892: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

888:
889: --
890:
891: IF (g_po_wf_debug = 'Y') THEN
892: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
893: '*** Finish: contract_po_reapproval ***');
894: END IF;
895: return;
896:

Line 928: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

924: l_actionoriginated_from varchar2(30); --Bug5697556
925: BEGIN
926:
927: IF (g_po_wf_debug = 'Y') THEN
928: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
929: '*** In Procedure: blanket_release_reapproval ***');
930: END IF;
931:
932: IF funcmode <> 'RUN' THEN

Line 969: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

965:
966:
967:
968: IF (g_po_wf_debug = 'Y') THEN
969: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
970: '$$$$$$$ Document requires full approval = N $$$$$$');
971: END IF;
972: RESULT := 'N';
973:

Line 994: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

990: OR x_release_control.release_num ='Y'
991: OR x_release_control.release_date ='Y'
992: THEN
993: IF (g_po_wf_debug = 'Y') THEN
994: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
995: '########## blanket_release_require_reapproval result: Y');
996: END IF;
997: x_result:='Y';
998: ELSE

Line 1000: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

996: END IF;
997: x_result:='Y';
998: ELSE
999: IF (g_po_wf_debug = 'Y') THEN
1000: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1001: '########## blanket_release_require_reapproval result: N');
1002: END IF;
1003: x_result:='N';
1004: END IF;

Line 1028: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

1024: OR (x_shipments_control.amount_change >
1025: nvl(x_tolerance_control.s_amount_t,0)) --
1026: THEN
1027: IF (g_po_wf_debug = 'Y') THEN
1028: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1029: '########## shipments_require_reapproval result: Y');
1030: END IF;
1031: x_result:='Y';
1032: ELSE

Line 1034: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

1030: END IF;
1031: x_result:='Y';
1032: ELSE
1033: IF (g_po_wf_debug = 'Y') THEN
1034: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1035: '########## shipments_require_reapproval result: N');
1036: END IF;
1037: x_result:='N';
1038: END IF;

Line 1061: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

1057: OR (x_dist_control.amount_ordered_change >
1058: nvl(x_tolerance_control.d_amount_ordered_t,0)) --
1059: THEN
1060: IF (g_po_wf_debug = 'Y') THEN
1061: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1062: '########## dist_require_reapproval result: Y');
1063: END IF;
1064: x_result:='Y';
1065: ELSE

Line 1067: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

1063: END IF;
1064: x_result:='Y';
1065: ELSE
1066: IF (g_po_wf_debug = 'Y') THEN
1067: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1068: '########## dist_require_reapproval result: N');
1069: END IF;
1070: x_result:='N';
1071: END IF;

Line 1076: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

1072: END IF;
1073:
1074: IF x_result = 'Y' THEN
1075: IF (g_po_wf_debug = 'Y') THEN
1076: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1077: '$$$$$$$ Document requires full approval = Y $$$$$$');
1078: END IF;
1079: RESULT := 'Y';
1080: ELSE

Line 1082: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

1078: END IF;
1079: RESULT := 'Y';
1080: ELSE
1081: IF (g_po_wf_debug = 'Y') THEN
1082: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1083: '$$$$$$$ Document requires full approval = N $$$$$$');
1084: END IF;
1085: RESULT := 'N';
1086: END IF;

Line 1090: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

1086: END IF;
1087:
1088:
1089: IF (g_po_wf_debug = 'Y') THEN
1090: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1091: '*** Finish: blanket_release_reapproval ***');
1092: END IF;
1093: return;
1094:

Line 1123: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

1119: x_result VARCHAR2(1);
1120: BEGIN
1121:
1122: IF (g_po_wf_debug = 'Y') THEN
1123: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1124: '*** In Procedure: scheduled_release_reapproval ***');
1125: END IF;
1126:
1127: IF funcmode <> 'RUN' THEN

Line 1146: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

1142: OR x_release_control.release_num ='Y'
1143: OR x_release_control.release_date ='Y'
1144: THEN
1145: IF (g_po_wf_debug = 'Y') THEN
1146: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1147: '########## scheduled_release_require_reapproval result: Y');
1148: END IF;
1149: x_result:='Y';
1150: ELSE

Line 1152: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

1148: END IF;
1149: x_result:='Y';
1150: ELSE
1151: IF (g_po_wf_debug = 'Y') THEN
1152: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1153: '########## scheduled_release_require_reapproval result: N');
1154: END IF;
1155: x_result:='N';
1156: END IF;

Line 1174: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

1170: OR x_shipments_control.promised_date_change > 0
1171: OR x_shipments_control.need_by_date_change > 0
1172: THEN
1173: IF (g_po_wf_debug = 'Y') THEN
1174: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1175: '########## shipments_require_reapproval result: Y');
1176: END IF;
1177: x_result:='Y';
1178: ELSE

Line 1180: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

1176: END IF;
1177: x_result:='Y';
1178: ELSE
1179: IF (g_po_wf_debug = 'Y') THEN
1180: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1181: '########## shipments_require_reapproval result: N');
1182: END IF;
1183: x_result:='N';
1184: END IF;

Line 1206: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

1202: OR (x_dist_control.amount_ordered_change >
1203: nvl(x_tolerance_control.d_amount_ordered_t,0))
1204: THEN
1205: IF (g_po_wf_debug = 'Y') THEN
1206: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1207: '########## dist_require_reapproval result: Y');
1208: END IF;
1209: x_result:='Y';
1210: ELSE

Line 1212: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

1208: END IF;
1209: x_result:='Y';
1210: ELSE
1211: IF (g_po_wf_debug = 'Y') THEN
1212: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1213: '########## dist_require_reapproval result: N');
1214: END IF;
1215: x_result:='N';
1216: END IF;

Line 1221: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

1217: END IF;
1218:
1219: IF x_result = 'Y' THEN
1220: IF (g_po_wf_debug = 'Y') THEN
1221: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1222: '$$$$$$$ Document requires full approval = Y $$$$$$');
1223: END IF;
1224: RESULT := 'Y';
1225: ELSE

Line 1227: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

1223: END IF;
1224: RESULT := 'Y';
1225: ELSE
1226: IF (g_po_wf_debug = 'Y') THEN
1227: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1228: '$$$$$$$ Document requires full approval = N $$$$$$');
1229: END IF;
1230: RESULT := 'N';
1231: END IF;

Line 1235: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

1231: END IF;
1232:
1233:
1234: IF (g_po_wf_debug = 'Y') THEN
1235: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1236: '*** Finish: scheduled_release_reapproval ***');
1237: END IF;
1238: return;
1239:

Line 1270: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

1266: x_msg_data VARCHAR2(2000);
1267: BEGIN
1268:
1269: IF (g_po_wf_debug = 'Y') THEN
1270: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1271: '*** In Procedure: get_default_tolerance ***');
1272: END IF;
1273:
1274: --

Line 1298: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

1294:
1295: debug_default_tolerance(itemtype, itemkey,x_tolerance_control);
1296:
1297: IF (g_po_wf_debug = 'Y') THEN
1298: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1299: '*** FINISH: get_default_tolerance ***');
1300: END IF;
1301:
1302: EXCEPTION

Line 1328: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

1324: IS
1325: BEGIN
1326:
1327: IF (g_po_wf_debug = 'Y') THEN
1328: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1329: '*** In Procedure: get_tolerances_from_wf ***');
1330: END IF;
1331:
1332: -- Common attributes

Line 1453: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

1449:
1450: debug_default_tolerance(itemtype, itemkey,x_tolerance_control);
1451:
1452: IF (g_po_wf_debug = 'Y') THEN
1453: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1454: '*** FINISH: get_tolerances_from_wf ***');
1455: END IF;
1456:
1457: EXCEPTION

Line 1496: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

1492: x_msg_data VARCHAR2(2000);
1493: BEGIN
1494: --
1495: IF (g_po_wf_debug = 'Y') THEN
1496: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1497: '*** In Procedure: Set_Wf_Order_Tol ***');
1498: END IF;
1499:
1500: -- Retrieve organization id

Line 1685: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

1681:
1682: end loop;
1683:
1684: IF (g_po_wf_debug = 'Y') THEN
1685: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1686: '*** FINISH: get_Default_Order_Tol ***');
1687: END IF;
1688: --
1689: EXCEPTION

Line 1730: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

1726: x_msg_data VARCHAR2(2000);
1727: BEGIN
1728: --
1729: IF (g_po_wf_debug = 'Y') THEN
1730: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1731: '*** In Procedure: Set_Wf_Agreement_Tol ***');
1732: END IF;
1733:
1734: -- Retrieve organization id

Line 1856: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

1852: end if;
1853: end loop;
1854:
1855: IF (g_po_wf_debug = 'Y') THEN
1856: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1857: '*** FINISH: get_Default_Agreement_Tol ***');
1858: END IF;
1859: --
1860: EXCEPTION

Line 1901: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

1897: x_msg_data VARCHAR2(2000);
1898: BEGIN
1899: --
1900: IF (g_po_wf_debug = 'Y') THEN
1901: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1902: '*** In Procedure: Set_Wf_Release_Tol ***');
1903: END IF;
1904:
1905: -- Retrieve organization id

Line 2005: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

2001: end if;
2002: end loop;
2003:
2004: IF (g_po_wf_debug = 'Y') THEN
2005: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
2006: '*** FINISH: Set_Wf_Release_Tol ***');
2007: END IF;
2008: --
2009: EXCEPTION

Line 2027: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

2023: IS
2024: BEGIN
2025:
2026: IF (g_po_wf_debug = 'Y') THEN
2027: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
2028: '*** In Procedure: debug_default_tolerance ***');
2029: END IF;
2030:
2031: /* Header Percentage Attibutes */

Line 2033: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,

2029: END IF;
2030:
2031: /* Header Percentage Attibutes */
2032: IF (g_po_wf_debug = 'Y') THEN
2033: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
2034: 'Tolerance - h_blanket_total_t : '||
2035: x_tolerance_control.h_blanket_total_t );
2036: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
2037: 'Tolerance - h_amount_limit_t : '||

Line 2036: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,

2032: IF (g_po_wf_debug = 'Y') THEN
2033: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
2034: 'Tolerance - h_blanket_total_t : '||
2035: x_tolerance_control.h_blanket_total_t );
2036: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
2037: 'Tolerance - h_amount_limit_t : '||
2038: x_tolerance_control.h_amount_limit_t );
2039: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
2040: 'Tolerance - h_po_total_t : '||

Line 2039: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,

2035: x_tolerance_control.h_blanket_total_t );
2036: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
2037: 'Tolerance - h_amount_limit_t : '||
2038: x_tolerance_control.h_amount_limit_t );
2039: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
2040: 'Tolerance - h_po_total_t : '||
2041: x_tolerance_control.h_po_total_t );
2042:
2043: --

Line 2044: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,

2040: 'Tolerance - h_po_total_t : '||
2041: x_tolerance_control.h_po_total_t );
2042:
2043: --
2044: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
2045: 'Tolerance - l_start_date_t : '||
2046: x_tolerance_control.l_start_date_t );
2047: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
2048: 'Tolerance - l_end_date_t : '||

Line 2047: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,

2043: --
2044: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
2045: 'Tolerance - l_start_date_t : '||
2046: x_tolerance_control.l_start_date_t );
2047: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
2048: 'Tolerance - l_end_date_t : '||
2049: x_tolerance_control.l_end_date_t );
2050: --
2051: END IF;

Line 2055: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,

2051: END IF;
2052:
2053: /* Line Percentage Attibutes */
2054: IF (g_po_wf_debug = 'Y') THEN
2055: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
2056: 'Tolerance - l_quantity_t : '||
2057: x_tolerance_control.l_quantity_t );
2058: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
2059: 'Tolerance - l_unit_price_t : '||

Line 2058: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,

2054: IF (g_po_wf_debug = 'Y') THEN
2055: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
2056: 'Tolerance - l_quantity_t : '||
2057: x_tolerance_control.l_quantity_t );
2058: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
2059: 'Tolerance - l_unit_price_t : '||
2060: x_tolerance_control.l_unit_price_t );
2061: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
2062: 'Tolerance - l_quantity_committed_t : '||

Line 2061: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,

2057: x_tolerance_control.l_quantity_t );
2058: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
2059: 'Tolerance - l_unit_price_t : '||
2060: x_tolerance_control.l_unit_price_t );
2061: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
2062: 'Tolerance - l_quantity_committed_t : '||
2063: x_tolerance_control.l_quantity_committed_t );
2064: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
2065: 'Tolerance - l_committed_amount_t : '||

Line 2064: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,

2060: x_tolerance_control.l_unit_price_t );
2061: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
2062: 'Tolerance - l_quantity_committed_t : '||
2063: x_tolerance_control.l_quantity_committed_t );
2064: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
2065: 'Tolerance - l_committed_amount_t : '||
2066: x_tolerance_control.l_committed_amount_t );
2067: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
2068: 'Tolerance - l_price_limit_t : '||

Line 2067: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,

2063: x_tolerance_control.l_quantity_committed_t );
2064: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
2065: 'Tolerance - l_committed_amount_t : '||
2066: x_tolerance_control.l_committed_amount_t );
2067: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
2068: 'Tolerance - l_price_limit_t : '||
2069: x_tolerance_control.l_price_limit_t );
2070: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
2071: 'Tolerance - l_price_limit_t : '||

Line 2070: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,

2066: x_tolerance_control.l_committed_amount_t );
2067: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
2068: 'Tolerance - l_price_limit_t : '||
2069: x_tolerance_control.l_price_limit_t );
2070: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
2071: 'Tolerance - l_price_limit_t : '||
2072: x_tolerance_control.l_price_limit_t );
2073: --
2074: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,

Line 2074: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,

2070: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
2071: 'Tolerance - l_price_limit_t : '||
2072: x_tolerance_control.l_price_limit_t );
2073: --
2074: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
2075: 'Tolerance - l_amount_t : '||
2076: x_tolerance_control.l_amount_t );
2077: --
2078: END IF;

Line 2082: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,

2078: END IF;
2079:
2080: /* Shipment Percentage Attributes */
2081: IF (g_po_wf_debug = 'Y') THEN
2082: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
2083: 'Tolerance - s_quantity_t : '||
2084: x_tolerance_control.s_quantity_t );
2085: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
2086: 'Tolerance - s_price_override_t : '||

Line 2085: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,

2081: IF (g_po_wf_debug = 'Y') THEN
2082: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
2083: 'Tolerance - s_quantity_t : '||
2084: x_tolerance_control.s_quantity_t );
2085: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
2086: 'Tolerance - s_price_override_t : '||
2087: x_tolerance_control.s_price_override_t );
2088:
2089: --

Line 2090: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,

2086: 'Tolerance - s_price_override_t : '||
2087: x_tolerance_control.s_price_override_t );
2088:
2089: --
2090: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
2091: 'Tolerance - s_amount_t : '||
2092: x_tolerance_control.s_amount_t );
2093: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
2094: 'Tolerance - s_need_by_date_t : '||

Line 2093: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,

2089: --
2090: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
2091: 'Tolerance - s_amount_t : '||
2092: x_tolerance_control.s_amount_t );
2093: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
2094: 'Tolerance - s_need_by_date_t : '||
2095: x_tolerance_control.s_need_by_date_t );
2096: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
2097: 'Tolerance - s_promised_date_t : '||

Line 2096: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,

2092: x_tolerance_control.s_amount_t );
2093: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
2094: 'Tolerance - s_need_by_date_t : '||
2095: x_tolerance_control.s_need_by_date_t );
2096: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
2097: 'Tolerance - s_promised_date_t : '||
2098: x_tolerance_control.s_promised_date_t );
2099: --
2100:

Line 2105: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,

2101: END IF;
2102:
2103: /* Distributions Attributes */
2104: IF (g_po_wf_debug = 'Y') THEN
2105: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
2106: 'Tolerance - d_quantity_ordered_t : '||
2107: x_tolerance_control.d_quantity_ordered_t );
2108: --
2109: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,

Line 2109: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,

2105: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
2106: 'Tolerance - d_quantity_ordered_t : '||
2107: x_tolerance_control.d_quantity_ordered_t );
2108: --
2109: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
2110: 'Tolerance - d_amount_ordered_t : '||
2111: x_tolerance_control.d_amount_ordered_t );
2112: --
2113: END IF;

Line 2116: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

2112: --
2113: END IF;
2114:
2115: IF (g_po_wf_debug = 'Y') THEN
2116: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
2117: '*** FINISH: debug_default_tolerance ***');
2118: END IF;
2119:
2120: EXCEPTION