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 134: PO_REQAPPROVAL_INIT1.get_user_name(p_employee_id => l_preparer_id,

130: itemkey => itemkey,
131: aname => 'PREPARER_ID',
132: avalue => l_preparer_id);
133:
134: PO_REQAPPROVAL_INIT1.get_user_name(p_employee_id => l_preparer_id,
135: x_username => l_username,
136: x_user_display_name => l_user_display_name);
137:
138: WF_ENGINE.SetItemOwner (itemtype => itemtype,

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

319: END IF;
320:
321: EXCEPTION
322: WHEN l_binding_exception then
323: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemtype, itemkey);
324: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemtype, itemkey);
325: WF_CORE.context('PO_SIGNATURE_PVT','Set_Startup_Values',l_progress);
326: 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');
327: RAISE;

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

320:
321: EXCEPTION
322: WHEN l_binding_exception then
323: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemtype, itemkey);
324: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemtype, itemkey);
325: WF_CORE.context('PO_SIGNATURE_PVT','Set_Startup_Values',l_progress);
326: 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');
327: RAISE;
328:

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

322: WHEN l_binding_exception then
323: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemtype, itemkey);
324: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemtype, itemkey);
325: WF_CORE.context('PO_SIGNATURE_PVT','Set_Startup_Values',l_progress);
326: 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');
327: RAISE;
328:
329: WHEN OTHERS THEN
330: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);

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

326: 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');
327: RAISE;
328:
329: WHEN OTHERS THEN
330: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
331: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
332: WF_CORE.context('PO_SIGNATURE_PVT','Set_Startup_Values',l_progress);
333: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_SIGNATURE_PVT.SET_STARTUP_VALUES');
334: RAISE;

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

327: RAISE;
328:
329: WHEN OTHERS THEN
330: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
331: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
332: WF_CORE.context('PO_SIGNATURE_PVT','Set_Startup_Values',l_progress);
333: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_SIGNATURE_PVT.SET_STARTUP_VALUES');
334: RAISE;
335:

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

329: WHEN OTHERS THEN
330: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
331: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
332: WF_CORE.context('PO_SIGNATURE_PVT','Set_Startup_Values',l_progress);
333: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_SIGNATURE_PVT.SET_STARTUP_VALUES');
334: RAISE;
335:
336: END SET_STARTUP_VALUES;
337:

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

535: END IF;
536:
537: EXCEPTION
538: WHEN l_binding_exception then
539: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(l_item_type, l_item_key);
540: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(l_item_type, l_item_key);
541: WF_CORE.context('PO_SIGNATURE_PVT','Get_Signature_Notfn_Body',l_progress);
542: 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');
543: RAISE;

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

536:
537: EXCEPTION
538: WHEN l_binding_exception then
539: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(l_item_type, l_item_key);
540: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(l_item_type, l_item_key);
541: WF_CORE.context('PO_SIGNATURE_PVT','Get_Signature_Notfn_Body',l_progress);
542: 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');
543: RAISE;
544: WHEN OTHERS THEN

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

538: WHEN l_binding_exception then
539: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(l_item_type, l_item_key);
540: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(l_item_type, l_item_key);
541: WF_CORE.context('PO_SIGNATURE_PVT','Get_Signature_Notfn_Body',l_progress);
542: 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');
543: RAISE;
544: WHEN OTHERS THEN
545: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(l_item_type, l_item_key);
546: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(l_item_type, l_item_key);

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

541: WF_CORE.context('PO_SIGNATURE_PVT','Get_Signature_Notfn_Body',l_progress);
542: 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');
543: RAISE;
544: WHEN OTHERS THEN
545: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(l_item_type, l_item_key);
546: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(l_item_type, l_item_key);
547: WF_CORE.context('PO_SIGNATURE_PVT','Get_Signature_Notfn_Body',l_progress);
548: 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');
549: RAISE;

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

542: 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');
543: RAISE;
544: WHEN OTHERS THEN
545: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(l_item_type, l_item_key);
546: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(l_item_type, l_item_key);
547: WF_CORE.context('PO_SIGNATURE_PVT','Get_Signature_Notfn_Body',l_progress);
548: 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');
549: RAISE;
550:

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

544: WHEN OTHERS THEN
545: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(l_item_type, l_item_key);
546: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(l_item_type, l_item_key);
547: WF_CORE.context('PO_SIGNATURE_PVT','Get_Signature_Notfn_Body',l_progress);
548: 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');
549: RAISE;
550:
551: END GET_SIGNATURE_NOTFN_BODY;
552:

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

869: 'End erecords_exception:PO_SIGNATURE_PVT.CREATE_ERECORD ');
870: PO_WF_DEBUG_PKG.INSERT_DEBUG(itemtype, itemkey,
871: 'ERROR RETURNED '||l_msg_data);
872: END IF;
873: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemtype, itemkey);
874: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemtype, itemkey);
875: wf_core.context('PO_SIGNATURE_PVT', 'Create_Erecord', 'l_erecords_exception');
876:
877: PO_REQAPPROVAL_INIT1.send_error_notif(itemtype, itemkey, l_preparer_user_name,

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

870: PO_WF_DEBUG_PKG.INSERT_DEBUG(itemtype, itemkey,
871: 'ERROR RETURNED '||l_msg_data);
872: END IF;
873: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemtype, itemkey);
874: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemtype, itemkey);
875: wf_core.context('PO_SIGNATURE_PVT', 'Create_Erecord', 'l_erecords_exception');
876:
877: PO_REQAPPROVAL_INIT1.send_error_notif(itemtype, itemkey, l_preparer_user_name,
878: l_doc_string, l_msg_data,'PO_SIGNATURE_PVT.Create_Erecord');

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

873: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemtype, itemkey);
874: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemtype, itemkey);
875: wf_core.context('PO_SIGNATURE_PVT', 'Create_Erecord', 'l_erecords_exception');
876:
877: PO_REQAPPROVAL_INIT1.send_error_notif(itemtype, itemkey, l_preparer_user_name,
878: l_doc_string, l_msg_data,'PO_SIGNATURE_PVT.Create_Erecord');
879: RAISE;
880: END CREATE_ERECORD;
881:

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

1347: 'End contracts_call_exception:PO_SIGNATURE_PVT.POST_SIGNATURE ');
1348: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1349: 'ERROR RETURNED '||l_msg_data);
1350: END IF;
1351: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1352: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1353: wf_core.context('PO_SIGNATURE_PVT', 'Post_Signature', 'l_contracts_call_Exception');
1354:
1355: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,

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

1348: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1349: 'ERROR RETURNED '||l_msg_data);
1350: END IF;
1351: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1352: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1353: wf_core.context('PO_SIGNATURE_PVT', 'Post_Signature', 'l_contracts_call_Exception');
1354:
1355: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,
1356: l_doc_string, l_msg_data,'PO_SIGNATURE_PVT.Post_Signature');

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

1351: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1352: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1353: wf_core.context('PO_SIGNATURE_PVT', 'Post_Signature', 'l_contracts_call_Exception');
1354:
1355: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,
1356: l_doc_string, l_msg_data,'PO_SIGNATURE_PVT.Post_Signature');
1357: RAISE;
1358: --
1359: WHEN l_binding_exception then

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

1362: 'End binding_exception:PO_SIGNATURE_PVT.POST_SIGNATURE ');
1363: PO_WF_DEBUG_PKG.INSERT_DEBUG(itemtype, itemkey,
1364: 'ERROR RETURNED '||l_msg_data);
1365: END IF;
1366: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemtype, itemkey);
1367: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemtype, itemkey);
1368: wf_core.context('PO_SIGNATURE_PVT', 'Post_Signature', 'l_binding_exception');
1369:
1370: PO_REQAPPROVAL_INIT1.send_error_notif(itemtype, itemkey, l_preparer_user_name,

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

1363: PO_WF_DEBUG_PKG.INSERT_DEBUG(itemtype, itemkey,
1364: 'ERROR RETURNED '||l_msg_data);
1365: END IF;
1366: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemtype, itemkey);
1367: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemtype, itemkey);
1368: wf_core.context('PO_SIGNATURE_PVT', 'Post_Signature', 'l_binding_exception');
1369:
1370: PO_REQAPPROVAL_INIT1.send_error_notif(itemtype, itemkey, l_preparer_user_name,
1371: l_doc_string, l_msg_data,'PO_SIGNATURE_PVT.Post_Signature');

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

1366: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemtype, itemkey);
1367: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemtype, itemkey);
1368: wf_core.context('PO_SIGNATURE_PVT', 'Post_Signature', 'l_binding_exception');
1369:
1370: PO_REQAPPROVAL_INIT1.send_error_notif(itemtype, itemkey, l_preparer_user_name,
1371: l_doc_string, l_msg_data,'PO_SIGNATURE_PVT.Post_Signature');
1372: RAISE;
1373:
1374: WHEN others THEN

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

1371: l_doc_string, l_msg_data,'PO_SIGNATURE_PVT.Post_Signature');
1372: RAISE;
1373:
1374: WHEN others THEN
1375: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1376: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1377: WF_CORE.context('PO_SIGNATURE_PVT','Post_Signature',l_progress);
1378: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_SIGNATURE_PVT.POST_SIGNATURE');
1379: RAISE;

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

1372: RAISE;
1373:
1374: WHEN others THEN
1375: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1376: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1377: WF_CORE.context('PO_SIGNATURE_PVT','Post_Signature',l_progress);
1378: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_SIGNATURE_PVT.POST_SIGNATURE');
1379: RAISE;
1380: END POST_SIGNATURE;

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

1374: WHEN others THEN
1375: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1376: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1377: WF_CORE.context('PO_SIGNATURE_PVT','Post_Signature',l_progress);
1378: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_SIGNATURE_PVT.POST_SIGNATURE');
1379: RAISE;
1380: END POST_SIGNATURE;
1381:
1382: -------------------------------------------------------------------------------

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

1498: END IF;
1499:
1500: EXCEPTION
1501: WHEN OTHERS THEN
1502: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1503: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1504: WF_CORE.context('PO_SIGNATURE_PVT','set_accepted_supplier_response',l_progress);
1505: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_SIGNATURE_PVT.SET_ACCEPTED_SUPPLIER_RESPONSE');
1506: RAISE;

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

1499:
1500: EXCEPTION
1501: WHEN OTHERS THEN
1502: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1503: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1504: WF_CORE.context('PO_SIGNATURE_PVT','set_accepted_supplier_response',l_progress);
1505: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_SIGNATURE_PVT.SET_ACCEPTED_SUPPLIER_RESPONSE');
1506: RAISE;
1507: END SET_ACCEPTED_SUPPLIER_RESPONSE;

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

1501: WHEN OTHERS THEN
1502: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1503: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1504: WF_CORE.context('PO_SIGNATURE_PVT','set_accepted_supplier_response',l_progress);
1505: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_SIGNATURE_PVT.SET_ACCEPTED_SUPPLIER_RESPONSE');
1506: RAISE;
1507: END SET_ACCEPTED_SUPPLIER_RESPONSE;
1508:
1509: -------------------------------------------------------------------------------

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

1624: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1625: END IF;
1626: EXCEPTION
1627: WHEN OTHERS THEN
1628: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1629: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1630: WF_CORE.context('PO_SIGNATURE_PVT','set_rejected_supplier_response',l_progress);
1631: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_SIGNATURE_PVT.SET_REJECTED_SUPPLIER_RESPONSE');
1632: RAISE;

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

1625: END IF;
1626: EXCEPTION
1627: WHEN OTHERS THEN
1628: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1629: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1630: WF_CORE.context('PO_SIGNATURE_PVT','set_rejected_supplier_response',l_progress);
1631: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_SIGNATURE_PVT.SET_REJECTED_SUPPLIER_RESPONSE');
1632: RAISE;
1633: END SET_REJECTED_SUPPLIER_RESPONSE;

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

1627: WHEN OTHERS THEN
1628: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1629: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1630: WF_CORE.context('PO_SIGNATURE_PVT','set_rejected_supplier_response',l_progress);
1631: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_SIGNATURE_PVT.SET_REJECTED_SUPPLIER_RESPONSE');
1632: RAISE;
1633: END SET_REJECTED_SUPPLIER_RESPONSE;
1634:
1635: -------------------------------------------------------------------------------

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

1866: END IF;
1867:
1868: EXCEPTION
1869: WHEN l_binding_exception then
1870: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(l_item_type, l_item_key);
1871: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(l_item_type, l_item_key);
1872: WF_CORE.context('PO_SIGNATURE_PVT','get_buyer_info_notfn_body',l_progress);
1873: 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');
1874: RAISE;

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

1867:
1868: EXCEPTION
1869: WHEN l_binding_exception then
1870: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(l_item_type, l_item_key);
1871: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(l_item_type, l_item_key);
1872: WF_CORE.context('PO_SIGNATURE_PVT','get_buyer_info_notfn_body',l_progress);
1873: 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');
1874: RAISE;
1875: WHEN OTHERS THEN

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

1869: WHEN l_binding_exception then
1870: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(l_item_type, l_item_key);
1871: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(l_item_type, l_item_key);
1872: WF_CORE.context('PO_SIGNATURE_PVT','get_buyer_info_notfn_body',l_progress);
1873: 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');
1874: RAISE;
1875: WHEN OTHERS THEN
1876: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(l_item_type, l_item_key);
1877: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(l_item_type, l_item_key);

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

1872: WF_CORE.context('PO_SIGNATURE_PVT','get_buyer_info_notfn_body',l_progress);
1873: 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');
1874: RAISE;
1875: WHEN OTHERS THEN
1876: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(l_item_type, l_item_key);
1877: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(l_item_type, l_item_key);
1878: WF_CORE.context('PO_SIGNATURE_PVT','get_buyer_info_notfn_body',l_progress);
1879: 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');
1880: RAISE;

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

1873: 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');
1874: RAISE;
1875: WHEN OTHERS THEN
1876: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(l_item_type, l_item_key);
1877: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(l_item_type, l_item_key);
1878: WF_CORE.context('PO_SIGNATURE_PVT','get_buyer_info_notfn_body',l_progress);
1879: 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');
1880: RAISE;
1881: END GET_BUYER_INFO_NOTFN_BODY;

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

1875: WHEN OTHERS THEN
1876: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(l_item_type, l_item_key);
1877: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(l_item_type, l_item_key);
1878: WF_CORE.context('PO_SIGNATURE_PVT','get_buyer_info_notfn_body',l_progress);
1879: 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');
1880: RAISE;
1881: END GET_BUYER_INFO_NOTFN_BODY;
1882:
1883: -------------------------------------------------------------------------------

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

1987: END IF;
1988:
1989: EXCEPTION
1990: WHEN OTHERS THEN
1991: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1992: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1993: WF_CORE.context('PO_SIGNATURE_PVT','set_accepted_buyer_response',l_progress);
1994: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_SIGNATURE_PVT.SET_ACCEPTED_BUYER_RESPONSE');
1995: RAISE;

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

1988:
1989: EXCEPTION
1990: WHEN OTHERS THEN
1991: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1992: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1993: WF_CORE.context('PO_SIGNATURE_PVT','set_accepted_buyer_response',l_progress);
1994: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_SIGNATURE_PVT.SET_ACCEPTED_BUYER_RESPONSE');
1995: RAISE;
1996: END SET_ACCEPTED_BUYER_RESPONSE;

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

1990: WHEN OTHERS THEN
1991: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1992: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1993: WF_CORE.context('PO_SIGNATURE_PVT','set_accepted_buyer_response',l_progress);
1994: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_SIGNATURE_PVT.SET_ACCEPTED_BUYER_RESPONSE');
1995: RAISE;
1996: END SET_ACCEPTED_BUYER_RESPONSE;
1997:
1998: -------------------------------------------------------------------------------

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

2220: END IF;
2221:
2222: EXCEPTION
2223: WHEN l_binding_exception then
2224: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(l_item_type, l_item_key);
2225: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(l_item_type, l_item_key);
2226: WF_CORE.context('PO_SIGNATURE_PVT','get_supplier_info_notfn_body',l_progress);
2227: 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');
2228: RAISE;

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

2221:
2222: EXCEPTION
2223: WHEN l_binding_exception then
2224: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(l_item_type, l_item_key);
2225: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(l_item_type, l_item_key);
2226: WF_CORE.context('PO_SIGNATURE_PVT','get_supplier_info_notfn_body',l_progress);
2227: 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');
2228: RAISE;
2229: WHEN OTHERS THEN

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

2223: WHEN l_binding_exception then
2224: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(l_item_type, l_item_key);
2225: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(l_item_type, l_item_key);
2226: WF_CORE.context('PO_SIGNATURE_PVT','get_supplier_info_notfn_body',l_progress);
2227: 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');
2228: RAISE;
2229: WHEN OTHERS THEN
2230: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(l_item_type, l_item_key);
2231: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(l_item_type, l_item_key);

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

2226: WF_CORE.context('PO_SIGNATURE_PVT','get_supplier_info_notfn_body',l_progress);
2227: 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');
2228: RAISE;
2229: WHEN OTHERS THEN
2230: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(l_item_type, l_item_key);
2231: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(l_item_type, l_item_key);
2232: WF_CORE.context('PO_SIGNATURE_PVT','get_supplier_info_notfn_body',l_progress);
2233: 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');
2234: RAISE;

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

2227: 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');
2228: RAISE;
2229: WHEN OTHERS THEN
2230: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(l_item_type, l_item_key);
2231: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(l_item_type, l_item_key);
2232: WF_CORE.context('PO_SIGNATURE_PVT','get_supplier_info_notfn_body',l_progress);
2233: 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');
2234: RAISE;
2235:

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

2229: WHEN OTHERS THEN
2230: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(l_item_type, l_item_key);
2231: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(l_item_type, l_item_key);
2232: WF_CORE.context('PO_SIGNATURE_PVT','get_supplier_info_notfn_body',l_progress);
2233: 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');
2234: RAISE;
2235:
2236: END GET_SUPPLIER_INFO_NOTFN_BODY;
2237:

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

2338:
2339:
2340: EXCEPTION
2341: WHEN OTHERS THEN
2342: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
2343: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
2344: WF_CORE.context('PO_SIGNATURE_PVT','set_rejected_buyer_response',l_progress);
2345: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_SIGNATURE_PVT.SET_REJECTED_BUYER_RESPONSE');
2346: RAISE;

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

2339:
2340: EXCEPTION
2341: WHEN OTHERS THEN
2342: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
2343: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
2344: WF_CORE.context('PO_SIGNATURE_PVT','set_rejected_buyer_response',l_progress);
2345: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_SIGNATURE_PVT.SET_REJECTED_BUYER_RESPONSE');
2346: RAISE;
2347: END SET_REJECTED_BUYER_RESPONSE;

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

2341: WHEN OTHERS THEN
2342: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
2343: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
2344: WF_CORE.context('PO_SIGNATURE_PVT','set_rejected_buyer_response',l_progress);
2345: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_SIGNATURE_PVT.SET_REJECTED_BUYER_RESPONSE');
2346: RAISE;
2347: END SET_REJECTED_BUYER_RESPONSE;
2348:
2349: -------------------------------------------------------------------------------

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

2422: END IF;
2423:
2424: EXCEPTION
2425: WHEN OTHERS THEN
2426: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
2427: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
2428: WF_CORE.context('PO_SIGNATURE_PVT','is_signature_required',l_progress);
2429: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_SIGNATURE_PVT.IS_SIGNATURE_REQUIRED');
2430: RAISE;

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

2423:
2424: EXCEPTION
2425: WHEN OTHERS THEN
2426: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
2427: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
2428: WF_CORE.context('PO_SIGNATURE_PVT','is_signature_required',l_progress);
2429: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_SIGNATURE_PVT.IS_SIGNATURE_REQUIRED');
2430: RAISE;
2431: END IS_SIGNATURE_REQUIRED;

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

2425: WHEN OTHERS THEN
2426: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
2427: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
2428: WF_CORE.context('PO_SIGNATURE_PVT','is_signature_required',l_progress);
2429: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_SIGNATURE_PVT.IS_SIGNATURE_REQUIRED');
2430: RAISE;
2431: END IS_SIGNATURE_REQUIRED;
2432:
2433:

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

2659: avalue => l_notification_id);
2660: END IF;
2661: EXCEPTION
2662: WHEN OTHERS THEN
2663: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
2664: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
2665: WF_CORE.context('PO_SIGNATURE_PVT','set_supplier_notification_id',l_progress);
2666: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_SIGNATURE_PVT.SET_SUPPLIER_NOTIFICATION_ID');
2667: RAISE;

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

2660: END IF;
2661: EXCEPTION
2662: WHEN OTHERS THEN
2663: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
2664: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
2665: WF_CORE.context('PO_SIGNATURE_PVT','set_supplier_notification_id',l_progress);
2666: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_SIGNATURE_PVT.SET_SUPPLIER_NOTIFICATION_ID');
2667: RAISE;
2668: END SET_SUPPLIER_NOTIFICATION_ID;

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

2662: WHEN OTHERS THEN
2663: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
2664: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
2665: WF_CORE.context('PO_SIGNATURE_PVT','set_supplier_notification_id',l_progress);
2666: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_SIGNATURE_PVT.SET_SUPPLIER_NOTIFICATION_ID');
2667: RAISE;
2668: END SET_SUPPLIER_NOTIFICATION_ID;
2669:
2670:

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

2771:
2772: END IF;
2773: EXCEPTION
2774: WHEN OTHERS THEN
2775: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
2776: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
2777: WF_CORE.context('PO_SIGNATURE_PVT','set_buyer_notification_id',l_progress);
2778: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_SIGNATURE_PVT.SET_BUYER_NOTIFICATION_ID');
2779: RAISE;

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

2772: END IF;
2773: EXCEPTION
2774: WHEN OTHERS THEN
2775: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
2776: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
2777: WF_CORE.context('PO_SIGNATURE_PVT','set_buyer_notification_id',l_progress);
2778: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_SIGNATURE_PVT.SET_BUYER_NOTIFICATION_ID');
2779: RAISE;
2780: END SET_BUYER_NOTIFICATION_ID;

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

2774: WHEN OTHERS THEN
2775: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
2776: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
2777: WF_CORE.context('PO_SIGNATURE_PVT','set_buyer_notification_id',l_progress);
2778: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_SIGNATURE_PVT.SET_BUYER_NOTIFICATION_ID');
2779: RAISE;
2780: END SET_BUYER_NOTIFICATION_ID;
2781:
2782: --

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

2883:
2884: END IF;
2885: EXCEPTION
2886: WHEN OTHERS THEN
2887: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
2888: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
2889: WF_CORE.context('PO_SIGNATURE_PVT','set_KO_notification_id',l_progress);
2890: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_SIGNATURE_PVT.SET_KO_NOTIFICATION_ID');
2891: RAISE;

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

2884: END IF;
2885: EXCEPTION
2886: WHEN OTHERS THEN
2887: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
2888: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
2889: WF_CORE.context('PO_SIGNATURE_PVT','set_KO_notification_id',l_progress);
2890: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_SIGNATURE_PVT.SET_KO_NOTIFICATION_ID');
2891: RAISE;
2892: END SET_KO_NOTIFICATION_ID;

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

2886: WHEN OTHERS THEN
2887: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
2888: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
2889: WF_CORE.context('PO_SIGNATURE_PVT','set_KO_notification_id',l_progress);
2890: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_SIGNATURE_PVT.SET_KO_NOTIFICATION_ID');
2891: RAISE;
2892: END SET_KO_NOTIFICATION_ID;
2893: --
2894: -------------------------------------------------------------------------------

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

4352:
4353:
4354: EXCEPTION
4355: WHEN OTHERS THEN
4356: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
4357: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
4358: WF_CORE.context('PO_SIGNATURE_PVT','Has_Doc_Been_Signed',l_progress);
4359: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_SIGNATURE_PVT.Has_Doc_Been_Signed');
4360: RAISE;

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

4353:
4354: EXCEPTION
4355: WHEN OTHERS THEN
4356: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
4357: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
4358: WF_CORE.context('PO_SIGNATURE_PVT','Has_Doc_Been_Signed',l_progress);
4359: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_SIGNATURE_PVT.Has_Doc_Been_Signed');
4360: RAISE;
4361: END HAS_DOC_BEEN_SIGNED;

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

4355: WHEN OTHERS THEN
4356: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
4357: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
4358: WF_CORE.context('PO_SIGNATURE_PVT','Has_Doc_Been_Signed',l_progress);
4359: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_SIGNATURE_PVT.Has_Doc_Been_Signed');
4360: RAISE;
4361: END HAS_DOC_BEEN_SIGNED;
4362:
4363: -------------------------------------------------------------------------------

Line 4573: l_edit_po_url := po_reqapproval_init1.get_mod_url(p_po_header_id => l_document_id,p_draft_id => l_draft_id, p_doc_subtype => l_doc_subtype, p_mode => 'update');

4569: -- Edit document link in the message is based on this attribute.
4570: -- When 'Approver can edit' check box is checked in document type page, this attribute is already initialized.
4571: -- When it is not checked it should be initialized here so that edit document link works.
4572: IF l_draft_id IS NOT NULL AND l_draft_id <> -1 THEN
4573: l_edit_po_url := po_reqapproval_init1.get_mod_url(p_po_header_id => l_document_id,p_draft_id => l_draft_id, p_doc_subtype => l_doc_subtype, p_mode => 'update');
4574: ELSE
4575: l_edit_po_url := po_reqapproval_init1.get_po_url(p_po_header_id => l_document_id, p_doc_subtype => l_doc_subtype, p_mode => 'update');
4576: END IF;
4577:

Line 4575: l_edit_po_url := po_reqapproval_init1.get_po_url(p_po_header_id => l_document_id, p_doc_subtype => l_doc_subtype, p_mode => 'update');

4571: -- When it is not checked it should be initialized here so that edit document link works.
4572: IF l_draft_id IS NOT NULL AND l_draft_id <> -1 THEN
4573: l_edit_po_url := po_reqapproval_init1.get_mod_url(p_po_header_id => l_document_id,p_draft_id => l_draft_id, p_doc_subtype => l_doc_subtype, p_mode => 'update');
4574: ELSE
4575: l_edit_po_url := po_reqapproval_init1.get_po_url(p_po_header_id => l_document_id, p_doc_subtype => l_doc_subtype, p_mode => 'update');
4576: END IF;
4577:
4578: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType, itemkey => itemkey, aname => 'EDIT_DOC_URL' , avalue => l_edit_po_url);
4579:

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

4742: END IF;
4743:
4744: EXCEPTION
4745: WHEN OTHERS THEN
4746: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
4747: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
4748: WF_CORE.context('PO_SIGNATURE_PVT','set_accepted_ko_response',l_progress);
4749: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_SIGNATURE_PVT.SET_ACCEPTED_KO_RESPONSE');
4750: RAISE;

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

4743:
4744: EXCEPTION
4745: WHEN OTHERS THEN
4746: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
4747: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
4748: WF_CORE.context('PO_SIGNATURE_PVT','set_accepted_ko_response',l_progress);
4749: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_SIGNATURE_PVT.SET_ACCEPTED_KO_RESPONSE');
4750: RAISE;
4751: END SET_ACCEPTED_KO_RESPONSE;

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

4745: WHEN OTHERS THEN
4746: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
4747: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
4748: WF_CORE.context('PO_SIGNATURE_PVT','set_accepted_ko_response',l_progress);
4749: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_SIGNATURE_PVT.SET_ACCEPTED_KO_RESPONSE');
4750: RAISE;
4751: END SET_ACCEPTED_KO_RESPONSE;
4752:
4753: -------------------------------------------------------------------------------

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

4853:
4854:
4855: EXCEPTION
4856: WHEN OTHERS THEN
4857: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
4858: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
4859: WF_CORE.context('PO_SIGNATURE_PVT','set_rejected_ko_response',l_progress);
4860: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_SIGNATURE_PVT.SET_REJECTED_KO_RESPONSE');
4861: RAISE;

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

4854:
4855: EXCEPTION
4856: WHEN OTHERS THEN
4857: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
4858: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
4859: WF_CORE.context('PO_SIGNATURE_PVT','set_rejected_ko_response',l_progress);
4860: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_SIGNATURE_PVT.SET_REJECTED_KO_RESPONSE');
4861: RAISE;
4862: END SET_REJECTED_KO_RESPONSE;

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

4856: WHEN OTHERS THEN
4857: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
4858: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
4859: WF_CORE.context('PO_SIGNATURE_PVT','set_rejected_ko_response',l_progress);
4860: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_SIGNATURE_PVT.SET_REJECTED_KO_RESPONSE');
4861: RAISE;
4862: END SET_REJECTED_KO_RESPONSE;
4863: -------------------------------------------------------------------------------
4864: --Start of Comments