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_SIGNATURE_PVT

Line 1: PACKAGE BODY PO_SIGNATURE_PVT AS

1: PACKAGE BODY PO_SIGNATURE_PVT AS
2: /* $Header: POXVSIGB.pls 120.42.12020000.3 2013/02/10 22:53:23 vegajula ship $ */
3:
4: -- Read the profile option that enables/disables the debug log
5: g_po_wf_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('PO_SET_DEBUG_WORKFLOW_ON'),'N');

Line 7: c_log_head CONSTANT VARCHAR2(30) := 'po.plsql.PO_SIGNATURE_PVT.';

3:
4: -- Read the profile option that enables/disables the debug log
5: g_po_wf_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('PO_SET_DEBUG_WORKFLOW_ON'),'N');
6:
7: c_log_head CONSTANT VARCHAR2(30) := 'po.plsql.PO_SIGNATURE_PVT.';
8: g_pkg_name CONSTANT VARCHAR2(30) := 'PO_SIGNATURE_PVT'; --
9: g_debug_stmt CONSTANT BOOLEAN := PO_DEBUG.is_debug_stmt_on;
10: g_debug_unexp CONSTANT BOOLEAN := PO_DEBUG.is_debug_unexp_on;
11:

Line 8: g_pkg_name CONSTANT VARCHAR2(30) := 'PO_SIGNATURE_PVT'; --

4: -- Read the profile option that enables/disables the debug log
5: g_po_wf_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('PO_SET_DEBUG_WORKFLOW_ON'),'N');
6:
7: c_log_head CONSTANT VARCHAR2(30) := 'po.plsql.PO_SIGNATURE_PVT.';
8: g_pkg_name CONSTANT VARCHAR2(30) := 'PO_SIGNATURE_PVT'; --
9: g_debug_stmt CONSTANT BOOLEAN := PO_DEBUG.is_debug_stmt_on;
10: g_debug_unexp CONSTANT BOOLEAN := PO_DEBUG.is_debug_unexp_on;
11:
12: -- Read the profile option that determines whether the promise date will be defaulted with need-by date or not

Line 109: l_progress := 'PO_SIGNATURE_PVT.Set_Startup_Values: 01';

105: l_po_itemkey PO_HEADERS_ALL.wf_item_key%TYPE;
106: BEGIN
107:
108: IF (g_po_wf_debug = 'Y') THEN
109: l_progress := 'PO_SIGNATURE_PVT.Set_Startup_Values: 01';
110: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
111: END IF;
112:
113: -- Do nothing in cancel or timeout mode

Line 274: 'PLSQLCLOB:PO_SIGNATURE_PVT.get_signature_notfn_body /'|| l_document_id ||':'||itemtype||':'||itemkey);

270: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,
271: itemkey => itemkey,
272: aname => 'PO_SUP_SIGNATURE_MSG_BODY',
273: avalue =>
274: 'PLSQLCLOB:PO_SIGNATURE_PVT.get_signature_notfn_body /'|| l_document_id ||':'||itemtype||':'||itemkey);
275:
276: /*Bug 9865162. Included fund_user check while deriving the supplier user name*/
277: BEGIN
278: SELECT fu.user_name

Line 317: l_progress := 'PO_SIGNATURE_PVT.Set_Startup_Values: 02 with E_SIGNER_EXISTS '|| l_esigner_exists;

313: l_esigner_exists := po_wf_util_pkg.GetItemAttrText (itemtype => itemtype, itemkey => l_po_itemkey, aname => 'E_SIGNER_EXISTS');
314: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype, itemkey => itemkey, aname => 'E_SIGNER_EXISTS', avalue => l_esigner_exists);
315:
316: IF (g_po_wf_debug = 'Y') THEN
317: l_progress := 'PO_SIGNATURE_PVT.Set_Startup_Values: 02 with E_SIGNER_EXISTS '|| l_esigner_exists;
318: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
319: END IF;
320:
321: EXCEPTION

Line 325: WF_CORE.context('PO_SIGNATURE_PVT','Set_Startup_Values',l_progress);

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:
329: WHEN OTHERS THEN

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 332: WF_CORE.context('PO_SIGNATURE_PVT','Set_Startup_Values',l_progress);

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:
336: END SET_STARTUP_VALUES;

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 405: l_progress := 'PO_SIGNATURE_PVT.get_signature_notfn_body: 01';

401: l_item_type := substr(document_id, l_firstcolon + 1, l_secondcolon - l_firstcolon - 1);
402: l_item_key := substr(document_id, l_secondcolon+1,length(document_id) - l_secondcolon);
403:
404: IF (g_po_wf_debug = 'Y') THEN
405: l_progress := 'PO_SIGNATURE_PVT.get_signature_notfn_body: 01';
406: PO_WF_DEBUG_PKG.insert_debug(l_item_type,l_item_key,l_progress);
407: END IF;
408:
409: l_buyer_name := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => l_item_type,

Line 526: l_progress := 'PO_SIGNATURE_PVT.get_signature_notfn_body: 02';

522:
523: l_msgbody := l_msgbody || '';
524:
525: IF (g_po_wf_debug = 'Y') THEN
526: l_progress := 'PO_SIGNATURE_PVT.get_signature_notfn_body: 02';
527: PO_WF_DEBUG_PKG.insert_debug(l_item_type,l_item_key,l_progress);
528: END IF;
529:
530: WF_NOTIFICATION.WriteToClob(document, l_msgbody);

Line 533: l_progress := 'PO_SIGNATURE_PVT.get_signature_notfn_body: 03';

529:
530: WF_NOTIFICATION.WriteToClob(document, l_msgbody);
531:
532: IF (g_po_wf_debug = 'Y') THEN
533: l_progress := 'PO_SIGNATURE_PVT.get_signature_notfn_body: 03';
534: PO_WF_DEBUG_PKG.insert_debug(l_item_type,l_item_key,l_progress);
535: END IF;
536:
537: EXCEPTION

Line 541: WF_CORE.context('PO_SIGNATURE_PVT','Get_Signature_Notfn_Body',l_progress);

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
545: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(l_item_type, l_item_key);

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 547: WF_CORE.context('PO_SIGNATURE_PVT','Get_Signature_Notfn_Body',l_progress);

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:
551: END GET_SIGNATURE_NOTFN_BODY;

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 620: l_progress := 'PO_SIGNATURE_PVT.Create_Erecord: 01';

616: l_signer VARCHAR2(20);
617: l_erecords_exception EXCEPTION;
618: BEGIN
619: IF (g_po_wf_debug = 'Y') THEN
620: l_progress := 'PO_SIGNATURE_PVT.Create_Erecord: 01';
621: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
622: END IF;
623:
624: -- Do nothing in cancel or timeout mode

Line 792: l_progress := 'PO_SIGNATURE_PVT.Create_Erecord: 02';

788: l_sig_parameters(3).Param_Value := l_signer_type;
789: l_sig_parameters(3).Param_displayname := '';
790:
791: IF (g_po_wf_debug = 'Y') THEN
792: l_progress := 'PO_SIGNATURE_PVT.Create_Erecord: 02';
793: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
794: END IF;
795:
796: -- Calling capture_signature API to store the eRecord

Line 848: l_progress := 'PO_SIGNATURE_PVT.Create_Erecord: 03';

844: p_ackn_note => l_acceptance_note,
845: p_autonomous_commit => FND_API.G_FALSE);
846:
847: IF (g_po_wf_debug = 'Y') THEN
848: l_progress := 'PO_SIGNATURE_PVT.Create_Erecord: 03';
849: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
850: END IF;
851:
852: IF l_return_status <> 'S' THEN

Line 869: 'End erecords_exception:PO_SIGNATURE_PVT.CREATE_ERECORD ');

865: EXCEPTION
866: WHEN l_erecords_exception then
867: IF (g_po_wf_debug = 'Y') THEN
868: PO_WF_DEBUG_PKG.INSERT_DEBUG(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);

Line 875: wf_core.context('PO_SIGNATURE_PVT', 'Create_Erecord', 'l_erecords_exception');

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');
879: RAISE;

Line 878: l_doc_string, l_msg_data,'PO_SIGNATURE_PVT.Create_Erecord');

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:
882: -------------------------------------------------------------------------------

Line 967: l_progress := 'PO_SIGNATURE_PVT.Post_Signature: 01';

963: l_vendor_signed_date po_acceptances.vendor_signed_date%TYPE := NULL;
964: BEGIN
965:
966: IF (g_po_wf_debug = 'Y') THEN
967: l_progress := 'PO_SIGNATURE_PVT.Post_Signature: 01';
968: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
969: END IF;
970: IF (g_po_wf_debug = 'Y') THEN
971: l_progress := 'PO_SIGNATURE_PVT.Post_Signature: l_vendor_contact_name = '||l_vendor_contact_name||

Line 971: l_progress := 'PO_SIGNATURE_PVT.Post_Signature: l_vendor_contact_name = '||l_vendor_contact_name||

967: l_progress := 'PO_SIGNATURE_PVT.Post_Signature: 01';
968: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
969: END IF;
970: IF (g_po_wf_debug = 'Y') THEN
971: l_progress := 'PO_SIGNATURE_PVT.Post_Signature: l_vendor_contact_name = '||l_vendor_contact_name||
972: ' l_vendor_contact_title = '||l_vendor_contact_title||
973: ' l_vendor_signed_date = '||l_vendor_signed_date||'funcmode: '||funcmode ;
974: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
975: END IF;

Line 1101: l_progress := 'PO_SIGNATURE_PVT.Post_Signature: l_response = '||l_response;

1097: l_accepted_flag := 'N';
1098: END IF;
1099:
1100: IF (g_po_wf_debug = 'Y') THEN
1101: l_progress := 'PO_SIGNATURE_PVT.Post_Signature: l_response = '||l_response;
1102: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1103: END IF;
1104: l_revision_num := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
1105: itemkey => itemkey,

Line 1172: l_progress := 'PO_SIGNATURE_PVT.Post_Signature: 02'||'Before calling Acceptance rowhandler';

1168:
1169: -- Bug 4417522: Removed this profile option
1170: -- Get the Profile value for the PO: Auto-approve PO after buyer's eSignature
1171: IF (g_po_wf_debug = 'Y') THEN
1172: l_progress := 'PO_SIGNATURE_PVT.Post_Signature: 02'||'Before calling Acceptance rowhandler';
1173: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1174: END IF;
1175:
1176: BEGIN

Line 1193: l_progress := 'PO_SIGNATURE_PVT.Post_Signature: before call to POS_ACK_PO';

1189: -- Default Promised date with Need-by-Date only when the profile option is set
1190: IF( g_default_promise_date = 'Y') THEN
1191: IF(l_supplier_response = 'ACCEPTED' AND l_buyer_response = 'ACCEPTED') THEN
1192: IF (g_po_wf_debug = 'Y') THEN
1193: l_progress := 'PO_SIGNATURE_PVT.Post_Signature: before call to POS_ACK_PO';
1194: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1195: END IF;
1196: POS_ACK_PO.Acknowledge_promise_date(null,l_document_id,null,l_revision_num,l_user_id);
1197: END IF;

Line 1200: l_progress := 'PO_SIGNATURE_PVT.Post_Signature: before call to PO_ACCEPTANCES_INS_PVT.insert_row';

1196: POS_ACK_PO.Acknowledge_promise_date(null,l_document_id,null,l_revision_num,l_user_id);
1197: END IF;
1198: END IF;
1199: IF (g_po_wf_debug = 'Y') THEN
1200: l_progress := 'PO_SIGNATURE_PVT.Post_Signature: before call to PO_ACCEPTANCES_INS_PVT.insert_row';
1201: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1202: END IF;
1203: -- CLM Apprvl...added the parameter p_draft_id
1204: /* In case of proxy signature mode the supplier contact name, title and signed date must be recorded in po_acceptances */

Line 1329: l_progress := 'PO_SIGNATURE_PVT.Post_Signature: 03'||'Updated PO tables';

1325: p_status => 'N',
1326: x_result => l_result);
1327: end if;
1328: IF (g_po_wf_debug = 'Y') THEN
1329: l_progress := 'PO_SIGNATURE_PVT.Post_Signature: 03'||'Updated PO tables';
1330: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1331: END IF;
1332:
1333: END IF;

Line 1347: 'End contracts_call_exception:PO_SIGNATURE_PVT.POST_SIGNATURE ');

1343: -- Handle contract Exceptions and re raise
1344: WHEN l_contracts_call_exception then
1345: IF (g_po_wf_debug = 'Y') THEN
1346: PO_WF_DEBUG_PKG.INSERT_DEBUG(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);

Line 1353: wf_core.context('PO_SIGNATURE_PVT', 'Post_Signature', 'l_contracts_call_Exception');

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');
1357: RAISE;

Line 1356: l_doc_string, l_msg_data,'PO_SIGNATURE_PVT.Post_Signature');

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
1360: IF (g_po_wf_debug = 'Y') THEN

Line 1362: 'End binding_exception:PO_SIGNATURE_PVT.POST_SIGNATURE ');

1358: --
1359: WHEN l_binding_exception then
1360: IF (g_po_wf_debug = 'Y') THEN
1361: PO_WF_DEBUG_PKG.INSERT_DEBUG(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);

Line 1368: wf_core.context('PO_SIGNATURE_PVT', 'Post_Signature', 'l_binding_exception');

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');
1372: RAISE;

Line 1371: l_doc_string, l_msg_data,'PO_SIGNATURE_PVT.Post_Signature');

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

Line 1377: WF_CORE.context('PO_SIGNATURE_PVT','Post_Signature',l_progress);

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;
1381:

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 1428: l_progress := 'PO_SIGNATURE_PVT.set_accepted_supplier_response: 01';

1424: l_po_itemkey PO_HEADERS_ALL.wf_item_key%TYPE;
1425: BEGIN
1426:
1427: IF (g_po_wf_debug = 'Y') THEN
1428: l_progress := 'PO_SIGNATURE_PVT.set_accepted_supplier_response: 01';
1429: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1430: END IF;
1431:
1432: -- Do nothing in cancel or timeout mode

Line 1480: 'PLSQLCLOB:PO_SIGNATURE_PVT.get_signature_notfn_body/'|| l_document_id ||':'||itemtype||':'||itemkey);

1476: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,
1477: itemkey => itemkey,
1478: aname => 'PO_BUY_SIGNATURE_MSG_BODY',
1479: avalue =>
1480: 'PLSQLCLOB:PO_SIGNATURE_PVT.get_signature_notfn_body/'|| l_document_id ||':'||itemtype||':'||itemkey);
1481:
1482: IF (g_po_wf_debug = 'Y') THEN
1483: l_progress := 'PO_SIGNATURE_PVT.set_accepted_supplier_response: 02';
1484: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

Line 1483: l_progress := 'PO_SIGNATURE_PVT.set_accepted_supplier_response: 02';

1479: avalue =>
1480: 'PLSQLCLOB:PO_SIGNATURE_PVT.get_signature_notfn_body/'|| l_document_id ||':'||itemtype||':'||itemkey);
1481:
1482: IF (g_po_wf_debug = 'Y') THEN
1483: l_progress := 'PO_SIGNATURE_PVT.set_accepted_supplier_response: 02';
1484: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1485: END IF;
1486:
1487: -- PO AME Project : Changes made for Multiple E-signatures

Line 1496: l_progress := 'PO_SIGNATURE_PVT.set_accepted_supplier_response: 03';

1492:
1493: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype, itemkey => l_po_itemkey, aname => 'SUPPLIER_RESPONSE', avalue => 'ACCEPTED');
1494:
1495: IF (g_po_wf_debug = 'Y') THEN
1496: l_progress := 'PO_SIGNATURE_PVT.set_accepted_supplier_response: 03';
1497: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1498: END IF;
1499:
1500: EXCEPTION

Line 1504: WF_CORE.context('PO_SIGNATURE_PVT','set_accepted_supplier_response',l_progress);

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;
1508:

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 1556: l_progress := 'PO_SIGNATURE_PVT.set_rejected_supplier_response: 01';

1552:
1553: BEGIN
1554:
1555: IF (g_po_wf_debug = 'Y') THEN
1556: l_progress := 'PO_SIGNATURE_PVT.set_rejected_supplier_response: 01';
1557: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1558: END IF;
1559:
1560: -- Do nothing in cancel or timeout mode

Line 1608: 'PLSQLCLOB:PO_SIGNATURE_PVT.get_buyer_info_notfn_body/'|| l_document_id ||':'||itemtype||':'||itemkey);

1604: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,
1605: itemkey => itemkey,
1606: aname => 'PO_BUY_INFO_MSG_BODY',
1607: avalue =>
1608: 'PLSQLCLOB:PO_SIGNATURE_PVT.get_buyer_info_notfn_body/'|| l_document_id ||':'||itemtype||':'||itemkey);
1609:
1610: IF (g_po_wf_debug = 'Y') THEN
1611: l_progress := 'PO_SIGNATURE_PVT.set_rejected_supplier_response: 02';
1612: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

Line 1611: l_progress := 'PO_SIGNATURE_PVT.set_rejected_supplier_response: 02';

1607: avalue =>
1608: 'PLSQLCLOB:PO_SIGNATURE_PVT.get_buyer_info_notfn_body/'|| l_document_id ||':'||itemtype||':'||itemkey);
1609:
1610: IF (g_po_wf_debug = 'Y') THEN
1611: l_progress := 'PO_SIGNATURE_PVT.set_rejected_supplier_response: 02';
1612: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1613: END IF;
1614: -- PO AME Project : Changes made for Multiple E-signatures
1615: SELECT wf_item_key

Line 1623: l_progress := 'PO_SIGNATURE_PVT.set_rejected_supplier_response: 03';

1619:
1620: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype, itemkey => l_po_itemkey, aname => 'SUPPLIER_RESPONSE', avalue => 'REJECTED');
1621:
1622: IF (g_po_wf_debug = 'Y') THEN
1623: l_progress := 'PO_SIGNATURE_PVT.set_rejected_supplier_response: 03';
1624: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1625: END IF;
1626: EXCEPTION
1627: WHEN OTHERS THEN

Line 1630: WF_CORE.context('PO_SIGNATURE_PVT','set_rejected_supplier_response',l_progress);

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;
1634:

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 1707: l_progress := 'PO_SIGNATURE_PVT.get_buyer_info_notfn_body: 01';

1703: l_item_type := substr(document_id, l_firstcolon + 1, l_secondcolon - l_firstcolon - 1);
1704: l_item_key := substr(document_id, l_secondcolon+1,length(document_id) - l_secondcolon);
1705:
1706: IF (g_po_wf_debug = 'Y') THEN
1707: l_progress := 'PO_SIGNATURE_PVT.get_buyer_info_notfn_body: 01';
1708: PO_WF_DEBUG_PKG.insert_debug(l_item_type,l_item_key,l_progress);
1709: END IF;
1710:
1711: l_buyer_name := PO_WF_UTIL_PKG.GetItemAttrText(

Line 1857: l_progress := 'PO_SIGNATURE_PVT.get_buyer_info_notfn_body: 02';

1853:
1854: l_msgbody := l_msgbody || '';
1855:
1856: IF (g_po_wf_debug = 'Y') THEN
1857: l_progress := 'PO_SIGNATURE_PVT.get_buyer_info_notfn_body: 02';
1858: PO_WF_DEBUG_PKG.insert_debug(l_item_type,l_item_key,l_progress);
1859: END IF;
1860:
1861: WF_NOTIFICATION.WriteToClob(document, l_msgbody);

Line 1864: l_progress := 'PO_SIGNATURE_PVT.get_buyer_info_notfn_body: 03';

1860:
1861: WF_NOTIFICATION.WriteToClob(document, l_msgbody);
1862:
1863: IF (g_po_wf_debug = 'Y') THEN
1864: l_progress := 'PO_SIGNATURE_PVT.get_buyer_info_notfn_body: 03';
1865: PO_WF_DEBUG_PKG.insert_debug(l_item_type,l_item_key,l_progress);
1866: END IF;
1867:
1868: EXCEPTION

Line 1872: WF_CORE.context('PO_SIGNATURE_PVT','get_buyer_info_notfn_body',l_progress);

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
1876: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(l_item_type, l_item_key);

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 1878: WF_CORE.context('PO_SIGNATURE_PVT','get_buyer_info_notfn_body',l_progress);

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;
1882:

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 1929: l_progress := 'PO_SIGNATURE_PVT.set_accepted_buyer_response: 01';

1925:
1926: BEGIN
1927:
1928: IF (g_po_wf_debug = 'Y') THEN
1929: l_progress := 'PO_SIGNATURE_PVT.set_accepted_buyer_response: 01';
1930: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1931: END IF;
1932:
1933: -- Do nothing in cancel or timeout mode

Line 1982: 'PLSQLCLOB:PO_SIGNATURE_PVT.get_supplier_info_notfn_body/'|| l_document_id ||':'||itemtype||':'||itemkey);

1978: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,
1979: itemkey => itemkey,
1980: aname => 'PO_SUP_INFO_MSG_BODY',
1981: avalue =>
1982: 'PLSQLCLOB:PO_SIGNATURE_PVT.get_supplier_info_notfn_body/'|| l_document_id ||':'||itemtype||':'||itemkey);
1983:
1984: IF (g_po_wf_debug = 'Y') THEN
1985: l_progress := 'PO_SIGNATURE_PVT.set_accepted_buyer_response: 02';
1986: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

Line 1985: l_progress := 'PO_SIGNATURE_PVT.set_accepted_buyer_response: 02';

1981: avalue =>
1982: 'PLSQLCLOB:PO_SIGNATURE_PVT.get_supplier_info_notfn_body/'|| l_document_id ||':'||itemtype||':'||itemkey);
1983:
1984: IF (g_po_wf_debug = 'Y') THEN
1985: l_progress := 'PO_SIGNATURE_PVT.set_accepted_buyer_response: 02';
1986: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1987: END IF;
1988:
1989: EXCEPTION

Line 1993: WF_CORE.context('PO_SIGNATURE_PVT','set_accepted_buyer_response',l_progress);

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;
1997:

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 2068: l_progress := 'PO_SIGNATURE_PVT.get_supplier_info_notfn_body: 01';

2064: l_item_type := substr(document_id, l_firstcolon + 1, l_secondcolon - l_firstcolon - 1);
2065: l_item_key := substr(document_id, l_secondcolon+1,length(document_id) - l_secondcolon);
2066:
2067: IF (g_po_wf_debug = 'Y') THEN
2068: l_progress := 'PO_SIGNATURE_PVT.get_supplier_info_notfn_body: 01';
2069: PO_WF_DEBUG_PKG.insert_debug(l_item_type,l_item_key,l_progress);
2070: END IF;
2071:
2072: l_buyer_name := PO_WF_UTIL_PKG.GetItemAttrText(

Line 2211: l_progress := 'PO_SIGNATURE_PVT.get_supplier_info_notfn_body: 02';

2207:
2208: l_msgbody := l_msgbody || '';
2209:
2210: IF (g_po_wf_debug = 'Y') THEN
2211: l_progress := 'PO_SIGNATURE_PVT.get_supplier_info_notfn_body: 02';
2212: PO_WF_DEBUG_PKG.insert_debug(l_item_type,l_item_key,l_progress);
2213: END IF;
2214:
2215: WF_NOTIFICATION.WriteToClob(document, l_msgbody);

Line 2218: l_progress := 'PO_SIGNATURE_PVT.get_supplier_info_notfn_body: 03';

2214:
2215: WF_NOTIFICATION.WriteToClob(document, l_msgbody);
2216:
2217: IF (g_po_wf_debug = 'Y') THEN
2218: l_progress := 'PO_SIGNATURE_PVT.get_supplier_info_notfn_body: 03';
2219: PO_WF_DEBUG_PKG.insert_debug(l_item_type,l_item_key,l_progress);
2220: END IF;
2221:
2222: EXCEPTION

Line 2226: WF_CORE.context('PO_SIGNATURE_PVT','get_supplier_info_notfn_body',l_progress);

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
2230: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(l_item_type, l_item_key);

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 2232: WF_CORE.context('PO_SIGNATURE_PVT','get_supplier_info_notfn_body',l_progress);

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:
2236: END GET_SUPPLIER_INFO_NOTFN_BODY;

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 2284: l_progress := 'PO_SIGNATURE_PVT.set_rejected_buyer_response: 01';

2280:
2281: BEGIN
2282:
2283: IF (g_po_wf_debug = 'Y') THEN
2284: l_progress := 'PO_SIGNATURE_PVT.set_rejected_buyer_response: 01';
2285: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2286: END IF;
2287:
2288: -- Do nothing in cancel or timeout mode

Line 2337: 'PLSQLCLOB:PO_SIGNATURE_PVT.get_supplier_info_notfn_body/'|| l_document_id ||':'||itemtype||':'||itemkey);

2333: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,
2334: itemkey => itemkey,
2335: aname => 'PO_SUP_INFO_MSG_BODY',
2336: avalue =>
2337: 'PLSQLCLOB:PO_SIGNATURE_PVT.get_supplier_info_notfn_body/'|| l_document_id ||':'||itemtype||':'||itemkey);
2338:
2339:
2340: EXCEPTION
2341: WHEN OTHERS THEN

Line 2344: WF_CORE.context('PO_SIGNATURE_PVT','set_rejected_buyer_response',l_progress);

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;
2348:

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 2395: l_progress := 'PO_SIGNATURE_PVT.Is_Signature_Required: 01';

2391:
2392: BEGIN
2393:
2394: IF (g_po_wf_debug = 'Y') THEN
2395: l_progress := 'PO_SIGNATURE_PVT.Is_Signature_Required: 01';
2396: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2397: END IF;
2398:
2399: -- Do nothing in cancel or timeout mode

Line 2420: l_progress := 'PO_SIGNATURE_PVT.Is_Signature_Required: 02. Result= ' || l_req_signature;

2416:
2417: resultout := WF_ENGINE.eng_completed || ':' || l_req_signature;
2418:
2419: IF (g_po_wf_debug = 'Y') THEN
2420: l_progress := 'PO_SIGNATURE_PVT.Is_Signature_Required: 02. Result= ' || l_req_signature;
2421: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2422: END IF;
2423:
2424: EXCEPTION

Line 2428: WF_CORE.context('PO_SIGNATURE_PVT','is_signature_required',l_progress);

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;
2432:

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 2665: WF_CORE.context('PO_SIGNATURE_PVT','set_supplier_notification_id',l_progress);

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;
2669:

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 2728: l_progress := 'PO_SIGNATURE_PVT.Set_Buyer_Notification_Id, funcmode: '||funcmode;

2724: --Bug11068447 - when the notification is transferred
2725: ELSIF (funcmode = 'TRANSFER') THEN
2726:
2727: IF (g_po_wf_debug = 'Y') THEN
2728: l_progress := 'PO_SIGNATURE_PVT.Set_Buyer_Notification_Id, funcmode: '||funcmode;
2729: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2730: END IF;
2731:
2732: PO_WF_UTIL_PKG.SetItemAttrText(

Line 2777: WF_CORE.context('PO_SIGNATURE_PVT','set_buyer_notification_id',l_progress);

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;
2781:

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 2840: l_progress := 'PO_SIGNATURE_PVT.Set_KO_Notification_Id, funcmode: '||funcmode;

2836: --Bug11068447 - when the notification is transferred
2837: ELSIF (funcmode = 'TRANSFER') THEN
2838:
2839: IF (g_po_wf_debug = 'Y') THEN
2840: l_progress := 'PO_SIGNATURE_PVT.Set_KO_Notification_Id, funcmode: '||funcmode;
2841: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2842: END IF;
2843:
2844: PO_WF_UTIL_PKG.SetItemAttrText(

Line 2889: WF_CORE.context('PO_SIGNATURE_PVT','set_KO_notification_id',l_progress);

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;
2893: --

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 2945: d_module CONSTANT VARCHAR2(70) := 'po.plsql.PO_SIGNATURE_PVT.UPDATE_PO_DETAILS';

2941: l_ret_sts VARCHAR2(1); --bug 13507482
2942: l_supply_action VARCHAR2(40); --bug 13507482
2943: l_bool_ret_sts BOOLEAN; --bug 13507482
2944: l_err_msg VARCHAR2(200); --bug 13507482
2945: d_module CONSTANT VARCHAR2(70) := 'po.plsql.PO_SIGNATURE_PVT.UPDATE_PO_DETAILS';
2946: d_pos NUMBER := 0;
2947:
2948: BEGIN
2949: IF (PO_LOG.d_proc) THEN

Line 4139: d_module CONSTANT VARCHAR2(70) := 'po.plsql.PO_SIGNATURE_PVT.if_was_sign_reqd_set_acc_flag';

4135: PROCEDURE if_was_sign_reqd_set_acc_flag(p_document_id IN NUMBER,
4136: x_if_acc_flag_updated OUT NOCOPY VARCHAR2)
4137: IS
4138: l_was_sign_reqd boolean := FALSE;
4139: d_module CONSTANT VARCHAR2(70) := 'po.plsql.PO_SIGNATURE_PVT.if_was_sign_reqd_set_acc_flag';
4140: d_pos NUMBER := 0;
4141: BEGIN
4142: IF (PO_LOG.d_proc) THEN
4143: PO_LOG.proc_begin(d_module,'p_document_id',p_document_id);

Line 4204: d_module CONSTANT VARCHAR2(70) := 'po.plsql.PO_SIGNATURE_PVT.if_rev_and_signed_set_acc_flag';

4200: p_document_id IN NUMBER,
4201: p_old_revision_num IN NUMBER,
4202: x_if_acc_flag_updated OUT NOCOPY VARCHAR2)
4203: IS
4204: d_module CONSTANT VARCHAR2(70) := 'po.plsql.PO_SIGNATURE_PVT.if_rev_and_signed_set_acc_flag';
4205: d_pos NUMBER := 0;
4206: l_revision_num PO_HEADERS_ALL.revision_num%TYPE;
4207: BEGIN
4208: SELECT revision_num

Line 4278: l_progress := 'PO_SIGNATURE_PVT.Has_Doc_Been_Signed: 01';

4274:
4275: BEGIN
4276:
4277: IF (g_po_wf_debug = 'Y') THEN
4278: l_progress := 'PO_SIGNATURE_PVT.Has_Doc_Been_Signed: 01';
4279: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
4280: END IF;
4281:
4282: -- Do nothing in cancel or timeout mode

Line 4312: l_progress := 'PO_SIGNATURE_PVT.Has_Doc_Been_Signed: 02. l_document_type: ' || l_document_type||', l_document_id: '||l_document_id||', l_draft_id: '||l_draft_id;

4308: );
4309:
4310:
4311: IF (g_po_wf_debug = 'Y') THEN
4312: l_progress := 'PO_SIGNATURE_PVT.Has_Doc_Been_Signed: 02. l_document_type: ' || l_document_type||', l_document_id: '||l_document_id||', l_draft_id: '||l_draft_id;
4313: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
4314: END IF;
4315:
4316:

Line 4349: l_progress := 'PO_SIGNATURE_PVT.Has_Doc_Been_Signed: 03. Result= ' || l_is_doc_signed;

4345:
4346: resultout := WF_ENGINE.eng_completed || ':' || l_is_doc_signed ;
4347:
4348: IF (g_po_wf_debug = 'Y') THEN
4349: l_progress := 'PO_SIGNATURE_PVT.Has_Doc_Been_Signed: 03. Result= ' || l_is_doc_signed;
4350: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
4351: END IF;
4352:
4353:

Line 4358: WF_CORE.context('PO_SIGNATURE_PVT','Has_Doc_Been_Signed',l_progress);

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;
4362:

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 4540: l_progress := 'PO_SIGNATURE_PVT.is_ko_signature_required: 01';

4536:
4537: BEGIN
4538:
4539: IF (g_po_wf_debug = 'Y') THEN
4540: l_progress := 'PO_SIGNATURE_PVT.is_ko_signature_required: 01';
4541: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
4542: END IF;
4543:
4544: -- Do nothing in cancel or timeout mode

Line 4642: l_progress := 'PO_SIGNATURE_PVT.set_accepted_ko_response: 01';

4638:
4639: BEGIN
4640:
4641: IF (g_po_wf_debug = 'Y') THEN
4642: l_progress := 'PO_SIGNATURE_PVT.set_accepted_ko_response: 01';
4643: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
4644: END IF;
4645:
4646: -- Do nothing in cancel or timeout mode

Line 4688: l_progress := 'PO_SIGNATURE_PVT.set_accepted_ko_response: l_return_status: '||l_return_status;

4684: , p_sequence => l_sequence
4685: , x_return_status => l_return_status
4686: );
4687: IF (g_po_wf_debug = 'Y') THEN
4688: l_progress := 'PO_SIGNATURE_PVT.set_accepted_ko_response: l_return_status: '||l_return_status;
4689: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
4690: END IF;
4691:
4692: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

Line 4732: 'PLSQLCLOB:PO_SIGNATURE_PVT.get_supplier_info_notfn_body/'|| l_document_id ||':'||itemtype||':'||itemkey);

4728: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,
4729: itemkey => itemkey,
4730: aname => 'PO_SUP_INFO_MSG_BODY',
4731: avalue =>
4732: 'PLSQLCLOB:PO_SIGNATURE_PVT.get_supplier_info_notfn_body/'|| l_document_id ||':'||itemtype||':'||itemkey);
4733:
4734: resultout := WF_ENGINE.eng_completed || ':' || 'VALID_ACTION' ;
4735: ELSE
4736: resultout := WF_ENGINE.eng_completed || ':' || 'INVALID_ACTION' ;

Line 4740: l_progress := 'PO_SIGNATURE_PVT.set_accepted_ko_response: 02';

4736: resultout := WF_ENGINE.eng_completed || ':' || 'INVALID_ACTION' ;
4737: END IF;
4738:
4739: IF (g_po_wf_debug = 'Y') THEN
4740: l_progress := 'PO_SIGNATURE_PVT.set_accepted_ko_response: 02';
4741: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
4742: END IF;
4743:
4744: EXCEPTION

Line 4748: WF_CORE.context('PO_SIGNATURE_PVT','set_accepted_ko_response',l_progress);

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;
4752:

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 4799: l_progress := 'PO_SIGNATURE_PVT.set_rejected_ko_response: 01';

4795:
4796: BEGIN
4797:
4798: IF (g_po_wf_debug = 'Y') THEN
4799: l_progress := 'PO_SIGNATURE_PVT.set_rejected_ko_response: 01';
4800: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
4801: END IF;
4802:
4803: -- Do nothing in cancel or timeout mode

Line 4852: 'PLSQLCLOB:PO_SIGNATURE_PVT.get_supplier_info_notfn_body/'|| l_document_id ||':'||itemtype||':'||itemkey);

4848: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,
4849: itemkey => itemkey,
4850: aname => 'PO_SUP_INFO_MSG_BODY',
4851: avalue =>
4852: 'PLSQLCLOB:PO_SIGNATURE_PVT.get_supplier_info_notfn_body/'|| l_document_id ||':'||itemtype||':'||itemkey);
4853:
4854:
4855: EXCEPTION
4856: WHEN OTHERS THEN

Line 4859: WF_CORE.context('PO_SIGNATURE_PVT','set_rejected_ko_response',l_progress);

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;
4863: -------------------------------------------------------------------------------

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

Line 4914: l_progress := 'PO_SIGNATURE_PVT.Check_Warrant_for_KO: 01';

4910: BEGIN
4911:
4912:
4913: IF (g_po_wf_debug = 'Y') THEN
4914: l_progress := 'PO_SIGNATURE_PVT.Check_Warrant_for_KO: 01';
4915: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
4916: END IF;
4917:
4918: -- Do nothing in cancel or timeout mode

Line 5000: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'PO_SIGNATURE_PVT.Check_Warrant_for_KO: l_return_status: '||l_return_status);

4996: , x_return_status => l_return_status
4997: );
4998: IF (g_po_wf_debug = 'Y') THEN
4999:
5000: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'PO_SIGNATURE_PVT.Check_Warrant_for_KO: l_return_status: '||l_return_status);
5001: END IF;
5002:
5003: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5004: l_warning := 'WARNING: PLEASE NOTE THAT THE CONTRACTING OFFICER DOES NOT HAVE SUFFICIENT WARRANT TO ACCEPT THE DOCUMENT. PLEASE FORWARD THE

Line 5048: END PO_SIGNATURE_PVT;

5044: RAISE;
5045: END;
5046:
5047:
5048: END PO_SIGNATURE_PVT;