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

Line 122: PO_REQAPPROVAL_INIT1.get_user_name(p_employee_id => l_preparer_id,

118: itemkey => itemkey,
119: aname => 'PREPARER_ID',
120: avalue => l_preparer_id);
121:
122: PO_REQAPPROVAL_INIT1.get_user_name(p_employee_id => l_preparer_id,
123: x_username => l_username,
124: x_user_display_name => l_user_display_name);
125:
126: WF_ENGINE.SetItemOwner (itemtype => itemtype,

Line 250: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemtype, itemkey);

246: 'PLSQLCLOB:PO_SIGNATURE_PVT.get_signature_notfn_body /'|| l_document_id ||':'||itemtype||':'||itemkey);
247:
248: EXCEPTION
249: WHEN l_binding_exception then
250: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemtype, itemkey);
251: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemtype, itemkey);
252: WF_CORE.context('PO_SIGNATURE_PVT','Set_Startup_Values',l_progress);
253: PO_REQAPPROVAL_INIT1.send_error_notif(itemtype, itemkey, l_preparer_user_name, l_doc_string, 'l_binding_exception - '||sqlerrm, 'PO_SIGNATURE_PVT.SET_STARTUP_VALUES');
254: RAISE;

Line 251: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemtype, itemkey);

247:
248: EXCEPTION
249: WHEN l_binding_exception then
250: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemtype, itemkey);
251: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemtype, itemkey);
252: WF_CORE.context('PO_SIGNATURE_PVT','Set_Startup_Values',l_progress);
253: PO_REQAPPROVAL_INIT1.send_error_notif(itemtype, itemkey, l_preparer_user_name, l_doc_string, 'l_binding_exception - '||sqlerrm, 'PO_SIGNATURE_PVT.SET_STARTUP_VALUES');
254: RAISE;
255:

Line 253: PO_REQAPPROVAL_INIT1.send_error_notif(itemtype, itemkey, l_preparer_user_name, l_doc_string, 'l_binding_exception - '||sqlerrm, 'PO_SIGNATURE_PVT.SET_STARTUP_VALUES');

249: WHEN l_binding_exception then
250: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemtype, itemkey);
251: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemtype, itemkey);
252: WF_CORE.context('PO_SIGNATURE_PVT','Set_Startup_Values',l_progress);
253: PO_REQAPPROVAL_INIT1.send_error_notif(itemtype, itemkey, l_preparer_user_name, l_doc_string, 'l_binding_exception - '||sqlerrm, 'PO_SIGNATURE_PVT.SET_STARTUP_VALUES');
254: RAISE;
255:
256: WHEN OTHERS THEN
257: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);

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

253: PO_REQAPPROVAL_INIT1.send_error_notif(itemtype, itemkey, l_preparer_user_name, l_doc_string, 'l_binding_exception - '||sqlerrm, 'PO_SIGNATURE_PVT.SET_STARTUP_VALUES');
254: RAISE;
255:
256: WHEN OTHERS THEN
257: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
258: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
259: WF_CORE.context('PO_SIGNATURE_PVT','Set_Startup_Values',l_progress);
260: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_SIGNATURE_PVT.SET_STARTUP_VALUES');
261: RAISE;

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

254: RAISE;
255:
256: WHEN OTHERS THEN
257: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
258: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
259: WF_CORE.context('PO_SIGNATURE_PVT','Set_Startup_Values',l_progress);
260: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_SIGNATURE_PVT.SET_STARTUP_VALUES');
261: RAISE;
262:

Line 260: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_SIGNATURE_PVT.SET_STARTUP_VALUES');

256: WHEN OTHERS THEN
257: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
258: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
259: WF_CORE.context('PO_SIGNATURE_PVT','Set_Startup_Values',l_progress);
260: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_SIGNATURE_PVT.SET_STARTUP_VALUES');
261: RAISE;
262:
263: END SET_STARTUP_VALUES;
264:

Line 452: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(l_item_type, l_item_key);

448: END IF;
449:
450: EXCEPTION
451: WHEN l_binding_exception then
452: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(l_item_type, l_item_key);
453: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(l_item_type, l_item_key);
454: WF_CORE.context('PO_SIGNATURE_PVT','Get_Signature_Notfn_Body',l_progress);
455: PO_REQAPPROVAL_INIT1.send_error_notif(l_item_type, l_item_key, l_preparer_user_name, l_doc_string, 'l_binding_exception - '||sqlerrm, 'PO_SIGNATURE_PVT.GET_SIGNATURE_NOTFN_BODY');
456: RAISE;

Line 453: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(l_item_type, l_item_key);

449:
450: EXCEPTION
451: WHEN l_binding_exception then
452: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(l_item_type, l_item_key);
453: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(l_item_type, l_item_key);
454: WF_CORE.context('PO_SIGNATURE_PVT','Get_Signature_Notfn_Body',l_progress);
455: PO_REQAPPROVAL_INIT1.send_error_notif(l_item_type, l_item_key, l_preparer_user_name, l_doc_string, 'l_binding_exception - '||sqlerrm, 'PO_SIGNATURE_PVT.GET_SIGNATURE_NOTFN_BODY');
456: RAISE;
457: WHEN OTHERS THEN

Line 455: PO_REQAPPROVAL_INIT1.send_error_notif(l_item_type, l_item_key, l_preparer_user_name, l_doc_string, 'l_binding_exception - '||sqlerrm, 'PO_SIGNATURE_PVT.GET_SIGNATURE_NOTFN_BODY');

451: WHEN l_binding_exception then
452: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(l_item_type, l_item_key);
453: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(l_item_type, l_item_key);
454: WF_CORE.context('PO_SIGNATURE_PVT','Get_Signature_Notfn_Body',l_progress);
455: PO_REQAPPROVAL_INIT1.send_error_notif(l_item_type, l_item_key, l_preparer_user_name, l_doc_string, 'l_binding_exception - '||sqlerrm, 'PO_SIGNATURE_PVT.GET_SIGNATURE_NOTFN_BODY');
456: RAISE;
457: WHEN OTHERS THEN
458: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(l_item_type, l_item_key);
459: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(l_item_type, l_item_key);

Line 458: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(l_item_type, l_item_key);

454: WF_CORE.context('PO_SIGNATURE_PVT','Get_Signature_Notfn_Body',l_progress);
455: PO_REQAPPROVAL_INIT1.send_error_notif(l_item_type, l_item_key, l_preparer_user_name, l_doc_string, 'l_binding_exception - '||sqlerrm, 'PO_SIGNATURE_PVT.GET_SIGNATURE_NOTFN_BODY');
456: RAISE;
457: WHEN OTHERS THEN
458: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(l_item_type, l_item_key);
459: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(l_item_type, l_item_key);
460: WF_CORE.context('PO_SIGNATURE_PVT','Get_Signature_Notfn_Body',l_progress);
461: PO_REQAPPROVAL_INIT1.send_error_notif(l_item_type, l_item_key, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_SIGNATURE_PVT.GET_SIGNATURE_NOTFN_BODY');
462: RAISE;

Line 459: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(l_item_type, l_item_key);

455: PO_REQAPPROVAL_INIT1.send_error_notif(l_item_type, l_item_key, l_preparer_user_name, l_doc_string, 'l_binding_exception - '||sqlerrm, 'PO_SIGNATURE_PVT.GET_SIGNATURE_NOTFN_BODY');
456: RAISE;
457: WHEN OTHERS THEN
458: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(l_item_type, l_item_key);
459: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(l_item_type, l_item_key);
460: WF_CORE.context('PO_SIGNATURE_PVT','Get_Signature_Notfn_Body',l_progress);
461: PO_REQAPPROVAL_INIT1.send_error_notif(l_item_type, l_item_key, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_SIGNATURE_PVT.GET_SIGNATURE_NOTFN_BODY');
462: RAISE;
463:

Line 461: PO_REQAPPROVAL_INIT1.send_error_notif(l_item_type, l_item_key, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_SIGNATURE_PVT.GET_SIGNATURE_NOTFN_BODY');

457: WHEN OTHERS THEN
458: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(l_item_type, l_item_key);
459: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(l_item_type, l_item_key);
460: WF_CORE.context('PO_SIGNATURE_PVT','Get_Signature_Notfn_Body',l_progress);
461: PO_REQAPPROVAL_INIT1.send_error_notif(l_item_type, l_item_key, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_SIGNATURE_PVT.GET_SIGNATURE_NOTFN_BODY');
462: RAISE;
463:
464: END GET_SIGNATURE_NOTFN_BODY;
465:

Line 745: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemtype, itemkey);

741: 'End erecords_exception:PO_SIGNATURE_PVT.CREATE_ERECORD ');
742: PO_WF_DEBUG_PKG.INSERT_DEBUG(itemtype, itemkey,
743: 'ERROR RETURNED '||l_msg_data);
744: END IF;
745: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemtype, itemkey);
746: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemtype, itemkey);
747: wf_core.context('PO_SIGNATURE_PVT', 'Create_Erecord', 'l_erecords_exception');
748:
749: PO_REQAPPROVAL_INIT1.send_error_notif(itemtype, itemkey, l_preparer_user_name,

Line 746: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemtype, itemkey);

742: PO_WF_DEBUG_PKG.INSERT_DEBUG(itemtype, itemkey,
743: 'ERROR RETURNED '||l_msg_data);
744: END IF;
745: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemtype, itemkey);
746: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemtype, itemkey);
747: wf_core.context('PO_SIGNATURE_PVT', 'Create_Erecord', 'l_erecords_exception');
748:
749: PO_REQAPPROVAL_INIT1.send_error_notif(itemtype, itemkey, l_preparer_user_name,
750: l_doc_string, l_msg_data,'PO_SIGNATURE_PVT.Create_Erecord');

Line 749: PO_REQAPPROVAL_INIT1.send_error_notif(itemtype, itemkey, l_preparer_user_name,

745: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemtype, itemkey);
746: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemtype, itemkey);
747: wf_core.context('PO_SIGNATURE_PVT', 'Create_Erecord', 'l_erecords_exception');
748:
749: PO_REQAPPROVAL_INIT1.send_error_notif(itemtype, itemkey, l_preparer_user_name,
750: l_doc_string, l_msg_data,'PO_SIGNATURE_PVT.Create_Erecord');
751: RAISE;
752: END CREATE_ERECORD;
753:

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

1043: 'End contracts_call_exception:PO_SIGNATURE_PVT.POST_SIGNATURE ');
1044: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1045: 'ERROR RETURNED '||l_msg_data);
1046: END IF;
1047: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1048: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1049: wf_core.context('PO_SIGNATURE_PVT', 'Post_Signature', 'l_contracts_call_Exception');
1050:
1051: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,

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

1044: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1045: 'ERROR RETURNED '||l_msg_data);
1046: END IF;
1047: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1048: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1049: wf_core.context('PO_SIGNATURE_PVT', 'Post_Signature', 'l_contracts_call_Exception');
1050:
1051: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,
1052: l_doc_string, l_msg_data,'PO_SIGNATURE_PVT.Post_Signature');

Line 1051: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,

1047: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1048: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1049: wf_core.context('PO_SIGNATURE_PVT', 'Post_Signature', 'l_contracts_call_Exception');
1050:
1051: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,
1052: l_doc_string, l_msg_data,'PO_SIGNATURE_PVT.Post_Signature');
1053: RAISE;
1054: --
1055: WHEN l_binding_exception then

Line 1062: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemtype, itemkey);

1058: 'End binding_exception:PO_SIGNATURE_PVT.POST_SIGNATURE ');
1059: PO_WF_DEBUG_PKG.INSERT_DEBUG(itemtype, itemkey,
1060: 'ERROR RETURNED '||l_msg_data);
1061: END IF;
1062: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemtype, itemkey);
1063: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemtype, itemkey);
1064: wf_core.context('PO_SIGNATURE_PVT', 'Post_Signature', 'l_binding_exception');
1065:
1066: PO_REQAPPROVAL_INIT1.send_error_notif(itemtype, itemkey, l_preparer_user_name,

Line 1063: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemtype, itemkey);

1059: PO_WF_DEBUG_PKG.INSERT_DEBUG(itemtype, itemkey,
1060: 'ERROR RETURNED '||l_msg_data);
1061: END IF;
1062: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemtype, itemkey);
1063: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemtype, itemkey);
1064: wf_core.context('PO_SIGNATURE_PVT', 'Post_Signature', 'l_binding_exception');
1065:
1066: PO_REQAPPROVAL_INIT1.send_error_notif(itemtype, itemkey, l_preparer_user_name,
1067: l_doc_string, l_msg_data,'PO_SIGNATURE_PVT.Post_Signature');

Line 1066: PO_REQAPPROVAL_INIT1.send_error_notif(itemtype, itemkey, l_preparer_user_name,

1062: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemtype, itemkey);
1063: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemtype, itemkey);
1064: wf_core.context('PO_SIGNATURE_PVT', 'Post_Signature', 'l_binding_exception');
1065:
1066: PO_REQAPPROVAL_INIT1.send_error_notif(itemtype, itemkey, l_preparer_user_name,
1067: l_doc_string, l_msg_data,'PO_SIGNATURE_PVT.Post_Signature');
1068: RAISE;
1069:
1070: WHEN others THEN

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

1067: l_doc_string, l_msg_data,'PO_SIGNATURE_PVT.Post_Signature');
1068: RAISE;
1069:
1070: WHEN others THEN
1071: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1072: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1073: WF_CORE.context('PO_SIGNATURE_PVT','Post_Signature',l_progress);
1074: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_SIGNATURE_PVT.POST_SIGNATURE');
1075: RAISE;

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

1068: RAISE;
1069:
1070: WHEN others THEN
1071: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1072: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1073: WF_CORE.context('PO_SIGNATURE_PVT','Post_Signature',l_progress);
1074: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_SIGNATURE_PVT.POST_SIGNATURE');
1075: RAISE;
1076: END POST_SIGNATURE;

Line 1074: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_SIGNATURE_PVT.POST_SIGNATURE');

1070: WHEN others THEN
1071: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1072: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1073: WF_CORE.context('PO_SIGNATURE_PVT','Post_Signature',l_progress);
1074: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_SIGNATURE_PVT.POST_SIGNATURE');
1075: RAISE;
1076: END POST_SIGNATURE;
1077:
1078: -------------------------------------------------------------------------------

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

1174: END IF;
1175:
1176: EXCEPTION
1177: WHEN OTHERS THEN
1178: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1179: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1180: WF_CORE.context('PO_SIGNATURE_PVT','set_accepted_supplier_response',l_progress);
1181: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_SIGNATURE_PVT.SET_ACCEPTED_SUPPLIER_RESPONSE');
1182: RAISE;

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

1175:
1176: EXCEPTION
1177: WHEN OTHERS THEN
1178: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1179: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1180: WF_CORE.context('PO_SIGNATURE_PVT','set_accepted_supplier_response',l_progress);
1181: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_SIGNATURE_PVT.SET_ACCEPTED_SUPPLIER_RESPONSE');
1182: RAISE;
1183: END SET_ACCEPTED_SUPPLIER_RESPONSE;

Line 1181: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_SIGNATURE_PVT.SET_ACCEPTED_SUPPLIER_RESPONSE');

1177: WHEN OTHERS THEN
1178: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1179: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1180: WF_CORE.context('PO_SIGNATURE_PVT','set_accepted_supplier_response',l_progress);
1181: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_SIGNATURE_PVT.SET_ACCEPTED_SUPPLIER_RESPONSE');
1182: RAISE;
1183: END SET_ACCEPTED_SUPPLIER_RESPONSE;
1184:
1185: -------------------------------------------------------------------------------

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

1281: END IF;
1282:
1283: EXCEPTION
1284: WHEN OTHERS THEN
1285: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1286: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1287: WF_CORE.context('PO_SIGNATURE_PVT','set_rejected_supplier_response',l_progress);
1288: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_SIGNATURE_PVT.SET_REJECTED_SUPPLIER_RESPONSE');
1289: RAISE;

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

1282:
1283: EXCEPTION
1284: WHEN OTHERS THEN
1285: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1286: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1287: WF_CORE.context('PO_SIGNATURE_PVT','set_rejected_supplier_response',l_progress);
1288: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_SIGNATURE_PVT.SET_REJECTED_SUPPLIER_RESPONSE');
1289: RAISE;
1290: END SET_REJECTED_SUPPLIER_RESPONSE;

Line 1288: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_SIGNATURE_PVT.SET_REJECTED_SUPPLIER_RESPONSE');

1284: WHEN OTHERS THEN
1285: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1286: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1287: WF_CORE.context('PO_SIGNATURE_PVT','set_rejected_supplier_response',l_progress);
1288: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_SIGNATURE_PVT.SET_REJECTED_SUPPLIER_RESPONSE');
1289: RAISE;
1290: END SET_REJECTED_SUPPLIER_RESPONSE;
1291:
1292: -------------------------------------------------------------------------------

Line 1526: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(l_item_type, l_item_key);

1522: END IF;
1523:
1524: EXCEPTION
1525: WHEN l_binding_exception then
1526: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(l_item_type, l_item_key);
1527: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(l_item_type, l_item_key);
1528: WF_CORE.context('PO_SIGNATURE_PVT','get_buyer_info_notfn_body',l_progress);
1529: PO_REQAPPROVAL_INIT1.send_error_notif(l_item_type, l_item_key, l_preparer_user_name, l_doc_string, 'l_binding_exception'||sqlerrm, 'PO_SIGNATURE_PVT.GET_BUYER_INFO_NOTFN_BODY');
1530: RAISE;

Line 1527: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(l_item_type, l_item_key);

1523:
1524: EXCEPTION
1525: WHEN l_binding_exception then
1526: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(l_item_type, l_item_key);
1527: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(l_item_type, l_item_key);
1528: WF_CORE.context('PO_SIGNATURE_PVT','get_buyer_info_notfn_body',l_progress);
1529: PO_REQAPPROVAL_INIT1.send_error_notif(l_item_type, l_item_key, l_preparer_user_name, l_doc_string, 'l_binding_exception'||sqlerrm, 'PO_SIGNATURE_PVT.GET_BUYER_INFO_NOTFN_BODY');
1530: RAISE;
1531: WHEN OTHERS THEN

Line 1529: PO_REQAPPROVAL_INIT1.send_error_notif(l_item_type, l_item_key, l_preparer_user_name, l_doc_string, 'l_binding_exception'||sqlerrm, 'PO_SIGNATURE_PVT.GET_BUYER_INFO_NOTFN_BODY');

1525: WHEN l_binding_exception then
1526: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(l_item_type, l_item_key);
1527: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(l_item_type, l_item_key);
1528: WF_CORE.context('PO_SIGNATURE_PVT','get_buyer_info_notfn_body',l_progress);
1529: PO_REQAPPROVAL_INIT1.send_error_notif(l_item_type, l_item_key, l_preparer_user_name, l_doc_string, 'l_binding_exception'||sqlerrm, 'PO_SIGNATURE_PVT.GET_BUYER_INFO_NOTFN_BODY');
1530: RAISE;
1531: WHEN OTHERS THEN
1532: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(l_item_type, l_item_key);
1533: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(l_item_type, l_item_key);

Line 1532: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(l_item_type, l_item_key);

1528: WF_CORE.context('PO_SIGNATURE_PVT','get_buyer_info_notfn_body',l_progress);
1529: PO_REQAPPROVAL_INIT1.send_error_notif(l_item_type, l_item_key, l_preparer_user_name, l_doc_string, 'l_binding_exception'||sqlerrm, 'PO_SIGNATURE_PVT.GET_BUYER_INFO_NOTFN_BODY');
1530: RAISE;
1531: WHEN OTHERS THEN
1532: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(l_item_type, l_item_key);
1533: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(l_item_type, l_item_key);
1534: WF_CORE.context('PO_SIGNATURE_PVT','get_buyer_info_notfn_body',l_progress);
1535: PO_REQAPPROVAL_INIT1.send_error_notif(l_item_type, l_item_key, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_SIGNATURE_PVT.GET_BUYER_INFO_NOTFN_BODY');
1536: RAISE;

Line 1533: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(l_item_type, l_item_key);

1529: PO_REQAPPROVAL_INIT1.send_error_notif(l_item_type, l_item_key, l_preparer_user_name, l_doc_string, 'l_binding_exception'||sqlerrm, 'PO_SIGNATURE_PVT.GET_BUYER_INFO_NOTFN_BODY');
1530: RAISE;
1531: WHEN OTHERS THEN
1532: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(l_item_type, l_item_key);
1533: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(l_item_type, l_item_key);
1534: WF_CORE.context('PO_SIGNATURE_PVT','get_buyer_info_notfn_body',l_progress);
1535: PO_REQAPPROVAL_INIT1.send_error_notif(l_item_type, l_item_key, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_SIGNATURE_PVT.GET_BUYER_INFO_NOTFN_BODY');
1536: RAISE;
1537: END GET_BUYER_INFO_NOTFN_BODY;

Line 1535: PO_REQAPPROVAL_INIT1.send_error_notif(l_item_type, l_item_key, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_SIGNATURE_PVT.GET_BUYER_INFO_NOTFN_BODY');

1531: WHEN OTHERS THEN
1532: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(l_item_type, l_item_key);
1533: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(l_item_type, l_item_key);
1534: WF_CORE.context('PO_SIGNATURE_PVT','get_buyer_info_notfn_body',l_progress);
1535: PO_REQAPPROVAL_INIT1.send_error_notif(l_item_type, l_item_key, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_SIGNATURE_PVT.GET_BUYER_INFO_NOTFN_BODY');
1536: RAISE;
1537: END GET_BUYER_INFO_NOTFN_BODY;
1538:
1539: -------------------------------------------------------------------------------

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

1636: END IF;
1637:
1638: EXCEPTION
1639: WHEN OTHERS THEN
1640: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1641: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1642: WF_CORE.context('PO_SIGNATURE_PVT','set_accepted_buyer_response',l_progress);
1643: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_SIGNATURE_PVT.SET_ACCEPTED_BUYER_RESPONSE');
1644: RAISE;

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

1637:
1638: EXCEPTION
1639: WHEN OTHERS THEN
1640: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1641: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1642: WF_CORE.context('PO_SIGNATURE_PVT','set_accepted_buyer_response',l_progress);
1643: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_SIGNATURE_PVT.SET_ACCEPTED_BUYER_RESPONSE');
1644: RAISE;
1645: END SET_ACCEPTED_BUYER_RESPONSE;

Line 1643: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_SIGNATURE_PVT.SET_ACCEPTED_BUYER_RESPONSE');

1639: WHEN OTHERS THEN
1640: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1641: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1642: WF_CORE.context('PO_SIGNATURE_PVT','set_accepted_buyer_response',l_progress);
1643: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_SIGNATURE_PVT.SET_ACCEPTED_BUYER_RESPONSE');
1644: RAISE;
1645: END SET_ACCEPTED_BUYER_RESPONSE;
1646:
1647: -------------------------------------------------------------------------------

Line 1873: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(l_item_type, l_item_key);

1869: END IF;
1870:
1871: EXCEPTION
1872: WHEN l_binding_exception then
1873: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(l_item_type, l_item_key);
1874: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(l_item_type, l_item_key);
1875: WF_CORE.context('PO_SIGNATURE_PVT','get_supplier_info_notfn_body',l_progress);
1876: PO_REQAPPROVAL_INIT1.send_error_notif(l_item_type, l_item_key, l_preparer_user_name, l_doc_string, 'l_binding_exception'||sqlerrm, 'PO_SIGNATURE_PVT.GET_SUPPLIER_INFO_NOTFN_BODY');
1877: RAISE;

Line 1874: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(l_item_type, l_item_key);

1870:
1871: EXCEPTION
1872: WHEN l_binding_exception then
1873: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(l_item_type, l_item_key);
1874: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(l_item_type, l_item_key);
1875: WF_CORE.context('PO_SIGNATURE_PVT','get_supplier_info_notfn_body',l_progress);
1876: PO_REQAPPROVAL_INIT1.send_error_notif(l_item_type, l_item_key, l_preparer_user_name, l_doc_string, 'l_binding_exception'||sqlerrm, 'PO_SIGNATURE_PVT.GET_SUPPLIER_INFO_NOTFN_BODY');
1877: RAISE;
1878: WHEN OTHERS THEN

Line 1876: PO_REQAPPROVAL_INIT1.send_error_notif(l_item_type, l_item_key, l_preparer_user_name, l_doc_string, 'l_binding_exception'||sqlerrm, 'PO_SIGNATURE_PVT.GET_SUPPLIER_INFO_NOTFN_BODY');

1872: WHEN l_binding_exception then
1873: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(l_item_type, l_item_key);
1874: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(l_item_type, l_item_key);
1875: WF_CORE.context('PO_SIGNATURE_PVT','get_supplier_info_notfn_body',l_progress);
1876: PO_REQAPPROVAL_INIT1.send_error_notif(l_item_type, l_item_key, l_preparer_user_name, l_doc_string, 'l_binding_exception'||sqlerrm, 'PO_SIGNATURE_PVT.GET_SUPPLIER_INFO_NOTFN_BODY');
1877: RAISE;
1878: WHEN OTHERS THEN
1879: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(l_item_type, l_item_key);
1880: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(l_item_type, l_item_key);

Line 1879: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(l_item_type, l_item_key);

1875: WF_CORE.context('PO_SIGNATURE_PVT','get_supplier_info_notfn_body',l_progress);
1876: PO_REQAPPROVAL_INIT1.send_error_notif(l_item_type, l_item_key, l_preparer_user_name, l_doc_string, 'l_binding_exception'||sqlerrm, 'PO_SIGNATURE_PVT.GET_SUPPLIER_INFO_NOTFN_BODY');
1877: RAISE;
1878: WHEN OTHERS THEN
1879: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(l_item_type, l_item_key);
1880: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(l_item_type, l_item_key);
1881: WF_CORE.context('PO_SIGNATURE_PVT','get_supplier_info_notfn_body',l_progress);
1882: PO_REQAPPROVAL_INIT1.send_error_notif(l_item_type, l_item_key, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_SIGNATURE_PVT.GET_SUPPLIER_INFO_NOTFN_BODY');
1883: RAISE;

Line 1880: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(l_item_type, l_item_key);

1876: PO_REQAPPROVAL_INIT1.send_error_notif(l_item_type, l_item_key, l_preparer_user_name, l_doc_string, 'l_binding_exception'||sqlerrm, 'PO_SIGNATURE_PVT.GET_SUPPLIER_INFO_NOTFN_BODY');
1877: RAISE;
1878: WHEN OTHERS THEN
1879: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(l_item_type, l_item_key);
1880: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(l_item_type, l_item_key);
1881: WF_CORE.context('PO_SIGNATURE_PVT','get_supplier_info_notfn_body',l_progress);
1882: PO_REQAPPROVAL_INIT1.send_error_notif(l_item_type, l_item_key, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_SIGNATURE_PVT.GET_SUPPLIER_INFO_NOTFN_BODY');
1883: RAISE;
1884:

Line 1882: PO_REQAPPROVAL_INIT1.send_error_notif(l_item_type, l_item_key, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_SIGNATURE_PVT.GET_SUPPLIER_INFO_NOTFN_BODY');

1878: WHEN OTHERS THEN
1879: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(l_item_type, l_item_key);
1880: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(l_item_type, l_item_key);
1881: WF_CORE.context('PO_SIGNATURE_PVT','get_supplier_info_notfn_body',l_progress);
1882: PO_REQAPPROVAL_INIT1.send_error_notif(l_item_type, l_item_key, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_SIGNATURE_PVT.GET_SUPPLIER_INFO_NOTFN_BODY');
1883: RAISE;
1884:
1885: END GET_SUPPLIER_INFO_NOTFN_BODY;
1886:

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

1980:
1981:
1982: EXCEPTION
1983: WHEN OTHERS THEN
1984: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1985: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1986: WF_CORE.context('PO_SIGNATURE_PVT','set_rejected_buyer_response',l_progress);
1987: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_SIGNATURE_PVT.SET_REJECTED_BUYER_RESPONSE');
1988: RAISE;

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

1981:
1982: EXCEPTION
1983: WHEN OTHERS THEN
1984: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1985: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1986: WF_CORE.context('PO_SIGNATURE_PVT','set_rejected_buyer_response',l_progress);
1987: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_SIGNATURE_PVT.SET_REJECTED_BUYER_RESPONSE');
1988: RAISE;
1989: END SET_REJECTED_BUYER_RESPONSE;

Line 1987: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_SIGNATURE_PVT.SET_REJECTED_BUYER_RESPONSE');

1983: WHEN OTHERS THEN
1984: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1985: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1986: WF_CORE.context('PO_SIGNATURE_PVT','set_rejected_buyer_response',l_progress);
1987: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_SIGNATURE_PVT.SET_REJECTED_BUYER_RESPONSE');
1988: RAISE;
1989: END SET_REJECTED_BUYER_RESPONSE;
1990:
1991: -------------------------------------------------------------------------------

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

2064: END IF;
2065:
2066: EXCEPTION
2067: WHEN OTHERS THEN
2068: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
2069: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
2070: WF_CORE.context('PO_SIGNATURE_PVT','is_signature_required',l_progress);
2071: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_SIGNATURE_PVT.IS_SIGNATURE_REQUIRED');
2072: RAISE;

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

2065:
2066: EXCEPTION
2067: WHEN OTHERS THEN
2068: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
2069: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
2070: WF_CORE.context('PO_SIGNATURE_PVT','is_signature_required',l_progress);
2071: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_SIGNATURE_PVT.IS_SIGNATURE_REQUIRED');
2072: RAISE;
2073: END IS_SIGNATURE_REQUIRED;

Line 2071: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_SIGNATURE_PVT.IS_SIGNATURE_REQUIRED');

2067: WHEN OTHERS THEN
2068: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
2069: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
2070: WF_CORE.context('PO_SIGNATURE_PVT','is_signature_required',l_progress);
2071: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_SIGNATURE_PVT.IS_SIGNATURE_REQUIRED');
2072: RAISE;
2073: END IS_SIGNATURE_REQUIRED;
2074:
2075:

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

2272: avalue => l_notification_id);
2273: END IF;
2274: EXCEPTION
2275: WHEN OTHERS THEN
2276: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
2277: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
2278: WF_CORE.context('PO_SIGNATURE_PVT','set_supplier_notification_id',l_progress);
2279: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_SIGNATURE_PVT.SET_SUPPLIER_NOTIFICATION_ID');
2280: RAISE;

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

2273: END IF;
2274: EXCEPTION
2275: WHEN OTHERS THEN
2276: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
2277: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
2278: WF_CORE.context('PO_SIGNATURE_PVT','set_supplier_notification_id',l_progress);
2279: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_SIGNATURE_PVT.SET_SUPPLIER_NOTIFICATION_ID');
2280: RAISE;
2281: END SET_SUPPLIER_NOTIFICATION_ID;

Line 2279: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_SIGNATURE_PVT.SET_SUPPLIER_NOTIFICATION_ID');

2275: WHEN OTHERS THEN
2276: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
2277: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
2278: WF_CORE.context('PO_SIGNATURE_PVT','set_supplier_notification_id',l_progress);
2279: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_SIGNATURE_PVT.SET_SUPPLIER_NOTIFICATION_ID');
2280: RAISE;
2281: END SET_SUPPLIER_NOTIFICATION_ID;
2282:
2283:

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

2333: avalue => l_notification_id);
2334: END IF;
2335: EXCEPTION
2336: WHEN OTHERS THEN
2337: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
2338: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
2339: WF_CORE.context('PO_SIGNATURE_PVT','set_buyer_notification_id',l_progress);
2340: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_SIGNATURE_PVT.SET_BUYER_NOTIFICATION_ID');
2341: RAISE;

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

2334: END IF;
2335: EXCEPTION
2336: WHEN OTHERS THEN
2337: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
2338: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
2339: WF_CORE.context('PO_SIGNATURE_PVT','set_buyer_notification_id',l_progress);
2340: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_SIGNATURE_PVT.SET_BUYER_NOTIFICATION_ID');
2341: RAISE;
2342: END SET_BUYER_NOTIFICATION_ID;

Line 2340: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_SIGNATURE_PVT.SET_BUYER_NOTIFICATION_ID');

2336: WHEN OTHERS THEN
2337: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
2338: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
2339: WF_CORE.context('PO_SIGNATURE_PVT','set_buyer_notification_id',l_progress);
2340: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_SIGNATURE_PVT.SET_BUYER_NOTIFICATION_ID');
2341: RAISE;
2342: END SET_BUYER_NOTIFICATION_ID;
2343:
2344: -------------------------------------------------------------------------------