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.ICX_CAT_POPULATE_PODOCS_PVT dependencies on FND_LOG

Line 33: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

29: l_err_loc PLS_INTEGER;
30: l_bpa_csr ICX_CAT_POPULATE_ITEM_PVT.g_item_csr_type;
31: BEGIN
32: l_err_loc := 100;
33: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
34: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
35: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
36: 'Processing cursor:' || l_api_name ||
37: ', p_key:' || p_key ||

Line 34: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

30: l_bpa_csr ICX_CAT_POPULATE_ITEM_PVT.g_item_csr_type;
31: BEGIN
32: l_err_loc := 100;
33: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
34: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
35: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
36: 'Processing cursor:' || l_api_name ||
37: ', p_key:' || p_key ||
38: ', p_po_line_id:' || p_po_line_id );

Line 175: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

171: l_err_loc PLS_INTEGER;
172: l_bpa_csr ICX_CAT_POPULATE_ITEM_PVT.g_item_csr_type;
173: BEGIN
174: l_err_loc := 100;
175: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
176: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
177: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
178: 'Processing cursor:' || l_api_name ||
179: ', p_key:' || p_key ||

Line 176: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

172: l_bpa_csr ICX_CAT_POPULATE_ITEM_PVT.g_item_csr_type;
173: BEGIN
174: l_err_loc := 100;
175: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
176: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
177: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
178: 'Processing cursor:' || l_api_name ||
179: ', p_key:' || p_key ||
180: ', p_po_line_id:' || p_po_line_id );

Line 509: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

505: l_batch_count := l_batch_count + 1;
506:
507: l_err_loc := 500;
508: l_count := l_po_line_id_tbl.COUNT;
509: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
510: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
511: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
512: 'Num. of rows returned from the cursor:' || l_count);
513: END IF;

Line 510: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

506:
507: l_err_loc := 500;
508: l_count := l_po_line_id_tbl.COUNT;
509: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
510: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
511: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
512: 'Num. of rows returned from the cursor:' || l_count);
513: END IF;
514:

Line 530: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

526: l_err_loc := 700;
527: -- The GBPAs created for bulkload items will not be in approved
528: -- status during upgrade, so treat them as valid during upgrade.
529: l_BPA_line_status := ICX_CAT_POPULATE_STATUS_PVT.VALID_FOR_POPULATE;
530: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
531: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
532: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
533: 'bpa status is hard-coded to valid for' ||
534: ', p_current_mode:' || p_current_mode ||

Line 531: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

527: -- The GBPAs created for bulkload items will not be in approved
528: -- status during upgrade, so treat them as valid during upgrade.
529: l_BPA_line_status := ICX_CAT_POPULATE_STATUS_PVT.VALID_FOR_POPULATE;
530: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
531: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
532: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
533: 'bpa status is hard-coded to valid for' ||
534: ', p_current_mode:' || p_current_mode ||
535: ', l_created_by_tbl(i):' || l_created_by_tbl(i) );

Line 622: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

618: l_err_loc := 1400;
619: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('INLOOP', ICX_CAT_UTIL_PVT.g_BPACsr_const);
620: ELSE
621: IF (p_current_mode = ICX_CAT_UTIL_PVT.g_upgrade_const) THEN
622: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
623: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
624: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
625: 'Row #:' || i ||
626: ', with po_line_id:' || l_po_line_id_tbl(i) ||', not processed' ||

Line 623: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

619: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('INLOOP', ICX_CAT_UTIL_PVT.g_BPACsr_const);
620: ELSE
621: IF (p_current_mode = ICX_CAT_UTIL_PVT.g_upgrade_const) THEN
622: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
623: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
624: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
625: 'Row #:' || i ||
626: ', with po_line_id:' || l_po_line_id_tbl(i) ||', not processed' ||
627: ', l_approved_date_tbl:' || l_approved_date_tbl(i) ||

Line 640: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

636: ', l_system_date_tbl:' || l_system_date_tbl(i) ||
637: ', status: ' || l_BPA_line_status);
638: END IF;
639: ELSE
640: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
641: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
642: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
643: 'Row #:' || i ||
644: ', with po_line_id:' || l_po_line_id_tbl(i) ||', not processed' ||

Line 641: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

637: ', status: ' || l_BPA_line_status);
638: END IF;
639: ELSE
640: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
641: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
642: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
643: 'Row #:' || i ||
644: ', with po_line_id:' || l_po_line_id_tbl(i) ||', not processed' ||
645: ', l_approved_date_tbl:' || l_approved_date_tbl(i) ||

Line 689: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

685: l_err_loc := 1800;
686: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('OUTLOOP', ICX_CAT_UTIL_PVT.g_BPACsr_const);
687:
688: l_err_loc := 1900;
689: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
690: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
691: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
692: 'populateBPAs in mode:'|| p_current_mode ||' done; '||
693: 'Total num. of batches processed:' ||l_batch_count ||

Line 690: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

686: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('OUTLOOP', ICX_CAT_UTIL_PVT.g_BPACsr_const);
687:
688: l_err_loc := 1900;
689: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
690: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
691: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
692: 'populateBPAs in mode:'|| p_current_mode ||' done; '||
693: 'Total num. of batches processed:' ||l_batch_count ||
694: ', Total num. of rows processed:' ||l_row_count);

Line 716: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

712: l_err_loc PLS_INTEGER;
713: l_gbpa_csr ICX_CAT_POPULATE_ITEM_PVT.g_item_csr_type;
714: BEGIN
715: l_err_loc := 100;
716: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
717: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
718: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
719: 'Processing cursor:' || l_api_name ||
720: ', g_upgrade_last_run_date:' || g_upgrade_last_run_date ||

Line 717: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

713: l_gbpa_csr ICX_CAT_POPULATE_ITEM_PVT.g_item_csr_type;
714: BEGIN
715: l_err_loc := 100;
716: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
717: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
718: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
719: 'Processing cursor:' || l_api_name ||
720: ', g_upgrade_last_run_date:' || g_upgrade_last_run_date ||
721: ', g_start_rowid:' || g_start_rowid ||

Line 918: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

914: l_err_loc PLS_INTEGER;
915: l_gbpa_csr ICX_CAT_POPULATE_ITEM_PVT.g_item_csr_type;
916: BEGIN
917: l_err_loc := 100;
918: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
919: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
920: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
921: 'Processing cursor:' || l_api_name ||
922: ', p_key:' || p_key ||

Line 919: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

915: l_gbpa_csr ICX_CAT_POPULATE_ITEM_PVT.g_item_csr_type;
916: BEGIN
917: l_err_loc := 100;
918: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
919: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
920: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
921: 'Processing cursor:' || l_api_name ||
922: ', p_key:' || p_key ||
923: ', p_po_line_id:' || p_po_line_id );

Line 1040: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1036: l_err_loc PLS_INTEGER;
1037: l_gbpa_csr ICX_CAT_POPULATE_ITEM_PVT.g_item_csr_type;
1038: BEGIN
1039: l_err_loc := 100;
1040: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1041: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
1042: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1043: 'Processing cursor:' || l_api_name ||
1044: ', p_key:' || p_key ||

Line 1041: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

1037: l_gbpa_csr ICX_CAT_POPULATE_ITEM_PVT.g_item_csr_type;
1038: BEGIN
1039: l_err_loc := 100;
1040: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1041: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
1042: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1043: 'Processing cursor:' || l_api_name ||
1044: ', p_key:' || p_key ||
1045: ', p_po_line_id:' || p_po_line_id );

Line 1332: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1328: l_batch_count := l_batch_count + 1;
1329:
1330: l_err_loc := 600;
1331: l_count := l_po_line_id_tbl.COUNT;
1332: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1333: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
1334: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1335: 'Num. of rows returned from the cursor:' || l_count);
1336: END IF;

Line 1333: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

1329:
1330: l_err_loc := 600;
1331: l_count := l_po_line_id_tbl.COUNT;
1332: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1333: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
1334: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1335: 'Num. of rows returned from the cursor:' || l_count);
1336: END IF;
1337: --Save the last po_line_id processed, so that re-open of cursor will start from the saved id.

Line 1415: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1411: l_err_loc := 1400;
1412: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('INLOOP', ICX_CAT_UTIL_PVT.g_GBPACsr_const);
1413: ELSE
1414: IF (p_current_mode = ICX_CAT_UTIL_PVT.g_upgrade_const) THEN
1415: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1416: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1417: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1418: 'Row #:' || i ||
1419: ', with po_line_id:' || l_po_line_id_tbl(i) ||', not processed' ||

Line 1416: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

1412: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('INLOOP', ICX_CAT_UTIL_PVT.g_GBPACsr_const);
1413: ELSE
1414: IF (p_current_mode = ICX_CAT_UTIL_PVT.g_upgrade_const) THEN
1415: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1416: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1417: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1418: 'Row #:' || i ||
1419: ', with po_line_id:' || l_po_line_id_tbl(i) ||', not processed' ||
1420: ', l_enabled_flag_tbl:' || l_enabled_flag_tbl(i) ||

Line 1424: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1420: ', l_enabled_flag_tbl:' || l_enabled_flag_tbl(i) ||
1421: ', status: ' || l_GBPA_line_status);
1422: END IF;
1423: ELSE
1424: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1425: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
1426: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1427: 'Row #:' || i ||
1428: ', with po_line_id:' || l_po_line_id_tbl(i) ||', not processed' ||

Line 1425: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

1421: ', status: ' || l_GBPA_line_status);
1422: END IF;
1423: ELSE
1424: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1425: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
1426: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1427: 'Row #:' || i ||
1428: ', with po_line_id:' || l_po_line_id_tbl(i) ||', not processed' ||
1429: ', l_enabled_flag_tbl:' || l_enabled_flag_tbl(i) ||

Line 1469: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1465: l_err_loc := 2000;
1466: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('OUTLOOP', ICX_CAT_UTIL_PVT.g_GBPACsr_const);
1467:
1468: l_err_loc := 2100;
1469: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1470: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
1471: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1472: 'populateGBPAs in mode:'|| p_current_mode ||' done; '||
1473: 'Total num. of batches processed:' ||l_batch_count ||

Line 1470: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

1466: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('OUTLOOP', ICX_CAT_UTIL_PVT.g_GBPACsr_const);
1467:
1468: l_err_loc := 2100;
1469: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1470: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
1471: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1472: 'populateGBPAs in mode:'|| p_current_mode ||' done; '||
1473: 'Total num. of batches processed:' ||l_batch_count ||
1474: ', Total num. of rows fetched:' ||l_row_count);

Line 1511: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1507: l_err_loc := 300;
1508: g_key := p_key;
1509:
1510: l_err_loc := 350;
1511: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1512: ICX_CAT_UTIL_PVT.logPOSessionGTData(p_key);
1513: END IF;
1514:
1515: l_err_loc := 400;

Line 1557: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1553: g_current_cursor := 'ORG_ASSIGNMENT_CSR';
1554: g_key := p_key;
1555:
1556: l_err_loc := 350;
1557: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1558: ICX_CAT_UTIL_PVT.logPOSessionGTData(p_key);
1559: END IF;
1560:
1561: l_err_loc := 400;

Line 1598: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1594: l_err_loc PLS_INTEGER;
1595: l_bpa_quote_csr ICX_CAT_POPULATE_ITEM_PVT.g_item_csr_type;
1596: BEGIN
1597: l_err_loc := 100;
1598: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1599: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
1600: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1601: 'Processing cursor:' || l_api_name ||
1602: ', g_upgrade_last_run_date:' || g_upgrade_last_run_date ||

Line 1599: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

1595: l_bpa_quote_csr ICX_CAT_POPULATE_ITEM_PVT.g_item_csr_type;
1596: BEGIN
1597: l_err_loc := 100;
1598: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1599: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
1600: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1601: 'Processing cursor:' || l_api_name ||
1602: ', g_upgrade_last_run_date:' || g_upgrade_last_run_date ||
1603: ', g_start_rowid:' || g_start_rowid ||

Line 2051: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2047: l_batch_count := l_batch_count + 1;
2048:
2049: l_err_loc := 500;
2050: l_count := l_po_line_id_tbl.COUNT;
2051: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2052: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
2053: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2054: 'Num. of rows returned from the cursor:' || l_count);
2055: END IF;

Line 2052: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

2048:
2049: l_err_loc := 500;
2050: l_count := l_po_line_id_tbl.COUNT;
2051: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2052: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
2053: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2054: 'Num. of rows returned from the cursor:' || l_count);
2055: END IF;
2056:

Line 2070: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2066: l_err_loc := 700;
2067: -- The GBPAs created for bulkload items will not be in approved
2068: -- status during upgrade, so treat them as valid during upgrade.
2069: l_podoc_status := ICX_CAT_POPULATE_STATUS_PVT.VALID_FOR_POPULATE;
2070: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2071: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
2072: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2073: 'bpa status is hard-coded to valid for' ||
2074: ', p_current_mode:' || p_current_mode ||

Line 2071: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

2067: -- The GBPAs created for bulkload items will not be in approved
2068: -- status during upgrade, so treat them as valid during upgrade.
2069: l_podoc_status := ICX_CAT_POPULATE_STATUS_PVT.VALID_FOR_POPULATE;
2070: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2071: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
2072: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2073: 'bpa status is hard-coded to valid for' ||
2074: ', p_current_mode:' || p_current_mode ||
2075: ', l_created_by_tbl(i):' || l_created_by_tbl(i) );

Line 2164: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2160: l_err_loc := 1400;
2161: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('INLOOP', ICX_CAT_UTIL_PVT.g_BPACsr_const);
2162: ELSE
2163: IF (p_current_mode = ICX_CAT_UTIL_PVT.g_upgrade_const) THEN
2164: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2165: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
2166: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2167: 'Row #:' || i ||
2168: ', with po_line_id:' || l_po_line_id_tbl(i) ||', not processed' ||

Line 2165: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

2161: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('INLOOP', ICX_CAT_UTIL_PVT.g_BPACsr_const);
2162: ELSE
2163: IF (p_current_mode = ICX_CAT_UTIL_PVT.g_upgrade_const) THEN
2164: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2165: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
2166: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2167: 'Row #:' || i ||
2168: ', with po_line_id:' || l_po_line_id_tbl(i) ||', not processed' ||
2169: ', l_source_type_tbl:' || l_source_type_tbl(i) ||

Line 2208: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2204: l_err_loc := 1800;
2205: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('OUTLOOP', ICX_CAT_UTIL_PVT.g_BPACsr_const);
2206:
2207: l_err_loc := 1900;
2208: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2209: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
2210: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2211: 'in mode:'|| p_current_mode ||' done; '||
2212: 'Total num. of batches processed:' ||l_batch_count ||

Line 2209: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

2205: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('OUTLOOP', ICX_CAT_UTIL_PVT.g_BPACsr_const);
2206:
2207: l_err_loc := 1900;
2208: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2209: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
2210: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2211: 'in mode:'|| p_current_mode ||' done; '||
2212: 'Total num. of batches processed:' ||l_batch_count ||
2213: ', Total num. of rows processed:' ||l_row_count);

Line 2273: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2269: l_err_loc PLS_INTEGER;
2270: l_quote_csr ICX_CAT_POPULATE_ITEM_PVT.g_item_csr_type;
2271: BEGIN
2272: l_err_loc := 100;
2273: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2274: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
2275: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2276: 'Processing cursor:' || l_api_name ||
2277: ', p_key:' || p_key ||

Line 2274: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

2270: l_quote_csr ICX_CAT_POPULATE_ITEM_PVT.g_item_csr_type;
2271: BEGIN
2272: l_err_loc := 100;
2273: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2274: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
2275: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2276: 'Processing cursor:' || l_api_name ||
2277: ', p_key:' || p_key ||
2278: ', p_po_line_id:' || p_po_line_id );

Line 2559: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2555: l_batch_count := l_batch_count + 1;
2556:
2557: l_err_loc := 600;
2558: l_count := l_po_line_id_tbl.COUNT;
2559: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2560: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
2561: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2562: 'Num. of rows returned from the cursor:' || l_count);
2563: END IF;

Line 2560: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

2556:
2557: l_err_loc := 600;
2558: l_count := l_po_line_id_tbl.COUNT;
2559: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2560: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
2561: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2562: 'Num. of rows returned from the cursor:' || l_count);
2563: END IF;
2564:

Line 2640: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2636: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('INLOOP', ICX_CAT_UTIL_PVT.g_QuoteCsr_const);
2637: ELSE
2638: l_err_loc := 1100;
2639: IF (p_current_mode = ICX_CAT_UTIL_PVT.g_upgrade_const) THEN
2640: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2641: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
2642: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2643: 'Row #:' || i ||
2644: ', with po_line_id:' || l_po_line_id_tbl(i) ||', not processed' ||

Line 2641: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

2637: ELSE
2638: l_err_loc := 1100;
2639: IF (p_current_mode = ICX_CAT_UTIL_PVT.g_upgrade_const) THEN
2640: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2641: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
2642: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2643: 'Row #:' || i ||
2644: ', with po_line_id:' || l_po_line_id_tbl(i) ||', not processed' ||
2645: ', status: ' || l_status_tbl(i));

Line 2648: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2644: ', with po_line_id:' || l_po_line_id_tbl(i) ||', not processed' ||
2645: ', status: ' || l_status_tbl(i));
2646: END IF;
2647: ELSE
2648: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2649: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
2650: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2651: 'Row #:' || i ||
2652: ', with po_line_id:' || l_po_line_id_tbl(i) ||', not processed' ||

Line 2649: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

2645: ', status: ' || l_status_tbl(i));
2646: END IF;
2647: ELSE
2648: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2649: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
2650: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2651: 'Row #:' || i ||
2652: ', with po_line_id:' || l_po_line_id_tbl(i) ||', not processed' ||
2653: ', status: ' || l_status_tbl(i));

Line 2680: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2676: l_err_loc := 1500;
2677: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('OUTLOOP', ICX_CAT_UTIL_PVT.g_QuoteCsr_const);
2678:
2679: l_err_loc := 1600;
2680: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2681: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
2682: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2683: 'populateQuotes in mode:'|| p_current_mode ||' done; '||
2684: 'Total num. of batches processed:' ||l_batch_count ||

Line 2681: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

2677: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('OUTLOOP', ICX_CAT_UTIL_PVT.g_QuoteCsr_const);
2678:
2679: l_err_loc := 1600;
2680: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2681: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
2682: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2683: 'populateQuotes in mode:'|| p_current_mode ||' done; '||
2684: 'Total num. of batches processed:' ||l_batch_count ||
2685: ', Total num. of rows processed:' ||l_row_count);

Line 2714: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2710: l_err_loc := 300;
2711: g_key := p_key;
2712:
2713: l_err_loc := 350;
2714: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2715: ICX_CAT_UTIL_PVT.logPOSessionGTData(p_key);
2716: END IF;
2717:
2718: l_err_loc := 400;

Line 2752: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2748: BEGIN
2749: l_err_loc := 100;
2750: IF (NOT ICX_CAT_POPULATE_PODOCS_PVT.g_metadataTblFormed) THEN
2751: l_err_loc := 200;
2752: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2753: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
2754: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2755: 'about to call buildmetadatinfo');
2756: END IF;

Line 2753: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

2749: l_err_loc := 100;
2750: IF (NOT ICX_CAT_POPULATE_PODOCS_PVT.g_metadataTblFormed) THEN
2751: l_err_loc := 200;
2752: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2753: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
2754: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2755: 'about to call buildmetadatinfo');
2756: END IF;
2757:

Line 2769: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2765:
2766: l_err_loc := 400;
2767: IF (NOT ICX_CAT_POPULATE_PODOCS_PVT.g_CtxSqlForPODocsFormed) THEN
2768: l_err_loc := 500;
2769: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2770: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
2771: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2772: 'about to call buildctxsql');
2773: END IF;

Line 2770: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

2766: l_err_loc := 400;
2767: IF (NOT ICX_CAT_POPULATE_PODOCS_PVT.g_CtxSqlForPODocsFormed) THEN
2768: l_err_loc := 500;
2769: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2770: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
2771: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2772: 'about to call buildctxsql');
2773: END IF;
2774: