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_R12_UPG_EXCEP_FILES

Line 53: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_icx_schema_name||'.ICX_CAT_R12_UPG_EXCEP_FILES';

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

Line 172: FROM icx_cat_r12_upg_excep_files

168: -- corresponding lines has errors
169: AND (poie.interface_line_id IS NULL OR
170: poie.interface_line_id = poai.interface_line_id))
171: AND NOT EXISTS (SELECT 1
172: FROM icx_cat_r12_upg_excep_files
173: WHERE interface_header_id = pohi.interface_header_id
174: AND language = poai.language)
175: ORDER BY pohi.interface_header_id;
176:

Line 252: INSERT INTO icx_cat_r12_upg_excep_files (interface_header_id,

248:
249: BEGIN
250: -- Inserting the data into Upgrade Exceptions File Table
251: FORALL headers_index IN 1..l_interface_header_id_tbl.COUNT
252: INSERT INTO icx_cat_r12_upg_excep_files (interface_header_id,
253: vendor_id,
254: vendor_site_id,
255: org_id,
256: currency_code,

Line 298: 'Deleting data from ICX_CAT_R12_UPG_EXCEP_FILES table'||

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);
301: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION, l_module_name, l_log_string);
302: END IF;

Line 303: DELETE FROM icx_cat_r12_upg_excep_files

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;
306:
307: IF (interface_headers_cursor%ISOPEN) THEN

Line 381: l_language icx_cat_r12_upg_excep_files.language%TYPE;

377: l_progress PLS_INTEGER;
378:
379: l_interface_header_id NUMBER;
380: l_ip_category_id NUMBER;
381: l_language icx_cat_r12_upg_excep_files.language%TYPE;
382:
383: langCount number := 1;
384: l_file_name icx_cat_r12_upg_excep_files.file_name%TYPE;
385: l_table_count NUMBER;

Line 384: l_file_name icx_cat_r12_upg_excep_files.file_name%TYPE;

380: l_ip_category_id NUMBER;
381: l_language icx_cat_r12_upg_excep_files.language%TYPE;
382:
383: langCount number := 1;
384: l_file_name icx_cat_r12_upg_excep_files.file_name%TYPE;
385: l_table_count NUMBER;
386: l_prev_interface_header_id NUMBER := 0;
387: l_log_string varchar2(400);
388: l_module_name varchar2(200);

Line 488: UPDATE icx_cat_r12_upg_excep_files

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
489: SET file_name = l_file_name,
490: data_file = l_headerXML
491: WHERE interface_header_id = l_interface_header_id
492: AND language = l_language;