APPS.ICX_ITEM_DIAG_PVT dependencies on FND_LOG

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

11: l_err_loc PLS_INTEGER;
12: BEGIN
13: l_err_loc := 100;
14: FND_FILE.PUT_LINE(FND_FILE.LOG, 'icx.plsql.' || UPPER(p_pkg_name) || '.' || UPPER(p_proc_name)|| 'EXCEPTION::'|| p_log_string);
15: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
16: l_err_loc := 200;
17: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,'icx.plsql.' || UPPER(p_pkg_name) || '.' || UPPER(p_proc_name) , p_log_string);
18: l_err_loc := 300;
19: END IF;

Line 17: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,'icx.plsql.' || UPPER(p_pkg_name) || '.' || UPPER(p_proc_name) , p_log_string);

13: l_err_loc := 100;
14: FND_FILE.PUT_LINE(FND_FILE.LOG, 'icx.plsql.' || UPPER(p_pkg_name) || '.' || UPPER(p_proc_name)|| 'EXCEPTION::'|| p_log_string);
15: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
16: l_err_loc := 200;
17: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,'icx.plsql.' || UPPER(p_pkg_name) || '.' || UPPER(p_proc_name) , p_log_string);
18: l_err_loc := 300;
19: END IF;
20: EXCEPTION
21: WHEN OTHERS THEN

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

1860: l_start_date := sysdate;
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:

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

1922: COMMIT;
1923: l_err_loc := 1400;
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;

Line 1927: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

1923: l_err_loc := 1400;
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:

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

1930: END IF;
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

Line 1944: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1940: BEGIN
1941: ROLLBACK TO populateItemSync_sp;
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);

Line 1945: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

1941: ROLLBACK TO populateItemSync_sp;
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;

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

1965: l_err_loc PLS_INTEGER;
1966: BEGIN
1967: l_err_loc := 100;
1968: FND_FILE.PUT_LINE(FND_FILE.LOG, 'icx.plsql.' || UPPER(p_pkg_name) || '.' || UPPER(p_proc_name)|| '::'|| p_log_string);
1969: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1970: l_err_loc := 200;
1971: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, 'icx.plsql.' || UPPER(p_pkg_name) || '.' || UPPER(p_proc_name), p_log_string);
1972: l_err_loc := 400;
1973: END IF;

Line 1971: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, 'icx.plsql.' || UPPER(p_pkg_name) || '.' || UPPER(p_proc_name), p_log_string);

1967: l_err_loc := 100;
1968: FND_FILE.PUT_LINE(FND_FILE.LOG, 'icx.plsql.' || UPPER(p_pkg_name) || '.' || UPPER(p_proc_name)|| '::'|| p_log_string);
1969: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1970: l_err_loc := 200;
1971: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, 'icx.plsql.' || UPPER(p_pkg_name) || '.' || UPPER(p_proc_name), p_log_string);
1972: l_err_loc := 400;
1973: END IF;
1974: EXCEPTION WHEN OTHERS THEN
1975: l_err_loc := 500;