APPS.ICX_CAT_POPULATE_QUOTE_GRP dependencies on FND_LOG

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

30:
31: l_err_loc := 300;
32: l_start_date := sysdate;
33:
34: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
35: l_log_string := 'Started at:' || TO_CHAR(l_start_date, 'DD-MON-YYYY HH24:MI:SS') ||
36: ', p_api_version:' || p_api_version ||
37: ', p_commit:' || p_commit ||
38: ', p_key:' || p_key;

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

62: COMMIT;
63: l_err_loc := 900;
64: -- Call the rebuild index
65: ICX_CAT_INTERMEDIA_INDEX_PVT.rebuild_index;
66: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
67: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
68: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
69: 'Rebuild indexes called.');
70: END IF;

Line 67: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

63: l_err_loc := 900;
64: -- Call the rebuild index
65: ICX_CAT_INTERMEDIA_INDEX_PVT.rebuild_index;
66: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
67: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
68: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
69: 'Rebuild indexes called.');
70: END IF;
71: ELSE

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

69: 'Rebuild indexes called.');
70: END IF;
71: ELSE
72: l_err_loc := 1000;
73: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
74: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
75: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
76: 'p_commit is false, so Rebuild indexes is not called.');
77: END IF;

Line 74: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

70: END IF;
71: ELSE
72: l_err_loc := 1000;
73: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
74: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
75: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
76: 'p_commit is false, so Rebuild indexes is not called.');
77: END IF;
78: END IF;

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

78: END IF;
79:
80: l_err_loc := 1100;
81: l_end_date := sysdate;
82: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
83: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name,
84: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));
85: END IF;
86:

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

89: BEGIN
90: ROLLBACK TO populateOnlineQuotes_sp;
91: EXCEPTION
92: WHEN OTHERS THEN
93: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
94: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
95: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
96: 'ROLLBACK TO the savepoint caused the exception -->'
97: || SQLERRM);

Line 94: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

90: ROLLBACK TO populateOnlineQuotes_sp;
91: EXCEPTION
92: WHEN OTHERS THEN
93: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
94: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
95: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
96: 'ROLLBACK TO the savepoint caused the exception -->'
97: || SQLERRM);
98: END IF;