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_MI_PVT dependencies on FND_LOG

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

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

Line 36: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

32: l_masterItem_csr ICX_CAT_POPULATE_ITEM_PVT.g_item_csr_type;
33: BEGIN
34: l_err_loc := 100;
35: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
36: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
37: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
38: 'Processing cursor:' || l_api_name ||
39: ', g_NULL_NUMBER:' || ICX_CAT_UTIL_PVT.g_NULL_NUMBER ||
40: ', g_category_set_id:' || ICX_CAT_UTIL_PVT.g_category_set_id ||

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

157: l_err_loc PLS_INTEGER;
158: l_masterItem_csr ICX_CAT_POPULATE_ITEM_PVT.g_item_csr_type;
159: BEGIN
160: l_err_loc := 100;
161: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
162: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
163: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
164: 'Processing cursor:' || l_api_name ||
165: ', g_category_set_id:' || ICX_CAT_UTIL_PVT.g_category_set_id ||

Line 162: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

158: l_masterItem_csr ICX_CAT_POPULATE_ITEM_PVT.g_item_csr_type;
159: BEGIN
160: l_err_loc := 100;
161: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
162: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
163: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
164: 'Processing cursor:' || l_api_name ||
165: ', g_category_set_id:' || ICX_CAT_UTIL_PVT.g_category_set_id ||
166: ', g_NULL_NUMBER:' || ICX_CAT_UTIL_PVT.g_NULL_NUMBER ||

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

287: l_err_loc PLS_INTEGER;
288: l_masterItem_csr ICX_CAT_POPULATE_ITEM_PVT.g_item_csr_type;
289: BEGIN
290: l_err_loc := 100;
291: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
292: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
293: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
294: 'Processing cursor:' || l_api_name ||
295: ', g_NULL_NUMBER:' || ICX_CAT_UTIL_PVT.g_NULL_NUMBER ||

Line 292: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

288: l_masterItem_csr ICX_CAT_POPULATE_ITEM_PVT.g_item_csr_type;
289: BEGIN
290: l_err_loc := 100;
291: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
292: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
293: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
294: 'Processing cursor:' || l_api_name ||
295: ', g_NULL_NUMBER:' || ICX_CAT_UTIL_PVT.g_NULL_NUMBER ||
296: ', g_category_set_id:' || ICX_CAT_UTIL_PVT.g_category_set_id ||

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

312: -- inventory_item_id and organization_id for the request_id passed in
313:
314: l_err_loc := 300;
315: IF (P_ENTITY_TYPE = 'ITEM') THEN
316: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
317: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
318: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
319: 'Inside if of P_ENTITY_TYPE = ITEM');
320: END IF;

Line 317: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

313:
314: l_err_loc := 300;
315: IF (P_ENTITY_TYPE = 'ITEM') THEN
316: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
317: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
318: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
319: 'Inside if of P_ENTITY_TYPE = ITEM');
320: END IF;
321:

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

410: * AND mparams.organization_id = mi.organization_id
411: * AND mi.organization_id = fsp.inventory_organization_id
412: */
413: ELSIF (P_ENTITY_TYPE = 'ITEM_CATEGORY') THEN
414: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
415: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
416: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
417: 'Inside else of P_ENTITY_TYPE = ITEM_CATEGORY');
418: END IF;

Line 415: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

411: * AND mi.organization_id = fsp.inventory_organization_id
412: */
413: ELSIF (P_ENTITY_TYPE = 'ITEM_CATEGORY') THEN
414: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
415: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
416: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
417: 'Inside else of P_ENTITY_TYPE = ITEM_CATEGORY');
418: END IF;
419: OPEN l_masterItem_csr FOR

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

607: l_err_loc PLS_INTEGER;
608: l_masterItem_csr ICX_CAT_POPULATE_ITEM_PVT.g_item_csr_type;
609: BEGIN
610: l_err_loc := 100;
611: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
612: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
613: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
614: 'Processing cursor:' || l_api_name ||
615: ', g_NULL_NUMBER:' || ICX_CAT_UTIL_PVT.g_NULL_NUMBER ||

Line 612: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

608: l_masterItem_csr ICX_CAT_POPULATE_ITEM_PVT.g_item_csr_type;
609: BEGIN
610: l_err_loc := 100;
611: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
612: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
613: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
614: 'Processing cursor:' || l_api_name ||
615: ', g_NULL_NUMBER:' || ICX_CAT_UTIL_PVT.g_NULL_NUMBER ||
616: ', g_category_set_id:' || ICX_CAT_UTIL_PVT.g_category_set_id ||

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

724: l_err_loc PLS_INTEGER;
725: l_masterItem_csr ICX_CAT_POPULATE_ITEM_PVT.g_item_csr_type;
726: BEGIN
727: l_err_loc := 100;
728: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
729: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
730: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
731: 'Processing cursor:' || l_api_name ||
732: ', g_upgrade_last_run_date:' || g_upgrade_last_run_date ||

Line 729: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

725: l_masterItem_csr ICX_CAT_POPULATE_ITEM_PVT.g_item_csr_type;
726: BEGIN
727: l_err_loc := 100;
728: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
729: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
730: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
731: 'Processing cursor:' || l_api_name ||
732: ', g_upgrade_last_run_date:' || g_upgrade_last_run_date ||
733: ', g_start_rowid:' || g_start_rowid ||

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

1062: l_batch_count := l_batch_count + 1;
1063:
1064: l_err_loc := 600;
1065: l_count := l_inv_item_id_tbl.COUNT;
1066: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1067: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
1068: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1069: 'Num. of rows returned from the cursor:' || l_count);
1070: END IF;

Line 1067: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

1063:
1064: l_err_loc := 600;
1065: l_count := l_inv_item_id_tbl.COUNT;
1066: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1067: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
1068: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1069: 'Num. of rows returned from the cursor:' || l_count);
1070: END IF;
1071:

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

1079: -- First get the status and item_type of the current inventory item line
1080: ICX_CAT_POPULATE_STATUS_PVT.getMasterItemStatusAndType
1081: (l_intrnl_order_enbld_flag_tbl(i), l_outside_operation_flag_tbl(i), l_unit_price_tbl(i),
1082: l_inv_item_status, l_item_type);
1083: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1084: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
1085: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1086: 'l_inv_item_status: ' || l_inv_item_status ||
1087: 'l_item_type :' || l_item_type);

Line 1084: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

1080: ICX_CAT_POPULATE_STATUS_PVT.getMasterItemStatusAndType
1081: (l_intrnl_order_enbld_flag_tbl(i), l_outside_operation_flag_tbl(i), l_unit_price_tbl(i),
1082: l_inv_item_status, l_item_type);
1083: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1084: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
1085: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1086: 'l_inv_item_status: ' || l_inv_item_status ||
1087: 'l_item_type :' || l_item_type);
1088: END IF;

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

1085: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1086: 'l_inv_item_status: ' || l_inv_item_status ||
1087: 'l_item_type :' || l_item_type);
1088: END IF;
1089: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1090: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
1091: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1092: 'Values for Variables in populateMIs ' ||
1093: 'l_inv_item_id: ' || l_inv_item_id_tbl(i) ||

Line 1090: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

1086: 'l_inv_item_status: ' || l_inv_item_status ||
1087: 'l_item_type :' || l_item_type);
1088: END IF;
1089: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1090: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
1091: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1092: 'Values for Variables in populateMIs ' ||
1093: 'l_inv_item_id: ' || l_inv_item_id_tbl(i) ||
1094: ',l_po_line_id: ' || l_po_line_id_tbl(i) ||

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

1130: l_err_loc := 800;
1131: -- For category assignment delete
1132: IF (l_po_category_id_tbl(i) IS NULL) THEN
1133: l_err_loc := 900;
1134: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1135: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
1136: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1137: 'null l_po_category_id:' || l_po_category_id_tbl(i) ||
1138: 'for l_inv_item_id_tbl:' || l_inv_item_id_tbl(i) ||

Line 1135: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

1131: -- For category assignment delete
1132: IF (l_po_category_id_tbl(i) IS NULL) THEN
1133: l_err_loc := 900;
1134: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1135: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
1136: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1137: 'null l_po_category_id:' || l_po_category_id_tbl(i) ||
1138: 'for l_inv_item_id_tbl:' || l_inv_item_id_tbl(i) ||
1139: ', l_org_id_tbl:' || l_org_id_tbl(i));

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

1168: IF (l_ctx_rowid_tbl(i) IS NOT NULL
1169: AND p_current_mode = ICX_CAT_UTIL_PVT.g_online_const
1170: AND NOT ICX_CAT_UTIL_PVT.g_ItemCatgChange_const)
1171: THEN
1172: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1173: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
1174: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1175: 'Not changing the po category and ip category for' ||
1176: ', l_inv_item_id_tbl:' || l_inv_item_id_tbl(i) ||

Line 1173: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

1169: AND p_current_mode = ICX_CAT_UTIL_PVT.g_online_const
1170: AND NOT ICX_CAT_UTIL_PVT.g_ItemCatgChange_const)
1171: THEN
1172: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1173: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
1174: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1175: 'Not changing the po category and ip category for' ||
1176: ', l_inv_item_id_tbl:' || l_inv_item_id_tbl(i) ||
1177: ', l_org_id_tbl:' || l_org_id_tbl(i) ||

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

1232: l_err_loc := 1300;
1233: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('INLOOP', ICX_CAT_UTIL_PVT.g_MasterItemCsr_const);
1234: ELSE
1235: IF (p_current_mode = ICX_CAT_UTIL_PVT.g_upgrade_const) THEN
1236: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1237: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1238: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1239: 'Row #:' || i ||
1240: ', item:( ' || l_inv_item_id_tbl(i) ||

Line 1237: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

1233: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('INLOOP', ICX_CAT_UTIL_PVT.g_MasterItemCsr_const);
1234: ELSE
1235: IF (p_current_mode = ICX_CAT_UTIL_PVT.g_upgrade_const) THEN
1236: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1237: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1238: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1239: 'Row #:' || i ||
1240: ', item:( ' || l_inv_item_id_tbl(i) ||
1241: ', ' || l_org_id_tbl(i) || '), Not processed' ||

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

1246: ', po_category_id:' || l_po_category_id_tbl(i) ||
1247: ', status:' || l_inv_item_status);
1248: END IF;
1249: ELSE
1250: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1251: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
1252: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1253: 'Row #:' || i ||
1254: ', item:( ' || l_inv_item_id_tbl(i) ||

Line 1251: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

1247: ', status:' || l_inv_item_status);
1248: END IF;
1249: ELSE
1250: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1251: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
1252: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1253: 'Row #:' || i ||
1254: ', item:( ' || l_inv_item_id_tbl(i) ||
1255: ', ' || l_org_id_tbl(i) || '), Not processed' ||

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

1288: openCategoryItemsCursor(g_mtl_category_id, l_start_inv_item_id);
1289: ELSE
1290: l_err_loc := 1900;
1291: -- Online case should not throw snapshot too old error.
1292: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1293: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
1294: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1295: 'Online case throwing snap shot too old error');
1296: END IF;

Line 1293: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

1289: ELSE
1290: l_err_loc := 1900;
1291: -- Online case should not throw snapshot too old error.
1292: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1293: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
1294: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1295: 'Online case throwing snap shot too old error');
1296: END IF;
1297: END IF;

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

1305: l_err_loc := 2000;
1306: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('OUTLOOP', ICX_CAT_UTIL_PVT.g_MasterItemCsr_const);
1307:
1308: l_err_loc := 2100;
1309: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1310: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
1311: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1312: 'populateMIs in mode:'|| p_current_mode ||' done; '||
1313: 'Total num. of batches processed:' ||l_batch_count ||

Line 1310: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

1306: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('OUTLOOP', ICX_CAT_UTIL_PVT.g_MasterItemCsr_const);
1307:
1308: l_err_loc := 2100;
1309: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1310: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
1311: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1312: 'populateMIs in mode:'|| p_current_mode ||' done; '||
1313: 'Total num. of batches processed:' ||l_batch_count ||
1314: ', Total num. of rows processed:' ||l_row_count);

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

1382: IF (ICX_CAT_UTIL_PVT.g_category_set_id IS NULL) THEN
1383: l_err_loc := 600;
1384: ICX_CAT_UTIL_PVT.getPurchasingCategorySetInfo;
1385: ELSE
1386: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1387: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1388: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1389: 'Purchasing category set info:' ||
1390: ', g_category_set_id:' || ICX_CAT_UTIL_PVT.g_category_set_id ||

Line 1387: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

1383: l_err_loc := 600;
1384: ICX_CAT_UTIL_PVT.getPurchasingCategorySetInfo;
1385: ELSE
1386: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1387: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1388: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1389: 'Purchasing category set info:' ||
1390: ', g_category_set_id:' || ICX_CAT_UTIL_PVT.g_category_set_id ||
1391: ', g_validate_flag:' || ICX_CAT_UTIL_PVT.g_validate_flag ||

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

1517: l_err_loc := 1700;
1518: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('OUTLOOP', ICX_CAT_UTIL_PVT.g_MasterItemCsr_const);
1519:
1520: l_err_loc := 1800;
1521: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1522: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1523: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1524: 'populateItemDelete done; Total num. of batches processed:' || l_batch_count);
1525: END IF;

Line 1522: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

1518: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('OUTLOOP', ICX_CAT_UTIL_PVT.g_MasterItemCsr_const);
1519:
1520: l_err_loc := 1800;
1521: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1522: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1523: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1524: 'populateItemDelete done; Total num. of batches processed:' || l_batch_count);
1525: END IF;
1526:

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

1605: BEGIN
1606: l_err_loc := 100;
1607: l_start_date := sysdate;
1608:
1609: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1610: l_log_string := 'Started at:' || TO_CHAR(l_start_date, 'DD-MON-YYYY HH24:MI:SS') ||
1611: ', P_MTL_CATEGORY_ID_TBL.COUNT:' || P_MTL_CATEGORY_ID_TBL.COUNT;
1612: ICX_CAT_UTIL_PVT.logProcBegin(g_pkg_name, l_api_name, l_log_string);
1613: END IF;

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

1620: END LOOP;
1621:
1622: l_err_loc := 900;
1623: l_end_date := sysdate;
1624: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1625: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name,
1626: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));
1627: END IF;
1628: EXCEPTION

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

1642: l_err_loc PLS_INTEGER;
1643: BEGIN
1644: l_err_loc := 100;
1645: IF (NOT ICX_CAT_POPULATE_MI_PVT.g_metadataTblFormed) THEN
1646: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1647: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1648: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1649: 'about to call buildmetadatinfo');
1650: END IF;

Line 1647: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

1643: BEGIN
1644: l_err_loc := 100;
1645: IF (NOT ICX_CAT_POPULATE_MI_PVT.g_metadataTblFormed) THEN
1646: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1647: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1648: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1649: 'about to call buildmetadatinfo');
1650: END IF;
1651:

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

1657: END IF;
1658:
1659: l_err_loc := 400;
1660: IF (NOT ICX_CAT_POPULATE_MI_PVT.g_CtxSqlForMIsFormed) THEN
1661: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1662: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1663: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1664: 'about to call buildctxsql');
1665: END IF;

Line 1662: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

1658:
1659: l_err_loc := 400;
1660: IF (NOT ICX_CAT_POPULATE_MI_PVT.g_CtxSqlForMIsFormed) THEN
1661: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1662: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1663: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1664: 'about to call buildctxsql');
1665: END IF;
1666: l_err_loc := 500;