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_ITEM_GRP dependencies on FND_LOG

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

27: SAVEPOINT populateVendorNameChanges_sp;
28:
29: l_start_date := sysdate;
30:
31: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
32: l_log_string := 'Started at:' || TO_CHAR(l_start_date, 'DD-MON-YYYY HH24:MI:SS') ||
33: ', p_api_version:' || p_api_version ||
34: ', p_commit:' || p_commit ||
35: ', p_vendor_id:' || p_vendor_id ||

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

52:
53: -- Standard check of P_COMMIT
54: IF (FND_API.To_Boolean(P_COMMIT)) THEN
55: COMMIT;
56: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
57: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
58: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
59: 'Commit done.');
60: END IF;

Line 57: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

53: -- Standard check of P_COMMIT
54: IF (FND_API.To_Boolean(P_COMMIT)) THEN
55: COMMIT;
56: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
57: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
58: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
59: 'Commit done.');
60: END IF;
61: ELSE

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

58: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
59: 'Commit done.');
60: END IF;
61: ELSE
62: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
63: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
64: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
65: 'Commit not done.');
66: END IF;

Line 63: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

59: 'Commit done.');
60: END IF;
61: ELSE
62: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
63: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
64: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
65: 'Commit not done.');
66: END IF;
67: END IF;

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

66: END IF;
67: END IF;
68:
69: l_end_date := sysdate;
70: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
71: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name,
72: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));
73: END IF;
74: EXCEPTION

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

76: BEGIN
77: ROLLBACK TO populateVendorNameChanges_sp;
78: EXCEPTION
79: WHEN OTHERS THEN
80: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
81: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
82: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
83: 'ROLLBACK TO the savepoint caused the exception -->'
84: || SQLERRM);

Line 81: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

77: ROLLBACK TO populateVendorNameChanges_sp;
78: EXCEPTION
79: WHEN OTHERS THEN
80: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
81: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
82: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
83: 'ROLLBACK TO the savepoint caused the exception -->'
84: || SQLERRM);
85: END IF;

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

113: SAVEPOINT populateVendorMerge_sp;
114:
115: l_start_date := sysdate;
116:
117: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
118: l_log_string := 'Started at:' || TO_CHAR(l_start_date, 'DD-MON-YYYY HH24:MI:SS') ||
119: ', p_api_version:' || p_api_version ||
120: ', p_commit:' || p_commit ||
121: ', p_from_vendor_id:' || p_from_vendor_id ||

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

140:
141: -- Standard check of P_COMMIT
142: IF (FND_API.To_Boolean(P_COMMIT)) THEN
143: COMMIT;
144: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
145: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
146: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
147: 'Commit done.');
148: END IF;

Line 145: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

141: -- Standard check of P_COMMIT
142: IF (FND_API.To_Boolean(P_COMMIT)) THEN
143: COMMIT;
144: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
145: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
146: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
147: 'Commit done.');
148: END IF;
149: ELSE

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

146: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
147: 'Commit done.');
148: END IF;
149: ELSE
150: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
151: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
152: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
153: 'Commit not done.');
154: END IF;

Line 151: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

147: 'Commit done.');
148: END IF;
149: ELSE
150: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
151: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
152: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
153: 'Commit not done.');
154: END IF;
155: END IF;

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

154: END IF;
155: END IF;
156:
157: l_end_date := sysdate;
158: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
159: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name,
160: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));
161: END IF;
162: EXCEPTION

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

164: BEGIN
165: ROLLBACK TO populateVendorMerge_sp;
166: EXCEPTION
167: WHEN OTHERS THEN
168: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
169: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
170: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
171: 'ROLLBACK TO the savepoint caused the exception -->'
172: || SQLERRM);

Line 169: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

165: ROLLBACK TO populateVendorMerge_sp;
166: EXCEPTION
167: WHEN OTHERS THEN
168: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
169: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
170: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
171: 'ROLLBACK TO the savepoint caused the exception -->'
172: || SQLERRM);
173: END IF;

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

197:
198: l_err_loc := 200;
199: l_start_date := sysdate;
200:
201: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
202: l_log_string := 'Started at:' || TO_CHAR(l_start_date, 'DD-MON-YYYY HH24:MI:SS') ||
203: ', p_api_version:' || p_api_version ||
204: ', p_commit:' || p_commit ;
205: ICX_CAT_UTIL_PVT.logProcBegin(g_pkg_name, l_api_name, l_log_string);

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

216: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
217: END IF;
218:
219: l_err_loc := 500;
220: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
221: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
222: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
223: ' About to call rebuild_index');
224: END IF;

Line 221: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

217: END IF;
218:
219: l_err_loc := 500;
220: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
221: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
222: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
223: ' About to call rebuild_index');
224: END IF;
225:

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

227: ICX_CAT_INTERMEDIA_INDEX_PVT.rebuild_index;
228:
229: l_err_loc := 700;
230: l_end_date := sysdate;
231: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
232: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name,
233: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));
234: END IF;
235: