DBA Data[Home] [Help]

APPS.PO_REQAPPROVAL_INIT1 dependencies on WF_CORE

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

2412:
2413: WHEN OTHERS THEN
2414: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
2415: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
2416: wf_core.context('PO_REQAPPROVAL_INIT1','Set_Startup_Values',x_progress);
2417: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_INIT1.SET_STARTUP_VALUES');
2418: raise;
2419:
2420: END Set_Startup_Values;

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

2492:
2493: WHEN OTHERS THEN
2494: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
2495: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
2496: wf_core.context('PO_REQAPPROVAL_INIT1','Get_Req_Attributes',x_progress);
2497: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_INIT1.GET_REQ_ATTRIBUTES');
2498: raise;
2499:
2500: END Get_Req_Attributes;

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

2606: EXCEPTION
2607: WHEN OTHERS THEN
2608: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
2609: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
2610: wf_core.context('PO_REQAPPROVAL_INIT1','set_doc_stat_preapproved',x_progress);
2611: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_INIT1.SET_DOC_STAT_PREAPPROVED');
2612: raise;
2613:
2614: END set_doc_stat_preapproved;

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

2738: EXCEPTION
2739: WHEN OTHERS THEN
2740: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
2741: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
2742: wf_core.context('PO_REQAPPROVAL_INIT1','set_doc_stat_inprocess',x_progress);
2743: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_INIT1.SET_DOC_STAT_INPROCESS');
2744: raise;
2745:
2746: END set_doc_stat_inprocess;

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

2884: EXCEPTION
2885: WHEN OTHERS THEN
2886: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
2887: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
2888: wf_core.context('PO_REQAPPROVAL_INIT1','set_doc_stat_inprocess',x_progress);
2889: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_INIT1.SET_DOC_STAT_INPROCESS');
2890: raise;
2891:
2892: END set_doc_to_originalstat;

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

2972: EXCEPTION
2973: WHEN OTHERS THEN
2974: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
2975: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
2976: wf_core.context('PO_REQAPPROVAL_INIT1','Register_doc_submitted',x_progress);
2977: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_INIT1.REGISTER_DOC_SUBMITTED');
2978: raise;
2979:
2980: END Register_doc_submitted;

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

3064: EXCEPTION
3065: WHEN OTHERS THEN
3066: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
3067: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
3068: wf_core.context('PO_REQAPPROVAL_INIT1','can_owner_approve',x_progress);
3069: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_INIT1.CAN_OWNER_APPROVE');
3070: raise;
3071:
3072: END can_owner_approve;

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

3185: EXCEPTION
3186: WHEN OTHERS THEN
3187: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
3188: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
3189: wf_core.context('PO_REQAPPROVAL_INIT1','Is_doc_preapproved',x_progress);
3190: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_INIT1.IS_DOC_PREAPPROVED');
3191: raise;
3192:
3193: END Is_doc_preapproved;

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

3315: EXCEPTION
3316: WHEN OTHERS THEN
3317: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
3318: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
3319: wf_core.context('PO_REQAPPROVAL_INIT1','Ins_actionhist_submit',x_progress);
3320: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_INIT1.INS_ACTIONHIST_SUBMIT');
3321: raise;
3322:
3323: END Ins_actionhist_submit;

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

3571: EXCEPTION
3572: WHEN OTHERS THEN
3573: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
3574: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
3575: wf_core.context('PO_REQAPPROVAL_INIT1.Encumb_on_doc_unreserved',x_progress);
3576: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_INIT1.ENCUMB_ON_DOC_UNRESERVED');
3577: raise;
3578:
3579: END Encumb_on_doc_unreserved;

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

3640: EXCEPTION
3641: WHEN OTHERS THEN
3642: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
3643: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
3644: wf_core.context('PO_REQAPPROVAL_INIT1.Encumb_on_doc_unreserved',x_progress);
3645: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_INIT1.RESERVE_AT_COMPLETION_CHECK');
3646: raise;
3647:
3648: END RESERVE_AT_COMPLETION_CHECK;

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

3799: EXCEPTION
3800: WHEN OTHERS THEN
3801: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
3802: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
3803: wf_core.context('PO_REQAPPROVAL_INIT1.Remove_reminder_notif',x_progress);
3804: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_INIT1.REMOVE_REMINDER_NOTIF');
3805: raise;
3806:
3807: END Remove_reminder_notif;

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

3855: EXCEPTION
3856: WHEN OTHERS THEN
3857: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
3858: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
3859: wf_core.context('PO_REQAPPROVAL_INIT1.Print_Doc_Yes_No',x_progress);
3860: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_INIT1.PRINT_DOC_YES_NO');
3861: raise;
3862:
3863: END Print_Doc_Yes_No;

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

3914: EXCEPTION
3915: WHEN OTHERS THEN
3916: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
3917: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
3918: wf_core.context('PO_REQAPPROVAL_INIT1.Fax_Doc_Yes_No',x_progress);
3919: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_INIT1.FAX_DOC_YES_NO');
3920: raise;
3921:
3922: END Fax_Doc_Yes_No;

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

4108: EXCEPTION
4109: WHEN OTHERS THEN
4110: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
4111: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
4112: wf_core.context('PO_REQAPPROVAL_INIT1.Send_Notification_Yes_No',x_progress);
4113: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_INIT1.FAX_DOC_YES_NO');
4114: raise;
4115:
4116: END Send_WS_Notif_Yes_No;

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

4219: EXCEPTION
4220: WHEN OTHERS THEN
4221: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
4222: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
4223: wf_core.context('PO_REQAPPROVAL_INIT1.Send_WS_FYI_Notif_Yes_No',x_progress);
4224: 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');
4225: raise;
4226:
4227: END Send_WS_FYI_Notif_Yes_No;

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

4300: EXCEPTION
4301: WHEN OTHERS THEN
4302: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
4303: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
4304: wf_core.context('PO_REQAPPROVAL_INIT1.Send_WS_ACK_Notif_Yes_No',x_progress);
4305: 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');
4306: raise;
4307:
4308: END Send_WS_ACK_Notif_Yes_No;

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

4558: end if;
4559: END IF;
4560: EXCEPTION
4561: WHEN OTHERS THEN
4562: wf_core.context('PO_REQAPPROVAL_INIT1.locate_notifier failed at:',l_step);
4563: wf_core.context('PO_REQAPPROVAL_INIT1.locate_notifier',l_role_name||sqlerrm);
4564: --raise_application_error(-20001,'l_role_name ='||l_role_name ||' and l_step='||l_step ||' and l_list='||l_namelist_for_sql, true);
4565: end locate_notifier;
4566:

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

4559: END IF;
4560: EXCEPTION
4561: WHEN OTHERS THEN
4562: wf_core.context('PO_REQAPPROVAL_INIT1.locate_notifier failed at:',l_step);
4563: wf_core.context('PO_REQAPPROVAL_INIT1.locate_notifier',l_role_name||sqlerrm);
4564: --raise_application_error(-20001,'l_role_name ='||l_role_name ||' and l_step='||l_step ||' and l_list='||l_namelist_for_sql, true);
4565: end locate_notifier;
4566:
4567: -- DKC 02/06/01

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

4797: EXCEPTION
4798: WHEN OTHERS THEN
4799: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
4800: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
4801: wf_core.context('PO_REQAPPROVAL_INIT1.Email_Doc_Yes_No',x_progress||':'||sqlerrm);
4802: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_INIT1.EMAIL_DOC_YES_NO');
4803: raise;
4804:
4805: END Email_Doc_Yes_No;

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

4868: EXCEPTION
4869: WHEN OTHERS THEN
4870: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
4871: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
4872: wf_core.context('PO_REQAPPROVAL_INIT1.Print_Document',x_progress);
4873: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_INIT1.PRINT_DOCUMENT');
4874: raise;
4875:
4876: END Print_Document;

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

4929: EXCEPTION
4930: WHEN OTHERS THEN
4931: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
4932: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
4933: wf_core.context('PO_REQAPPROVAL_INIT1.Fax_Document',x_progress);
4934: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_INIT1.FAX_DOCUMENT');
4935: raise;
4936:
4937: END Fax_Document;

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

5050:
5051: WHEN OTHERS THEN
5052: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
5053: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
5054: wf_core.context('PO_REQAPPROVAL_INIT1','Is_document_Approved',x_progress);
5055: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_INIT1.IS_DOCUMENT_APPROVED');
5056: raise;
5057:
5058:

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

5121:
5122: WHEN OTHERS THEN
5123: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
5124: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
5125: wf_core.context('PO_REQAPPROVAL_INIT1','Get_Create_PO_Mode',x_progress);
5126: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_INIT1.GET_CREATE_PO_MODE');
5127: raise;
5128:
5129: END Get_Create_PO_Mode;

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

5191:
5192: WHEN OTHERS THEN
5193: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
5194: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
5195: wf_core.context('PO_REQAPPROVAL_INIT1','Get_Workflow_Approval_Mode',x_progress);
5196: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_INIT1.GET_WORKFLOW_APPROVAL_MODE');
5197: raise;
5198:
5199: END Get_Workflow_Approval_Mode;

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

5261: END IF;
5262:
5263: EXCEPTION
5264: WHEN OTHERS THEN
5265: wf_core.context('PO_REQAPPROVAL_INIT1','GetReqAttributes',x_progress);
5266: raise;
5267:
5268: end GetReqAttributes;
5269: --

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

5833: end if;
5834:
5835: EXCEPTION
5836: WHEN OTHERS THEN
5837: wf_core.context('PO_REQAPPROVAL_INIT1','SetReqHdrAttributes',x_progress);
5838: raise;
5839:
5840:
5841: end SetReqHdrAttributes;

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

5923: commit;
5924:
5925: EXCEPTION
5926: WHEN OTHERS THEN
5927: wf_core.context('PO_REQAPPROVAL_INIT1','SetReqAuthStat',x_progress);
5928: raise;
5929:
5930: END SetReqAuthStat;
5931:

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

5976: commit;
5977:
5978: EXCEPTION
5979: WHEN OTHERS THEN
5980: wf_core.context('PO_REQAPPROVAL_INIT1','SetPOAuthStat',x_progress);
5981: raise;
5982:
5983: END SetPOAuthStat;
5984:

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

6029: commit;
6030:
6031: EXCEPTION
6032: WHEN OTHERS THEN
6033: wf_core.context('PO_REQAPPROVAL_INIT1','SetRelAuthStat',x_progress);
6034: raise;
6035:
6036: END SetRelAuthStat;
6037: --

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

6055: commit;
6056:
6057: EXCEPTION
6058: WHEN OTHERS THEN
6059: wf_core.context('PO_REQAPPROVAL_INIT1','UpdtReqItemtype',x_progress);
6060: raise;
6061:
6062: END UpdtReqItemtype;
6063:

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

6083: commit;
6084:
6085: EXCEPTION
6086: WHEN OTHERS THEN
6087: wf_core.context('PO_REQAPPROVAL_INIT1','UpdtPOItemtype',x_progress);
6088: raise;
6089:
6090: END UpdtPOItemtype;
6091:

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

6112: commit;
6113:
6114: EXCEPTION
6115: WHEN OTHERS THEN
6116: wf_core.context('PO_REQAPPROVAL_INIT1','UpdtRelItemtype',x_progress);
6117: raise;
6118:
6119: END UpdtRelItemtype;
6120:

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

6149: close C1;
6150:
6151: EXCEPTION
6152: WHEN OTHERS THEN
6153: wf_core.context('PO_REQAPPROVAL_INIT1','GetCanOwnerApprove',x_progress);
6154: raise;
6155:
6156: END GetCanOwnerApprove;
6157: --

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

6208:
6209:
6210: EXCEPTION
6211: WHEN OTHERS THEN
6212: wf_core.context('PO_REQAPPROVAL_INIT1','get_multiorg_context',x_progress);
6213: raise;
6214:
6215: END get_multiorg_context;
6216:

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

6249: close c_empid;
6250:
6251: EXCEPTION
6252: WHEN OTHERS THEN
6253: wf_core.context('PO_REQAPPROVAL_INIT1','get_employee_id',p_username);
6254: raise;
6255:
6256:
6257: END get_employee_id;

Line 6277: wf_core.context('PO_REQAPPROVAL_INIT1','get_user_name',to_char(p_employee_id));

6273: x_user_display_name);
6274:
6275: EXCEPTION
6276: WHEN OTHERS THEN
6277: wf_core.context('PO_REQAPPROVAL_INIT1','get_user_name',to_char(p_employee_id));
6278: raise;
6279:
6280: END get_user_name;
6281:

Line 6510: wf_core.context('PO_REQAPPROVAL_INIT1','InsertActionHistSubmit',x_progress);

6506: commit;
6507: EXCEPTION
6508:
6509: WHEN OTHERS THEN
6510: wf_core.context('PO_REQAPPROVAL_INIT1','InsertActionHistSubmit',x_progress);
6511: raise;
6512:
6513: END InsertActionHistSubmit;
6514:

Line 6605: wf_core.context('PO_REQAPPROVAL_INIT1','EncumbOn_DocUnreserved',

6601: ROLLBACK;
6602: RETURN(l_unreserved_flag);
6603:
6604: WHEN OTHERS THEN
6605: wf_core.context('PO_REQAPPROVAL_INIT1','EncumbOn_DocUnreserved',
6606: l_progress);
6607:
6608: ROLLBACK;
6609: RAISE;

Line 6800: wf_core.context('PO_REQAPPROVAL_INIT1','PrintDocument',x_progress);

6796:
6797: EXCEPTION
6798:
6799: WHEN OTHERS THEN
6800: wf_core.context('PO_REQAPPROVAL_INIT1','PrintDocument',x_progress);
6801: raise;
6802:
6803: END PrintDocument;
6804:

Line 6955: wf_core.context('PO_REQAPPROVAL_INIT1','FaxDocument',x_progress);

6951:
6952: EXCEPTION
6953:
6954: WHEN OTHERS THEN
6955: wf_core.context('PO_REQAPPROVAL_INIT1','FaxDocument',x_progress);
6956: raise;
6957:
6958: END FaxDocument;
6959:

Line 7008: wf_core.context('PO_REQAPPROVAL_INIT1','Print_Requisition',x_progress);

7004:
7005: EXCEPTION
7006:
7007: WHEN OTHERS THEN
7008: wf_core.context('PO_REQAPPROVAL_INIT1','Print_Requisition',x_progress);
7009: raise;
7010: END;
7011:
7012: FUNCTION Print_PO(p_doc_num varchar2, p_qty_precision varchar,

Line 7117: wf_core.context('PO_REQAPPROVAL_INIT1','Print_PO',x_progress);

7113:
7114: EXCEPTION
7115:
7116: WHEN OTHERS THEN
7117: wf_core.context('PO_REQAPPROVAL_INIT1','Print_PO',x_progress);
7118: raise;
7119:
7120: END Print_PO;
7121:

Line 7236: wf_core.context('PO_REQAPPROVAL_INIT1','Fax_PO',x_progress);

7232:
7233: EXCEPTION
7234:
7235: WHEN OTHERS THEN
7236: wf_core.context('PO_REQAPPROVAL_INIT1','Fax_PO',x_progress);
7237: raise;
7238:
7239: END Fax_PO;
7240:

Line 7352: wf_core.context('PO_REQAPPROVAL_INIT1','Print_Release',x_progress);

7348:
7349: EXCEPTION
7350:
7351: WHEN OTHERS THEN
7352: wf_core.context('PO_REQAPPROVAL_INIT1','Print_Release',x_progress);
7353: raise;
7354:
7355: END Print_Release;
7356:

Line 7471: wf_core.context('PO_REQAPPROVAL_INIT1','Fax_Release',x_progress);

7467:
7468: EXCEPTION
7469:
7470: WHEN OTHERS THEN
7471: wf_core.context('PO_REQAPPROVAL_INIT1','Fax_Release',x_progress);
7472: raise;
7473:
7474: END Fax_Release;
7475:

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

7528: EXCEPTION
7529: WHEN OTHERS THEN
7530: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
7531: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
7532: wf_core.context('PO_REQAPPROVAL_INIT1','is_apps_source_POR',l_progress);
7533: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_INIT1.IS_APPS_SOURCE_POR');
7534: RAISE;
7535:
7536: END is_apps_source_POR;

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

7598: EXCEPTION
7599: WHEN OTHERS THEN
7600: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
7601: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
7602: wf_core.context('PO_REQAPPROVAL_INIT1','is_contractor_status_pending',l_progress);
7603: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_INIT1.is_contractor_status_pending');
7604: RAISE;
7605:
7606: END is_contractor_status_pending;

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

7664: EXCEPTION
7665: WHEN OTHERS THEN
7666: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
7667: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
7668: wf_core.context('PO_REQAPPROVAL_INIT1','Is_Submitter_Last_Approver',x_progress);
7669: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_INIT1.IS_SUBMITTER_LAST_APPROVER');
7670: raise;
7671:
7672: end Is_Submitter_Last_Approver;

Line 7978: WF_CORE.context('PO_APPROVAL_LIST_WF1S' , 'Is_Document_Manager_Error_1_2',

7974: END IF; --run mode
7975:
7976: EXCEPTION
7977: WHEN OTHERS THEN
7978: WF_CORE.context('PO_APPROVAL_LIST_WF1S' , 'Is_Document_Manager_Error_1_2',
7979: itemtype, itemkey, l_progress);
7980: resultout:='COMPLETE:'||'N';
7981:
7982: END Is_Document_Manager_Error_1_2;

Line 8037: WF_CORE.context('PO_REQAPPROVAL_INIT1', 'PROFILE_VALUE_CHECK' ,

8033: EXCEPTION
8034: WHEN OTHERS THEN
8035: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
8036: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
8037: WF_CORE.context('PO_REQAPPROVAL_INIT1', 'PROFILE_VALUE_CHECK' ,
8038: itemtype, itemkey, x_progress);
8039: resultout:='COMPLETE:'||'N';
8040:
8041: END;

Line 8095: WF_CORE.context('PO_APPROVAL_LIST_WF1S' , 'Check_Error_Count',

8091: END IF; --run mode
8092:
8093: EXCEPTION
8094: WHEN OTHERS THEN
8095: WF_CORE.context('PO_APPROVAL_LIST_WF1S' , 'Check_Error_Count',
8096: itemtype, itemkey, l_progress);
8097: resultout:='COMPLETE:'||'N';
8098: END Check_Error_Count;
8099:

Line 8306: WF_CORE.context('PO_APPROVAL_LIST_WF1S' , 'Initialise_Error',

8302: END IF; --run mode
8303:
8304: EXCEPTION
8305: WHEN OTHERS THEN
8306: WF_CORE.context('PO_APPROVAL_LIST_WF1S' , 'Initialise_Error',
8307: itemtype, itemkey, l_progress);
8308: resultout:='COMPLETE:'||'N';
8309: END Initialise_Error;
8310:

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

8403:
8404:
8405: exception
8406: WHEN OTHERS THEN
8407: wf_core.context('PO_REQAPPROVAL_INIT1','acceptance_required',x_progress);
8408: raise;
8409: end;
8410:
8411: --

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

8569: Insert_Acc_Rejection_Row(itemtype, itemkey, actid, 'Y');
8570:
8571: EXCEPTION
8572: WHEN OTHERS THEN
8573: wf_core.context('PO_REQAPPROVAL_INIT1','Register_acceptance',x_progress);
8574: raise;
8575: end;
8576:
8577: --

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

8770: end if;
8771:
8772: EXCEPTION
8773: WHEN OTHERS THEN
8774: wf_core.context('PO_REQAPPROVAL_INIT1','Register_rejection',x_progress);
8775: raise;
8776: end;
8777:
8778:

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

9062:
9063: EXCEPTION
9064:
9065: WHEN OTHERS THEN
9066: wf_core.context('PO_REQAPPROVAL_ACTION','set_doc_mgr_context',x_progress);
9067: raise;
9068:
9069: END Set_doc_mgr_context;
9070:

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

9729: l_progress := '200';
9730:
9731: EXCEPTION
9732: WHEN OTHERS THEN
9733: wf_core.context('PO_REQAPPROVAL_INIT1','should_notify_cat_admin',l_progress||' DocumentId='||to_char(l_doc_id));
9734: raise;
9735:
9736: END should_notify_cat_admin;
9737:

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

9835: l_progress := '200';
9836:
9837: EXCEPTION
9838: WHEN OTHERS THEN
9839: wf_core.context('PO_REQAPPROVAL_INIT1','set_catalog_admin_user_name',l_progress||' DocumentId='||to_char(p_doc_id));
9840: raise;
9841:
9842: END set_catalog_admin_user_name;
9843: