APPS.CS_CF_UPG_BUGFIX1_PKG dependencies on FND_LOG

Line 18: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_STATEMENT,'CS_CF_UPG_BUGFIX1_PKG.Main', 'Starting bugfix1 procedure');

14: from dual;
15:
16: CS_CF_UPG_UTL_PKG.setup_log('IBUCFUPG-' || l_logfilename);
17:
18: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_STATEMENT,'CS_CF_UPG_BUGFIX1_PKG.Main', 'Starting bugfix1 procedure');
19: Fix_Regions_Bugfix1('R');
20: Fix_Regions_Bugfix1('A');
21: Fix_Regions_Bugfix1('GC');
22:

Line 28: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_UNEXPECTED, 'CS_CF_UPG_BUGFIX1_PKG.Main','Exception raised in Main');

24:
25: EXCEPTION
26: WHEN OTHERS THEN
27: CS_CF_UPG_UTL_PKG.wrapup('ERROR');
28: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_UNEXPECTED, 'CS_CF_UPG_BUGFIX1_PKG.Main','Exception raised in Main');
29: RAISE;
30: End Main;
31:
32: PROCEDURE Fix_Regions_Bugfix1(p_contextType IN VARCHAR2) IS

Line 76: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_STATEMENT,'CS_CF_UPG_BUGFIX1_PKG.Fix_Regions_Bugfix1', 'Fixing for IBU_CF_SR_30_X suffix:' || p_contextType || l_suffix);

72: l_suffix := substr(l_region_code, 15);
73: ELSE
74: l_suffix := '';
75: END IF;
76: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_STATEMENT,'CS_CF_UPG_BUGFIX1_PKG.Fix_Regions_Bugfix1', 'Fixing for IBU_CF_SR_30_X suffix:' || p_contextType || l_suffix);
77:
78: l_newRegionCode := 'IBU_CF_SR_35_' || p_contextType || l_suffix;
79:
80: OPEN region_exist('IBU_CF_SR_35_' || p_contextType || l_suffix);

Line 187: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_STATEMENT,'CS_CF_UPG_BUGFIX1_PKG.Fix_Regions_Bugfix1', 'Fixing for IBU_CF_SR_130_X suffix:' || p_contextType || l_suffix);

183: l_suffix := substr(l_region_code, 16);
184: ELSE
185: l_suffix := '';
186: END IF;
187: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_STATEMENT,'CS_CF_UPG_BUGFIX1_PKG.Fix_Regions_Bugfix1', 'Fixing for IBU_CF_SR_130_X suffix:' || p_contextType || l_suffix);
188:
189: OPEN region_exist('IBU_CF_SR_25_' || p_contextType || l_suffix);
190: FETCH region_exist INTO l_count;
191: CLOSE region_exist;

Line 218: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_STATEMENT,'CS_CF_UPG_BUGFIX1_PKG.Fix_Regions_Bugfix1', 'Fixing for IBU_CF_SR_210_X suffix:' || p_contextType || l_suffix);

214: l_suffix := substr(l_region_code, 16);
215: ELSE
216: l_suffix := '';
217: END IF;
218: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_STATEMENT,'CS_CF_UPG_BUGFIX1_PKG.Fix_Regions_Bugfix1', 'Fixing for IBU_CF_SR_210_X suffix:' || p_contextType || l_suffix);
219:
220: OPEN region_exist('IBU_CF_SR_25_' || p_contextType || l_suffix);
221: FETCH region_exist INTO l_count;
222: CLOSE region_exist;

Line 249: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_STATEMENT,'CS_CF_UPG_BUGFIX1_PKG.Fix_Regions_Bugfix1', 'Fixing for IBU_CF_SR_310_X suffix:' || p_contextType || l_suffix);

245: l_suffix := substr(l_region_code, 16);
246: ELSE
247: l_suffix := '';
248: END IF;
249: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_STATEMENT,'CS_CF_UPG_BUGFIX1_PKG.Fix_Regions_Bugfix1', 'Fixing for IBU_CF_SR_310_X suffix:' || p_contextType || l_suffix);
250:
251: CS_CF_UPG_UTL_PKG.UpdateRegionItems('IBU_CF_SR_310_' || p_contextType || l_suffix,
252: 'IBU_CF_SR_PRIMARY_CONTACT_RG',
253: 'Y', 'N', 'IBU_CF_SR_15_G');

Line 270: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_STATEMENT,'CS_CF_UPG_BUGFIX1_PKG.Fix_Regions_Bugfix1', 'Fixing for IBU_CF_SR_320_X suffix:' || p_contextType || l_suffix);

266: l_suffix := substr(l_region_code, 16);
267: ELSE
268: l_suffix := '';
269: END IF;
270: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_STATEMENT,'CS_CF_UPG_BUGFIX1_PKG.Fix_Regions_Bugfix1', 'Fixing for IBU_CF_SR_320_X suffix:' || p_contextType || l_suffix);
271:
272: CS_CF_UPG_UTL_PKG.UpdateRegionItems('IBU_CF_SR_320_' || p_contextType || l_suffix,
273: 'IBU_CF_SR_PRIMARY_CONTACT_RG',
274: 'Y', 'N', 'IBU_CF_SR_15_G');

Line 284: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_UNEXPECTED, 'CS_CF_UPG_BUGFIX1_PKG.Main','Exception raised in Main');

280:
281: EXCEPTION
282: WHEN OTHERS THEN
283: CS_CF_UPG_UTL_PKG.wrapup('ERROR');
284: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_UNEXPECTED, 'CS_CF_UPG_BUGFIX1_PKG.Main','Exception raised in Main');
285:
286: IF (get_regions%ISOPEN) THEN
287: CLOSE get_regions;
288: END IF;