APPS.PO_EMAIL_GENERATE dependencies on PO_EMAIL_GENERATE

Line 1: PACKAGE BODY PO_EMAIL_GENERATE AS

1: PACKAGE BODY PO_EMAIL_GENERATE AS
2: /* $Header: POXWPAMB.pls 120.12.12020000.3 2013/04/09 06:18:52 swagajul ship $ */
3:
4: /*=======================================================================+
5: | FILENAME

Line 9: | PL/SQL body for package: PO_EMAIL_GENERATE

5: | FILENAME
6: | POXWPAMB.pls
7: |
8: | DESCRIPTION
9: | PL/SQL body for package: PO_EMAIL_GENERATE
10: |
11: | NOTES Diwas Kc Created 02/09/01
12: | Created for generating the header and body of a PO Email notification.
13: | MODIFIED (MM/DD/YY)

Line 34: c_log_head CONSTANT VARCHAR2(30) := 'po.plsql.PO_EMAIL_GENERATE.'; -- Bug 2792156

30: | 4. All code changes done in procedure generate_html().
31: | Search for keyword TIMEPHASED.
32: *=======================================================================*/
33:
34: c_log_head CONSTANT VARCHAR2(30) := 'po.plsql.PO_EMAIL_GENERATE.'; -- Bug 2792156
35:
36: g_po_wf_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('PO_SET_DEBUG_WORKFLOW_ON'),'N'); -- BUG 9858430
37:
38: TYPE shipment_record IS RECORD (

Line 473: l_progress := 'PO_EMAIL_GENERATE.GENERATE_HTML';

469: l_org_id := wf_engine.GetItemAttrNumber ( itemtype => l_item_type,
470: itemkey => l_item_key,
471: aname => 'ORG_ID');
472:
473: l_progress := 'PO_EMAIL_GENERATE.GENERATE_HTML';
474: IF (g_po_wf_debug = 'Y') THEN
475: PO_WF_DEBUG_PKG.insert_debug('itemtype','itemkey','l_item_type= ' || l_item_type);
476: PO_WF_DEBUG_PKG.insert_debug('itemtype','itemkey','l_item_key= ' || l_item_key);
477: PO_WF_DEBUG_PKG.insert_debug('itemtype','itemkey','l_document_id= ' || l_document_id);

Line 2802: l_progress := 'PO_EMAIL_GENERATE.GENERATE_HEADER';

2798: l_org_id := wf_engine.GetItemAttrNumber ( itemtype => l_item_type,
2799: itemkey => l_item_key,
2800: aname => 'ORG_ID');
2801:
2802: l_progress := 'PO_EMAIL_GENERATE.GENERATE_HEADER';
2803: IF (g_po_wf_debug = 'Y') THEN
2804: PO_WF_DEBUG_PKG.insert_debug(l_item_type,l_item_key,l_progress);
2805: PO_WF_DEBUG_PKG.insert_debug(l_item_type,l_item_key,'l_item_type= ' || l_item_type);
2806: PO_WF_DEBUG_PKG.insert_debug(l_item_type,l_item_key,'l_item_key= ' || l_item_key);

Line 4636: l_progress := 'PO_EMAIL_GENERATE.GENERATE_TERMS';

4632: l_org_id := wf_engine.GetItemAttrNumber ( itemtype => l_item_type,
4633: itemkey => l_item_key,
4634: aname => 'ORG_ID');
4635:
4636: l_progress := 'PO_EMAIL_GENERATE.GENERATE_TERMS';
4637: IF (g_po_wf_debug = 'Y') THEN
4638: PO_WF_DEBUG_PKG.insert_debug(l_item_type,l_item_key,l_progress);
4639: PO_WF_DEBUG_PKG.insert_debug(l_item_type,l_item_key,'l_item_type= ' || l_item_type);
4640: PO_WF_DEBUG_PKG.insert_debug(l_item_type,l_item_key,'l_item_key= ' || l_item_key);

Line 4878: END PO_EMAIL_GENERATE;

4874: UTL_FILE.FCLOSE(v_filehandle);
4875: END;
4876:
4877:
4878: END PO_EMAIL_GENERATE;