APPS.ICX_CAT_R12_DATA_EXCEP_RPT_PVT dependencies on ICX_CAT_R12_UPG_ERROR_MSGS

Line 57: from icx_cat_r12_upg_error_msgs';

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

Line 62: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_icx_schema_name||'.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:
64: l_end_date := sysdate;
65:
66: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 515: ** ICX_CAT_R12_UPG_Error_Msgs Table.

511:
512: /**
513: ** Procedure : populate_upg_error_msgs
514: ** Synopsis : Procedure For Populating
515: ** ICX_CAT_R12_UPG_Error_Msgs Table.
516: ** Parameter:
517: ** IN p_interface_header_id_tbl --table of interface_header_ids
518: **/
519: PROCEDURE populate_upg_error_msgs(p_interface_header_id_tbl IN DBMS_SQL.NUMBER_TABLE)

Line 588: INSERT INTO icx_cat_r12_upg_error_msgs(interface_header_id,

584: EXIT WHEN l_po_msg_tbl.COUNT = 0;
585:
586: l_progress := 120;
587: FORALL i IN 1..l_po_msg_tbl.COUNT
588: INSERT INTO icx_cat_r12_upg_error_msgs(interface_header_id,
589: error_message_name,
590: token_value,
591: creation_date,
592: created_by,