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.10.12010000.2 2008/11/14 03:01:58 vchiran 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 104: l_progress := 'PO_SIGNATURE_PVT.Set_Startup_Values: 01';

100: l_sign_attachments_value VARCHAR2(300);
101: BEGIN
102:
103: IF (g_po_wf_debug = 'Y') THEN
104: l_progress := 'PO_SIGNATURE_PVT.Set_Startup_Values: 01';
105: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
106: END IF;
107:
108: -- Set the multi-org context

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

242: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,
243: itemkey => itemkey,
244: aname => 'PO_SUP_SIGNATURE_MSG_BODY',
245: avalue =>
246: 'PLSQLCLOB:PO_SIGNATURE_PVT.get_signature_notfn_body /'|| l_document_id ||':'||itemtype||':'||itemkey);
247:
248: EXCEPTION
249: WHEN l_binding_exception then
250: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemtype, itemkey);

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

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

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

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

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

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

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

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

Line 330: l_progress := 'PO_SIGNATURE_PVT.get_signature_notfn_body: 01';

326: l_item_type := substr(document_id, l_firstcolon + 1, l_secondcolon - l_firstcolon - 1);
327: l_item_key := substr(document_id, l_secondcolon+1,length(document_id) - l_secondcolon);
328:
329: IF (g_po_wf_debug = 'Y') THEN
330: l_progress := 'PO_SIGNATURE_PVT.get_signature_notfn_body: 01';
331: PO_WF_DEBUG_PKG.insert_debug(l_item_type,l_item_key,l_progress);
332: END IF;
333:
334: l_buyer_name := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => l_item_type,

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

435:
436: l_msgbody := l_msgbody || '';
437:
438: IF (g_po_wf_debug = 'Y') THEN
439: l_progress := 'PO_SIGNATURE_PVT.get_signature_notfn_body: 02';
440: PO_WF_DEBUG_PKG.insert_debug(l_item_type,l_item_key,l_progress);
441: END IF;
442:
443: WF_NOTIFICATION.WriteToClob(document, l_msgbody);

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

442:
443: WF_NOTIFICATION.WriteToClob(document, l_msgbody);
444:
445: IF (g_po_wf_debug = 'Y') THEN
446: l_progress := 'PO_SIGNATURE_PVT.get_signature_notfn_body: 03';
447: PO_WF_DEBUG_PKG.insert_debug(l_item_type,l_item_key,l_progress);
448: END IF;
449:
450: EXCEPTION

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

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

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

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

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

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

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

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

Line 532: l_progress := 'PO_SIGNATURE_PVT.Create_Erecord: 01';

528: l_signer VARCHAR2(10);
529: l_erecords_exception EXCEPTION;
530: BEGIN
531: IF (g_po_wf_debug = 'Y') THEN
532: l_progress := 'PO_SIGNATURE_PVT.Create_Erecord: 01';
533: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
534: END IF;
535:
536: l_po_header_id := PO_WF_UTIL_PKG.GetItemAttrNumber(itemtype => itemtype,

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

660: l_sig_parameters(3).Param_Value := l_signer_type;
661: l_sig_parameters(3).Param_displayname := '';
662:
663: IF (g_po_wf_debug = 'Y') THEN
664: l_progress := 'PO_SIGNATURE_PVT.Create_Erecord: 02';
665: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
666: END IF;
667:
668: -- Calling capture_signature API to store the eRecord

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

716: p_ackn_note => l_acceptance_note,
717: p_autonomous_commit => FND_API.G_FALSE);
718:
719: IF (g_po_wf_debug = 'Y') THEN
720: l_progress := 'PO_SIGNATURE_PVT.Create_Erecord: 03';
721: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
722: END IF;
723:
724: IF l_return_status <> 'S' THEN

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

737: EXCEPTION
738: WHEN l_erecords_exception then
739: IF (g_po_wf_debug = 'Y') THEN
740: PO_WF_DEBUG_PKG.INSERT_DEBUG(itemtype, itemkey,
741: 'End erecords_exception:PO_SIGNATURE_PVT.CREATE_ERECORD ');
742: PO_WF_DEBUG_PKG.INSERT_DEBUG(itemtype, itemkey,
743: 'ERROR RETURNED '||l_msg_data);
744: END IF;
745: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemtype, itemkey);

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

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

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

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

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

827: --
828: BEGIN
829:
830: IF (g_po_wf_debug = 'Y') THEN
831: l_progress := 'PO_SIGNATURE_PVT.Post_Signature: 01';
832: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
833: END IF;
834:
835: l_acceptance_note := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

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

919:
920: -- Bug 4417522: Removed this profile option
921: -- Get the Profile value for the PO: Auto-approve PO after buyer's eSignature
922: IF (g_po_wf_debug = 'Y') THEN
923: l_progress := 'PO_SIGNATURE_PVT.Post_Signature: 02'||'Before calling Acceptance rowhandler';
924: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
925: END IF;
926:
927: BEGIN

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

1021: Complete_Block_Activities(p_itemkey => itemkey,
1022: p_status => 'Y',
1023: x_result => l_result);
1024: IF (g_po_wf_debug = 'Y') THEN
1025: l_progress := 'PO_SIGNATURE_PVT.Post_Signature: 03'||'Updated PO tables';
1026: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1027: END IF;
1028:
1029: END IF;

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

1039: -- Handle contract Exceptions and re raise
1040: WHEN l_contracts_call_exception then
1041: IF (g_po_wf_debug = 'Y') THEN
1042: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1043: 'End contracts_call_exception:PO_SIGNATURE_PVT.POST_SIGNATURE ');
1044: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1045: 'ERROR RETURNED '||l_msg_data);
1046: END IF;
1047: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);

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

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

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

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

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

1054: --
1055: WHEN l_binding_exception then
1056: IF (g_po_wf_debug = 'Y') THEN
1057: PO_WF_DEBUG_PKG.INSERT_DEBUG(itemtype, itemkey,
1058: 'End binding_exception:PO_SIGNATURE_PVT.POST_SIGNATURE ');
1059: PO_WF_DEBUG_PKG.INSERT_DEBUG(itemtype, itemkey,
1060: 'ERROR RETURNED '||l_msg_data);
1061: END IF;
1062: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemtype, itemkey);

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

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

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

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

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

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

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

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

Line 1124: l_progress := 'PO_SIGNATURE_PVT.set_accepted_supplier_response: 01';

1120:
1121: BEGIN
1122:
1123: IF (g_po_wf_debug = 'Y') THEN
1124: l_progress := 'PO_SIGNATURE_PVT.set_accepted_supplier_response: 01';
1125: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1126: END IF;
1127:
1128: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber(

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

1165: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,
1166: itemkey => itemkey,
1167: aname => 'PO_BUY_SIGNATURE_MSG_BODY',
1168: avalue =>
1169: 'PLSQLCLOB:PO_SIGNATURE_PVT.get_signature_notfn_body/'|| l_document_id ||':'||itemtype||':'||itemkey);
1170:
1171: IF (g_po_wf_debug = 'Y') THEN
1172: l_progress := 'PO_SIGNATURE_PVT.set_accepted_supplier_response: 02';
1173: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

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

1168: avalue =>
1169: 'PLSQLCLOB:PO_SIGNATURE_PVT.get_signature_notfn_body/'|| l_document_id ||':'||itemtype||':'||itemkey);
1170:
1171: IF (g_po_wf_debug = 'Y') THEN
1172: l_progress := 'PO_SIGNATURE_PVT.set_accepted_supplier_response: 02';
1173: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1174: END IF;
1175:
1176: EXCEPTION

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

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

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

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

Line 1231: l_progress := 'PO_SIGNATURE_PVT.set_rejected_supplier_response: 01';

1227:
1228: BEGIN
1229:
1230: IF (g_po_wf_debug = 'Y') THEN
1231: l_progress := 'PO_SIGNATURE_PVT.set_rejected_supplier_response: 01';
1232: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1233: END IF;
1234:
1235: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber(

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

1272: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,
1273: itemkey => itemkey,
1274: aname => 'PO_BUY_INFO_MSG_BODY',
1275: avalue =>
1276: 'PLSQLCLOB:PO_SIGNATURE_PVT.get_buyer_info_notfn_body/'|| l_document_id ||':'||itemtype||':'||itemkey);
1277:
1278: IF (g_po_wf_debug = 'Y') THEN
1279: l_progress := 'PO_SIGNATURE_PVT.set_rejected_supplier_response: 02';
1280: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

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

1275: avalue =>
1276: 'PLSQLCLOB:PO_SIGNATURE_PVT.get_buyer_info_notfn_body/'|| l_document_id ||':'||itemtype||':'||itemkey);
1277:
1278: IF (g_po_wf_debug = 'Y') THEN
1279: l_progress := 'PO_SIGNATURE_PVT.set_rejected_supplier_response: 02';
1280: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1281: END IF;
1282:
1283: EXCEPTION

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

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

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

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

Line 1364: l_progress := 'PO_SIGNATURE_PVT.get_buyer_info_notfn_body: 01';

1360: l_item_type := substr(document_id, l_firstcolon + 1, l_secondcolon - l_firstcolon - 1);
1361: l_item_key := substr(document_id, l_secondcolon+1,length(document_id) - l_secondcolon);
1362:
1363: IF (g_po_wf_debug = 'Y') THEN
1364: l_progress := 'PO_SIGNATURE_PVT.get_buyer_info_notfn_body: 01';
1365: PO_WF_DEBUG_PKG.insert_debug(l_item_type,l_item_key,l_progress);
1366: END IF;
1367:
1368: l_buyer_name := PO_WF_UTIL_PKG.GetItemAttrText(

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

1509:
1510: l_msgbody := l_msgbody || '';
1511:
1512: IF (g_po_wf_debug = 'Y') THEN
1513: l_progress := 'PO_SIGNATURE_PVT.get_buyer_info_notfn_body: 02';
1514: PO_WF_DEBUG_PKG.insert_debug(l_item_type,l_item_key,l_progress);
1515: END IF;
1516:
1517: WF_NOTIFICATION.WriteToClob(document, l_msgbody);

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

1516:
1517: WF_NOTIFICATION.WriteToClob(document, l_msgbody);
1518:
1519: IF (g_po_wf_debug = 'Y') THEN
1520: l_progress := 'PO_SIGNATURE_PVT.get_buyer_info_notfn_body: 03';
1521: PO_WF_DEBUG_PKG.insert_debug(l_item_type,l_item_key,l_progress);
1522: END IF;
1523:
1524: EXCEPTION

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

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

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

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

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

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

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

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

Line 1585: l_progress := 'PO_SIGNATURE_PVT.set_accepted_buyer_response: 01';

1581:
1582: BEGIN
1583:
1584: IF (g_po_wf_debug = 'Y') THEN
1585: l_progress := 'PO_SIGNATURE_PVT.set_accepted_buyer_response: 01';
1586: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1587: END IF;
1588:
1589: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber(

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

1627: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,
1628: itemkey => itemkey,
1629: aname => 'PO_SUP_INFO_MSG_BODY',
1630: avalue =>
1631: 'PLSQLCLOB:PO_SIGNATURE_PVT.get_supplier_info_notfn_body/'|| l_document_id ||':'||itemtype||':'||itemkey);
1632:
1633: IF (g_po_wf_debug = 'Y') THEN
1634: l_progress := 'PO_SIGNATURE_PVT.set_accepted_buyer_response: 02';
1635: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

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

1630: avalue =>
1631: 'PLSQLCLOB:PO_SIGNATURE_PVT.get_supplier_info_notfn_body/'|| l_document_id ||':'||itemtype||':'||itemkey);
1632:
1633: IF (g_po_wf_debug = 'Y') THEN
1634: l_progress := 'PO_SIGNATURE_PVT.set_accepted_buyer_response: 02';
1635: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1636: END IF;
1637:
1638: EXCEPTION

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

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

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

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

Line 1717: l_progress := 'PO_SIGNATURE_PVT.get_supplier_info_notfn_body: 01';

1713: l_item_type := substr(document_id, l_firstcolon + 1, l_secondcolon - l_firstcolon - 1);
1714: l_item_key := substr(document_id, l_secondcolon+1,length(document_id) - l_secondcolon);
1715:
1716: IF (g_po_wf_debug = 'Y') THEN
1717: l_progress := 'PO_SIGNATURE_PVT.get_supplier_info_notfn_body: 01';
1718: PO_WF_DEBUG_PKG.insert_debug(l_item_type,l_item_key,l_progress);
1719: END IF;
1720:
1721: l_buyer_name := PO_WF_UTIL_PKG.GetItemAttrText(

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

1856:
1857: l_msgbody := l_msgbody || '';
1858:
1859: IF (g_po_wf_debug = 'Y') THEN
1860: l_progress := 'PO_SIGNATURE_PVT.get_supplier_info_notfn_body: 02';
1861: PO_WF_DEBUG_PKG.insert_debug(l_item_type,l_item_key,l_progress);
1862: END IF;
1863:
1864: WF_NOTIFICATION.WriteToClob(document, l_msgbody);

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

1863:
1864: WF_NOTIFICATION.WriteToClob(document, l_msgbody);
1865:
1866: IF (g_po_wf_debug = 'Y') THEN
1867: l_progress := 'PO_SIGNATURE_PVT.get_supplier_info_notfn_body: 03';
1868: PO_WF_DEBUG_PKG.insert_debug(l_item_type,l_item_key,l_progress);
1869: END IF;
1870:
1871: EXCEPTION

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

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

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

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

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

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

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

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

Line 1933: l_progress := 'PO_SIGNATURE_PVT.set_rejected_buyer_response: 01';

1929:
1930: BEGIN
1931:
1932: IF (g_po_wf_debug = 'Y') THEN
1933: l_progress := 'PO_SIGNATURE_PVT.set_rejected_buyer_response: 01';
1934: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1935: END IF;
1936:
1937: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber(

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

1975: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,
1976: itemkey => itemkey,
1977: aname => 'PO_SUP_INFO_MSG_BODY',
1978: avalue =>
1979: 'PLSQLCLOB:PO_SIGNATURE_PVT.get_supplier_info_notfn_body/'|| l_document_id ||':'||itemtype||':'||itemkey);
1980:
1981:
1982: EXCEPTION
1983: WHEN OTHERS THEN

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

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

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

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

Line 2037: l_progress := 'PO_SIGNATURE_PVT.Is_Signature_Required: 01';

2033:
2034: BEGIN
2035:
2036: IF (g_po_wf_debug = 'Y') THEN
2037: l_progress := 'PO_SIGNATURE_PVT.Is_Signature_Required: 01';
2038: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2039: END IF;
2040:
2041: -- Do nothing in cancel or timeout mode

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

2058:
2059: resultout := WF_ENGINE.eng_completed || ':' || l_req_signature ;
2060:
2061: IF (g_po_wf_debug = 'Y') THEN
2062: l_progress := 'PO_SIGNATURE_PVT.Is_Signature_Required: 02. Result= ' || l_req_signature;
2063: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2064: END IF;
2065:
2066: EXCEPTION

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

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

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

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

Line 2278: WF_CORE.context('PO_SIGNATURE_PVT','set_supplier_notification_id',l_progress);

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

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

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

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

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

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

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

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

3392: PROCEDURE if_was_sign_reqd_set_acc_flag(p_document_id IN NUMBER,
3393: x_if_acc_flag_updated OUT NOCOPY VARCHAR2)
3394: IS
3395: l_was_sign_reqd boolean := FALSE;
3396: d_module CONSTANT VARCHAR2(70) := 'po.plsql.PO_SIGNATURE_PVT.if_was_sign_reqd_set_acc_flag';
3397: d_pos NUMBER := 0;
3398: BEGIN
3399: IF (PO_LOG.d_proc) THEN
3400: PO_LOG.proc_begin(d_module,'p_document_id',p_document_id);

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

3457: p_document_id IN NUMBER,
3458: p_old_revision_num IN NUMBER,
3459: x_if_acc_flag_updated OUT NOCOPY VARCHAR2)
3460: IS
3461: d_module CONSTANT VARCHAR2(70) := 'po.plsql.PO_SIGNATURE_PVT.if_rev_and_signed_set_acc_flag';
3462: d_pos NUMBER := 0;
3463: l_revision_num PO_HEADERS_ALL.revision_num%TYPE;
3464: BEGIN
3465: SELECT revision_num

Line 3488: END PO_SIGNATURE_PVT;

3484: END IF;
3485: RAISE;
3486: END if_rev_and_signed_set_acc_flag;
3487:
3488: END PO_SIGNATURE_PVT;