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_COMMUNICATION_PVT dependencies on PO_WF_DEBUG_PKG

Line 192: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,x_progress);

188:
189: x_progress := 'PO_COMMUNICATION_PVT.GENERATE_PDF';
190:
191: IF (g_po_wf_debug = 'Y') THEN
192: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,x_progress);
193: END IF;
194:
195: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
196: itemkey => itemkey,

Line 218: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,x_progress);

214:
215: x_progress := 'PO_COMMUNICATION_PVT.GENERATE_PDF :launching the java concurrent program ';
216:
217: IF (g_po_wf_debug = 'Y') THEN
218: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,x_progress);
219: END IF;
220:
221: --if the po has T's and C's then launch the concurrent request to generate the pdf with T's and C's
222: --Bug5080617 Pass the parameters P_PO_TEMPLATE_CODE and P_CONTRACT_TEMPLATE_CODE as null

Line 284: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,x_progress);

280:
281: x_progress := 'PO_COMMUNICATION_PVT.GENERATE_PDF : Request id is '|| l_request_id;
282:
283: IF (g_po_wf_debug = 'Y') THEN
284: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,x_progress);
285: END IF;
286:
287: END IF;
288: END IF;

Line 295: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

291:
292: WHEN OTHERS THEN
293: x_progress := 'PO_COMMUNICATION_PVT.GENERATE_PDF : In Exception handler';
294: IF (g_po_wf_debug = 'Y') THEN
295: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
296: END IF;
297: wf_core.context('PO_COMMUNICATION_PVT','GENERATE_PDF',x_progress);
298: RAISE;
299:

Line 315: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

311: Begin
312: x_progress := 'PO_COMMUNICATION_PVT.PO_NEW_COMMUNICATION';
313:
314: IF (g_po_wf_debug = 'Y') THEN
315: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
316: END IF;
317:
318:
319: -- : Do nothing in cancel or timeout modes.

Line 342: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

338:
339: x_progress := 'PO_COMMUNICATION_PVT.PO_NEW_COMMUNICATION: Verify whether XDO Product is installed or not';
340:
341: IF (g_po_wf_debug = 'Y') THEN
342: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
343: END IF;
344:
345:
346: IF PO_COMMUNICATION_PROFILE = 'T' THEN

Line 363: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

359:
360: WHEN OTHERS THEN
361: x_progress := 'PO_COMMUNICATION_PVT.PO_NEW_COMMUNICATION: In Exception handler';
362: IF (g_po_wf_debug = 'Y') THEN
363: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
364: END IF;
365: wf_core.context('PO_COMMUNICATION_PVT','PO_NEW_COMMUNICATION',x_progress);
366: raise;
367:

Line 388: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

384: Begin
385: x_progress := 'PO_COMMUNICATION_PVT.DELETE_PDF_ATTACHMENTS';
386:
387: IF (g_po_wf_debug = 'Y') THEN
388: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
389: END IF;
390:
391: -- : Do nothing in cancel or timeout modes.
392: IF (funcmode <> wf_engine.eng_run)

Line 426: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

422:
423: x_progress := 'PO_COMMUNICATION_PVT.DELETE_PDF_ATTACHMENTS :Calling the Delete attachments procedure';
424:
425: IF (g_po_wf_debug = 'Y') THEN
426: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
427: END IF;
428:
429: FND_ATTACHED_DOCUMENTS2_PKG.delete_attachments(X_entity_name => l_entity_name,
430: X_pk1_value =>to_char(l_document_id),

Line 450: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

446:
447: WHEN OTHERS THEN
448: x_progress := 'PO_COMMUNICATION_PVT.DELETE_PDF_ATTACHMENTS:In Exception handler';
449: IF (g_po_wf_debug = 'Y') THEN
450: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
451: END IF;
452: wf_core.context('PO_COMMUNICATION_PVT','DELETE_PDF_ATTACHMENTS',x_progress);
453: raise;
454:

Line 481: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

477: Begin
478: x_progress := 'PO_COMMUNICATION_PVT.PO_PDF_EXISTS';
479:
480: IF (g_po_wf_debug = 'Y') THEN
481: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
482: END IF;
483:
484:
485: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

Line 528: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

524:
525: x_progress := 'PO_COMMUNICATION_PVT.PO_PDF_EXISTS: Verify whether the pdf exists for the document';
526:
527: IF (g_po_wf_debug = 'Y') THEN
528: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
529: END IF;
530:
531: BEGIN
532:

Line 538: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

534: --search in contracts repository
535: x_progress := 'PO_COMMUNICATION_PVT.PO_PDF_EXISTS:Searching in the Contracts Repository';
536:
537: IF (g_po_wf_debug = 'Y') THEN
538: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
539: END IF;
540:
541:
542: SELECT count(*) into l_count from fnd_lobs fl,fnd_attached_docs_form_vl fad

Line 554: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

550: --search in PO repository
551: x_progress := 'PO_COMMUNICATION_PVT.PO_PDF_EXISTS: Searching in the PO Repository';
552:
553: IF (g_po_wf_debug = 'Y') THEN
554: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
555: END IF;
556:
557:
558: -- Bug6139548

Line 589: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

585: EXCEPTION
586: When others then
587: x_progress := 'PO_COMMUNICATION_PVT.PO_PDF_EXISTS: In Exception handler';
588: IF (g_po_wf_debug = 'Y') THEN
589: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
590: END IF;
591: wf_core.context('PO_COMMUNICATION_PVT','PO_PDF_EXISTS',x_progress);
592: resultout := wf_engine.eng_completed || ':' || 'N';
593: raise;

Line 650: PO_WF_DEBUG_PKG.insert_debug (l_itemtype, l_itemkey,l_progress);

646:
647: l_progress := 'PO_COMMUNICATION_PVT.Start_Email_WF_Process: at beginning of Start_Email_WF_Process';
648:
649: IF (g_po_wf_debug = 'Y') THEN
650: PO_WF_DEBUG_PKG.insert_debug (l_itemtype, l_itemkey,l_progress);
651: END IF;
652:
653:
654: l_workflow_process := 'EMAIL_PO_PDF';

Line 787: PO_WF_DEBUG_PKG.insert_debug (l_itemtype, l_itemkey,l_progress);

783:
784: l_progress := 'PO_COMMUNICATION_PVT.Start_Email_WF_Process: Get the Supplier site language';
785:
786: IF (g_po_wf_debug = 'Y') THEN
787: PO_WF_DEBUG_PKG.insert_debug (l_itemtype, l_itemkey,l_progress);
788: END IF;
789:
790: if p_document_type = 'RELEASE' then
791: select poh.vendor_site_id, pvs.vendor_site_code, pvs.language

Line 826: PO_WF_DEBUG_PKG.insert_debug (l_itemtype, l_itemkey,l_progress);

822:
823: l_progress := 'PO_COMMUNICATION_PVT.Start_Email_WF_Process: Verify whether the role exists in wf_users';
824:
825: IF (g_po_wf_debug = 'Y') THEN
826: PO_WF_DEBUG_PKG.insert_debug (l_itemtype, l_itemkey,l_progress);
827: END IF;
828:
829:
830: select count(1) into l_performer_exists

Line 904: PO_WF_DEBUG_PKG.insert_debug (l_itemtype, l_itemkey,l_progress);

900:
901: l_progress := 'PO_COMMUNICATION_PVT.Start_Email_WF_Process:Start the workflow process';
902:
903: IF (g_po_wf_debug = 'Y') THEN
904: PO_WF_DEBUG_PKG.insert_debug (l_itemtype, l_itemkey,l_progress);
905: END IF;
906:
907: wf_engine. StartProcess (itemtype => l_itemtype, itemkey => l_itemkey);
908:

Line 916: PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);

912:
913: l_progress := 'PO_COMMUNICATION_PVT.Start_WF_Process_Email: In Exception handler';
914:
915: IF (g_po_wf_debug = 'Y') THEN
916: PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);
917: END IF;
918:
919: RAISE;
920:

Line 955: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,x_progress);

951: begin
952: x_progress := 'PO_COMMUNICATION_PVT.GENERATE_PDF_SUPP';
953:
954: IF (g_po_wf_debug = 'Y') THEN
955: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,x_progress);
956: END IF;
957:
958: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
959: itemkey => itemkey,

Line 1005: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,x_progress);

1001:
1002: x_progress := 'PO_COMMUNICATION_PVT.GENERATE_PDF_SUPP_TC :launching the Dispatch Purchase Order concurrent program ';
1003:
1004: IF (g_po_wf_debug = 'Y') THEN
1005: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,x_progress);
1006: END IF;
1007:
1008:
1009: --set the suppliers language before launching the concurrent request

Line 1088: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,x_progress);

1084:
1085: x_progress := 'PO_COMMUNICATION_PVT.GENERATE_PDF_SUPP_TC : Request id is - '|| l_request_id;
1086:
1087: IF (g_po_wf_debug = 'Y') THEN
1088: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,x_progress);
1089: END IF;
1090:
1091: END IF; -- language <> supplier language
1092:

Line 1101: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

1097: WHEN OTHERS THEN
1098: x_progress := 'PO_COMMUNICATION_PVT.GENERATE_PDF_SUPP_TC: In Exception handler';
1099:
1100: IF (g_po_wf_debug = 'Y') THEN
1101: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
1102: END IF;
1103: wf_core.context('PO_COMMUNICATION_PVT','GENERATE_PDF_SUPP_TC',x_progress);
1104: raise;
1105:

Line 1244: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,l_progress);

1240: begin
1241: l_progress := 'PO_COMMUNICATION_PVT.generate_pdf_buyer ';
1242:
1243: IF (g_po_wf_debug = 'Y') THEN
1244: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,l_progress);
1245: END IF;
1246:
1247: -- : Do nothing in cancel or timeout modes.
1248: IF (funcmode <> wf_engine.eng_run)

Line 1309: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,l_progress);

1305:
1306: l_progress := 'PO_COMMUNICATION_PVT.generate_pdf_buyer :Launching the Dispatch Purchase Order program ';
1307:
1308: IF (g_po_wf_debug = 'Y') THEN
1309: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,l_progress);
1310: END IF;
1311:
1312: --Bug#3481824 Need to pass document type as
1313: --RELEASE in case of a release to the concurrent program

Line 1345: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,l_progress);

1341: p_document_id => l_document_id);
1342: Exception when no_data_found then
1343: l_progress := 'PO_COMMUNICATION_PVT.generate_pdf_buyer: No supplier file attachments exist for this document';
1344: IF (g_po_wf_debug = 'Y') THEN
1345: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,l_progress);
1346: END IF;
1347: l_max_attachment_size := 0; -- No need to generate zip file if no 'To Supplier' file attachments exist
1348: End;
1349:

Line 1433: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,l_progress);

1429: -- until caught by outer exception handler
1430: Exception when no_data_found then
1431: l_progress := 'PO_COMMUNICATION_PVT.generate_pdf_buyer: No duplicate filenames exist in the attachments for this Release';
1432: IF (g_po_wf_debug = 'Y') THEN
1433: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,l_progress);
1434: END IF;
1435: End;
1436: ELSE
1437: -- bug4917605

Line 1495: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,l_progress);

1491: -- until caught by outer exception handler
1492: Exception when no_data_found then
1493: l_progress := 'PO_COMMUNICATION_PVT.generate_pdf_buyer: No duplicate filenames exist in the attachments for this PO';
1494: IF (g_po_wf_debug = 'Y') THEN
1495: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,l_progress);
1496: END IF;
1497: End;
1498: END IF;
1499:

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

1506: END IF;
1507:
1508: l_progress := 'PO_COMMUNICATION_PVT.generate_pdf_buyer : execute loop to get duplicate filenames with error condition';
1509: IF (g_po_wf_debug = 'Y') THEN
1510: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1511: END IF;
1512:
1513: l_error_flag := 0;
1514: LOOP

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

1532: END IF;
1533:
1534: l_progress := 'PO_COMMUNICATION_PVT.generate_pdf_buyer : error flag = '||l_error_flag;
1535: IF (g_po_wf_debug = 'Y') THEN
1536: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1537: END IF;
1538:
1539: IF l_error_flag = 1 THEN
1540: set_zip_error_code(itemtype,itemkey,'DUPLICATE_FILENAME');

Line 1548: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,l_progress);

1544: END IF; --IF l_attachments_exist = 'Y'
1545: END IF; --IF l_max_attachment_size > 0
1546: Exception when others then
1547: IF (g_po_wf_debug = 'Y') THEN
1548: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,l_progress);
1549: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,'PO_COMMUNICATION_PVT.generate_pdf_buyer: Caught Zip generation exception '||SQLERRM);
1550: END IF;
1551: set_zip_error_code(itemtype,itemkey,'UNEXPECTED');
1552: l_max_attachment_size := 0; -- No need to generate zip file if it is an error

Line 1549: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,'PO_COMMUNICATION_PVT.generate_pdf_buyer: Caught Zip generation exception '||SQLERRM);

1545: END IF; --IF l_max_attachment_size > 0
1546: Exception when others then
1547: IF (g_po_wf_debug = 'Y') THEN
1548: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,l_progress);
1549: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,'PO_COMMUNICATION_PVT.generate_pdf_buyer: Caught Zip generation exception '||SQLERRM);
1550: END IF;
1551: set_zip_error_code(itemtype,itemkey,'UNEXPECTED');
1552: l_max_attachment_size := 0; -- No need to generate zip file if it is an error
1553: End;

Line 1613: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,l_progress);

1609:
1610: l_progress := 'PO_COMMUNICATION_PVT.generate_pdf_buyer : Request id is - '|| l_request_id;
1611:
1612: IF (g_po_wf_debug = 'Y') THEN
1613: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,l_progress);
1614: END IF;
1615:
1616: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => itemtype,
1617: itemkey => itemkey,

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

1622:
1623: WHEN OTHERS THEN
1624:
1625: IF (g_po_wf_debug = 'Y') THEN
1626: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1627: END IF;
1628:
1629: wf_core.context('PO_COMMUNICATION_PVT','GENERATE_PDF_BUYER',l_progress);
1630: raise;

Line 1662: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,x_progress);

1658: begin
1659: x_progress := 'PO_COMMUNICATION_PVT.GENERATE_PDF_SUPP';
1660:
1661: IF (g_po_wf_debug = 'Y') THEN
1662: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,x_progress);
1663: END IF;
1664:
1665: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
1666: itemkey => itemkey,

Line 1713: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,x_progress);

1709:
1710: x_progress := 'PO_COMMUNICATION_PVT.GENERATE_PDF_SUPP :launching the Dispatch Purchase Order concurrent program ';
1711:
1712: IF (g_po_wf_debug = 'Y') THEN
1713: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,x_progress);
1714: END IF;
1715:
1716: --set the suppliers language before launching the concurrent request
1717: -- Bug6841986/6528046 changed userenv('LANG')==> l_language_code

Line 1789: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,x_progress);

1785:
1786: x_progress := 'PO_COMMUNICATION_PVT.GENERATE_PDF_SUPP : Request id is - '|| l_request_id;
1787:
1788: IF (g_po_wf_debug = 'Y') THEN
1789: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,x_progress);
1790: END IF;
1791:
1792: -- Bug 7299381
1793: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => itemtype,

Line 1807: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

1803: WHEN OTHERS THEN
1804: x_progress := 'PO_COMMUNICATION_PVT.GENERATE_PDF_SUPP: In Exception handler';
1805:
1806: IF (g_po_wf_debug = 'Y') THEN
1807: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
1808: END IF;
1809: wf_core.context('PO_COMMUNICATION_PVT','GENERATE_PDF_SUPP',x_progress);
1810: raise;
1811:

Line 1836: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,x_progress);

1832: begin
1833: x_progress := 'PO_COMMUNICATION_PVT.GENERATE_PDF_EMAIL_PROCESS';
1834:
1835: IF (g_po_wf_debug = 'Y') THEN
1836: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,x_progress);
1837: END IF;
1838:
1839: l_language_code := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
1840: itemkey => itemkey,

Line 1872: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,x_progress);

1868:
1869: x_progress := 'PO_COMMUNICATION_PVT.GENERATE_PDF_EMAIL_PROCESS:launching the Dispatch Purchase Order concurrent program ';
1870:
1871: IF (g_po_wf_debug = 'Y') THEN
1872: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,x_progress);
1873: END IF;
1874:
1875: IF l_language_code <> userenv('LANG') THEN
1876:

Line 1949: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

1945: WHEN OTHERS THEN
1946: x_progress := 'PO_COMMUNICATION_PVT.GENERATE_PDF_EMAIL_PROCESS: In Exception handler';
1947:
1948: IF (g_po_wf_debug = 'Y') THEN
1949: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
1950: END IF;
1951: wf_core.context('PO_COMMUNICATION_PVT','GENERATE_PDF_EMAIL_PROCESS',x_progress);
1952: RAISE ;
1953:

Line 3114: PO_WF_DEBUG_PKG.INSERT_DEBUG(l_itemtype, l_itemkey,x_progress);

3110:
3111: x_progress := 'PO_COMMUNICATION_PVT.pdf_attach_app ';
3112:
3113: IF (g_po_wf_debug = 'Y') THEN
3114: PO_WF_DEBUG_PKG.INSERT_DEBUG(l_itemtype, l_itemkey,x_progress);
3115: END IF;
3116:
3117: l_document_id :=wf_engine.GetItemAttrNumber (itemtype => l_itemtype,
3118: itemkey => l_itemkey,

Line 3189: PO_WF_DEBUG_PKG.INSERT_DEBUG(l_itemtype, l_itemkey,x_progress);

3185: --WF_NOTIFICATION.WriteToBlob(document, l_document);
3186: x_progress := 'PO_COMMUNICATION_PVT.pdf_attach_app-Exception ';
3187:
3188: IF (g_po_wf_debug = 'Y') THEN
3189: PO_WF_DEBUG_PKG.INSERT_DEBUG(l_itemtype, l_itemkey,x_progress);
3190: END IF;
3191:
3192: --Bug#3274081 Display the message to the user incase the pdf fails.
3193: document_type:='text/html; name='||l_filename;

Line 3230: PO_WF_DEBUG_PKG.INSERT_DEBUG(l_itemtype, l_itemkey,x_progress);

3226: l_itemtype := substr(document_id, 1, instr(document_id, ':') - 1);
3227: l_itemkey := substr(document_id, instr(document_id, ':') + 1, length(document_id) - 2);
3228:
3229: IF (g_po_wf_debug = 'Y') THEN
3230: PO_WF_DEBUG_PKG.INSERT_DEBUG(l_itemtype, l_itemkey,x_progress);
3231: END IF;
3232:
3233: l_document_id :=wf_engine.GetItemAttrNumber (itemtype => l_itemtype,
3234: itemkey => l_itemkey,

Line 3304: PO_WF_DEBUG_PKG.INSERT_DEBUG(l_itemtype, l_itemkey,x_progress);

3300: WHEN OTHERS THEN
3301: x_progress := 'PO_COMMUNICATION_PVT.pdf_attach_supp - Exception ';
3302:
3303: IF (g_po_wf_debug = 'Y') THEN
3304: PO_WF_DEBUG_PKG.INSERT_DEBUG(l_itemtype, l_itemkey,x_progress);
3305: END IF;
3306:
3307: -- Display the message to the user incase the pdf fails.
3308: -- Bug 4047688

Line 3344: PO_WF_DEBUG_PKG.INSERT_DEBUG(l_itemtype, l_itemkey,x_progress);

3340: l_itemtype := substr(document_id, 1, instr(document_id, ':') - 1);
3341: l_itemkey := substr(document_id, instr(document_id, ':') + 1, length(document_id) - 2);
3342:
3343: IF (g_po_wf_debug = 'Y') THEN
3344: PO_WF_DEBUG_PKG.INSERT_DEBUG(l_itemtype, l_itemkey,x_progress);
3345: END IF;
3346:
3347: l_document_id :=wf_engine.GetItemAttrNumber (itemtype => l_itemtype,
3348: itemkey => l_itemkey,

Line 3469: PO_WF_DEBUG_PKG.INSERT_DEBUG(l_itemtype, l_itemkey,x_progress);

3465: --WF_NOTIFICATION.WriteToBlob(document, l_document);
3466: x_progress := 'PO_COMMUNICATION_PVT.pdf_attach - Exception ';
3467:
3468: IF (g_po_wf_debug = 'Y') THEN
3469: PO_WF_DEBUG_PKG.INSERT_DEBUG(l_itemtype, l_itemkey,x_progress);
3470: END IF;
3471:
3472: --Bug#3274081 Display the message to the user incase the pdf fails.
3473: --Bug 4047688: Removed concatenation of l_filename from document_type

Line 3537: PO_WF_DEBUG_PKG.insert_debug(l_itemtype, l_itemkey, x_progress);

3533: l_itemkey := substr(document_id, instr(document_id, ':') + 1,
3534: length(document_id) - 2);
3535:
3536: IF (g_po_wf_debug = 'Y') THEN
3537: PO_WF_DEBUG_PKG.insert_debug(l_itemtype, l_itemkey, x_progress);
3538: END IF;
3539:
3540: l_po_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber (
3541: itemtype => l_itemtype,

Line 3578: PO_WF_DEBUG_PKG.insert_debug(l_itemtype, l_itemkey, x_progress);

3574:
3575: x_progress := '020';
3576:
3577: IF (g_po_wf_debug = 'Y') THEN
3578: PO_WF_DEBUG_PKG.insert_debug(l_itemtype, l_itemkey, x_progress);
3579: END IF;
3580:
3581: IF l_withTerms <> 'Y' THEN
3582: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3594: PO_WF_DEBUG_PKG.insert_debug(l_itemtype, l_itemkey, x_progress);

3590:
3591: x_progress := '030; l_okc_file_id = ' || l_okc_file_id;
3592:
3593: IF (g_po_wf_debug = 'Y') THEN
3594: PO_WF_DEBUG_PKG.insert_debug(l_itemtype, l_itemkey, x_progress);
3595: END IF;
3596:
3597: IF (l_okc_file_id > 0)
3598: THEN

Line 3624: PO_WF_DEBUG_PKG.insert_debug(l_itemtype, l_itemkey, x_progress);

3620:
3621: x_progress := 'END OF okc_doc_attach';
3622:
3623: IF (g_po_wf_debug = 'Y') THEN
3624: PO_WF_DEBUG_PKG.insert_debug(l_itemtype, l_itemkey, x_progress);
3625: END IF;
3626:
3627: EXCEPTION
3628:

Line 3634: PO_WF_DEBUG_PKG.INSERT_DEBUG(l_itemtype, l_itemkey,x_progress);

3630: WHEN others THEN
3631: x_progress := 'PO_COMMUNICATION_PVT.pdf_attach - Exception ';
3632:
3633: IF (g_po_wf_debug = 'Y') THEN
3634: PO_WF_DEBUG_PKG.INSERT_DEBUG(l_itemtype, l_itemkey,x_progress);
3635: END IF;
3636:
3637: document_type:='text/html; name='||l_okc_file_name;
3638: l_message := fnd_message.get_string('PO','PO_OKC_DOC_FAILED');

Line 3704: PO_WF_DEBUG_PKG.INSERT_DEBUG(l_itemtype, l_itemkey,l_progress);

3700: l_itemtype := substr(document_id, 1, instr(document_id, ':') - 1);
3701: l_itemkey := substr(document_id, instr(document_id, ':') + 1, length(document_id) - 2);
3702:
3703: IF (g_po_wf_debug = 'Y') THEN
3704: PO_WF_DEBUG_PKG.INSERT_DEBUG(l_itemtype, l_itemkey,l_progress);
3705: END IF;
3706:
3707: l_progress := 'PO_COMMUNICATION_PVT.zip_attach : Get item attributes';
3708: l_document_id :=wf_engine.GetItemAttrNumber (itemtype => l_itemtype,

Line 3782: PO_WF_DEBUG_PKG.INSERT_DEBUG(l_itemtype, l_itemkey,l_progress||' '||SQLERRM);

3778: EXCEPTION
3779: WHEN OTHERS THEN
3780:
3781: IF (g_po_wf_debug = 'Y') THEN
3782: PO_WF_DEBUG_PKG.INSERT_DEBUG(l_itemtype, l_itemkey,l_progress||' '||SQLERRM);
3783: END IF;
3784:
3785: document_type:='text/html; name='||l_filename;
3786: l_message := fnd_message.get_string('PO','PO_ZIP_FAILED');

Line 3913: PO_WF_DEBUG_PKG.insert_debug(p_itemtype,p_itemkey,l_progress);

3909: l_progress varchar2(200);
3910: BEGIN
3911: l_progress := 'PO_COMMUNICATION_PVT.get_max_zip_size : Querying max_attachment_size';
3912: IF (g_po_wf_debug = 'Y') THEN
3913: PO_WF_DEBUG_PKG.insert_debug(p_itemtype,p_itemkey,l_progress);
3914: END IF;
3915: select nvl(psp.max_attachment_size,0)
3916: into l_max_attachment_size
3917: from po_system_parameters psp;

Line 3920: PO_WF_DEBUG_PKG.insert_debug(p_itemtype,p_itemkey,l_progress);

3916: into l_max_attachment_size
3917: from po_system_parameters psp;
3918: l_progress := 'PO_COMMUNICATION_PVT.get_max_zip_size : maximum attachment size = '||l_max_attachment_size;
3919: IF (g_po_wf_debug = 'Y') THEN
3920: PO_WF_DEBUG_PKG.insert_debug(p_itemtype,p_itemkey,l_progress);
3921: END IF;
3922: return l_max_attachment_size;
3923: Exception
3924: when others then

Line 3927: PO_WF_DEBUG_PKG.insert_debug(p_itemtype,p_itemkey,l_progress);

3923: Exception
3924: when others then
3925: l_progress := 'PO_COMMUNICATION_PVT.get_max_zip_size : handled exception while getting Maximum Attachment Size ';
3926: IF (g_po_wf_debug = 'Y') THEN
3927: PO_WF_DEBUG_PKG.insert_debug(p_itemtype,p_itemkey,l_progress);
3928: END IF;
3929: l_max_attachment_size := 0;
3930: END get_max_zip_size;
3931: