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_WF_DEBUG_PKG

Line 110: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

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

Line 318: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

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
322: WHEN l_binding_exception then

Line 406: PO_WF_DEBUG_PKG.insert_debug(l_item_type,l_item_key,l_progress);

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,
410: itemkey => l_item_key,

Line 527: PO_WF_DEBUG_PKG.insert_debug(l_item_type,l_item_key,l_progress);

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);
531:

Line 534: PO_WF_DEBUG_PKG.insert_debug(l_item_type,l_item_key,l_progress);

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
538: WHEN l_binding_exception then

Line 621: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

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

Line 793: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

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
797: PO_ERECORDS_PVT.capture_signature (

Line 849: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

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
853: RAISE l_erecords_exception;

Line 868: PO_WF_DEBUG_PKG.INSERT_DEBUG(itemtype, itemkey,

864: avalue => l_signature_id);
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;

Line 870: PO_WF_DEBUG_PKG.INSERT_DEBUG(itemtype, itemkey,

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);
874: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemtype, itemkey);

Line 968: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

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||
972: ' l_vendor_contact_title = '||l_vendor_contact_title||

Line 974: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

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;
976:
977: -- Do nothing in cancel or timeout mode
978: --

Line 1102: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

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,
1106: aname => 'PO_REVISION_NUM');

Line 1173: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

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
1177: SELECT displayed_field

Line 1194: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

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;
1198: END IF;

Line 1201: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

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 */
1205:

Line 1330: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

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

Line 1346: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

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

Line 1348: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

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);
1352: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);

Line 1361: PO_WF_DEBUG_PKG.INSERT_DEBUG(itemtype, itemkey,

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

Line 1363: PO_WF_DEBUG_PKG.INSERT_DEBUG(itemtype, itemkey,

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);
1367: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemtype, itemkey);

Line 1429: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

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

Line 1484: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

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
1488: SELECT wf_item_key

Line 1497: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

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

Line 1557: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

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

Line 1612: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

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
1616: INTO l_po_itemkey

Line 1624: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

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

Line 1708: PO_WF_DEBUG_PKG.insert_debug(l_item_type,l_item_key,l_progress);

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(
1712: itemtype => l_item_type,

Line 1858: PO_WF_DEBUG_PKG.insert_debug(l_item_type,l_item_key,l_progress);

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);
1862:

Line 1865: PO_WF_DEBUG_PKG.insert_debug(l_item_type,l_item_key,l_progress);

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
1869: WHEN l_binding_exception then

Line 1930: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

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

Line 1986: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

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

Line 2069: PO_WF_DEBUG_PKG.insert_debug(l_item_type,l_item_key,l_progress);

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(
2073: itemtype => l_item_type,

Line 2212: PO_WF_DEBUG_PKG.insert_debug(l_item_type,l_item_key,l_progress);

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);
2216:

Line 2219: PO_WF_DEBUG_PKG.insert_debug(l_item_type,l_item_key,l_progress);

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
2223: WHEN l_binding_exception then

Line 2285: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

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

Line 2396: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

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

Line 2421: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

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

Line 2478: l_progress:='000'; PO_WF_DEBUG_PKG.insert_debug(p_itemtype,p_itemkey,l_log_head||':'||l_progress);

2474: l_draft_id PO_HEADERS_DRAFT_ALL.draft_id%TYPE; --CLM Apprvl
2475:
2476: BEGIN
2477:
2478: l_progress:='000'; PO_WF_DEBUG_PKG.insert_debug(p_itemtype,p_itemkey,l_log_head||':'||l_progress);
2479:
2480: -- Get the Document Type and ID from the Workflow Attributes.
2481: --
2482: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText

Line 2507: l_progress:='010'; PO_WF_DEBUG_PKG.insert_debug(p_itemtype,p_itemkey,l_log_head||':'||l_progress||' Document Type = '||l_document_type);

2503: l_draft_id := -1;
2504: end if;
2505:
2506: -- CLM Apprvl end
2507: l_progress:='010'; PO_WF_DEBUG_PKG.insert_debug(p_itemtype,p_itemkey,l_log_head||':'||l_progress||' Document Type = '||l_document_type);
2508: l_progress:='020'; PO_WF_DEBUG_PKG.insert_debug(p_itemtype,p_itemkey,l_log_head||':'||l_progress||' Document ID = '||l_document_id);
2509:
2510: -- If the document is not a Release, then the get the value of the
2511: -- Acceptance Required Flag.

Line 2508: l_progress:='020'; PO_WF_DEBUG_PKG.insert_debug(p_itemtype,p_itemkey,l_log_head||':'||l_progress||' Document ID = '||l_document_id);

2504: end if;
2505:
2506: -- CLM Apprvl end
2507: l_progress:='010'; PO_WF_DEBUG_PKG.insert_debug(p_itemtype,p_itemkey,l_log_head||':'||l_progress||' Document Type = '||l_document_type);
2508: l_progress:='020'; PO_WF_DEBUG_PKG.insert_debug(p_itemtype,p_itemkey,l_log_head||':'||l_progress||' Document ID = '||l_document_id);
2509:
2510: -- If the document is not a Release, then the get the value of the
2511: -- Acceptance Required Flag.
2512: --

Line 2523: l_progress:='030'; PO_WF_DEBUG_PKG.insert_debug(p_itemtype,p_itemkey,l_log_head||':'||l_progress||' Acceptance Required Flag = '||l_acceptance_flag);

2519: AND draft_id = l_draft_id;
2520:
2521: END IF;
2522:
2523: l_progress:='030'; PO_WF_DEBUG_PKG.insert_debug(p_itemtype,p_itemkey,l_log_head||':'||l_progress||' Acceptance Required Flag = '||l_acceptance_flag);
2524:
2525: -- If the Acceptance Required Flag is 'S',
2526: -- then a Signature is required; else, no Signature is required.
2527: --

Line 2532: l_progress:='040'; PO_WF_DEBUG_PKG.insert_debug(p_itemtype,p_itemkey,l_log_head||':'||l_progress||' Signature Required = TRUE');

2528: -- CLM Apprvl. l_acceptance_flag = 'P' signifies 'Proxy Signature' which is specific to CLM approval.
2529: IF ( l_acceptance_flag = 'S' or l_acceptance_flag = 'P' )
2530: THEN
2531: l_signature_required := TRUE;
2532: l_progress:='040'; PO_WF_DEBUG_PKG.insert_debug(p_itemtype,p_itemkey,l_log_head||':'||l_progress||' Signature Required = TRUE');
2533: ELSE
2534: l_signature_required := FALSE;
2535: l_progress:='050'; PO_WF_DEBUG_PKG.insert_debug(p_itemtype,p_itemkey,l_log_head||':'||l_progress||' Signature Required = FALSE');
2536: END IF;

Line 2535: l_progress:='050'; PO_WF_DEBUG_PKG.insert_debug(p_itemtype,p_itemkey,l_log_head||':'||l_progress||' Signature Required = FALSE');

2531: l_signature_required := TRUE;
2532: l_progress:='040'; PO_WF_DEBUG_PKG.insert_debug(p_itemtype,p_itemkey,l_log_head||':'||l_progress||' Signature Required = TRUE');
2533: ELSE
2534: l_signature_required := FALSE;
2535: l_progress:='050'; PO_WF_DEBUG_PKG.insert_debug(p_itemtype,p_itemkey,l_log_head||':'||l_progress||' Signature Required = FALSE');
2536: END IF;
2537:
2538: return (l_signature_required);
2539:

Line 2543: PO_WF_DEBUG_PKG.insert_debug(p_itemtype,p_itemkey,l_log_head||':'||SQLERRM);

2539:
2540: EXCEPTION
2541:
2542: WHEN OTHERS THEN
2543: PO_WF_DEBUG_PKG.insert_debug(p_itemtype,p_itemkey,l_log_head||':'||SQLERRM);
2544: RAISE;
2545:
2546: END is_signature_required;
2547:

Line 2729: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

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(
2733: itemtype => itemtype,

Line 2841: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

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(
2845: itemtype => itemtype,

Line 4279: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

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

Line 4313: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

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:
4317: if l_draft_id IS NOT NULL AND l_draft_id <> -1 THEN

Line 4350: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

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:
4354: EXCEPTION

Line 4409: l_progress:='000'; PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_log_head||':'||l_progress);

4405: l_acceptance_mode VARCHAR2(30);
4406:
4407: BEGIN
4408:
4409: l_progress:='000'; PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_log_head||':'||l_progress);
4410:
4411: -- Do nothing in cancel or timeout mode
4412: --
4413: if (funcmode <> WF_ENGINE.eng_run) then

Line 4446: l_progress:='010'; PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_log_head||':'||l_progress||' Document Type = '||l_document_type);

4442: end if;
4443:
4444:
4445:
4446: l_progress:='010'; PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_log_head||':'||l_progress||' Document Type = '||l_document_type);
4447: l_progress:='020'; PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_log_head||':'||l_progress||' Document ID = '||l_document_id);
4448: --l_progress:='030'; PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_log_head||':'||l_progress||' Document sub type = '||l_document_subtype);
4449: l_progress:='040'; PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_log_head||':'||l_progress||' Draft ID = '||l_draft_id);
4450:

Line 4447: l_progress:='020'; PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_log_head||':'||l_progress||' Document ID = '||l_document_id);

4443:
4444:
4445:
4446: l_progress:='010'; PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_log_head||':'||l_progress||' Document Type = '||l_document_type);
4447: l_progress:='020'; PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_log_head||':'||l_progress||' Document ID = '||l_document_id);
4448: --l_progress:='030'; PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_log_head||':'||l_progress||' Document sub type = '||l_document_subtype);
4449: l_progress:='040'; PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_log_head||':'||l_progress||' Draft ID = '||l_draft_id);
4450:
4451: -- If the document is not a Release, then the get the value of the

Line 4448: --l_progress:='030'; PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_log_head||':'||l_progress||' Document sub type = '||l_document_subtype);

4444:
4445:
4446: l_progress:='010'; PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_log_head||':'||l_progress||' Document Type = '||l_document_type);
4447: l_progress:='020'; PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_log_head||':'||l_progress||' Document ID = '||l_document_id);
4448: --l_progress:='030'; PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_log_head||':'||l_progress||' Document sub type = '||l_document_subtype);
4449: l_progress:='040'; PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_log_head||':'||l_progress||' Draft ID = '||l_draft_id);
4450:
4451: -- If the document is not a Release, then the get the value of the
4452: -- Acceptance Required Flag.

Line 4449: l_progress:='040'; PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_log_head||':'||l_progress||' Draft ID = '||l_draft_id);

4445:
4446: l_progress:='010'; PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_log_head||':'||l_progress||' Document Type = '||l_document_type);
4447: l_progress:='020'; PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_log_head||':'||l_progress||' Document ID = '||l_document_id);
4448: --l_progress:='030'; PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_log_head||':'||l_progress||' Document sub type = '||l_document_subtype);
4449: l_progress:='040'; PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_log_head||':'||l_progress||' Draft ID = '||l_draft_id);
4450:
4451: -- If the document is not a Release, then the get the value of the
4452: -- Acceptance Required Flag.
4453: --

Line 4470: l_progress:='030'; PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_log_head||':'||l_progress||' Acceptance Required Flag = '||l_acceptance_flag);

4466: WHERE po_header_id = l_document_id;
4467: END IF;
4468: END IF;
4469:
4470: l_progress:='030'; PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_log_head||':'||l_progress||' Acceptance Required Flag = '||l_acceptance_flag);
4471:
4472:
4473: -- CLM Apprvl. l_acceptance_flag = 'P' signifies 'Proxy Signature' which is specific to CLM approval.
4474: IF l_acceptance_flag = 'S' THEN

Line 4476: l_progress:='040'; PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_log_head||':'||l_progress||' l_acceptance_mode ='||l_acceptance_mode);

4472:
4473: -- CLM Apprvl. l_acceptance_flag = 'P' signifies 'Proxy Signature' which is specific to CLM approval.
4474: IF l_acceptance_flag = 'S' THEN
4475: l_acceptance_mode := 'SIGNATURE';
4476: l_progress:='040'; PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_log_head||':'||l_progress||' l_acceptance_mode ='||l_acceptance_mode);
4477: ELSIF l_acceptance_flag = 'P' THEN
4478: l_acceptance_mode := 'SIGNATURE_PROXY';
4479: l_progress:='050'; PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_log_head||':'||l_progress||' l_acceptance_mode = '||l_acceptance_mode);
4480: END IF;

Line 4479: l_progress:='050'; PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_log_head||':'||l_progress||' l_acceptance_mode = '||l_acceptance_mode);

4475: l_acceptance_mode := 'SIGNATURE';
4476: l_progress:='040'; PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_log_head||':'||l_progress||' l_acceptance_mode ='||l_acceptance_mode);
4477: ELSIF l_acceptance_flag = 'P' THEN
4478: l_acceptance_mode := 'SIGNATURE_PROXY';
4479: l_progress:='050'; PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_log_head||':'||l_progress||' l_acceptance_mode = '||l_acceptance_mode);
4480: END IF;
4481:
4482: resultout := WF_ENGINE.eng_completed || ':' || l_acceptance_mode ;
4483:

Line 4487: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_log_head||':'||SQLERRM);

4483:
4484: EXCEPTION
4485:
4486: WHEN OTHERS THEN
4487: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_log_head||':'||SQLERRM);
4488: RAISE;
4489:
4490: END get_acceptance_mode;
4491:

Line 4541: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

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

Line 4585: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_log_head||':'||SQLERRM);

4581: resultout := WF_ENGINE.eng_completed || ':' || 'N' ;
4582: END IF;
4583: EXCEPTION
4584: WHEN others THEN
4585: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_log_head||':'||SQLERRM);
4586: RAISE;
4587: END;
4588: -----------------------------------------------------------------------------------
4589: --Start of Comments

Line 4643: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

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

Line 4689: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

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

Line 4741: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

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

Line 4800: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

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

Line 4915: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

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

Line 4930: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'l_forward_to_username: '||l_forward_to_username);

4926: l_forward_to_username := po_wf_util_pkg.GetItemAttrText( itemtype => itemType,
4927: itemkey => itemkey,
4928: aname => 'FORWARD_TO_USERNAME_RESPONSE');
4929:
4930: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'l_forward_to_username: '||l_forward_to_username);
4931:
4932: IF l_forward_to_username IS NOT NULL THEN
4933: PO_WF_UTIL_PKG.SetItemAttrText(
4934: itemtype => itemtype,

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 5043: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_log_head||':'||SQLERRM);

5039:
5040:
5041: EXCEPTION
5042: WHEN others THEN
5043: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_log_head||':'||SQLERRM);
5044: RAISE;
5045: END;
5046:
5047: