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

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

670: /* DBMS_OUTPUT.enable(10000); */
671:
672: x_progress := 'PO_REQAPPROVAL_INIT1.Start_WF_Process: at beginning of Start_WF_Process';
673: IF (g_po_wf_debug = 'Y') THEN
674: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
675: END IF;
676:
677: --
678: -- Start Process :

Line 755: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,x_progress);

751: OR (DocumentTypeCode='PO' and DocumentSubtype='STANDARD'))) THEN
752:
753: x_progress := 'PO_REQAPPROVAL_INIT1.Start_WF_Process: Updating the xml_flag: ' || p_xml_flag;
754: IF (g_po_wf_debug = 'Y') THEN
755: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,x_progress);
756: END IF;
757:
758: IF (p_xml_flag = 'Y') THEN
759:

Line 825: PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,x_progress);

821: to skip the PO_APPROVED notification ,when wf is called from cancel.
822: */
823:
824: x_progress := 'start wf process called interface source code:'||ActionOriginatedFrom;
825: PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,x_progress);
826:
827: IF (ActionOriginatedFrom = 'CANCEL') THEN
828:
829: -- If approval workflow is being called from a Cancel action, then

Line 1575: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,x_progress);

1571: END IF;
1572:
1573: x_progress := 'PO_REQAPPROVAL_INIT1.Start_WF_Process: Before call to FND_PROFILE';
1574: IF (g_po_wf_debug = 'Y') THEN
1575: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,x_progress);
1576: END IF;
1577:
1578: /* Get the USER_ID and the RESPONSIBLITY_ID for the current forms session.
1579: ** This will be used in later calls to APPS_INITIALIZE(), before calling

Line 1661: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,l_itemkey,x_progress);

1657:
1658: x_progress := 'PO_REQAPPROVAL_INIT1.Start_WF_Process: Before call to wf_engine.StartProcess()' ||
1659: ' parameter DefaultApprovalPathID= ' || to_char(DefaultApprovalPathID);
1660: IF (g_po_wf_debug = 'Y') THEN
1661: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,l_itemkey,x_progress);
1662: END IF;
1663:
1664: --
1665: wf_engine.StartProcess( itemtype => l_itemtype,

Line 1675: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,l_itemkey,x_progress);

1671: WHEN OTHERS THEN
1672:
1673: x_progress := 'PO_REQAPPROVAL_INIT1.Start_WF_Process: In Exception handler';
1674: IF (g_po_wf_debug = 'Y') THEN
1675: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,l_itemkey,x_progress);
1676: END IF;
1677:
1678: po_message_s.sql_error('In Exception of Start_WF_Process()', x_progress, sqlcode);
1679:

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

1749: BEGIN
1750:
1751: x_progress := 'PO_REQAPPROVAL_INIT1.Set_Startup_Values: 01';
1752: IF (g_po_wf_debug = 'Y') THEN
1753: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
1754: END IF;
1755:
1756:
1757: -- Do nothing in cancel or timeout mode

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

2046: /* Bug 7307832
2047: Added Debug Messages */
2048: x_progress := 'PO_REQAPPROVAL_INIT1.get_po_url viewOnly' || 'l_view_po_url ::'|| l_view_po_url;
2049: IF (g_po_wf_debug = 'Y') THEN
2050: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
2051: END IF;
2052:
2053: IF nvl(l_can_modify_flag,'N') = 'Y' THEN /*Bug 7125551, edit document link should not be available if approver can modify is
2054: unchecked for the document type.*/

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

2059: /* Bug 7307832
2060: Added WF Debug Messages */
2061: x_progress := 'PO_REQAPPROVAL_INIT1.get_po_url update' || 'l_edit_po_url ::'|| l_edit_po_url;
2062: IF (g_po_wf_debug = 'Y') THEN
2063: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
2064: END IF;
2065:
2066: ELSE
2067: l_edit_po_url := null;

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

2404:
2405: x_progress := 'PO_REQAPPROVAL_INIT1.Set_Startup_Values: 03'||
2406: 'Open Form Command= ' || l_open_form;
2407: IF (g_po_wf_debug = 'Y') THEN
2408: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
2409: END IF;
2410:
2411: EXCEPTION
2412:

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

2440: BEGIN
2441:
2442: x_progress := 'PO_REQAPPROVAL_INIT1.Get_Req_Attributes: 01';
2443: IF (g_po_wf_debug = 'Y') THEN
2444: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
2445: END IF;
2446:
2447:
2448: -- Do nothing in cancel or timeout mode

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

2483: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
2484: --
2485: x_progress := 'PO_REQAPPROVAL_INIT1.Get_Req_Attributes: 02';
2486: IF (g_po_wf_debug = 'Y') THEN
2487: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
2488: END IF;
2489:
2490:
2491: EXCEPTION

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

2598: --
2599:
2600: x_progress := 'PO_REQAPPROVAL_INIT1.set_doc_stat_inprocess: 02';
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: EXCEPTION

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

2637: BEGIN
2638:
2639: x_progress := 'PO_REQAPPROVAL_INIT1.set_doc_stat_inprocess: 01';
2640: IF (g_po_wf_debug = 'Y') THEN
2641: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
2642: END IF;
2643:
2644:
2645: -- Do nothing in cancel or timeout mode

Line 2703: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

2699: -- Release functional lock, if needed
2700:
2701: x_progress := 'PO_REQAPPROVAL_INIT1.set_doc_stat_inprocess: 02 unlock document';
2702: IF (g_po_wf_debug = 'Y') THEN
2703: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
2704: END IF;
2705:
2706:
2707: unlock_document

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

2730: --
2731:
2732: x_progress := 'PO_REQAPPROVAL_INIT1.set_doc_stat_inprocess: 02';
2733: IF (g_po_wf_debug = 'Y') THEN
2734: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
2735: END IF;
2736:
2737:
2738: EXCEPTION

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

2768: BEGIN
2769:
2770: x_progress := 'PO_REQAPPROVAL_INIT1.set_doc_to_originalstat: 01';
2771: IF (g_po_wf_debug = 'Y') THEN
2772: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
2773: END IF;
2774:
2775:
2776: -- Do nothing in cancel or timeout mode

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

2855:
2856: x_progress := 'PO_REQAPPROVAL_INIT1.set_doc_to_originalstat: 02' ||
2857: ' Auth_status= ' || l_auth_stat || ', Orig_auth_stat= ' || l_orig_auth_stat;
2858: IF (g_po_wf_debug = 'Y') THEN
2859: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
2860: END IF;
2861:
2862:
2863: -- Bug 3845048: Added the code to update the action history with 'no action'

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

2866:
2867: x_progress := 'PO_REQAPPROVAL_INIT1.set_doc_to_originalstat: 03' || 'Update Action History'
2868: || 'Action Code = No Action';
2869: IF (g_po_wf_debug = 'Y') THEN
2870: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
2871: END IF;
2872: /* This was added for bug 3845048.
2873: As part of fix 5691965 moving this code to prior location in approval wf.
2874: UpdateActionHistory(p_doc_id => l_doc_id,

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

2912: BEGIN
2913:
2914: x_progress := 'PO_REQAPPROVAL_INIT1.Register_doc_submitted: 01';
2915: IF (g_po_wf_debug = 'Y') THEN
2916: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
2917: END IF;
2918:
2919:
2920: -- Do nothing in cancel or timeout mode

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

2965: --
2966:
2967: x_progress := 'PO_REQAPPROVAL_INIT1.Register_doc_submitted: 02';
2968: IF (g_po_wf_debug = 'Y') THEN
2969: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
2970: END IF;
2971:
2972: EXCEPTION
2973: WHEN OTHERS THEN

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

3002: BEGIN
3003:
3004: x_progress := 'PO_REQAPPROVAL_INIT1.can_owner_approve: 01';
3005: IF (g_po_wf_debug = 'Y') THEN
3006: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
3007: END IF;
3008:
3009:
3010: -- Do nothing in cancel or timeout mode

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

3057: END IF;
3058:
3059: x_progress := 'PO_REQAPPROVAL_INIT1.can_owner_approve: 02';
3060: IF (g_po_wf_debug = 'Y') THEN
3061: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
3062: END IF;
3063:
3064: EXCEPTION
3065: WHEN OTHERS THEN

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

3093: BEGIN
3094:
3095: x_progress := 'PO_REQAPPROVAL_INIT1.Is_doc_preapproved: 01';
3096: IF (g_po_wf_debug = 'Y') THEN
3097: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
3098: END IF;
3099:
3100:
3101: -- Do nothing in cancel or timeout mode

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

3177:
3178: x_progress := 'PO_REQAPPROVAL_INIT1.Is_doc_preapproved: 02' ||
3179: ' Authorization_status= ' || l_auth_stat ;
3180: IF (g_po_wf_debug = 'Y') THEN
3181: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
3182: END IF;
3183:
3184:
3185: EXCEPTION

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

3226: BEGIN
3227:
3228: x_progress := 'PO_REQAPPROVAL_INIT1.Ins_actionhist_submit: 01';
3229: IF (g_po_wf_debug = 'Y') THEN
3230: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
3231: END IF;
3232:
3233:
3234: -- Do nothing in cancel or timeout mode

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

3308:
3309:
3310: x_progress := 'PO_REQAPPROVAL_INIT1.Ins_actionhist_submit: 02';
3311: IF (g_po_wf_debug = 'Y') THEN
3312: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
3313: END IF;
3314:
3315: EXCEPTION
3316: WHEN OTHERS THEN

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

3417: --
3418:
3419: x_progress := 'PO_REQAPPROVAL_INIT1.Set_End_Valid_Action: RESULT=VALID_ACTION';
3420: IF (g_po_wf_debug = 'Y') THEN
3421: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
3422: END IF;
3423:
3424: END Set_End_Valid_Action;
3425:

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

3553: resultout := wf_engine.eng_completed || ':' || 'Y' ;
3554: --
3555: x_progress := 'PO_REQAPPROVAL_INIT1.Encumb_on_doc_unreserved: 01';
3556: IF (g_po_wf_debug = 'Y') THEN
3557: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
3558: END IF;
3559:
3560: ELSE
3561: --

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

3562: resultout := wf_engine.eng_completed || ':' || 'N' ;
3563: --
3564: x_progress := 'PO_REQAPPROVAL_INIT1.Encumb_on_doc_unreserved: 02';
3565: IF (g_po_wf_debug = 'Y') THEN
3566: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
3567: END IF;
3568:
3569: END IF;
3570:

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

3622: resultout := wf_engine.eng_completed || ':' || 'N' ;
3623: --
3624: x_progress := 'PO_REQAPPROVAL_INIT1.Encumb_on_doc_commit: 01';
3625: IF (g_po_wf_debug = 'Y') THEN
3626: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
3627: END IF;
3628:
3629: ELSE
3630: --

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

3631: resultout := wf_engine.eng_completed || ':' || 'Y' ;
3632: --
3633: x_progress := 'PO_REQAPPROVAL_INIT1.Encumb_on_doc_commit: 02';
3634: IF (g_po_wf_debug = 'Y') THEN
3635: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
3636: END IF;
3637:
3638: END IF;
3639:

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

3691: BEGIN
3692:
3693: x_progress := 'PO_REQAPPROVAL_INIT1.Remove_reminder_notif: 01';
3694: IF (g_po_wf_debug = 'Y') THEN
3695: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
3696: END IF;
3697:
3698: -- Do nothing in cancel or timeout mode
3699: --

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

3792: resultout := wf_engine.eng_completed ;
3793:
3794: x_progress := 'PO_REQAPPROVAL_INIT1.Remove_reminder_notif: 02.';
3795: IF (g_po_wf_debug = 'Y') THEN
3796: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
3797: END IF;
3798:
3799: EXCEPTION
3800: WHEN OTHERS THEN

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

3821:
3822: BEGIN
3823: x_progress := 'PO_REQAPPROVAL_INIT1.Print_Doc_Yes_No: 01';
3824: IF (g_po_wf_debug = 'Y') THEN
3825: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
3826: END IF;
3827:
3828:
3829: -- Do nothing in cancel or timeout mode

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

3848: resultout := wf_engine.eng_completed || ':' || l_print_doc ;
3849: --
3850: x_progress := 'PO_REQAPPROVAL_INIT1.Print_Doc_Yes_No: 02. Result= ' || l_print_doc;
3851: IF (g_po_wf_debug = 'Y') THEN
3852: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
3853: END IF;
3854:
3855: EXCEPTION
3856: WHEN OTHERS THEN

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

3880:
3881: BEGIN
3882: x_progress := 'PO_REQAPPROVAL_INIT1.Fax_Doc_Yes_No: 01';
3883: IF (g_po_wf_debug = 'Y') THEN
3884: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
3885: END IF;
3886:
3887:
3888: -- Do nothing in cancel or timeout mode

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

3907: resultout := wf_engine.eng_completed || ':' || l_fax_doc ;
3908: --
3909: x_progress := 'PO_REQAPPROVAL_INIT1.Fax_Doc_Yes_No: 02. Result= ' || l_fax_doc;
3910: IF (g_po_wf_debug = 'Y') THEN
3911: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
3912: END IF;
3913:
3914: EXCEPTION
3915: WHEN OTHERS THEN

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

3942:
3943: BEGIN
3944: x_progress := 'PO_REQAPPROVAL_INIT1.Create_SR_ASL_Yes_No: 01';
3945: IF (g_po_wf_debug = 'Y') THEN
3946: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
3947: END IF;
3948:
3949: -- Do nothing in cancel or timeout mode
3950: if (funcmode <> wf_engine.eng_run) then

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

4019: resultout := wf_engine.eng_completed || ':' || l_create_sr_asl;
4020:
4021: x_progress := 'PO_REQAPPROVAL_INIT1.Create_SR_ASL_Yes_No: 02. Result= ' || l_create_sr_asl;
4022: IF (g_po_wf_debug = 'Y') THEN
4023: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
4024: END IF;
4025:
4026: EXCEPTION
4027: WHEN OTHERS THEN

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

4055:
4056: BEGIN
4057: x_progress := 'PO_REQAPPROVAL_INIT1.Send_Notification_Yes_No: 01';
4058: IF (g_po_wf_debug = 'Y') THEN
4059: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
4060: END IF;
4061:
4062:
4063: -- Do nothing in cancel or timeout mode

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

4101: resultout := wf_engine.eng_completed || ':' || l_send_notif ;
4102:
4103: x_progress := 'PO_REQAPPROVAL_INIT1.Send_Notification_Yes_No: 02. Result= ' || l_send_notif;
4104: IF (g_po_wf_debug = 'Y') THEN
4105: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
4106: END IF;
4107:
4108: EXCEPTION
4109: WHEN OTHERS THEN

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

4143:
4144: BEGIN
4145: x_progress := 'PO_REQAPPROVAL_INIT1.Send_WS_FYI_Notif_Yes_No: 01';
4146: IF (g_po_wf_debug = 'Y') THEN
4147: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
4148: END IF;
4149:
4150:
4151: -- Do nothing in cancel or timeout mode

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

4212:
4213:
4214: x_progress := 'PO_REQAPPROVAL_INIT1.Send_WS_FYI_Notif_Yes_No: 02. Result= ' || l_send_notif;
4215: IF (g_po_wf_debug = 'Y') THEN
4216: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
4217: END IF;
4218:
4219: EXCEPTION
4220: WHEN OTHERS THEN

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

4251:
4252: BEGIN
4253: x_progress := 'PO_REQAPPROVAL_INIT1.Send_WS_ACK_Notif_Yes_No: 01';
4254: IF (g_po_wf_debug = 'Y') THEN
4255: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
4256: END IF;
4257:
4258:
4259: -- Do nothing in cancel or timeout mode

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

4293: resultout := wf_engine.eng_completed || ':' || l_send_notif ;
4294:
4295: x_progress := 'PO_REQAPPROVAL_INIT1.Send_WS_ACK_Notif_Yes_No: 02. Result= ' || l_send_notif;
4296: IF (g_po_wf_debug = 'Y') THEN
4297: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
4298: END IF;
4299:
4300: EXCEPTION
4301: WHEN OTHERS THEN

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

4602:
4603: BEGIN
4604: x_progress := 'PO_REQAPPROVAL_INIT1.Email_Doc_Yes_No: 01';
4605: IF (g_po_wf_debug = 'Y') THEN
4606: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
4607: END IF;
4608:
4609:
4610: -- Do nothing in cancel or timeout mode

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

4788: resultout := wf_engine.eng_completed || ':' || l_email_doc ;
4789:
4790: x_progress := 'PO_REQAPPROVAL_INIT1.Email_Doc_Yes_No: 02. Result= ' || l_email_doc;
4791: IF (g_po_wf_debug = 'Y') THEN
4792: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
4793: END IF;
4794:
4795: -- resultout := wf_engine.eng_completed || ':' || 'Y' ;
4796:

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

4833:
4834: BEGIN
4835: x_progress := 'PO_REQAPPROVAL_INIT1.Print_Document: 01';
4836: IF (g_po_wf_debug = 'Y') THEN
4837: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
4838: END IF;
4839:
4840:
4841: -- Do nothing in cancel or timeout mode

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

4894:
4895: BEGIN
4896: x_progress := 'PO_REQAPPROVAL_INIT1.Fax_Document: 01';
4897: IF (g_po_wf_debug = 'Y') THEN
4898: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
4899: END IF;
4900:
4901:
4902: -- Do nothing in cancel or timeout mode

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

4968:
4969: BEGIN
4970: x_progress := 'PO_REQAPPROVAL_INIT1.Is_document_Approved: 01';
4971: IF (g_po_wf_debug = 'Y') THEN
4972: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
4973: END IF;
4974:
4975:
4976: -- Do nothing in cancel or timeout mode

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

5042: END IF;
5043:
5044: x_progress := 'PO_REQAPPROVAL_INIT1.Is_document_Approved: 02. Result=' || x_resultout;
5045: IF (g_po_wf_debug = 'Y') THEN
5046: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress );
5047: END IF;
5048:
5049: EXCEPTION
5050:

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

5080:
5081:
5082: x_progress := 'PO_REQAPPROVAL_INIT1.Get_Create_PO_Mode: 01';
5083: IF (g_po_wf_debug = 'Y') THEN
5084: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
5085: END IF;
5086:
5087:
5088: -- Do nothing in cancel or timeout mode

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

5112:
5113: x_progress := 'PO_REQAPPROVAL_INIT1.Get_Create_PO_Mode: ' ||
5114: 'Create PO Mode= ' || l_create_po_mode;
5115: IF (g_po_wf_debug = 'Y') THEN
5116: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
5117: END IF;
5118:
5119:
5120: EXCEPTION

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

5152: /* get the profile PO_WORKFLOW_APPROVAL_MODE and return the value */
5153:
5154: x_progress := 'PO_REQAPPROVAL_INIT1.Get_Workflow_Approval_Mode: 01';
5155: IF (g_po_wf_debug = 'Y') THEN
5156: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
5157: END IF;
5158:
5159:
5160: -- Do nothing in cancel or timeout mode

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

5182:
5183: x_progress := 'PO_REQAPPROVAL_INIT1.Get_Workflow_Approval_Mode: ' ||
5184: 'Approval Mode= ' || l_approval_mode;
5185: IF (g_po_wf_debug = 'Y') THEN
5186: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
5187: END IF;
5188:
5189:
5190: EXCEPTION

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

5239:
5240:
5241: x_progress := 'PO_REQAPPROVAL_INIT1.GetReqAttributes: 01';
5242: IF (g_po_wf_debug = 'Y') THEN
5243: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
5244: END IF;
5245:
5246: /* Fetch the Req Header, then set the attributes. */
5247: open GetRecHdr_csr(p_requisition_header_id);

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

5249: close GetRecHdr_csr;
5250:
5251: x_progress := 'PO_REQAPPROVAL_INIT1.GetReqAttributes: 02';
5252: IF (g_po_wf_debug = 'Y') THEN
5253: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
5254: END IF;
5255:
5256: SetReqHdrAttributes(itemtype, itemkey);
5257:

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

5256: SetReqHdrAttributes(itemtype, itemkey);
5257:
5258: x_progress := 'PO_REQAPPROVAL_INIT1.GetReqAttributes: 03';
5259: IF (g_po_wf_debug = 'Y') THEN
5260: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
5261: END IF;
5262:
5263: EXCEPTION
5264: WHEN OTHERS THEN

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

5337: FROM po_system_parameters;
5338:
5339: l_progress := 'getReqAmountInfo:' || l_rate_type;
5340: IF (g_po_wf_debug = 'Y') THEN
5341: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
5342: END IF;
5343:
5344: l_approver_user_name := PO_WF_UTIL_PKG.GetItemAttrText(itemtype=>itemtype,
5345: itemkey=>itemkey,

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

5351: WHERE user_name = l_approver_user_name;
5352:
5353: l_progress := 'getReqAmountInfo:' || l_user_id;
5354: IF (g_po_wf_debug = 'Y') THEN
5355: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
5356: END IF;
5357:
5358: l_approval_currency := FND_PROFILE.VALUE_SPECIFIC('ICX_PREFERRED_CURRENCY', l_user_id);
5359: end if;

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

5367: end if;
5368:
5369: l_progress := 'getReqAmountInfo:' || l_approval_currency;
5370: IF (g_po_wf_debug = 'Y') THEN
5371: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
5372: END IF;
5373:
5374: gl_currency_api.get_closest_triangulation_rate(
5375: x_from_currency => p_function_currency,

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

5384:
5385: l_progress := 'getReqAmountInfo:' || substrb(to_char(l_rate), 1, 30);
5386:
5387: IF (g_po_wf_debug = 'Y') THEN
5388: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
5389: END IF;
5390:
5391: /* setting amount for notification subject */
5392: l_amount_approval_currency := (p_total_amount/l_denominator_rate) * l_numerator_rate;

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

5402: FND_CURRENCY.GET_FORMAT_MASK(l_approval_currency,g_currency_format_mask));
5403:
5404: l_progress := 'getReqAmountInfo:' || l_amount_disp;
5405: IF (g_po_wf_debug = 'Y') THEN
5406: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
5407: END IF;
5408:
5409: x_amount_for_header := p_req_amount_disp || ' ' || p_function_currency;
5410: x_amount_for_header := x_amount_for_header || ' (' || l_amount_disp || ' ' || l_approval_currency || ')';

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

5421: when gl_currency_api.no_rate then
5422: l_progress := 'getReqAmountInfo: no rate';
5423:
5424: IF (g_po_wf_debug = 'Y') THEN
5425: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
5426: END IF;
5427: x_amount_for_subject := p_req_amount_disp || ' ' || p_function_currency;
5428:
5429: l_no_rate_msg := fnd_message.get_string('PO', 'PO_WF_NOTIF_NO_RATE');

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

5439:
5440: l_progress := 'getReqAmountInfo:' || substrb(SQLERRM, 1,200);
5441:
5442: IF (g_po_wf_debug = 'Y') THEN
5443: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
5444: END IF;
5445: x_amount_for_subject := p_req_amount_disp || ' ' || p_function_currency;
5446: x_amount_for_header := p_req_amount_disp || ' ' || p_function_currency;
5447: x_amount_for_tax := p_tax_amount_disp || ' ' || p_function_currency;

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

5560: BEGIN
5561:
5562: x_progress := 'PO_REQAPPROVAL_INIT1.SetReqHdrAttributes: 01';
5563: IF (g_po_wf_debug = 'Y') THEN
5564: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
5565: END IF;
5566:
5567:
5568: wf_engine.SetItemAttrText ( itemtype => itemtype,

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

5605:
5606: -- Bug#3147435
5607: x_progress := 'PO_REQAPPROVAL_INIT1.SetReqHdrAttributes: 02 Start of Hdr Att for JRAD';
5608: IF (g_po_wf_debug = 'Y') THEN
5609: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
5610: END IF;
5611:
5612: -- Bug#3147435
5613: --Set the CONTRACTOR_REQUISITION_FLAG

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

5627:
5628: -- Bug#3147435
5629: x_progress := 'PO_REQAPPROVAL_INIT1.SetReqHdrAttributes: 03 End of Hdr Att for JRAD';
5630: IF (g_po_wf_debug = 'Y') THEN
5631: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
5632: END IF;
5633:
5634: /* Bug 1100247 Amitabh*/
5635: PO_REQAPPROVAL_INIT1.get_user_name(ReqHdr_rec.preparer_id, x_username,

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

5821:
5822: x_progress := 'SetReqHdrAttributes (end): : ' || l_auth_stat ||
5823: l_currency_code || l_req_amount_disp;
5824: IF (g_po_wf_debug = 'Y') THEN
5825: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
5826: END IF;
5827:
5828: if (ReqHdr_rec.NOTE_TO_AUTHORIZER is not null) then
5829: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype,

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

6639: BEGIN
6640:
6641: x_progress := 'PO_REQAPPROVAL_INIT1.PrintDocument: 01';
6642: IF (g_po_wf_debug = 'Y') THEN
6643: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
6644: END IF;
6645:
6646: -- Get the profile option report_quantity_precision
6647:

Line 6737: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

6733: ' conc_copies '||l_conc_copies||
6734: ' save o/p '||l_conc_save_output;
6735:
6736: IF (g_po_wf_debug = 'Y') THEN
6737: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
6738: END IF;
6739: --
6740:
6741: if (l_printer is not null) then

Line 6750: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

6746: if (l_spo_result) then
6747: --
6748: x_progress := 'SPO:set print options successful';
6749: IF (g_po_wf_debug = 'Y') THEN
6750: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
6751: END IF;
6752: --
6753: else
6754: --

Line 6757: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

6753: else
6754: --
6755: x_progress := 'SPO:set print options not successful ';
6756: IF (g_po_wf_debug = 'Y') THEN
6757: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
6758: END IF;
6759: --
6760: end if;
6761: end if;

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

6790: avalue => l_request_id);
6791:
6792: x_progress := 'PO_REQAPPROVAL_INIT1.PrintDocument: 02. request_id= ' || to_char(l_request_id);
6793: IF (g_po_wf_debug = 'Y') THEN
6794: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
6795: END IF;
6796:
6797: EXCEPTION
6798:

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

6832: BEGIN
6833:
6834: x_progress := 'PO_REQAPPROVAL_INIT1.FaxDocument: 01';
6835: IF (g_po_wf_debug = 'Y') THEN
6836: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
6837: END IF;
6838:
6839: -- Get the profile option report_quantity_precision
6840:

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

6945: avalue => l_request_id);
6946:
6947: x_progress := 'PO_REQAPPROVAL_INIT1.FaxDocument: 02. request_id= ' || to_char(l_request_id);
6948: IF (g_po_wf_debug = 'Y') THEN
6949: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
6950: END IF;
6951:
6952: EXCEPTION
6953:

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

7551:
7552: BEGIN
7553: l_progress:='001-'||funcmode;
7554: IF (g_po_wf_debug = 'Y') THEN
7555: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
7556: END IF;
7557:
7558: IF (funcmode='RUN') THEN
7559: l_contractor_status := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

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

7561: aname => 'CONTRACTOR_STATUS');
7562:
7563: l_progress:='002-'||l_contractor_status;
7564: IF (g_po_wf_debug = 'Y') THEN
7565: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
7566: END IF;
7567:
7568: IF (l_contractor_status = 'PENDING') THEN
7569: --Bug#3268971

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

7577: resultout:='COMPLETE:'||'Y';
7578:
7579: l_progress:='003-'||resultout;
7580: IF (g_po_wf_debug = 'Y') THEN
7581: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
7582: END IF;
7583:
7584: return;
7585: ELSE

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

7586: resultout:='COMPLETE:'||'N';
7587:
7588: l_progress:='004-'||resultout;
7589: IF (g_po_wf_debug = 'Y') THEN
7590: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
7591: END IF;
7592:
7593: return;
7594: END IF;

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

7631:
7632: BEGIN
7633: x_progress := 'PO_REQAPPROVAL_INIT1.Is_Submitter_Last_Approver: 01';
7634: IF (g_po_wf_debug = 'Y') THEN
7635: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);
7636: END IF;
7637:
7638: preparer_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
7639: itemkey => itemkey,

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

7798: -- To be used only for PO and Req Approval wf
7799:
7800: x_progress := 'PO_REQAPPROVAL_INIT1.send_error_notif: 10';
7801: IF (g_po_wf_debug = 'Y') THEN
7802: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
7803: END IF;
7804:
7805: x_progress := 'PO_REQAPPROVAL_INIT1.send_error_notif: 20'
7806: ||' username: '|| username

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

7807: ||' doc: '|| doc
7808: ||' location: '|| loc
7809: ||' error msg: '|| msg;
7810: IF (g_po_wf_debug = 'Y') THEN
7811: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
7812: END IF;
7813:
7814:
7815: if username is not null and doc is not null then

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

7846: ||' Parent Itemkey: '|| ItemKey
7847: ||' Error Itemtype: '|| Err_ItemType
7848: ||' Error Itemkey: '|| Err_ItemKey;
7849: IF (g_po_wf_debug = 'Y') THEN
7850: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
7851: END IF;
7852:
7853: wf_engine.CreateProcess( ItemType => Err_ItemType,
7854: ItemKey => Err_ItemKey,

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

7855: process => 'PLSQL_ERROR_NOTIF');
7856:
7857: x_progress := 'PO_REQAPPROVAL_INIT1.send_error_notif: 70';
7858: IF (g_po_wf_debug = 'Y') THEN
7859: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
7860: END IF;
7861:
7862: -- Set the attributes
7863: wf_engine.SetItemAttrText ( itemtype => Err_ItemType,

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

7882: avalue => username);
7883: --
7884: x_progress := 'PO_REQAPPROVAL_INIT1.send_error_notif: 100';
7885: IF (g_po_wf_debug = 'Y') THEN
7886: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
7887: END IF;
7888:
7889:
7890: wf_engine.StartProcess(itemtype => Err_ItemType,

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

7891: itemkey => Err_ItemKey);
7892:
7893: x_progress := 'PO_REQAPPROVAL_INIT1.send_error_notif: 900';
7894: IF (g_po_wf_debug = 'Y') THEN
7895: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
7896: END IF;
7897:
7898: commit;
7899:

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

7902: EXCEPTION
7903: WHEN OTHERS THEN
7904: x_progress := 'PO_REQAPPROVAL_INIT1.send_error_notif: '|| sqlerrm;
7905: IF (g_po_wf_debug = 'Y') THEN
7906: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
7907: END IF;
7908: RAISE;
7909:
7910: END send_error_notif;

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

7946: IF (funcmode='RUN') THEN
7947:
7948: l_progress := 'Is_Document_Manager_Error_1_2: 001';
7949: IF (g_po_wf_debug = 'Y') THEN
7950: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
7951: END IF;
7952:
7953: l_error_number:=
7954: wf_engine.GetItemAttrNumber ( itemtype => itemtype,

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

7957:
7958: l_progress := 'Is_Document_Manager_Error_1_2: 002 - '||
7959: to_char(l_error_number);
7960: IF (g_po_wf_debug = 'Y') THEN
7961: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
7962: END IF;
7963:
7964: IF (l_error_number = 1 or l_error_number = 2) THEN
7965: resultout:='COMPLETE:'||'Y';

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

7997:
7998: BEGIN
7999: x_progress := 'PO_REQAPPROVAL_INIT1.profile_value_check: 01';
8000: IF (g_po_wf_debug = 'Y') THEN
8001: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
8002: END IF;
8003:
8004:
8005: -- Do nothing in cancel or timeout mode

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

8026: resultout := wf_engine.eng_completed || ':' || l_prof_value ;
8027: --
8028: x_progress := 'PO_REQAPPROVAL_INIT1.profile_value_check: 02. Result= ' || l_prof_value;
8029: IF (g_po_wf_debug = 'Y') THEN
8030: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
8031: END IF;
8032:
8033: EXCEPTION
8034: WHEN OTHERS THEN

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

8056: IF (funcmode='RUN') THEN
8057:
8058: l_progress := 'CHECK_ERROR_COUNT: 001';
8059: IF (g_po_wf_debug = 'Y') THEN
8060: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
8061: END IF;
8062:
8063: l_item_type :=wf_engine.GetItemAttrText ( itemtype => itemtype,
8064: itemkey => itemkey,

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

8140: IF (funcmode='RUN') THEN
8141:
8142: l_progress := 'Initialise_Error: 001';
8143: IF (g_po_wf_debug = 'Y') THEN
8144: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
8145: END IF;
8146:
8147: l_item_type :=wf_engine.GetItemAttrText ( itemtype => itemtype,
8148: itemkey => itemkey,

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

8974: || to_char(x_user_id)
8975: || 'X_ APPLICATION_ID= ' || to_char(x_application_id)
8976: || 'X_RESPONSIBILITY_ID= ' || to_char(x_responsibility_id);
8977: IF (g_po_wf_debug = 'Y') THEN
8978: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
8979: END IF;
8980:
8981:
8982: IF (X_User_Id = -1) THEN

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

9007: || to_char(l_user_id)
9008: || ' L_APPLICATION_ID= ' || to_char(l_application_id)
9009: || 'L_RESPONSIBILITY_ID= ' || to_char(l_responsibility_id);
9010: IF (g_po_wf_debug = 'Y') THEN
9011: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
9012: END IF;
9013:
9014: -- bug 3543578
9015: -- Returning a Req from AutoCreate was nulling out the FND context.

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

9090: BEGIN
9091:
9092: l_progress := 'PO_REQAPPROVAL_INIT1.MassUpdate_Releases_Yes_No: 01';
9093: IF (g_po_wf_debug = 'Y') THEN
9094: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
9095: END IF;
9096:
9097: -- Do nothing in cancel or timeout mode
9098: if (funcmode <> wf_engine.eng_run) then

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

9163: resultout := wf_engine.eng_completed || ':' || l_massupdate_releases;
9164:
9165: l_progress := 'PO_REQAPPROVAL_INIT1.MassUpdate_Releases_Yes_No: 02. Result= ' || l_massupdate_releases;
9166: IF (g_po_wf_debug = 'Y') THEN
9167: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
9168: END IF;
9169:
9170: EXCEPTION
9171: WHEN OTHERS THEN

Line 9219: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

9215: Exception
9216: when others then
9217: l_progress := 'PO_REQAPPROVAL_INIT1.MassUpdate_Releases_Workflow: Could not find Category Structure Id';
9218: IF (g_po_wf_debug = 'Y') THEN
9219: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
9220: END IF;
9221: raise;
9222: End;
9223: --

Line 9256: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

9252: End if;
9253:
9254: l_progress := ': 02. Result= ' || l_update_releases;
9255: IF (g_po_wf_debug = 'Y') THEN
9256: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
9257: END IF;
9258: resultout := wf_engine.eng_completed || ':' || l_update_releases;
9259: EXCEPTION
9260: WHEN OTHERS THEN

Line 9266: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

9262: l_progress := 'PO_REQAPPROVAL_INIT1.MassUpdate_Releases_Workflow: 03.'||
9263: ' Result= ' || l_update_releases;
9264: resultout := wf_engine.eng_completed || ':' || l_update_releases;
9265: IF (g_po_wf_debug = 'Y') THEN
9266: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
9267: END IF;
9268: END MassUpdate_Releases_Workflow;
9269:
9270: procedure Send_Supplier_Comm_Yes_No( itemtype in varchar2,

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

9315: resultout := wf_engine.eng_completed || ':' || l_supplier_comm;
9316:
9317: l_progress := 'PO_REQAPPROVAL_INIT1.Send_Supplier_Comm_Yes_No: 02. Result= ' || l_supplier_comm;
9318: IF (g_po_wf_debug = 'Y') THEN
9319: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
9320: END IF;
9321:
9322:
9323: EXCEPTION

Line 9393: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

9389: BEGIN
9390:
9391: l_progress := 'PO_REQAPPROVAL_INIT1.Retro_Invoice_Release_WF: 01';
9392: IF (g_po_wf_debug = 'Y') THEN
9393: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
9394: END IF;
9395:
9396: resultout := wf_engine.eng_completed || ':' || l_update_releases;
9397:

Line 9422: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

9418: 'l_document_type = ' || l_document_type ||
9419: 'l_retro_change = ' || l_retro_change ;
9420:
9421: IF (g_po_wf_debug = 'Y') THEN
9422: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
9423: END IF;
9424:
9425: -- Only handle retroactive invoice change for PO or Release
9426: IF (l_document_type NOT IN ('PO', 'RELEASE')) THEN

Line 9444: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

9440:
9441: l_progress := 'PO_REQAPPROVAL_INIT1.Retro_Invoice_Release_WF: 03' ||
9442: 'l_retro_change = ' || l_retro_change ;
9443: IF (g_po_wf_debug = 'Y') THEN
9444: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
9445: END IF;
9446:
9447:
9448: END IF; /*IF (l_retro_change IS NULL OR l_retro_change = 'N')*/

Line 9456: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

9452:
9453: l_progress := 'PO_REQAPPROVAL_INIT1.Retro_Invoice_Release_WF: 04' ||
9454: 'l_retroactive_update = ' || l_retroactive_update;
9455: IF (g_po_wf_debug = 'Y') THEN
9456: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
9457: END IF;
9458:
9459: -- Need to reset retroactive_date afterwards
9460: l_reset_retro_update := TRUE;

Line 9472: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

9468: l_progress := 'PO_REQAPPROVAL_INIT1.Retro_Invoice_Release_WF: 05' ||
9469: 'l_retroactive_update = ' || l_retroactive_update ||
9470: 'l_retro_change = ' || l_retro_change ;
9471: IF (g_po_wf_debug = 'Y') THEN
9472: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
9473: END IF;
9474:
9475: -- Set 'CO_R_RETRO_CHANGE' attribute so that later Workflow process can
9476: -- use this attribute safely

Line 9486: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

9482: IF (l_retro_change = 'Y' AND l_retroactive_update = 'ALL_RELEASES') THEN
9483: l_progress := 'PO_REQAPPROVAL_INIT1.Retro_Invoice_Release_WF: 06. Calling ' ||
9484: 'PO_RETROACTIVE_PRICING_PVT.Retro_Invoice_Release';
9485: IF (g_po_wf_debug = 'Y') THEN
9486: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
9487: END IF;
9488:
9489: PO_RETROACTIVE_PRICING_PVT.Retro_Invoice_Release
9490: ( p_api_version => 1.0,

Line 9504: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

9500:
9501: l_progress := 'PO_REQAPPROVAL_INIT1.Retro_Invoice_Release_WF: 07. Result= ' ||
9502: l_update_releases;
9503: IF (g_po_wf_debug = 'Y') THEN
9504: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
9505: END IF;
9506:
9507: END IF; /*IF (l_retro_change = 'Y' AND l_retroactive_update = 'ALL_RELEASES')*/
9508:

Line 9512: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

9508:
9509: IF (l_reset_retro_update) THEN
9510: l_progress := 'PO_REQAPPROVAL_INIT1.Retro_Invoice_Release_WF: 08. Reset_Retro_Update';
9511: IF (g_po_wf_debug = 'Y') THEN
9512: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
9513: END IF;
9514:
9515: PO_RETROACTIVE_PRICING_PVT.Reset_Retro_Update(
9516: p_document_id => l_document_id,

Line 9529: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

9525: l_progress := 'PO_REQAPPROVAL_INIT1.Retro_Invoice_Release_WF: 09.'||
9526: ' Result= ' || l_update_releases;
9527: resultout := wf_engine.eng_completed || ':' || l_update_releases;
9528: IF (g_po_wf_debug = 'Y') THEN
9529: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
9530: END IF;
9531:
9532: END Retro_Invoice_Release_WF;
9533:

Line 9707: PO_WF_DEBUG_PKG.insert_debug(p_item_type,p_item_key,l_progress);

9703: l_cat_admin_user_name FND_USER.USER_NAME%type;
9704: BEGIN
9705: l_progress := '100';
9706: IF (g_po_wf_debug = 'Y') THEN
9707: PO_WF_DEBUG_PKG.insert_debug(p_item_type,p_item_key,l_progress);
9708: END IF;
9709:
9710: l_progress := '110';
9711: -- Get the Catalog Admin User Name

Line 9719: PO_WF_DEBUG_PKG.insert_debug(p_item_type,p_item_key,'Item Attribute value for CATALOG_ADMIN_USER_NAME='|| l_cat_admin_user_name);

9715: aname => 'CATALOG_ADMIN_USER_NAME');
9716:
9717: l_progress := '130';
9718: IF (g_po_wf_debug = 'Y') THEN
9719: PO_WF_DEBUG_PKG.insert_debug(p_item_type,p_item_key,'Item Attribute value for CATALOG_ADMIN_USER_NAME='|| l_cat_admin_user_name);
9720: END IF;
9721:
9722: IF l_cat_admin_user_name is not null THEN
9723: l_progress := '150';

Line 9786: PO_WF_DEBUG_PKG.insert_debug(p_item_type,p_item_key,l_progress);

9782: l_progress := 'PO_REQAPPROVAL_INIT1.set_catalog_admin_user_name: 100' ||
9783: 'Document Id='|| to_char(p_doc_id) ||
9784: 'Document Type='|| p_doc_type;
9785: IF (g_po_wf_debug = 'Y') THEN
9786: PO_WF_DEBUG_PKG.insert_debug(p_item_type,p_item_key,l_progress);
9787: END IF;
9788:
9789: l_progress := 'PO_REQAPPROVAL_INIT1.set_catalog_admin_user_name: 110';
9790: -- Proceed only if this is an agreement

Line 9792: PO_WF_DEBUG_PKG.insert_debug(p_item_type,p_item_key,l_progress);

9788:
9789: l_progress := 'PO_REQAPPROVAL_INIT1.set_catalog_admin_user_name: 110';
9790: -- Proceed only if this is an agreement
9791: IF (g_po_wf_debug = 'Y') THEN
9792: PO_WF_DEBUG_PKG.insert_debug(p_item_type,p_item_key,l_progress);
9793: END IF;
9794:
9795: IF p_doc_type = 'PA' THEN
9796: -- Get the locking user role and user id information

Line 9807: PO_WF_DEBUG_PKG.insert_debug(p_item_type,p_item_key,l_progress);

9803: 'l_lock_owner_user_id ='|| to_char(l_lock_owner_user_id) ||
9804: 'l_lock_owner_role Type='|| l_lock_owner_role;
9805:
9806: IF (g_po_wf_debug = 'Y') THEN
9807: PO_WF_DEBUG_PKG.insert_debug(p_item_type,p_item_key,l_progress);
9808: END IF;
9809:
9810: IF l_lock_owner_role = 'CAT ADMIN' THEN
9811: l_progress := 'PO_REQAPPROVAL_INIT1.set_catalog_admin_user_name: 150';

Line 9822: PO_WF_DEBUG_PKG.insert_debug(p_item_type,p_item_key,l_progress);

9818:
9819: l_progress := 'PO_REQAPPROVAL_INIT1.set_catalog_admin_user_name: 155' ||
9820: 'UserName='|| l_user_name;
9821: IF (g_po_wf_debug = 'Y') THEN
9822: PO_WF_DEBUG_PKG.insert_debug(p_item_type,p_item_key,l_progress);
9823: END IF;
9824:
9825: l_progress := 'PO_REQAPPROVAL_INIT1.set_catalog_admin_user_name: 160';
9826: -- Set the item attribute tied to the performer of the

Line 9966: PO_WF_DEBUG_PKG.insert_debug(p_item_type, p_item_key, l_progress || 'Begin');

9962: l_progress VARCHAR2(300);
9963: begin
9964: l_progress := 'PO_REQAPPROVAL_INIT1.set_is_supplier_context_y: ';
9965: IF (g_po_wf_debug = 'Y') THEN
9966: PO_WF_DEBUG_PKG.insert_debug(p_item_type, p_item_key, l_progress || 'Begin');
9967: END IF;
9968:
9969: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => p_item_type,
9970: itemkey => p_item_key,

Line 9975: PO_WF_DEBUG_PKG.insert_debug(p_item_type, p_item_key, l_progress || 'End');

9971: aname => 'IS_SUPPLIER_CONTEXT',
9972: avalue => 'Y');
9973:
9974: IF (g_po_wf_debug = 'Y') THEN
9975: PO_WF_DEBUG_PKG.insert_debug(p_item_type, p_item_key, l_progress || 'End');
9976: END IF;
9977:
9978: EXCEPTION
9979: WHEN OTHERS THEN

Line 9981: PO_WF_DEBUG_PKG.insert_debug(p_item_type, p_item_key, l_progress || 'Unexpected error');

9977:
9978: EXCEPTION
9979: WHEN OTHERS THEN
9980: IF (g_po_wf_debug = 'Y') THEN
9981: PO_WF_DEBUG_PKG.insert_debug(p_item_type, p_item_key, l_progress || 'Unexpected error');
9982: END IF;
9983: RAISE;
9984: end set_is_supplier_context_y; */
9985:

Line 10007: PO_WF_DEBUG_PKG.insert_debug(p_item_type, p_item_key, l_progress || 'Begin');

10003: begin
10004:
10005: l_progress := 'PO_REQAPPROVAL_INIT1.set_is_supplier_context_n: ';
10006: IF (g_po_wf_debug = 'Y') THEN
10007: PO_WF_DEBUG_PKG.insert_debug(p_item_type, p_item_key, l_progress || 'Begin');
10008: END IF;
10009:
10010: -- Set the IS_SUPPLIER_CONTEXT value to 'N'
10011: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => p_item_type,

Line 10017: PO_WF_DEBUG_PKG.insert_debug(p_item_type, p_item_key, l_progress || 'End');

10013: aname => 'IS_SUPPLIER_CONTEXT',
10014: avalue => 'N');
10015:
10016: IF (g_po_wf_debug = 'Y') THEN
10017: PO_WF_DEBUG_PKG.insert_debug(p_item_type, p_item_key, l_progress || 'End');
10018: END IF;
10019:
10020: EXCEPTION
10021: WHEN OTHERS THEN

Line 10023: PO_WF_DEBUG_PKG.insert_debug(p_item_type, p_item_key, l_progress || 'Unexpected error');

10019:
10020: EXCEPTION
10021: WHEN OTHERS THEN
10022: IF (g_po_wf_debug = 'Y') THEN
10023: PO_WF_DEBUG_PKG.insert_debug(p_item_type, p_item_key, l_progress || 'Unexpected error');
10024: END IF;
10025: RAISE;
10026: end set_is_supplier_context_n; */
10027: --

Line 10121: PO_WF_DEBUG_PKG.insert_debug(p_item_type, p_item_key, l_progress || 'Begin');

10117: l_progress VARCHAR2(300);
10118: begin
10119: l_progress := 'PO_REQAPPROVAL_INIT1.set_is_supplier_context_y: ';
10120: IF (g_po_wf_debug = 'Y') THEN
10121: PO_WF_DEBUG_PKG.insert_debug(p_item_type, p_item_key, l_progress || 'Begin');
10122: END IF;
10123:
10124: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => p_item_type,
10125: itemkey => p_item_key,

Line 10130: PO_WF_DEBUG_PKG.insert_debug(p_item_type, p_item_key, l_progress || 'End');

10126: aname => 'IS_SUPPLIER_CONTEXT',
10127: avalue => 'Y');
10128:
10129: IF (g_po_wf_debug = 'Y') THEN
10130: PO_WF_DEBUG_PKG.insert_debug(p_item_type, p_item_key, l_progress || 'End');
10131: END IF;
10132:
10133: EXCEPTION
10134: WHEN OTHERS THEN

Line 10136: PO_WF_DEBUG_PKG.insert_debug(p_item_type, p_item_key, l_progress || 'Unexpected error');

10132:
10133: EXCEPTION
10134: WHEN OTHERS THEN
10135: IF (g_po_wf_debug = 'Y') THEN
10136: PO_WF_DEBUG_PKG.insert_debug(p_item_type, p_item_key, l_progress || 'Unexpected error');
10137: END IF;
10138: RAISE;
10139: end set_is_supplier_context_y;
10140:

Line 10162: PO_WF_DEBUG_PKG.insert_debug(p_item_type, p_item_key, l_progress || 'Begin');

10158: begin
10159:
10160: l_progress := 'PO_REQAPPROVAL_INIT1.set_is_supplier_context_n: ';
10161: IF (g_po_wf_debug = 'Y') THEN
10162: PO_WF_DEBUG_PKG.insert_debug(p_item_type, p_item_key, l_progress || 'Begin');
10163: END IF;
10164:
10165: -- Set the IS_SUPPLIER_CONTEXT value to 'N'
10166: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => p_item_type,

Line 10172: PO_WF_DEBUG_PKG.insert_debug(p_item_type, p_item_key, l_progress || 'End');

10168: aname => 'IS_SUPPLIER_CONTEXT',
10169: avalue => 'N');
10170:
10171: IF (g_po_wf_debug = 'Y') THEN
10172: PO_WF_DEBUG_PKG.insert_debug(p_item_type, p_item_key, l_progress || 'End');
10173: END IF;
10174:
10175: EXCEPTION
10176: WHEN OTHERS THEN

Line 10178: PO_WF_DEBUG_PKG.insert_debug(p_item_type, p_item_key, l_progress || 'Unexpected error');

10174:
10175: EXCEPTION
10176: WHEN OTHERS THEN
10177: IF (g_po_wf_debug = 'Y') THEN
10178: PO_WF_DEBUG_PKG.insert_debug(p_item_type, p_item_key, l_progress || 'Unexpected error');
10179: END IF;
10180: RAISE;
10181: end set_is_supplier_context_n;
10182: --