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_CTXSTRING_PVT dependencies on ICX_CAT_UTIL_PVT

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

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:
42: l_err_loc := 200;

Line 54: LIMIT ICX_CAT_UTIL_PVT.g_batch_size;

50:
51: l_err_loc := 400;
52: FETCH l_csr_var
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,

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

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:
63: l_err_loc := 600;

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

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;
82: EXIT;

Line 100: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN

96: l_status := DBMS_SQL.EXECUTE(l_csr_handle);
97: l_err_loc := 1600;
98: DBMS_SQL.CLOSE_CURSOR(l_csr_handle);
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,

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

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
109: l_err_loc := 1900;

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

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

Line 120: EXIT WHEN l_rowid_tbl.COUNT < ICX_CAT_UTIL_PVT.g_batch_size;

116: END IF;
117: END IF;
118:
119: l_err_loc := 2000;
120: EXIT WHEN l_rowid_tbl.COUNT < ICX_CAT_UTIL_PVT.g_batch_size;
121: END LOOP;
122: l_err_loc := 2100;
123: CLOSE l_csr_var;
124:

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

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
132: WHEN OTHERS THEN

Line 133: ICX_CAT_UTIL_PVT.logUnexpectedException(

129: 'done.');
130: END IF;
131: EXCEPTION
132: WHEN OTHERS THEN
133: ICX_CAT_UTIL_PVT.logUnexpectedException(
134: G_PKG_NAME, l_api_name,
135: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
136: RAISE;
137: END popCtxBaseSpecAttForAllSrc;

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

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:
163: l_err_loc := 200;

Line 176: LIMIT ICX_CAT_UTIL_PVT.g_batch_size;

172:
173: l_err_loc := 400;
174: FETCH l_csr_var
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,

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

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:
185: l_err_loc := 600;

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

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;
204: EXIT;

Line 222: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN

218: l_status := DBMS_SQL.EXECUTE(l_csr_handle);
219: l_err_loc := 1600;
220: DBMS_SQL.CLOSE_CURSOR(l_csr_handle);
221: l_err_loc := 1700;
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

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

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
232: l_err_loc := 1900;

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

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

Line 243: EXIT WHEN l_rowid_tbl.COUNT < ICX_CAT_UTIL_PVT.g_batch_size;

239: END IF;
240: END IF;
241:
242: l_err_loc := 2000;
243: EXIT WHEN l_rowid_tbl.COUNT < ICX_CAT_UTIL_PVT.g_batch_size;
244: END LOOP;
245: l_err_loc := 2100;
246: CLOSE l_csr_var;
247:

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

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
255: WHEN OTHERS THEN

Line 256: ICX_CAT_UTIL_PVT.logUnexpectedException(

252: 'done.');
253: END IF;
254: EXCEPTION
255: WHEN OTHERS THEN
256: ICX_CAT_UTIL_PVT.logUnexpectedException(
257: G_PKG_NAME, l_api_name,
258: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
259: RAISE;
260: END popCtxBaseSpecSupplierAtt;

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

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

Line 299: IF (p_doc_source = ICX_CAT_UTIL_PVT.g_PODoc_const) THEN

295: 'Start; p_doc_source:' || p_doc_source ||
296: ', p_repopulate_at_seq:' || p_repopulate_at_seq);
297: END IF;
298:
299: IF (p_doc_source = ICX_CAT_UTIL_PVT.g_PODoc_const) THEN
300: l_err_loc := 200;
301: l_source_type1 := 'BLANKET';
302: l_source_type2 := 'QUOTATION';
303: ELSIF (p_doc_source = ICX_CAT_UTIL_PVT.g_ReqTemplateCsr_const) THEN

Line 303: ELSIF (p_doc_source = ICX_CAT_UTIL_PVT.g_ReqTemplateCsr_const) THEN

299: IF (p_doc_source = ICX_CAT_UTIL_PVT.g_PODoc_const) THEN
300: l_err_loc := 200;
301: l_source_type1 := 'BLANKET';
302: l_source_type2 := 'QUOTATION';
303: ELSIF (p_doc_source = ICX_CAT_UTIL_PVT.g_ReqTemplateCsr_const) THEN
304: l_err_loc := 300;
305: l_source_type1 := 'TEMPLATE';
306: l_source_type2 := 'INTERNAL_TEMPLATE';
307: END IF;

Line 324: LIMIT ICX_CAT_UTIL_PVT.g_batch_size;

320:
321: l_err_loc := 800;
322: FETCH l_csr_var
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,

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

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:
333: l_err_loc := 1000;

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

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;
351: EXIT;

Line 369: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN

365: l_status := DBMS_SQL.EXECUTE(l_csr_handle);
366: l_err_loc := 1900;
367: DBMS_SQL.CLOSE_CURSOR(l_csr_handle);
368: l_err_loc := 2000;
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

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

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
379: l_err_loc := 2200;

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

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

Line 390: EXIT WHEN l_rowid_tbl.COUNT < ICX_CAT_UTIL_PVT.g_batch_size;

386: END IF;
387: END IF;
388:
389: l_err_loc := 2300;
390: EXIT WHEN l_rowid_tbl.COUNT < ICX_CAT_UTIL_PVT.g_batch_size;
391: END LOOP;
392: l_err_loc := 2400;
393: CLOSE l_csr_var;
394:

Line 396: IF (p_doc_source = ICX_CAT_UTIL_PVT.g_PODoc_const) THEN

392: l_err_loc := 2400;
393: CLOSE l_csr_var;
394:
395: l_err_loc := 2500;
396: IF (p_doc_source = ICX_CAT_UTIL_PVT.g_PODoc_const) THEN
397: l_err_loc := 2600;
398: INSERT INTO icx_cat_items_ctx_dtls_tlp
399: (inventory_item_id, po_line_id, req_template_name,
400: req_template_line_num, org_id, language,

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

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:
426: l_err_loc := 2800;

Line 427: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN

423: 'Num. of rows inserted for ga:' || SQL%ROWCOUNT);
424: END IF;
425:
426: l_err_loc := 2800;
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

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

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
437: l_err_loc := 3000;

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

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

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

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
454: WHEN OTHERS THEN

Line 455: ICX_CAT_UTIL_PVT.logUnexpectedException(

451: 'done.');
452: END IF;
453: EXCEPTION
454: WHEN OTHERS THEN
455: ICX_CAT_UTIL_PVT.logUnexpectedException(
456: G_PKG_NAME, l_api_name,
457: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
458: RAISE;
459: END popCtxBaseSpecSrcAndItemRevAtt;

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

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:
486: IF (p_doc_source = ICX_CAT_UTIL_PVT.g_PODoc_const) THEN

Line 486: IF (p_doc_source = ICX_CAT_UTIL_PVT.g_PODoc_const) THEN

482: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
483: 'Start; p_doc_source:' || p_doc_source);
484: END IF;
485:
486: IF (p_doc_source = ICX_CAT_UTIL_PVT.g_PODoc_const) THEN
487: l_err_loc := 200;
488: OPEN l_csr_var FOR
489: SELECT ROWID
490: FROM icx_cat_items_ctx_hdrs_tlp

Line 508: LIMIT ICX_CAT_UTIL_PVT.g_batch_size;

504:
505: l_err_loc := 600;
506: FETCH l_csr_var
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,

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

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

Line 540: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN

536: DBMS_SQL.CLOSE_CURSOR(l_csr_handle);
537: END LOOP;
538:
539: l_err_loc := 1600;
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

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

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
550: l_err_loc := 1800;

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

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

Line 560: EXIT WHEN l_rowid_tbl.COUNT < ICX_CAT_UTIL_PVT.g_batch_size;

556: END IF;
557: END IF;
558:
559: l_err_loc := 1900;
560: EXIT WHEN l_rowid_tbl.COUNT < ICX_CAT_UTIL_PVT.g_batch_size;
561: END LOOP;
562: l_err_loc := 2000;
563: CLOSE l_csr_var;
564:

Line 566: IF (p_doc_source = ICX_CAT_UTIL_PVT.g_PODoc_const) THEN

562: l_err_loc := 2000;
563: CLOSE l_csr_var;
564:
565: l_err_loc := 2100;
566: IF (p_doc_source = ICX_CAT_UTIL_PVT.g_PODoc_const) THEN
567: l_err_loc := 2200;
568: INSERT INTO icx_cat_items_ctx_dtls_tlp
569: (inventory_item_id, po_line_id, req_template_name,
570: req_template_line_num, org_id, language,

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

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:
597: l_err_loc := 2400;

Line 598: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN

594: 'Num. of rows inserted for ga:' || SQL%ROWCOUNT);
595: END IF;
596:
597: l_err_loc := 2400;
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

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

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
608: l_err_loc := 2600;

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

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

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

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
625: WHEN OTHERS THEN

Line 626: ICX_CAT_UTIL_PVT.logUnexpectedException(

622: 'done.');
623: END IF;
624: EXCEPTION
625: WHEN OTHERS THEN
626: ICX_CAT_UTIL_PVT.logUnexpectedException(
627: G_PKG_NAME, l_api_name,
628: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
629: RAISE;
630: END popCtxBaseRegularAttributes;

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

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

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

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 );
690:

Line 695: IF (p_doc_source = ICX_CAT_UTIL_PVT.g_PODoc_const) THEN

691: END LOOP;
692: END IF;
693:
694: l_err_loc := 700;
695: IF (p_doc_source = ICX_CAT_UTIL_PVT.g_PODoc_const) THEN
696: l_err_loc := 800;
697: l_source_type1 := 'BLANKET';
698: l_source_type2 := 'QUOTATION';
699: ELSIF (p_doc_source = ICX_CAT_UTIL_PVT.g_ReqTemplateCsr_const) THEN

Line 699: ELSIF (p_doc_source = ICX_CAT_UTIL_PVT.g_ReqTemplateCsr_const) THEN

695: IF (p_doc_source = ICX_CAT_UTIL_PVT.g_PODoc_const) THEN
696: l_err_loc := 800;
697: l_source_type1 := 'BLANKET';
698: l_source_type2 := 'QUOTATION';
699: ELSIF (p_doc_source = ICX_CAT_UTIL_PVT.g_ReqTemplateCsr_const) THEN
700: l_err_loc := 900;
701: l_source_type1 := 'TEMPLATE';
702: l_source_type2 := 'INTERNAL_TEMPLATE';
703: ELSE

Line 720: l_source_type_tbl, l_rowid_tbl LIMIT ICX_CAT_UTIL_PVT.g_batch_size;

716: l_source_type_tbl.DELETE;
717:
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),

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

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:
728: l_err_loc := 1700;

Line 749: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN

745: DBMS_SQL.CLOSE_CURSOR(l_csr_handle);
746: END LOOP;
747:
748: l_err_loc := 2500;
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

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

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
759: l_err_loc := 2700;

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

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

Line 769: EXIT WHEN l_rowid_tbl.COUNT < ICX_CAT_UTIL_PVT.g_batch_size;

765: END IF;
766: END IF;
767:
768: l_err_loc := 2800;
769: EXIT WHEN l_rowid_tbl.COUNT < ICX_CAT_UTIL_PVT.g_batch_size;
770: END LOOP;
771: l_err_loc := 2900;
772: CLOSE getItemRowsCsr;
773:

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

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

Line 783: ICX_CAT_UTIL_PVT.logUnexpectedException(

779: END IF;
780:
781: EXCEPTION
782: WHEN OTHERS THEN
783: ICX_CAT_UTIL_PVT.logUnexpectedException(
784: G_PKG_NAME, l_api_name,
785: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
786: RAISE;
787: END populateCtxBaseAtt;

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

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

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

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:
854: l_err_loc := 300;

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

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 );
880: END LOOP;

Line 891: FETCH getItemRowsCsr BULK COLLECT INTO l_rowid_tbl LIMIT ICX_CAT_UTIL_PVT.g_batch_size;

887: LOOP
888: l_err_loc := 1400;
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),

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

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:
899: l_err_loc := 1700;

Line 920: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN

916: DBMS_SQL.CLOSE_CURSOR(l_csr_handle);
917: END LOOP; -- l_all_ctx_sql_tbl LOOP
918:
919: l_err_loc := 2500;
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

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

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
930: l_err_loc := 2700;

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

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

Line 940: EXIT WHEN l_rowid_tbl.COUNT < ICX_CAT_UTIL_PVT.g_batch_size;

936: END IF;
937: END IF;
938:
939: l_err_loc := 2800;
940: EXIT WHEN l_rowid_tbl.COUNT < ICX_CAT_UTIL_PVT.g_batch_size;
941: END LOOP; -- getItemRowsCsr LOOP
942:
943: l_err_loc := 2900;
944: CLOSE getItemRowsCsr;

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

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:
984: l_err_loc := 3300;

Line 985: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN

981: 'Num. of rows inserted for ga:' || SQL%ROWCOUNT);
982: END IF;
983:
984: l_err_loc := 3300;
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

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

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
995: l_err_loc := 3500;

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

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

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

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

Line 1009: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));

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:
1012: EXCEPTION
1013: WHEN OTHERS THEN

Line 1014: ICX_CAT_UTIL_PVT.logUnexpectedException(

1010: END IF;
1011:
1012: EXCEPTION
1013: WHEN OTHERS THEN
1014: ICX_CAT_UTIL_PVT.logUnexpectedException(
1015: G_PKG_NAME, l_api_name,
1016: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
1017: RAISE;
1018: END populateCtxCatgAtt;

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

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:
1038: l_err_loc := 150;

Line 1045: FETCH getItemRowsCsr BULK COLLECT INTO l_rowid_tbl LIMIT ICX_CAT_UTIL_PVT.g_batch_size;

1041: l_err_loc := 200;
1042: l_rowid_tbl.DELETE;
1043:
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,

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

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:
1054: l_err_loc := 500;

Line 1099: EXIT WHEN l_rowid_tbl.COUNT < ICX_CAT_UTIL_PVT.g_batch_size;

1095: FROM icx_cat_items_ctx_hdrs_tlp hdrs
1096: WHERE hdrs.rowid = l_rowid_tbl(i);
1097:
1098: l_err_loc := 1000;
1099: EXIT WHEN l_rowid_tbl.COUNT < ICX_CAT_UTIL_PVT.g_batch_size;
1100: END LOOP;
1101:
1102: l_err_loc := 1100;
1103: CLOSE getItemRowsCsr;

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

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

Line 1114: ICX_CAT_UTIL_PVT.logUnexpectedException(

1110: END IF;
1111:
1112: EXCEPTION
1113: WHEN OTHERS THEN
1114: ICX_CAT_UTIL_PVT.logUnexpectedException(
1115: G_PKG_NAME, l_api_name,
1116: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
1117: RAISE;
1118: END populateCtxOrgInfo;

Line 1126: ICX_CAT_UTIL_PVT.g_PODoc_const VARCHAR2(15) := 'PO_DOCUMENTS';

1122: The calling procedure should make sure to remove all the dtls for the source and internal_request_id
1123: Commenting out for the moment
1124:
1125: Values of p_doc_source:
1126: ICX_CAT_UTIL_PVT.g_PODoc_const VARCHAR2(15) := 'PO_DOCUMENTS';
1127: ICX_CAT_UTIL_PVT.g_ReqTemplateCsr_const VARCHAR2(15) := 'ReqTemplate';
1128: ICX_CAT_UTIL_PVT.g_MasterItemCsr_const VARCHAR2(15) := 'MASTER_ITEM';
1129: Values of p_mode:
1130: ICX_CAT_UTIL_PVT.g_upgrade_const VARCHAR2(15) := 'UPGRADE';

Line 1127: ICX_CAT_UTIL_PVT.g_ReqTemplateCsr_const VARCHAR2(15) := 'ReqTemplate';

1123: Commenting out for the moment
1124:
1125: Values of p_doc_source:
1126: ICX_CAT_UTIL_PVT.g_PODoc_const VARCHAR2(15) := 'PO_DOCUMENTS';
1127: ICX_CAT_UTIL_PVT.g_ReqTemplateCsr_const VARCHAR2(15) := 'ReqTemplate';
1128: ICX_CAT_UTIL_PVT.g_MasterItemCsr_const VARCHAR2(15) := 'MASTER_ITEM';
1129: Values of p_mode:
1130: ICX_CAT_UTIL_PVT.g_upgrade_const VARCHAR2(15) := 'UPGRADE';
1131: ICX_CAT_UTIL_PVT.g_online_const VARCHAR2(15) := 'ONLINE';

Line 1128: ICX_CAT_UTIL_PVT.g_MasterItemCsr_const VARCHAR2(15) := 'MASTER_ITEM';

1124:
1125: Values of p_doc_source:
1126: ICX_CAT_UTIL_PVT.g_PODoc_const VARCHAR2(15) := 'PO_DOCUMENTS';
1127: ICX_CAT_UTIL_PVT.g_ReqTemplateCsr_const VARCHAR2(15) := 'ReqTemplate';
1128: ICX_CAT_UTIL_PVT.g_MasterItemCsr_const VARCHAR2(15) := 'MASTER_ITEM';
1129: Values of p_mode:
1130: ICX_CAT_UTIL_PVT.g_upgrade_const VARCHAR2(15) := 'UPGRADE';
1131: ICX_CAT_UTIL_PVT.g_online_const VARCHAR2(15) := 'ONLINE';
1132: exec ICX_CAT_POPULATE_CTXSTRING_PVT.populateCtxString(ICX_CAT_UTIL_PVT.g_PODoc_const, -12, 'UPG', 2500)

Line 1130: ICX_CAT_UTIL_PVT.g_upgrade_const VARCHAR2(15) := 'UPGRADE';

1126: ICX_CAT_UTIL_PVT.g_PODoc_const VARCHAR2(15) := 'PO_DOCUMENTS';
1127: ICX_CAT_UTIL_PVT.g_ReqTemplateCsr_const VARCHAR2(15) := 'ReqTemplate';
1128: ICX_CAT_UTIL_PVT.g_MasterItemCsr_const VARCHAR2(15) := 'MASTER_ITEM';
1129: Values of p_mode:
1130: ICX_CAT_UTIL_PVT.g_upgrade_const VARCHAR2(15) := 'UPGRADE';
1131: ICX_CAT_UTIL_PVT.g_online_const VARCHAR2(15) := 'ONLINE';
1132: exec ICX_CAT_POPULATE_CTXSTRING_PVT.populateCtxString(ICX_CAT_UTIL_PVT.g_PODoc_const, -12, 'UPG', 2500)
1133: PROCEDURE populateCtxString
1134: ( p_doc_source IN VARCHAR2 ,

Line 1131: ICX_CAT_UTIL_PVT.g_online_const VARCHAR2(15) := 'ONLINE';

1127: ICX_CAT_UTIL_PVT.g_ReqTemplateCsr_const VARCHAR2(15) := 'ReqTemplate';
1128: ICX_CAT_UTIL_PVT.g_MasterItemCsr_const VARCHAR2(15) := 'MASTER_ITEM';
1129: Values of p_mode:
1130: ICX_CAT_UTIL_PVT.g_upgrade_const VARCHAR2(15) := 'UPGRADE';
1131: ICX_CAT_UTIL_PVT.g_online_const VARCHAR2(15) := 'ONLINE';
1132: exec ICX_CAT_POPULATE_CTXSTRING_PVT.populateCtxString(ICX_CAT_UTIL_PVT.g_PODoc_const, -12, 'UPG', 2500)
1133: PROCEDURE populateCtxString
1134: ( p_doc_source IN VARCHAR2 ,
1135: p_internal_request_id IN NUMBER ,

Line 1132: exec ICX_CAT_POPULATE_CTXSTRING_PVT.populateCtxString(ICX_CAT_UTIL_PVT.g_PODoc_const, -12, 'UPG', 2500)

1128: ICX_CAT_UTIL_PVT.g_MasterItemCsr_const VARCHAR2(15) := 'MASTER_ITEM';
1129: Values of p_mode:
1130: ICX_CAT_UTIL_PVT.g_upgrade_const VARCHAR2(15) := 'UPGRADE';
1131: ICX_CAT_UTIL_PVT.g_online_const VARCHAR2(15) := 'ONLINE';
1132: exec ICX_CAT_POPULATE_CTXSTRING_PVT.populateCtxString(ICX_CAT_UTIL_PVT.g_PODoc_const, -12, 'UPG', 2500)
1133: PROCEDURE populateCtxString
1134: ( p_doc_source IN VARCHAR2 ,
1135: p_internal_request_id IN NUMBER ,
1136: p_mode IN VARCHAR2 ,

Line 1154: ICX_CAT_UTIL_PVT.logProcBegin(g_pkg_name, l_api_name, l_log_string);

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:
1157: l_err_loc := 200;
1158: ICX_CAT_UTIL_PVT.setBatchSize(p_batch_size);

Line 1158: ICX_CAT_UTIL_PVT.setBatchSize(p_batch_size);

1154: ICX_CAT_UTIL_PVT.logProcBegin(g_pkg_name, l_api_name, l_log_string);
1155: END IF;
1156:
1157: l_err_loc := 200;
1158: ICX_CAT_UTIL_PVT.setBatchSize(p_batch_size);
1159:
1160: l_err_loc := 300;
1161: populateCtxBaseAtt(p_doc_source, p_internal_request_id);
1162:

Line 1167: --So, call populateCtxCatgAtt when doc source <> ICX_CAT_UTIL_PVT.g_MasterItem_const

1163: l_err_loc := 400;
1164: populateCtxOrgInfo(p_internal_request_id);
1165:
1166: --Since there is no way to load the category attributes for a master item
1167: --So, call populateCtxCatgAtt when doc source <> ICX_CAT_UTIL_PVT.g_MasterItem_const
1168: l_err_loc := 500;
1169: IF (p_doc_source <> ICX_CAT_UTIL_PVT.g_MasterItemCsr_const) THEN
1170: populateCtxCatgAtt(p_internal_request_id);
1171: END IF;

Line 1169: IF (p_doc_source <> ICX_CAT_UTIL_PVT.g_MasterItemCsr_const) THEN

1165:
1166: --Since there is no way to load the category attributes for a master item
1167: --So, call populateCtxCatgAtt when doc source <> ICX_CAT_UTIL_PVT.g_MasterItem_const
1168: l_err_loc := 500;
1169: IF (p_doc_source <> ICX_CAT_UTIL_PVT.g_MasterItemCsr_const) THEN
1170: populateCtxCatgAtt(p_internal_request_id);
1171: END IF;
1172: l_err_loc := 600;
1173: l_end_date := sysdate;

Line 1175: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name,

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

Line 1176: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));

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:
1179: EXCEPTION
1180: WHEN OTHERS THEN

Line 1181: ICX_CAT_UTIL_PVT.logUnexpectedException(

1177: END IF;
1178:
1179: EXCEPTION
1180: WHEN OTHERS THEN
1181: ICX_CAT_UTIL_PVT.logUnexpectedException(
1182: G_PKG_NAME, l_api_name,
1183: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
1184: ROLLBACK;
1185: RAISE;

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

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
1219: -- otherwise only update row with ip_category_id = p_category_id

Line 1221: l_internal_request_id := ICX_CAT_UTIL_PVT.getNextSequenceForWhoColumns;

1217: END IF;
1218: -- Update ctx_desc and internal_request_id for all items if ip_category_id = 0 in hdrs tlp
1219: -- otherwise only update row with ip_category_id = p_category_id
1220: -- Return internal_request_id
1221: l_internal_request_id := ICX_CAT_UTIL_PVT.getNextSequenceForWhoColumns;
1222: p_internal_request_id := l_internal_request_id;
1223: l_err_loc := 200;
1224: OPEN l_csr_var FOR
1225: SELECT ROWID, po_line_id, inventory_item_id,

Line 1247: LIMIT ICX_CAT_UTIL_PVT.g_batch_size;

1243: FETCH l_csr_var
1244: BULK COLLECT INTO l_rowid_tbl, l_po_line_id_tbl, l_inventory_item_id_tbl,
1245: l_req_template_name_tbl, l_req_template_line_num_tbl,
1246: l_org_id_tbl, l_language_tbl
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

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

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:
1257: l_err_loc := 600;

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

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
1280: l_err_loc := 1000;

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

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
1301: l_err_loc := 1300;

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

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
1320: l_err_loc := 1500;

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

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
1339: l_err_loc := 1700;

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

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
1358: l_err_loc := 1900;

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

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
1377: l_err_loc := 2100;

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

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
1396: l_err_loc := 2300;

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

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

Line 1431: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN

1427: internal_request_id = l_internal_request_id
1428: WHERE rowid = l_rowid_tbl(i);
1429:
1430: l_err_loc := 2800;
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

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

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
1441: l_err_loc := 3000;

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

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

Line 1451: EXIT WHEN l_rowid_tbl.COUNT < ICX_CAT_UTIL_PVT.g_batch_size;

1447: END IF;
1448: END IF;
1449:
1450: l_err_loc := 3100;
1451: EXIT WHEN l_rowid_tbl.COUNT < ICX_CAT_UTIL_PVT.g_batch_size;
1452: EXCEPTION
1453: WHEN ICX_CAT_UTIL_PVT.g_snap_shot_too_old THEN
1454: l_err_string := 'ICX_CAT_POPULATE_CTXSTRING_PVT.updateItemsCtxHdrsTlp' ||l_err_loc;
1455: ICX_CAT_UTIL_PVT.logAndCommitSnapShotTooOld(g_pkg_name, l_api_name, l_err_string);

Line 1453: WHEN ICX_CAT_UTIL_PVT.g_snap_shot_too_old THEN

1449:
1450: l_err_loc := 3100;
1451: EXIT WHEN l_rowid_tbl.COUNT < ICX_CAT_UTIL_PVT.g_batch_size;
1452: EXCEPTION
1453: WHEN ICX_CAT_UTIL_PVT.g_snap_shot_too_old THEN
1454: l_err_string := 'ICX_CAT_POPULATE_CTXSTRING_PVT.updateItemsCtxHdrsTlp' ||l_err_loc;
1455: ICX_CAT_UTIL_PVT.logAndCommitSnapShotTooOld(g_pkg_name, l_api_name, l_err_string);
1456: l_err_loc := 3200;
1457: CLOSE l_csr_var;

Line 1455: ICX_CAT_UTIL_PVT.logAndCommitSnapShotTooOld(g_pkg_name, l_api_name, l_err_string);

1451: EXIT WHEN l_rowid_tbl.COUNT < ICX_CAT_UTIL_PVT.g_batch_size;
1452: EXCEPTION
1453: WHEN ICX_CAT_UTIL_PVT.g_snap_shot_too_old THEN
1454: l_err_string := 'ICX_CAT_POPULATE_CTXSTRING_PVT.updateItemsCtxHdrsTlp' ||l_err_loc;
1455: ICX_CAT_UTIL_PVT.logAndCommitSnapShotTooOld(g_pkg_name, l_api_name, l_err_string);
1456: l_err_loc := 3200;
1457: CLOSE l_csr_var;
1458: l_err_loc := 3300;
1459: OPEN l_csr_var FOR

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

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
1482: WHEN OTHERS THEN

Line 1483: ICX_CAT_UTIL_PVT.logUnexpectedException(

1479: 'done.');
1480: END IF;
1481: EXCEPTION
1482: WHEN OTHERS THEN
1483: ICX_CAT_UTIL_PVT.logUnexpectedException(
1484: G_PKG_NAME, l_api_name,
1485: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
1486: IF (l_csr_var%ISOPEN) THEN
1487: CLOSE l_csr_var;

Line 1509: ICX_CAT_UTIL_PVT.logProcBegin(g_pkg_name, l_api_name, l_log_string);

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;
1511:
1512: -- Update ctx_desc and internal_request_id for all items with ip_category_id = p_category_id in hdrs tlp
1513: -- Delete all rows between 5001 and 9999 for items that has ip_category_id = p_category_id

Line 1521: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name,

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
1525: WHEN OTHERS THEN

Line 1522: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));

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
1525: WHEN OTHERS THEN
1526: ICX_CAT_UTIL_PVT.logUnexpectedException(

Line 1526: ICX_CAT_UTIL_PVT.logUnexpectedException(

1522: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));
1523: END IF;
1524: EXCEPTION
1525: WHEN OTHERS THEN
1526: ICX_CAT_UTIL_PVT.logUnexpectedException(
1527: G_PKG_NAME, l_api_name,
1528: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
1529: RAISE;
1530: END rePopulateCategoryAttributes;

Line 1563: ICX_CAT_UTIL_PVT.logProcBegin(g_pkg_name, l_api_name, l_log_string);

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;
1565:
1566: -- If the changed descriptor is one of the following, then just return no processing is needed
1567: l_err_loc := 200;

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

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

Line 1596: (0, ICX_CAT_UTIL_PVT.g_PODoc_const, 'ROWID', l_special_metadata_tbl,

1592: (0, l_special_metadata_tbl, l_regular_nontl_metadata_tbl, l_regular_tl_metadata_tbl);
1593:
1594: l_err_loc := 600;
1595: ICX_CAT_BUILD_CTX_SQL_PVT.buildCtxSql
1596: (0, ICX_CAT_UTIL_PVT.g_PODoc_const, 'ROWID', l_special_metadata_tbl,
1597: l_regular_nontl_metadata_tbl, l_regular_tl_metadata_tbl,
1598: l_all_ctx_sql_tbl, l_special_ctx_sql_tbl, l_regular_ctx_sql_tbl);
1599:
1600: l_err_loc := 700;

Line 1629: popCtxBaseSpecSrcAndItemRevAtt(ICX_CAT_UTIL_PVT.g_PODoc_const,

1625: l_err_loc := 1200;
1626: -- Row with sequence 4 (source) and 5 (Item Revision)
1627: IF (p_attribute_key = 'SOURCE') THEN
1628: l_err_loc := 1300;
1629: popCtxBaseSpecSrcAndItemRevAtt(ICX_CAT_UTIL_PVT.g_PODoc_const,
1630: l_special_ctx_sql_tbl,
1631: ICX_CAT_BUILD_CTX_SQL_PVT.g_seqForSourceRow);
1632: ELSE
1633: l_err_loc := 1400;

Line 1634: popCtxBaseSpecSrcAndItemRevAtt(ICX_CAT_UTIL_PVT.g_PODoc_const,

1630: l_special_ctx_sql_tbl,
1631: ICX_CAT_BUILD_CTX_SQL_PVT.g_seqForSourceRow);
1632: ELSE
1633: l_err_loc := 1400;
1634: popCtxBaseSpecSrcAndItemRevAtt(ICX_CAT_UTIL_PVT.g_PODoc_const,
1635: l_special_ctx_sql_tbl,
1636: ICX_CAT_BUILD_CTX_SQL_PVT.g_seqForItemRevisionRow);
1637: END IF;
1638:

Line 1647: (0, ICX_CAT_UTIL_PVT.g_ReqTemplateCsr_const, 'ROWID', l_special_metadata_tbl,

1643:
1644: l_err_loc := 1600;
1645: -- Build the ctx sqls for Req templates.
1646: ICX_CAT_BUILD_CTX_SQL_PVT.buildCtxSql
1647: (0, ICX_CAT_UTIL_PVT.g_ReqTemplateCsr_const, 'ROWID', l_special_metadata_tbl,
1648: l_regular_nontl_metadata_tbl, l_regular_tl_metadata_tbl,
1649: l_all_ctx_sql_tbl, l_special_ctx_sql_tbl, l_regular_ctx_sql_tbl);
1650: l_err_loc := 1700;
1651: IF (p_attribute_key = 'SOURCE') THEN

Line 1653: popCtxBaseSpecSrcAndItemRevAtt(ICX_CAT_UTIL_PVT.g_ReqTemplateCsr_const,

1649: l_all_ctx_sql_tbl, l_special_ctx_sql_tbl, l_regular_ctx_sql_tbl);
1650: l_err_loc := 1700;
1651: IF (p_attribute_key = 'SOURCE') THEN
1652: l_err_loc := 1800;
1653: popCtxBaseSpecSrcAndItemRevAtt(ICX_CAT_UTIL_PVT.g_ReqTemplateCsr_const,
1654: l_special_ctx_sql_tbl,
1655: ICX_CAT_BUILD_CTX_SQL_PVT.g_seqForSourceRow);
1656: ELSE
1657: l_err_loc := 1900;

Line 1658: popCtxBaseSpecSrcAndItemRevAtt(ICX_CAT_UTIL_PVT.g_ReqTemplateCsr_const,

1654: l_special_ctx_sql_tbl,
1655: ICX_CAT_BUILD_CTX_SQL_PVT.g_seqForSourceRow);
1656: ELSE
1657: l_err_loc := 1900;
1658: popCtxBaseSpecSrcAndItemRevAtt(ICX_CAT_UTIL_PVT.g_ReqTemplateCsr_const,
1659: l_special_ctx_sql_tbl,
1660: ICX_CAT_BUILD_CTX_SQL_PVT.g_seqForItemRevisionRow);
1661: END IF;
1662:

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

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
1678: l_err_loc := 2600;

Line 1679: popCtxBaseRegularAttributes(ICX_CAT_UTIL_PVT.g_PODoc_const,

1675: 'In else loop for p_attribute_key:' || p_attribute_key);
1676: END IF;
1677: -- Row with sequence between 101 - 5000
1678: l_err_loc := 2600;
1679: popCtxBaseRegularAttributes(ICX_CAT_UTIL_PVT.g_PODoc_const,
1680: l_regular_ctx_sql_tbl);
1681:
1682: l_err_loc := 2700;
1683: l_all_ctx_sql_tbl.DELETE;

Line 1690: (0, ICX_CAT_UTIL_PVT.g_MasterItemCsr_const, 'ROWID', l_special_metadata_tbl,

1686:
1687: l_err_loc := 2800;
1688: -- Build the ctx_sql_table for Master Items
1689: ICX_CAT_BUILD_CTX_SQL_PVT.buildCtxSql
1690: (0, ICX_CAT_UTIL_PVT.g_MasterItemCsr_const, 'ROWID', l_special_metadata_tbl,
1691: l_regular_nontl_metadata_tbl, l_regular_tl_metadata_tbl,
1692: l_all_ctx_sql_tbl, l_special_ctx_sql_tbl, l_regular_ctx_sql_tbl);
1693: l_err_loc := 2900;
1694: popCtxBaseRegularAttributes(ICX_CAT_UTIL_PVT.g_MasterItemCsr_const,

Line 1694: popCtxBaseRegularAttributes(ICX_CAT_UTIL_PVT.g_MasterItemCsr_const,

1690: (0, ICX_CAT_UTIL_PVT.g_MasterItemCsr_const, 'ROWID', l_special_metadata_tbl,
1691: l_regular_nontl_metadata_tbl, l_regular_tl_metadata_tbl,
1692: l_all_ctx_sql_tbl, l_special_ctx_sql_tbl, l_regular_ctx_sql_tbl);
1693: l_err_loc := 2900;
1694: popCtxBaseRegularAttributes(ICX_CAT_UTIL_PVT.g_MasterItemCsr_const,
1695: l_regular_ctx_sql_tbl);
1696: END IF;
1697:
1698: l_err_loc := 3000;

Line 1701: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name,

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
1705: WHEN OTHERS THEN

Line 1702: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));

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
1705: WHEN OTHERS THEN
1706: ICX_CAT_UTIL_PVT.logUnexpectedException(

Line 1706: ICX_CAT_UTIL_PVT.logUnexpectedException(

1702: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));
1703: END IF;
1704: EXCEPTION
1705: WHEN OTHERS THEN
1706: ICX_CAT_UTIL_PVT.logUnexpectedException(
1707: G_PKG_NAME, l_api_name,
1708: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
1709: RAISE;
1710: END rePopulateBaseAttributes;

Line 1730: ICX_CAT_UTIL_PVT.logProcBegin(g_pkg_name, l_api_name, l_log_string);

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:
1733: l_err_loc := 200;
1734: ICX_CAT_UTIL_PVT.setBatchSize;

Line 1734: ICX_CAT_UTIL_PVT.setBatchSize;

1730: ICX_CAT_UTIL_PVT.logProcBegin(g_pkg_name, l_api_name, l_log_string);
1731: END IF;
1732:
1733: l_err_loc := 200;
1734: ICX_CAT_UTIL_PVT.setBatchSize;
1735:
1736: l_err_loc := 300;
1737: ICX_CAT_UTIL_PVT.setCommitParameter(FND_API.G_TRUE);
1738:

Line 1737: ICX_CAT_UTIL_PVT.setCommitParameter(FND_API.G_TRUE);

1733: l_err_loc := 200;
1734: ICX_CAT_UTIL_PVT.setBatchSize;
1735:
1736: l_err_loc := 300;
1737: ICX_CAT_UTIL_PVT.setCommitParameter(FND_API.G_TRUE);
1738:
1739: l_err_loc := 400;
1740: IF (p_category_id = 0) THEN
1741: l_err_loc := 500;

Line 1757: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name,

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
1761: WHEN OTHERS THEN

Line 1758: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));

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
1761: WHEN OTHERS THEN
1762: ICX_CAT_UTIL_PVT.logUnexpectedException(

Line 1762: ICX_CAT_UTIL_PVT.logUnexpectedException(

1758: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));
1759: END IF;
1760: EXCEPTION
1761: WHEN OTHERS THEN
1762: ICX_CAT_UTIL_PVT.logUnexpectedException(
1763: G_PKG_NAME, l_api_name,
1764: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
1765: ROLLBACK;
1766: -- Call the rebuild index

Line 1801: ICX_CAT_UTIL_PVT.logProcBegin(g_pkg_name, l_api_name, l_log_string);

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:
1804: l_err_loc := 200;
1805: ICX_CAT_UTIL_PVT.setBatchSize;

Line 1805: ICX_CAT_UTIL_PVT.setBatchSize;

1801: ICX_CAT_UTIL_PVT.logProcBegin(g_pkg_name, l_api_name, l_log_string);
1802: END IF;
1803:
1804: l_err_loc := 200;
1805: ICX_CAT_UTIL_PVT.setBatchSize;
1806:
1807: l_err_loc := 300;
1808: ICX_CAT_UTIL_PVT.setCommitParameter(FND_API.G_TRUE);
1809:

Line 1808: ICX_CAT_UTIL_PVT.setCommitParameter(FND_API.G_TRUE);

1804: l_err_loc := 200;
1805: ICX_CAT_UTIL_PVT.setBatchSize;
1806:
1807: l_err_loc := 300;
1808: ICX_CAT_UTIL_PVT.setCommitParameter(FND_API.G_TRUE);
1809:
1810: l_err_loc := 400;
1811: -- Update ctx_desc and internal_request_id for all items belonging to p_category_id and p_language in hdrs tlp
1812: l_internal_request_id := ICX_CAT_UTIL_PVT.getNextSequenceForWhoColumns;

Line 1812: l_internal_request_id := ICX_CAT_UTIL_PVT.getNextSequenceForWhoColumns;

1808: ICX_CAT_UTIL_PVT.setCommitParameter(FND_API.G_TRUE);
1809:
1810: l_err_loc := 400;
1811: -- Update ctx_desc and internal_request_id for all items belonging to p_category_id and p_language in hdrs tlp
1812: l_internal_request_id := ICX_CAT_UTIL_PVT.getNextSequenceForWhoColumns;
1813:
1814: l_err_loc := 500;
1815: ICX_CAT_BUILD_CTX_SQL_PVT.checkIfAttributeIsSrchble
1816: ('SHOPPING_CATEGORY', l_searchable, l_section_tag);

Line 1843: LIMIT ICX_CAT_UTIL_PVT.g_batch_size;

1839: FETCH l_csr_var
1840: BULK COLLECT INTO l_rowid_tbl, l_po_line_id_tbl, l_inventory_item_id_tbl,
1841: l_req_template_name_tbl, l_req_template_line_num_tbl,
1842: l_org_id_tbl, l_language_tbl
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

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

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:
1853: l_err_loc := 1000;

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

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
1875: l_err_loc := 1200;

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

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

Line 1898: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN

1894: internal_request_id = l_internal_request_id
1895: WHERE rowid = l_rowid_tbl(i);
1896:
1897: l_err_loc := 1400;
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

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

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
1908: l_err_loc := 1600;

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

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

Line 1918: EXIT WHEN l_rowid_tbl.COUNT < ICX_CAT_UTIL_PVT.g_batch_size;

1914: END IF;
1915: END IF;
1916:
1917: l_err_loc := 1700;
1918: EXIT WHEN l_rowid_tbl.COUNT < ICX_CAT_UTIL_PVT.g_batch_size;
1919: EXCEPTION
1920: WHEN ICX_CAT_UTIL_PVT.g_snap_shot_too_old THEN
1921: l_err_string := 'ICX_CAT_POPULATE_CTXSTRING_PVT.handleCategoryRename' ||l_err_loc;
1922: ICX_CAT_UTIL_PVT.logAndCommitSnapShotTooOld(g_pkg_name, l_api_name, l_err_string);

Line 1920: WHEN ICX_CAT_UTIL_PVT.g_snap_shot_too_old THEN

1916:
1917: l_err_loc := 1700;
1918: EXIT WHEN l_rowid_tbl.COUNT < ICX_CAT_UTIL_PVT.g_batch_size;
1919: EXCEPTION
1920: WHEN ICX_CAT_UTIL_PVT.g_snap_shot_too_old THEN
1921: l_err_string := 'ICX_CAT_POPULATE_CTXSTRING_PVT.handleCategoryRename' ||l_err_loc;
1922: ICX_CAT_UTIL_PVT.logAndCommitSnapShotTooOld(g_pkg_name, l_api_name, l_err_string);
1923: l_err_loc := 1800;
1924: CLOSE l_csr_var;

Line 1922: ICX_CAT_UTIL_PVT.logAndCommitSnapShotTooOld(g_pkg_name, l_api_name, l_err_string);

1918: EXIT WHEN l_rowid_tbl.COUNT < ICX_CAT_UTIL_PVT.g_batch_size;
1919: EXCEPTION
1920: WHEN ICX_CAT_UTIL_PVT.g_snap_shot_too_old THEN
1921: l_err_string := 'ICX_CAT_POPULATE_CTXSTRING_PVT.handleCategoryRename' ||l_err_loc;
1922: ICX_CAT_UTIL_PVT.logAndCommitSnapShotTooOld(g_pkg_name, l_api_name, l_err_string);
1923: l_err_loc := 1800;
1924: CLOSE l_csr_var;
1925: l_err_loc := 1900;
1926: OPEN l_csr_var FOR

Line 1950: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name,

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

Line 1951: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));

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:
1954: EXCEPTION
1955: WHEN OTHERS THEN

Line 1956: ICX_CAT_UTIL_PVT.logUnexpectedException(

1952: END IF;
1953:
1954: EXCEPTION
1955: WHEN OTHERS THEN
1956: ICX_CAT_UTIL_PVT.logUnexpectedException(
1957: G_PKG_NAME, l_api_name,
1958: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
1959: ROLLBACK;
1960: -- Call the rebuild index