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 ICX_CAT_UTIL_PVT

Line 40: ICX_CAT_UTIL_PVT.setCommitParameter(p_commit);

36: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
37: END IF;
38:
39: l_err_loc := 500;
40: ICX_CAT_UTIL_PVT.setCommitParameter(p_commit);
41:
42: l_err_loc := 600;
43: ICX_CAT_R12_UPGRADE_PVT.updatePOHeaderId(p_interface_header_id);
44:

Line 51: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),

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
55: l_err_loc := 800;

Line 58: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),

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;
62: EXCEPTION

Line 70: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),

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;
74: NULL;

Line 113: ICX_CAT_UTIL_PVT.setCommitParameter(p_commit);

109: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
110: END IF;
111:
112: l_err_loc := 500;
113: ICX_CAT_UTIL_PVT.setCommitParameter(p_commit);
114:
115: l_err_loc := 600;
116: ICX_CAT_R12_UPGRADE_PVT.updatePOLineId(p_interface_line_id);
117:

Line 125: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),

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
129: l_err_loc := 900;

Line 132: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),

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;
136: EXCEPTION

Line 144: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),

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;
148: NULL;

Line 216: ICX_CAT_UTIL_PVT.setCommitParameter(p_commit);

212: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
213: END IF;
214:
215: l_err_loc := 500;
216: ICX_CAT_UTIL_PVT.setCommitParameter(p_commit);
217:
218: l_err_loc := 600;
219:
220: l_upgrade_job_number := ICX_CAT_UTIL_PVT.getR12UpgradeJobNumber;

Line 220: l_upgrade_job_number := ICX_CAT_UTIL_PVT.getR12UpgradeJobNumber;

216: ICX_CAT_UTIL_PVT.setCommitParameter(p_commit);
217:
218: l_err_loc := 600;
219:
220: l_upgrade_job_number := ICX_CAT_UTIL_PVT.getR12UpgradeJobNumber;
221:
222: l_err_loc := 620;
223: -- gUserId is used in created_by which should be -12 to identify the rows created by r12 upgrade
224: ICX_CAT_UTIL_PVT.g_who_columns_rec.user_id := ICX_CAT_UTIL_PVT.g_upgrade_user;

Line 224: ICX_CAT_UTIL_PVT.g_who_columns_rec.user_id := ICX_CAT_UTIL_PVT.g_upgrade_user;

220: l_upgrade_job_number := ICX_CAT_UTIL_PVT.getR12UpgradeJobNumber;
221:
222: l_err_loc := 620;
223: -- gUserId is used in created_by which should be -12 to identify the rows created by r12 upgrade
224: ICX_CAT_UTIL_PVT.g_who_columns_rec.user_id := ICX_CAT_UTIL_PVT.g_upgrade_user;
225: ICX_CAT_UTIL_PVT.g_who_columns_rec.internal_request_id := ICX_CAT_UTIL_PVT.getNextSequenceForWhoColumns;
226: ICX_CAT_UTIL_PVT.g_who_columns_rec.login_id := l_upgrade_job_number;
227: ICX_CAT_UTIL_PVT.g_who_columns_rec.request_id := l_upgrade_job_number;
228: ICX_CAT_UTIL_PVT.g_who_columns_rec.program_application_id := l_upgrade_job_number;

Line 225: ICX_CAT_UTIL_PVT.g_who_columns_rec.internal_request_id := ICX_CAT_UTIL_PVT.getNextSequenceForWhoColumns;

221:
222: l_err_loc := 620;
223: -- gUserId is used in created_by which should be -12 to identify the rows created by r12 upgrade
224: ICX_CAT_UTIL_PVT.g_who_columns_rec.user_id := ICX_CAT_UTIL_PVT.g_upgrade_user;
225: ICX_CAT_UTIL_PVT.g_who_columns_rec.internal_request_id := ICX_CAT_UTIL_PVT.getNextSequenceForWhoColumns;
226: ICX_CAT_UTIL_PVT.g_who_columns_rec.login_id := l_upgrade_job_number;
227: ICX_CAT_UTIL_PVT.g_who_columns_rec.request_id := l_upgrade_job_number;
228: ICX_CAT_UTIL_PVT.g_who_columns_rec.program_application_id := l_upgrade_job_number;
229: ICX_CAT_UTIL_PVT.g_who_columns_rec.program_id := l_upgrade_job_number;

Line 226: ICX_CAT_UTIL_PVT.g_who_columns_rec.login_id := l_upgrade_job_number;

222: l_err_loc := 620;
223: -- gUserId is used in created_by which should be -12 to identify the rows created by r12 upgrade
224: ICX_CAT_UTIL_PVT.g_who_columns_rec.user_id := ICX_CAT_UTIL_PVT.g_upgrade_user;
225: ICX_CAT_UTIL_PVT.g_who_columns_rec.internal_request_id := ICX_CAT_UTIL_PVT.getNextSequenceForWhoColumns;
226: ICX_CAT_UTIL_PVT.g_who_columns_rec.login_id := l_upgrade_job_number;
227: ICX_CAT_UTIL_PVT.g_who_columns_rec.request_id := l_upgrade_job_number;
228: ICX_CAT_UTIL_PVT.g_who_columns_rec.program_application_id := l_upgrade_job_number;
229: ICX_CAT_UTIL_PVT.g_who_columns_rec.program_id := l_upgrade_job_number;
230: ICX_CAT_UTIL_PVT.g_who_columns_rec.program_login_id := l_upgrade_job_number;

Line 227: ICX_CAT_UTIL_PVT.g_who_columns_rec.request_id := l_upgrade_job_number;

223: -- gUserId is used in created_by which should be -12 to identify the rows created by r12 upgrade
224: ICX_CAT_UTIL_PVT.g_who_columns_rec.user_id := ICX_CAT_UTIL_PVT.g_upgrade_user;
225: ICX_CAT_UTIL_PVT.g_who_columns_rec.internal_request_id := ICX_CAT_UTIL_PVT.getNextSequenceForWhoColumns;
226: ICX_CAT_UTIL_PVT.g_who_columns_rec.login_id := l_upgrade_job_number;
227: ICX_CAT_UTIL_PVT.g_who_columns_rec.request_id := l_upgrade_job_number;
228: ICX_CAT_UTIL_PVT.g_who_columns_rec.program_application_id := l_upgrade_job_number;
229: ICX_CAT_UTIL_PVT.g_who_columns_rec.program_id := l_upgrade_job_number;
230: ICX_CAT_UTIL_PVT.g_who_columns_rec.program_login_id := l_upgrade_job_number;
231:

Line 228: ICX_CAT_UTIL_PVT.g_who_columns_rec.program_application_id := l_upgrade_job_number;

224: ICX_CAT_UTIL_PVT.g_who_columns_rec.user_id := ICX_CAT_UTIL_PVT.g_upgrade_user;
225: ICX_CAT_UTIL_PVT.g_who_columns_rec.internal_request_id := ICX_CAT_UTIL_PVT.getNextSequenceForWhoColumns;
226: ICX_CAT_UTIL_PVT.g_who_columns_rec.login_id := l_upgrade_job_number;
227: ICX_CAT_UTIL_PVT.g_who_columns_rec.request_id := l_upgrade_job_number;
228: ICX_CAT_UTIL_PVT.g_who_columns_rec.program_application_id := l_upgrade_job_number;
229: ICX_CAT_UTIL_PVT.g_who_columns_rec.program_id := l_upgrade_job_number;
230: ICX_CAT_UTIL_PVT.g_who_columns_rec.program_login_id := l_upgrade_job_number;
231:
232: l_err_loc := 630;

Line 229: ICX_CAT_UTIL_PVT.g_who_columns_rec.program_id := l_upgrade_job_number;

225: ICX_CAT_UTIL_PVT.g_who_columns_rec.internal_request_id := ICX_CAT_UTIL_PVT.getNextSequenceForWhoColumns;
226: ICX_CAT_UTIL_PVT.g_who_columns_rec.login_id := l_upgrade_job_number;
227: ICX_CAT_UTIL_PVT.g_who_columns_rec.request_id := l_upgrade_job_number;
228: ICX_CAT_UTIL_PVT.g_who_columns_rec.program_application_id := l_upgrade_job_number;
229: ICX_CAT_UTIL_PVT.g_who_columns_rec.program_id := l_upgrade_job_number;
230: ICX_CAT_UTIL_PVT.g_who_columns_rec.program_login_id := l_upgrade_job_number;
231:
232: l_err_loc := 630;
233: ICX_CAT_UTIL_PVT.g_job_type := p_job_type;

Line 230: ICX_CAT_UTIL_PVT.g_who_columns_rec.program_login_id := l_upgrade_job_number;

226: ICX_CAT_UTIL_PVT.g_who_columns_rec.login_id := l_upgrade_job_number;
227: ICX_CAT_UTIL_PVT.g_who_columns_rec.request_id := l_upgrade_job_number;
228: ICX_CAT_UTIL_PVT.g_who_columns_rec.program_application_id := l_upgrade_job_number;
229: ICX_CAT_UTIL_PVT.g_who_columns_rec.program_id := l_upgrade_job_number;
230: ICX_CAT_UTIL_PVT.g_who_columns_rec.program_login_id := l_upgrade_job_number;
231:
232: l_err_loc := 630;
233: ICX_CAT_UTIL_PVT.g_job_type := p_job_type;
234: ICX_CAT_UTIL_PVT.g_job_number := l_upgrade_job_number;

Line 233: ICX_CAT_UTIL_PVT.g_job_type := p_job_type;

229: ICX_CAT_UTIL_PVT.g_who_columns_rec.program_id := l_upgrade_job_number;
230: ICX_CAT_UTIL_PVT.g_who_columns_rec.program_login_id := l_upgrade_job_number;
231:
232: l_err_loc := 630;
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

Line 234: ICX_CAT_UTIL_PVT.g_job_number := l_upgrade_job_number;

230: ICX_CAT_UTIL_PVT.g_who_columns_rec.program_login_id := l_upgrade_job_number;
231:
232: l_err_loc := 630;
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,

Line 239: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),

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;
243:

Line 240: ' g_job_type:' || ICX_CAT_UTIL_PVT.g_job_type ||

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;
243:
244: l_err_loc := 650;

Line 241: ' g_job_number:' || ICX_CAT_UTIL_PVT.g_job_number);

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;
243:
244: l_err_loc := 650;
245: ICX_CAT_R12_UPGRADE_PVT.createR12UpgradeJob(p_audsid);

Line 254: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),

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
258: l_err_loc := 900;

Line 261: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),

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;
265:

Line 274: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),

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;
278: NULL;

Line 341: ICX_CAT_UTIL_PVT.setCommitParameter(p_commit);

337: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
338: END IF;
339:
340: l_err_loc := 500;
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

Line 347: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),

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

Line 348: ' g_job_type:' || ICX_CAT_UTIL_PVT.g_job_type ||

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);
351: END IF;
352:

Line 349: ' g_job_number:' || ICX_CAT_UTIL_PVT.g_job_number ||

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);
351: END IF;
352:
353: IF (p_job_status = g_job_complete_status) THEN

Line 354: ICX_CAT_UTIL_PVT.g_job_complete_date := SYSDATE;

350: ' p_job_status:' || p_job_status);
351: END IF;
352:
353: IF (p_job_status = g_job_complete_status) THEN
354: ICX_CAT_UTIL_PVT.g_job_complete_date := SYSDATE;
355: ELSE
356: ICX_CAT_UTIL_PVT.g_job_complete_date := NULL;
357: END IF;
358:

Line 356: ICX_CAT_UTIL_PVT.g_job_complete_date := NULL;

352:
353: IF (p_job_status = g_job_complete_status) THEN
354: ICX_CAT_UTIL_PVT.g_job_complete_date := SYSDATE;
355: ELSE
356: ICX_CAT_UTIL_PVT.g_job_complete_date := NULL;
357: END IF;
358:
359: l_err_loc := 2400;
360: ICX_CAT_R12_UPGRADE_PVT.updateR12UpgradeJob(p_job_status);

Line 369: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),

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
373: l_err_loc := 900;

Line 376: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),

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;
380:

Line 389: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),

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;
393: NULL;