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 105: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

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
109: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

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

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

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

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

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

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

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

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

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

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

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

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

Line 740: PO_WF_DEBUG_PKG.INSERT_DEBUG(itemtype, itemkey,

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

Line 742: PO_WF_DEBUG_PKG.INSERT_DEBUG(itemtype, itemkey,

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

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

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

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

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

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

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

Line 1042: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

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

Line 1044: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

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

Line 1057: PO_WF_DEBUG_PKG.INSERT_DEBUG(itemtype, itemkey,

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

Line 1059: PO_WF_DEBUG_PKG.INSERT_DEBUG(itemtype, itemkey,

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

2115: l_acceptance_flag PO_HEADERS_ALL.acceptance_required_flag%TYPE := 'N';
2116:
2117: BEGIN
2118:
2119: l_progress:='000'; PO_WF_DEBUG_PKG.insert_debug(p_itemtype,p_itemkey,l_log_head||':'||l_progress);
2120:
2121: -- Get the Document Type and ID from the Workflow Attributes.
2122: --
2123: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText

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

2129: ( itemtype => p_itemtype
2130: , itemkey => p_itemkey
2131: , aname => 'DOCUMENT_ID'
2132: );
2133: l_progress:='010'; PO_WF_DEBUG_PKG.insert_debug(p_itemtype,p_itemkey,l_log_head||':'||l_progress||' Document Type = '||l_document_type);
2134: l_progress:='020'; PO_WF_DEBUG_PKG.insert_debug(p_itemtype,p_itemkey,l_log_head||':'||l_progress||' Document ID = '||l_document_id);
2135:
2136: -- If the document is not a Release, then the get the value of the
2137: -- Acceptance Required Flag.

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

2130: , itemkey => p_itemkey
2131: , aname => 'DOCUMENT_ID'
2132: );
2133: l_progress:='010'; PO_WF_DEBUG_PKG.insert_debug(p_itemtype,p_itemkey,l_log_head||':'||l_progress||' Document Type = '||l_document_type);
2134: l_progress:='020'; PO_WF_DEBUG_PKG.insert_debug(p_itemtype,p_itemkey,l_log_head||':'||l_progress||' Document ID = '||l_document_id);
2135:
2136: -- If the document is not a Release, then the get the value of the
2137: -- Acceptance Required Flag.
2138: --

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

2143: FROM po_headers_all
2144: WHERE po_header_id = l_document_id;
2145: END IF;
2146:
2147: l_progress:='030'; PO_WF_DEBUG_PKG.insert_debug(p_itemtype,p_itemkey,l_log_head||':'||l_progress||' Acceptance Required Flag = '||l_acceptance_flag);
2148:
2149: -- If the Acceptance Required Flag is 'S',
2150: -- then a Signature is required; else, no Signature is required.
2151: --

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

2151: --
2152: IF ( l_acceptance_flag = 'S' )
2153: THEN
2154: l_signature_required := TRUE;
2155: l_progress:='040'; PO_WF_DEBUG_PKG.insert_debug(p_itemtype,p_itemkey,l_log_head||':'||l_progress||' Signature Required = TRUE');
2156: ELSE
2157: l_signature_required := FALSE;
2158: l_progress:='050'; PO_WF_DEBUG_PKG.insert_debug(p_itemtype,p_itemkey,l_log_head||':'||l_progress||' Signature Required = FALSE');
2159: END IF;

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

2154: l_signature_required := TRUE;
2155: l_progress:='040'; PO_WF_DEBUG_PKG.insert_debug(p_itemtype,p_itemkey,l_log_head||':'||l_progress||' Signature Required = TRUE');
2156: ELSE
2157: l_signature_required := FALSE;
2158: l_progress:='050'; PO_WF_DEBUG_PKG.insert_debug(p_itemtype,p_itemkey,l_log_head||':'||l_progress||' Signature Required = FALSE');
2159: END IF;
2160:
2161: return (l_signature_required);
2162:

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

2162:
2163: EXCEPTION
2164:
2165: WHEN OTHERS THEN
2166: PO_WF_DEBUG_PKG.insert_debug(p_itemtype,p_itemkey,l_log_head||':'||SQLERRM);
2167: RAISE;
2168:
2169: END is_signature_required;
2170: