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

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

45: -- Standard check of p_commit
46: IF FND_API.To_Boolean( p_commit ) THEN
47: l_err_loc := 700;
48: COMMIT;
49: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
50: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
51: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
52: '; Commit done.');
53: END IF;

Line 50: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

46: IF FND_API.To_Boolean( p_commit ) THEN
47: l_err_loc := 700;
48: COMMIT;
49: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
50: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
51: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
52: '; Commit done.');
53: END IF;
54: ELSE

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

52: '; Commit done.');
53: END IF;
54: ELSE
55: l_err_loc := 800;
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 not done.' );
60: END IF;

Line 57: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

53: END IF;
54: ELSE
55: l_err_loc := 800;
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 not done.' );
60: END IF;
61: END IF;

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

64: BEGIN
65: ROLLBACK TO updatePOHeaderId_sp;
66: EXCEPTION
67: WHEN OTHERS THEN
68: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
69: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
70: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
71: 'ROLLBACK TO the savepoint caused the exception -->'
72: || SQLERRM);

Line 69: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

65: ROLLBACK TO updatePOHeaderId_sp;
66: EXCEPTION
67: WHEN OTHERS THEN
68: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
69: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
70: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
71: 'ROLLBACK TO the savepoint caused the exception -->'
72: || SQLERRM);
73: END IF;

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

119: -- Standard check of p_commit
120: IF FND_API.To_Boolean( p_commit ) THEN
121: l_err_loc := 800;
122: COMMIT;
123: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
124: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
125: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
126: '; Commit done.');
127: END IF;

Line 124: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

120: IF FND_API.To_Boolean( p_commit ) THEN
121: l_err_loc := 800;
122: COMMIT;
123: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
124: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
125: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
126: '; Commit done.');
127: END IF;
128: ELSE

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

126: '; Commit done.');
127: END IF;
128: ELSE
129: l_err_loc := 900;
130: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
131: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
132: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
133: '; Commit not done.');
134: END IF;

Line 131: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

127: END IF;
128: ELSE
129: l_err_loc := 900;
130: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
131: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
132: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
133: '; Commit not done.');
134: END IF;
135: END IF;

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

138: BEGIN
139: ROLLBACK TO updatePOLineId_sp;
140: EXCEPTION
141: WHEN OTHERS THEN
142: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
143: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
144: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
145: 'ROLLBACK TO the savepoint caused the exception -->'
146: || SQLERRM);

Line 143: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

139: ROLLBACK TO updatePOLineId_sp;
140: EXCEPTION
141: WHEN OTHERS THEN
142: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
143: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
144: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
145: 'ROLLBACK TO the savepoint caused the exception -->'
146: || SQLERRM);
147: END IF;

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

233: ICX_CAT_UTIL_PVT.g_job_type := p_job_type;
234: ICX_CAT_UTIL_PVT.g_job_number := l_upgrade_job_number;
235:
236: l_err_loc := 640;
237: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
238: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
239: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
240: ' g_job_type:' || ICX_CAT_UTIL_PVT.g_job_type ||
241: ' g_job_number:' || ICX_CAT_UTIL_PVT.g_job_number);

Line 238: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

234: ICX_CAT_UTIL_PVT.g_job_number := l_upgrade_job_number;
235:
236: l_err_loc := 640;
237: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
238: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
239: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
240: ' g_job_type:' || ICX_CAT_UTIL_PVT.g_job_type ||
241: ' g_job_number:' || ICX_CAT_UTIL_PVT.g_job_number);
242: END IF;

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

248: -- Standard check of p_commit
249: IF FND_API.To_Boolean( p_commit ) THEN
250: l_err_loc := 800;
251: COMMIT;
252: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
253: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
254: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
255: '; Commit done.');
256: END IF;

Line 253: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

249: IF FND_API.To_Boolean( p_commit ) THEN
250: l_err_loc := 800;
251: COMMIT;
252: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
253: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
254: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
255: '; Commit done.');
256: END IF;
257: ELSE

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

255: '; Commit done.');
256: END IF;
257: ELSE
258: l_err_loc := 900;
259: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
260: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
261: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
262: '; Commit not done.');
263: END IF;

Line 260: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

256: END IF;
257: ELSE
258: l_err_loc := 900;
259: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
260: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
261: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
262: '; Commit not done.');
263: END IF;
264: END IF;

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

268: BEGIN
269: ROLLBACK TO createR12UpgradeJob_sp;
270: EXCEPTION
271: WHEN OTHERS THEN
272: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
273: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
274: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
275: 'ROLLBACK TO the savepoint caused the exception -->'
276: || SQLERRM);

Line 273: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

269: ROLLBACK TO createR12UpgradeJob_sp;
270: EXCEPTION
271: WHEN OTHERS THEN
272: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
273: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
274: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
275: 'ROLLBACK TO the savepoint caused the exception -->'
276: || SQLERRM);
277: END IF;

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

341: ICX_CAT_UTIL_PVT.setCommitParameter(p_commit);
342:
343: l_err_loc := 600;
344:
345: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
346: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
347: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
348: ' g_job_type:' || ICX_CAT_UTIL_PVT.g_job_type ||
349: ' g_job_number:' || ICX_CAT_UTIL_PVT.g_job_number ||

Line 346: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

342:
343: l_err_loc := 600;
344:
345: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
346: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
347: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
348: ' g_job_type:' || ICX_CAT_UTIL_PVT.g_job_type ||
349: ' g_job_number:' || ICX_CAT_UTIL_PVT.g_job_number ||
350: ' p_job_status:' || p_job_status);

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

363: -- Standard check of p_commit
364: IF FND_API.To_Boolean( p_commit ) THEN
365: l_err_loc := 800;
366: COMMIT;
367: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
368: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
369: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
370: '; Commit done.');
371: END IF;

Line 368: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

364: IF FND_API.To_Boolean( p_commit ) THEN
365: l_err_loc := 800;
366: COMMIT;
367: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
368: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
369: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
370: '; Commit done.');
371: END IF;
372: ELSE

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

370: '; Commit done.');
371: END IF;
372: ELSE
373: l_err_loc := 900;
374: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
375: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
376: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
377: '; Commit not done.');
378: END IF;

Line 375: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

371: END IF;
372: ELSE
373: l_err_loc := 900;
374: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
375: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
376: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
377: '; Commit not done.');
378: END IF;
379: END IF;

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

383: BEGIN
384: ROLLBACK TO updateR12UpgradeJob_sp;
385: EXCEPTION
386: WHEN OTHERS THEN
387: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
388: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
389: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
390: 'ROLLBACK TO the savepoint caused the exception -->'
391: || SQLERRM);

Line 388: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

384: ROLLBACK TO updateR12UpgradeJob_sp;
385: EXCEPTION
386: WHEN OTHERS THEN
387: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
388: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
389: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
390: 'ROLLBACK TO the savepoint caused the exception -->'
391: || SQLERRM);
392: END IF;