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_R12_CAT_UPG_EXISTING_DOCS dependencies on PO_R12_CAT_UPG_DEBUG

Line 4: g_debug BOOLEAN := PO_R12_CAT_UPG_DEBUG.is_logging_enabled;

1: PACKAGE BODY PO_R12_CAT_UPG_EXISTING_DOCS AS
2: /* $Header: PO_R12_CAT_UPG_EXISTING_DOCS.plb 120.10 2006/08/18 21:58:34 pthapliy noship $ */
3:
4: g_debug BOOLEAN := PO_R12_CAT_UPG_DEBUG.is_logging_enabled;
5:
6: g_pkg_name CONSTANT VARCHAR2(30) := 'PO_R12_CAT_UPG_EXISTING_DOCS';
7: g_module_prefix CONSTANT VARCHAR2(100) := 'po.plsql.' || g_pkg_name || '.';
8:

Line 168: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'START'); END IF;

164: l_log_head CONSTANT VARCHAR2(100) := g_module_prefix || l_api_name;
165: l_progress VARCHAR2(3) := '000';
166:
167: BEGIN
168: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'START'); END IF;
169:
170: l_progress := '010';
171:
172: -- SQL What: If this is the first time the upgrade script has been run

Line 185: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'lines_already_upgraded flag='||l_was_R12_upg_ever_run_before); END IF;

181: AND POL.po_line_id between p_start_id and p_end_id
182: AND rownum=1;
183:
184: l_progress := '030';
185: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'lines_already_upgraded flag='||l_was_R12_upg_ever_run_before); END IF;
186:
187: IF (l_was_R12_upg_ever_run_before = 0) THEN
188: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'early END'); END IF;
189: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 188: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'early END'); END IF;

184: l_progress := '030';
185: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'lines_already_upgraded flag='||l_was_R12_upg_ever_run_before); END IF;
186:
187: IF (l_was_R12_upg_ever_run_before = 0) THEN
188: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'early END'); END IF;
189: x_return_status := FND_API.G_RET_STS_SUCCESS;
190: RETURN;
191: END IF;
192:

Line 195: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Inside loop'); END IF;

191: END IF;
192:
193: l_progress := '040';
194: LOOP
195: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Inside loop'); END IF;
196: -- The following exception occurs if we dont do this check for existence:
197: -- ORA-06531: Reference to uninitialized collection.
198: IF (gPoLineIds.exists(1)) THEN
199: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Modified Lines; gPoLineIds.DELETE'); END IF;

Line 199: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Modified Lines; gPoLineIds.DELETE'); END IF;

195: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Inside loop'); END IF;
196: -- The following exception occurs if we dont do this check for existence:
197: -- ORA-06531: Reference to uninitialized collection.
198: IF (gPoLineIds.exists(1)) THEN
199: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Modified Lines; gPoLineIds.DELETE'); END IF;
200: gPoLineIds.DELETE;
201: gIpCategoryIds.DELETE;
202: gInvItemIds.DELETE;
203: gPoOrgIds.DELETE;

Line 216: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Opening Cursor'); END IF;

212: END IF;
213:
214: -- Get the PO Lines which have not been updated yet
215: l_progress := '050';
216: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Opening Cursor'); END IF;
217: OPEN getModifiedLinesCsr(p_start_id, p_end_id);
218:
219: l_progress := '060';
220: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Fetching cursor'); END IF;

Line 220: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Fetching cursor'); END IF;

216: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Opening Cursor'); END IF;
217: OPEN getModifiedLinesCsr(p_start_id, p_end_id);
218:
219: l_progress := '060';
220: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Fetching cursor'); END IF;
221: -- No need of LIMIT batchsize because the cursor is returning only
222: -- a batch of lines (start and end line id)
223: FETCH getModifiedLinesCsr
224: BULK COLLECT into gPoLineIds,

Line 234: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Closing cursor'); END IF;

230: gUpdatedAttribute,
231: gRecreateAttribRow, gRecreateAttribTLPRow;
232:
233: l_progress := '070';
234: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Closing cursor'); END IF;
235: CLOSE getModifiedLinesCsr;
236:
237: l_progress := '080';
238: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'gPoLineIds.COUNT='||gPoLineIds.COUNT); END IF;

Line 238: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'gPoLineIds.COUNT='||gPoLineIds.COUNT); END IF;

234: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Closing cursor'); END IF;
235: CLOSE getModifiedLinesCsr;
236:
237: l_progress := '080';
238: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'gPoLineIds.COUNT='||gPoLineIds.COUNT); END IF;
239: EXIT WHEN gPoLineIds.COUNT = 0;
240:
241: l_progress := '090';
242:

Line 243: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Updating PO Lines'); END IF;

239: EXIT WHEN gPoLineIds.COUNT = 0;
240:
241: l_progress := '090';
242:
243: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Updating PO Lines'); END IF;
244:
245: -- SQL What: Update the PO Lines with ip_category_id
246: -- SQL Why : Part of catalog upgrade requirements
247: -- SQL Join: po_line_id

Line 261: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Number of PO_LINES_ALL rows updated='||x_rows_processed); END IF;

257: AND gUpdatedAttribute(i) = 'IP_CATEGORY_ID';
258:
259: x_rows_processed := SQL%ROWCOUNT; --Bug#5156673:
260:
261: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Number of PO_LINES_ALL rows updated='||x_rows_processed); END IF;
262:
263: l_progress := '100';
264:
265: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'PO Lines: Deleting Attributes'); END IF;

Line 265: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'PO Lines: Deleting Attributes'); END IF;

261: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Number of PO_LINES_ALL rows updated='||x_rows_processed); END IF;
262:
263: l_progress := '100';
264:
265: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'PO Lines: Deleting Attributes'); END IF;
266:
267: -- SQL What: For item change erase the attributes
268: -- SQL Why : Instead of erasing the columns, just delete the rows from
269: -- attributes table and recreate the row later.

Line 276: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Number of PO_ATTRIBUTE_VALUES rows deleted='||SQL%rowcount); END IF;

272: DELETE FROM PO_ATTRIBUTE_VALUES POAT
273: WHERE po_line_id = gPoLineIds(i)
274: AND (gRecreateAttribRow(i) = 'Y' OR gUpdatedAttribute(i) = 'LINE_DELETED');
275:
276: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Number of PO_ATTRIBUTE_VALUES rows deleted='||SQL%rowcount); END IF;
277:
278: l_progress := '110';
279:
280: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Deleting Attribute TLP'); END IF;

Line 280: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Deleting Attribute TLP'); END IF;

276: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Number of PO_ATTRIBUTE_VALUES rows deleted='||SQL%rowcount); END IF;
277:
278: l_progress := '110';
279:
280: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Deleting Attribute TLP'); END IF;
281:
282: -- SQL What: For item change erase the attributes TLP
283: -- SQL Why : Instead of erasing the columns, just delete the rows from
284: -- attributes TLP table and recreate the row later.

Line 292: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Number of PO_ATTRIBUTE_VALUES_TLP rows deleted='||SQL%rowcount); END IF;

288: WHERE po_line_id = gPoLineIds(i)
289: AND (gRecreateAttribTLPRow(i) = 'Y' OR gUpdatedAttribute(i) = 'LINE_DELETED');
290:
291:
292: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Number of PO_ATTRIBUTE_VALUES_TLP rows deleted='||SQL%rowcount); END IF;
293:
294: l_progress := '120';
295: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Updating Attributes'); END IF;
296:

Line 295: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Updating Attributes'); END IF;

291:
292: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Number of PO_ATTRIBUTE_VALUES_TLP rows deleted='||SQL%rowcount); END IF;
293:
294: l_progress := '120';
295: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Updating Attributes'); END IF;
296:
297: -- SQL What: Update the PO attribute values TLP when the description has changed
298: -- SQL Why : Sync up the description at the TLP level
299: -- SQL Join: po_line_id

Line 307: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Number of PO_ATTRIBUTE_VALUES_TLP rows updated='||SQL%rowcount); END IF;

303: last_updated_program = g_R12_MIGRATION_PROGRAM
304: WHERE po_line_id = gPoLineIds(i)
305: AND gUpdatedAttribute(i) = 'DESCRIPTION';
306:
307: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Number of PO_ATTRIBUTE_VALUES_TLP rows updated='||SQL%rowcount); END IF;
308:
309: l_progress := '130';
310:
311: -- Lines for which attributes records need to be created are in gPoLineIds

Line 324: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'END'); END IF;

320:
321: END LOOP;
322: x_return_status := FND_API.G_RET_STS_SUCCESS;
323:
324: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'END'); END IF;
325: EXCEPTION
326: WHEN OTHERS THEN
327: ROLLBACK;
328: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Unexpected exception'); END IF;

Line 328: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Unexpected exception'); END IF;

324: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'END'); END IF;
325: EXCEPTION
326: WHEN OTHERS THEN
327: ROLLBACK;
328: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Unexpected exception'); END IF;
329: RAISE_APPLICATION_ERROR(g_err_num,l_log_head||','||l_progress || ','|| SQLERRM);
330: END process_modified_po_lines;
331:
332: --------------------------------------------------------------------------------

Line 393: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'START'); END IF;

389: l_log_head CONSTANT VARCHAR2(100) := g_module_prefix || l_api_name;
390: l_progress VARCHAR2(3) := '000';
391:
392: BEGIN
393: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'START'); END IF;
394:
395: l_progress := '010';
396:
397: LOOP

Line 403: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'New Lines; gPoLineIds.DELETE'); END IF;

399:
400: -- The following exception occurs if we dont do this check for existence:
401: -- ORA-06531: Reference to uninitialized collection.
402: IF (gPoLineIds.exists(1)) THEN
403: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'New Lines; gPoLineIds.DELETE'); END IF;
404: gPoLineIds.DELETE;
405: gIpCategoryIds.DELETE;
406: gInvItemIds.DELETE;
407: gPoOrgIds.DELETE;

Line 438: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Processing a batch with gPoLineIds.COUNT='||gPoLineIds.COUNT); END IF;

434: CLOSE getNonUpgradedLinesCsr;
435:
436:
437: l_progress := '070';
438: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Processing a batch with gPoLineIds.COUNT='||gPoLineIds.COUNT); END IF;
439: EXIT WHEN gPoLineIds.COUNT = 0;
440:
441: l_progress := '080';
442:

Line 461: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Number of PO_LINES_ALL rows updated='||x_rows_processed); END IF;

457: WHERE po_line_id = gPoLineIds(i);
458:
459: x_rows_processed := SQL%rowcount;--Bug#5156673
460:
461: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Number of PO_LINES_ALL rows updated='||x_rows_processed); END IF;
462:
463: -- IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Number of IP_CATEGORY_IDs loaded='||SQL%rowcount); END IF;
464:
465: l_progress := '100';

Line 463: -- IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Number of IP_CATEGORY_IDs loaded='||SQL%rowcount); END IF;

459: x_rows_processed := SQL%rowcount;--Bug#5156673
460:
461: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Number of PO_LINES_ALL rows updated='||x_rows_processed); END IF;
462:
463: -- IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Number of IP_CATEGORY_IDs loaded='||SQL%rowcount); END IF;
464:
465: l_progress := '100';
466: -- Lines for which attributes need to be created are in gPoLineIds
467: CREATE_LINE_ATTRIBUTES(p_batch_size, p_base_lang);

Line 480: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'END'); END IF;

476:
477: x_return_status := FND_API.G_RET_STS_SUCCESS;
478:
479: l_progress := '130';
480: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'END'); END IF;
481: EXCEPTION
482: WHEN OTHERS THEN
483: ROLLBACK;
484: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Unexpected exception'); END IF;

Line 484: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Unexpected exception'); END IF;

480: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'END'); END IF;
481: EXCEPTION
482: WHEN OTHERS THEN
483: ROLLBACK;
484: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Unexpected exception'); END IF;
485: RAISE_APPLICATION_ERROR(g_err_num,l_log_head||','||l_progress || ','|| SQLERRM);
486: END process_new_po_lines;
487:
488: --------------------------------------------------------------------------------

Line 515: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'START'); END IF;

511: l_log_head CONSTANT VARCHAR2(100) := g_module_prefix || l_api_name;
512: l_progress VARCHAR2(3) := '000';
513:
514: BEGIN
515: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'START'); END IF;
516:
517: IF g_debug THEN
518: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'gPoLineIds.COUNT='||gPoLineIds.COUNT);
519: IF (gPoLineIds.COUNT > 0) THEN

Line 518: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'gPoLineIds.COUNT='||gPoLineIds.COUNT);

514: BEGIN
515: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'START'); END IF;
516:
517: IF g_debug THEN
518: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'gPoLineIds.COUNT='||gPoLineIds.COUNT);
519: IF (gPoLineIds.COUNT > 0) THEN
520: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'gPoLineIds(1)='||gPoLineIds(1));
521: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'gPoReqTemplateNames(1)='||gPoReqTemplateNames(1));
522: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'gPoReqTemplateLineIds(1)='||gPoReqTemplateLineIds(1));

Line 520: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'gPoLineIds(1)='||gPoLineIds(1));

516:
517: IF g_debug THEN
518: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'gPoLineIds.COUNT='||gPoLineIds.COUNT);
519: IF (gPoLineIds.COUNT > 0) THEN
520: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'gPoLineIds(1)='||gPoLineIds(1));
521: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'gPoReqTemplateNames(1)='||gPoReqTemplateNames(1));
522: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'gPoReqTemplateLineIds(1)='||gPoReqTemplateLineIds(1));
523: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'gIpCategoryIds(1)='||gIpCategoryIds(1));
524: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'gInvItemIds(1)='||gInvItemIds(1));

Line 521: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'gPoReqTemplateNames(1)='||gPoReqTemplateNames(1));

517: IF g_debug THEN
518: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'gPoLineIds.COUNT='||gPoLineIds.COUNT);
519: IF (gPoLineIds.COUNT > 0) THEN
520: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'gPoLineIds(1)='||gPoLineIds(1));
521: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'gPoReqTemplateNames(1)='||gPoReqTemplateNames(1));
522: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'gPoReqTemplateLineIds(1)='||gPoReqTemplateLineIds(1));
523: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'gIpCategoryIds(1)='||gIpCategoryIds(1));
524: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'gInvItemIds(1)='||gInvItemIds(1));
525: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'gPoOrgIds(1)='||gPoOrgIds(1));

Line 522: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'gPoReqTemplateLineIds(1)='||gPoReqTemplateLineIds(1));

518: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'gPoLineIds.COUNT='||gPoLineIds.COUNT);
519: IF (gPoLineIds.COUNT > 0) THEN
520: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'gPoLineIds(1)='||gPoLineIds(1));
521: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'gPoReqTemplateNames(1)='||gPoReqTemplateNames(1));
522: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'gPoReqTemplateLineIds(1)='||gPoReqTemplateLineIds(1));
523: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'gIpCategoryIds(1)='||gIpCategoryIds(1));
524: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'gInvItemIds(1)='||gInvItemIds(1));
525: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'gPoOrgIds(1)='||gPoOrgIds(1));
526: END IF;

Line 523: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'gIpCategoryIds(1)='||gIpCategoryIds(1));

519: IF (gPoLineIds.COUNT > 0) THEN
520: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'gPoLineIds(1)='||gPoLineIds(1));
521: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'gPoReqTemplateNames(1)='||gPoReqTemplateNames(1));
522: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'gPoReqTemplateLineIds(1)='||gPoReqTemplateLineIds(1));
523: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'gIpCategoryIds(1)='||gIpCategoryIds(1));
524: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'gInvItemIds(1)='||gInvItemIds(1));
525: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'gPoOrgIds(1)='||gPoOrgIds(1));
526: END IF;
527: END IF;

Line 524: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'gInvItemIds(1)='||gInvItemIds(1));

520: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'gPoLineIds(1)='||gPoLineIds(1));
521: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'gPoReqTemplateNames(1)='||gPoReqTemplateNames(1));
522: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'gPoReqTemplateLineIds(1)='||gPoReqTemplateLineIds(1));
523: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'gIpCategoryIds(1)='||gIpCategoryIds(1));
524: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'gInvItemIds(1)='||gInvItemIds(1));
525: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'gPoOrgIds(1)='||gPoOrgIds(1));
526: END IF;
527: END IF;
528:

Line 525: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'gPoOrgIds(1)='||gPoOrgIds(1));

521: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'gPoReqTemplateNames(1)='||gPoReqTemplateNames(1));
522: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'gPoReqTemplateLineIds(1)='||gPoReqTemplateLineIds(1));
523: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'gIpCategoryIds(1)='||gIpCategoryIds(1));
524: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'gInvItemIds(1)='||gInvItemIds(1));
525: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'gPoOrgIds(1)='||gPoOrgIds(1));
526: END IF;
527: END IF;
528:
529: l_progress := '010';

Line 580: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Number of PO_ATTRIBUTE_VALUES rows inserted='||SQL%rowcount); END IF;

576: AND POAT.req_template_line_num = to_char(gPoReqTemplateLineIds(i))
577: AND POAT.org_id = gPoOrgIds(i));
578:
579: l_progress := '020';
580: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Number of PO_ATTRIBUTE_VALUES rows inserted='||SQL%rowcount); END IF;
581:
582: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'END'); END IF;
583: EXCEPTION
584: WHEN OTHERS THEN

Line 582: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'END'); END IF;

578:
579: l_progress := '020';
580: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Number of PO_ATTRIBUTE_VALUES rows inserted='||SQL%rowcount); END IF;
581:
582: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'END'); END IF;
583: EXCEPTION
584: WHEN OTHERS THEN
585: ROLLBACK;
586: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Unexpected exception:'||SQLERRM); END IF;

Line 586: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Unexpected exception:'||SQLERRM); END IF;

582: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'END'); END IF;
583: EXCEPTION
584: WHEN OTHERS THEN
585: ROLLBACK;
586: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Unexpected exception:'||SQLERRM); END IF;
587: RAISE_APPLICATION_ERROR(g_err_num,l_log_head||','||l_progress || ','|| SQLERRM);
588: END create_line_attributes;
589:
590: --------------------------------------------------------------------------------

Line 618: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'START'); END IF;

614: l_api_name CONSTANT VARCHAR2(30) := 'create_line_attributes_tlp';
615: l_log_head CONSTANT VARCHAR2(100) := g_module_prefix || l_api_name;
616: l_progress VARCHAR2(3) := '000';
617: BEGIN
618: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'START'); END IF;
619:
620: l_progress := '020';
621: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Inserting for description based items'); END IF;
622:

Line 621: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Inserting for description based items'); END IF;

617: BEGIN
618: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'START'); END IF;
619:
620: l_progress := '020';
621: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Inserting for description based items'); END IF;
622:
623: -- SQL What: Insert attributes TLP records for every line that has been just
624: -- processed and the attribute row does not already exist in
625: -- attributes_tlp table.

Line 679: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Number of PO_ATTRIBUTE_VALUES_TLP rows inserted by default='||SQL%rowcount); END IF;

675: AND POATLP.req_template_name = gPoReqTemplateNames(i)
676: AND POATLP.req_template_line_num = to_char(gPoReqTemplateLineIds(i))
677: AND POATLP.org_id = gPoOrgIds(i));
678:
679: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Number of PO_ATTRIBUTE_VALUES_TLP rows inserted by default='||SQL%rowcount); END IF;
680:
681: l_progress := '030';
682: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Inserting for item master items (pulling translations from INV)'); END IF;
683:

Line 682: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Inserting for item master items (pulling translations from INV)'); END IF;

678:
679: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Number of PO_ATTRIBUTE_VALUES_TLP rows inserted by default='||SQL%rowcount); END IF;
680:
681: l_progress := '030';
682: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Inserting for item master items (pulling translations from INV)'); END IF;
683:
684: -- SQL What: Handle for Item master based documents. Pull translations
685: -- from INV.
686: -- SQL Why : Only those records that have gRecreateAttribTLPRow(i)='Y', need

Line 742: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Number of PO_ATTRIBUTE_VALUES_TLP rows inserted due to item master translation='||SQL%rowcount); END IF;

738: AND POATLP.req_template_name = gPoReqTemplateNames(i)
739: AND POATLP.req_template_line_num = to_char(gPoReqTemplateLineIds(i))
740: AND POATLP.org_id = gPoOrgIds(i));
741:
742: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Number of PO_ATTRIBUTE_VALUES_TLP rows inserted due to item master translation='||SQL%rowcount); END IF;
743:
744: l_progress := '040';
745: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Inserting for item master items that have no translation available in base lang'); END IF;
746:

Line 745: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Inserting for item master items that have no translation available in base lang'); END IF;

741:
742: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Number of PO_ATTRIBUTE_VALUES_TLP rows inserted due to item master translation='||SQL%rowcount); END IF;
743:
744: l_progress := '040';
745: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Inserting for item master items that have no translation available in base lang'); END IF;
746:
747: -- SQL What: Handle those item master record that dont have translation in
748: -- the created_language of the Document header.
749: -- SQL Why : We need to create a default row with language=created_language

Line 811: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Number of PO_ATTRIBUTE_VALUES_TLP rows inserted due to nonexistence of item master in created_lang ='||SQL%rowcount); END IF;

807: FROM PO_ATTRIBUTE_VALUES_TLP POATLP
808: WHERE POATLP.language = POH.created_language
809: AND POATLP.po_line_id = gPoLineIds(i));
810:
811: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Number of PO_ATTRIBUTE_VALUES_TLP rows inserted due to nonexistence of item master in created_lang ='||SQL%rowcount); END IF;
812:
813: l_progress := '050';
814: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'END'); END IF;
815: EXCEPTION

Line 814: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'END'); END IF;

810:
811: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Number of PO_ATTRIBUTE_VALUES_TLP rows inserted due to nonexistence of item master in created_lang ='||SQL%rowcount); END IF;
812:
813: l_progress := '050';
814: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'END'); END IF;
815: EXCEPTION
816: WHEN OTHERS THEN
817: ROLLBACK;
818: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Unexpected exception'); END IF;

Line 818: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Unexpected exception'); END IF;

814: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'END'); END IF;
815: EXCEPTION
816: WHEN OTHERS THEN
817: ROLLBACK;
818: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Unexpected exception'); END IF;
819: RAISE_APPLICATION_ERROR(g_err_num,l_log_head||','||l_progress || ','|| SQLERRM);
820: END create_line_attributes_tlp;
821:
822: --------------------------------------------------------------------------------

Line 944: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'START'); END IF;

940:
941: l_was_R12_upg_ever_run_before NUMBER := 0;
942: l_current_batch NUMBER; -- Bug 5468308: Track the progress of the script
943: BEGIN
944: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'START'); END IF;
945:
946: l_progress := '020';
947:
948: -- SQL What: If this is the first time the upgrade script has been run

Line 962: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'early END'); END IF;

958:
959: l_progress := '030';
960:
961: IF (l_was_R12_upg_ever_run_before = 0) THEN
962: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'early END'); END IF;
963: RETURN;
964: END IF;
965:
966: l_progress := '040';

Line 973: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Modified RTs; gPoLineIds.DELETE'); END IF;

969: l_current_batch := l_current_batch + 1;
970: -- The following exception occurs if we dont do this check for existence:
971: -- ORA-06531: Reference to uninitialized collection.
972: IF (gPoLineIds.exists(1)) THEN
973: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Modified RTs; gPoLineIds.DELETE'); END IF;
974: gPoLineIds.DELETE;
975: gIpCategoryIds.DELETE;
976: gInvItemIds.DELETE;
977: gPoOrgIds.DELETE;

Line 1034: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Number of PO_REQEXPRESS_LINES_ALL rows updated='||SQL%rowcount); END IF;

1030: AND PORL.sequence_num = to_char(gPoReqTemplateLineIds(i))
1031: AND PORL.org_id = gPoOrgIds(i)
1032: AND gUpdatedAttribute(i) = 'IP_CATEGORY_ID';
1033:
1034: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Number of PO_REQEXPRESS_LINES_ALL rows updated='||SQL%rowcount); END IF;
1035:
1036: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Deleting Attributes:Template'); END IF;
1037:
1038: l_progress := '100';

Line 1036: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Deleting Attributes:Template'); END IF;

1032: AND gUpdatedAttribute(i) = 'IP_CATEGORY_ID';
1033:
1034: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Number of PO_REQEXPRESS_LINES_ALL rows updated='||SQL%rowcount); END IF;
1035:
1036: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Deleting Attributes:Template'); END IF;
1037:
1038: l_progress := '100';
1039: -- SQL What: For item change erase the attributes
1040: -- SQL Why : Instead of erasing the columns, just delete the rows from

Line 1050: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Number of PO_ATTRIBUTE_VALUES rows deleted='||SQL%rowcount); END IF;

1046: AND req_template_line_num = to_char(gPoReqTemplateLineIds(i))
1047: AND org_id = gPoOrgIds(i)
1048: AND (gRecreateAttribRow(i) = 'Y' OR gUpdatedAttribute(i) = 'LINE_DELETED');
1049:
1050: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Number of PO_ATTRIBUTE_VALUES rows deleted='||SQL%rowcount); END IF;
1051:
1052: l_progress := '110';
1053:
1054: -- SQL What: For item change erase the attributes ATLP

Line 1065: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Number of PO_ATTRIBUTE_VALUES_TLP rows deleted='||SQL%rowcount); END IF;

1061: AND req_template_line_num = to_char(gPoReqTemplateLineIds(i))
1062: AND org_id = gPoOrgIds(i)
1063: AND (gRecreateAttribTLPRow(i) = 'Y' OR gUpdatedAttribute(i) = 'LINE_DELETED');
1064:
1065: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Number of PO_ATTRIBUTE_VALUES_TLP rows deleted='||SQL%rowcount); END IF;
1066:
1067: l_progress := '120';
1068:
1069: -- SQL What: Update the PO attribute values TLP when the description has

Line 1082: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Number of PO_ATTRIBUTE_VALUES_TLP rows updated='||SQL%rowcount); END IF;

1078: AND req_template_line_num = to_char(gPoReqTemplateLineIds(i))
1079: AND org_id = gPoOrgIds(i)
1080: AND gUpdatedAttribute(i) = 'DESCRIPTION';
1081:
1082: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Number of PO_ATTRIBUTE_VALUES_TLP rows updated='||SQL%rowcount); END IF;
1083:
1084: l_progress := '130';
1085:
1086: -- Lines for which attributes records need to be created are in

Line 1100: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'END'); END IF;

1096: COMMIT;
1097: END LOOP;
1098:
1099: l_progress := '150';
1100: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'END'); END IF;
1101: EXCEPTION
1102: WHEN OTHERS THEN
1103: ROLLBACK;
1104: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Unexpected exception'); END IF;

Line 1104: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Unexpected exception'); END IF;

1100: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'END'); END IF;
1101: EXCEPTION
1102: WHEN OTHERS THEN
1103: ROLLBACK;
1104: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Unexpected exception'); END IF;
1105: RAISE_APPLICATION_ERROR(g_err_num,l_log_head||','||l_progress || ','|| SQLERRM);
1106: END process_modified_rt_lines;
1107:
1108: --------------------------------------------------------------------------------

Line 1153: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'START'); END IF;

1149: l_progress VARCHAR2(3) := '000';
1150:
1151: l_current_batch NUMBER; -- Bug 5468308: Track the progress of the script
1152: BEGIN
1153: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'START'); END IF;
1154:
1155: l_progress := '030';
1156: l_current_batch := 0;
1157: LOOP

Line 1163: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'New RTs; gPoLineIds.DELETE'); END IF;

1159:
1160: -- The following exception occurs if we dont do this check for existence:
1161: -- ORA-06531: Reference to uninitialized collection.
1162: IF (gPoLineIds.exists(1)) THEN
1163: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'New RTs; gPoLineIds.DELETE'); END IF;
1164: gPoLineIds.DELETE;
1165: gIpCategoryIds.DELETE;
1166: gInvItemIds.DELETE;
1167: gPoOrgIds.DELETE;

Line 1223: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Number of PO_REQEXPRESS_LINES_ALL rows updated='||SQL%rowcount); END IF;

1219: WHERE express_name = gPoReqTemplateNames(i)
1220: AND sequence_num = to_char(gPoReqTemplateLineIds(i))
1221: AND org_id = gPoOrgIds(i);
1222:
1223: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Number of PO_REQEXPRESS_LINES_ALL rows updated='||SQL%rowcount); END IF;
1224:
1225: l_progress := '090';
1226:
1227: -- Lines for which attributes need to be created are in gPoLineIds

Line 1240: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'END'); END IF;

1236: COMMIT;
1237: END LOOP;
1238:
1239: l_progress := '120';
1240: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'END'); END IF;
1241: EXCEPTION
1242: WHEN OTHERS THEN
1243: ROLLBACK;
1244: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Unexpected exception'); END IF;

Line 1244: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Unexpected exception'); END IF;

1240: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'END'); END IF;
1241: EXCEPTION
1242: WHEN OTHERS THEN
1243: ROLLBACK;
1244: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Unexpected exception'); END IF;
1245: RAISE_APPLICATION_ERROR(g_err_num,l_log_head||','||l_progress || ','|| SQLERRM);
1246: END process_new_rt_lines;
1247:
1248: /*