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_FINDAPPRV1 dependencies on PO_REQAPPROVAL_INIT1

Line 113: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);

109:
110: EXCEPTION
111:
112: WHEN OTHERS THEN
113: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
114: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
115: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','Set_Forward_To_From_App_fwd',x_progress);
116: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_FINDAPPRV1.SET_FORWARD_TO_FROM_APP_FWD');
117: raise;

Line 114: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);

110: EXCEPTION
111:
112: WHEN OTHERS THEN
113: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
114: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
115: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','Set_Forward_To_From_App_fwd',x_progress);
116: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_FINDAPPRV1.SET_FORWARD_TO_FROM_APP_FWD');
117: raise;
118:

Line 116: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_FINDAPPRV1.SET_FORWARD_TO_FROM_APP_FWD');

112: WHEN OTHERS THEN
113: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
114: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
115: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','Set_Forward_To_From_App_fwd',x_progress);
116: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_FINDAPPRV1.SET_FORWARD_TO_FROM_APP_FWD');
117: raise;
118:
119: END Set_Forward_To_From_App_fwd;
120: --

Line 286: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);

282:
283: EXCEPTION
284:
285: WHEN OTHERS THEN
286: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
287: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
288: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','Set_Fwd_To_From_App_timeout',x_progress);
289: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_FINDAPPRV1.SET_FWD_TO_FROM_APP_TIMEOUT');
290: raise;

Line 287: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);

283: EXCEPTION
284:
285: WHEN OTHERS THEN
286: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
287: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
288: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','Set_Fwd_To_From_App_timeout',x_progress);
289: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_FINDAPPRV1.SET_FWD_TO_FROM_APP_TIMEOUT');
290: raise;
291:

Line 289: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_FINDAPPRV1.SET_FWD_TO_FROM_APP_TIMEOUT');

285: WHEN OTHERS THEN
286: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
287: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
288: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','Set_Fwd_To_From_App_timeout',x_progress);
289: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_FINDAPPRV1.SET_FWD_TO_FROM_APP_TIMEOUT');
290: raise;
291:
292: END Set_Fwd_To_From_App_timeout;
293: --

Line 351: /* PO_REQAPPROVAL_INIT1.Set_doc_mgr_context(itemtype, itemkey); */

347: /* Bug# 2353153
348: ** Setting application context
349: */
350: -- Context Setting revamp
351: /* PO_REQAPPROVAL_INIT1.Set_doc_mgr_context(itemtype, itemkey); */
352:
353:
354: /* Bug# 1796605: kagarwal
355: ** Desc: When responding from the E-mail notifications, the forward

Line 690: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);

686:
687: EXCEPTION
688:
689: WHEN OTHERS THEN
690: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
691: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
692: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','Is_forward_to_provided',x_progress);
693: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_FINDAPPRV1.IS_FORWARD_TO_PROVIDED');
694: raise;

Line 691: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);

687: EXCEPTION
688:
689: WHEN OTHERS THEN
690: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
691: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
692: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','Is_forward_to_provided',x_progress);
693: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_FINDAPPRV1.IS_FORWARD_TO_PROVIDED');
694: raise;
695:

Line 693: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_FINDAPPRV1.IS_FORWARD_TO_PROVIDED');

689: WHEN OTHERS THEN
690: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
691: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
692: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','Is_forward_to_provided',x_progress);
693: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_FINDAPPRV1.IS_FORWARD_TO_PROVIDED');
694: raise;
695:
696: END Is_forward_to_provided;
697:

Line 784: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);

780:
781: EXCEPTION
782:
783: WHEN OTHERS THEN
784: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
785: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
786: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','Is_forward_to_user_name_valid',x_progress);
787: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_FINDAPPRV1.IS_FORWARD_TO_USER_NAME_VALID');
788: raise;

Line 785: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);

781: EXCEPTION
782:
783: WHEN OTHERS THEN
784: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
785: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
786: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','Is_forward_to_user_name_valid',x_progress);
787: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_FINDAPPRV1.IS_FORWARD_TO_USER_NAME_VALID');
788: raise;
789:

Line 787: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_FINDAPPRV1.IS_FORWARD_TO_USER_NAME_VALID');

783: WHEN OTHERS THEN
784: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
785: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
786: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','Is_forward_to_user_name_valid',x_progress);
787: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_FINDAPPRV1.IS_FORWARD_TO_USER_NAME_VALID');
788: raise;
789:
790: END Is_Forward_To_User_Name_Valid;
791:

Line 838: -- PO_REQAPPROVAL_INIT1.get_multiorg_context (l_document_type, l_document_id, x_orgid);

834: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
835: itemkey => itemkey,
836: aname => 'DOCUMENT_ID');
837:
838: -- PO_REQAPPROVAL_INIT1.get_multiorg_context (l_document_type, l_document_id, x_orgid);
839: l_orgid := wf_engine.GetItemAttrNumber (itemtype => itemtype,
840: itemkey => itemkey,
841: aname => 'ORG_ID');
842:

Line 865: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);

861:
862: EXCEPTION
863:
864: WHEN OTHERS THEN
865: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
866: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
867: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','Get_approval_path_id',x_progress);
868: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_FINDAPPRV1.GET_APPROVAL_PATH_ID');
869: raise;

Line 866: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);

862: EXCEPTION
863:
864: WHEN OTHERS THEN
865: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
866: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
867: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','Get_approval_path_id',x_progress);
868: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_FINDAPPRV1.GET_APPROVAL_PATH_ID');
869: raise;
870:

Line 868: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_FINDAPPRV1.GET_APPROVAL_PATH_ID');

864: WHEN OTHERS THEN
865: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
866: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
867: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','Get_approval_path_id',x_progress);
868: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_FINDAPPRV1.GET_APPROVAL_PATH_ID');
869: raise;
870:
871: END Get_approval_path_id;
872:

Line 916: -- PO_REQAPPROVAL_INIT1.get_multiorg_context (l_document_type, l_document_id,x_orgid);

912: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
913: itemkey => itemkey,
914: aname => 'DOCUMENT_ID');
915:
916: -- PO_REQAPPROVAL_INIT1.get_multiorg_context (l_document_type, l_document_id,x_orgid);
917:
918: l_orgid := wf_engine.GetItemAttrNumber (itemtype => itemtype,
919: itemkey => itemkey,
920: aname => 'ORG_ID');

Line 950: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);

946:
947: EXCEPTION
948:
949: WHEN OTHERS THEN
950: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
951: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
952: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','Get_Forward_mode',x_progress);
953: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_FINDAPPRV1.GET_FORWARD_MODE');
954: raise;

Line 951: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);

947: EXCEPTION
948:
949: WHEN OTHERS THEN
950: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
951: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
952: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','Get_Forward_mode',x_progress);
953: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_FINDAPPRV1.GET_FORWARD_MODE');
954: raise;
955:

Line 953: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_FINDAPPRV1.GET_FORWARD_MODE');

949: WHEN OTHERS THEN
950: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
951: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
952: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','Get_Forward_mode',x_progress);
953: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_FINDAPPRV1.GET_FORWARD_MODE');
954: raise;
955:
956:
957: END Get_Forward_mode;

Line 1000: -- PO_REQAPPROVAL_INIT1.get_multiorg_context (l_document_type, l_document_id,x_orgid);

996: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
997: itemkey => itemkey,
998: aname => 'DOCUMENT_ID');
999:
1000: -- PO_REQAPPROVAL_INIT1.get_multiorg_context (l_document_type, l_document_id,x_orgid);
1001: l_orgid := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1002: itemkey => itemkey,
1003: aname => 'ORG_ID');
1004:

Line 1032: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);

1028:
1029: EXCEPTION
1030:
1031: WHEN OTHERS THEN
1032: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1033: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1034: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','Use_Position_flag',x_progress);
1035: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_FINDAPPRV1.USE_POSITION_FLAG');
1036: raise;

Line 1033: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);

1029: EXCEPTION
1030:
1031: WHEN OTHERS THEN
1032: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1033: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1034: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','Use_Position_flag',x_progress);
1035: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_FINDAPPRV1.USE_POSITION_FLAG');
1036: raise;
1037:

Line 1035: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_FINDAPPRV1.USE_POSITION_FLAG');

1031: WHEN OTHERS THEN
1032: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1033: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1034: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','Use_Position_flag',x_progress);
1035: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_FINDAPPRV1.USE_POSITION_FLAG');
1036: raise;
1037:
1038:
1039: END Use_Position_flag;

Line 1085: -- PO_REQAPPROVAL_INIT1.get_multiorg_context (l_document_type, l_document_id,x_orgid);

1081: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1082: itemkey => itemkey,
1083: aname => 'DOCUMENT_ID');
1084:
1085: -- PO_REQAPPROVAL_INIT1.get_multiorg_context (l_document_type, l_document_id,x_orgid);
1086:
1087: l_orgid := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1088: itemkey => itemkey,
1089: aname => 'ORG_ID');

Line 1120: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);

1116:
1117: EXCEPTION
1118:
1119: WHEN OTHERS THEN
1120: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1121: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1122: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','GetMgr_hr_hier',x_progress);
1123: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_FINDAPPRV1.GETMGR_HR_HIER');
1124: raise;

Line 1121: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);

1117: EXCEPTION
1118:
1119: WHEN OTHERS THEN
1120: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1121: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1122: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','GetMgr_hr_hier',x_progress);
1123: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_FINDAPPRV1.GETMGR_HR_HIER');
1124: raise;
1125:

Line 1123: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_FINDAPPRV1.GETMGR_HR_HIER');

1119: WHEN OTHERS THEN
1120: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1121: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1122: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','GetMgr_hr_hier',x_progress);
1123: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_FINDAPPRV1.GETMGR_HR_HIER');
1124: raise;
1125:
1126: END GetMgr_hr_hier;
1127:

Line 1174: -- PO_REQAPPROVAL_INIT1.get_multiorg_context (l_document_type, l_document_id, x_orgid);

1170: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1171: itemkey => itemkey,
1172: aname => 'DOCUMENT_ID');
1173:
1174: -- PO_REQAPPROVAL_INIT1.get_multiorg_context (l_document_type, l_document_id, x_orgid);
1175: l_orgid := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1176: itemkey => itemkey,
1177: aname => 'ORG_ID');
1178:

Line 1207: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);

1203:
1204: EXCEPTION
1205:
1206: WHEN OTHERS THEN
1207: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1208: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1209: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','GetMgr_po_hier',x_progress);
1210: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_FINDAPPRV1.GETMGR_PO_HIER');
1211: raise;

Line 1208: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);

1204: EXCEPTION
1205:
1206: WHEN OTHERS THEN
1207: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1208: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1209: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','GetMgr_po_hier',x_progress);
1210: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_FINDAPPRV1.GETMGR_PO_HIER');
1211: raise;
1212:

Line 1210: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_FINDAPPRV1.GETMGR_PO_HIER');

1206: WHEN OTHERS THEN
1207: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1208: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1209: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','GetMgr_po_hier',x_progress);
1210: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_FINDAPPRV1.GETMGR_PO_HIER');
1211: raise;
1212:
1213:
1214: END GetMgr_po_hier;

Line 1275: PO_REQAPPROVAL_INIT1.Get_employee_id(l_forward_to_username_response,

1271: /* Set the forward_to username so they would get the notification */
1272: /* DEBUG: Only set the FORWARD_TO_USERNAME, if Get_employee_id() returned
1273: ** a valid employee.
1274: */
1275: PO_REQAPPROVAL_INIT1.Get_employee_id(l_forward_to_username_response,
1276: l_forward_to_id);
1277:
1278: IF l_forward_to_id is NOT NULL THEN
1279:

Line 1696: ** Return 'N', if PO_REQAPPROVAL_INIT1.get_user_name returns

1692: **
1693: ** If the superior does not have a valid username, we will return the
1694: ** document to the preparer with Message 'No Approver found'.
1695: **
1696: ** Return 'N', if PO_REQAPPROVAL_INIT1.get_user_name returns
1697: ** x_username as NULL
1698: */
1699:
1700: PO_REQAPPROVAL_INIT1.get_user_name(l_superior_id, x_username,

Line 1700: PO_REQAPPROVAL_INIT1.get_user_name(l_superior_id, x_username,

1696: ** Return 'N', if PO_REQAPPROVAL_INIT1.get_user_name returns
1697: ** x_username as NULL
1698: */
1699:
1700: PO_REQAPPROVAL_INIT1.get_user_name(l_superior_id, x_username,
1701: x_user_display_name);
1702:
1703: IF x_username IS NULL THEN
1704: if x_hr_profile = 'Y' then

Line 1794: /*PO_REQAPPROVAL_INIT1.get_user_name(l_superior_id, x_username,

1790:
1791: /* Get the username of Forward-to employee. We need to assign it to the
1792: ** performer of the notification */
1793: /* Commented out the call since we have already got the username */
1794: /*PO_REQAPPROVAL_INIT1.get_user_name(l_superior_id, x_username,
1795: x_user_display_name);*/
1796:
1797: wf_engine.SetItemAttrText ( itemtype => itemType,
1798: itemkey => itemkey,

Line 1921: ** Return 'N', if PO_REQAPPROVAL_INIT1.get_user_name returns

1917: **
1918: ** If the superior does not have a valid username, we will return the
1919: ** document to the preparer with Message 'No Approver found'.
1920: **
1921: ** Return 'N', if PO_REQAPPROVAL_INIT1.get_user_name returns
1922: ** x_username as NULL
1923: */
1924:
1925: PO_REQAPPROVAL_INIT1.get_user_name(l_superior_id, x_username,

Line 1925: PO_REQAPPROVAL_INIT1.get_user_name(l_superior_id, x_username,

1921: ** Return 'N', if PO_REQAPPROVAL_INIT1.get_user_name returns
1922: ** x_username as NULL
1923: */
1924:
1925: PO_REQAPPROVAL_INIT1.get_user_name(l_superior_id, x_username,
1926: x_user_display_name);
1927:
1928: IF x_username IS NULL THEN
1929: close C1;

Line 2013: /*PO_REQAPPROVAL_INIT1.get_user_name(l_superior_id, x_username,

2009: avalue => l_superior_id);
2010:
2011: /* Get the username of Forward-to employee. We need to assign it to the
2012: ** performer of the notification */
2013: /*PO_REQAPPROVAL_INIT1.get_user_name(l_superior_id, x_username,
2014: x_user_display_name);*/
2015:
2016: wf_engine.SetItemAttrText ( itemtype => itemType,
2017: itemkey => itemkey,

Line 2090: wf_core.context('PO_REQAPPROVAL_INIT1','CheckOwnerCanApprove',x_progress);

2086: close C1;
2087:
2088: EXCEPTION
2089: WHEN OTHERS THEN
2090: wf_core.context('PO_REQAPPROVAL_INIT1','CheckOwnerCanApprove',x_progress);
2091: raise;
2092: END CheckOwnerCanApprove;
2093:
2094: --