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_ITEM_DIAG_PVT dependencies on ICX_CAT_UTIL_PVT

Line 1236: validation 4 # validate item using api ICX_CAT_UTIL_PVT.is_item_valid_for_search

1232: programmatically or manually
1233: validation 2 # If CTX_IP_INVENTORY_ITEM_ID is -2 , then you need to reextract the item.
1234: icx_cat_items_ctx_hdrs_tlp record missing.
1235: validation 3 # If CTX_IP_CATEGORY_ID is -2 , then you need to reextract the item.
1236: validation 4 # validate item using api ICX_CAT_UTIL_PVT.is_item_valid_for_search
1237: */
1238: if l_row_val(p_row_num)(10) IS NULL THEN
1239: l_row_val(p_row_num)(35):=g_error_code(2);
1240: add_error(char1 => g_error_code(2),

Line 1269: elsif ( ICX_CAT_UTIL_PVT.is_item_valid_for_search(l_row_val(p_row_num)(7),

1265: char2 =>l_row_val(p_row_num)(3),
1266: char3 =>l_row_val(p_row_num)(4),
1267: char4 =>l_row_val(p_row_num)(9));
1268:
1269: elsif ( ICX_CAT_UTIL_PVT.is_item_valid_for_search(l_row_val(p_row_num)(7),
1270: to_number(l_row_val(p_row_num)(2)),
1271: l_row_val(p_row_num)(3),
1272: to_number(l_row_val(p_row_num)(4)),
1273: to_number(l_row_val(p_row_num)(9)),

Line 1345: ICX_CAT_UTIL_PVT.g_ItemCatgChange_const := TRUE;

1341: loop
1342: fetch create_ip_cat into l_po_category_id;
1343: exit when create_ip_cat%NOTFOUND;
1344: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'extracting po_category_id='||l_po_category_id);
1345: ICX_CAT_UTIL_PVT.g_ItemCatgChange_const := TRUE;
1346: ICX_CAT_POPULATE_CATG_GRP.populateValidCategorySetInsert
1347: ( p_api_version =>1.0 ,
1348: p_commit =>FND_API.G_TRUE ,
1349: x_return_status => l_ret ,

Line 1368: ICX_CAT_UTIL_PVT.g_ItemCatgChange_const := TRUE;

1364: loop
1365: fetch create_mappings into l_po_category_id;
1366: exit when create_mappings%NOTFOUND;
1367: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'extracting item='||l_po_category_id);
1368: ICX_CAT_UTIL_PVT.g_ItemCatgChange_const := TRUE;
1369: ICX_CAT_POPULATE_CATG_GRP.populateValidCategorySetInsert
1370: (p_api_version =>1.0 ,
1371: p_commit =>FND_API.G_TRUE ,
1372: x_return_status => l_ret ,

Line 1388: ICX_CAT_UTIL_PVT.setCommitParameter(FND_API.G_TRUE);

1384: fetch create_ctx_hdrs into l_inv_item_id,l_organization_id;
1385: exit when create_ctx_hdrs%NOTFOUND;
1386: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'extracting inv_item_id='||l_inv_item_id|| ' organization_id'||l_organization_id );
1387:
1388: ICX_CAT_UTIL_PVT.setCommitParameter(FND_API.G_TRUE);
1389: ICX_CAT_UTIL_PVT.g_ItemCatgChange_const := FALSE;
1390: ICX_CAT_POPULATE_MI_PVT.populateItemChange(l_inv_item_id, l_organization_id, NULL, NULL);
1391: ICX_CAT_INTERMEDIA_INDEX_PVT.rebuild_index;
1392:

Line 1389: ICX_CAT_UTIL_PVT.g_ItemCatgChange_const := FALSE;

1385: exit when create_ctx_hdrs%NOTFOUND;
1386: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'extracting inv_item_id='||l_inv_item_id|| ' organization_id'||l_organization_id );
1387:
1388: ICX_CAT_UTIL_PVT.setCommitParameter(FND_API.G_TRUE);
1389: ICX_CAT_UTIL_PVT.g_ItemCatgChange_const := FALSE;
1390: ICX_CAT_POPULATE_MI_PVT.populateItemChange(l_inv_item_id, l_organization_id, NULL, NULL);
1391: ICX_CAT_INTERMEDIA_INDEX_PVT.rebuild_index;
1392:
1393: end loop;

Line 1865: ICX_CAT_UTIL_PVT.logProcBegin(g_pkg_name, l_api_name, l_log_string);

1861: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,l_log_string||l_err_loc);
1862: l_log_string := 'Started at:' || TO_CHAR(l_start_date, 'DD-MON-YYYY HH24:MI:SS')|| ' p_source_type=' ||p_source_type ;
1863:
1864: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1865: ICX_CAT_UTIL_PVT.logProcBegin(g_pkg_name, l_api_name, l_log_string);
1866: END IF;
1867: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,l_log_string||l_err_loc);
1868:
1869: l_err_loc := 600;

Line 1871: ICX_CAT_UTIL_PVT.getPurchasingCategorySetInfo;

1867: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,l_log_string||l_err_loc);
1868:
1869: l_err_loc := 600;
1870: --Initialize the purchasing category set info.
1871: ICX_CAT_UTIL_PVT.getPurchasingCategorySetInfo;
1872: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,l_log_string||l_err_loc);
1873:
1874: l_err_loc := 800;
1875: ICX_CAT_UTIL_PVT.setCommitParameter(FND_API.G_TRUE);

Line 1875: ICX_CAT_UTIL_PVT.setCommitParameter(FND_API.G_TRUE);

1871: ICX_CAT_UTIL_PVT.getPurchasingCategorySetInfo;
1872: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,l_log_string||l_err_loc);
1873:
1874: l_err_loc := 800;
1875: ICX_CAT_UTIL_PVT.setCommitParameter(FND_API.G_TRUE);
1876: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,l_log_string||l_err_loc);
1877:
1878: l_err_loc := 900;
1879: -- Set the global parameter ICX_CAT_UTIL_PVT.g_ItemCatgChange_const

Line 1879: -- Set the global parameter ICX_CAT_UTIL_PVT.g_ItemCatgChange_const

1875: ICX_CAT_UTIL_PVT.setCommitParameter(FND_API.G_TRUE);
1876: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,l_log_string||l_err_loc);
1877:
1878: l_err_loc := 900;
1879: -- Set the global parameter ICX_CAT_UTIL_PVT.g_ItemCatgChange_const
1880: ICX_CAT_UTIL_PVT.g_ItemCatgChange_const := TRUE;
1881: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,l_log_string||l_err_loc);
1882:
1883: l_err_loc := 1000;

Line 1880: ICX_CAT_UTIL_PVT.g_ItemCatgChange_const := TRUE;

1876: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,l_log_string||l_err_loc);
1877:
1878: l_err_loc := 900;
1879: -- Set the global parameter ICX_CAT_UTIL_PVT.g_ItemCatgChange_const
1880: ICX_CAT_UTIL_PVT.g_ItemCatgChange_const := TRUE;
1881: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,l_log_string||l_err_loc);
1882:
1883: l_err_loc := 1000;
1884: -- Set the batch_size for the online case

Line 1885: ICX_CAT_UTIL_PVT.setBatchSize;

1881: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,l_log_string||l_err_loc);
1882:
1883: l_err_loc := 1000;
1884: -- Set the batch_size for the online case
1885: ICX_CAT_UTIL_PVT.setBatchSize;
1886: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,l_log_string||l_err_loc);
1887:
1888: l_err_loc := 400;
1889: ICX_CAT_UTIL_PVT.setWhoColumns(g_request_id);

Line 1889: ICX_CAT_UTIL_PVT.setWhoColumns(g_request_id);

1885: ICX_CAT_UTIL_PVT.setBatchSize;
1886: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,l_log_string||l_err_loc);
1887:
1888: l_err_loc := 400;
1889: ICX_CAT_UTIL_PVT.setWhoColumns(g_request_id);
1890: if p_source_type = 'MASTER_ITEM' then
1891:
1892: PO_ATTRIBUTE_VALUES_DATA_FIX;
1893:

Line 1928: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),

1924: -- Call the rebuild index
1925: ICX_CAT_INTERMEDIA_INDEX_PVT.rebuild_index;
1926: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1927: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
1928: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1929: 'Rebuild indexes called.');
1930: END IF;
1931:
1932: l_err_loc := 1600;

Line 1935: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name,

1931:
1932: l_err_loc := 1600;
1933: l_end_date := sysdate;
1934: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1935: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name,
1936: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));
1937: END IF;
1938: EXCEPTION
1939: WHEN OTHERS THEN

Line 1936: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));

1932: l_err_loc := 1600;
1933: l_end_date := sysdate;
1934: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1935: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name,
1936: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));
1937: END IF;
1938: EXCEPTION
1939: WHEN OTHERS THEN
1940: BEGIN

Line 1946: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),

1942: EXCEPTION
1943: WHEN OTHERS THEN
1944: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1945: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1946: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1947: 'ROLLBACK TO the savepoint caused the exception -->'
1948: || SQLERRM);
1949: END IF;
1950: NULL;