APPS.ICX_CAT_POPULATE_CTXSTRING_PVT dependencies on FND_LOG

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

32: l_csr_handle NUMBER;
33: l_status PLS_INTEGER;
34: BEGIN
35: l_err_loc := 100;
36: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
37: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
38: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
39: 'p_repopulate_at_seq:' || p_repopulate_at_seq);
40: END IF;

Line 37: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

33: l_status PLS_INTEGER;
34: BEGIN
35: l_err_loc := 100;
36: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
37: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
38: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
39: 'p_repopulate_at_seq:' || p_repopulate_at_seq);
40: END IF;
41:

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

53: BULK COLLECT INTO l_rowid_tbl
54: LIMIT ICX_CAT_UTIL_PVT.g_batch_size;
55:
56: l_err_loc := 500;
57: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
58: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
59: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
60: 'fetched from getItemRowsCsr rowcount:' ||l_rowid_tbl.COUNT);
61: END IF;

Line 58: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

54: LIMIT ICX_CAT_UTIL_PVT.g_batch_size;
55:
56: l_err_loc := 500;
57: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
58: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
59: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
60: 'fetched from getItemRowsCsr rowcount:' ||l_rowid_tbl.COUNT);
61: END IF;
62:

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

72: l_err_loc := 900;
73: IF (p_repopulate_at_seq = l_sequence) THEN
74: l_err_loc := 1000;
75: l_ctx_sql_string := l_ctx_sqlstring_rec.ctx_sql_string;
76: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
77: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
78: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
79: 'l_sequence:' || l_sequence ||
80: ', l_ctx_sql_string:' || l_ctx_sql_string);

Line 77: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

73: IF (p_repopulate_at_seq = l_sequence) THEN
74: l_err_loc := 1000;
75: l_ctx_sql_string := l_ctx_sqlstring_rec.ctx_sql_string;
76: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
77: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
78: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
79: 'l_sequence:' || l_sequence ||
80: ', l_ctx_sql_string:' || l_ctx_sql_string);
81: END IF;

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

99: l_err_loc := 1700;
100: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
101: l_err_loc := 1800;
102: COMMIT;
103: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
104: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
105: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
106: 'Commit done.');
107: END IF;

Line 104: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

100: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
101: l_err_loc := 1800;
102: COMMIT;
103: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
104: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
105: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
106: 'Commit done.');
107: END IF;
108: ELSE

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

107: END IF;
108: ELSE
109: l_err_loc := 1900;
110: -- Must log
111: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
112: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
113: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
114: 'Commit not done.');
115: END IF;

Line 112: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

108: ELSE
109: l_err_loc := 1900;
110: -- Must log
111: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
112: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
113: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
114: 'Commit not done.');
115: END IF;
116: END IF;

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

122: l_err_loc := 2100;
123: CLOSE l_csr_var;
124:
125: l_err_loc := 2200;
126: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
127: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
128: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
129: 'done.');
130: END IF;

Line 127: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

123: CLOSE l_csr_var;
124:
125: l_err_loc := 2200;
126: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
127: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
128: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
129: 'done.');
130: END IF;
131: EXCEPTION

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

153: l_csr_handle NUMBER;
154: l_status PLS_INTEGER;
155: BEGIN
156: l_err_loc := 100;
157: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
158: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
159: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
160: 'Start');
161: END IF;

Line 158: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

154: l_status PLS_INTEGER;
155: BEGIN
156: l_err_loc := 100;
157: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
158: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
159: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
160: 'Start');
161: END IF;
162:

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

175: BULK COLLECT INTO l_rowid_tbl
176: LIMIT ICX_CAT_UTIL_PVT.g_batch_size;
177:
178: l_err_loc := 500;
179: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
180: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
181: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
182: 'fetched from getItemRowsCsr rowcount:' ||l_rowid_tbl.COUNT);
183: END IF;

Line 180: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

176: LIMIT ICX_CAT_UTIL_PVT.g_batch_size;
177:
178: l_err_loc := 500;
179: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
180: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
181: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
182: 'fetched from getItemRowsCsr rowcount:' ||l_rowid_tbl.COUNT);
183: END IF;
184:

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

194: l_err_loc := 900;
195: IF (ICX_CAT_BUILD_CTX_SQL_PVT.g_seqForSupplierRow = l_sequence) THEN
196: l_err_loc := 1000;
197: l_ctx_sql_string := l_ctx_sqlstring_rec.ctx_sql_string;
198: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
199: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
200: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
201: 'l_sequence:' || l_sequence ||
202: ', l_ctx_sql_string:' || l_ctx_sql_string);

Line 199: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

195: IF (ICX_CAT_BUILD_CTX_SQL_PVT.g_seqForSupplierRow = l_sequence) THEN
196: l_err_loc := 1000;
197: l_ctx_sql_string := l_ctx_sqlstring_rec.ctx_sql_string;
198: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
199: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
200: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
201: 'l_sequence:' || l_sequence ||
202: ', l_ctx_sql_string:' || l_ctx_sql_string);
203: END IF;

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

222: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
223: l_err_loc := 1800;
224: COMMIT;
225: -- Must log
226: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
227: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
228: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
229: 'Commit done.');
230: END IF;

Line 227: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

223: l_err_loc := 1800;
224: COMMIT;
225: -- Must log
226: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
227: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
228: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
229: 'Commit done.');
230: END IF;
231: ELSE

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

230: END IF;
231: ELSE
232: l_err_loc := 1900;
233: -- Must log
234: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
235: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
236: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
237: 'Commit not done.');
238: END IF;

Line 235: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

231: ELSE
232: l_err_loc := 1900;
233: -- Must log
234: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
235: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
236: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
237: 'Commit not done.');
238: END IF;
239: END IF;

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

245: l_err_loc := 2100;
246: CLOSE l_csr_var;
247:
248: l_err_loc :=2200;
249: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
250: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
251: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
252: 'done.');
253: END IF;

Line 250: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

246: CLOSE l_csr_var;
247:
248: l_err_loc :=2200;
249: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
250: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
251: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
252: 'done.');
253: END IF;
254: EXCEPTION

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

288: l_csr_handle NUMBER;
289: l_status PLS_INTEGER;
290: BEGIN
291: l_err_loc := 100;
292: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
293: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
294: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
295: 'Start; p_doc_source:' || p_doc_source ||
296: ', p_repopulate_at_seq:' || p_repopulate_at_seq);

Line 293: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

289: l_status PLS_INTEGER;
290: BEGIN
291: l_err_loc := 100;
292: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
293: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
294: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
295: 'Start; p_doc_source:' || p_doc_source ||
296: ', p_repopulate_at_seq:' || p_repopulate_at_seq);
297: END IF;

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

323: BULK COLLECT INTO l_rowid_tbl
324: LIMIT ICX_CAT_UTIL_PVT.g_batch_size;
325:
326: l_err_loc := 900;
327: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
328: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
329: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
330: 'fetched from getItemRowsCsr rowcount:' ||l_rowid_tbl.COUNT);
331: END IF;

Line 328: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

324: LIMIT ICX_CAT_UTIL_PVT.g_batch_size;
325:
326: l_err_loc := 900;
327: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
328: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
329: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
330: 'fetched from getItemRowsCsr rowcount:' ||l_rowid_tbl.COUNT);
331: END IF;
332:

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

341: l_ctx_sql_string := null;
342: IF (p_repopulate_at_seq = l_sequence) THEN
343: l_err_loc := 1300;
344: l_ctx_sql_string := l_ctx_sqlstring_rec.ctx_sql_string;
345: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
346: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
347: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
348: 'l_sequence:' || l_sequence ||
349: ', l_ctx_sql_string:' || l_ctx_sql_string);

Line 346: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

342: IF (p_repopulate_at_seq = l_sequence) THEN
343: l_err_loc := 1300;
344: l_ctx_sql_string := l_ctx_sqlstring_rec.ctx_sql_string;
345: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
346: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
347: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
348: 'l_sequence:' || l_sequence ||
349: ', l_ctx_sql_string:' || l_ctx_sql_string);
350: END IF;

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

369: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
370: l_err_loc := 2100;
371: COMMIT;
372: -- Must log
373: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
374: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
375: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
376: 'Commit done.');
377: END IF;

Line 374: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

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

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

377: END IF;
378: ELSE
379: l_err_loc := 2200;
380: -- Must log
381: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
382: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
383: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
384: 'Commit not done.');
385: END IF;

Line 382: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

378: ELSE
379: l_err_loc := 2200;
380: -- Must log
381: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
382: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
383: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
384: 'Commit not done.');
385: END IF;
386: END IF;

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

416: AND hdrs.owning_org_id = dtls.org_id
417: AND dtls.sequence = p_repopulate_at_seq;
418:
419: l_err_loc := 2700;
420: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
421: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
422: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
423: 'Num. of rows inserted for ga:' || SQL%ROWCOUNT);
424: END IF;

Line 421: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

417: AND dtls.sequence = p_repopulate_at_seq;
418:
419: l_err_loc := 2700;
420: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
421: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
422: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
423: 'Num. of rows inserted for ga:' || SQL%ROWCOUNT);
424: END IF;
425:

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

427: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
428: l_err_loc := 2900;
429: COMMIT;
430: -- Must log
431: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
432: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
433: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
434: 'Commit done after populating ctx string for ga.');
435: END IF;

Line 432: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

428: l_err_loc := 2900;
429: COMMIT;
430: -- Must log
431: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
432: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
433: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
434: 'Commit done after populating ctx string for ga.');
435: END IF;
436: ELSE

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

435: END IF;
436: ELSE
437: l_err_loc := 3000;
438: -- Must log
439: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
440: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
441: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
442: 'Commit not done after populating ctx string for ga.');
443: END IF;

Line 440: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

436: ELSE
437: l_err_loc := 3000;
438: -- Must log
439: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
440: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
441: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
442: 'Commit not done after populating ctx string for ga.');
443: END IF;
444: END IF;

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

444: END IF;
445: END IF;
446:
447: l_err_loc := 3100;
448: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
449: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
450: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
451: 'done.');
452: END IF;

Line 449: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

445: END IF;
446:
447: l_err_loc := 3100;
448: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
449: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
450: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
451: 'done.');
452: END IF;
453: EXCEPTION

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

476: l_csr_handle NUMBER;
477: l_status PLS_INTEGER;
478: BEGIN
479: l_err_loc := 100;
480: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
481: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
482: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
483: 'Start; p_doc_source:' || p_doc_source);
484: END IF;

Line 481: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

477: l_status PLS_INTEGER;
478: BEGIN
479: l_err_loc := 100;
480: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
481: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
482: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
483: 'Start; p_doc_source:' || p_doc_source);
484: END IF;
485:

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

507: BULK COLLECT INTO l_rowid_tbl
508: LIMIT ICX_CAT_UTIL_PVT.g_batch_size;
509:
510: l_err_loc := 700;
511: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
512: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
513: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
514: 'fetched from getItemRowsCsr rowcount:' ||l_rowid_tbl.COUNT);
515: END IF;

Line 512: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

508: LIMIT ICX_CAT_UTIL_PVT.g_batch_size;
509:
510: l_err_loc := 700;
511: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
512: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
513: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
514: 'fetched from getItemRowsCsr rowcount:' ||l_rowid_tbl.COUNT);
515: END IF;
516:

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

540: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
541: l_err_loc := 1700;
542: COMMIT;
543: -- Must log
544: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
545: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
546: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
547: 'Commit done.');
548: END IF;

Line 545: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

541: l_err_loc := 1700;
542: COMMIT;
543: -- Must log
544: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
545: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
546: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
547: 'Commit done.');
548: END IF;
549: ELSE

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

548: END IF;
549: ELSE
550: l_err_loc := 1800;
551: -- Must log
552: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
553: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
554: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
555: 'Commit not done.');
556: END IF;

Line 553: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

549: ELSE
550: l_err_loc := 1800;
551: -- Must log
552: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
553: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
554: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
555: 'Commit not done.');
556: END IF;
557: END IF;

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

587: AND dtls.sequence BETWEEN ICX_CAT_BUILD_CTX_SQL_PVT.g_seqStartReqularBaseRow
588: AND ICX_CAT_BUILD_CTX_SQL_PVT.g_seqEndReqularBaseRow;
589:
590: l_err_loc := 2300;
591: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
592: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
593: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
594: 'Num. of rows inserted for ga:' || SQL%ROWCOUNT);
595: END IF;

Line 592: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

588: AND ICX_CAT_BUILD_CTX_SQL_PVT.g_seqEndReqularBaseRow;
589:
590: l_err_loc := 2300;
591: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
592: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
593: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
594: 'Num. of rows inserted for ga:' || SQL%ROWCOUNT);
595: END IF;
596:

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

598: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
599: l_err_loc := 2500;
600: COMMIT;
601: -- Must log
602: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
603: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
604: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
605: 'Commit done after populating ctx string for ga.');
606: END IF;

Line 603: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

599: l_err_loc := 2500;
600: COMMIT;
601: -- Must log
602: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
603: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
604: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
605: 'Commit done after populating ctx string for ga.');
606: END IF;
607: ELSE

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

606: END IF;
607: ELSE
608: l_err_loc := 2600;
609: -- Must log
610: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
611: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
612: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
613: 'Commit not done after populating ctx string for ga.');
614: END IF;

Line 611: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

607: ELSE
608: l_err_loc := 2600;
609: -- Must log
610: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
611: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
612: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
613: 'Commit not done after populating ctx string for ga.');
614: END IF;
615: END IF;

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

615: END IF;
616: END IF;
617:
618: l_err_loc := 2700;
619: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
620: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
621: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
622: 'done.');
623: END IF;

Line 620: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

616: END IF;
617:
618: l_err_loc := 2700;
619: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
620: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
621: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
622: 'done.');
623: END IF;
624: EXCEPTION

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

657: l_source_type1 icx_cat_items_ctx_hdrs_tlp.source_type%TYPE;
658: l_source_type2 icx_cat_items_ctx_hdrs_tlp.source_type%TYPE;
659: BEGIN
660: l_err_loc := 100;
661: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
662: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
663: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
664: 'Start; p_doc_source:' || p_doc_source ||
665: ', p_internal_request_id:' || p_internal_request_id);

Line 662: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

658: l_source_type2 icx_cat_items_ctx_hdrs_tlp.source_type%TYPE;
659: BEGIN
660: l_err_loc := 100;
661: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
662: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
663: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
664: 'Start; p_doc_source:' || p_doc_source ||
665: ', p_internal_request_id:' || p_internal_request_id);
666: END IF;

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

678: l_all_ctx_sql_tbl, l_special_ctx_sql_tbl, l_regular_ctx_sql_tbl);
679:
680: l_err_loc := 600;
681:
682: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
683: FOR i in 1..l_all_ctx_sql_tbl.COUNT LOOP
684: l_ctx_sqlstring_rec := l_all_ctx_sql_tbl(i);
685: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
686: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),

Line 685: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

681:
682: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
683: FOR i in 1..l_all_ctx_sql_tbl.COUNT LOOP
684: l_ctx_sqlstring_rec := l_all_ctx_sql_tbl(i);
685: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
686: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
687: 'All ctx SQLs..Value at i:' || i ||
688: ', sequence:' || l_ctx_sqlstring_rec.bind_sequence ||
689: ', sql_string:' || l_ctx_sqlstring_rec.ctx_sql_string );

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

718: l_err_loc := 1500;
719: FETCH getItemRowsCsr BULK COLLECT INTO
720: l_source_type_tbl, l_rowid_tbl LIMIT ICX_CAT_UTIL_PVT.g_batch_size;
721: l_err_loc := 1600;
722: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
723: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
724: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
725: 'fetched from getItemRowsCsr rowcount:' ||l_rowid_tbl.COUNT);
726: END IF;

Line 723: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

719: FETCH getItemRowsCsr BULK COLLECT INTO
720: l_source_type_tbl, l_rowid_tbl LIMIT ICX_CAT_UTIL_PVT.g_batch_size;
721: l_err_loc := 1600;
722: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
723: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
724: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
725: 'fetched from getItemRowsCsr rowcount:' ||l_rowid_tbl.COUNT);
726: END IF;
727:

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

749: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
750: l_err_loc := 2600;
751: COMMIT;
752: -- Must log
753: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
754: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
755: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
756: 'Commit done.');
757: END IF;

Line 754: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

750: l_err_loc := 2600;
751: COMMIT;
752: -- Must log
753: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
754: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
755: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
756: 'Commit done.');
757: END IF;
758: ELSE

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

757: END IF;
758: ELSE
759: l_err_loc := 2700;
760: -- Must log
761: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
762: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
763: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
764: 'Commit not done.');
765: END IF;

Line 762: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

758: ELSE
759: l_err_loc := 2700;
760: -- Must log
761: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
762: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
763: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
764: 'Commit not done.');
765: END IF;
766: END IF;

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

771: l_err_loc := 2900;
772: CLOSE getItemRowsCsr;
773:
774: l_err_loc := 3000;
775: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
776: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
777: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
778: 'done.');
779: END IF;

Line 776: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

772: CLOSE getItemRowsCsr;
773:
774: l_err_loc := 3000;
775: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
776: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
777: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
778: 'done.');
779: END IF;
780:

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

835: l_end_date DATE;
836: BEGIN
837: l_err_loc := 100;
838: l_start_date := sysdate;
839: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
840: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
841: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
842: 'Started at:' || TO_CHAR(l_start_date, 'DD-MON-YYYY HH24:MI:SS') ||
843: ';(' || p_internal_request_id || ');');

Line 840: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

836: BEGIN
837: l_err_loc := 100;
838: l_start_date := sysdate;
839: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
840: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
841: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
842: 'Started at:' || TO_CHAR(l_start_date, 'DD-MON-YYYY HH24:MI:SS') ||
843: ';(' || p_internal_request_id || ');');
844: END IF;

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

844: END IF;
845:
846: l_err_loc := 200;
847: FOR catgRec IN getCategoriesCsr(p_internal_request_id) LOOP
848: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
849: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
850: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
851: 'for category:' || catgRec.rt_category_id);
852: END IF;

Line 849: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

845:
846: l_err_loc := 200;
847: FOR catgRec IN getCategoriesCsr(p_internal_request_id) LOOP
848: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
849: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
850: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
851: 'for category:' || catgRec.rt_category_id);
852: END IF;
853:

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

868: l_regular_nontl_metadata_tbl, l_regular_tl_metadata_tbl,
869: l_all_ctx_sql_tbl, l_special_ctx_sql_tbl, l_regular_ctx_sql_tbl);
870:
871: l_err_loc := 1000;
872: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
873: FOR i in 1..l_all_ctx_sql_tbl.COUNT LOOP
874: l_ctx_sqlstring_rec := l_all_ctx_sql_tbl(i);
875: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
876: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),

Line 875: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

871: l_err_loc := 1000;
872: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
873: FOR i in 1..l_all_ctx_sql_tbl.COUNT LOOP
874: l_ctx_sqlstring_rec := l_all_ctx_sql_tbl(i);
875: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
876: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
877: 'All ctx SQLs..Value at i:' || i ||
878: ', sequence:' || l_ctx_sqlstring_rec.bind_sequence ||
879: ', sql_string:' || l_ctx_sqlstring_rec.ctx_sql_string );

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

889: l_rowid_tbl.DELETE;
890: l_err_loc := 1500;
891: FETCH getItemRowsCsr BULK COLLECT INTO l_rowid_tbl LIMIT ICX_CAT_UTIL_PVT.g_batch_size;
892: l_err_loc := 1600;
893: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
894: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
895: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
896: 'fetched from getItemRowsCsr rowcount:' ||l_rowid_tbl.COUNT);
897: END IF;

Line 894: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

890: l_err_loc := 1500;
891: FETCH getItemRowsCsr BULK COLLECT INTO l_rowid_tbl LIMIT ICX_CAT_UTIL_PVT.g_batch_size;
892: l_err_loc := 1600;
893: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
894: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
895: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
896: 'fetched from getItemRowsCsr rowcount:' ||l_rowid_tbl.COUNT);
897: END IF;
898:

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

920: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
921: l_err_loc := 2600;
922: COMMIT;
923: -- Must log
924: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
925: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
926: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
927: 'Commit done.');
928: END IF;

Line 925: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

921: l_err_loc := 2600;
922: COMMIT;
923: -- Must log
924: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
925: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
926: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
927: 'Commit done.');
928: END IF;
929: ELSE

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

928: END IF;
929: ELSE
930: l_err_loc := 2700;
931: -- Must log
932: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
933: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
934: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
935: 'Commit not done.');
936: END IF;

Line 933: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

929: ELSE
930: l_err_loc := 2700;
931: -- Must log
932: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
933: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
934: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
935: 'Commit not done.');
936: END IF;
937: END IF;

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

974: AND hdrs.language = dtls.language
975: AND dtls.sequence BETWEEN l_start_catg_att_seq AND l_end_catg_att_seq;
976:
977: l_err_loc := 3200;
978: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
979: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
980: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
981: 'Num. of rows inserted for ga:' || SQL%ROWCOUNT);
982: END IF;

Line 979: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

975: AND dtls.sequence BETWEEN l_start_catg_att_seq AND l_end_catg_att_seq;
976:
977: l_err_loc := 3200;
978: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
979: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
980: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
981: 'Num. of rows inserted for ga:' || SQL%ROWCOUNT);
982: END IF;
983:

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

985: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
986: l_err_loc := 3400;
987: COMMIT;
988: -- Must log
989: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
990: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
991: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
992: 'Commit done after populating ctx string for ga.');
993: END IF;

Line 990: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

986: l_err_loc := 3400;
987: COMMIT;
988: -- Must log
989: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
990: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
991: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
992: 'Commit done after populating ctx string for ga.');
993: END IF;
994: ELSE

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

993: END IF;
994: ELSE
995: l_err_loc := 3500;
996: -- Must log
997: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
998: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
999: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1000: 'Commit not done after populating ctx string for ga.');
1001: END IF;

Line 998: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

994: ELSE
995: l_err_loc := 3500;
996: -- Must log
997: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
998: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
999: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1000: 'Commit not done after populating ctx string for ga.');
1001: END IF;
1002: END IF;

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

1002: END IF;
1003:
1004: l_err_loc := 3600;
1005: l_end_date := sysdate;
1006: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1007: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
1008: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1009: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));
1010: END IF;

Line 1007: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

1003:
1004: l_err_loc := 3600;
1005: l_end_date := sysdate;
1006: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1007: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
1008: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1009: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));
1010: END IF;
1011:

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

1028: l_api_name CONSTANT VARCHAR2(30) := 'populateCtxOrgInfo';
1029: l_err_loc PLS_INTEGER;
1030: BEGIN
1031: l_err_loc := 100;
1032: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1033: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1034: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1035: 'Start; p_internal_request_id:' || p_internal_request_id);
1036: END IF;

Line 1033: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

1029: l_err_loc PLS_INTEGER;
1030: BEGIN
1031: l_err_loc := 100;
1032: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1033: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1034: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1035: 'Start; p_internal_request_id:' || p_internal_request_id);
1036: END IF;
1037:

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

1044: l_err_loc := 300;
1045: FETCH getItemRowsCsr BULK COLLECT INTO l_rowid_tbl LIMIT ICX_CAT_UTIL_PVT.g_batch_size;
1046:
1047: l_err_loc := 400;
1048: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1049: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
1050: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1051: 'fetched from getItemRowsCsr rowcount:' ||l_rowid_tbl.COUNT);
1052: END IF;

Line 1049: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

1045: FETCH getItemRowsCsr BULK COLLECT INTO l_rowid_tbl LIMIT ICX_CAT_UTIL_PVT.g_batch_size;
1046:
1047: l_err_loc := 400;
1048: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1049: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
1050: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1051: 'fetched from getItemRowsCsr rowcount:' ||l_rowid_tbl.COUNT);
1052: END IF;
1053:

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

1102: l_err_loc := 1100;
1103: CLOSE getItemRowsCsr;
1104:
1105: l_err_loc := 1200;
1106: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1107: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1108: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1109: 'done.');
1110: END IF;

Line 1107: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

1103: CLOSE getItemRowsCsr;
1104:
1105: l_err_loc := 1200;
1106: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1107: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1108: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1109: 'done.');
1110: END IF;
1111:

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

1148: BEGIN
1149: l_err_loc := 100;
1150: l_start_date := sysdate;
1151:
1152: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1153: l_log_string := 'Started at:' || TO_CHAR(l_start_date, 'DD-MON-YYYY HH24:MI:SS') ;
1154: ICX_CAT_UTIL_PVT.logProcBegin(g_pkg_name, l_api_name, l_log_string);
1155: END IF;
1156:

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

1170: populateCtxCatgAtt(p_internal_request_id);
1171: END IF;
1172: l_err_loc := 600;
1173: l_end_date := sysdate;
1174: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1175: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name,
1176: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));
1177: END IF;
1178:

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

1209: l_err_string VARCHAR2(4000);
1210:
1211: BEGIN
1212: l_err_loc := 100;
1213: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1214: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1215: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1216: 'Start; (' || p_category_id ||', ' || p_attribute_key ||', ' || ');');
1217: END IF;

Line 1214: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

1210:
1211: BEGIN
1212: l_err_loc := 100;
1213: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1214: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1215: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1216: 'Start; (' || p_category_id ||', ' || p_attribute_key ||', ' || ');');
1217: END IF;
1218: -- Update ctx_desc and internal_request_id for all items if ip_category_id = 0 in hdrs tlp

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

1247: LIMIT ICX_CAT_UTIL_PVT.g_batch_size;
1248:
1249: l_err_loc := 500;
1250: EXIT WHEN l_rowid_tbl.COUNT = 0;
1251: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1252: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1253: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1254: 'Num. of rows returned from the cursor:' || l_rowid_tbl.COUNT);
1255: END IF;

Line 1252: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

1248:
1249: l_err_loc := 500;
1250: EXIT WHEN l_rowid_tbl.COUNT = 0;
1251: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1252: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1253: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1254: 'Num. of rows returned from the cursor:' || l_rowid_tbl.COUNT);
1255: END IF;
1256:

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

1270: AND language = l_language_tbl(i)
1271: AND sequence BETWEEN l_start_sequence AND l_end_sequence;
1272:
1273: l_err_loc := 900;
1274: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1275: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1276: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1277: ' Num. of rows deleted from dtls for category_id:' || SQL%ROWCOUNT);
1278: END IF;

Line 1275: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

1271: AND sequence BETWEEN l_start_sequence AND l_end_sequence;
1272:
1273: l_err_loc := 900;
1274: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1275: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1276: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1277: ' Num. of rows deleted from dtls for category_id:' || SQL%ROWCOUNT);
1278: END IF;
1279: ELSE

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

1291: AND language = l_language_tbl(i)
1292: AND sequence = ICX_CAT_BUILD_CTX_SQL_PVT.g_seqMandatoryBaseRow;
1293:
1294: l_err_loc := 1200;
1295: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1296: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1297: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1298: 'Num. of rows deleted from dtls for partNum, auxid:' || SQL%ROWCOUNT);
1299: END IF;

Line 1296: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

1292: AND sequence = ICX_CAT_BUILD_CTX_SQL_PVT.g_seqMandatoryBaseRow;
1293:
1294: l_err_loc := 1200;
1295: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1296: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1297: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1298: 'Num. of rows deleted from dtls for partNum, auxid:' || SQL%ROWCOUNT);
1299: END IF;
1300: ELSIF (p_attribute_key = 'SUPPLIER') THEN

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

1310: AND language = l_language_tbl(i)
1311: AND sequence = ICX_CAT_BUILD_CTX_SQL_PVT.g_seqForSupplierRow;
1312:
1313: l_err_loc := 1400;
1314: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1315: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1316: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1317: 'Num. of rows deleted from dtls for supp:' || SQL%ROWCOUNT);
1318: END IF;

Line 1315: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

1311: AND sequence = ICX_CAT_BUILD_CTX_SQL_PVT.g_seqForSupplierRow;
1312:
1313: l_err_loc := 1400;
1314: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1315: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1316: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1317: 'Num. of rows deleted from dtls for supp:' || SQL%ROWCOUNT);
1318: END IF;
1319: ELSIF (p_attribute_key = 'INTERNAL_ITEM_NUM') THEN

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

1329: AND language = l_language_tbl(i)
1330: AND sequence = ICX_CAT_BUILD_CTX_SQL_PVT.g_seqForInternalItemNumRow;
1331:
1332: l_err_loc := 1600;
1333: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1334: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1335: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1336: 'Num. of rows deleted from dtls for intItemNum:' || SQL%ROWCOUNT);
1337: END IF;

Line 1334: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

1330: AND sequence = ICX_CAT_BUILD_CTX_SQL_PVT.g_seqForInternalItemNumRow;
1331:
1332: l_err_loc := 1600;
1333: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1334: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1335: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1336: 'Num. of rows deleted from dtls for intItemNum:' || SQL%ROWCOUNT);
1337: END IF;
1338: ELSIF (p_attribute_key = 'SOURCE') THEN

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

1348: AND language = l_language_tbl(i)
1349: AND sequence = ICX_CAT_BUILD_CTX_SQL_PVT.g_seqForSourceRow;
1350:
1351: l_err_loc := 1800;
1352: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1353: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1354: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1355: 'Num. of rows deleted from dtls for source:' || SQL%ROWCOUNT);
1356: END IF;

Line 1353: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

1349: AND sequence = ICX_CAT_BUILD_CTX_SQL_PVT.g_seqForSourceRow;
1350:
1351: l_err_loc := 1800;
1352: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1353: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1354: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1355: 'Num. of rows deleted from dtls for source:' || SQL%ROWCOUNT);
1356: END IF;
1357: ELSIF (p_attribute_key = 'ITEM_REVISION') THEN

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

1367: AND language = l_language_tbl(i)
1368: AND sequence = ICX_CAT_BUILD_CTX_SQL_PVT.g_seqForItemRevisionRow;
1369:
1370: l_err_loc := 2000;
1371: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1372: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1373: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1374: 'Num. of rows deleted from dtls for itemrev:' || SQL%ROWCOUNT);
1375: END IF;

Line 1372: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

1368: AND sequence = ICX_CAT_BUILD_CTX_SQL_PVT.g_seqForItemRevisionRow;
1369:
1370: l_err_loc := 2000;
1371: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1372: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1373: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1374: 'Num. of rows deleted from dtls for itemrev:' || SQL%ROWCOUNT);
1375: END IF;
1376: ELSIF (p_attribute_key = 'SHOPPING_CATEGORY') THEN

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

1386: AND language = l_language_tbl(i)
1387: AND sequence = ICX_CAT_BUILD_CTX_SQL_PVT.g_seqForShoppingCategoryRow;
1388:
1389: l_err_loc := 2200;
1390: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1391: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1392: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1393: 'Num. of rows deleted from dtls for shopCatg:' || SQL%ROWCOUNT);
1394: END IF;

Line 1391: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

1387: AND sequence = ICX_CAT_BUILD_CTX_SQL_PVT.g_seqForShoppingCategoryRow;
1388:
1389: l_err_loc := 2200;
1390: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1391: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1392: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1393: 'Num. of rows deleted from dtls for shopCatg:' || SQL%ROWCOUNT);
1394: END IF;
1395: ELSE

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

1408: AND language = l_language_tbl(i)
1409: AND sequence BETWEEN l_start_sequence AND l_end_sequence;
1410:
1411: l_err_loc := 2500;
1412: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1413: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1414: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1415: 'Num. of rows deleted from dtls for regular base attrs:' || SQL%ROWCOUNT);
1416: END IF;

Line 1413: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

1409: AND sequence BETWEEN l_start_sequence AND l_end_sequence;
1410:
1411: l_err_loc := 2500;
1412: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1413: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1414: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1415: 'Num. of rows deleted from dtls for regular base attrs:' || SQL%ROWCOUNT);
1416: END IF;
1417: END IF;

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

1431: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
1432: l_err_loc := 2900;
1433: COMMIT;
1434: -- Must log
1435: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1436: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
1437: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1438: 'Commit done.');
1439: END IF;

Line 1436: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

1432: l_err_loc := 2900;
1433: COMMIT;
1434: -- Must log
1435: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1436: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
1437: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1438: 'Commit done.');
1439: END IF;
1440: ELSE

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

1439: END IF;
1440: ELSE
1441: l_err_loc := 3000;
1442: -- Must log
1443: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1444: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
1445: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1446: 'Commit not done.');
1447: END IF;

Line 1444: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

1440: ELSE
1441: l_err_loc := 3000;
1442: -- Must log
1443: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1444: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
1445: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1446: 'Commit not done.');
1447: END IF;
1448: END IF;

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

1472: CLOSE l_csr_var;
1473: END IF;
1474:
1475: l_err_loc := 3600;
1476: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1477: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1478: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1479: 'done.');
1480: END IF;

Line 1477: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

1473: END IF;
1474:
1475: l_err_loc := 3600;
1476: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1477: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1478: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1479: 'done.');
1480: END IF;
1481: EXCEPTION

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

1502: BEGIN
1503: l_err_loc := 100;
1504: l_start_date := sysdate;
1505:
1506: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1507: l_log_string := 'Started at:' || TO_CHAR(l_start_date, 'DD-MON-YYYY HH24:MI:SS') ||
1508: ';(' || p_category_id ||');' ;
1509: ICX_CAT_UTIL_PVT.logProcBegin(g_pkg_name, l_api_name, l_log_string);
1510: END IF;

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

1516: l_err_loc := 200;
1517: populateCtxCatgAtt(l_internal_request_id);
1518:
1519: l_end_date := sysdate;
1520: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1521: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name,
1522: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));
1523: END IF;
1524: EXCEPTION

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

1556:
1557: l_err_loc := 100;
1558: l_start_date := sysdate;
1559:
1560: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1561: l_log_string := 'Started at:' || TO_CHAR(l_start_date, 'DD-MON-YYYY HH24:MI:SS') ||
1562: ';(' || p_attribute_key ||', ' || p_searchable || ');' ;
1563: ICX_CAT_UTIL_PVT.logProcBegin(g_pkg_name, l_api_name, l_log_string);
1564: END IF;

Line 1575: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1571: 'THUMBNAIL_IMAGE', 'PICTURE', 'ATTACHMENT_URL',
1572: 'SUPPLIER_URL', 'MANUFACTURER_URL'))
1573: THEN
1574: l_err_loc := 300;
1575: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1576: FND_LOG.string(FND_LOG.LEVEL_EVENT,
1577: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1578: 'returning; for p_attribute_key:' || p_attribute_key);
1579: END IF;

Line 1576: FND_LOG.string(FND_LOG.LEVEL_EVENT,

1572: 'SUPPLIER_URL', 'MANUFACTURER_URL'))
1573: THEN
1574: l_err_loc := 300;
1575: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1576: FND_LOG.string(FND_LOG.LEVEL_EVENT,
1577: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1578: 'returning; for p_attribute_key:' || p_attribute_key);
1579: END IF;
1580: RETURN;

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

1668: l_special_ctx_sql_tbl);
1669: END IF;
1670: ELSE
1671: l_err_loc := 2500;
1672: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1673: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1674: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1675: 'In else loop for p_attribute_key:' || p_attribute_key);
1676: END IF;

Line 1673: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

1669: END IF;
1670: ELSE
1671: l_err_loc := 2500;
1672: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1673: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1674: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1675: 'In else loop for p_attribute_key:' || p_attribute_key);
1676: END IF;
1677: -- Row with sequence between 101 - 5000

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

1696: END IF;
1697:
1698: l_err_loc := 3000;
1699: l_end_date := sysdate;
1700: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1701: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name,
1702: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));
1703: END IF;
1704: EXCEPTION

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

1724: BEGIN
1725: l_err_loc := 100;
1726: l_start_date := sysdate;
1727:
1728: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1729: l_log_string := 'Started at:' || TO_CHAR(l_start_date, 'DD-MON-YYYY HH24:MI:SS') ;
1730: ICX_CAT_UTIL_PVT.logProcBegin(g_pkg_name, l_api_name, l_log_string);
1731: END IF;
1732:

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

1752: -- Call the rebuild index
1753: ICX_CAT_INTERMEDIA_INDEX_PVT.rebuild_index;
1754:
1755: l_end_date := sysdate;
1756: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1757: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name,
1758: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));
1759: END IF;
1760: EXCEPTION

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

1795: BEGIN
1796: l_err_loc := 100;
1797: l_start_date := sysdate;
1798:
1799: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1800: l_log_string := 'Started at:' || TO_CHAR(l_start_date, 'DD-MON-YYYY HH24:MI:SS') ;
1801: ICX_CAT_UTIL_PVT.logProcBegin(g_pkg_name, l_api_name, l_log_string);
1802: END IF;
1803:

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

1843: LIMIT ICX_CAT_UTIL_PVT.g_batch_size;
1844:
1845: l_err_loc := 900;
1846: EXIT WHEN l_rowid_tbl.COUNT = 0;
1847: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1848: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
1849: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1850: 'Num of rows from ctx_hdrs for category rename:' || l_rowid_tbl.COUNT);
1851: END IF;

Line 1848: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

1844:
1845: l_err_loc := 900;
1846: EXIT WHEN l_rowid_tbl.COUNT = 0;
1847: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1848: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
1849: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1850: 'Num of rows from ctx_hdrs for category rename:' || l_rowid_tbl.COUNT);
1851: END IF;
1852:

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

1865: AND org_id = l_org_id_tbl(i)
1866: AND language = l_language_tbl(i)
1867: AND sequence = ICX_CAT_BUILD_CTX_SQL_PVT.g_seqForShoppingCategoryRow;
1868:
1869: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1870: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1871: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1872: 'Num of rows updated in ctx_dtls for category rename:' || SQL%ROWCOUNT);
1873: END IF;

Line 1870: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

1866: AND language = l_language_tbl(i)
1867: AND sequence = ICX_CAT_BUILD_CTX_SQL_PVT.g_seqForShoppingCategoryRow;
1868:
1869: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1870: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1871: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1872: 'Num of rows updated in ctx_dtls for category rename:' || SQL%ROWCOUNT);
1873: END IF;
1874: ELSE

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

1873: END IF;
1874: ELSE
1875: l_err_loc := 1200;
1876: -- Must log
1877: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1878: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
1879: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1880: 'Shopping Category attribute is not searchable, ' ||
1881: 'so no changes needed in icx_cat_items_ctx_dtls_tlp; ' ||

Line 1878: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

1874: ELSE
1875: l_err_loc := 1200;
1876: -- Must log
1877: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1878: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
1879: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1880: 'Shopping Category attribute is not searchable, ' ||
1881: 'so no changes needed in icx_cat_items_ctx_dtls_tlp; ' ||
1882: 'l_searchable:' || l_searchable || ', l_section_tag:' || l_section_tag );

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

1898: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
1899: l_err_loc := 1500;
1900: COMMIT;
1901: -- Must log
1902: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1903: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
1904: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1905: 'Commit done.');
1906: END IF;

Line 1903: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

1899: l_err_loc := 1500;
1900: COMMIT;
1901: -- Must log
1902: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1903: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
1904: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1905: 'Commit done.');
1906: END IF;
1907: ELSE

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

1906: END IF;
1907: ELSE
1908: l_err_loc := 1600;
1909: -- Must log
1910: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1911: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
1912: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1913: 'Commit not done.');
1914: END IF;

Line 1911: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

1907: ELSE
1908: l_err_loc := 1600;
1909: -- Must log
1910: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1911: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
1912: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1913: 'Commit not done.');
1914: END IF;
1915: END IF;

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

1945: ICX_CAT_INTERMEDIA_INDEX_PVT.rebuild_index;
1946:
1947: l_err_loc := 2300;
1948: l_end_date := sysdate;
1949: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1950: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name,
1951: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));
1952: END IF;
1953: