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 ICX_CAT_UTIL_PVT

Line 46: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_proc_name),

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:
50: l_icx_schema_name := ICX_CAT_UTIL_PVT.getIcxSchemaName;

Line 50: l_icx_schema_name := ICX_CAT_UTIL_PVT.getIcxSchemaName;

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:
50: l_icx_schema_name := ICX_CAT_UTIL_PVT.getIcxSchemaName;
51:
52: --Data removed from data migration tables
53: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_icx_schema_name||'.ICX_CAT_R12_UPG_EXCEP_FILES';
54:

Line 58: l_module_name := ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name,l_proc_name);

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);
60: END IF;
61:
62: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_icx_schema_name||'.ICX_CAT_R12_UPG_ERROR_MSGS';

Line 68: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_proc_name),

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

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

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;
72:
73: /**

Line 95: l_module_name := ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name,l_proc_name);

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);
97: END IF;
98:
99: -- Populating the territories list for each language

Line 122: l_module_name := ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name,l_proc_name);

118: 'iso language'|| l_iso_language_tbl(i)||
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);

Line 136: l_module_name := ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name,l_proc_name);

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);
138: END IF;
139:
140: END;

Line 199: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_proc_name),

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

Line 205: IF (ICX_CAT_UTIL_PVT.g_batch_size IS NULL) THEN

201: 'Parameters: p_batch_id:' || p_batch_id);
202: END IF;
203:
204: -- Set Batch Size if null
205: IF (ICX_CAT_UTIL_PVT.g_batch_size IS NULL) THEN
206: ICX_CAT_UTIL_PVT.setBatchSize();
207: END IF;
208:
209: -- clear the data from the upgrade tables

Line 206: ICX_CAT_UTIL_PVT.setBatchSize();

202: END IF;
203:
204: -- Set Batch Size if null
205: IF (ICX_CAT_UTIL_PVT.g_batch_size IS NULL) THEN
206: ICX_CAT_UTIL_PVT.setBatchSize();
207: END IF;
208:
209: -- clear the data from the upgrade tables
210: cleanup_tables;

Line 223: l_module_name := ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name,l_proc_name);

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);
225: END IF;
226:
227: l_progress := 110;

Line 246: LIMIT ICX_CAT_UTIL_PVT.g_batch_size;

242: l_org_id_tbl,
243: l_currency_code_tbl,
244: l_contract_num_tbl,
245: l_language_tbl
246: LIMIT ICX_CAT_UTIL_PVT.g_batch_size;
247: EXIT WHEN l_interface_header_id_tbl.COUNT = 0;
248:
249: BEGIN
250: -- Inserting the data into Upgrade Exceptions File Table

Line 292: WHEN ICX_CAT_UTIL_PVT.g_snap_shot_too_old THEN

288: l_language_tbl);
289:
290: COMMIT;
291: EXCEPTION
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

Line 300: l_module_name := ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name,l_proc_name);

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

Line 322: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_proc_name),

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

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

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:
326: EXCEPTION
327: WHEN OTHERS THEN

Line 328: ICX_CAT_UTIL_PVT.logUnexpectedException(

324: END IF;
325:
326: EXCEPTION
327: WHEN OTHERS THEN
328: ICX_CAT_UTIL_PVT.logUnexpectedException(
329: g_pkg_name, l_proc_name,' --> l_progress:' ||l_progress||' '|| SQLERRM);
330: RAISE;
331: END process_data_exceptions_report;
332:

Line 400: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_proc_name),

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;
404: -- iterate through the interface headers in the PL/SQL table

Line 413: l_module_name := ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name,l_proc_name);

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);
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 ||'''';

Line 439: LIMIT ICX_CAT_UTIL_PVT.g_batch_size;

435: LOOP
436: l_ip_category_id_tbl.DELETE;
437: FETCH category_ids_cursor BULK COLLECT INTO
438: l_ip_category_id_tbl
439: LIMIT ICX_CAT_UTIL_PVT.g_batch_size;
440:
441: l_progress := 150;
442: EXIT when l_ip_category_id_tbl.COUNT=0;
443:

Line 452: l_module_name := ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name,l_proc_name);

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;
455:
456: l_progress := 170;

Line 483: l_module_name := ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name,l_proc_name);

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;
486: --update the table
487:

Line 501: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_proc_name),

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

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

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:
505: EXCEPTION
506: WHEN OTHERS THEN

Line 507: ICX_CAT_UTIL_PVT.logUnexpectedException(

503: END IF;
504:
505: EXCEPTION
506: WHEN OTHERS THEN
507: ICX_CAT_UTIL_PVT.logUnexpectedException(
508: g_pkg_name, l_proc_name,' --> l_progress:' ||l_progress||' '|| SQLERRM);
509: RAISE;
510: END populate_catalog_files;
511:

Line 558: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_proc_name),

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:
562: FOR header_id_index IN 1..p_interface_header_id_tbl.COUNT

Line 572: l_module_name := ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name,l_proc_name);

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);
574: END IF;
575:
576: OPEN interface_errors_cursor(p_interface_header_id_tbl(header_id_index));

Line 581: LIMIT ICX_CAT_UTIL_PVT.g_batch_size;

577: LOOP
578: FETCH interface_errors_cursor BULK COLLECT INTO
579: l_po_msg_tbl,
580: l_column_value_tbl
581: LIMIT ICX_CAT_UTIL_PVT.g_batch_size;
582:
583: l_progress := 110;
584: EXIT WHEN l_po_msg_tbl.COUNT = 0;
585:

Line 619: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_proc_name),

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

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

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:
623: EXCEPTION
624: WHEN OTHERS THEN

Line 625: ICX_CAT_UTIL_PVT.logUnexpectedException(

621: END IF;
622:
623: EXCEPTION
624: WHEN OTHERS THEN
625: ICX_CAT_UTIL_PVT.logUnexpectedException(
626: g_pkg_name, l_proc_name,' --> l_progress:' ||l_progress||' '|| SQLERRM);
627: RAISE;
628: END populate_upg_error_msgs;
629:

Line 659: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_proc_name),

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

Line 691: l_module_name := ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name,l_proc_name);

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);
693: END IF;
694:
695: -- Set the bind parameter values

Line 707: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_proc_name),

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

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

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:
711: EXCEPTION
712: WHEN OTHERS THEN

Line 713: ICX_CAT_UTIL_PVT.logUnexpectedException(

709: END IF;
710:
711: EXCEPTION
712: WHEN OTHERS THEN
713: ICX_CAT_UTIL_PVT.logUnexpectedException(
714: g_pkg_name, l_proc_name,' --> l_progress:' ||l_progress||' '|| SQLERRM);
715: RAISE;
716: END generate_header_section;
717:

Line 753: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_proc_name),

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||
757: ',p_language'||p_language);

Line 778: l_module_name := ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_proc_name);

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);
780: END IF;
781: populate_namevalue_xmltag(p_category_id);
782: l_attr_list := g_descriptors_list(p_category_id);

Line 796: l_module_name := ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_proc_name);

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);
798: END IF;
799: l_shopping_category := ' ';
800: END;

Line 842: l_module_name := ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name,l_proc_name);

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);
843: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, l_module_name, l_log_string);
844: END IF;
845:
846: -- Set the bind parameter values

Line 885: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_proc_name),

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

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

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:
889: EXCEPTION
890: WHEN OTHERS THEN

Line 891: ICX_CAT_UTIL_PVT.logUnexpectedException(

887: END IF;
888:
889: EXCEPTION
890: WHEN OTHERS THEN
891: ICX_CAT_UTIL_PVT.logUnexpectedException(
892: g_pkg_name, l_proc_name,' --> l_progress:' ||l_progress||' '|| SQLERRM);
893: RAISE;
894: END generate_lines_section;
895:

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

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
930: l_qryctx := DBMS_XMLGEN.newcontext(p_qryString);

Line 948: l_module_name := ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name,l_proc_name);

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;
951:
952: l_progress := 120;

Line 965: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_proc_name),

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

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

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:
969: EXCEPTION
970: WHEN OTHERS THEN

Line 971: ICX_CAT_UTIL_PVT.logUnexpectedException(

967: END IF;
968:
969: EXCEPTION
970: WHEN OTHERS THEN
971: ICX_CAT_UTIL_PVT.logUnexpectedException(
972: g_pkg_name, l_proc_name,' --> l_progress:' ||l_progress||' '|| SQLERRM);
973: RAISE;
974: END get_xml;
975:

Line 1009: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_proc_name),

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:
1013: -- Query to select the attributes of a category

Line 1030: l_module_name := ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name,l_proc_name);

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;
1033:
1034: IF (l_descriptors_tbl.COUNT = 0) THEN

Line 1063: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_proc_name),

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

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

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:
1067: EXCEPTION
1068: WHEN OTHERS THEN

Line 1069: ICX_CAT_UTIL_PVT.logUnexpectedException(

1065: END IF;
1066:
1067: EXCEPTION
1068: WHEN OTHERS THEN
1069: ICX_CAT_UTIL_PVT.logUnexpectedException(
1070: g_pkg_name, l_proc_name,' --> l_progress:' ||l_progress||' '|| SQLERRM);
1071: RAISE;
1072: END populate_namevalue_xmltag;
1073:

Line 1106: l_module_name := ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name,l_proc_name);

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);
1108: END IF;
1109:
1110: IF (dbms_lob.getlength(p_src_clob) > 0 and length(p_replace_with) > 0)THEN

Line 1176: l_module_name := ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name,l_proc_name);

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);
1178: END IF;
1179:
1180: EXCEPTION

Line 1182: ICX_CAT_UTIL_PVT.logUnexpectedException(

1178: END IF;
1179:
1180: EXCEPTION
1181: WHEN OTHERS THEN
1182: ICX_CAT_UTIL_PVT.logUnexpectedException(
1183: g_pkg_name, l_proc_name,' --> l_progress:' ||l_progress||' '|| SQLERRM);
1184: RAISE;
1185: END replace_clob;
1186: