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 207: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);

203:
204: EXCEPTION
205:
206: WHEN OTHERS THEN
207: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
208: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
209: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','Set_Forward_To_From_App_fwd',x_progress);
210: 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');
211: raise;

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

204: EXCEPTION
205:
206: WHEN OTHERS THEN
207: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
208: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
209: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','Set_Forward_To_From_App_fwd',x_progress);
210: 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');
211: raise;
212:

Line 210: 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');

206: WHEN OTHERS THEN
207: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
208: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
209: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','Set_Forward_To_From_App_fwd',x_progress);
210: 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');
211: raise;
212:
213: END Set_Forward_To_From_App_fwd;
214: --

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

400:
401: EXCEPTION
402:
403: WHEN OTHERS THEN
404: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
405: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
406: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','Set_Fwd_To_From_App_timeout',x_progress);
407: 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');
408: raise;

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

401: EXCEPTION
402:
403: WHEN OTHERS THEN
404: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
405: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
406: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','Set_Fwd_To_From_App_timeout',x_progress);
407: 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');
408: raise;
409:

Line 407: 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');

403: WHEN OTHERS THEN
404: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
405: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
406: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','Set_Fwd_To_From_App_timeout',x_progress);
407: 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');
408: raise;
409:
410: END Set_Fwd_To_From_App_timeout;
411: --

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

470: /* Bug# 2353153
471: ** Setting application context
472: */
473: -- Context Setting revamp
474: /* PO_REQAPPROVAL_INIT1.Set_doc_mgr_context(itemtype, itemkey); */
475:
476:
477: /* Bug# 1796605: kagarwal
478: ** Desc: When responding from the E-mail notifications, the forward

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

828:
829: EXCEPTION
830:
831: WHEN OTHERS THEN
832: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
833: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
834: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','Is_forward_to_provided',x_progress);
835: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_FINDAPPRV1.IS_FORWARD_TO_PROVIDED');
836: raise;

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

829: EXCEPTION
830:
831: WHEN OTHERS THEN
832: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
833: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
834: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','Is_forward_to_provided',x_progress);
835: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_FINDAPPRV1.IS_FORWARD_TO_PROVIDED');
836: raise;
837:

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

831: WHEN OTHERS THEN
832: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
833: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
834: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','Is_forward_to_provided',x_progress);
835: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_FINDAPPRV1.IS_FORWARD_TO_PROVIDED');
836: raise;
837:
838: END Is_forward_to_provided;
839:

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

922:
923: EXCEPTION
924:
925: WHEN OTHERS THEN
926: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
927: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
928: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','Is_forward_to_user_name_valid',x_progress);
929: 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');
930: raise;

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

923: EXCEPTION
924:
925: WHEN OTHERS THEN
926: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
927: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
928: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','Is_forward_to_user_name_valid',x_progress);
929: 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');
930: raise;
931:

Line 929: 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');

925: WHEN OTHERS THEN
926: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
927: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
928: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','Is_forward_to_user_name_valid',x_progress);
929: 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');
930: raise;
931:
932: END Is_Forward_To_User_Name_Valid;
933:

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

976: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
977: itemkey => itemkey,
978: aname => 'DOCUMENT_ID');
979:
980: -- PO_REQAPPROVAL_INIT1.get_multiorg_context (l_document_type, l_document_id, x_orgid);
981: l_orgid := wf_engine.GetItemAttrNumber (itemtype => itemtype,
982: itemkey => itemkey,
983: aname => 'ORG_ID');
984:

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

1003:
1004: EXCEPTION
1005:
1006: WHEN OTHERS THEN
1007: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1008: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1009: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','Get_approval_path_id',x_progress);
1010: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_FINDAPPRV1.GET_APPROVAL_PATH_ID');
1011: raise;

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

1004: EXCEPTION
1005:
1006: WHEN OTHERS THEN
1007: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1008: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1009: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','Get_approval_path_id',x_progress);
1010: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_FINDAPPRV1.GET_APPROVAL_PATH_ID');
1011: raise;
1012:

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

1006: WHEN OTHERS THEN
1007: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1008: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1009: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','Get_approval_path_id',x_progress);
1010: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_FINDAPPRV1.GET_APPROVAL_PATH_ID');
1011: raise;
1012:
1013: END Get_approval_path_id;
1014:

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

1054: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1055: itemkey => itemkey,
1056: aname => 'DOCUMENT_ID');
1057:
1058: -- PO_REQAPPROVAL_INIT1.get_multiorg_context (l_document_type, l_document_id,x_orgid);
1059:
1060: l_orgid := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1061: itemkey => itemkey,
1062: aname => 'ORG_ID');

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

1088:
1089: EXCEPTION
1090:
1091: WHEN OTHERS THEN
1092: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1093: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1094: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','Get_Forward_mode',x_progress);
1095: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_FINDAPPRV1.GET_FORWARD_MODE');
1096: raise;

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

1089: EXCEPTION
1090:
1091: WHEN OTHERS THEN
1092: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1093: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1094: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','Get_Forward_mode',x_progress);
1095: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_FINDAPPRV1.GET_FORWARD_MODE');
1096: raise;
1097:

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

1091: WHEN OTHERS THEN
1092: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1093: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1094: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','Get_Forward_mode',x_progress);
1095: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_FINDAPPRV1.GET_FORWARD_MODE');
1096: raise;
1097:
1098:
1099: END Get_Forward_mode;

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

1138: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1139: itemkey => itemkey,
1140: aname => 'DOCUMENT_ID');
1141:
1142: -- PO_REQAPPROVAL_INIT1.get_multiorg_context (l_document_type, l_document_id,x_orgid);
1143: l_orgid := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1144: itemkey => itemkey,
1145: aname => 'ORG_ID');
1146:

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

1170:
1171: EXCEPTION
1172:
1173: WHEN OTHERS THEN
1174: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1175: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1176: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','Use_Position_flag',x_progress);
1177: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_FINDAPPRV1.USE_POSITION_FLAG');
1178: raise;

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

1171: EXCEPTION
1172:
1173: WHEN OTHERS THEN
1174: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1175: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1176: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','Use_Position_flag',x_progress);
1177: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_FINDAPPRV1.USE_POSITION_FLAG');
1178: raise;
1179:

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

1173: WHEN OTHERS THEN
1174: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1175: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1176: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','Use_Position_flag',x_progress);
1177: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_FINDAPPRV1.USE_POSITION_FLAG');
1178: raise;
1179:
1180:
1181: END Use_Position_flag;

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

1223: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1224: itemkey => itemkey,
1225: aname => 'DOCUMENT_ID');
1226:
1227: -- PO_REQAPPROVAL_INIT1.get_multiorg_context (l_document_type, l_document_id,x_orgid);
1228:
1229: l_orgid := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1230: itemkey => itemkey,
1231: aname => 'ORG_ID');

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

1258:
1259: EXCEPTION
1260:
1261: WHEN OTHERS THEN
1262: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1263: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1264: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','GetMgr_hr_hier',x_progress);
1265: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_FINDAPPRV1.GETMGR_HR_HIER');
1266: raise;

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

1259: EXCEPTION
1260:
1261: WHEN OTHERS THEN
1262: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1263: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1264: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','GetMgr_hr_hier',x_progress);
1265: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_FINDAPPRV1.GETMGR_HR_HIER');
1266: raise;
1267:

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

1261: WHEN OTHERS THEN
1262: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1263: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1264: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','GetMgr_hr_hier',x_progress);
1265: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_FINDAPPRV1.GETMGR_HR_HIER');
1266: raise;
1267:
1268: END GetMgr_hr_hier;
1269:

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

1312: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1313: itemkey => itemkey,
1314: aname => 'DOCUMENT_ID');
1315:
1316: -- PO_REQAPPROVAL_INIT1.get_multiorg_context (l_document_type, l_document_id, x_orgid);
1317: l_orgid := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1318: itemkey => itemkey,
1319: aname => 'ORG_ID');
1320:

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

1345:
1346: EXCEPTION
1347:
1348: WHEN OTHERS THEN
1349: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1350: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1351: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','GetMgr_po_hier',x_progress);
1352: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_FINDAPPRV1.GETMGR_PO_HIER');
1353: raise;

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

1346: EXCEPTION
1347:
1348: WHEN OTHERS THEN
1349: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1350: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1351: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','GetMgr_po_hier',x_progress);
1352: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_FINDAPPRV1.GETMGR_PO_HIER');
1353: raise;
1354:

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

1348: WHEN OTHERS THEN
1349: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1350: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1351: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','GetMgr_po_hier',x_progress);
1352: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_FINDAPPRV1.GETMGR_PO_HIER');
1353: raise;
1354:
1355:
1356: END GetMgr_po_hier;

Line 1417: PO_REQAPPROVAL_INIT1.Get_employee_id(l_forward_to_username_response,

1413: /* Set the forward_to username so they would get the notification */
1414: /* DEBUG: Only set the FORWARD_TO_USERNAME, if Get_employee_id() returned
1415: ** a valid employee.
1416: */
1417: PO_REQAPPROVAL_INIT1.Get_employee_id(l_forward_to_username_response,
1418: l_forward_to_id);
1419:
1420: IF l_forward_to_id is NOT NULL THEN
1421:

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

1844: **
1845: ** If the superior does not have a valid username, we will return the
1846: ** document to the preparer with Message 'No Approver found'.
1847: **
1848: ** Return 'N', if PO_REQAPPROVAL_INIT1.get_user_name returns
1849: ** x_username as NULL
1850: */
1851:
1852: PO_REQAPPROVAL_INIT1.get_user_name(l_superior_id, x_username,

Line 1852: PO_REQAPPROVAL_INIT1.get_user_name(l_superior_id, x_username,

1848: ** Return 'N', if PO_REQAPPROVAL_INIT1.get_user_name returns
1849: ** x_username as NULL
1850: */
1851:
1852: PO_REQAPPROVAL_INIT1.get_user_name(l_superior_id, x_username,
1853: x_user_display_name);
1854:
1855: IF x_username IS NULL THEN
1856: if x_hr_profile = 'Y' then

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

1942:
1943: /* Get the username of Forward-to employee. We need to assign it to the
1944: ** performer of the notification */
1945: /* Commented out the call since we have already got the username */
1946: /*PO_REQAPPROVAL_INIT1.get_user_name(l_superior_id, x_username,
1947: x_user_display_name);*/
1948:
1949: wf_engine.SetItemAttrText ( itemtype => itemType,
1950: itemkey => itemkey,

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

2103: **
2104: ** If the superior does not have a valid username, we will return the
2105: ** document to the preparer with Message 'No Approver found'.
2106: **
2107: ** Return 'N', if PO_REQAPPROVAL_INIT1.get_user_name returns
2108: ** x_username as NULL
2109: */
2110:
2111: PO_REQAPPROVAL_INIT1.get_user_name(l_superior_id, x_username,

Line 2111: PO_REQAPPROVAL_INIT1.get_user_name(l_superior_id, x_username,

2107: ** Return 'N', if PO_REQAPPROVAL_INIT1.get_user_name returns
2108: ** x_username as NULL
2109: */
2110:
2111: PO_REQAPPROVAL_INIT1.get_user_name(l_superior_id, x_username,
2112: x_user_display_name);
2113:
2114: IF x_username IS NULL THEN
2115: close C1;

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

2195: avalue => l_superior_id);
2196:
2197: /* Get the username of Forward-to employee. We need to assign it to the
2198: ** performer of the notification */
2199: /*PO_REQAPPROVAL_INIT1.get_user_name(l_superior_id, x_username,
2200: x_user_display_name);*/
2201:
2202: wf_engine.SetItemAttrText ( itemtype => itemType,
2203: itemkey => itemkey,

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

2272: close C1;
2273:
2274: EXCEPTION
2275: WHEN OTHERS THEN
2276: wf_core.context('PO_REQAPPROVAL_INIT1','CheckOwnerCanApprove',x_progress);
2277: raise;
2278: END CheckOwnerCanApprove;
2279:
2280: --