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_SYNC_DRAFT_FROM_ARCHIVE_PVT dependencies on PO_LOG

Line 5: PO_LOG.get_package_base('PO_SYNC_DRAFT_FROM_ARCHIVE_PVT');

1: PACKAGE BODY PO_SYNC_DRAFT_FROM_ARCHIVE_PVT AS
2: /* $Header: PO_SYNC_DRAFT_FROM_ARCHIVE_PVT.plb 120.4.12020000.3 2013/04/30 06:41:49 mabaig ship $ */
3:
4: d_pkg_name CONSTANT varchar2(50) :=
5: PO_LOG.get_package_base('PO_SYNC_DRAFT_FROM_ARCHIVE_PVT');
6:
7: -------------------------------------------------------------------------------
8: --Start of Comments
9: --Name: CHECK_PO_SYNC

Line 47: IF (PO_LOG.d_proc) THEN

43:
44: BEGIN
45:
46: d_position := 0;
47: IF (PO_LOG.d_proc) THEN
48: PO_LOG.proc_begin(d_module,'p_po_header_id',p_document_id);
49: END IF;
50:
51: d_position := 10;

Line 48: PO_LOG.proc_begin(d_module,'p_po_header_id',p_document_id);

44: BEGIN
45:
46: d_position := 0;
47: IF (PO_LOG.d_proc) THEN
48: PO_LOG.proc_begin(d_module,'p_po_header_id',p_document_id);
49: END IF;
50:
51: d_position := 10;
52: IF (PO_LOG.d_stmt) THEN

Line 52: IF (PO_LOG.d_stmt) THEN

48: PO_LOG.proc_begin(d_module,'p_po_header_id',p_document_id);
49: END IF;
50:
51: d_position := 10;
52: IF (PO_LOG.d_stmt) THEN
53: PO_LOG.stmt(d_module, d_position, 'Check if the PO has already been synced from archive -> dft');
54: END IF;
55: -- SQL What: Select record from Draft which has been copied from Archive
56: -- SQL Why : Check if the document has already been synced from archive to Draft

Line 53: PO_LOG.stmt(d_module, d_position, 'Check if the PO has already been synced from archive -> dft');

49: END IF;
50:
51: d_position := 10;
52: IF (PO_LOG.d_stmt) THEN
53: PO_LOG.stmt(d_module, d_position, 'Check if the PO has already been synced from archive -> dft');
54: END IF;
55: -- SQL What: Select record from Draft which has been copied from Archive
56: -- SQL Why : Check if the document has already been synced from archive to Draft
57: SELECT 'Y' INTO x_return_status

Line 66: IF (PO_LOG.d_stmt) THEN

62: AND pd.document_id = pha.po_header_id (+)
63: AND pd.draft_id = p_draft_id; --Always passed as 0 for Revision 0 Documents
64:
65: d_position := 20;
66: IF (PO_LOG.d_stmt) THEN
67: PO_LOG.stmt(d_module, d_position, 'Archive -> Dft Sync has already been done');
68: END IF;
69:
70: d_position := 30;

Line 67: PO_LOG.stmt(d_module, d_position, 'Archive -> Dft Sync has already been done');

63: AND pd.draft_id = p_draft_id; --Always passed as 0 for Revision 0 Documents
64:
65: d_position := 20;
66: IF (PO_LOG.d_stmt) THEN
67: PO_LOG.stmt(d_module, d_position, 'Archive -> Dft Sync has already been done');
68: END IF;
69:
70: d_position := 30;
71: IF (PO_LOG.d_proc) THEN

Line 71: IF (PO_LOG.d_proc) THEN

67: PO_LOG.stmt(d_module, d_position, 'Archive -> Dft Sync has already been done');
68: END IF;
69:
70: d_position := 30;
71: IF (PO_LOG.d_proc) THEN
72: PO_LOG.proc_end(d_module);
73: END IF;
74:
75: EXCEPTION

Line 72: PO_LOG.proc_end(d_module);

68: END IF;
69:
70: d_position := 30;
71: IF (PO_LOG.d_proc) THEN
72: PO_LOG.proc_end(d_module);
73: END IF;
74:
75: EXCEPTION
76: WHEN No_Data_Found THEN

Line 119: IF (PO_LOG.d_proc) THEN

115:
116: BEGIN
117:
118: d_position := 0;
119: IF (PO_LOG.d_proc) THEN
120: PO_LOG.proc_begin(d_module,'p_draft_id',p_draft_id);
121: END IF;
122:
123: d_position := 10;

Line 120: PO_LOG.proc_begin(d_module,'p_draft_id',p_draft_id);

116: BEGIN
117:
118: d_position := 0;
119: IF (PO_LOG.d_proc) THEN
120: PO_LOG.proc_begin(d_module,'p_draft_id',p_draft_id);
121: END IF;
122:
123: d_position := 10;
124: IF (PO_LOG.d_proc) THEN

Line 124: IF (PO_LOG.d_proc) THEN

120: PO_LOG.proc_begin(d_module,'p_draft_id',p_draft_id);
121: END IF;
122:
123: d_position := 10;
124: IF (PO_LOG.d_proc) THEN
125: PO_LOG.proc_begin(d_module,'Delete all entries from DRAFT Tables having draft_id: ',p_draft_id);
126: END IF;
127:
128: --Deleting from po_drafts

Line 125: PO_LOG.proc_begin(d_module,'Delete all entries from DRAFT Tables having draft_id: ',p_draft_id);

121: END IF;
122:
123: d_position := 10;
124: IF (PO_LOG.d_proc) THEN
125: PO_LOG.proc_begin(d_module,'Delete all entries from DRAFT Tables having draft_id: ',p_draft_id);
126: END IF;
127:
128: --Deleting from po_drafts
129: DELETE FROM po_drafts

Line 198: IF (PO_LOG.d_stmt) THEN

194: DELETE FROM po_exhibit_details_draft
195: WHERE draft_id = p_draft_id;
196:
197: d_position := 20;
198: IF (PO_LOG.d_stmt) THEN
199: PO_LOG.stmt(d_module, d_position, 'Rows deleted from DRAFT Tables');
200: END IF;
201:
202: d_position := 30;

Line 199: PO_LOG.stmt(d_module, d_position, 'Rows deleted from DRAFT Tables');

195: WHERE draft_id = p_draft_id;
196:
197: d_position := 20;
198: IF (PO_LOG.d_stmt) THEN
199: PO_LOG.stmt(d_module, d_position, 'Rows deleted from DRAFT Tables');
200: END IF;
201:
202: d_position := 30;
203: IF (PO_LOG.d_proc) THEN

Line 203: IF (PO_LOG.d_proc) THEN

199: PO_LOG.stmt(d_module, d_position, 'Rows deleted from DRAFT Tables');
200: END IF;
201:
202: d_position := 30;
203: IF (PO_LOG.d_proc) THEN
204: PO_LOG.proc_end(d_module);
205: END IF;
206:
207: EXCEPTION

Line 204: PO_LOG.proc_end(d_module);

200: END IF;
201:
202: d_position := 30;
203: IF (PO_LOG.d_proc) THEN
204: PO_LOG.proc_end(d_module);
205: END IF;
206:
207: EXCEPTION
208: WHEN OTHERS THEN

Line 251: IF (PO_LOG.d_proc) THEN

247:
248: BEGIN
249:
250: d_position := 0;
251: IF (PO_LOG.d_proc) THEN
252: PO_LOG.proc_begin(d_module,'p_po_header_id',p_document_id);
253: END IF;
254:
255: d_position := 10;

Line 252: PO_LOG.proc_begin(d_module,'p_po_header_id',p_document_id);

248: BEGIN
249:
250: d_position := 0;
251: IF (PO_LOG.d_proc) THEN
252: PO_LOG.proc_begin(d_module,'p_po_header_id',p_document_id);
253: END IF;
254:
255: d_position := 10;
256: IF (PO_LOG.d_stmt) THEN

Line 256: IF (PO_LOG.d_stmt) THEN

252: PO_LOG.proc_begin(d_module,'p_po_header_id',p_document_id);
253: END IF;
254:
255: d_position := 10;
256: IF (PO_LOG.d_stmt) THEN
257: PO_LOG.stmt(d_module, d_position, 'Insert Dummy row in PO_DRAFTS with DRAFT_ID = 0');
258: END IF;
259:
260: INSERT INTO po_drafts

Line 257: PO_LOG.stmt(d_module, d_position, 'Insert Dummy row in PO_DRAFTS with DRAFT_ID = 0');

253: END IF;
254:
255: d_position := 10;
256: IF (PO_LOG.d_stmt) THEN
257: PO_LOG.stmt(d_module, d_position, 'Insert Dummy row in PO_DRAFTS with DRAFT_ID = 0');
258: END IF;
259:
260: INSERT INTO po_drafts
261: (draft_id,

Line 288: IF (PO_LOG.d_stmt) THEN

284: FND_GLOBAL.user_id
285: );
286:
287: d_position := 20;
288: IF (PO_LOG.d_stmt) THEN
289: PO_LOG.stmt(d_module, d_position, 'Row inserted into PO_DRAFTS');
290: END IF;
291:
292: d_position := 30;

Line 289: PO_LOG.stmt(d_module, d_position, 'Row inserted into PO_DRAFTS');

285: );
286:
287: d_position := 20;
288: IF (PO_LOG.d_stmt) THEN
289: PO_LOG.stmt(d_module, d_position, 'Row inserted into PO_DRAFTS');
290: END IF;
291:
292: d_position := 30;
293: IF (PO_LOG.d_proc) THEN

Line 293: IF (PO_LOG.d_proc) THEN

289: PO_LOG.stmt(d_module, d_position, 'Row inserted into PO_DRAFTS');
290: END IF;
291:
292: d_position := 30;
293: IF (PO_LOG.d_proc) THEN
294: PO_LOG.proc_end(d_module);
295: END IF;
296:
297: EXCEPTION

Line 294: PO_LOG.proc_end(d_module);

290: END IF;
291:
292: d_position := 30;
293: IF (PO_LOG.d_proc) THEN
294: PO_LOG.proc_end(d_module);
295: END IF;
296:
297: EXCEPTION
298: WHEN OTHERS THEN

Line 342: IF (PO_LOG.d_proc) THEN

338:
339: BEGIN
340:
341: d_position := 0;
342: IF (PO_LOG.d_proc) THEN
343: PO_LOG.proc_begin(d_module,'p_po_header_id',p_document_id);
344: END IF;
345:
346: d_position := 10;

Line 343: PO_LOG.proc_begin(d_module,'p_po_header_id',p_document_id);

339: BEGIN
340:
341: d_position := 0;
342: IF (PO_LOG.d_proc) THEN
343: PO_LOG.proc_begin(d_module,'p_po_header_id',p_document_id);
344: END IF;
345:
346: d_position := 10;
347: IF (PO_LOG.d_stmt) THEN

Line 347: IF (PO_LOG.d_stmt) THEN

343: PO_LOG.proc_begin(d_module,'p_po_header_id',p_document_id);
344: END IF;
345:
346: d_position := 10;
347: IF (PO_LOG.d_stmt) THEN
348: PO_LOG.stmt(d_module, d_position, 'transfer records from archive to dft');
349: END IF;
350:
351: INSERT INTO po_headers_draft_all

Line 348: PO_LOG.stmt(d_module, d_position, 'transfer records from archive to dft');

344: END IF;
345:
346: d_position := 10;
347: IF (PO_LOG.d_stmt) THEN
348: PO_LOG.stmt(d_module, d_position, 'transfer records from archive to dft');
349: END IF;
350:
351: INSERT INTO po_headers_draft_all
352: ( draft_id,

Line 748: IF (PO_LOG.d_stmt) THEN

744: AND revision_num = p_revision_num;
745:
746:
747: d_position := 20;
748: IF (PO_LOG.d_stmt) THEN
749: PO_LOG.stmt(d_module, d_position, 'transfer count = ' || SQL%ROWCOUNT);
750: END IF;
751:
752: d_position := 30;

Line 749: PO_LOG.stmt(d_module, d_position, 'transfer count = ' || SQL%ROWCOUNT);

745:
746:
747: d_position := 20;
748: IF (PO_LOG.d_stmt) THEN
749: PO_LOG.stmt(d_module, d_position, 'transfer count = ' || SQL%ROWCOUNT);
750: END IF;
751:
752: d_position := 30;
753:

Line 754: IF (PO_LOG.d_proc) THEN

750: END IF;
751:
752: d_position := 30;
753:
754: IF (PO_LOG.d_proc) THEN
755: PO_LOG.proc_end(d_module);
756: END IF;
757:
758: EXCEPTION

Line 755: PO_LOG.proc_end(d_module);

751:
752: d_position := 30;
753:
754: IF (PO_LOG.d_proc) THEN
755: PO_LOG.proc_end(d_module);
756: END IF;
757:
758: EXCEPTION
759: WHEN OTHERS THEN

Line 802: IF (PO_LOG.d_proc) THEN

798:
799: BEGIN
800:
801: d_position := 0;
802: IF (PO_LOG.d_proc) THEN
803: PO_LOG.proc_begin(d_module,'p_po_header_id',p_document_id);
804: END IF;
805:
806: d_position := 10;

Line 803: PO_LOG.proc_begin(d_module,'p_po_header_id',p_document_id);

799: BEGIN
800:
801: d_position := 0;
802: IF (PO_LOG.d_proc) THEN
803: PO_LOG.proc_begin(d_module,'p_po_header_id',p_document_id);
804: END IF;
805:
806: d_position := 10;
807: IF (PO_LOG.d_stmt) THEN

Line 807: IF (PO_LOG.d_stmt) THEN

803: PO_LOG.proc_begin(d_module,'p_po_header_id',p_document_id);
804: END IF;
805:
806: d_position := 10;
807: IF (PO_LOG.d_stmt) THEN
808: PO_LOG.stmt(d_module, d_position, 'transfer records from archive to dft');
809: END IF;
810:
811: INSERT INTO po_lines_draft_all

Line 808: PO_LOG.stmt(d_module, d_position, 'transfer records from archive to dft');

804: END IF;
805:
806: d_position := 10;
807: IF (PO_LOG.d_stmt) THEN
808: PO_LOG.stmt(d_module, d_position, 'transfer records from archive to dft');
809: END IF;
810:
811: INSERT INTO po_lines_draft_all
812: (

Line 1201: IF (PO_LOG.d_stmt) THEN

1197: AND revision_num = p_revision_num;
1198: --UCA Project - CLM R4 changes Begin;
1199:
1200: d_position := 20;
1201: IF (PO_LOG.d_stmt) THEN
1202: PO_LOG.stmt(d_module, d_position, 'transfer count = ' || SQL%ROWCOUNT);
1203: END IF;
1204:
1205: d_position := 30;

Line 1202: PO_LOG.stmt(d_module, d_position, 'transfer count = ' || SQL%ROWCOUNT);

1198: --UCA Project - CLM R4 changes Begin;
1199:
1200: d_position := 20;
1201: IF (PO_LOG.d_stmt) THEN
1202: PO_LOG.stmt(d_module, d_position, 'transfer count = ' || SQL%ROWCOUNT);
1203: END IF;
1204:
1205: d_position := 30;
1206:

Line 1207: IF (PO_LOG.d_proc) THEN

1203: END IF;
1204:
1205: d_position := 30;
1206:
1207: IF (PO_LOG.d_proc) THEN
1208: PO_LOG.proc_end(d_module);
1209: END IF;
1210:
1211: EXCEPTION

Line 1208: PO_LOG.proc_end(d_module);

1204:
1205: d_position := 30;
1206:
1207: IF (PO_LOG.d_proc) THEN
1208: PO_LOG.proc_end(d_module);
1209: END IF;
1210:
1211: EXCEPTION
1212: WHEN OTHERS THEN

Line 1254: IF (PO_LOG.d_proc) THEN

1250:
1251: BEGIN
1252:
1253: d_position := 0;
1254: IF (PO_LOG.d_proc) THEN
1255: PO_LOG.proc_begin(d_module,'p_po_header_id',p_document_id);
1256: END IF;
1257:
1258: d_position := 10;

Line 1255: PO_LOG.proc_begin(d_module,'p_po_header_id',p_document_id);

1251: BEGIN
1252:
1253: d_position := 0;
1254: IF (PO_LOG.d_proc) THEN
1255: PO_LOG.proc_begin(d_module,'p_po_header_id',p_document_id);
1256: END IF;
1257:
1258: d_position := 10;
1259: IF (PO_LOG.d_stmt) THEN

Line 1259: IF (PO_LOG.d_stmt) THEN

1255: PO_LOG.proc_begin(d_module,'p_po_header_id',p_document_id);
1256: END IF;
1257:
1258: d_position := 10;
1259: IF (PO_LOG.d_stmt) THEN
1260: PO_LOG.stmt(d_module, d_position, 'transfer records from archive to dft');
1261: END IF;
1262:
1263: INSERT INTO po_line_locations_draft_all

Line 1260: PO_LOG.stmt(d_module, d_position, 'transfer records from archive to dft');

1256: END IF;
1257:
1258: d_position := 10;
1259: IF (PO_LOG.d_stmt) THEN
1260: PO_LOG.stmt(d_module, d_position, 'transfer records from archive to dft');
1261: END IF;
1262:
1263: INSERT INTO po_line_locations_draft_all
1264: ( draft_id,

Line 1629: IF (PO_LOG.d_stmt) THEN

1625: WHERE po_header_id = p_document_id
1626: AND revision_num = p_revision_num;
1627:
1628: d_position := 20;
1629: IF (PO_LOG.d_stmt) THEN
1630: PO_LOG.stmt(d_module, d_position, 'transfer count = ' || SQL%ROWCOUNT);
1631: END IF;
1632:
1633: d_position := 30;

Line 1630: PO_LOG.stmt(d_module, d_position, 'transfer count = ' || SQL%ROWCOUNT);

1626: AND revision_num = p_revision_num;
1627:
1628: d_position := 20;
1629: IF (PO_LOG.d_stmt) THEN
1630: PO_LOG.stmt(d_module, d_position, 'transfer count = ' || SQL%ROWCOUNT);
1631: END IF;
1632:
1633: d_position := 30;
1634:

Line 1635: IF (PO_LOG.d_proc) THEN

1631: END IF;
1632:
1633: d_position := 30;
1634:
1635: IF (PO_LOG.d_proc) THEN
1636: PO_LOG.proc_end(d_module);
1637: END IF;
1638:
1639: EXCEPTION

Line 1636: PO_LOG.proc_end(d_module);

1632:
1633: d_position := 30;
1634:
1635: IF (PO_LOG.d_proc) THEN
1636: PO_LOG.proc_end(d_module);
1637: END IF;
1638:
1639: EXCEPTION
1640: WHEN OTHERS THEN

Line 1683: IF (PO_LOG.d_proc) THEN

1679:
1680: BEGIN
1681:
1682: d_position := 0;
1683: IF (PO_LOG.d_proc) THEN
1684: PO_LOG.proc_begin(d_module,'p_po_header_id',p_document_id);
1685: END IF;
1686:
1687: d_position := 10;

Line 1684: PO_LOG.proc_begin(d_module,'p_po_header_id',p_document_id);

1680: BEGIN
1681:
1682: d_position := 0;
1683: IF (PO_LOG.d_proc) THEN
1684: PO_LOG.proc_begin(d_module,'p_po_header_id',p_document_id);
1685: END IF;
1686:
1687: d_position := 10;
1688: IF (PO_LOG.d_stmt) THEN

Line 1688: IF (PO_LOG.d_stmt) THEN

1684: PO_LOG.proc_begin(d_module,'p_po_header_id',p_document_id);
1685: END IF;
1686:
1687: d_position := 10;
1688: IF (PO_LOG.d_stmt) THEN
1689: PO_LOG.stmt(d_module, d_position, 'transfer records from archive to dft');
1690: END IF;
1691:
1692: INSERT INTO po_distributions_draft_all

Line 1689: PO_LOG.stmt(d_module, d_position, 'transfer records from archive to dft');

1685: END IF;
1686:
1687: d_position := 10;
1688: IF (PO_LOG.d_stmt) THEN
1689: PO_LOG.stmt(d_module, d_position, 'transfer records from archive to dft');
1690: END IF;
1691:
1692: INSERT INTO po_distributions_draft_all
1693: (

Line 1955: IF (PO_LOG.d_stmt) THEN

1951: WHERE po_header_id = p_document_id
1952: AND revision_num = p_revision_num;
1953:
1954: d_position := 20;
1955: IF (PO_LOG.d_stmt) THEN
1956: PO_LOG.stmt(d_module, d_position, 'transfer count = ' || SQL%ROWCOUNT);
1957: END IF;
1958:
1959: d_position := 30;

Line 1956: PO_LOG.stmt(d_module, d_position, 'transfer count = ' || SQL%ROWCOUNT);

1952: AND revision_num = p_revision_num;
1953:
1954: d_position := 20;
1955: IF (PO_LOG.d_stmt) THEN
1956: PO_LOG.stmt(d_module, d_position, 'transfer count = ' || SQL%ROWCOUNT);
1957: END IF;
1958:
1959: d_position := 30;
1960:

Line 1961: IF (PO_LOG.d_proc) THEN

1957: END IF;
1958:
1959: d_position := 30;
1960:
1961: IF (PO_LOG.d_proc) THEN
1962: PO_LOG.proc_end(d_module);
1963: END IF;
1964:
1965: EXCEPTION

Line 1962: PO_LOG.proc_end(d_module);

1958:
1959: d_position := 30;
1960:
1961: IF (PO_LOG.d_proc) THEN
1962: PO_LOG.proc_end(d_module);
1963: END IF;
1964:
1965: EXCEPTION
1966: WHEN OTHERS THEN

Line 2008: IF (PO_LOG.d_proc) THEN

2004:
2005: BEGIN
2006:
2007: d_position := 0;
2008: IF (PO_LOG.d_proc) THEN
2009: PO_LOG.proc_begin(d_module,'p_po_header_id',p_document_id);
2010: END IF;
2011:
2012: d_position := 10;

Line 2009: PO_LOG.proc_begin(d_module,'p_po_header_id',p_document_id);

2005: BEGIN
2006:
2007: d_position := 0;
2008: IF (PO_LOG.d_proc) THEN
2009: PO_LOG.proc_begin(d_module,'p_po_header_id',p_document_id);
2010: END IF;
2011:
2012: d_position := 10;
2013: IF (PO_LOG.d_stmt) THEN

Line 2013: IF (PO_LOG.d_stmt) THEN

2009: PO_LOG.proc_begin(d_module,'p_po_header_id',p_document_id);
2010: END IF;
2011:
2012: d_position := 10;
2013: IF (PO_LOG.d_stmt) THEN
2014: PO_LOG.stmt(d_module, d_position, 'transfer records from archive to dft');
2015: END IF;
2016:
2017: INSERT INTO po_ga_org_assign_draft

Line 2014: PO_LOG.stmt(d_module, d_position, 'transfer records from archive to dft');

2010: END IF;
2011:
2012: d_position := 10;
2013: IF (PO_LOG.d_stmt) THEN
2014: PO_LOG.stmt(d_module, d_position, 'transfer records from archive to dft');
2015: END IF;
2016:
2017: INSERT INTO po_ga_org_assign_draft
2018: (

Line 2056: IF (PO_LOG.d_stmt) THEN

2052: WHERE po_header_id = p_document_id
2053: AND revision_num = p_revision_num;
2054:
2055: d_position := 20;
2056: IF (PO_LOG.d_stmt) THEN
2057: PO_LOG.stmt(d_module, d_position, 'transfer count = ' || SQL%ROWCOUNT);
2058: END IF;
2059:
2060: d_position := 30;

Line 2057: PO_LOG.stmt(d_module, d_position, 'transfer count = ' || SQL%ROWCOUNT);

2053: AND revision_num = p_revision_num;
2054:
2055: d_position := 20;
2056: IF (PO_LOG.d_stmt) THEN
2057: PO_LOG.stmt(d_module, d_position, 'transfer count = ' || SQL%ROWCOUNT);
2058: END IF;
2059:
2060: d_position := 30;
2061:

Line 2062: IF (PO_LOG.d_proc) THEN

2058: END IF;
2059:
2060: d_position := 30;
2061:
2062: IF (PO_LOG.d_proc) THEN
2063: PO_LOG.proc_end(d_module);
2064: END IF;
2065:
2066: EXCEPTION

Line 2063: PO_LOG.proc_end(d_module);

2059:
2060: d_position := 30;
2061:
2062: IF (PO_LOG.d_proc) THEN
2063: PO_LOG.proc_end(d_module);
2064: END IF;
2065:
2066: EXCEPTION
2067: WHEN OTHERS THEN

Line 2113: IF (PO_LOG.d_proc) THEN

2109:
2110: BEGIN
2111:
2112: d_position := 0;
2113: IF (PO_LOG.d_proc) THEN
2114: PO_LOG.proc_begin(d_module,'p_po_header_id',p_document_id);
2115: PO_LOG.proc_begin(d_module,'p_entity_type',p_entity_type);
2116: END IF;
2117:

Line 2114: PO_LOG.proc_begin(d_module,'p_po_header_id',p_document_id);

2110: BEGIN
2111:
2112: d_position := 0;
2113: IF (PO_LOG.d_proc) THEN
2114: PO_LOG.proc_begin(d_module,'p_po_header_id',p_document_id);
2115: PO_LOG.proc_begin(d_module,'p_entity_type',p_entity_type);
2116: END IF;
2117:
2118: d_position := 10;

Line 2115: PO_LOG.proc_begin(d_module,'p_entity_type',p_entity_type);

2111:
2112: d_position := 0;
2113: IF (PO_LOG.d_proc) THEN
2114: PO_LOG.proc_begin(d_module,'p_po_header_id',p_document_id);
2115: PO_LOG.proc_begin(d_module,'p_entity_type',p_entity_type);
2116: END IF;
2117:
2118: d_position := 10;
2119: IF (PO_LOG.d_stmt) THEN

Line 2119: IF (PO_LOG.d_stmt) THEN

2115: PO_LOG.proc_begin(d_module,'p_entity_type',p_entity_type);
2116: END IF;
2117:
2118: d_position := 10;
2119: IF (PO_LOG.d_stmt) THEN
2120: PO_LOG.stmt(d_module, d_position, 'transfer records from archive to dft');
2121: END IF;
2122:
2123: INSERT INTO po_price_diff_draft

Line 2120: PO_LOG.stmt(d_module, d_position, 'transfer records from archive to dft');

2116: END IF;
2117:
2118: d_position := 10;
2119: IF (PO_LOG.d_stmt) THEN
2120: PO_LOG.stmt(d_module, d_position, 'transfer records from archive to dft');
2121: END IF;
2122:
2123: INSERT INTO po_price_diff_draft
2124: (

Line 2176: IF (PO_LOG.d_stmt) THEN

2172: AND POR.entity_type = p_entity_type
2173: AND POR.revision_num = p_revision_num;
2174:
2175: d_position := 20;
2176: IF (PO_LOG.d_stmt) THEN
2177: PO_LOG.stmt(d_module, d_position, 'transfer count = ' || SQL%ROWCOUNT);
2178: END IF;
2179:
2180: d_position := 30;

Line 2177: PO_LOG.stmt(d_module, d_position, 'transfer count = ' || SQL%ROWCOUNT);

2173: AND POR.revision_num = p_revision_num;
2174:
2175: d_position := 20;
2176: IF (PO_LOG.d_stmt) THEN
2177: PO_LOG.stmt(d_module, d_position, 'transfer count = ' || SQL%ROWCOUNT);
2178: END IF;
2179:
2180: d_position := 30;
2181:

Line 2182: IF (PO_LOG.d_proc) THEN

2178: END IF;
2179:
2180: d_position := 30;
2181:
2182: IF (PO_LOG.d_proc) THEN
2183: PO_LOG.proc_end(d_module);
2184: END IF;
2185:
2186: EXCEPTION

Line 2183: PO_LOG.proc_end(d_module);

2179:
2180: d_position := 30;
2181:
2182: IF (PO_LOG.d_proc) THEN
2183: PO_LOG.proc_end(d_module);
2184: END IF;
2185:
2186: EXCEPTION
2187: WHEN OTHERS THEN

Line 2230: IF (PO_LOG.d_proc) THEN

2226:
2227: BEGIN
2228:
2229: d_position := 0;
2230: IF (PO_LOG.d_proc) THEN
2231: PO_LOG.proc_begin(d_module,'p_po_header_id',p_document_id);
2232: END IF;
2233:
2234: d_position := 10;

Line 2231: PO_LOG.proc_begin(d_module,'p_po_header_id',p_document_id);

2227: BEGIN
2228:
2229: d_position := 0;
2230: IF (PO_LOG.d_proc) THEN
2231: PO_LOG.proc_begin(d_module,'p_po_header_id',p_document_id);
2232: END IF;
2233:
2234: d_position := 10;
2235: IF (PO_LOG.d_stmt) THEN

Line 2235: IF (PO_LOG.d_stmt) THEN

2231: PO_LOG.proc_begin(d_module,'p_po_header_id',p_document_id);
2232: END IF;
2233:
2234: d_position := 10;
2235: IF (PO_LOG.d_stmt) THEN
2236: PO_LOG.stmt(d_module, d_position, 'transfer records from archive to dft');
2237: END IF;
2238:
2239: INSERT INTO po_attribute_values_draft

Line 2236: PO_LOG.stmt(d_module, d_position, 'transfer records from archive to dft');

2232: END IF;
2233:
2234: d_position := 10;
2235: IF (PO_LOG.d_stmt) THEN
2236: PO_LOG.stmt(d_module, d_position, 'transfer records from archive to dft');
2237: END IF;
2238:
2239: INSERT INTO po_attribute_values_draft
2240: ( draft_id,

Line 2907: IF (PO_LOG.d_stmt) THEN

2903: AND POL.po_header_id = p_document_id
2904: AND ATTR.revision_num = p_revision_num;
2905:
2906: d_position := 20;
2907: IF (PO_LOG.d_stmt) THEN
2908: PO_LOG.stmt(d_module, d_position, 'transfer count = ' || SQL%ROWCOUNT);
2909: END IF;
2910:
2911: d_position := 30;

Line 2908: PO_LOG.stmt(d_module, d_position, 'transfer count = ' || SQL%ROWCOUNT);

2904: AND ATTR.revision_num = p_revision_num;
2905:
2906: d_position := 20;
2907: IF (PO_LOG.d_stmt) THEN
2908: PO_LOG.stmt(d_module, d_position, 'transfer count = ' || SQL%ROWCOUNT);
2909: END IF;
2910:
2911: d_position := 30;
2912:

Line 2913: IF (PO_LOG.d_proc) THEN

2909: END IF;
2910:
2911: d_position := 30;
2912:
2913: IF (PO_LOG.d_proc) THEN
2914: PO_LOG.proc_end(d_module);
2915: END IF;
2916:
2917: EXCEPTION

Line 2914: PO_LOG.proc_end(d_module);

2910:
2911: d_position := 30;
2912:
2913: IF (PO_LOG.d_proc) THEN
2914: PO_LOG.proc_end(d_module);
2915: END IF;
2916:
2917: EXCEPTION
2918: WHEN OTHERS THEN

Line 2960: IF (PO_LOG.d_proc) THEN

2956:
2957: BEGIN
2958:
2959: d_position := 0;
2960: IF (PO_LOG.d_proc) THEN
2961: PO_LOG.proc_begin(d_module,'p_po_header_id',p_document_id);
2962: END IF;
2963:
2964: d_position := 10;

Line 2961: PO_LOG.proc_begin(d_module,'p_po_header_id',p_document_id);

2957: BEGIN
2958:
2959: d_position := 0;
2960: IF (PO_LOG.d_proc) THEN
2961: PO_LOG.proc_begin(d_module,'p_po_header_id',p_document_id);
2962: END IF;
2963:
2964: d_position := 10;
2965: IF (PO_LOG.d_stmt) THEN

Line 2965: IF (PO_LOG.d_stmt) THEN

2961: PO_LOG.proc_begin(d_module,'p_po_header_id',p_document_id);
2962: END IF;
2963:
2964: d_position := 10;
2965: IF (PO_LOG.d_stmt) THEN
2966: PO_LOG.stmt(d_module, d_position, 'transfer records from archive to dft');
2967: END IF;
2968:
2969: INSERT INTO po_attribute_values_tlp_draft

Line 2966: PO_LOG.stmt(d_module, d_position, 'transfer records from archive to dft');

2962: END IF;
2963:
2964: d_position := 10;
2965: IF (PO_LOG.d_stmt) THEN
2966: PO_LOG.stmt(d_module, d_position, 'transfer records from archive to dft');
2967: END IF;
2968:
2969: INSERT INTO po_attribute_values_tlp_draft
2970: (draft_id,

Line 3332: IF (PO_LOG.d_stmt) THEN

3328: AND TLP.revision_num = p_revision_num;
3329:
3330:
3331: d_position := 20;
3332: IF (PO_LOG.d_stmt) THEN
3333: PO_LOG.stmt(d_module, d_position, 'transfer count = ' || SQL%ROWCOUNT);
3334: END IF;
3335:
3336: d_position := 30;

Line 3333: PO_LOG.stmt(d_module, d_position, 'transfer count = ' || SQL%ROWCOUNT);

3329:
3330:
3331: d_position := 20;
3332: IF (PO_LOG.d_stmt) THEN
3333: PO_LOG.stmt(d_module, d_position, 'transfer count = ' || SQL%ROWCOUNT);
3334: END IF;
3335:
3336: d_position := 30;
3337:

Line 3338: IF (PO_LOG.d_proc) THEN

3334: END IF;
3335:
3336: d_position := 30;
3337:
3338: IF (PO_LOG.d_proc) THEN
3339: PO_LOG.proc_end(d_module);
3340: END IF;
3341:
3342: EXCEPTION

Line 3339: PO_LOG.proc_end(d_module);

3335:
3336: d_position := 30;
3337:
3338: IF (PO_LOG.d_proc) THEN
3339: PO_LOG.proc_end(d_module);
3340: END IF;
3341:
3342: EXCEPTION
3343: WHEN OTHERS THEN

Line 3385: IF (PO_LOG.d_proc) THEN

3381:
3382: BEGIN
3383:
3384: d_position := 0;
3385: IF (PO_LOG.d_proc) THEN
3386: PO_LOG.proc_begin(d_module,'p_po_header_id',p_document_id);
3387: END IF;
3388:
3389: d_position := 10;

Line 3386: PO_LOG.proc_begin(d_module,'p_po_header_id',p_document_id);

3382: BEGIN
3383:
3384: d_position := 0;
3385: IF (PO_LOG.d_proc) THEN
3386: PO_LOG.proc_begin(d_module,'p_po_header_id',p_document_id);
3387: END IF;
3388:
3389: d_position := 10;
3390: IF (PO_LOG.d_stmt) THEN

Line 3390: IF (PO_LOG.d_stmt) THEN

3386: PO_LOG.proc_begin(d_module,'p_po_header_id',p_document_id);
3387: END IF;
3388:
3389: d_position := 10;
3390: IF (PO_LOG.d_stmt) THEN
3391: PO_LOG.stmt(d_module, d_position, 'transfer records from archive to dft');
3392: END IF;
3393:
3394: INSERT INTO PO_PRICE_ADJUSTMENTS_DRAFT

Line 3391: PO_LOG.stmt(d_module, d_position, 'transfer records from archive to dft');

3387: END IF;
3388:
3389: d_position := 10;
3390: IF (PO_LOG.d_stmt) THEN
3391: PO_LOG.stmt(d_module, d_position, 'transfer records from archive to dft');
3392: END IF;
3393:
3394: INSERT INTO PO_PRICE_ADJUSTMENTS_DRAFT
3395: (DRAFT_ID

Line 3604: IF (PO_LOG.d_stmt) THEN

3600: AND POL.po_header_id = p_document_id
3601: AND ADJ.revision_num = p_revision_num;
3602:
3603: d_position := 20;
3604: IF (PO_LOG.d_stmt) THEN
3605: PO_LOG.stmt(d_module, d_position, 'transfer count = ' || SQL%ROWCOUNT);
3606: END IF;
3607:
3608: d_position := 30;

Line 3605: PO_LOG.stmt(d_module, d_position, 'transfer count = ' || SQL%ROWCOUNT);

3601: AND ADJ.revision_num = p_revision_num;
3602:
3603: d_position := 20;
3604: IF (PO_LOG.d_stmt) THEN
3605: PO_LOG.stmt(d_module, d_position, 'transfer count = ' || SQL%ROWCOUNT);
3606: END IF;
3607:
3608: d_position := 30;
3609:

Line 3610: IF (PO_LOG.d_proc) THEN

3606: END IF;
3607:
3608: d_position := 30;
3609:
3610: IF (PO_LOG.d_proc) THEN
3611: PO_LOG.proc_end(d_module);
3612: END IF;
3613:
3614: EXCEPTION

Line 3611: PO_LOG.proc_end(d_module);

3607:
3608: d_position := 30;
3609:
3610: IF (PO_LOG.d_proc) THEN
3611: PO_LOG.proc_end(d_module);
3612: END IF;
3613:
3614: EXCEPTION
3615: WHEN OTHERS THEN

Line 3657: IF (PO_LOG.d_proc) THEN

3653:
3654: BEGIN
3655:
3656: d_position := 0;
3657: IF (PO_LOG.d_proc) THEN
3658: PO_LOG.proc_begin(d_module,'p_po_header_id',p_document_id);
3659: END IF;
3660:
3661: d_position := 10;

Line 3658: PO_LOG.proc_begin(d_module,'p_po_header_id',p_document_id);

3654: BEGIN
3655:
3656: d_position := 0;
3657: IF (PO_LOG.d_proc) THEN
3658: PO_LOG.proc_begin(d_module,'p_po_header_id',p_document_id);
3659: END IF;
3660:
3661: d_position := 10;
3662: IF (PO_LOG.d_stmt) THEN

Line 3662: IF (PO_LOG.d_stmt) THEN

3658: PO_LOG.proc_begin(d_module,'p_po_header_id',p_document_id);
3659: END IF;
3660:
3661: d_position := 10;
3662: IF (PO_LOG.d_stmt) THEN
3663: PO_LOG.stmt(d_module, d_position, 'transfer records from archive to dft');
3664: END IF;
3665:
3666: INSERT INTO PO_PRICE_ADJ_ATTRIBS_DRAFT

Line 3663: PO_LOG.stmt(d_module, d_position, 'transfer records from archive to dft');

3659: END IF;
3660:
3661: d_position := 10;
3662: IF (PO_LOG.d_stmt) THEN
3663: PO_LOG.stmt(d_module, d_position, 'transfer records from archive to dft');
3664: END IF;
3665:
3666: INSERT INTO PO_PRICE_ADJ_ATTRIBS_DRAFT
3667: (DRAFT_ID

Line 3717: IF (PO_LOG.d_stmt) THEN

3713: AND ATTR.revision_num = p_revision_num;
3714:
3715:
3716: d_position := 20;
3717: IF (PO_LOG.d_stmt) THEN
3718: PO_LOG.stmt(d_module, d_position, 'transfer count = ' || SQL%ROWCOUNT);
3719: END IF;
3720:
3721: d_position := 30;

Line 3718: PO_LOG.stmt(d_module, d_position, 'transfer count = ' || SQL%ROWCOUNT);

3714:
3715:
3716: d_position := 20;
3717: IF (PO_LOG.d_stmt) THEN
3718: PO_LOG.stmt(d_module, d_position, 'transfer count = ' || SQL%ROWCOUNT);
3719: END IF;
3720:
3721: d_position := 30;
3722:

Line 3723: IF (PO_LOG.d_proc) THEN

3719: END IF;
3720:
3721: d_position := 30;
3722:
3723: IF (PO_LOG.d_proc) THEN
3724: PO_LOG.proc_end(d_module);
3725: END IF;
3726:
3727: EXCEPTION

Line 3724: PO_LOG.proc_end(d_module);

3720:
3721: d_position := 30;
3722:
3723: IF (PO_LOG.d_proc) THEN
3724: PO_LOG.proc_end(d_module);
3725: END IF;
3726:
3727: EXCEPTION
3728: WHEN OTHERS THEN

Line 3771: IF (PO_LOG.d_proc) THEN

3767:
3768:
3769: BEGIN
3770: d_position := 0;
3771: IF (PO_LOG.d_proc) THEN
3772: PO_LOG.proc_begin(d_module);
3773: END IF;
3774:
3775: d_position := 10;

Line 3772: PO_LOG.proc_begin(d_module);

3768:
3769: BEGIN
3770: d_position := 0;
3771: IF (PO_LOG.d_proc) THEN
3772: PO_LOG.proc_begin(d_module);
3773: END IF;
3774:
3775: d_position := 10;
3776: IF (PO_LOG.d_stmt) THEN

Line 3776: IF (PO_LOG.d_stmt) THEN

3772: PO_LOG.proc_begin(d_module);
3773: END IF;
3774:
3775: d_position := 10;
3776: IF (PO_LOG.d_stmt) THEN
3777: PO_LOG.stmt(d_module, d_position, 'transfer records from archive to dft');
3778: END IF;
3779:
3780: INSERT INTO po_notification_ctrl_draft

Line 3777: PO_LOG.stmt(d_module, d_position, 'transfer records from archive to dft');

3773: END IF;
3774:
3775: d_position := 10;
3776: IF (PO_LOG.d_stmt) THEN
3777: PO_LOG.stmt(d_module, d_position, 'transfer records from archive to dft');
3778: END IF;
3779:
3780: INSERT INTO po_notification_ctrl_draft
3781: (

Line 3860: IF (PO_LOG.d_stmt) THEN

3856: FROM po_notification_controls
3857: WHERE po_header_id = p_document_id;
3858:
3859: d_position := 20;
3860: IF (PO_LOG.d_stmt) THEN
3861: PO_LOG.stmt(d_module, d_position, 'transfer count = ' || SQL%ROWCOUNT);
3862: END IF;
3863:
3864: d_position := 30;

Line 3861: PO_LOG.stmt(d_module, d_position, 'transfer count = ' || SQL%ROWCOUNT);

3857: WHERE po_header_id = p_document_id;
3858:
3859: d_position := 20;
3860: IF (PO_LOG.d_stmt) THEN
3861: PO_LOG.stmt(d_module, d_position, 'transfer count = ' || SQL%ROWCOUNT);
3862: END IF;
3863:
3864: d_position := 30;
3865:

Line 3866: IF (PO_LOG.d_proc) THEN

3862: END IF;
3863:
3864: d_position := 30;
3865:
3866: IF (PO_LOG.d_proc) THEN
3867: PO_LOG.proc_end(d_module);
3868: END IF;
3869:
3870: EXCEPTION

Line 3867: PO_LOG.proc_end(d_module);

3863:
3864: d_position := 30;
3865:
3866: IF (PO_LOG.d_proc) THEN
3867: PO_LOG.proc_end(d_module);
3868: END IF;
3869:
3870: EXCEPTION
3871: WHEN OTHERS THEN

Line 3964: IF (PO_LOG.d_proc) THEN

3960:
3961:
3962: BEGIN
3963: d_position := 0;
3964: IF (PO_LOG.d_proc) THEN
3965: PO_LOG.proc_begin(d_mod);
3966: END IF;
3967:
3968: d_position := 10;

Line 3965: PO_LOG.proc_begin(d_mod);

3961:
3962: BEGIN
3963: d_position := 0;
3964: IF (PO_LOG.d_proc) THEN
3965: PO_LOG.proc_begin(d_mod);
3966: END IF;
3967:
3968: d_position := 10;
3969: IF (PO_LOG.d_stmt) THEN

Line 3969: IF (PO_LOG.d_stmt) THEN

3965: PO_LOG.proc_begin(d_mod);
3966: END IF;
3967:
3968: d_position := 10;
3969: IF (PO_LOG.d_stmt) THEN
3970: PO_LOG.stmt(d_mod, d_position, 'transfer UDA records from archive to txn');
3971: END IF;
3972:
3973: -- Check if Document is UDA Enabled

Line 3970: PO_LOG.stmt(d_mod, d_position, 'transfer UDA records from archive to txn');

3966: END IF;
3967:
3968: d_position := 10;
3969: IF (PO_LOG.d_stmt) THEN
3970: PO_LOG.stmt(d_mod, d_position, 'transfer UDA records from archive to txn');
3971: END IF;
3972:
3973: -- Check if Document is UDA Enabled
3974: SELECT 'PURCHASING', TYPE_LOOKUP_CODE, STYLE_ID

Line 3980: IF PO_LOG.d_stmt THEN

3976: FROM po_headers_all
3977: WHERE PO_HEADER_ID = p_document_id;
3978:
3979: d_position := 20;
3980: IF PO_LOG.d_stmt THEN
3981: PO_LOG.stmt(d_mod,d_position,'Before Check_Uda_Enabled');
3982: END IF;
3983:
3984: PO_CLM_CLO_UTIL.Check_Uda_Enabled

Line 3981: PO_LOG.stmt(d_mod,d_position,'Before Check_Uda_Enabled');

3977: WHERE PO_HEADER_ID = p_document_id;
3978:
3979: d_position := 20;
3980: IF PO_LOG.d_stmt THEN
3981: PO_LOG.stmt(d_mod,d_position,'Before Check_Uda_Enabled');
3982: END IF;
3983:
3984: PO_CLM_CLO_UTIL.Check_Uda_Enabled
3985: (

Line 3997: IF PO_LOG.d_stmt THEN

3993: ,x_msg_data => l_msg_data
3994: );
3995:
3996: d_position := 30;
3997: IF PO_LOG.d_stmt THEN
3998: PO_LOG.stmt(d_mod,d_position,'After Check_Uda_Enabled with x_return_status : ' || l_return_status);
3999: END IF;
4000:
4001: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 3998: PO_LOG.stmt(d_mod,d_position,'After Check_Uda_Enabled with x_return_status : ' || l_return_status);

3994: );
3995:
3996: d_position := 30;
3997: IF PO_LOG.d_stmt THEN
3998: PO_LOG.stmt(d_mod,d_position,'After Check_Uda_Enabled with x_return_status : ' || l_return_status);
3999: END IF;
4000:
4001: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4002: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4015: IF PO_LOG.d_stmt THEN

4011: CLOSE po_headers_ext_cursor;
4012:
4013: -- Start Sync PO_HEADERS_ALL_EXT_B
4014: d_position := 40;
4015: IF PO_LOG.d_stmt THEN
4016: PO_LOG.stmt(d_mod,d_position,'Sync PO_HEADERS_ALL_EXT_B');
4017: END IF;
4018:
4019: FORALL i IN 1..l_old_hdr_ext_id_tbl.Count

Line 4016: PO_LOG.stmt(d_mod,d_position,'Sync PO_HEADERS_ALL_EXT_B');

4012:
4013: -- Start Sync PO_HEADERS_ALL_EXT_B
4014: d_position := 40;
4015: IF PO_LOG.d_stmt THEN
4016: PO_LOG.stmt(d_mod,d_position,'Sync PO_HEADERS_ALL_EXT_B');
4017: END IF;
4018:
4019: FORALL i IN 1..l_old_hdr_ext_id_tbl.Count
4020: INSERT INTO PO_HEADERS_ALL_EXT_B

Line 4240: IF PO_LOG.d_stmt THEN

4236: WHERE extension_id = l_old_hdr_ext_id_tbl(i)
4237: AND revision_num = p_revision_num;
4238:
4239: d_position := 50;
4240: IF PO_LOG.d_stmt THEN
4241: PO_LOG.stmt(d_mod,d_position,'Number of rows inserted: '||SQL%rowcount);
4242: END IF;
4243: -- End PO_HEADERS_ALL_EXT_B
4244:

Line 4241: PO_LOG.stmt(d_mod,d_position,'Number of rows inserted: '||SQL%rowcount);

4237: AND revision_num = p_revision_num;
4238:
4239: d_position := 50;
4240: IF PO_LOG.d_stmt THEN
4241: PO_LOG.stmt(d_mod,d_position,'Number of rows inserted: '||SQL%rowcount);
4242: END IF;
4243: -- End PO_HEADERS_ALL_EXT_B
4244:
4245: -- Start PO_HEADERS_ALL_EXT_TL

Line 4247: IF PO_LOG.d_stmt THEN

4243: -- End PO_HEADERS_ALL_EXT_B
4244:
4245: -- Start PO_HEADERS_ALL_EXT_TL
4246: d_position := 60;
4247: IF PO_LOG.d_stmt THEN
4248: PO_LOG.stmt(d_mod,d_position,'Sync PO_HEADERS_ALL_EXT_TL');
4249: END IF;
4250:
4251: FORALL i IN 1..l_old_hdr_ext_id_tbl.Count

Line 4248: PO_LOG.stmt(d_mod,d_position,'Sync PO_HEADERS_ALL_EXT_TL');

4244:
4245: -- Start PO_HEADERS_ALL_EXT_TL
4246: d_position := 60;
4247: IF PO_LOG.d_stmt THEN
4248: PO_LOG.stmt(d_mod,d_position,'Sync PO_HEADERS_ALL_EXT_TL');
4249: END IF;
4250:
4251: FORALL i IN 1..l_old_hdr_ext_id_tbl.Count
4252: INSERT INTO PO_HEADERS_ALL_EXT_TL

Line 4377: IF PO_LOG.d_stmt THEN

4373: AND language = userenv('LANG')
4374: AND revision_num = p_revision_num;
4375:
4376: d_position := 70;
4377: IF PO_LOG.d_stmt THEN
4378: PO_LOG.stmt(d_mod,d_position,'Number of rows inserted: '||SQL%rowcount);
4379: END IF;
4380: -- End PO_HEADERS_ALL_EXT_TL
4381:

Line 4378: PO_LOG.stmt(d_mod,d_position,'Number of rows inserted: '||SQL%rowcount);

4374: AND revision_num = p_revision_num;
4375:
4376: d_position := 70;
4377: IF PO_LOG.d_stmt THEN
4378: PO_LOG.stmt(d_mod,d_position,'Number of rows inserted: '||SQL%rowcount);
4379: END IF;
4380: -- End PO_HEADERS_ALL_EXT_TL
4381:
4382: -- Sync UDA Line and Line Locations data only for PO or PA BLANKETS

Line 4392: IF PO_LOG.d_stmt THEN

4388: CLOSE po_lines_ext_cursor;
4389:
4390: -- Start PO_LINES_ALL_EXT_B
4391: d_position := 80;
4392: IF PO_LOG.d_stmt THEN
4393: PO_LOG.stmt(d_mod,d_position,'Sync PO_LINES_ALL_EXT_B');
4394: END IF;
4395:
4396: FORALL i IN 1..l_old_line_ext_id_tbl.Count

Line 4393: PO_LOG.stmt(d_mod,d_position,'Sync PO_LINES_ALL_EXT_B');

4389:
4390: -- Start PO_LINES_ALL_EXT_B
4391: d_position := 80;
4392: IF PO_LOG.d_stmt THEN
4393: PO_LOG.stmt(d_mod,d_position,'Sync PO_LINES_ALL_EXT_B');
4394: END IF;
4395:
4396: FORALL i IN 1..l_old_line_ext_id_tbl.Count
4397: INSERT INTO PO_LINES_ALL_EXT_B

Line 4617: IF PO_LOG.d_stmt THEN

4613: WHERE extension_id = l_old_line_ext_id_tbl(i)
4614: AND revision_num = p_revision_num;
4615:
4616: d_position := 90;
4617: IF PO_LOG.d_stmt THEN
4618: PO_LOG.stmt(d_mod,d_position,'Number of rows inserted: '||SQL%rowcount);
4619: END IF;
4620: -- End PO_LINES_ALL_EXT_B
4621:

Line 4618: PO_LOG.stmt(d_mod,d_position,'Number of rows inserted: '||SQL%rowcount);

4614: AND revision_num = p_revision_num;
4615:
4616: d_position := 90;
4617: IF PO_LOG.d_stmt THEN
4618: PO_LOG.stmt(d_mod,d_position,'Number of rows inserted: '||SQL%rowcount);
4619: END IF;
4620: -- End PO_LINES_ALL_EXT_B
4621:
4622: -- Start PO_LINES_ALL_EXT_TL

Line 4624: IF PO_LOG.d_stmt THEN

4620: -- End PO_LINES_ALL_EXT_B
4621:
4622: -- Start PO_LINES_ALL_EXT_TL
4623: d_position := 100;
4624: IF PO_LOG.d_stmt THEN
4625: PO_LOG.stmt(d_mod,d_position,'Sync PO_LINES_ALL_EXT_TL');
4626: END IF;
4627:
4628: FORALL i IN 1..l_old_line_ext_id_tbl.Count

Line 4625: PO_LOG.stmt(d_mod,d_position,'Sync PO_LINES_ALL_EXT_TL');

4621:
4622: -- Start PO_LINES_ALL_EXT_TL
4623: d_position := 100;
4624: IF PO_LOG.d_stmt THEN
4625: PO_LOG.stmt(d_mod,d_position,'Sync PO_LINES_ALL_EXT_TL');
4626: END IF;
4627:
4628: FORALL i IN 1..l_old_line_ext_id_tbl.Count
4629: INSERT INTO PO_LINES_ALL_EXT_TL

Line 4754: IF PO_LOG.d_stmt THEN

4750: AND language = userenv('LANG')
4751: AND revision_num = p_revision_num;
4752:
4753: d_position := 110;
4754: IF PO_LOG.d_stmt THEN
4755: PO_LOG.stmt(d_mod,d_position,'Number of rows inserted: '||SQL%rowcount);
4756: END IF;
4757: -- End PO_LINES_ALL_EXT_TL
4758:

Line 4755: PO_LOG.stmt(d_mod,d_position,'Number of rows inserted: '||SQL%rowcount);

4751: AND revision_num = p_revision_num;
4752:
4753: d_position := 110;
4754: IF PO_LOG.d_stmt THEN
4755: PO_LOG.stmt(d_mod,d_position,'Number of rows inserted: '||SQL%rowcount);
4756: END IF;
4757: -- End PO_LINES_ALL_EXT_TL
4758:
4759: OPEN po_line_loc_ext_cursor;

Line 4765: IF PO_LOG.d_stmt THEN

4761: CLOSE po_line_loc_ext_cursor;
4762:
4763: -- Start PO_LINE_LOC_ALL_EXT_B
4764: d_position := 120;
4765: IF PO_LOG.d_stmt THEN
4766: PO_LOG.stmt(d_mod,d_position,'Sync PO_LINE_LOCATIONS_ALL_EXT_B');
4767: END IF;
4768:
4769: FORALL i IN 1..l_old_line_loc_ext_id_tbl.Count

Line 4766: PO_LOG.stmt(d_mod,d_position,'Sync PO_LINE_LOCATIONS_ALL_EXT_B');

4762:
4763: -- Start PO_LINE_LOC_ALL_EXT_B
4764: d_position := 120;
4765: IF PO_LOG.d_stmt THEN
4766: PO_LOG.stmt(d_mod,d_position,'Sync PO_LINE_LOCATIONS_ALL_EXT_B');
4767: END IF;
4768:
4769: FORALL i IN 1..l_old_line_loc_ext_id_tbl.Count
4770: INSERT INTO PO_LINE_LOCATIONS_ALL_EXT_B

Line 4990: IF PO_LOG.d_stmt THEN

4986: WHERE extension_id = l_old_line_loc_ext_id_tbl(i)
4987: AND revision_num = p_revision_num;
4988:
4989: d_position := 130;
4990: IF PO_LOG.d_stmt THEN
4991: PO_LOG.stmt(d_mod,d_position,'Number of rows inserted: '||SQL%rowcount);
4992: END IF;
4993: -- End PO_LINE_LOC_ALL_EXT_B
4994:

Line 4991: PO_LOG.stmt(d_mod,d_position,'Number of rows inserted: '||SQL%rowcount);

4987: AND revision_num = p_revision_num;
4988:
4989: d_position := 130;
4990: IF PO_LOG.d_stmt THEN
4991: PO_LOG.stmt(d_mod,d_position,'Number of rows inserted: '||SQL%rowcount);
4992: END IF;
4993: -- End PO_LINE_LOC_ALL_EXT_B
4994:
4995: -- Start PO_LINE_LOC_ALL_EXT_TL

Line 4997: IF PO_LOG.d_stmt THEN

4993: -- End PO_LINE_LOC_ALL_EXT_B
4994:
4995: -- Start PO_LINE_LOC_ALL_EXT_TL
4996: d_position := 140;
4997: IF PO_LOG.d_stmt THEN
4998: PO_LOG.stmt(d_mod,d_position,'Sync PO_LINE_LOCATIONS_ALL_EXT_TL');
4999: END IF;
5000:
5001: FORALL i IN 1..l_old_line_loc_ext_id_tbl.Count

Line 4998: PO_LOG.stmt(d_mod,d_position,'Sync PO_LINE_LOCATIONS_ALL_EXT_TL');

4994:
4995: -- Start PO_LINE_LOC_ALL_EXT_TL
4996: d_position := 140;
4997: IF PO_LOG.d_stmt THEN
4998: PO_LOG.stmt(d_mod,d_position,'Sync PO_LINE_LOCATIONS_ALL_EXT_TL');
4999: END IF;
5000:
5001: FORALL i IN 1..l_old_line_loc_ext_id_tbl.Count
5002: INSERT INTO PO_LINE_LOCATIONS_ALL_EXT_TL

Line 5127: IF PO_LOG.d_stmt THEN

5123: AND language = userenv('LANG')
5124: AND revision_num = p_revision_num;
5125:
5126: d_position := 150;
5127: IF PO_LOG.d_stmt THEN
5128: PO_LOG.stmt(d_mod,d_position,'Number of rows inserted: '||SQL%rowcount);
5129: END IF;
5130: -- End PO_LINE_LOC_ALL_EXT_TL
5131:

Line 5128: PO_LOG.stmt(d_mod,d_position,'Number of rows inserted: '||SQL%rowcount);

5124: AND revision_num = p_revision_num;
5125:
5126: d_position := 150;
5127: IF PO_LOG.d_stmt THEN
5128: PO_LOG.stmt(d_mod,d_position,'Number of rows inserted: '||SQL%rowcount);
5129: END IF;
5130: -- End PO_LINE_LOC_ALL_EXT_TL
5131:
5132: END IF; --IF p_document_subtype='BLANKET'

Line 5138: IF (PO_LOG.d_proc) THEN

5134: END IF; --IF l_enabled_flag = 'Y' AND p_document_type IN ('PO', 'PA')
5135:
5136: d_position := 160;
5137:
5138: IF (PO_LOG.d_proc) THEN
5139: PO_LOG.proc_end(d_mod);
5140: END IF;
5141:
5142: EXCEPTION

Line 5139: PO_LOG.proc_end(d_mod);

5135:
5136: d_position := 160;
5137:
5138: IF (PO_LOG.d_proc) THEN
5139: PO_LOG.proc_end(d_mod);
5140: END IF;
5141:
5142: EXCEPTION
5143: WHEN OTHERS THEN

Line 5239: IF (PO_LOG.d_stmt) THEN

5235: FROM po_line_ucas
5236: WHERE po_header_id = p_document_id
5237: AND undef_draft_id = -1;
5238: d_position :=20;
5239: IF (PO_LOG.d_stmt) THEN
5240: PO_LOG.stmt(d_module, d_position, 'transfer count = ' || SQL%ROWCOUNT);
5241: END IF;
5242:
5243: d_position := 30;

Line 5240: PO_LOG.stmt(d_module, d_position, 'transfer count = ' || SQL%ROWCOUNT);

5236: WHERE po_header_id = p_document_id
5237: AND undef_draft_id = -1;
5238: d_position :=20;
5239: IF (PO_LOG.d_stmt) THEN
5240: PO_LOG.stmt(d_module, d_position, 'transfer count = ' || SQL%ROWCOUNT);
5241: END IF;
5242:
5243: d_position := 30;
5244:

Line 5245: IF (PO_LOG.d_proc) THEN

5241: END IF;
5242:
5243: d_position := 30;
5244:
5245: IF (PO_LOG.d_proc) THEN
5246: PO_LOG.proc_end(d_module);
5247: END IF;
5248:
5249: EXCEPTION

Line 5246: PO_LOG.proc_end(d_module);

5242:
5243: d_position := 30;
5244:
5245: IF (PO_LOG.d_proc) THEN
5246: PO_LOG.proc_end(d_module);
5247: END IF;
5248:
5249: EXCEPTION
5250: WHEN OTHERS THEN

Line 5296: IF (PO_LOG.d_proc) THEN

5292: BEGIN
5293:
5294: d_position := 0;
5295:
5296: IF (PO_LOG.d_proc) THEN
5297: PO_LOG.proc_begin(d_module,'p_po_header_id',p_document_id);
5298: END IF;
5299:
5300: d_position := 10;

Line 5297: PO_LOG.proc_begin(d_module,'p_po_header_id',p_document_id);

5293:
5294: d_position := 0;
5295:
5296: IF (PO_LOG.d_proc) THEN
5297: PO_LOG.proc_begin(d_module,'p_po_header_id',p_document_id);
5298: END IF;
5299:
5300: d_position := 10;
5301: IF (PO_LOG.d_stmt) THEN

Line 5301: IF (PO_LOG.d_stmt) THEN

5297: PO_LOG.proc_begin(d_module,'p_po_header_id',p_document_id);
5298: END IF;
5299:
5300: d_position := 10;
5301: IF (PO_LOG.d_stmt) THEN
5302: PO_LOG.stmt(d_module, d_position, 'transfer records from archive to dft');
5303: END IF;
5304:
5305: INSERT INTO po_exhibit_details_draft

Line 5302: PO_LOG.stmt(d_module, d_position, 'transfer records from archive to dft');

5298: END IF;
5299:
5300: d_position := 10;
5301: IF (PO_LOG.d_stmt) THEN
5302: PO_LOG.stmt(d_module, d_position, 'transfer records from archive to dft');
5303: END IF;
5304:
5305: INSERT INTO po_exhibit_details_draft
5306: (

Line 5345: IF (PO_LOG.d_stmt) THEN

5341: AND revision_num = p_revision_num;
5342:
5343:
5344: d_position :=20;
5345: IF (PO_LOG.d_stmt) THEN
5346: PO_LOG.stmt(d_module, d_position, 'transfer count = ' || SQL%ROWCOUNT);
5347: END IF;
5348:
5349: d_position := 30;

Line 5346: PO_LOG.stmt(d_module, d_position, 'transfer count = ' || SQL%ROWCOUNT);

5342:
5343:
5344: d_position :=20;
5345: IF (PO_LOG.d_stmt) THEN
5346: PO_LOG.stmt(d_module, d_position, 'transfer count = ' || SQL%ROWCOUNT);
5347: END IF;
5348:
5349: d_position := 30;
5350:

Line 5351: IF (PO_LOG.d_proc) THEN

5347: END IF;
5348:
5349: d_position := 30;
5350:
5351: IF (PO_LOG.d_proc) THEN
5352: PO_LOG.proc_end(d_module);
5353: END IF;
5354:
5355: EXCEPTION

Line 5352: PO_LOG.proc_end(d_module);

5348:
5349: d_position := 30;
5350:
5351: IF (PO_LOG.d_proc) THEN
5352: PO_LOG.proc_end(d_module);
5353: END IF;
5354:
5355: EXCEPTION
5356: WHEN OTHERS THEN

Line 5431: IF (PO_LOG.d_proc) THEN

5427:
5428: BEGIN
5429:
5430: d_position := 0;
5431: IF (PO_LOG.d_proc) THEN
5432: PO_LOG.proc_begin(d_module,'p_po_header_id',p_document_id);
5433: PO_LOG.proc_begin(d_module,'p_document_type',p_document_type);
5434: PO_LOG.proc_begin(d_module,'p_document_subtype',p_document_subtype);
5435: END IF;

Line 5432: PO_LOG.proc_begin(d_module,'p_po_header_id',p_document_id);

5428: BEGIN
5429:
5430: d_position := 0;
5431: IF (PO_LOG.d_proc) THEN
5432: PO_LOG.proc_begin(d_module,'p_po_header_id',p_document_id);
5433: PO_LOG.proc_begin(d_module,'p_document_type',p_document_type);
5434: PO_LOG.proc_begin(d_module,'p_document_subtype',p_document_subtype);
5435: END IF;
5436:

Line 5433: PO_LOG.proc_begin(d_module,'p_document_type',p_document_type);

5429:
5430: d_position := 0;
5431: IF (PO_LOG.d_proc) THEN
5432: PO_LOG.proc_begin(d_module,'p_po_header_id',p_document_id);
5433: PO_LOG.proc_begin(d_module,'p_document_type',p_document_type);
5434: PO_LOG.proc_begin(d_module,'p_document_subtype',p_document_subtype);
5435: END IF;
5436:
5437: --Standard Start API savepoint

Line 5434: PO_LOG.proc_begin(d_module,'p_document_subtype',p_document_subtype);

5430: d_position := 0;
5431: IF (PO_LOG.d_proc) THEN
5432: PO_LOG.proc_begin(d_module,'p_po_header_id',p_document_id);
5433: PO_LOG.proc_begin(d_module,'p_document_type',p_document_type);
5434: PO_LOG.proc_begin(d_module,'p_document_subtype',p_document_subtype);
5435: END IF;
5436:
5437: --Standard Start API savepoint
5438: SAVEPOINT PO_SYNC_DRAFT_FROM_ARCHIVE_SP;

Line 5446: IF (PO_LOG.d_stmt) THEN

5442: check_po_sync ( p_document_id, p_revision_num, p_draft_id, l_return_status );
5443:
5444: d_position := 10;
5445:
5446: IF (PO_LOG.d_stmt) THEN
5447: PO_LOG.stmt(d_module, d_position, 'check_po_sync returned'||l_return_status);
5448: END IF;
5449:
5450: IF (l_return_status = 'N') THEN

Line 5447: PO_LOG.stmt(d_module, d_position, 'check_po_sync returned'||l_return_status);

5443:
5444: d_position := 10;
5445:
5446: IF (PO_LOG.d_stmt) THEN
5447: PO_LOG.stmt(d_module, d_position, 'check_po_sync returned'||l_return_status);
5448: END IF;
5449:
5450: IF (l_return_status = 'N') THEN
5451:

Line 5453: IF (PO_LOG.d_stmt) THEN

5449:
5450: IF (l_return_status = 'N') THEN
5451:
5452: d_position := 20;
5453: IF (PO_LOG.d_stmt) THEN
5454: PO_LOG.stmt(d_module, d_position, 'Document has not been synced yet');
5455: END IF;
5456:
5457: IF (p_document_type = 'PO') THEN

Line 5454: PO_LOG.stmt(d_module, d_position, 'Document has not been synced yet');

5450: IF (l_return_status = 'N') THEN
5451:
5452: d_position := 20;
5453: IF (PO_LOG.d_stmt) THEN
5454: PO_LOG.stmt(d_module, d_position, 'Document has not been synced yet');
5455: END IF;
5456:
5457: IF (p_document_type = 'PO') THEN
5458:

Line 5462: IF (PO_LOG.d_proc) THEN

5458:
5459: --View Base Document action is being handled for a new document in this transaction
5460: --Delete All Draft records for DRAFT_ID=0 if they exist
5461: d_position := 25;
5462: IF (PO_LOG.d_proc) THEN
5463: PO_LOG.proc_begin(d_module,'Delete all entries from Draft Tables having draft_id: ',p_draft_id);
5464: END IF;
5465:
5466: delete_dummy_data_from_draft (p_draft_id);

Line 5463: PO_LOG.proc_begin(d_module,'Delete all entries from Draft Tables having draft_id: ',p_draft_id);

5459: --View Base Document action is being handled for a new document in this transaction
5460: --Delete All Draft records for DRAFT_ID=0 if they exist
5461: d_position := 25;
5462: IF (PO_LOG.d_proc) THEN
5463: PO_LOG.proc_begin(d_module,'Delete all entries from Draft Tables having draft_id: ',p_draft_id);
5464: END IF;
5465:
5466: delete_dummy_data_from_draft (p_draft_id);
5467:

Line 5469: IF (PO_LOG.d_stmt) THEN

5465:
5466: delete_dummy_data_from_draft (p_draft_id);
5467:
5468: d_position := 30;
5469: IF (PO_LOG.d_stmt) THEN
5470: PO_LOG.stmt(d_module, d_position, 'sync_draft_from_archive for PO');
5471: END IF;
5472:
5473: d_position := 40;

Line 5470: PO_LOG.stmt(d_module, d_position, 'sync_draft_from_archive for PO');

5466: delete_dummy_data_from_draft (p_draft_id);
5467:
5468: d_position := 30;
5469: IF (PO_LOG.d_stmt) THEN
5470: PO_LOG.stmt(d_module, d_position, 'sync_draft_from_archive for PO');
5471: END IF;
5472:
5473: d_position := 40;
5474: IF (PO_LOG.d_stmt) THEN

Line 5474: IF (PO_LOG.d_stmt) THEN

5470: PO_LOG.stmt(d_module, d_position, 'sync_draft_from_archive for PO');
5471: END IF;
5472:
5473: d_position := 40;
5474: IF (PO_LOG.d_stmt) THEN
5475: PO_LOG.stmt(d_module, d_position, 'Calling CREATE_DUMMY_ROW_IN_DRAFT');
5476: END IF;
5477:
5478: create_dummy_row_in_draft (p_document_id, p_revision_num, p_draft_id);

Line 5475: PO_LOG.stmt(d_module, d_position, 'Calling CREATE_DUMMY_ROW_IN_DRAFT');

5471: END IF;
5472:
5473: d_position := 40;
5474: IF (PO_LOG.d_stmt) THEN
5475: PO_LOG.stmt(d_module, d_position, 'Calling CREATE_DUMMY_ROW_IN_DRAFT');
5476: END IF;
5477:
5478: create_dummy_row_in_draft (p_document_id, p_revision_num, p_draft_id);
5479:

Line 5481: IF (PO_LOG.d_stmt) THEN

5477:
5478: create_dummy_row_in_draft (p_document_id, p_revision_num, p_draft_id);
5479:
5480: d_position := 50;
5481: IF (PO_LOG.d_stmt) THEN
5482: PO_LOG.stmt(d_module, d_position, 'Calling SYNC_HEADER');
5483: END IF;
5484:
5485: sync_header (p_document_id, p_revision_num, p_draft_id);

Line 5482: PO_LOG.stmt(d_module, d_position, 'Calling SYNC_HEADER');

5478: create_dummy_row_in_draft (p_document_id, p_revision_num, p_draft_id);
5479:
5480: d_position := 50;
5481: IF (PO_LOG.d_stmt) THEN
5482: PO_LOG.stmt(d_module, d_position, 'Calling SYNC_HEADER');
5483: END IF;
5484:
5485: sync_header (p_document_id, p_revision_num, p_draft_id);
5486:

Line 5488: IF (PO_LOG.d_stmt) THEN

5484:
5485: sync_header (p_document_id, p_revision_num, p_draft_id);
5486:
5487: d_position := 60;
5488: IF (PO_LOG.d_stmt) THEN
5489: PO_LOG.stmt(d_module, d_position, 'Calling SYNC_LINES');
5490: END IF;
5491:
5492: sync_lines (p_document_id, p_revision_num, p_draft_id);

Line 5489: PO_LOG.stmt(d_module, d_position, 'Calling SYNC_LINES');

5485: sync_header (p_document_id, p_revision_num, p_draft_id);
5486:
5487: d_position := 60;
5488: IF (PO_LOG.d_stmt) THEN
5489: PO_LOG.stmt(d_module, d_position, 'Calling SYNC_LINES');
5490: END IF;
5491:
5492: sync_lines (p_document_id, p_revision_num, p_draft_id);
5493:

Line 5495: IF (PO_LOG.d_stmt) THEN

5491:
5492: sync_lines (p_document_id, p_revision_num, p_draft_id);
5493:
5494: d_position := 70;
5495: IF (PO_LOG.d_stmt) THEN
5496: PO_LOG.stmt(d_module, d_position, 'Calling SYNC_PRICE_ADJUSTMENTS');
5497: END IF;
5498:
5499: sync_price_adjustments (p_document_id, p_revision_num, p_draft_id);

Line 5496: PO_LOG.stmt(d_module, d_position, 'Calling SYNC_PRICE_ADJUSTMENTS');

5492: sync_lines (p_document_id, p_revision_num, p_draft_id);
5493:
5494: d_position := 70;
5495: IF (PO_LOG.d_stmt) THEN
5496: PO_LOG.stmt(d_module, d_position, 'Calling SYNC_PRICE_ADJUSTMENTS');
5497: END IF;
5498:
5499: sync_price_adjustments (p_document_id, p_revision_num, p_draft_id);
5500:

Line 5502: IF (PO_LOG.d_stmt) THEN

5498:
5499: sync_price_adjustments (p_document_id, p_revision_num, p_draft_id);
5500:
5501: d_position := 80;
5502: IF (PO_LOG.d_stmt) THEN
5503: PO_LOG.stmt(d_module, d_position, 'Calling SYNC_PRICE_ADJ_ATTRIBS');
5504: END IF;
5505:
5506: sync_price_adj_attribs (p_document_id, p_revision_num, p_draft_id);

Line 5503: PO_LOG.stmt(d_module, d_position, 'Calling SYNC_PRICE_ADJ_ATTRIBS');

5499: sync_price_adjustments (p_document_id, p_revision_num, p_draft_id);
5500:
5501: d_position := 80;
5502: IF (PO_LOG.d_stmt) THEN
5503: PO_LOG.stmt(d_module, d_position, 'Calling SYNC_PRICE_ADJ_ATTRIBS');
5504: END IF;
5505:
5506: sync_price_adj_attribs (p_document_id, p_revision_num, p_draft_id);
5507:

Line 5509: IF (PO_LOG.d_stmt) THEN

5505:
5506: sync_price_adj_attribs (p_document_id, p_revision_num, p_draft_id);
5507:
5508: d_position := 90;
5509: IF (PO_LOG.d_stmt) THEN
5510: PO_LOG.stmt(d_module, d_position, 'Calling SYNC_PRICE_DIFFS with entity type PO LINE');
5511: END IF;
5512:
5513: sync_price_diffs (p_document_id => p_document_id,

Line 5510: PO_LOG.stmt(d_module, d_position, 'Calling SYNC_PRICE_DIFFS with entity type PO LINE');

5506: sync_price_adj_attribs (p_document_id, p_revision_num, p_draft_id);
5507:
5508: d_position := 90;
5509: IF (PO_LOG.d_stmt) THEN
5510: PO_LOG.stmt(d_module, d_position, 'Calling SYNC_PRICE_DIFFS with entity type PO LINE');
5511: END IF;
5512:
5513: sync_price_diffs (p_document_id => p_document_id,
5514: p_revision_num => p_revision_num,

Line 5519: IF (PO_LOG.d_stmt) THEN

5515: p_draft_id => p_draft_id,
5516: p_entity_type => 'PO LINE');
5517:
5518: d_position := 100;
5519: IF (PO_LOG.d_stmt) THEN
5520: PO_LOG.stmt(d_module, d_position, 'Calling SYNC_LINE_LOCATIONS');
5521: END IF;
5522:
5523: sync_line_locations (p_document_id, p_revision_num, p_draft_id);

Line 5520: PO_LOG.stmt(d_module, d_position, 'Calling SYNC_LINE_LOCATIONS');

5516: p_entity_type => 'PO LINE');
5517:
5518: d_position := 100;
5519: IF (PO_LOG.d_stmt) THEN
5520: PO_LOG.stmt(d_module, d_position, 'Calling SYNC_LINE_LOCATIONS');
5521: END IF;
5522:
5523: sync_line_locations (p_document_id, p_revision_num, p_draft_id);
5524:

Line 5526: IF (PO_LOG.d_stmt) THEN

5522:
5523: sync_line_locations (p_document_id, p_revision_num, p_draft_id);
5524:
5525: d_position := 110;
5526: IF (PO_LOG.d_stmt) THEN
5527: PO_LOG.stmt(d_module, d_position, 'Calling SYNC_DISTRIBUTIONS');
5528: END IF;
5529:
5530: sync_distributions (p_document_id, p_revision_num, p_draft_id);

Line 5527: PO_LOG.stmt(d_module, d_position, 'Calling SYNC_DISTRIBUTIONS');

5523: sync_line_locations (p_document_id, p_revision_num, p_draft_id);
5524:
5525: d_position := 110;
5526: IF (PO_LOG.d_stmt) THEN
5527: PO_LOG.stmt(d_module, d_position, 'Calling SYNC_DISTRIBUTIONS');
5528: END IF;
5529:
5530: sync_distributions (p_document_id, p_revision_num, p_draft_id);
5531:

Line 5533: IF (PO_LOG.d_stmt) THEN

5529:
5530: sync_distributions (p_document_id, p_revision_num, p_draft_id);
5531:
5532: d_position := 112;
5533: IF (PO_LOG.d_stmt) THEN
5534: PO_LOG.stmt(d_module, d_position, 'Calling SYNC_EXHIBITS');
5535: END IF;
5536:
5537: sync_exhibits (p_document_id, p_revision_num, p_draft_id);

Line 5534: PO_LOG.stmt(d_module, d_position, 'Calling SYNC_EXHIBITS');

5530: sync_distributions (p_document_id, p_revision_num, p_draft_id);
5531:
5532: d_position := 112;
5533: IF (PO_LOG.d_stmt) THEN
5534: PO_LOG.stmt(d_module, d_position, 'Calling SYNC_EXHIBITS');
5535: END IF;
5536:
5537: sync_exhibits (p_document_id, p_revision_num, p_draft_id);
5538:

Line 5541: IF (PO_LOG.d_stmt) THEN

5537: sync_exhibits (p_document_id, p_revision_num, p_draft_id);
5538:
5539: --Sync UDA Data for UDA Enabled Documents
5540: d_position := 115;
5541: IF (PO_LOG.d_stmt) THEN
5542: PO_LOG.stmt(d_module, d_position, 'Calling SYNC_UDA_ATTRIBS');
5543: END IF;
5544:
5545: sync_uda_attribs(p_document_id, p_document_type,

Line 5542: PO_LOG.stmt(d_module, d_position, 'Calling SYNC_UDA_ATTRIBS');

5538:
5539: --Sync UDA Data for UDA Enabled Documents
5540: d_position := 115;
5541: IF (PO_LOG.d_stmt) THEN
5542: PO_LOG.stmt(d_module, d_position, 'Calling SYNC_UDA_ATTRIBS');
5543: END IF;
5544:
5545: sync_uda_attribs(p_document_id, p_document_type,
5546: p_document_subtype, p_revision_num, p_draft_id);

Line 5572: IF (PO_LOG.d_proc) THEN

5568:
5569: --View Base Document action is being handled for a new document in this transaction
5570: --Delete All Draft records for DRAFT_ID=0 if they exist
5571: d_position := 117;
5572: IF (PO_LOG.d_proc) THEN
5573: PO_LOG.proc_begin(d_module,'Delete all entries from Draft Tables having draft_id: ',p_draft_id);
5574: END IF;
5575:
5576: delete_dummy_data_from_draft (p_draft_id);

Line 5573: PO_LOG.proc_begin(d_module,'Delete all entries from Draft Tables having draft_id: ',p_draft_id);

5569: --View Base Document action is being handled for a new document in this transaction
5570: --Delete All Draft records for DRAFT_ID=0 if they exist
5571: d_position := 117;
5572: IF (PO_LOG.d_proc) THEN
5573: PO_LOG.proc_begin(d_module,'Delete all entries from Draft Tables having draft_id: ',p_draft_id);
5574: END IF;
5575:
5576: delete_dummy_data_from_draft (p_draft_id);
5577:

Line 5579: IF (PO_LOG.d_stmt) THEN

5575:
5576: delete_dummy_data_from_draft (p_draft_id);
5577:
5578: d_position := 118;
5579: IF (PO_LOG.d_stmt) THEN
5580: PO_LOG.stmt(d_module, d_position, 'Calling CREATE_DUMMY_ROW_IN_DRAFT');
5581: END IF;
5582:
5583: create_dummy_row_in_draft (p_document_id, p_revision_num, p_draft_id);

Line 5580: PO_LOG.stmt(d_module, d_position, 'Calling CREATE_DUMMY_ROW_IN_DRAFT');

5576: delete_dummy_data_from_draft (p_draft_id);
5577:
5578: d_position := 118;
5579: IF (PO_LOG.d_stmt) THEN
5580: PO_LOG.stmt(d_module, d_position, 'Calling CREATE_DUMMY_ROW_IN_DRAFT');
5581: END IF;
5582:
5583: create_dummy_row_in_draft (p_document_id, p_revision_num, p_draft_id);
5584:

Line 5586: IF (PO_LOG.d_stmt) THEN

5582:
5583: create_dummy_row_in_draft (p_document_id, p_revision_num, p_draft_id);
5584:
5585: d_position := 120;
5586: IF (PO_LOG.d_stmt) THEN
5587: PO_LOG.stmt(d_module, d_position, 'Calling SYNC_HEADER');
5588: END IF;
5589:
5590: sync_header (p_document_id, p_revision_num, p_draft_id);

Line 5587: PO_LOG.stmt(d_module, d_position, 'Calling SYNC_HEADER');

5583: create_dummy_row_in_draft (p_document_id, p_revision_num, p_draft_id);
5584:
5585: d_position := 120;
5586: IF (PO_LOG.d_stmt) THEN
5587: PO_LOG.stmt(d_module, d_position, 'Calling SYNC_HEADER');
5588: END IF;
5589:
5590: sync_header (p_document_id, p_revision_num, p_draft_id);
5591:

Line 5595: IF (PO_LOG.d_stmt) THEN

5591:
5592: IF (p_document_subtype = 'BLANKET') THEN
5593:
5594: d_position := 130;
5595: IF (PO_LOG.d_stmt) THEN
5596: PO_LOG.stmt(d_module, d_position, 'Calling SYNC_LINES');
5597: END IF;
5598:
5599: sync_lines (p_document_id, p_revision_num, p_draft_id);

Line 5596: PO_LOG.stmt(d_module, d_position, 'Calling SYNC_LINES');

5592: IF (p_document_subtype = 'BLANKET') THEN
5593:
5594: d_position := 130;
5595: IF (PO_LOG.d_stmt) THEN
5596: PO_LOG.stmt(d_module, d_position, 'Calling SYNC_LINES');
5597: END IF;
5598:
5599: sync_lines (p_document_id, p_revision_num, p_draft_id);
5600:

Line 5602: IF (PO_LOG.d_stmt) THEN

5598:
5599: sync_lines (p_document_id, p_revision_num, p_draft_id);
5600:
5601: d_position := 140;
5602: IF (PO_LOG.d_stmt) THEN
5603: PO_LOG.stmt(d_module, d_position, 'Calling SYNC_PRICE_ADJUSTMENTS');
5604: END IF;
5605:
5606: sync_price_adjustments (p_document_id, p_revision_num, p_draft_id);

Line 5603: PO_LOG.stmt(d_module, d_position, 'Calling SYNC_PRICE_ADJUSTMENTS');

5599: sync_lines (p_document_id, p_revision_num, p_draft_id);
5600:
5601: d_position := 140;
5602: IF (PO_LOG.d_stmt) THEN
5603: PO_LOG.stmt(d_module, d_position, 'Calling SYNC_PRICE_ADJUSTMENTS');
5604: END IF;
5605:
5606: sync_price_adjustments (p_document_id, p_revision_num, p_draft_id);
5607:

Line 5609: IF (PO_LOG.d_stmt) THEN

5605:
5606: sync_price_adjustments (p_document_id, p_revision_num, p_draft_id);
5607:
5608: d_position := 150;
5609: IF (PO_LOG.d_stmt) THEN
5610: PO_LOG.stmt(d_module, d_position, 'Calling SYNC_PRICE_ADJ_ATTRIBS');
5611: END IF;
5612:
5613: sync_price_adj_attribs (p_document_id, p_revision_num, p_draft_id);

Line 5610: PO_LOG.stmt(d_module, d_position, 'Calling SYNC_PRICE_ADJ_ATTRIBS');

5606: sync_price_adjustments (p_document_id, p_revision_num, p_draft_id);
5607:
5608: d_position := 150;
5609: IF (PO_LOG.d_stmt) THEN
5610: PO_LOG.stmt(d_module, d_position, 'Calling SYNC_PRICE_ADJ_ATTRIBS');
5611: END IF;
5612:
5613: sync_price_adj_attribs (p_document_id, p_revision_num, p_draft_id);
5614:

Line 5616: IF (PO_LOG.d_stmt) THEN

5612:
5613: sync_price_adj_attribs (p_document_id, p_revision_num, p_draft_id);
5614:
5615: d_position := 160;
5616: IF (PO_LOG.d_stmt) THEN
5617: PO_LOG.stmt(d_module, d_position, 'Calling SYNC_ATTRIBUTE_VALUES');
5618: END IF;
5619:
5620: sync_attribute_values (p_document_id, p_revision_num, p_draft_id);

Line 5617: PO_LOG.stmt(d_module, d_position, 'Calling SYNC_ATTRIBUTE_VALUES');

5613: sync_price_adj_attribs (p_document_id, p_revision_num, p_draft_id);
5614:
5615: d_position := 160;
5616: IF (PO_LOG.d_stmt) THEN
5617: PO_LOG.stmt(d_module, d_position, 'Calling SYNC_ATTRIBUTE_VALUES');
5618: END IF;
5619:
5620: sync_attribute_values (p_document_id, p_revision_num, p_draft_id);
5621:

Line 5623: IF (PO_LOG.d_stmt) THEN

5619:
5620: sync_attribute_values (p_document_id, p_revision_num, p_draft_id);
5621:
5622: d_position := 170;
5623: IF (PO_LOG.d_stmt) THEN
5624: PO_LOG.stmt(d_module, d_position, 'Calling SYNC_ATTR_VALUES_TLP');
5625: END IF;
5626:
5627: sync_attr_values_tlp (p_document_id, p_revision_num, p_draft_id);

Line 5624: PO_LOG.stmt(d_module, d_position, 'Calling SYNC_ATTR_VALUES_TLP');

5620: sync_attribute_values (p_document_id, p_revision_num, p_draft_id);
5621:
5622: d_position := 170;
5623: IF (PO_LOG.d_stmt) THEN
5624: PO_LOG.stmt(d_module, d_position, 'Calling SYNC_ATTR_VALUES_TLP');
5625: END IF;
5626:
5627: sync_attr_values_tlp (p_document_id, p_revision_num, p_draft_id);
5628:

Line 5630: IF (PO_LOG.d_stmt) THEN

5626:
5627: sync_attr_values_tlp (p_document_id, p_revision_num, p_draft_id);
5628:
5629: d_position := 180;
5630: IF (PO_LOG.d_stmt) THEN
5631: PO_LOG.stmt(d_module, d_position, 'Calling SYNC_PRICE_DIFFS with entity_type BLANKET LINE');
5632: END IF;
5633:
5634: sync_price_diffs (p_document_id => p_document_id,

Line 5631: PO_LOG.stmt(d_module, d_position, 'Calling SYNC_PRICE_DIFFS with entity_type BLANKET LINE');

5627: sync_attr_values_tlp (p_document_id, p_revision_num, p_draft_id);
5628:
5629: d_position := 180;
5630: IF (PO_LOG.d_stmt) THEN
5631: PO_LOG.stmt(d_module, d_position, 'Calling SYNC_PRICE_DIFFS with entity_type BLANKET LINE');
5632: END IF;
5633:
5634: sync_price_diffs (p_document_id => p_document_id,
5635: p_revision_num => p_revision_num,

Line 5640: IF (PO_LOG.d_stmt) THEN

5636: p_draft_id => p_draft_id,
5637: p_entity_type => 'BLANKET LINE');
5638:
5639: d_position := 190;
5640: IF (PO_LOG.d_stmt) THEN
5641: PO_LOG.stmt(d_module, d_position, 'Calling SYNC_LINE_LOCATIONS');
5642: END IF;
5643:
5644: sync_line_locations (p_document_id, p_revision_num, p_draft_id);

Line 5641: PO_LOG.stmt(d_module, d_position, 'Calling SYNC_LINE_LOCATIONS');

5637: p_entity_type => 'BLANKET LINE');
5638:
5639: d_position := 190;
5640: IF (PO_LOG.d_stmt) THEN
5641: PO_LOG.stmt(d_module, d_position, 'Calling SYNC_LINE_LOCATIONS');
5642: END IF;
5643:
5644: sync_line_locations (p_document_id, p_revision_num, p_draft_id);
5645:

Line 5647: IF (PO_LOG.d_stmt) THEN

5643:
5644: sync_line_locations (p_document_id, p_revision_num, p_draft_id);
5645:
5646: d_position := 200;
5647: IF (PO_LOG.d_stmt) THEN
5648: PO_LOG.stmt(d_module, d_position, 'Calling SYNC_PRICE_DIFFS with entity_type PRICE BREAK');
5649: END IF;
5650:
5651: sync_price_diffs (p_document_id => p_document_id,

Line 5648: PO_LOG.stmt(d_module, d_position, 'Calling SYNC_PRICE_DIFFS with entity_type PRICE BREAK');

5644: sync_line_locations (p_document_id, p_revision_num, p_draft_id);
5645:
5646: d_position := 200;
5647: IF (PO_LOG.d_stmt) THEN
5648: PO_LOG.stmt(d_module, d_position, 'Calling SYNC_PRICE_DIFFS with entity_type PRICE BREAK');
5649: END IF;
5650:
5651: sync_price_diffs (p_document_id => p_document_id,
5652: p_revision_num => p_revision_num,

Line 5657: IF (PO_LOG.d_stmt) THEN

5653: p_draft_id => p_draft_id,
5654: p_entity_type => 'PRICE BREAK');
5655:
5656: d_position := 210;
5657: IF (PO_LOG.d_stmt) THEN
5658: PO_LOG.stmt(d_module, d_position, 'Calling SYNC_DISTRIBUTIONS');
5659: END IF;
5660:
5661: sync_distributions (p_document_id, p_revision_num, p_draft_id);

Line 5658: PO_LOG.stmt(d_module, d_position, 'Calling SYNC_DISTRIBUTIONS');

5654: p_entity_type => 'PRICE BREAK');
5655:
5656: d_position := 210;
5657: IF (PO_LOG.d_stmt) THEN
5658: PO_LOG.stmt(d_module, d_position, 'Calling SYNC_DISTRIBUTIONS');
5659: END IF;
5660:
5661: sync_distributions (p_document_id, p_revision_num, p_draft_id);
5662:

Line 5666: IF (PO_LOG.d_stmt) THEN

5662:
5663: END IF; --IF (p_document_subtype = 'BLANKET')
5664:
5665: d_position := 212;
5666: IF (PO_LOG.d_stmt) THEN
5667: PO_LOG.stmt(d_module, d_position, 'Calling SYNC_EXHIBITS');
5668: END IF;
5669:
5670: sync_exhibits (p_document_id, p_revision_num, p_draft_id);

Line 5667: PO_LOG.stmt(d_module, d_position, 'Calling SYNC_EXHIBITS');

5663: END IF; --IF (p_document_subtype = 'BLANKET')
5664:
5665: d_position := 212;
5666: IF (PO_LOG.d_stmt) THEN
5667: PO_LOG.stmt(d_module, d_position, 'Calling SYNC_EXHIBITS');
5668: END IF;
5669:
5670: sync_exhibits (p_document_id, p_revision_num, p_draft_id);
5671:

Line 5674: IF (PO_LOG.d_stmt) THEN

5670: sync_exhibits (p_document_id, p_revision_num, p_draft_id);
5671:
5672: --Sync org assignments for global contracts as well as global blankets.
5673: d_position := 220;
5674: IF (PO_LOG.d_stmt) THEN
5675: PO_LOG.stmt(d_module, d_position, 'Select global agreement flag - po_header_id');
5676: END IF;
5677:
5678: -- SQL What:Find out if it is a global agreement

Line 5675: PO_LOG.stmt(d_module, d_position, 'Select global agreement flag - po_header_id');

5671:
5672: --Sync org assignments for global contracts as well as global blankets.
5673: d_position := 220;
5674: IF (PO_LOG.d_stmt) THEN
5675: PO_LOG.stmt(d_module, d_position, 'Select global agreement flag - po_header_id');
5676: END IF;
5677:
5678: -- SQL What:Find out if it is a global agreement
5679: -- SQL Why :Sync org_assignment draft table if needed

Line 5688: IF (PO_LOG.d_stmt) THEN

5684:
5685: IF (l_ga_flag = 'Y') THEN
5686:
5687: d_position := 230;
5688: IF (PO_LOG.d_stmt) THEN
5689: PO_LOG.stmt(d_module, d_position, 'Calling SYNC_ORG_ASSIGNMENTS');
5690: END IF;
5691:
5692: sync_org_assignments (p_document_id, p_revision_num, p_draft_id);

Line 5689: PO_LOG.stmt(d_module, d_position, 'Calling SYNC_ORG_ASSIGNMENTS');

5685: IF (l_ga_flag = 'Y') THEN
5686:
5687: d_position := 230;
5688: IF (PO_LOG.d_stmt) THEN
5689: PO_LOG.stmt(d_module, d_position, 'Calling SYNC_ORG_ASSIGNMENTS');
5690: END IF;
5691:
5692: sync_org_assignments (p_document_id, p_revision_num, p_draft_id);
5693:

Line 5697: IF (PO_LOG.d_stmt) THEN

5693:
5694: END IF; --IF (l_ga_flag = 'Y')
5695:
5696: d_position := 240;
5697: IF (PO_LOG.d_stmt) THEN
5698: PO_LOG.stmt(d_module, d_position, 'Calling SYNC_NOTIFICATION_CONTROLS');
5699: END IF;
5700:
5701: sync_notification_controls (p_document_id, p_revision_num, p_draft_id);

Line 5698: PO_LOG.stmt(d_module, d_position, 'Calling SYNC_NOTIFICATION_CONTROLS');

5694: END IF; --IF (l_ga_flag = 'Y')
5695:
5696: d_position := 240;
5697: IF (PO_LOG.d_stmt) THEN
5698: PO_LOG.stmt(d_module, d_position, 'Calling SYNC_NOTIFICATION_CONTROLS');
5699: END IF;
5700:
5701: sync_notification_controls (p_document_id, p_revision_num, p_draft_id);
5702:

Line 5705: IF (PO_LOG.d_stmt) THEN

5701: sync_notification_controls (p_document_id, p_revision_num, p_draft_id);
5702:
5703: --Sync UDA Data for UDA Enabled Documents
5704: d_position := 250;
5705: IF (PO_LOG.d_stmt) THEN
5706: PO_LOG.stmt(d_module, d_position, 'Calling SYNC_UDA_ATTRIBS');
5707: END IF;
5708:
5709: sync_uda_attribs(p_document_id, p_document_type,

Line 5706: PO_LOG.stmt(d_module, d_position, 'Calling SYNC_UDA_ATTRIBS');

5702:
5703: --Sync UDA Data for UDA Enabled Documents
5704: d_position := 250;
5705: IF (PO_LOG.d_stmt) THEN
5706: PO_LOG.stmt(d_module, d_position, 'Calling SYNC_UDA_ATTRIBS');
5707: END IF;
5708:
5709: sync_uda_attribs(p_document_id, p_document_type,
5710: p_document_subtype, p_revision_num, p_draft_id);