APPS.ICX_CAT_POPULATE_CATG_GRP dependencies on FND_LOG

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

39:
40: l_err_loc := 300;
41: l_start_date := sysdate;
42:
43: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
44: l_log_string := 'Started at:' || TO_CHAR(l_start_date, 'DD-MON-YYYY HH24:MI:SS') ||
45: ', p_api_version:' || p_api_version ||
46: ', p_commit:' || p_commit ||
47: ', p_dml_type:' || p_dml_type ||

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

72: -- If ICX_CAT_UTIL_PVT.g_validate_flag is 'Y'
73: -- Then ip does not have to process the category added to mtl_categories_b
74: -- This category will be processed when it is added to the valid cats
75: -- in the call to populateValidCategorySetInsert
76: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
77: FND_LOG.string(FND_LOG.LEVEL_EVENT,
78: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
79: 'returning; g_structure_id:' || ICX_CAT_UTIL_PVT.g_structure_id ||
80: ', P_DML_TYPE:' || P_DML_TYPE ||

Line 77: FND_LOG.string(FND_LOG.LEVEL_EVENT,

73: -- Then ip does not have to process the category added to mtl_categories_b
74: -- This category will be processed when it is added to the valid cats
75: -- in the call to populateValidCategorySetInsert
76: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
77: FND_LOG.string(FND_LOG.LEVEL_EVENT,
78: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
79: 'returning; g_structure_id:' || ICX_CAT_UTIL_PVT.g_structure_id ||
80: ', P_DML_TYPE:' || P_DML_TYPE ||
81: ', g_validate_flag:' || ICX_CAT_UTIL_PVT.g_validate_flag );

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

99: COMMIT;
100: l_err_loc := 1300;
101: -- Call the rebuild index
102: ICX_CAT_INTERMEDIA_INDEX_PVT.rebuild_index;
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: 'Rebuild indexes called.');
107: END IF;

Line 104: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

100: l_err_loc := 1300;
101: -- Call the rebuild index
102: ICX_CAT_INTERMEDIA_INDEX_PVT.rebuild_index;
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: 'Rebuild indexes called.');
107: END IF;
108: ELSE

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

106: 'Rebuild indexes called.');
107: END IF;
108: ELSE
109: l_err_loc := 1400;
110: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
111: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
112: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
113: 'p_commit is false, so Rebuild indexes is not called.');
114: END IF;

Line 111: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

107: END IF;
108: ELSE
109: l_err_loc := 1400;
110: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
111: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
112: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
113: 'p_commit is false, so Rebuild indexes is not called.');
114: END IF;
115: END IF;

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

115: END IF;
116:
117: l_err_loc := 1500;
118: l_end_date := sysdate;
119: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
120: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name,
121: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));
122: END IF;
123: EXCEPTION

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

125: BEGIN
126: ROLLBACK TO populateCategoryChange_sp;
127: EXCEPTION
128: WHEN OTHERS THEN
129: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
130: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
131: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
132: 'ROLLBACK TO the savepoint caused the exception -->'
133: || SQLERRM);

Line 130: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

126: ROLLBACK TO populateCategoryChange_sp;
127: EXCEPTION
128: WHEN OTHERS THEN
129: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
130: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
131: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
132: 'ROLLBACK TO the savepoint caused the exception -->'
133: || SQLERRM);
134: END IF;

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

167:
168: l_err_loc := 300;
169: l_start_date := sysdate;
170:
171: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
172: l_log_string := 'Started at:' || TO_CHAR(l_start_date, 'DD-MON-YYYY HH24:MI:SS') ||
173: ', p_api_version:' || p_api_version ||
174: ', p_commit:' || p_commit ||
175: ', p_category_set_id:' || p_category_set_id ||

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

194:
195: l_err_loc := 700;
196: IF (ICX_CAT_UTIL_PVT.g_category_set_id <> P_CATEGORY_SET_ID OR
197: ICX_CAT_UTIL_PVT.g_validate_flag = 'N') THEN
198: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
199: FND_LOG.string(FND_LOG.LEVEL_EVENT,
200: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
201: 'returning; g_category_set_id:' || ICX_CAT_UTIL_PVT.g_category_set_id ||
202: ', g_validate_flag:' || ICX_CAT_UTIL_PVT.g_validate_flag );

Line 199: FND_LOG.string(FND_LOG.LEVEL_EVENT,

195: l_err_loc := 700;
196: IF (ICX_CAT_UTIL_PVT.g_category_set_id <> P_CATEGORY_SET_ID OR
197: ICX_CAT_UTIL_PVT.g_validate_flag = 'N') THEN
198: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
199: FND_LOG.string(FND_LOG.LEVEL_EVENT,
200: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
201: 'returning; g_category_set_id:' || ICX_CAT_UTIL_PVT.g_category_set_id ||
202: ', g_validate_flag:' || ICX_CAT_UTIL_PVT.g_validate_flag );
203: END IF;

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

219: COMMIT;
220: l_err_loc := 1300;
221: -- Call the rebuild index
222: ICX_CAT_INTERMEDIA_INDEX_PVT.rebuild_index;
223: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
224: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
225: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
226: 'Rebuild indexes called.');
227: END IF;

Line 224: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

220: l_err_loc := 1300;
221: -- Call the rebuild index
222: ICX_CAT_INTERMEDIA_INDEX_PVT.rebuild_index;
223: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
224: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
225: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
226: 'Rebuild indexes called.');
227: END IF;
228: ELSE

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

226: 'Rebuild indexes called.');
227: END IF;
228: ELSE
229: l_err_loc := 1400;
230: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
231: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
232: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
233: 'p_commit is false, so Rebuild indexes is not called.');
234: END IF;

Line 231: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

227: END IF;
228: ELSE
229: l_err_loc := 1400;
230: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
231: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
232: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
233: 'p_commit is false, so Rebuild indexes is not called.');
234: END IF;
235: END IF;

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

235: END IF;
236:
237: l_err_loc := 1500;
238: l_end_date := sysdate;
239: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
240: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name,
241: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));
242: END IF;
243: EXCEPTION

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

245: BEGIN
246: ROLLBACK TO popValidCatgSetInsert_sp;
247: EXCEPTION
248: WHEN OTHERS THEN
249: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
250: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
251: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
252: 'ROLLBACK TO the savepoint caused the exception -->'
253: || SQLERRM);

Line 250: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

246: ROLLBACK TO popValidCatgSetInsert_sp;
247: EXCEPTION
248: WHEN OTHERS THEN
249: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
250: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
251: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
252: 'ROLLBACK TO the savepoint caused the exception -->'
253: || SQLERRM);
254: END IF;

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

288:
289: l_err_loc := 300;
290: l_start_date := sysdate;
291:
292: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
293: l_log_string := 'Started at:' || TO_CHAR(l_start_date, 'DD-MON-YYYY HH24:MI:SS') ||
294: ', p_api_version:' || p_api_version ||
295: ', p_commit:' || p_commit ||
296: ', p_category_set_id:' || p_category_set_id ||

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

316:
317: l_err_loc := 700;
318: IF (ICX_CAT_UTIL_PVT.g_category_set_id <> P_CATEGORY_SET_ID OR
319: ICX_CAT_UTIL_PVT.g_validate_flag = 'N') THEN
320: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
321: FND_LOG.string(FND_LOG.LEVEL_EVENT,
322: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
323: 'returning; g_category_set_id:' || ICX_CAT_UTIL_PVT.g_category_set_id ||
324: ', g_validate_flag:' || ICX_CAT_UTIL_PVT.g_validate_flag );

Line 321: FND_LOG.string(FND_LOG.LEVEL_EVENT,

317: l_err_loc := 700;
318: IF (ICX_CAT_UTIL_PVT.g_category_set_id <> P_CATEGORY_SET_ID OR
319: ICX_CAT_UTIL_PVT.g_validate_flag = 'N') THEN
320: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
321: FND_LOG.string(FND_LOG.LEVEL_EVENT,
322: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
323: 'returning; g_category_set_id:' || ICX_CAT_UTIL_PVT.g_category_set_id ||
324: ', g_validate_flag:' || ICX_CAT_UTIL_PVT.g_validate_flag );
325: END IF;

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

341: COMMIT;
342: l_err_loc := 1300;
343: -- Call the rebuild index
344: ICX_CAT_INTERMEDIA_INDEX_PVT.rebuild_index;
345: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
346: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
347: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
348: 'Rebuild indexes called.');
349: END IF;

Line 346: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

342: l_err_loc := 1300;
343: -- Call the rebuild index
344: ICX_CAT_INTERMEDIA_INDEX_PVT.rebuild_index;
345: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
346: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
347: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
348: 'Rebuild indexes called.');
349: END IF;
350: ELSE

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

348: 'Rebuild indexes called.');
349: END IF;
350: ELSE
351: l_err_loc := 1400;
352: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
353: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
354: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
355: 'p_commit is false, so Rebuild indexes is not called.');
356: END IF;

Line 353: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

349: END IF;
350: ELSE
351: l_err_loc := 1400;
352: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
353: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
354: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
355: 'p_commit is false, so Rebuild indexes is not called.');
356: END IF;
357: END IF;

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

357: END IF;
358:
359: l_err_loc := 1500;
360: l_end_date := sysdate;
361: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
362: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name,
363: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));
364: END IF;
365: EXCEPTION

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

367: BEGIN
368: ROLLBACK TO popValidCatgSetUpdate_sp;
369: EXCEPTION
370: WHEN OTHERS THEN
371: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
372: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
373: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
374: 'ROLLBACK TO the savepoint caused the exception -->'
375: || SQLERRM);

Line 372: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

368: ROLLBACK TO popValidCatgSetUpdate_sp;
369: EXCEPTION
370: WHEN OTHERS THEN
371: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
372: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
373: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
374: 'ROLLBACK TO the savepoint caused the exception -->'
375: || SQLERRM);
376: END IF;

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

409:
410: l_err_loc := 300;
411: l_start_date := sysdate;
412:
413: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
414: l_log_string := 'Started at:' || TO_CHAR(l_start_date, 'DD-MON-YYYY HH24:MI:SS') ||
415: ', p_api_version:' || p_api_version ||
416: ', p_commit:' || p_commit ||
417: ', p_category_set_id:' || p_category_set_id ||

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

436:
437: l_err_loc := 700;
438: IF (ICX_CAT_UTIL_PVT.g_category_set_id <> P_CATEGORY_SET_ID OR
439: ICX_CAT_UTIL_PVT.g_validate_flag = 'N') THEN
440: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
441: FND_LOG.string(FND_LOG.LEVEL_EVENT,
442: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
443: 'returning; g_category_set_id:' || ICX_CAT_UTIL_PVT.g_category_set_id ||
444: ', g_validate_flag:' || ICX_CAT_UTIL_PVT.g_validate_flag );

Line 441: FND_LOG.string(FND_LOG.LEVEL_EVENT,

437: l_err_loc := 700;
438: IF (ICX_CAT_UTIL_PVT.g_category_set_id <> P_CATEGORY_SET_ID OR
439: ICX_CAT_UTIL_PVT.g_validate_flag = 'N') THEN
440: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
441: FND_LOG.string(FND_LOG.LEVEL_EVENT,
442: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
443: 'returning; g_category_set_id:' || ICX_CAT_UTIL_PVT.g_category_set_id ||
444: ', g_validate_flag:' || ICX_CAT_UTIL_PVT.g_validate_flag );
445: END IF;

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

462: COMMIT;
463: l_err_loc := 1300;
464: -- Call the rebuild index
465: ICX_CAT_INTERMEDIA_INDEX_PVT.rebuild_index;
466: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
467: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
468: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
469: 'Rebuild indexes called.');
470: END IF;

Line 467: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

463: l_err_loc := 1300;
464: -- Call the rebuild index
465: ICX_CAT_INTERMEDIA_INDEX_PVT.rebuild_index;
466: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
467: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
468: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
469: 'Rebuild indexes called.');
470: END IF;
471: ELSE

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

469: 'Rebuild indexes called.');
470: END IF;
471: ELSE
472: l_err_loc := 1400;
473: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
474: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
475: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
476: 'p_commit is false, so Rebuild indexes is not called.');
477: END IF;

Line 474: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

470: END IF;
471: ELSE
472: l_err_loc := 1400;
473: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
474: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
475: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
476: 'p_commit is false, so Rebuild indexes is not called.');
477: END IF;
478: END IF;

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

478: END IF;
479:
480: l_err_loc := 1500;
481: l_end_date := sysdate;
482: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
483: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name,
484: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));
485: END IF;
486: EXCEPTION

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

488: BEGIN
489: ROLLBACK TO popValidCatgSetDelete_sp;
490: EXCEPTION
491: WHEN OTHERS THEN
492: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
493: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
494: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
495: 'ROLLBACK TO the savepoint caused the exception -->'
496: || SQLERRM);

Line 493: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

489: ROLLBACK TO popValidCatgSetDelete_sp;
490: EXCEPTION
491: WHEN OTHERS THEN
492: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
493: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
494: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
495: 'ROLLBACK TO the savepoint caused the exception -->'
496: || SQLERRM);
497: END IF;