eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ICX_CAT_R12_DATA_EXCEP_RPT_PVT dependencies on FND_LOG

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

40: BEGIN
41:
42: l_start_date := sysdate;
43:
44: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
45: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
46: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_proc_name),
47: 'Started at:' || TO_CHAR(l_start_date, 'DD-MON-YYYY HH24:MI:SS'));
48: END IF;

Line 45: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

41:
42: l_start_date := sysdate;
43:
44: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
45: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
46: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_proc_name),
47: 'Started at:' || TO_CHAR(l_start_date, 'DD-MON-YYYY HH24:MI:SS'));
48: END IF;
49:

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

51:
52: --Data removed from data migration tables
53: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_icx_schema_name||'.ICX_CAT_R12_UPG_EXCEP_FILES';
54:
55: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
56: l_log_string := 'ICX_CAT_R12_DATA_EXCEP_RPT_PVT.cleanup_tables deleting data
57: from icx_cat_r12_upg_error_msgs';
58: l_module_name := ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name,l_proc_name);
59: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, l_module_name, l_log_string);

Line 59: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, l_module_name, l_log_string);

55: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
56: l_log_string := 'ICX_CAT_R12_DATA_EXCEP_RPT_PVT.cleanup_tables deleting data
57: from icx_cat_r12_upg_error_msgs';
58: l_module_name := ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name,l_proc_name);
59: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, l_module_name, l_log_string);
60: END IF;
61:
62: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_icx_schema_name||'.ICX_CAT_R12_UPG_ERROR_MSGS';
63:

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

62: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_icx_schema_name||'.ICX_CAT_R12_UPG_ERROR_MSGS';
63:
64: l_end_date := sysdate;
65:
66: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
67: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
68: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_proc_name),
69: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));
70: END IF;

Line 67: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

63:
64: l_end_date := sysdate;
65:
66: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
67: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
68: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_proc_name),
69: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));
70: END IF;
71: END;

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

88:
89: BEGIN
90: l_progress := 100;
91:
92: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
93: l_log_string := 'ICX_CAT_R12_DATA_EXCEP_RPT_PVT.populate_language_map started :--> '||
94: 'l_progress:' ||l_progress;
95: l_module_name := ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name,l_proc_name);
96: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_module_name, l_log_string);

Line 96: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_module_name, l_log_string);

92: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
93: l_log_string := 'ICX_CAT_R12_DATA_EXCEP_RPT_PVT.populate_language_map started :--> '||
94: 'l_progress:' ||l_progress;
95: l_module_name := ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name,l_proc_name);
96: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_module_name, l_log_string);
97: END IF;
98:
99: -- Populating the territories list for each language
100: -- This list is used while populating the Catalog XML File

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

111:
112: FOR i in 1..l_language_code_tbl.COUNT
113: LOOP
114:
115: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
116: l_log_string := 'populate_language_map: language code'||l_language_code_tbl(i)||
117: 'iso territory' || l_iso_territory_tbl(i)||
118: 'iso language'|| l_iso_language_tbl(i)||
119: 'nls territory' || l_nls_territory_tbl(i)||

Line 123: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module_name, l_log_string);

119: 'nls territory' || l_nls_territory_tbl(i)||
120: 'nls language' || l_nls_language_tbl(i)||
121: 'l_progress:' ||l_progress;
122: l_module_name := ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name,l_proc_name);
123: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module_name, l_log_string);
124: END IF;
125:
126: g_territories(l_language_code_tbl(i)).iso_territory := l_iso_territory_tbl(i);
127: g_territories(l_language_code_tbl(i)).iso_language := l_iso_language_tbl(i);

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

129: g_territories(l_language_code_tbl(i)).nls_language := l_nls_language_tbl(i);
130:
131: END LOOP;
132:
133: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
134: l_log_string := 'ICX_CAT_R12_DATA_EXCEP_RPT_PVT.populate_language_map completed :--> '||
135: 'l_progress:' ||l_progress;
136: l_module_name := ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name,l_proc_name);
137: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_module_name, l_log_string);

Line 137: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_module_name, l_log_string);

133: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
134: l_log_string := 'ICX_CAT_R12_DATA_EXCEP_RPT_PVT.populate_language_map completed :--> '||
135: 'l_progress:' ||l_progress;
136: l_module_name := ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name,l_proc_name);
137: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_module_name, l_log_string);
138: END IF;
139:
140: END;
141:

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

193: l_progress := 100;
194:
195: l_start_date := sysdate;
196:
197: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
198: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
199: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_proc_name),
200: 'Started at:' || TO_CHAR(l_start_date, 'DD-MON-YYYY HH24:MI:SS') ||
201: 'Parameters: p_batch_id:' || p_batch_id);

Line 198: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

194:
195: l_start_date := sysdate;
196:
197: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
198: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
199: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_proc_name),
200: 'Started at:' || TO_CHAR(l_start_date, 'DD-MON-YYYY HH24:MI:SS') ||
201: 'Parameters: p_batch_id:' || p_batch_id);
202: END IF;

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

216: l_progress := 104;
217: -- Prepare the attributes list for 0 category id
218: populate_namevalue_xmltag(0);
219:
220: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
221: l_log_string := 'process_data_exceptions_report :'||'Processing exceptions report for Batch Id : '
222: ||p_batch_id||'l_progress:' ||l_progress;
223: l_module_name := ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name,l_proc_name);
224: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module_name, l_log_string);

Line 224: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module_name, l_log_string);

220: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
221: l_log_string := 'process_data_exceptions_report :'||'Processing exceptions report for Batch Id : '
222: ||p_batch_id||'l_progress:' ||l_progress;
223: l_module_name := ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name,l_proc_name);
224: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module_name, l_log_string);
225: END IF;
226:
227: l_progress := 110;
228: OPEN interface_headers_cursor(p_batch_id);

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

292: WHEN ICX_CAT_UTIL_PVT.g_snap_shot_too_old THEN
293: -- delete the data for which the xml file is not
294: -- yet generated. So that these lines can be
295: -- retrieved again
296: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
297: l_log_string := 'process_data_exceptions_report : Snapshot too old encountered'||
298: 'Deleting data from ICX_CAT_R12_UPG_EXCEP_FILES table'||
299: 'l_progress:' ||l_progress ||' '||SQLERRM;
300: l_module_name := ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name,l_proc_name);

Line 301: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION, l_module_name, l_log_string);

297: l_log_string := 'process_data_exceptions_report : Snapshot too old encountered'||
298: 'Deleting data from ICX_CAT_R12_UPG_EXCEP_FILES table'||
299: 'l_progress:' ||l_progress ||' '||SQLERRM;
300: l_module_name := ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name,l_proc_name);
301: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION, l_module_name, l_log_string);
302: END IF;
303: DELETE FROM icx_cat_r12_upg_excep_files
304: WHERE file_name is null;
305: COMMIT;

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

316: END IF;
317:
318: l_end_date := sysdate;
319:
320: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
321: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
322: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_proc_name),
323: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));
324: END IF;

Line 321: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

317:
318: l_end_date := sysdate;
319:
320: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
321: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
322: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_proc_name),
323: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));
324: END IF;
325:

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

394: l_progress := 100;
395:
396: l_start_date := sysdate;
397:
398: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
399: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
400: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_proc_name),
401: 'Started at:' || TO_CHAR(l_start_date, 'DD-MON-YYYY HH24:MI:SS'));
402: END IF;

Line 399: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

395:
396: l_start_date := sysdate;
397:
398: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
399: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
400: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_proc_name),
401: 'Started at:' || TO_CHAR(l_start_date, 'DD-MON-YYYY HH24:MI:SS'));
402: END IF;
403: l_table_count := p_interface_header_id_tbl.COUNT;

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

405: WHILE headers_index <= l_table_count LOOP
406: l_interface_header_id := p_interface_header_id_tbl(headers_index);
407: l_language := p_language_tbl(headers_index);
408:
409: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
410: l_log_string := 'populate_catalog_files; '||' interface header id '|| l_interface_header_id
411: ||'Session Alter to nls language'||g_territories(l_language).nls_language
412: ||'and nls territory'|| g_territories(l_language).nls_territory;
413: l_module_name := ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name,l_proc_name);

Line 414: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module_name, l_log_string);

410: l_log_string := 'populate_catalog_files; '||' interface header id '|| l_interface_header_id
411: ||'Session Alter to nls language'||g_territories(l_language).nls_language
412: ||'and nls territory'|| g_territories(l_language).nls_territory;
413: l_module_name := ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name,l_proc_name);
414: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module_name, l_log_string);
415: END IF;
416:
417: EXECUTE IMMEDIATE 'ALTER SESSION SET NLS_LANGUAGE = '''|| g_territories(l_language).nls_language ||'''';
418: EXECUTE IMMEDIATE 'ALTER SESSION SET NLS_TERRITORY ='''|| g_territories(l_language).nls_territory||'''';

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

446: FOR category_index in 1..l_ip_category_id_tbl.COUNT
447: LOOP
448: l_ip_category_id := l_ip_category_id_tbl(category_index);
449:
450: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
451: l_log_string := 'populate_catalog_files; '||' category id '|| l_ip_category_id;
452: l_module_name := ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name,l_proc_name);
453: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module_name, l_log_string);
454: END IF;

Line 453: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module_name, l_log_string);

449:
450: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
451: l_log_string := 'populate_catalog_files; '||' category id '|| l_ip_category_id;
452: l_module_name := ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name,l_proc_name);
453: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module_name, l_log_string);
454: END IF;
455:
456: l_progress := 170;
457: -- Generate Lines section for the lines that have the category id

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

477: -- if current language is same as the language in the PL/SQL Table
478: -- then update the current row
479: l_progress := 200;
480:
481: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
482: l_log_string := 'populate_catalog_files : updating existing rows';
483: l_module_name := ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name,l_proc_name);
484: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module_name, l_log_string);
485: END IF;

Line 484: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module_name, l_log_string);

480:
481: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
482: l_log_string := 'populate_catalog_files : updating existing rows';
483: l_module_name := ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name,l_proc_name);
484: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module_name, l_log_string);
485: END IF;
486: --update the table
487:
488: UPDATE icx_cat_r12_upg_excep_files

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

495: END LOOP; -- end of interface header ids for loop
496:
497: l_end_date := sysdate;
498:
499: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
500: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
501: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_proc_name),
502: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));
503: END IF;

Line 500: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

496:
497: l_end_date := sysdate;
498:
499: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
500: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
501: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_proc_name),
502: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));
503: END IF;
504:

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

552: l_progress :=100;
553:
554: l_start_date := sysdate;
555:
556: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
557: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
558: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_proc_name),
559: 'Started at:' || TO_CHAR(l_start_date, 'DD-MON-YYYY HH24:MI:SS'));
560: END IF;

Line 557: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

553:
554: l_start_date := sysdate;
555:
556: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
557: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
558: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_proc_name),
559: 'Started at:' || TO_CHAR(l_start_date, 'DD-MON-YYYY HH24:MI:SS'));
560: END IF;
561:

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

565: l_interface_header_id := p_interface_header_id_tbl(header_id_index);
566:
567: IF (l_interface_header_id <> l_prev_interface_header_id) THEN
568:
569: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
570: l_log_string := 'populate_upg_error_msgs:'||'Inserting messages for interface header id'
571: ||l_interface_header_id|| 'l_progress:' ||l_progress;
572: l_module_name := ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name,l_proc_name);
573: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, l_module_name, l_log_string);

Line 573: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, l_module_name, l_log_string);

569: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
570: l_log_string := 'populate_upg_error_msgs:'||'Inserting messages for interface header id'
571: ||l_interface_header_id|| 'l_progress:' ||l_progress;
572: l_module_name := ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name,l_proc_name);
573: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, l_module_name, l_log_string);
574: END IF;
575:
576: OPEN interface_errors_cursor(p_interface_header_id_tbl(header_id_index));
577: LOOP

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

613: END LOOP;
614:
615: l_end_date := sysdate;
616:
617: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
618: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
619: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_proc_name),
620: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));
621: END IF;

Line 618: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

614:
615: l_end_date := sysdate;
616:
617: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
618: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
619: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_proc_name),
620: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));
621: END IF;
622:

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

653: l_progress := 100;
654:
655: l_start_date := sysdate;
656:
657: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
658: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
659: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_proc_name),
660: 'Started at:' || TO_CHAR(l_start_date, 'DD-MON-YYYY HH24:MI:SS') ||
661: 'Parameters: p_interface_header_id:' || p_interface_header_id);

Line 658: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

654:
655: l_start_date := sysdate;
656:
657: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
658: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
659: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_proc_name),
660: 'Started at:' || TO_CHAR(l_start_date, 'DD-MON-YYYY HH24:MI:SS') ||
661: 'Parameters: p_interface_header_id:' || p_interface_header_id);
662: END IF;

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

684: AND pohi.org_id = hro.organization_id (+)
685: AND pohi.vendor_id = pv.vendor_id (+)
686: AND pohi.vendor_site_id = pvs.vendor_site_id (+)';
687:
688: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
689: l_log_string := 'generate_lines_section:'||'Binding parameters :interface header id'
690: ||p_interface_header_id;
691: l_module_name := ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name,l_proc_name);
692: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module_name, l_log_string);

Line 692: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module_name, l_log_string);

688: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
689: l_log_string := 'generate_lines_section:'||'Binding parameters :interface header id'
690: ||p_interface_header_id;
691: l_module_name := ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name,l_proc_name);
692: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module_name, l_log_string);
693: END IF;
694:
695: -- Set the bind parameter values
696: l_params := xml_bind_params(null);

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

701: x_header_XML := get_xml(l_qryString, l_params);
702:
703: l_end_date := sysdate;
704:
705: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
706: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
707: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_proc_name),
708: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));
709: END IF;

Line 706: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

702:
703: l_end_date := sysdate;
704:
705: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
706: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
707: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_proc_name),
708: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));
709: END IF;
710:

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

747: BEGIN
748:
749: l_start_date := sysdate;
750:
751: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
752: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
753: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_proc_name),
754: 'Started at:' || TO_CHAR(l_start_date, 'DD-MON-YYYY HH24:MI:SS') ||
755: 'Parameters: p_interface_header_id:' || p_interface_header_id||

Line 752: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

748:
749: l_start_date := sysdate;
750:
751: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
752: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
753: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_proc_name),
754: 'Started at:' || TO_CHAR(l_start_date, 'DD-MON-YYYY HH24:MI:SS') ||
755: 'Parameters: p_interface_header_id:' || p_interface_header_id||
756: ',p_category_id'|| p_category_id||

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

771: l_attr_list := g_descriptors_list(p_category_id);
772: END IF;
773: EXCEPTION
774: when no_data_found then
775: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
776: l_log_string := 'generate_lines_section:'||'No data found in g_descriptors_list'||
777: 'Invoking populate_namevalue_xmltag for category id'||p_category_id;
778: l_module_name := ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_proc_name);
779: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION, l_module_name, l_log_string);

Line 779: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION, l_module_name, l_log_string);

775: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
776: l_log_string := 'generate_lines_section:'||'No data found in g_descriptors_list'||
777: 'Invoking populate_namevalue_xmltag for category id'||p_category_id;
778: l_module_name := ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_proc_name);
779: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION, l_module_name, l_log_string);
780: END IF;
781: populate_namevalue_xmltag(p_category_id);
782: l_attr_list := g_descriptors_list(p_category_id);
783: END;

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

789: FROM icx_cat_categories_tl icat
790: WHERE icat.rt_category_id = p_category_id;
791: EXCEPTION
792: when no_data_found then
793: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
794: l_log_string := 'generate_lines_section:'||'No data found in icx_cat_categories_tl'||
795: 'Assigning '' '' to shopping category for category id :'||p_category_id;
796: l_module_name := ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_proc_name);
797: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION, l_module_name, l_log_string);

Line 797: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION, l_module_name, l_log_string);

793: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
794: l_log_string := 'generate_lines_section:'||'No data found in icx_cat_categories_tl'||
795: 'Assigning '' '' to shopping category for category id :'||p_category_id;
796: l_module_name := ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_proc_name);
797: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION, l_module_name, l_log_string);
798: END IF;
799: l_shopping_category := ' ';
800: END;
801:

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

834: AND (poie.interface_line_id IS NULL OR
835: poie.interface_line_id = poli.interface_line_id))';
836:
837:
838: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
839: l_log_string := 'generate_lines_section:'||'Binding parameters :interface header id'
840: ||p_interface_header_id||', IP CATEGORY ID:'|| p_category_id
841: ||', LANGUAGE'|| p_language ||', SHOPPING CATEGORY' || l_shopping_category;
842: l_module_name := ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name,l_proc_name);

Line 843: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, l_module_name, l_log_string);

839: l_log_string := 'generate_lines_section:'||'Binding parameters :interface header id'
840: ||p_interface_header_id||', IP CATEGORY ID:'|| p_category_id
841: ||', LANGUAGE'|| p_language ||', SHOPPING CATEGORY' || l_shopping_category;
842: l_module_name := ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name,l_proc_name);
843: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, l_module_name, l_log_string);
844: END IF;
845:
846: -- Set the bind parameter values
847: l_params := xml_bind_params(null, null, null, null);

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

879: END IF;
880:
881: l_end_date := sysdate;
882:
883: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
884: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
885: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_proc_name),
886: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));
887: END IF;

Line 884: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

880:
881: l_end_date := sysdate;
882:
883: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
884: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
885: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_proc_name),
886: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));
887: END IF;
888:

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

920: l_proc_name varchar2(100) := 'get_xml';
921: BEGIN
922: l_progress := 100;
923: l_start_date := sysdate;
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_proc_name),
927: 'Started at:' || TO_CHAR(l_start_date, 'DD-MON-YYYY HH24:MI:SS'));
928: END IF;

Line 925: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

921: BEGIN
922: l_progress := 100;
923: l_start_date := sysdate;
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_proc_name),
927: 'Started at:' || TO_CHAR(l_start_date, 'DD-MON-YYYY HH24:MI:SS'));
928: END IF;
929: -- Set the bind parameters

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

942:
943: DBMS_XMLGEN.setNullHandling(l_qryctx, DBMS_XMLGEN.EMPTY_TAG);
944: DBMS_XMLGEN.setConvertSpecialChars(l_qryctx, TRUE);
945:
946: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
947: l_log_string := 'get_xml: Invoking XMLgen for XML generation';
948: l_module_name := ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name,l_proc_name);
949: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module_name, l_log_string);
950: END IF;

Line 949: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module_name, l_log_string);

945:
946: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
947: l_log_string := 'get_xml: Invoking XMLgen for XML generation';
948: l_module_name := ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name,l_proc_name);
949: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module_name, l_log_string);
950: END IF;
951:
952: l_progress := 120;
953: x_result:=DBMS_XMLGEN.getXML(l_qryctx);

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

959: return x_result;
960:
961: l_end_date := sysdate;
962:
963: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
964: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
965: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_proc_name),
966: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));
967: END IF;

Line 964: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

960:
961: l_end_date := sysdate;
962:
963: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
964: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
965: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_proc_name),
966: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));
967: END IF;
968:

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

1003: l_progress := 100;
1004:
1005: l_start_date := sysdate;
1006:
1007: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1008: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
1009: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_proc_name),
1010: 'Started at:' || TO_CHAR(l_start_date, 'DD-MON-YYYY HH24:MI:SS'));
1011: END IF;

Line 1008: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

1004:
1005: l_start_date := sysdate;
1006:
1007: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1008: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
1009: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_proc_name),
1010: 'Started at:' || TO_CHAR(l_start_date, 'DD-MON-YYYY HH24:MI:SS'));
1011: END IF;
1012:

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

1024: AND stored_in_column is not null;
1025:
1026: l_progress := 110;
1027:
1028: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1029: l_log_string := 'populate_namevalue_xmltag: Concatenating values to generate XML Query String';
1030: l_module_name := ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name,l_proc_name);
1031: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module_name, l_log_string);
1032: END IF;

Line 1031: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module_name, l_log_string);

1027:
1028: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1029: l_log_string := 'populate_namevalue_xmltag: Concatenating values to generate XML Query String';
1030: l_module_name := ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name,l_proc_name);
1031: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module_name, l_log_string);
1032: END IF;
1033:
1034: IF (l_descriptors_tbl.COUNT = 0) THEN
1035: l_attr_list := ' ';

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

1057: g_descriptors_list(p_category_id) := l_attr_list;
1058:
1059: l_end_date := sysdate;
1060:
1061: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1062: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
1063: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_proc_name),
1064: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));
1065: END IF;

Line 1062: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

1058:
1059: l_end_date := sysdate;
1060:
1061: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1062: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
1063: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_proc_name),
1064: ' done in:' || ICX_CAT_UTIL_PVT.getTimeStats(l_start_date, l_end_date));
1065: END IF;
1066:

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

1099:
1100: BEGIN
1101: l_progress := 110;
1102:
1103: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1104: l_log_string := 'ICX_CAT_R12_DATA_EXCEP_RPT_PVT.replace_clob started:-->'||
1105: 'l_progress:' ||l_progress;
1106: l_module_name := ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name,l_proc_name);
1107: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_module_name, l_log_string);

Line 1107: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_module_name, l_log_string);

1103: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1104: l_log_string := 'ICX_CAT_R12_DATA_EXCEP_RPT_PVT.replace_clob started:-->'||
1105: 'l_progress:' ||l_progress;
1106: l_module_name := ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name,l_proc_name);
1107: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_module_name, l_log_string);
1108: END IF;
1109:
1110: IF (dbms_lob.getlength(p_src_clob) > 0 and length(p_replace_with) > 0)THEN
1111: dbms_lob.createtemporary(x_result, false);

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

1169: END IF;
1170: dbms_lob.freetemporary(x_result);
1171: END IF;
1172:
1173: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1174: l_log_string := 'ICX_CAT_R12_DATA_EXCEP_RPT_PVT.replace_clob completed:-->'||
1175: 'l_progress:' ||l_progress;
1176: l_module_name := ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name,l_proc_name);
1177: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_module_name, l_log_string);

Line 1177: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_module_name, l_log_string);

1173: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1174: l_log_string := 'ICX_CAT_R12_DATA_EXCEP_RPT_PVT.replace_clob completed:-->'||
1175: 'l_progress:' ||l_progress;
1176: l_module_name := ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name,l_proc_name);
1177: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_module_name, l_log_string);
1178: END IF;
1179:
1180: EXCEPTION
1181: WHEN OTHERS THEN