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

Line 172: IF (PO_LOG.d_stmt) THEN

168: when others then null;
169: end;
170:
171: x_progress := 'Header attachment exists for Modification with draft_id '||p_draft_id;
172: IF (PO_LOG.d_stmt) THEN
173: PO_LOG.stmt(d_module, d_position, x_progress);
174: END IF;
175:
176: if l_header_attach_exist = 'Y' then

Line 173: PO_LOG.stmt(d_module, d_position, x_progress);

169: end;
170:
171: x_progress := 'Header attachment exists for Modification with draft_id '||p_draft_id;
172: IF (PO_LOG.d_stmt) THEN
173: PO_LOG.stmt(d_module, d_position, x_progress);
174: END IF;
175:
176: if l_header_attach_exist = 'Y' then
177: process_attachments('PO_HEADERS', p_document_id, p_draft_id);

Line 179: IF (PO_LOG.d_stmt) THEN

175:
176: if l_header_attach_exist = 'Y' then
177: process_attachments('PO_HEADERS', p_document_id, p_draft_id);
178: x_progress := 'Header attachment copied from Modification to header ';
179: IF (PO_LOG.d_stmt) THEN
180: PO_LOG.stmt(d_module, d_position, x_progress);
181: END IF;
182:
183: end if;

Line 180: PO_LOG.stmt(d_module, d_position, x_progress);

176: if l_header_attach_exist = 'Y' then
177: process_attachments('PO_HEADERS', p_document_id, p_draft_id);
178: x_progress := 'Header attachment copied from Modification to header ';
179: IF (PO_LOG.d_stmt) THEN
180: PO_LOG.stmt(d_module, d_position, x_progress);
181: END IF;
182:
183: end if;
184:

Line 192: IF (PO_LOG.d_stmt) THEN

188: x_progress := 'Line attachment exists for Modification with draft_id '||p_draft_id||
189: ' and line id '||l_rec.po_line_id;
190: process_attachments('PO_LINES', l_rec.po_line_id, p_draft_id);
191: x_progress := 'Line attachment copied from Mod line to line ';
192: IF (PO_LOG.d_stmt) THEN
193: PO_LOG.stmt(d_module, d_position, x_progress);
194: END IF;
195: end loop;
196:

Line 193: PO_LOG.stmt(d_module, d_position, x_progress);

189: ' and line id '||l_rec.po_line_id;
190: process_attachments('PO_LINES', l_rec.po_line_id, p_draft_id);
191: x_progress := 'Line attachment copied from Mod line to line ';
192: IF (PO_LOG.d_stmt) THEN
193: PO_LOG.stmt(d_module, d_position, x_progress);
194: END IF;
195: end loop;
196:
197: d_position := 20;

Line 204: IF (PO_LOG.d_stmt) THEN

200: x_progress := 'Shipment attachment exists for Modification with draft_id '||p_draft_id||
201: ' and line loc id '||ll_rec.line_location_id;
202: process_attachments('PO_SHIPMENTS', ll_rec.line_location_id, p_draft_id);
203: x_progress := 'Shipment attachment copied from Mod shipment to shipment ';
204: IF (PO_LOG.d_stmt) THEN
205: PO_LOG.stmt(d_module, d_position, x_progress);
206: END IF;
207: end loop;
208:

Line 205: PO_LOG.stmt(d_module, d_position, x_progress);

201: ' and line loc id '||ll_rec.line_location_id;
202: process_attachments('PO_SHIPMENTS', ll_rec.line_location_id, p_draft_id);
203: x_progress := 'Shipment attachment copied from Mod shipment to shipment ';
204: IF (PO_LOG.d_stmt) THEN
205: PO_LOG.stmt(d_module, d_position, x_progress);
206: END IF;
207: end loop;
208:
209: Exception

Line 213: IF (PO_LOG.d_stmt) THEN

209: Exception
210: When Others Then
211: d_position := 30;
212: x_progress := 'PO_DRAFT_MERGE_PKG.merge_upgraded_attachments: Exception';
213: IF (PO_LOG.d_stmt) THEN
214: PO_LOG.stmt(d_module, d_position, x_progress);
215: END IF;
216: raise;
217: End merge_upgraded_attachments;

Line 214: PO_LOG.stmt(d_module, d_position, x_progress);

210: When Others Then
211: d_position := 30;
212: x_progress := 'PO_DRAFT_MERGE_PKG.merge_upgraded_attachments: Exception';
213: IF (PO_LOG.d_stmt) THEN
214: PO_LOG.stmt(d_module, d_position, x_progress);
215: END IF;
216: raise;
217: End merge_upgraded_attachments;
218:

Line 1510: IF (PO_LOG.d_stmt) THEN

1506: --Fetch copied records
1507:
1508: --Fetch copied records
1509: x_progress := 'Merging copied records for Modification with draft_id '||p_draft_id;
1510: IF (PO_LOG.d_stmt) THEN
1511: PO_LOG.stmt(d_module, d_position, x_progress);
1512: END IF;
1513:
1514: for l_rec in modified_header_attachments_c(p_header_id,p_draft_id,'PO_HEADERS') LOOP

Line 1511: PO_LOG.stmt(d_module, d_position, x_progress);

1507:
1508: --Fetch copied records
1509: x_progress := 'Merging copied records for Modification with draft_id '||p_draft_id;
1510: IF (PO_LOG.d_stmt) THEN
1511: PO_LOG.stmt(d_module, d_position, x_progress);
1512: END IF;
1513:
1514: for l_rec in modified_header_attachments_c(p_header_id,p_draft_id,'PO_HEADERS') LOOP
1515: --delete the old records

Line 1535: IF (PO_LOG.d_stmt) THEN

1531:
1532: d_position := 20;
1533: --Fetch deleted records
1534: x_progress := 'Deleting attachments marked for deletion by draft_id '||p_draft_id;
1535: IF (PO_LOG.d_stmt) THEN
1536: PO_LOG.stmt(d_module, d_position, x_progress);
1537: END IF;
1538:
1539:

Line 1536: PO_LOG.stmt(d_module, d_position, x_progress);

1532: d_position := 20;
1533: --Fetch deleted records
1534: x_progress := 'Deleting attachments marked for deletion by draft_id '||p_draft_id;
1535: IF (PO_LOG.d_stmt) THEN
1536: PO_LOG.stmt(d_module, d_position, x_progress);
1537: END IF;
1538:
1539:
1540: for l_rec in modified_header_attachments_c(p_header_id,p_draft_id,'PO_HEADERS_DEL') LOOP

Line 1552: IF (PO_LOG.d_stmt) THEN

1548:
1549: d_position := 30;
1550: --Fetch the new attachments adde
1551: x_progress := 'Merging new attachments added by draft_id '||p_draft_id;
1552: IF (PO_LOG.d_stmt) THEN
1553: PO_LOG.stmt(d_module, d_position, x_progress);
1554: END IF;
1555:
1556: FOR l_rec IN headers_with_new_attachments_c(p_header_id,p_draft_id) LOOP

Line 1553: PO_LOG.stmt(d_module, d_position, x_progress);

1549: d_position := 30;
1550: --Fetch the new attachments adde
1551: x_progress := 'Merging new attachments added by draft_id '||p_draft_id;
1552: IF (PO_LOG.d_stmt) THEN
1553: PO_LOG.stmt(d_module, d_position, x_progress);
1554: END IF;
1555:
1556: FOR l_rec IN headers_with_new_attachments_c(p_header_id,p_draft_id) LOOP
1557: fnd_attached_documents2_pkg.copy_attachments

Line 1570: IF (PO_LOG.d_stmt) THEN

1566: Exception
1567: When Others Then
1568: d_position := 40;
1569: x_progress := 'PO_DRAFT_MERGE_PKG.merge_header_attachments: Exception';
1570: IF (PO_LOG.d_stmt) THEN
1571: PO_LOG.stmt(d_module, d_position, x_progress);
1572: END IF;
1573: raise;
1574:

Line 1571: PO_LOG.stmt(d_module, d_position, x_progress);

1567: When Others Then
1568: d_position := 40;
1569: x_progress := 'PO_DRAFT_MERGE_PKG.merge_header_attachments: Exception';
1570: IF (PO_LOG.d_stmt) THEN
1571: PO_LOG.stmt(d_module, d_position, x_progress);
1572: END IF;
1573: raise;
1574:
1575: END MERGE_HEADER_ATTACHMENTS;

Line 1625: IF (PO_LOG.d_stmt) THEN

1621: d_position := 10;
1622:
1623: --Fetch copied records
1624: x_progress := 'Merging copied records for Modification with draft_id '||p_draft_id;
1625: IF (PO_LOG.d_stmt) THEN
1626: PO_LOG.stmt(d_module, d_position, x_progress);
1627: END IF;
1628:
1629: for l_rec in modified_line_attachments_c(p_draft_id,'PO_LINES') LOOP

Line 1626: PO_LOG.stmt(d_module, d_position, x_progress);

1622:
1623: --Fetch copied records
1624: x_progress := 'Merging copied records for Modification with draft_id '||p_draft_id;
1625: IF (PO_LOG.d_stmt) THEN
1626: PO_LOG.stmt(d_module, d_position, x_progress);
1627: END IF;
1628:
1629: for l_rec in modified_line_attachments_c(p_draft_id,'PO_LINES') LOOP
1630: --delete the old record

Line 1649: IF (PO_LOG.d_stmt) THEN

1645:
1646: d_position := 20;
1647: --Fetch deleted records
1648: x_progress := 'Deleting attachments marked for deletion by draft_id '||p_draft_id;
1649: IF (PO_LOG.d_stmt) THEN
1650: PO_LOG.stmt(d_module, d_position, x_progress);
1651: END IF;
1652:
1653: for l_rec in modified_line_attachments_c(p_draft_id,'PO_LINES_DEL') LOOP

Line 1650: PO_LOG.stmt(d_module, d_position, x_progress);

1646: d_position := 20;
1647: --Fetch deleted records
1648: x_progress := 'Deleting attachments marked for deletion by draft_id '||p_draft_id;
1649: IF (PO_LOG.d_stmt) THEN
1650: PO_LOG.stmt(d_module, d_position, x_progress);
1651: END IF;
1652:
1653: for l_rec in modified_line_attachments_c(p_draft_id,'PO_LINES_DEL') LOOP
1654: --delete the old record

Line 1665: IF (PO_LOG.d_stmt) THEN

1661:
1662: d_position := 30;
1663: --Fetch the new attachments adde
1664: x_progress := 'Merging new attachments added by draft_id '||p_draft_id;
1665: IF (PO_LOG.d_stmt) THEN
1666: PO_LOG.stmt(d_module, d_position, x_progress);
1667: END IF;
1668:
1669: FOR l_rec IN new_line_attachments_c(p_draft_id) LOOP

Line 1666: PO_LOG.stmt(d_module, d_position, x_progress);

1662: d_position := 30;
1663: --Fetch the new attachments adde
1664: x_progress := 'Merging new attachments added by draft_id '||p_draft_id;
1665: IF (PO_LOG.d_stmt) THEN
1666: PO_LOG.stmt(d_module, d_position, x_progress);
1667: END IF;
1668:
1669: FOR l_rec IN new_line_attachments_c(p_draft_id) LOOP
1670: --copy the new attachments

Line 1684: IF (PO_LOG.d_stmt) THEN

1680: Exception
1681: When Others Then
1682: d_position :=40;
1683: x_progress := 'PO_DRAFT_MERGE_PKG.merge_line_attachments: Exception';
1684: IF (PO_LOG.d_stmt) THEN
1685: PO_LOG.stmt(d_module, d_position, x_progress);
1686: END IF;
1687: raise;
1688:

Line 1685: PO_LOG.stmt(d_module, d_position, x_progress);

1681: When Others Then
1682: d_position :=40;
1683: x_progress := 'PO_DRAFT_MERGE_PKG.merge_line_attachments: Exception';
1684: IF (PO_LOG.d_stmt) THEN
1685: PO_LOG.stmt(d_module, d_position, x_progress);
1686: END IF;
1687: raise;
1688:
1689:

Line 1739: IF (PO_LOG.d_stmt) THEN

1735: d_position := 10;
1736:
1737: --Fetch copied records
1738: x_progress := 'Merging copied records for Modification with draft_id '||p_draft_id;
1739: IF (PO_LOG.d_stmt) THEN
1740: PO_LOG.stmt(d_module, d_position, x_progress);
1741: END IF;
1742:
1743: for l_rec in modified_line_loc_attachment_c(p_draft_id,'PO_SHIPMENTS') LOOP

Line 1740: PO_LOG.stmt(d_module, d_position, x_progress);

1736:
1737: --Fetch copied records
1738: x_progress := 'Merging copied records for Modification with draft_id '||p_draft_id;
1739: IF (PO_LOG.d_stmt) THEN
1740: PO_LOG.stmt(d_module, d_position, x_progress);
1741: END IF;
1742:
1743: for l_rec in modified_line_loc_attachment_c(p_draft_id,'PO_SHIPMENTS') LOOP
1744: --delete the old records

Line 1763: IF (PO_LOG.d_stmt) THEN

1759:
1760: d_position := 20;
1761: --Fetch deleted records
1762: x_progress := 'Deleting attachments marked for deletion by draft_id '||p_draft_id;
1763: IF (PO_LOG.d_stmt) THEN
1764: PO_LOG.stmt(d_module, d_position, x_progress);
1765: END IF;
1766: for l_rec in modified_line_loc_attachment_c(p_draft_id,'PO_SHIPMENTS_DEL') LOOP
1767: --delete the records

Line 1764: PO_LOG.stmt(d_module, d_position, x_progress);

1760: d_position := 20;
1761: --Fetch deleted records
1762: x_progress := 'Deleting attachments marked for deletion by draft_id '||p_draft_id;
1763: IF (PO_LOG.d_stmt) THEN
1764: PO_LOG.stmt(d_module, d_position, x_progress);
1765: END IF;
1766: for l_rec in modified_line_loc_attachment_c(p_draft_id,'PO_SHIPMENTS_DEL') LOOP
1767: --delete the records
1768: fnd_attached_documents3_pkg.delete_row

Line 1778: IF (PO_LOG.d_stmt) THEN

1774:
1775: d_position := 30;
1776: --Fetch the new attachments adde
1777: x_progress := 'Merging new attachments added by draft_id '||p_draft_id;
1778: IF (PO_LOG.d_stmt) THEN
1779: PO_LOG.stmt(d_module, d_position, x_progress);
1780: END IF;
1781: FOR l_rec IN new_line_loc_attachment_c(p_draft_id) LOOP
1782: --copy the new attachments

Line 1779: PO_LOG.stmt(d_module, d_position, x_progress);

1775: d_position := 30;
1776: --Fetch the new attachments adde
1777: x_progress := 'Merging new attachments added by draft_id '||p_draft_id;
1778: IF (PO_LOG.d_stmt) THEN
1779: PO_LOG.stmt(d_module, d_position, x_progress);
1780: END IF;
1781: FOR l_rec IN new_line_loc_attachment_c(p_draft_id) LOOP
1782: --copy the new attachments
1783: fnd_attached_documents2_pkg.copy_attachments

Line 1796: IF (PO_LOG.d_stmt) THEN

1792: Exception
1793: When Others Then
1794: d_position := 40;
1795: x_progress := 'PO_DRAFT_MERGE_PKG.merge_line_location_attachment: Exception';
1796: IF (PO_LOG.d_stmt) THEN
1797: PO_LOG.stmt(d_module, d_position, x_progress);
1798: END IF;
1799: raise;
1800:

Line 1797: PO_LOG.stmt(d_module, d_position, x_progress);

1793: When Others Then
1794: d_position := 40;
1795: x_progress := 'PO_DRAFT_MERGE_PKG.merge_line_location_attachment: Exception';
1796: IF (PO_LOG.d_stmt) THEN
1797: PO_LOG.stmt(d_module, d_position, x_progress);
1798: END IF;
1799: raise;
1800:
1801: END MERGE_LINE_LOCATION_ATTACHMENT;

Line 2021: IF (PO_LOG.d_proc) THEN

2017: l_effective_date po_headers_all.clm_effective_date%TYPE;
2018: BEGIN
2019:
2020: d_progress := 0;
2021: IF (PO_LOG.d_proc) THEN
2022: PO_LOG.proc_begin(d_module);
2023: PO_LOG.proc_begin(d_module, 'p_document_id', p_document_id);
2024: PO_LOG.proc_begin(d_module, 'p_draft_id', p_draft_id);
2025: END IF;

Line 2022: PO_LOG.proc_begin(d_module);

2018: BEGIN
2019:
2020: d_progress := 0;
2021: IF (PO_LOG.d_proc) THEN
2022: PO_LOG.proc_begin(d_module);
2023: PO_LOG.proc_begin(d_module, 'p_document_id', p_document_id);
2024: PO_LOG.proc_begin(d_module, 'p_draft_id', p_draft_id);
2025: END IF;
2026:

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

2019:
2020: d_progress := 0;
2021: IF (PO_LOG.d_proc) THEN
2022: PO_LOG.proc_begin(d_module);
2023: PO_LOG.proc_begin(d_module, 'p_document_id', p_document_id);
2024: PO_LOG.proc_begin(d_module, 'p_draft_id', p_draft_id);
2025: END IF;
2026:
2027: -- Take the Clm Effective date / Mod Effective Date into l_effective_date

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

2020: d_progress := 0;
2021: IF (PO_LOG.d_proc) THEN
2022: PO_LOG.proc_begin(d_module);
2023: PO_LOG.proc_begin(d_module, 'p_document_id', p_document_id);
2024: PO_LOG.proc_begin(d_module, 'p_draft_id', p_draft_id);
2025: END IF;
2026:
2027: -- Take the Clm Effective date / Mod Effective Date into l_effective_date
2028: -- For awards need_by_date/promise_date/pop_dates will be clm_effective_date + periods

Line 2053: IF (PO_LOG.d_stmt) THEN

2049:
2050: END IF;
2051:
2052:
2053: IF (PO_LOG.d_stmt) THEN
2054: PO_LOG.stmt(d_module, d_progress, 'effective date : ', l_effective_date);
2055: END IF;
2056:
2057: -- Update need by date

Line 2054: PO_LOG.stmt(d_module, d_progress, 'effective date : ', l_effective_date);

2050: END IF;
2051:
2052:
2053: IF (PO_LOG.d_stmt) THEN
2054: PO_LOG.stmt(d_module, d_progress, 'effective date : ', l_effective_date);
2055: END IF;
2056:
2057: -- Update need by date
2058: -- Only when After Date of Contract or Notice of Award event is used

Line 2085: IF (PO_LOG.d_stmt) THEN

2081: AND poll.change_status = 'NEW';
2082:
2083: d_progress := 3;
2084:
2085: IF (PO_LOG.d_stmt) THEN
2086: PO_LOG.stmt(d_module, d_progress, 'Updated Need By Date in po_line_locations_draft_all - No of rows updated :' , SQL%ROWCOUNT);
2087: END IF;
2088:
2089: UPDATE po_line_locations_all poll

Line 2086: PO_LOG.stmt(d_module, d_progress, 'Updated Need By Date in po_line_locations_draft_all - No of rows updated :' , SQL%ROWCOUNT);

2082:
2083: d_progress := 3;
2084:
2085: IF (PO_LOG.d_stmt) THEN
2086: PO_LOG.stmt(d_module, d_progress, 'Updated Need By Date in po_line_locations_draft_all - No of rows updated :' , SQL%ROWCOUNT);
2087: END IF;
2088:
2089: UPDATE po_line_locations_all poll
2090: SET poll.need_by_date = po_core_s3.Add_period(l_effective_date,

Line 2116: IF (PO_LOG.d_stmt) THEN

2112: AND polld.change_status = 'NEW') );
2113:
2114: d_progress := 4;
2115:
2116: IF (PO_LOG.d_stmt) THEN
2117: PO_LOG.stmt(d_module, d_progress, 'Updated Need By Date in po_line_locations_all- No of rows updated :' , SQL%ROWCOUNT);
2118: END IF;
2119:
2120: -- Update Promised Date

Line 2117: PO_LOG.stmt(d_module, d_progress, 'Updated Need By Date in po_line_locations_all- No of rows updated :' , SQL%ROWCOUNT);

2113:
2114: d_progress := 4;
2115:
2116: IF (PO_LOG.d_stmt) THEN
2117: PO_LOG.stmt(d_module, d_progress, 'Updated Need By Date in po_line_locations_all- No of rows updated :' , SQL%ROWCOUNT);
2118: END IF;
2119:
2120: -- Update Promised Date
2121: -- Only when After Date of Contract or Notice of Award event is used

Line 2149: IF (PO_LOG.d_stmt) THEN

2145: AND poll.draft_id = p_draft_id
2146: AND poll.change_status = 'NEW';
2147:
2148: d_progress := 5;
2149: IF (PO_LOG.d_stmt) THEN
2150: PO_LOG.stmt(d_module, d_progress, 'Updated Promised in po_line_locations_draft_all- No of rows updated :' , SQL%ROWCOUNT);
2151: END IF;
2152:
2153: UPDATE po_line_locations_all poll

Line 2150: PO_LOG.stmt(d_module, d_progress, 'Updated Promised in po_line_locations_draft_all- No of rows updated :' , SQL%ROWCOUNT);

2146: AND poll.change_status = 'NEW';
2147:
2148: d_progress := 5;
2149: IF (PO_LOG.d_stmt) THEN
2150: PO_LOG.stmt(d_module, d_progress, 'Updated Promised in po_line_locations_draft_all- No of rows updated :' , SQL%ROWCOUNT);
2151: END IF;
2152:
2153: UPDATE po_line_locations_all poll
2154: SET poll.promised_date = po_core_s3.Add_period(l_effective_date,

Line 2181: IF (PO_LOG.d_stmt) THEN

2177: AND polld.draft_id = p_draft_id
2178: AND polld.change_status = 'NEW') );
2179:
2180: d_progress := 6;
2181: IF (PO_LOG.d_stmt) THEN
2182: PO_LOG.stmt(d_module, d_progress, 'Updated Promised in po_line_locations_all- No of rows updated :' , SQL%ROWCOUNT);
2183: END IF;
2184:
2185: -- Update POP Start Date

Line 2182: PO_LOG.stmt(d_module, d_progress, 'Updated Promised in po_line_locations_all- No of rows updated :' , SQL%ROWCOUNT);

2178: AND polld.change_status = 'NEW') );
2179:
2180: d_progress := 6;
2181: IF (PO_LOG.d_stmt) THEN
2182: PO_LOG.stmt(d_module, d_progress, 'Updated Promised in po_line_locations_all- No of rows updated :' , SQL%ROWCOUNT);
2183: END IF;
2184:
2185: -- Update POP Start Date
2186: -- Only when After Date of Contract or Notice of Award event is used

Line 2213: IF (PO_LOG.d_stmt) THEN

2209: AND poll.draft_id = p_draft_id
2210: AND poll.change_status = 'NEW';
2211:
2212: d_progress := 7;
2213: IF (PO_LOG.d_stmt) THEN
2214: PO_LOG.stmt(d_module, d_progress, 'Updated POP Start Date in po_line_locations_draft_all - No of rows updated :' , SQL%ROWCOUNT);
2215: END IF;
2216:
2217: UPDATE po_line_locations_all poll

Line 2214: PO_LOG.stmt(d_module, d_progress, 'Updated POP Start Date in po_line_locations_draft_all - No of rows updated :' , SQL%ROWCOUNT);

2210: AND poll.change_status = 'NEW';
2211:
2212: d_progress := 7;
2213: IF (PO_LOG.d_stmt) THEN
2214: PO_LOG.stmt(d_module, d_progress, 'Updated POP Start Date in po_line_locations_draft_all - No of rows updated :' , SQL%ROWCOUNT);
2215: END IF;
2216:
2217: UPDATE po_line_locations_all poll
2218: SET poll.CLM_PERIOD_PERF_START_DATE = po_core_s3.Add_period(l_effective_date,

Line 2244: IF (PO_LOG.d_stmt) THEN

2240: AND polld.draft_id = p_draft_id
2241: AND polld.change_status = 'NEW') );
2242:
2243: d_progress := 8;
2244: IF (PO_LOG.d_stmt) THEN
2245: PO_LOG.stmt(d_module, d_progress, 'Updated POP Start Date in po_line_locations_all - No of rows updated :' , SQL%ROWCOUNT);
2246: END IF;
2247:
2248: -- Update POP End Date

Line 2245: PO_LOG.stmt(d_module, d_progress, 'Updated POP Start Date in po_line_locations_all - No of rows updated :' , SQL%ROWCOUNT);

2241: AND polld.change_status = 'NEW') );
2242:
2243: d_progress := 8;
2244: IF (PO_LOG.d_stmt) THEN
2245: PO_LOG.stmt(d_module, d_progress, 'Updated POP Start Date in po_line_locations_all - No of rows updated :' , SQL%ROWCOUNT);
2246: END IF;
2247:
2248: -- Update POP End Date
2249: -- Only when After Date of Contract or Notice of Award event is used

Line 2275: IF (PO_LOG.d_stmt) THEN

2271: AND poll.draft_id = p_draft_id
2272: AND poll.change_status = 'NEW';
2273:
2274: d_progress := 9;
2275: IF (PO_LOG.d_stmt) THEN
2276: PO_LOG.stmt(d_module, d_progress, 'Updated POP End Date in po_line_locations_draft_all - No of rows updated :' , SQL%ROWCOUNT);
2277: END IF;
2278:
2279: UPDATE po_line_locations_all poll

Line 2276: PO_LOG.stmt(d_module, d_progress, 'Updated POP End Date in po_line_locations_draft_all - No of rows updated :' , SQL%ROWCOUNT);

2272: AND poll.change_status = 'NEW';
2273:
2274: d_progress := 9;
2275: IF (PO_LOG.d_stmt) THEN
2276: PO_LOG.stmt(d_module, d_progress, 'Updated POP End Date in po_line_locations_draft_all - No of rows updated :' , SQL%ROWCOUNT);
2277: END IF;
2278:
2279: UPDATE po_line_locations_all poll
2280: SET poll.CLM_PERIOD_PERF_END_DATE = po_core_s3.Add_period(poll.clm_period_perf_start_date,

Line 2306: IF (PO_LOG.d_stmt) THEN

2302: AND polld.draft_id = p_draft_id
2303: AND polld.change_status = 'NEW') );
2304:
2305: d_progress := 10;
2306: IF (PO_LOG.d_stmt) THEN
2307: PO_LOG.stmt(d_module, d_progress, 'Updated POP End Date in po_line_locations_all - No of rows updated :' , SQL%ROWCOUNT);
2308: END IF;
2309:
2310: -- Sync Archive

Line 2307: PO_LOG.stmt(d_module, d_progress, 'Updated POP End Date in po_line_locations_all - No of rows updated :' , SQL%ROWCOUNT);

2303: AND polld.change_status = 'NEW') );
2304:
2305: d_progress := 10;
2306: IF (PO_LOG.d_stmt) THEN
2307: PO_LOG.stmt(d_module, d_progress, 'Updated POP End Date in po_line_locations_all - No of rows updated :' , SQL%ROWCOUNT);
2308: END IF;
2309:
2310: -- Sync Archive
2311: FOR poll in (SELECT poll.po_header_id,

Line 2352: IF (PO_LOG.d_stmt) THEN

2348:
2349: END LOOP;
2350:
2351: d_progress := 11;
2352: IF (PO_LOG.d_stmt) THEN
2353: PO_LOG.stmt(d_module, d_progress, 'Updated POP End Date in po_line_locations_archive_all - No of rows updated :' , SQL%ROWCOUNT);
2354: END IF;
2355:
2356:

Line 2353: PO_LOG.stmt(d_module, d_progress, 'Updated POP End Date in po_line_locations_archive_all - No of rows updated :' , SQL%ROWCOUNT);

2349: END LOOP;
2350:
2351: d_progress := 11;
2352: IF (PO_LOG.d_stmt) THEN
2353: PO_LOG.stmt(d_module, d_progress, 'Updated POP End Date in po_line_locations_archive_all - No of rows updated :' , SQL%ROWCOUNT);
2354: END IF;
2355:
2356:
2357: EXCEPTION

Line 2360: IF (PO_LOG.d_stmt) THEN

2356:
2357: EXCEPTION
2358:
2359: WHEN OTHERS THEN
2360: IF (PO_LOG.d_stmt) THEN
2361: PO_LOG.stmt(d_module, d_progress, 'Exception in update_delivery_event_attr ' || sqlerrm);
2362: END IF;
2363:
2364: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2361: PO_LOG.stmt(d_module, d_progress, 'Exception in update_delivery_event_attr ' || sqlerrm);

2357: EXCEPTION
2358:
2359: WHEN OTHERS THEN
2360: IF (PO_LOG.d_stmt) THEN
2361: PO_LOG.stmt(d_module, d_progress, 'Exception in update_delivery_event_attr ' || sqlerrm);
2362: END IF;
2363:
2364: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2365: