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 WF_CORE

Line 2115: wf_core.context('PO_REQAPPROVAL_INIT1','Set_Startup_Values',x_progress);

2111: EXCEPTION
2112: WHEN OTHERS THEN
2113: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
2114: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
2115: wf_core.context('PO_REQAPPROVAL_INIT1','Set_Startup_Values',x_progress);
2116: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_INIT1.SET_STARTUP_VALUES');
2117: raise;
2118: END Set_Startup_Values;
2119: --

Line 2172: wf_core.context('PO_REQAPPROVAL_INIT1','Get_Req_Attributes',x_progress);

2168: EXCEPTION
2169: WHEN OTHERS THEN
2170: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
2171: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
2172: wf_core.context('PO_REQAPPROVAL_INIT1','Get_Req_Attributes',x_progress);
2173: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_INIT1.GET_REQ_ATTRIBUTES');
2174: raise;
2175: END Get_Req_Attributes;
2176: -- set_doc_stat_preapproved

Line 2248: wf_core.context('PO_REQAPPROVAL_INIT1','set_doc_stat_preapproved',x_progress);

2244: EXCEPTION
2245: WHEN OTHERS THEN
2246: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
2247: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
2248: wf_core.context('PO_REQAPPROVAL_INIT1','set_doc_stat_preapproved',x_progress);
2249: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_INIT1.SET_DOC_STAT_PREAPPROVED');
2250: raise;
2251: END set_doc_stat_preapproved;
2252: /* New procedure for set status preapproved added to call from workflow POAPPAME*/

Line 2314: wf_core.context('PO_REQAPPROVAL_INIT1','set_doc_stat_preapproved',x_progress);

2310: EXCEPTION
2311: WHEN OTHERS THEN
2312: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
2313: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
2314: wf_core.context('PO_REQAPPROVAL_INIT1','set_doc_stat_preapproved',x_progress);
2315: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_INIT1.SET_DOC_STAT_PREAPPROVED');
2316: raise;
2317: END set_doc_stat_preapproved1;
2318: -- set_doc_stat_inprocess

Line 2412: wf_core.context('PO_REQAPPROVAL_INIT1','set_doc_stat_inprocess',x_progress);

2408: EXCEPTION
2409: WHEN OTHERS THEN
2410: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
2411: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
2412: wf_core.context('PO_REQAPPROVAL_INIT1','set_doc_stat_inprocess',x_progress);
2413: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_INIT1.SET_DOC_STAT_INPROCESS');
2414: raise;
2415: END set_doc_stat_inprocess;
2416: --

Line 2530: wf_core.context('PO_REQAPPROVAL_INIT1','set_doc_stat_inprocess',x_progress);

2526: EXCEPTION
2527: WHEN OTHERS THEN
2528: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
2529: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
2530: wf_core.context('PO_REQAPPROVAL_INIT1','set_doc_stat_inprocess',x_progress);
2531: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_INIT1.SET_DOC_STAT_INPROCESS');
2532: raise;
2533: END set_doc_to_originalstat;
2534: -- Register_doc_submitted

Line 2591: wf_core.context('PO_REQAPPROVAL_INIT1','Register_doc_submitted',x_progress);

2587: EXCEPTION
2588: WHEN OTHERS THEN
2589: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
2590: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
2591: wf_core.context('PO_REQAPPROVAL_INIT1','Register_doc_submitted',x_progress);
2592: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_INIT1.REGISTER_DOC_SUBMITTED');
2593: raise;
2594: END Register_doc_submitted;
2595: --

Line 2658: wf_core.context('PO_REQAPPROVAL_INIT1','can_owner_approve',x_progress);

2654: EXCEPTION
2655: WHEN OTHERS THEN
2656: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
2657: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
2658: wf_core.context('PO_REQAPPROVAL_INIT1','can_owner_approve',x_progress);
2659: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_INIT1.CAN_OWNER_APPROVE');
2660: raise;
2661: END can_owner_approve;
2662:

Line 2781: wf_core.context('PO_REQAPPROVAL_INIT1','Is_doc_preapproved',x_progress);

2777: EXCEPTION
2778: WHEN OTHERS THEN
2779: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
2780: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
2781: wf_core.context('PO_REQAPPROVAL_INIT1','Is_doc_preapproved',x_progress);
2782: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_INIT1.IS_DOC_PREAPPROVED');
2783: raise;
2784: END Is_doc_preapproved;
2785: --

Line 2875: wf_core.context('PO_REQAPPROVAL_INIT1','Ins_actionhist_submit',x_progress);

2871: EXCEPTION
2872: WHEN OTHERS THEN
2873: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
2874: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
2875: wf_core.context('PO_REQAPPROVAL_INIT1','Ins_actionhist_submit',x_progress);
2876: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_INIT1.INS_ACTIONHIST_SUBMIT');
2877: raise;
2878: END Ins_actionhist_submit;
2879: --

Line 3085: wf_core.context('PO_REQAPPROVAL_INIT1.Encumb_on_doc_unreserved',x_progress);

3081: EXCEPTION
3082: WHEN OTHERS THEN
3083: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
3084: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
3085: wf_core.context('PO_REQAPPROVAL_INIT1.Encumb_on_doc_unreserved',x_progress);
3086: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_INIT1.ENCUMB_ON_DOC_UNRESERVED');
3087: raise;
3088: END Encumb_on_doc_unreserved;
3089: --

Line 3170: wf_core.context('PO_REQAPPROVAL_INIT1.Encumb_on_doc_unreserved',x_progress);

3166: EXCEPTION
3167: WHEN OTHERS THEN
3168: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
3169: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
3170: wf_core.context('PO_REQAPPROVAL_INIT1.Encumb_on_doc_unreserved',x_progress);
3171: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_INIT1.RESERVE_AT_COMPLETION_CHECK');
3172: raise;
3173: END RESERVE_AT_COMPLETION_CHECK;
3174: -- Remove_reminder_notif

Line 3302: wf_core.context('PO_REQAPPROVAL_INIT1.Remove_reminder_notif',x_progress);

3298: EXCEPTION
3299: WHEN OTHERS THEN
3300: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
3301: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
3302: wf_core.context('PO_REQAPPROVAL_INIT1.Remove_reminder_notif',x_progress);
3303: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_INIT1.REMOVE_REMINDER_NOTIF');
3304: raise;
3305: END Remove_reminder_notif;
3306: PROCEDURE Print_Doc_Yes_No

Line 3348: wf_core.context('PO_REQAPPROVAL_INIT1.Print_Doc_Yes_No',x_progress);

3344: EXCEPTION
3345: WHEN OTHERS THEN
3346: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
3347: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
3348: wf_core.context('PO_REQAPPROVAL_INIT1.Print_Doc_Yes_No',x_progress);
3349: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_INIT1.PRINT_DOC_YES_NO');
3350: raise;
3351: END Print_Doc_Yes_No;
3352: -- DKC 10/10/99

Line 3395: wf_core.context('PO_REQAPPROVAL_INIT1.Fax_Doc_Yes_No',x_progress);

3391: EXCEPTION
3392: WHEN OTHERS THEN
3393: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
3394: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
3395: wf_core.context('PO_REQAPPROVAL_INIT1.Fax_Doc_Yes_No',x_progress);
3396: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_INIT1.FAX_DOC_YES_NO');
3397: raise;
3398: END Fax_Doc_Yes_No;
3399: --SR-ASL FPH --

Line 3526: wf_core.context('PO_REQAPPROVAL_INIT1.Send_Notification_Yes_No',x_progress);

3522: EXCEPTION
3523: WHEN OTHERS THEN
3524: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
3525: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
3526: wf_core.context('PO_REQAPPROVAL_INIT1.Send_Notification_Yes_No',x_progress);
3527: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_INIT1.FAX_DOC_YES_NO');
3528: raise;
3529: END Send_WS_Notif_Yes_No;
3530: /*

Line 3602: wf_core.context('PO_REQAPPROVAL_INIT1.Send_WS_FYI_Notif_Yes_No',x_progress);

3598: EXCEPTION
3599: WHEN OTHERS THEN
3600: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
3601: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
3602: wf_core.context('PO_REQAPPROVAL_INIT1.Send_WS_FYI_Notif_Yes_No',x_progress);
3603: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_INIT1.Send_WS_FYI_Notif_Yes_No');
3604: raise;
3605: END Send_WS_FYI_Notif_Yes_No;
3606: /*

Line 3659: wf_core.context('PO_REQAPPROVAL_INIT1.Send_WS_ACK_Notif_Yes_No',x_progress);

3655: EXCEPTION
3656: WHEN OTHERS THEN
3657: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
3658: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
3659: wf_core.context('PO_REQAPPROVAL_INIT1.Send_WS_ACK_Notif_Yes_No',x_progress);
3660: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_INIT1.Send_WS_ACK_Notif_Yes_No');
3661: raise;
3662: END Send_WS_ACK_Notif_Yes_No;
3663: /*

Line 3856: wf_core.context('PO_REQAPPROVAL_INIT1.locate_notifier failed at:',l_step);

3852: END IF;
3853: END IF;
3854: EXCEPTION
3855: WHEN OTHERS THEN
3856: wf_core.context('PO_REQAPPROVAL_INIT1.locate_notifier failed at:',l_step);
3857: wf_core.context('PO_REQAPPROVAL_INIT1.locate_notifier',l_role_name||sqlerrm);
3858: --raise_application_error(-20001,'l_role_name ='||l_role_name ||' and l_step='||l_step ||' and l_list='||l_namelist_for_sql, true);
3859: END locate_notifier;
3860: -- DKC 02/06/01

Line 3857: wf_core.context('PO_REQAPPROVAL_INIT1.locate_notifier',l_role_name||sqlerrm);

3853: END IF;
3854: EXCEPTION
3855: WHEN OTHERS THEN
3856: wf_core.context('PO_REQAPPROVAL_INIT1.locate_notifier failed at:',l_step);
3857: wf_core.context('PO_REQAPPROVAL_INIT1.locate_notifier',l_role_name||sqlerrm);
3858: --raise_application_error(-20001,'l_role_name ='||l_role_name ||' and l_step='||l_step ||' and l_list='||l_namelist_for_sql, true);
3859: END locate_notifier;
3860: -- DKC 02/06/01
3861: PROCEDURE Email_Doc_Yes_No

Line 4092: wf_core.context('PO_REQAPPROVAL_INIT1.Email_Doc_Yes_No',x_progress||':'||sqlerrm);

4088: EXCEPTION
4089: WHEN OTHERS THEN
4090: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
4091: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
4092: wf_core.context('PO_REQAPPROVAL_INIT1.Email_Doc_Yes_No',x_progress||':'||sqlerrm);
4093: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_INIT1.EMAIL_DOC_YES_NO');
4094: raise;
4095: END Email_Doc_Yes_No;
4096: -- Print_Document

Line 4139: wf_core.context('PO_REQAPPROVAL_INIT1.Print_Document',x_progress);

4135: EXCEPTION
4136: WHEN OTHERS THEN
4137: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
4138: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
4139: wf_core.context('PO_REQAPPROVAL_INIT1.Print_Document',x_progress);
4140: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_INIT1.PRINT_DOCUMENT');
4141: raise;
4142: END Print_Document;
4143: -- Procedure called by wf.

Line 4184: wf_core.context('PO_REQAPPROVAL_INIT1.Fax_Document',x_progress);

4180: EXCEPTION
4181: WHEN OTHERS THEN
4182: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
4183: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
4184: wf_core.context('PO_REQAPPROVAL_INIT1.Fax_Document',x_progress);
4185: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_INIT1.FAX_DOCUMENT');
4186: raise;
4187: END Fax_Document;
4188: -- Is_document_Approved

Line 4271: wf_core.context('PO_REQAPPROVAL_INIT1','Is_document_Approved',x_progress);

4267: EXCEPTION
4268: WHEN OTHERS THEN
4269: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
4270: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
4271: wf_core.context('PO_REQAPPROVAL_INIT1','Is_document_Approved',x_progress);
4272: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_INIT1.IS_DOCUMENT_APPROVED');
4273: raise;
4274: END Is_document_Approved;
4275: -- Get_Create_PO_Mode

Line 4325: wf_core.context('PO_REQAPPROVAL_INIT1','Get_Create_PO_Mode',x_progress);

4321: EXCEPTION
4322: WHEN OTHERS THEN
4323: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
4324: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
4325: wf_core.context('PO_REQAPPROVAL_INIT1','Get_Create_PO_Mode',x_progress);
4326: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_INIT1.GET_CREATE_PO_MODE');
4327: raise;
4328: END Get_Create_PO_Mode;
4329: -- Get_Workflow_Approval_Mode

Line 4381: wf_core.context('PO_REQAPPROVAL_INIT1','Get_Workflow_Approval_Mode',x_progress);

4377: EXCEPTION
4378: WHEN OTHERS THEN
4379: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
4380: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
4381: wf_core.context('PO_REQAPPROVAL_INIT1','Get_Workflow_Approval_Mode',x_progress);
4382: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_INIT1.GET_WORKFLOW_APPROVAL_MODE');
4383: raise;
4384: END Get_Workflow_Approval_Mode;
4385: -- Dummy

Line 4443: wf_core.context('PO_REQAPPROVAL_INIT1','GetReqAttributes',x_progress);

4439: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
4440: END IF;
4441: EXCEPTION
4442: WHEN OTHERS THEN
4443: wf_core.context('PO_REQAPPROVAL_INIT1','GetReqAttributes',x_progress);
4444: raise;
4445: END GetReqAttributes;
4446: --
4447: --------------------------------------------------------------------------------

Line 4894: wf_core.context('PO_REQAPPROVAL_INIT1','SetReqHdrAttributes',x_progress);

4890: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype, itemkey => itemkey, aname => 'JUSTIFICATION', avalue => ReqHdr_rec.NOTE_TO_AUTHORIZER);
4891: END IF;
4892: EXCEPTION
4893: WHEN OTHERS THEN
4894: wf_core.context('PO_REQAPPROVAL_INIT1','SetReqHdrAttributes',x_progress);
4895: raise;
4896: END SetReqHdrAttributes;
4897:
4898: /* added as part of bug 10399957 - deadlock issue during updating comm_rev_num value */

Line 4931: wf_core.context('PO_REQAPPROVAL_INIT1','Set_Comm_Rev_Num',x_progress);

4927:
4928: EXCEPTION
4929: WHEN OTHERS THEN
4930: ROLLBACK TO save_rev_num;
4931: wf_core.context('PO_REQAPPROVAL_INIT1','Set_Comm_Rev_Num',x_progress);
4932: raise;
4933:
4934: End Set_Comm_Rev_Num;
4935: --

Line 5012: wf_core.context('PO_REQAPPROVAL_INIT1','SetReqAuthStat',x_progress);

5008: END IF;
5009: COMMIT;
5010: EXCEPTION
5011: WHEN OTHERS THEN
5012: wf_core.context('PO_REQAPPROVAL_INIT1','SetReqAuthStat',x_progress);
5013: raise;
5014: END SetReqAuthStat;
5015: --
5016: PROCEDURE SetPOAuthStat

Line 5083: wf_core.context('PO_REQAPPROVAL_INIT1','SetPOAuthStat',x_progress);

5079: END IF;
5080: COMMIT;
5081: EXCEPTION
5082: WHEN OTHERS THEN
5083: wf_core.context('PO_REQAPPROVAL_INIT1','SetPOAuthStat',x_progress);
5084: raise;
5085: END SetPOAuthStat;
5086: --
5087: PROCEDURE SetRelAuthStat

Line 5129: wf_core.context('PO_REQAPPROVAL_INIT1','SetRelAuthStat',x_progress);

5125: END IF;
5126: COMMIT;
5127: EXCEPTION
5128: WHEN OTHERS THEN
5129: wf_core.context('PO_REQAPPROVAL_INIT1','SetRelAuthStat',x_progress);
5130: raise;
5131: END SetRelAuthStat;
5132: --
5133: --

Line 5154: wf_core.context('PO_REQAPPROVAL_INIT1','UpdtReqItemtype',x_progress);

5150: WHERE requisition_header_id = p_doc_id;
5151: COMMIT;
5152: EXCEPTION
5153: WHEN OTHERS THEN
5154: wf_core.context('PO_REQAPPROVAL_INIT1','UpdtReqItemtype',x_progress);
5155: raise;
5156: END UpdtReqItemtype;
5157: --
5158: PROCEDURE UpdtPOItemtype

Line 5179: wf_core.context('PO_REQAPPROVAL_INIT1','UpdtPOItemtype',x_progress);

5175: WHERE po_header_id = p_doc_id;
5176: COMMIT;
5177: EXCEPTION
5178: WHEN OTHERS THEN
5179: wf_core.context('PO_REQAPPROVAL_INIT1','UpdtPOItemtype',x_progress);
5180: raise;
5181: END UpdtPOItemtype;
5182: --
5183: PROCEDURE UpdtRelItemtype

Line 5204: wf_core.context('PO_REQAPPROVAL_INIT1','UpdtRelItemtype',x_progress);

5200: WHERE po_release_id = p_doc_id;
5201: COMMIT;
5202: EXCEPTION
5203: WHEN OTHERS THEN
5204: wf_core.context('PO_REQAPPROVAL_INIT1','UpdtRelItemtype',x_progress);
5205: raise;
5206: END UpdtRelItemtype;
5207: --
5208: PROCEDURE GetCanOwnerApprove

Line 5234: wf_core.context('PO_REQAPPROVAL_INIT1','GetCanOwnerApprove',x_progress);

5230:
5231: CLOSE C1;
5232: EXCEPTION
5233: WHEN OTHERS THEN
5234: wf_core.context('PO_REQAPPROVAL_INIT1','GetCanOwnerApprove',x_progress);
5235: raise;
5236: END GetCanOwnerApprove;
5237: --
5238: /*****************************************************************************

Line 5281: wf_core.context('PO_REQAPPROVAL_INIT1','get_multiorg_context',x_progress);

5277: CLOSE get_release_orgid;
5278: END IF;
5279: EXCEPTION
5280: WHEN OTHERS THEN
5281: wf_core.context('PO_REQAPPROVAL_INIT1','get_multiorg_context',x_progress);
5282: raise;
5283: END get_multiorg_context;
5284: --
5285: PROCEDURE get_employee_id

Line 5315: wf_core.context('PO_REQAPPROVAL_INIT1','get_employee_id',p_username);

5311: END IF;
5312: CLOSE c_empid;
5313: EXCEPTION
5314: WHEN OTHERS THEN
5315: wf_core.context('PO_REQAPPROVAL_INIT1','get_employee_id',p_username);
5316: raise;
5317: END get_employee_id;
5318: --
5319: PROCEDURE get_user_name

Line 5331: wf_core.context('PO_REQAPPROVAL_INIT1','get_user_name',TO_CHAR(p_employee_id));

5327: p_orig_system:= 'PER';
5328: WF_DIRECTORY.GetUserName(p_orig_system, p_employee_id, x_username, x_user_display_name);
5329: EXCEPTION
5330: WHEN OTHERS THEN
5331: wf_core.context('PO_REQAPPROVAL_INIT1','get_user_name',TO_CHAR(p_employee_id));
5332: raise;
5333: END get_user_name;
5334: --
5335: PROCEDURE InsertActionHistSubmit

Line 5618: wf_core.context

5614: x_progress := '007';
5615: COMMIT;
5616: EXCEPTION
5617: WHEN OTHERS THEN
5618: wf_core.context
5619: (
5620: 'PO_REQAPPROVAL_INIT1','InsertActionHistSubmit',x_progress
5621: )
5622: ;

Line 5696: wf_core.context

5692: l_unreserved_flag
5693: )
5694: ;
5695: WHEN OTHERS THEN
5696: wf_core.context
5697: (
5698: 'PO_REQAPPROVAL_INIT1','EncumbOn_DocUnreserved', l_progress
5699: )
5700: ;

Line 5990: wf_core.context

5986: ;
5987: END IF;
5988: EXCEPTION
5989: WHEN OTHERS THEN
5990: wf_core.context
5991: (
5992: 'PO_REQAPPROVAL_INIT1','PrintDocument',x_progress
5993: )
5994: ;

Line 6230: wf_core.context

6226: ;
6227: END IF;
6228: EXCEPTION
6229: WHEN OTHERS THEN
6230: wf_core.context
6231: (
6232: 'PO_REQAPPROVAL_INIT1','FaxDocument',x_progress
6233: )
6234: ;

Line 6278: wf_core.context

6274: )
6275: ;
6276: EXCEPTION
6277: WHEN OTHERS THEN
6278: wf_core.context
6279: (
6280: 'PO_REQAPPROVAL_INIT1','Print_Requisition',x_progress
6281: )
6282: ;

Line 6397: wf_core.context

6393: )
6394: ;
6395: EXCEPTION
6396: WHEN OTHERS THEN
6397: wf_core.context
6398: (
6399: 'PO_REQAPPROVAL_INIT1','Print_PO',x_progress
6400: )
6401: ;

Line 6525: wf_core.context

6521: )
6522: ;
6523: EXCEPTION
6524: WHEN OTHERS THEN
6525: wf_core.context
6526: (
6527: 'PO_REQAPPROVAL_INIT1','Fax_PO',x_progress
6528: )
6529: ;

Line 6644: wf_core.context

6640: )
6641: ;
6642: EXCEPTION
6643: WHEN OTHERS THEN
6644: wf_core.context
6645: (
6646: 'PO_REQAPPROVAL_INIT1','Print_Release',x_progress
6647: )
6648: ;

Line 6770: wf_core.context

6766: )
6767: ;
6768: EXCEPTION
6769: WHEN OTHERS THEN
6770: wf_core.context
6771: (
6772: 'PO_REQAPPROVAL_INIT1','Fax_Release',x_progress
6773: )
6774: ;

Line 6843: wf_core.context('PO_REQAPPROVAL_INIT1','is_apps_source_POR',l_progress);

6839: EXCEPTION
6840: WHEN OTHERS THEN
6841: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
6842: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
6843: wf_core.context('PO_REQAPPROVAL_INIT1','is_apps_source_POR',l_progress);
6844: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_INIT1.IS_APPS_SOURCE_POR');
6845: RAISE;
6846: END is_apps_source_POR;
6847: -- Bug#3147435

Line 6902: wf_core.context('PO_REQAPPROVAL_INIT1','is_contractor_status_pending',l_progress);

6898: EXCEPTION
6899: WHEN OTHERS THEN
6900: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
6901: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
6902: wf_core.context('PO_REQAPPROVAL_INIT1','is_contractor_status_pending',l_progress);
6903: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_INIT1.is_contractor_status_pending');
6904: RAISE;
6905: END is_contractor_status_pending;
6906: -- Bug 823167 kbenjami

Line 6953: wf_core.context('PO_REQAPPROVAL_INIT1','Is_Submitter_Last_Approver',x_progress);

6949: EXCEPTION
6950: WHEN OTHERS THEN
6951: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
6952: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
6953: wf_core.context('PO_REQAPPROVAL_INIT1','Is_Submitter_Last_Approver',x_progress);
6954: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_INIT1.IS_SUBMITTER_LAST_APPROVER');
6955: raise;
6956: END Is_Submitter_Last_Approver;
6957: --

Line 7193: WF_CORE.context('PO_APPROVAL_LIST_WF1S' , 'Is_Document_Manager_Error_1_2', itemtype, itemkey, l_progress);

7189: END IF;
7190: END IF; --run mode
7191: EXCEPTION
7192: WHEN OTHERS THEN
7193: WF_CORE.context('PO_APPROVAL_LIST_WF1S' , 'Is_Document_Manager_Error_1_2', itemtype, itemkey, l_progress);
7194: resultout:='COMPLETE:'||'N';
7195: END Is_Document_Manager_Error_1_2;
7196: /**************************************************************************/
7197: PROCEDURE PROFILE_VALUE_CHECK

Line 7241: WF_CORE.context('PO_REQAPPROVAL_INIT1', 'PROFILE_VALUE_CHECK' , itemtype, itemkey, x_progress);

7237: EXCEPTION
7238: WHEN OTHERS THEN
7239: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
7240: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
7241: WF_CORE.context('PO_REQAPPROVAL_INIT1', 'PROFILE_VALUE_CHECK' , itemtype, itemkey, x_progress);
7242: resultout:='COMPLETE:'||'N';
7243: END;
7244: PROCEDURE Check_Error_Count
7245: (

Line 7282: WF_CORE.context('PO_APPROVAL_LIST_WF1S' , 'Check_Error_Count', itemtype, itemkey, l_progress);

7278: END IF;
7279: END IF; --run mode
7280: EXCEPTION
7281: WHEN OTHERS THEN
7282: WF_CORE.context('PO_APPROVAL_LIST_WF1S' , 'Check_Error_Count', itemtype, itemkey, l_progress);
7283: resultout:='COMPLETE:'||'N';
7284: END Check_Error_Count;
7285: PROCEDURE Initialise_Error
7286: (

Line 7398: WF_CORE.context('PO_APPROVAL_LIST_WF1S' , 'Initialise_Error', itemtype, itemkey, l_progress);

7394: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_item_type, itemkey => l_item_key, aname => 'SYSADMIN_ERROR_MSG' , avalue => l_sys_error_msg);
7395: END IF; --run mode
7396: EXCEPTION
7397: WHEN OTHERS THEN
7398: WF_CORE.context('PO_APPROVAL_LIST_WF1S' , 'Initialise_Error', itemtype, itemkey, l_progress);
7399: resultout:='COMPLETE:'||'N';
7400: END Initialise_Error;
7401: PROCEDURE acceptance_required
7402: (

Line 7476: wf_core.context('PO_REQAPPROVAL_INIT1','acceptance_required',x_progress);

7472: END IF;
7473: /*** (Bug 5501659) ***/
7474: EXCEPTION
7475: WHEN OTHERS THEN
7476: wf_core.context('PO_REQAPPROVAL_INIT1','acceptance_required',x_progress);
7477: raise;
7478: END;
7479: --
7480: PROCEDURE Register_acceptance

Line 7610: wf_core.context('PO_REQAPPROVAL_INIT1','Register_acceptance',x_progress);

7606: -- insert acceptance record.
7607: Insert_Acc_Rejection_Row(itemtype, itemkey, actid, 'Y');
7608: EXCEPTION
7609: WHEN OTHERS THEN
7610: wf_core.context('PO_REQAPPROVAL_INIT1','Register_acceptance',x_progress);
7611: raise;
7612: END;
7613: --
7614: PROCEDURE Register_rejection

Line 7747: wf_core.context('PO_REQAPPROVAL_INIT1','Register_rejection',x_progress);

7743: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype, itemkey => itemkey, aname => 'BUYER_USER_NAME', avalue => l_role_name);
7744: END IF;
7745: EXCEPTION
7746: WHEN OTHERS THEN
7747: wf_core.context('PO_REQAPPROVAL_INIT1','Register_rejection',x_progress);
7748: raise;
7749: END;
7750: PROCEDURE Insert_Acc_Rejection_Row
7751: (

Line 7968: wf_core.context('PO_REQAPPROVAL_ACTION','set_doc_mgr_context',x_progress);

7964: -- Bug 3571038
7965: igi_sls_context_pkg.set_sls_context;
7966: EXCEPTION
7967: WHEN OTHERS THEN
7968: wf_core.context('PO_REQAPPROVAL_ACTION','set_doc_mgr_context',x_progress);
7969: raise;
7970: END Set_doc_mgr_context;
7971: /* RETROACTIVE FPI START */
7972: PROCEDURE MassUpdate_Releases_Yes_No

Line 8483: wf_core.context('PO_REQAPPROVAL_INIT1','should_notify_cat_admin',l_progress||' DocumentId='||TO_CHAR(l_doc_id));

8479: END IF;
8480: l_progress := '200';
8481: EXCEPTION
8482: WHEN OTHERS THEN
8483: wf_core.context('PO_REQAPPROVAL_INIT1','should_notify_cat_admin',l_progress||' DocumentId='||TO_CHAR(l_doc_id));
8484: raise;
8485: END should_notify_cat_admin;
8486: -------------------------------------------------------------------------------
8487: --Start of Comments : R12 Online authoring Notifications

Line 8577: wf_core.context('PO_REQAPPROVAL_INIT1','set_catalog_admin_user_name',l_progress||' DocumentId='||TO_CHAR(p_doc_id));

8573: END IF; -- End of Check for "PA" (Agreement check)
8574: l_progress := '200';
8575: EXCEPTION
8576: WHEN OTHERS THEN
8577: wf_core.context('PO_REQAPPROVAL_INIT1','set_catalog_admin_user_name',l_progress||' DocumentId='||TO_CHAR(p_doc_id));
8578: raise;
8579: END set_catalog_admin_user_name;
8580: -------------------------------------------------------------------------------
8581: --Start of Comments : HTML Orders R12

Line 9017: wf_core.context('PO_REQAPPROVAL_INIT1','SetModUpdateAfterCDGenFlag',x_progress);

9013: END IF;
9014: COMMIT;
9015: EXCEPTION
9016: WHEN OTHERS THEN
9017: wf_core.context('PO_REQAPPROVAL_INIT1','SetModUpdateAfterCDGenFlag',x_progress);
9018: raise;
9019: END SetModUpdateAfterCDGenFlag;
9020:
9021: -- code added for bug 8291565 FP