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_BPA_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: EXCEPTION

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

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

Line 93: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

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

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

126:
127: l_err_loc := 300;
128: l_start_date := sysdate;
129:
130: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
131: l_log_string := 'Started at:' || TO_CHAR(l_start_date, 'DD-MON-YYYY HH24:MI:SS') ||
132: ', p_api_version:' || p_api_version ||
133: ', p_commit:' || p_commit ||
134: ', p_key:' || p_key;

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

158: COMMIT;
159: l_err_loc := 900;
160: -- Call the rebuild index
161: ICX_CAT_INTERMEDIA_INDEX_PVT.rebuild_index;
162: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
163: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
164: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
165: 'Rebuild indexes called.');
166: END IF;

Line 163: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

159: l_err_loc := 900;
160: -- Call the rebuild index
161: ICX_CAT_INTERMEDIA_INDEX_PVT.rebuild_index;
162: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
163: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
164: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
165: 'Rebuild indexes called.');
166: END IF;
167: ELSE

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

165: 'Rebuild indexes called.');
166: END IF;
167: ELSE
168: l_err_loc := 1000;
169: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
170: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
171: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
172: 'p_commit is false, so Rebuild indexes is not called.');
173: END IF;

Line 170: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

166: END IF;
167: ELSE
168: l_err_loc := 1000;
169: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
170: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
171: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
172: 'p_commit is false, so Rebuild indexes is not called.');
173: END IF;
174: END IF;

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

174: END IF;
175:
176: l_err_loc := 1100;
177: l_end_date := sysdate;
178: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
179: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name,
180: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));
181: END IF;
182: EXCEPTION

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

184: BEGIN
185: ROLLBACK TO populateOnlineOrgAssgnmnts_sp;
186: EXCEPTION
187: WHEN OTHERS THEN
188: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
189: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
190: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
191: 'ROLLBACK TO the savepoint caused the exception -->'
192: || SQLERRM);

Line 189: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

185: ROLLBACK TO populateOnlineOrgAssgnmnts_sp;
186: EXCEPTION
187: WHEN OTHERS THEN
188: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
189: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
190: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
191: 'ROLLBACK TO the savepoint caused the exception -->'
192: || SQLERRM);
193: END IF;