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

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

Line 163: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

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

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

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

Line 294: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

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

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

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

Line 319: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

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

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

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

Line 418: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

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

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

612: l_err_loc PLS_INTEGER;
613: l_masterItem_csr ICX_CAT_POPULATE_ITEM_PVT.g_item_csr_type;
614: BEGIN
615: l_err_loc := 100;
616: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
617: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
618: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
619: 'Processing cursor:' || l_api_name ||
620: ', g_NULL_NUMBER:' || ICX_CAT_UTIL_PVT.g_NULL_NUMBER ||

Line 617: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

613: l_masterItem_csr ICX_CAT_POPULATE_ITEM_PVT.g_item_csr_type;
614: BEGIN
615: l_err_loc := 100;
616: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
617: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
618: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
619: 'Processing cursor:' || l_api_name ||
620: ', g_NULL_NUMBER:' || ICX_CAT_UTIL_PVT.g_NULL_NUMBER ||
621: ', g_category_set_id:' || ICX_CAT_UTIL_PVT.g_category_set_id ||

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

730: l_err_loc PLS_INTEGER;
731: l_masterItem_csr ICX_CAT_POPULATE_ITEM_PVT.g_item_csr_type;
732: BEGIN
733: l_err_loc := 100;
734: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
735: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
736: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
737: 'Processing cursor:' || l_api_name ||
738: ', g_upgrade_last_run_date:' || g_upgrade_last_run_date ||

Line 735: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

731: l_masterItem_csr ICX_CAT_POPULATE_ITEM_PVT.g_item_csr_type;
732: BEGIN
733: l_err_loc := 100;
734: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
735: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
736: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
737: 'Processing cursor:' || l_api_name ||
738: ', g_upgrade_last_run_date:' || g_upgrade_last_run_date ||
739: ', g_start_rowid:' || g_start_rowid ||

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

1068: l_batch_count := l_batch_count + 1;
1069:
1070: l_err_loc := 600;
1071: l_count := l_inv_item_id_tbl.COUNT;
1072: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1073: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
1074: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1075: 'Num. of rows returned from the cursor:' || l_count);
1076: END IF;

Line 1073: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

1069:
1070: l_err_loc := 600;
1071: l_count := l_inv_item_id_tbl.COUNT;
1072: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1073: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
1074: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1075: 'Num. of rows returned from the cursor:' || l_count);
1076: END IF;
1077:

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

1085: -- First get the status and item_type of the current inventory item line
1086: ICX_CAT_POPULATE_STATUS_PVT.getMasterItemStatusAndType
1087: (l_intrnl_order_enbld_flag_tbl(i), l_outside_operation_flag_tbl(i), l_unit_price_tbl(i),
1088: l_inv_item_status, l_item_type);
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: 'l_inv_item_status: ' || l_inv_item_status ||
1093: 'l_item_type :' || l_item_type);

Line 1090: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

1086: ICX_CAT_POPULATE_STATUS_PVT.getMasterItemStatusAndType
1087: (l_intrnl_order_enbld_flag_tbl(i), l_outside_operation_flag_tbl(i), l_unit_price_tbl(i),
1088: l_inv_item_status, l_item_type);
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: 'l_inv_item_status: ' || l_inv_item_status ||
1093: 'l_item_type :' || l_item_type);
1094: END IF;

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

1091: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1092: 'l_inv_item_status: ' || l_inv_item_status ||
1093: 'l_item_type :' || l_item_type);
1094: END IF;
1095: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1096: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
1097: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1098: 'Values for Variables in populateMIs ' ||
1099: 'l_inv_item_id: ' || l_inv_item_id_tbl(i) ||

Line 1096: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

1092: 'l_inv_item_status: ' || l_inv_item_status ||
1093: 'l_item_type :' || l_item_type);
1094: END IF;
1095: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1096: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
1097: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1098: 'Values for Variables in populateMIs ' ||
1099: 'l_inv_item_id: ' || l_inv_item_id_tbl(i) ||
1100: ',l_po_line_id: ' || l_po_line_id_tbl(i) ||

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

1136: l_err_loc := 800;
1137: -- For category assignment delete
1138: IF (l_po_category_id_tbl(i) IS NULL) THEN
1139: l_err_loc := 900;
1140: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1141: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
1142: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1143: 'null l_po_category_id:' || l_po_category_id_tbl(i) ||
1144: 'for l_inv_item_id_tbl:' || l_inv_item_id_tbl(i) ||

Line 1141: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

1137: -- For category assignment delete
1138: IF (l_po_category_id_tbl(i) IS NULL) THEN
1139: l_err_loc := 900;
1140: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1141: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
1142: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1143: 'null l_po_category_id:' || l_po_category_id_tbl(i) ||
1144: 'for l_inv_item_id_tbl:' || l_inv_item_id_tbl(i) ||
1145: ', l_org_id_tbl:' || l_org_id_tbl(i));

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

1174: IF (l_ctx_rowid_tbl(i) IS NOT NULL
1175: AND p_current_mode = ICX_CAT_UTIL_PVT.g_online_const
1176: AND NOT ICX_CAT_UTIL_PVT.g_ItemCatgChange_const)
1177: THEN
1178: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1179: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
1180: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1181: 'Not changing the po category and ip category for' ||
1182: ', l_inv_item_id_tbl:' || l_inv_item_id_tbl(i) ||

Line 1179: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

1175: AND p_current_mode = ICX_CAT_UTIL_PVT.g_online_const
1176: AND NOT ICX_CAT_UTIL_PVT.g_ItemCatgChange_const)
1177: THEN
1178: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1179: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
1180: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1181: 'Not changing the po category and ip category for' ||
1182: ', l_inv_item_id_tbl:' || l_inv_item_id_tbl(i) ||
1183: ', l_org_id_tbl:' || l_org_id_tbl(i) ||

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

1238: l_err_loc := 1300;
1239: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('INLOOP', ICX_CAT_UTIL_PVT.g_MasterItemCsr_const);
1240: ELSE
1241: IF (p_current_mode = ICX_CAT_UTIL_PVT.g_upgrade_const) THEN
1242: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1243: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1244: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1245: 'Row #:' || i ||
1246: ', item:( ' || l_inv_item_id_tbl(i) ||

Line 1243: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

1239: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('INLOOP', ICX_CAT_UTIL_PVT.g_MasterItemCsr_const);
1240: ELSE
1241: IF (p_current_mode = ICX_CAT_UTIL_PVT.g_upgrade_const) THEN
1242: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1243: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1244: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1245: 'Row #:' || i ||
1246: ', item:( ' || l_inv_item_id_tbl(i) ||
1247: ', ' || l_org_id_tbl(i) || '), Not processed' ||

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

1252: ', po_category_id:' || l_po_category_id_tbl(i) ||
1253: ', status:' || l_inv_item_status);
1254: END IF;
1255: ELSE
1256: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1257: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
1258: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1259: 'Row #:' || i ||
1260: ', item:( ' || l_inv_item_id_tbl(i) ||

Line 1257: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

1253: ', status:' || l_inv_item_status);
1254: END IF;
1255: ELSE
1256: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1257: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
1258: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1259: 'Row #:' || i ||
1260: ', item:( ' || l_inv_item_id_tbl(i) ||
1261: ', ' || l_organization_id_tbl(i) || '), Item is inactive and invalid for purchase, delete from iP tables' ||

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

1295: openCategoryItemsCursor(g_mtl_category_id, l_start_inv_item_id);
1296: ELSE
1297: l_err_loc := 1900;
1298: -- Online case should not throw snapshot too old error.
1299: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1300: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
1301: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1302: 'Online case throwing snap shot too old error');
1303: END IF;

Line 1300: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

1296: ELSE
1297: l_err_loc := 1900;
1298: -- Online case should not throw snapshot too old error.
1299: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1300: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
1301: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1302: 'Online case throwing snap shot too old error');
1303: END IF;
1304: END IF;

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

1312: l_err_loc := 2000;
1313: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('OUTLOOP', ICX_CAT_UTIL_PVT.g_MasterItemCsr_const);
1314:
1315: l_err_loc := 2100;
1316: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1317: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
1318: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1319: 'populateMIs in mode:'|| p_current_mode ||' done; '||
1320: 'Total num. of batches processed:' ||l_batch_count ||

Line 1317: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

1313: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('OUTLOOP', ICX_CAT_UTIL_PVT.g_MasterItemCsr_const);
1314:
1315: l_err_loc := 2100;
1316: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1317: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
1318: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1319: 'populateMIs in mode:'|| p_current_mode ||' done; '||
1320: 'Total num. of batches processed:' ||l_batch_count ||
1321: ', Total num. of rows processed:' ||l_row_count);

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

1389: IF (ICX_CAT_UTIL_PVT.g_category_set_id IS NULL) THEN
1390: l_err_loc := 600;
1391: ICX_CAT_UTIL_PVT.getPurchasingCategorySetInfo;
1392: ELSE
1393: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1394: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1395: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1396: 'Purchasing category set info:' ||
1397: ', g_category_set_id:' || ICX_CAT_UTIL_PVT.g_category_set_id ||

Line 1394: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

1390: l_err_loc := 600;
1391: ICX_CAT_UTIL_PVT.getPurchasingCategorySetInfo;
1392: ELSE
1393: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1394: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1395: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1396: 'Purchasing category set info:' ||
1397: ', g_category_set_id:' || ICX_CAT_UTIL_PVT.g_category_set_id ||
1398: ', g_validate_flag:' || ICX_CAT_UTIL_PVT.g_validate_flag ||

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

1524: l_err_loc := 1700;
1525: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('OUTLOOP', ICX_CAT_UTIL_PVT.g_MasterItemCsr_const);
1526:
1527: l_err_loc := 1800;
1528: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1529: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1530: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1531: 'populateItemDelete done; Total num. of batches processed:' || l_batch_count);
1532: END IF;

Line 1529: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

1525: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('OUTLOOP', ICX_CAT_UTIL_PVT.g_MasterItemCsr_const);
1526:
1527: l_err_loc := 1800;
1528: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1529: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1530: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1531: 'populateItemDelete done; Total num. of batches processed:' || l_batch_count);
1532: END IF;
1533:

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

1612: BEGIN
1613: l_err_loc := 100;
1614: l_start_date := sysdate;
1615:
1616: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1617: l_log_string := 'Started at:' || TO_CHAR(l_start_date, 'DD-MON-YYYY HH24:MI:SS') ||
1618: ', P_MTL_CATEGORY_ID_TBL.COUNT:' || P_MTL_CATEGORY_ID_TBL.COUNT;
1619: ICX_CAT_UTIL_PVT.logProcBegin(g_pkg_name, l_api_name, l_log_string);
1620: END IF;

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

1627: END LOOP;
1628:
1629: l_err_loc := 900;
1630: l_end_date := sysdate;
1631: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1632: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name,
1633: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));
1634: END IF;
1635: EXCEPTION

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

1649: l_err_loc PLS_INTEGER;
1650: BEGIN
1651: l_err_loc := 100;
1652: IF (NOT ICX_CAT_POPULATE_MI_PVT.g_metadataTblFormed) THEN
1653: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1654: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1655: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1656: 'about to call buildmetadatinfo');
1657: END IF;

Line 1654: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

1650: BEGIN
1651: l_err_loc := 100;
1652: IF (NOT ICX_CAT_POPULATE_MI_PVT.g_metadataTblFormed) THEN
1653: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1654: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1655: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1656: 'about to call buildmetadatinfo');
1657: END IF;
1658:

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

1664: END IF;
1665:
1666: l_err_loc := 400;
1667: IF (NOT ICX_CAT_POPULATE_MI_PVT.g_CtxSqlForMIsFormed) THEN
1668: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1669: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1670: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1671: 'about to call buildctxsql');
1672: END IF;

Line 1669: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

1665:
1666: l_err_loc := 400;
1667: IF (NOT ICX_CAT_POPULATE_MI_PVT.g_CtxSqlForMIsFormed) THEN
1668: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1669: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1670: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1671: 'about to call buildctxsql');
1672: END IF;
1673: l_err_loc := 500;