APPS.ICX_CAT_R12_DATA_EXCEP_RPT_PVT dependencies on ICX_CAT_R12_DATA_EXCEP_RPT_PVT

Line 1: PACKAGE BODY ICX_CAT_R12_DATA_EXCEP_RPT_PVT AS

1: PACKAGE BODY ICX_CAT_R12_DATA_EXCEP_RPT_PVT AS
2: /* $Header: ICXVDERB.pls 120.17 2006/07/21 10:04:28 mkohale noship $*/
3:
4: --Constant for R12 used to
5: --populate Updated_by and Created_by Columns

Line 9: g_pkg_name VARCHAR2(40) := 'ICX_CAT_R12_DATA_EXCEP_RPT_PVT';

5: --populate Updated_by and Created_by Columns
6: UPGRADE_USER_ID NUMBER := -12;
7:
8: -- Package name constant used in debug
9: g_pkg_name VARCHAR2(40) := 'ICX_CAT_R12_DATA_EXCEP_RPT_PVT';
10:
11: /**
12: ** Private functions used in Populating the XML Data
13: **

Line 56: l_log_string := 'ICX_CAT_R12_DATA_EXCEP_RPT_PVT.cleanup_tables deleting data

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

Line 93: l_log_string := 'ICX_CAT_R12_DATA_EXCEP_RPT_PVT.populate_language_map started :--> '||

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

Line 134: l_log_string := 'ICX_CAT_R12_DATA_EXCEP_RPT_PVT.populate_language_map completed :--> '||

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

Line 1104: l_log_string := 'ICX_CAT_R12_DATA_EXCEP_RPT_PVT.replace_clob started:-->'||

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

Line 1174: l_log_string := 'ICX_CAT_R12_DATA_EXCEP_RPT_PVT.replace_clob completed:-->'||

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

Line 1187: END ICX_CAT_R12_DATA_EXCEP_RPT_PVT;

1183: g_pkg_name, l_proc_name,' --> l_progress:' ||l_progress||' '|| SQLERRM);
1184: RAISE;
1185: END replace_clob;
1186:
1187: END ICX_CAT_R12_DATA_EXCEP_RPT_PVT;