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 626: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

Line 627: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

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

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

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

Line 645: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

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

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

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

Line 694: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

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

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

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

Line 721: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

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

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

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

Line 923: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

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

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

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

Line 1045: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

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

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

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

Line 1338: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

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

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

1425: l_err_loc := 1400;
1426: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('INLOOP', ICX_CAT_UTIL_PVT.g_GBPACsr_const);
1427: ELSE
1428: IF (p_current_mode = ICX_CAT_UTIL_PVT.g_upgrade_const) THEN
1429: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1430: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1431: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1432: 'Row #:' || i ||
1433: ', with po_line_id:' || l_po_line_id_tbl(i) ||', not processed' ||

Line 1430: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

1426: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('INLOOP', ICX_CAT_UTIL_PVT.g_GBPACsr_const);
1427: ELSE
1428: IF (p_current_mode = ICX_CAT_UTIL_PVT.g_upgrade_const) THEN
1429: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1430: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1431: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1432: 'Row #:' || i ||
1433: ', with po_line_id:' || l_po_line_id_tbl(i) ||', not processed' ||
1434: ', l_enabled_flag_tbl:' || l_enabled_flag_tbl(i) ||

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

1434: ', l_enabled_flag_tbl:' || l_enabled_flag_tbl(i) ||
1435: ', status: ' || l_GBPA_line_status);
1436: END IF;
1437: ELSE
1438: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1439: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
1440: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1441: 'Row #:' || i ||
1442: ', with po_line_id:' || l_po_line_id_tbl(i) ||', not processed' ||

Line 1439: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

1435: ', status: ' || l_GBPA_line_status);
1436: END IF;
1437: ELSE
1438: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1439: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
1440: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1441: 'Row #:' || i ||
1442: ', with po_line_id:' || l_po_line_id_tbl(i) ||', not processed' ||
1443: ', l_enabled_flag_tbl:' || l_enabled_flag_tbl(i) ||

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

1479: l_err_loc := 2000;
1480: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('OUTLOOP', ICX_CAT_UTIL_PVT.g_GBPACsr_const);
1481:
1482: l_err_loc := 2100;
1483: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1484: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
1485: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1486: 'populateGBPAs in mode:'|| p_current_mode ||' done; '||
1487: 'Total num. of batches processed:' ||l_batch_count ||

Line 1484: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

1480: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('OUTLOOP', ICX_CAT_UTIL_PVT.g_GBPACsr_const);
1481:
1482: l_err_loc := 2100;
1483: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1484: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
1485: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1486: 'populateGBPAs in mode:'|| p_current_mode ||' done; '||
1487: 'Total num. of batches processed:' ||l_batch_count ||
1488: ', Total num. of rows fetched:' ||l_row_count);

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

1521: l_err_loc := 300;
1522: g_key := p_key;
1523:
1524: l_err_loc := 350;
1525: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1526: ICX_CAT_UTIL_PVT.logPOSessionGTData(p_key);
1527: END IF;
1528:
1529: l_err_loc := 400;

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

1567: g_current_cursor := 'ORG_ASSIGNMENT_CSR';
1568: g_key := p_key;
1569:
1570: l_err_loc := 350;
1571: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1572: ICX_CAT_UTIL_PVT.logPOSessionGTData(p_key);
1573: END IF;
1574:
1575: l_err_loc := 400;

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

1608: l_err_loc PLS_INTEGER;
1609: l_bpa_quote_csr ICX_CAT_POPULATE_ITEM_PVT.g_item_csr_type;
1610: BEGIN
1611: l_err_loc := 100;
1612: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1613: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
1614: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1615: 'Processing cursor:' || l_api_name ||
1616: ', g_upgrade_last_run_date:' || g_upgrade_last_run_date ||

Line 1613: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

1609: l_bpa_quote_csr ICX_CAT_POPULATE_ITEM_PVT.g_item_csr_type;
1610: BEGIN
1611: l_err_loc := 100;
1612: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1613: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
1614: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1615: 'Processing cursor:' || l_api_name ||
1616: ', g_upgrade_last_run_date:' || g_upgrade_last_run_date ||
1617: ', g_start_rowid:' || g_start_rowid ||

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

2061: l_batch_count := l_batch_count + 1;
2062:
2063: l_err_loc := 500;
2064: l_count := l_po_line_id_tbl.COUNT;
2065: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2066: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
2067: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2068: 'Num. of rows returned from the cursor:' || l_count);
2069: END IF;

Line 2066: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

2062:
2063: l_err_loc := 500;
2064: l_count := l_po_line_id_tbl.COUNT;
2065: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2066: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
2067: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2068: 'Num. of rows returned from the cursor:' || l_count);
2069: END IF;
2070:

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

2080: l_err_loc := 700;
2081: -- The GBPAs created for bulkload items will not be in approved
2082: -- status during upgrade, so treat them as valid during upgrade.
2083: l_podoc_status := ICX_CAT_POPULATE_STATUS_PVT.VALID_FOR_POPULATE;
2084: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2085: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
2086: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2087: 'bpa status is hard-coded to valid for' ||
2088: ', p_current_mode:' || p_current_mode ||

Line 2085: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

2081: -- The GBPAs created for bulkload items will not be in approved
2082: -- status during upgrade, so treat them as valid during upgrade.
2083: l_podoc_status := ICX_CAT_POPULATE_STATUS_PVT.VALID_FOR_POPULATE;
2084: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2085: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
2086: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2087: 'bpa status is hard-coded to valid for' ||
2088: ', p_current_mode:' || p_current_mode ||
2089: ', l_created_by_tbl(i):' || l_created_by_tbl(i) );

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

2174: l_err_loc := 1400;
2175: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('INLOOP', ICX_CAT_UTIL_PVT.g_BPACsr_const);
2176: ELSE
2177: IF (p_current_mode = ICX_CAT_UTIL_PVT.g_upgrade_const) THEN
2178: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2179: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
2180: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2181: 'Row #:' || i ||
2182: ', with po_line_id:' || l_po_line_id_tbl(i) ||', not processed' ||

Line 2179: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

2175: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('INLOOP', ICX_CAT_UTIL_PVT.g_BPACsr_const);
2176: ELSE
2177: IF (p_current_mode = ICX_CAT_UTIL_PVT.g_upgrade_const) THEN
2178: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2179: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
2180: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2181: 'Row #:' || i ||
2182: ', with po_line_id:' || l_po_line_id_tbl(i) ||', not processed' ||
2183: ', l_source_type_tbl:' || l_source_type_tbl(i) ||

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

2218: l_err_loc := 1800;
2219: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('OUTLOOP', ICX_CAT_UTIL_PVT.g_BPACsr_const);
2220:
2221: l_err_loc := 1900;
2222: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2223: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
2224: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2225: 'in mode:'|| p_current_mode ||' done; '||
2226: 'Total num. of batches processed:' ||l_batch_count ||

Line 2223: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

2219: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('OUTLOOP', ICX_CAT_UTIL_PVT.g_BPACsr_const);
2220:
2221: l_err_loc := 1900;
2222: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2223: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
2224: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2225: 'in mode:'|| p_current_mode ||' done; '||
2226: 'Total num. of batches processed:' ||l_batch_count ||
2227: ', Total num. of rows processed:' ||l_row_count);

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

2283: l_err_loc PLS_INTEGER;
2284: l_quote_csr ICX_CAT_POPULATE_ITEM_PVT.g_item_csr_type;
2285: BEGIN
2286: l_err_loc := 100;
2287: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2288: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
2289: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2290: 'Processing cursor:' || l_api_name ||
2291: ', p_key:' || p_key ||

Line 2288: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

2284: l_quote_csr ICX_CAT_POPULATE_ITEM_PVT.g_item_csr_type;
2285: BEGIN
2286: l_err_loc := 100;
2287: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2288: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
2289: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2290: 'Processing cursor:' || l_api_name ||
2291: ', p_key:' || p_key ||
2292: ', p_po_line_id:' || p_po_line_id );

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

2569: l_batch_count := l_batch_count + 1;
2570:
2571: l_err_loc := 600;
2572: l_count := l_po_line_id_tbl.COUNT;
2573: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2574: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
2575: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2576: 'Num. of rows returned from the cursor:' || l_count);
2577: END IF;

Line 2574: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

2570:
2571: l_err_loc := 600;
2572: l_count := l_po_line_id_tbl.COUNT;
2573: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2574: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
2575: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2576: 'Num. of rows returned from the cursor:' || l_count);
2577: END IF;
2578:

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

2650: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('INLOOP', ICX_CAT_UTIL_PVT.g_QuoteCsr_const);
2651: ELSE
2652: l_err_loc := 1100;
2653: IF (p_current_mode = ICX_CAT_UTIL_PVT.g_upgrade_const) THEN
2654: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2655: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
2656: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2657: 'Row #:' || i ||
2658: ', with po_line_id:' || l_po_line_id_tbl(i) ||', not processed' ||

Line 2655: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

2651: ELSE
2652: l_err_loc := 1100;
2653: IF (p_current_mode = ICX_CAT_UTIL_PVT.g_upgrade_const) THEN
2654: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2655: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
2656: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2657: 'Row #:' || i ||
2658: ', with po_line_id:' || l_po_line_id_tbl(i) ||', not processed' ||
2659: ', status: ' || l_status_tbl(i));

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

2658: ', with po_line_id:' || l_po_line_id_tbl(i) ||', not processed' ||
2659: ', status: ' || l_status_tbl(i));
2660: END IF;
2661: ELSE
2662: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2663: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
2664: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2665: 'Row #:' || i ||
2666: ', with po_line_id:' || l_po_line_id_tbl(i) ||', not processed' ||

Line 2663: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

2659: ', status: ' || l_status_tbl(i));
2660: END IF;
2661: ELSE
2662: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2663: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
2664: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2665: 'Row #:' || i ||
2666: ', with po_line_id:' || l_po_line_id_tbl(i) ||', not processed' ||
2667: ', status: ' || l_status_tbl(i));

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

2690: l_err_loc := 1500;
2691: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('OUTLOOP', ICX_CAT_UTIL_PVT.g_QuoteCsr_const);
2692:
2693: l_err_loc := 1600;
2694: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2695: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
2696: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2697: 'populateQuotes in mode:'|| p_current_mode ||' done; '||
2698: 'Total num. of batches processed:' ||l_batch_count ||

Line 2695: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

2691: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('OUTLOOP', ICX_CAT_UTIL_PVT.g_QuoteCsr_const);
2692:
2693: l_err_loc := 1600;
2694: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2695: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
2696: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2697: 'populateQuotes in mode:'|| p_current_mode ||' done; '||
2698: 'Total num. of batches processed:' ||l_batch_count ||
2699: ', Total num. of rows processed:' ||l_row_count);

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

2724: l_err_loc := 300;
2725: g_key := p_key;
2726:
2727: l_err_loc := 350;
2728: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2729: ICX_CAT_UTIL_PVT.logPOSessionGTData(p_key);
2730: END IF;
2731:
2732: l_err_loc := 400;

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

2762: BEGIN
2763: l_err_loc := 100;
2764: IF (NOT ICX_CAT_POPULATE_PODOCS_PVT.g_metadataTblFormed) THEN
2765: l_err_loc := 200;
2766: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2767: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
2768: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2769: 'about to call buildmetadatinfo');
2770: END IF;

Line 2767: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

2763: l_err_loc := 100;
2764: IF (NOT ICX_CAT_POPULATE_PODOCS_PVT.g_metadataTblFormed) THEN
2765: l_err_loc := 200;
2766: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2767: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
2768: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2769: 'about to call buildmetadatinfo');
2770: END IF;
2771:

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

2779:
2780: l_err_loc := 400;
2781: IF (NOT ICX_CAT_POPULATE_PODOCS_PVT.g_CtxSqlForPODocsFormed) THEN
2782: l_err_loc := 500;
2783: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2784: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
2785: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2786: 'about to call buildctxsql');
2787: END IF;

Line 2784: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

2780: l_err_loc := 400;
2781: IF (NOT ICX_CAT_POPULATE_PODOCS_PVT.g_CtxSqlForPODocsFormed) THEN
2782: l_err_loc := 500;
2783: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2784: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
2785: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2786: 'about to call buildctxsql');
2787: END IF;
2788: