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.CS_CF_UPG_PKG dependencies on FND_LOG

Line 57: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_PKG.Upgrade_Main', 'Configuration profile has been customized. Will not overwrite.');

53: IF (l_region_upgrade_required OR l_flow_upgrade_required) THEN
54: -- Check if the config profile has been customized
55: IF (CS_CF_UPG_UTL_PKG.configProfileCustomized) THEN
56: -- The profile has been customized. Don't overwrite
57: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_PKG.Upgrade_Main', 'Configuration profile has been customized. Will not overwrite.');
58: ELSE
59: -- Update the profile to set to CUSTOM
60: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_PKG.Upgrade_Main', 'Saving profile to CUSTOM');
61:

Line 60: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_PKG.Upgrade_Main', 'Saving profile to CUSTOM');

56: -- The profile has been customized. Don't overwrite
57: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_PKG.Upgrade_Main', 'Configuration profile has been customized. Will not overwrite.');
58: ELSE
59: -- Update the profile to set to CUSTOM
60: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_PKG.Upgrade_Main', 'Saving profile to CUSTOM');
61:
62: l_return_value := FND_PROFILE.SAVE('IBU_REGION_FIELD_CONFIG_OPTION', 'CUSTOM', 'SITE');
63: IF NOT(l_return_value) THEN
64: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_PKG.Upgrade_Main', 'Saving profile to CUSTOM was unsuccessful');

Line 64: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_PKG.Upgrade_Main', 'Saving profile to CUSTOM was unsuccessful');

60: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_PKG.Upgrade_Main', 'Saving profile to CUSTOM');
61:
62: l_return_value := FND_PROFILE.SAVE('IBU_REGION_FIELD_CONFIG_OPTION', 'CUSTOM', 'SITE');
63: IF NOT(l_return_value) THEN
64: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_PKG.Upgrade_Main', 'Saving profile to CUSTOM was unsuccessful');
65:
66: RAISE PROGRAM_ERROR;
67: END IF ;
68: commit;

Line 77: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_UNEXPECTED, 'CS_CF_UPG_PKG.Upgrade_Main','Exception raised in Upgrade_Main');

73:
74: EXCEPTION
75: WHEN OTHERS THEN
76: CS_CF_UPG_UTL_PKG.wrapup('ERROR');
77: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_UNEXPECTED, 'CS_CF_UPG_PKG.Upgrade_Main','Exception raised in Upgrade_Main');
78: RAISE;
79: End Upgrade_Main;
80:
81: /*

Line 263: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_PKG.Is_Region_Upgrade_Required','Is_Region_Upgrade_Required returns true');

259: l_upgrade_required := TRUE;
260: END IF;
261:
262: IF (l_upgrade_required) THEN
263: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_PKG.Is_Region_Upgrade_Required','Is_Region_Upgrade_Required returns true');
264: ELSE
265: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_PKG.Is_Region_Upgrade_Required','Is_Region_Upgrade_Required returns false');
266: END IF;
267: return l_upgrade_required;

Line 265: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_PKG.Is_Region_Upgrade_Required','Is_Region_Upgrade_Required returns false');

261:
262: IF (l_upgrade_required) THEN
263: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_PKG.Is_Region_Upgrade_Required','Is_Region_Upgrade_Required returns true');
264: ELSE
265: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_PKG.Is_Region_Upgrade_Required','Is_Region_Upgrade_Required returns false');
266: END IF;
267: return l_upgrade_required;
268:
269: EXCEPTION

Line 271: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_UNEXPECTED, 'CS_CF_UPG_PKG.Is_Region_Upgrade_Required','Exception raised in Is_Region_Upgrade_Required');

267: return l_upgrade_required;
268:
269: EXCEPTION
270: WHEN OTHERS THEN
271: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_UNEXPECTED, 'CS_CF_UPG_PKG.Is_Region_Upgrade_Required','Exception raised in Is_Region_Upgrade_Required');
272: RAISE;
273:
274: END Is_Region_Upgrade_Required;
275:

Line 313: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_PKG.Is_Flow_Upgrade_Required','Is_Flow_Upgrade_Required returns true');

309: l_upgrade_required := TRUE;
310: END IF;
311:
312: IF (l_upgrade_required) THEN
313: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_PKG.Is_Flow_Upgrade_Required','Is_Flow_Upgrade_Required returns true');
314: ELSE
315: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_PKG.Is_Flow_Upgrade_Required','Is_Flow_Upgrade_Required returns false');
316: END IF;
317: return l_upgrade_required;

Line 315: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_PKG.Is_Flow_Upgrade_Required','Is_Flow_Upgrade_Required returns false');

311:
312: IF (l_upgrade_required) THEN
313: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_PKG.Is_Flow_Upgrade_Required','Is_Flow_Upgrade_Required returns true');
314: ELSE
315: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_PKG.Is_Flow_Upgrade_Required','Is_Flow_Upgrade_Required returns false');
316: END IF;
317: return l_upgrade_required;
318: END Is_Flow_Upgrade_Required;
319:

Line 443: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_PKG: Do_Region_Upgrades_For_Resp', 'Processing Do_Region_Upgrades_For_Resp');

439: l_ProfileTable CS_CF_UPG_UTL_PKG.ProfileTable;
440:
441: BEGIN
442:
443: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_PKG: Do_Region_Upgrades_For_Resp', 'Processing Do_Region_Upgrades_For_Resp');
444:
445:
446: WHILE (l_index < l_count) LOOP
447: -- Get the list of profile names and their values

Line 493: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_UNEXPECTED, 'CS_CF_UPG_PKG: Do_Region_Upgrades_For_Resp', 'Exception in Do_Region_Upgrades_For_Resp');

489: END LOOP; -- ends while loop
490:
491: EXCEPTION
492: WHEN OTHERS THEN
493: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_UNEXPECTED, 'CS_CF_UPG_PKG: Do_Region_Upgrades_For_Resp', 'Exception in Do_Region_Upgrades_For_Resp');
494: IF (get_profiles_for_resp%ISOPEN) THEN
495: CLOSE get_profiles_for_resp;
496: END IF;
497: RAISE;

Line 604: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_PKG.Clone_Regions_For_Resp', 'Cloning regions for respId: ' || l_respId || ' respApplId: ' || l_respApplId);

600: l_examineProbCodeOption BOOLEAN := TRUE;
601:
602: BEGIN
603:
604: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_PKG.Clone_Regions_For_Resp', 'Cloning regions for respId: ' || l_respId || ' respApplId: ' || l_respApplId);
605: WHILE (l_index < l_count) LOOP
606: l_profileOptionName := p_ProfileTable(l_index).profileOptionName;
607: l_profileOptionValue := p_ProfileTable(l_index).profileOptionValue;
608:

Line 624: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_PKG.Clone_Regions_For_Resp', 'Done with SR Account Option');

620: 'IBU_CF_SR_ACCOUNT_NUMBER',
621: 'Y', 'N', null);
622: END IF;
623: l_examineSrAccountOption := FALSE;
624: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_PKG.Clone_Regions_For_Resp', 'Done with SR Account Option');
625: ELSIF (l_profileOptionName = 'IBU_A_SR_PRODUCT_SELECTION_OPTION' AND l_examineProdSelectOption) THEN
626: -- clone the regions
627: l_newRegProductRegionCode := 'IBU_CF_SR_80_R' || p_respId;
628:

Line 654: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_PKG.Clone_Regions_For_Resp', 'Done with SR Product Selection Option');

650: 'Y', 'N', null);
651:
652: END IF;
653: l_examineProdSelectOption := FALSE;
654: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_PKG.Clone_Regions_For_Resp', 'Done with SR Product Selection Option');
655: ELSIF ((l_profileOptionName = 'IBU_A_SR_BILLTO_ADDRESS_OPTION' OR
656: l_profileOptionName = 'IBU_A_SR_BILLTO_CONTACT_OPTION' OR
657: l_profileOptionName = 'IBU_A_SR_SHIPTO_ADDRESS_OPTION' OR
658: l_profileOptionName = 'IBU_A_SR_SHIPTO_CONTACT_OPTION' OR

Line 919: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_PKG.Clone_Regions_For_Resp', 'Done with Address Options');

915: -- We don't need to worry about this case for Update SR address regions, so
916: -- no need to do anything.
917: END IF;
918: l_examineAddressOption := FALSE;
919: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_PKG.Clone_Regions_For_Resp', 'Done with Address Options');
920:
921: ELSIF (l_profileOptionName = 'IBU_SR_CREATION_PRODUCT_OPTION' AND l_examineCreateProdOption) THEN
922: -- mkcyee 12/14/2004 - This profile also impacts the product region for
923: -- Search and Templates, so we need to clone that region as well.

Line 975: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_PKG.Clone_Regions_For_Resp', 'Done with Creation Product Option');

971: 'IBU_CF_SR_REG_PRODUCT_RG',
972: 'N', 'N', null);
973: END IF;
974: l_examineCreateProdOption := FALSE;
975: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_PKG.Clone_Regions_For_Resp', 'Done with Creation Product Option');
976: ELSIF ((l_profileOptionName = 'IBU_A_SR_ATTACHMENT_OPTION' AND l_examineAttachmentOption) OR (l_profileOptionName = 'IBU_A_SR_PROB_CODE_MANDATORY' and l_examineProbCodeOption)) THEN
977: l_newIdentifyProblemRegionCode := 'IBU_CF_SR_40_R' || p_respId;
978:
979: CS_CF_UPG_UTL_PKG.getAttachmentProbCodeValues(p_ProfileTable,

Line 1023: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_PKG.Clone_Regions_For_Resp', 'Done with Attachment Option and Mandatory Problem Code');

1019: END IF;
1020: END IF; -- end if l_region_count for IBU_CF_SR_130_G
1021: l_examineAttachmentOption := FALSE;
1022: l_examineProbCodeOption := FALSE;
1023: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_PKG.Clone_Regions_For_Resp', 'Done with Attachment Option and Mandatory Problem Code');
1024: ELSIF (l_profileOptionName = 'IBU_SR_ENABLE_TEMPLATE' AND l_examineTemplateOption) THEN
1025: l_newProblemDetailsRegionCode := 'IBU_CF_SR_60_R' || p_respId;
1026:
1027: IF (l_profileOptionName = 'N') THEN

Line 1038: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_PKG.Clone_Regions_For_Resp', 'Done with Template Option');

1034: 'IBU_CF_SR_PROB_DETAILS',
1035: 'N', 'N', null);
1036: END IF;
1037: l_examineTemplateOption := FALSE;
1038: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_PKG.Clone_Regions_For_Resp', 'Done with Template Option');
1039:
1040: ELSIF (l_profileOptionName = 'IBU_A_SR_ENABLE_INTERACTION_LOGGING' AND l_examineLoggingOption) THEN
1041: l_newDtlProgOptionsRegionCode := 'IBU_CF_SR_110_R' || p_respId;
1042:

Line 1051: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_PKG.Clone_Regions_For_Resp', 'Done with Interaction Logging Option');

1047: CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newDtlProgOptionsRegionCode,
1048: 'IBU_CF_SR_DTL_PROGRESS_INTRCT',
1049: 'Y', 'N', null);
1050: l_examineLoggingOption := FALSE;
1051: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_PKG.Clone_Regions_For_Resp', 'Done with Interaction Logging Option');
1052: ELSIF (l_profileOptionName = 'IBU_SR_TASK_DISPLAY' AND l_examineTaskOption) THEN
1053: l_newDtlResolnRegionCode := 'IBU_CF_SR_150_R' || p_respId;
1054: IF (l_profileOptionValue = 'Y') THEN
1055: CS_CF_UPG_UTL_PKG.Clone_Region('IBU_CF_SR_150_G',

Line 1064: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_PKG.Clone_Regions_For_Resp', 'Done with Task Display Option');

1060: 'IBU_CF_SR_DTL_ACTS_RG',
1061: 'Y', 'N', null);
1062: END IF;
1063: l_examineTaskOption := FALSE;
1064: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_PKG.Clone_Regions_For_Resp', 'Done with Task Display Option');
1065: END IF; -- end profile checks
1066: l_index := l_index + 1;
1067: END LOOP; -- end while loop
1068:

Line 1986: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_PKG.Clone_Regions_For_Global', '');

1982: l_examineProbCodeOption BOOLEAN := TRUE;
1983:
1984: BEGIN
1985:
1986: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_PKG.Clone_Regions_For_Global', '');
1987: WHILE (l_index < l_count) LOOP
1988: l_profileOptionName := p_ProfileTable(l_index).profileOptionName;
1989: l_profileOptionValue := p_ProfileTable(l_index).profileOptionValue;
1990:

Line 2008: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_PKG.Clone_Regions_For_Global', 'Done with SR Account Option');

2004: 'Y', 'N', null);
2005:
2006: END IF;
2007: l_examineSrAccountOption := FALSE;
2008: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_PKG.Clone_Regions_For_Global', 'Done with SR Account Option');
2009: ELSIF (l_profileOptionName = 'IBU_A_SR_PRODUCT_SELECTION_OPTION' AND l_examineProdSelectOption) THEN
2010: -- clone the regions
2011: l_newRegProductRegionCode := 'IBU_CF_SR_80_GC';
2012:

Line 2039: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_PKG.Clone_Regions_For_Global', 'Done with SR Product Selection Option');

2035: 'Y', 'N', null);
2036:
2037: END IF;
2038: l_examineProdSelectOption := FALSE;
2039: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_PKG.Clone_Regions_For_Global', 'Done with SR Product Selection Option');
2040: ELSIF ((l_profileOptionName = 'IBU_A_SR_BILLTO_ADDRESS_OPTION' OR
2041: l_profileOptionName = 'IBU_A_SR_BILLTO_CONTACT_OPTION' OR
2042: l_profileOptionName = 'IBU_A_SR_SHIPTO_ADDRESS_OPTION' OR
2043: l_profileOptionName = 'IBU_A_SR_SHIPTO_CONTACT_OPTION' OR

Line 2294: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_PKG.Clone_Regions_For_Global', 'Done with Address Options');

2290:
2291: -- we can ignore this case for the address region in update SR
2292: END IF;
2293: l_examineAddressOption := FALSE;
2294: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_PKG.Clone_Regions_For_Global', 'Done with Address Options');
2295:
2296: ELSIF (l_profileOptionName = 'IBU_SR_CREATION_PRODUCT_OPTION' AND l_examineCreateProdOption) THEN
2297:
2298: -- mkcyee 12/14/2004 - This profile also impacts the product region for

Line 2350: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_PKG.Clone_Regions_For_Global', 'Done with Creation Product Option');

2346: 'IBU_CF_SR_REG_PRODUCT_RG',
2347: 'N', 'N', null);
2348: END IF;
2349: l_examineCreateProdOption := FALSE;
2350: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_PKG.Clone_Regions_For_Global', 'Done with Creation Product Option');
2351: ELSIF ((l_profileOptionName = 'IBU_A_SR_ATTACHMENT_OPTION' AND l_examineAttachmentOption) OR (l_profileOptionName = 'IBU_A_SR_PROB_CODE_MANDATORY' and l_examineProbCodeOption)) THEN
2352: l_newIdentifyProblemRegionCode := 'IBU_CF_SR_40_GC';
2353:
2354: CS_CF_UPG_UTL_PKG.getAttachmentProbCodeValues(p_ProfileTable,

Line 2397: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_PKG.Clone_Regions_For_Global', 'Done with Attachment Option and Mandatory Problem Code' );

2393: END IF;
2394: END IF;
2395: l_examineAttachmentOption := FALSE;
2396: l_examineProbCodeOption := FALSE;
2397: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_PKG.Clone_Regions_For_Global', 'Done with Attachment Option and Mandatory Problem Code' );
2398: ELSIF (l_profileOptionName = 'IBU_SR_ENABLE_TEMPLATE' AND l_examineTemplateOption) THEN
2399: l_newProblemDetailsRegionCode := 'IBU_CF_SR_60_GC';
2400: IF (l_profileOptionName = 'N') THEN
2401: CS_CF_UPG_UTL_PKG.Clone_Region('IBU_CF_SR_60_G',

Line 2411: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_PKG.Clone_Regions_For_Global', 'Done with Template Option');

2407: 'IBU_CF_SR_PROB_DETAILS',
2408: 'N', 'N', null);
2409: END IF;
2410: l_examineTemplateOption := FALSE;
2411: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_PKG.Clone_Regions_For_Global', 'Done with Template Option');
2412:
2413: ELSIF (l_profileOptionName = 'IBU_A_SR_ENABLE_INTERACTION_LOGGING' AND l_examineLoggingOption) THEN
2414: l_newDtlProgOptionsRegionCode := 'IBU_CF_SR_110_GC';
2415: CS_CF_UPG_UTL_PKG.Clone_Region('IBU_CF_SR_110_G',

Line 2423: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_PKG.Clone_Regions_For_Global', 'Done with Interaction Logging Option');

2419: CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newDtlProgOptionsRegionCode,
2420: 'IBU_CF_SR_DTL_PROGRESS_INTRCT',
2421: 'Y', 'N', null);
2422: l_examineLoggingOption := FALSE;
2423: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_PKG.Clone_Regions_For_Global', 'Done with Interaction Logging Option');
2424: ELSIF (l_profileOptionName = 'IBU_SR_TASK_DISPLAY' AND l_examineTaskOption) THEN
2425: l_newDtlResolnRegionCode := 'IBU_CF_SR_150_GC';
2426: IF (l_profileOptionValue = 'Y') THEN
2427: CS_CF_UPG_UTL_PKG.Clone_Region('IBU_CF_SR_150_G',

Line 2436: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_PKG.Clone_Regions_For_Global', 'Done with Task Display Option');

2432: 'IBU_CF_SR_DTL_ACTS_RG',
2433: 'Y', 'N', null);
2434: END IF;
2435: l_examineTaskOption := FALSE;
2436: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_PKG.Clone_Regions_For_Global', 'Done with Task Display Option');
2437: END IF; -- end profile checks
2438: l_index := l_index + 1;
2439: END LOOP; -- end while loop
2440:

Line 3213: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_PKG.Clone_Regions_For_Appl', 'Cloning regions for ApplId: ' || l_ApplId);

3209: l_examineProbCodeOption BOOLEAN := TRUE;
3210:
3211: BEGIN
3212:
3213: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_PKG.Clone_Regions_For_Appl', 'Cloning regions for ApplId: ' || l_ApplId);
3214: WHILE (l_index < l_count) LOOP
3215: l_profileOptionName := p_ProfileTable(l_index).profileOptionName;
3216: l_profileOptionValue := p_ProfileTable(l_index).profileOptionValue;
3217:

Line 3235: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_PKG.Clone_Regions_For_Appl', 'Done with SR Account Option');

3231: 'Y', 'N', null);
3232:
3233: END IF;
3234: l_examineSrAccountOption := FALSE;
3235: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_PKG.Clone_Regions_For_Appl', 'Done with SR Account Option');
3236: ELSIF (l_profileOptionName = 'IBU_A_SR_PRODUCT_SELECTION_OPTION' AND l_examineProdSelectOption) THEN
3237: -- clone the regions
3238: l_newRegProductRegionCode := 'IBU_CF_SR_80_A' || p_ApplId;
3239:

Line 3266: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_PKG.Clone_Regions_For_Appl', 'Done with SR Product Selection Option');

3262: 'Y', 'N', null);
3263:
3264: END IF;
3265: l_examineProdSelectOption := FALSE;
3266: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_PKG.Clone_Regions_For_Appl', 'Done with SR Product Selection Option');
3267: ELSIF ((l_profileOptionName = 'IBU_A_SR_BILLTO_ADDRESS_OPTION' OR
3268: l_profileOptionName = 'IBU_A_SR_BILLTO_CONTACT_OPTION' OR
3269: l_profileOptionName = 'IBU_A_SR_SHIPTO_ADDRESS_OPTION' OR
3270: l_profileOptionName = 'IBU_A_SR_SHIPTO_CONTACT_OPTION' OR

Line 3527: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_PKG.Clone_Regions_For_Appl', 'Done with Address Options');

3523: 'N', 'N', null);
3524:
3525: END IF;
3526: l_examineAddressOption := FALSE;
3527: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_PKG.Clone_Regions_For_Appl', 'Done with Address Options');
3528:
3529: ELSIF (l_profileOptionName = 'IBU_SR_CREATION_PRODUCT_OPTION' AND l_examineCreateProdOption) THEN
3530: -- mkcyee 12/14/2004 - This profile also impacts the product region for
3531: -- Templates, so we need to clone that region as well.

Line 3582: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_PKG.Clone_Regions_For_Appl', 'Done with Creation Product Option');

3578: 'IBU_CF_SR_REG_PRODUCT_RG',
3579: 'N', 'N', null);
3580: END IF;
3581: l_examineCreateProdOption := FALSE;
3582: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_PKG.Clone_Regions_For_Appl', 'Done with Creation Product Option');
3583: ELSIF ((l_profileOptionName = 'IBU_A_SR_ATTACHMENT_OPTION' AND l_examineAttachmentOption) OR (l_profileOptionName = 'IBU_A_SR_PROB_CODE_MANDATORY' and l_examineProbCodeOption)) THEN
3584: l_newIdentifyProblemRegionCode := 'IBU_CF_SR_40_A' || p_ApplId;
3585:
3586: CS_CF_UPG_UTL_PKG.getAttachmentProbCodeValues(p_ProfileTable,

Line 3629: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_PKG.Clone_Regions_For_Appl', 'Done with Attachment Option and Mandatory Problem Code' );

3625: END IF;
3626: END IF;
3627: l_examineAttachmentOption := FALSE;
3628: l_examineProbCodeOption := FALSE;
3629: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_PKG.Clone_Regions_For_Appl', 'Done with Attachment Option and Mandatory Problem Code' );
3630: ELSIF (l_profileOptionName = 'IBU_SR_ENABLE_TEMPLATE' AND l_examineTemplateOption) THEN
3631: l_newProblemDetailsRegionCode := 'IBU_CF_SR_60_A' || p_ApplId;
3632: IF (l_profileOptionName = 'N') THEN
3633: CS_CF_UPG_UTL_PKG.Clone_Region('IBU_CF_SR_60_G',

Line 3643: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_PKG.Clone_Regions_For_Appl', 'Done with Template Option');

3639: 'IBU_CF_SR_PROB_DETAILS',
3640: 'N', 'N', null);
3641: END IF;
3642: l_examineTemplateOption := FALSE;
3643: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_PKG.Clone_Regions_For_Appl', 'Done with Template Option');
3644:
3645: ELSIF (l_profileOptionName = 'IBU_A_SR_ENABLE_INTERACTION_LOGGING' AND l_examineLoggingOption) THEN
3646: l_newDtlProgOptionsRegionCode := 'IBU_CF_SR_110_A' || p_ApplId;
3647: CS_CF_UPG_UTL_PKG.Clone_Region('IBU_CF_SR_110_G',

Line 3655: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_PKG.Clone_Regions_For_Appl', 'Done with Interaction Logging Option');

3651: CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newDtlProgOptionsRegionCode,
3652: 'IBU_CF_SR_DTL_PROGRESS_INTRCT',
3653: 'Y', 'N', null);
3654: l_examineLoggingOption := FALSE;
3655: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_PKG.Clone_Regions_For_Appl', 'Done with Interaction Logging Option');
3656: ELSIF (l_profileOptionName = 'IBU_SR_TASK_DISPLAY' AND l_examineTaskOption) THEN
3657: l_newDtlResolnRegionCode := 'IBU_CF_SR_150_A' || p_ApplId;
3658: IF (l_profileOptionValue = 'Y') THEN
3659: CS_CF_UPG_UTL_PKG.Clone_Region('IBU_CF_SR_150_G',

Line 3668: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_PKG.Clone_Regions_For_Appl', 'Done with Task Display Option');

3664: 'IBU_CF_SR_DTL_ACTS_RG',
3665: 'Y', 'N', null);
3666: END IF;
3667: l_examineTaskOption := FALSE;
3668: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_PKG.Clone_Regions_For_Appl', 'Done with Task Display Option');
3669: END IF; -- end profile checks
3670: l_index := l_index + 1;
3671: END LOOP; -- end while loop
3672:

Line 4427: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_PKG: Do_Flow_Upgrades_For_Resp', 'Processing Do_Flow_Upgrades_For_Resp');

4423: l_ProfileTable CS_CF_UPG_UTL_PKG.ProfileTable;
4424:
4425: BEGIN
4426:
4427: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_PKG: Do_Flow_Upgrades_For_Resp', 'Processing Do_Flow_Upgrades_For_Resp');
4428:
4429:
4430: WHILE (l_index < l_count) LOOP
4431: -- Get the list of profile names and their values

Line 4478: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_UNEXPECTED, 'CS_CF_UPG_PKG: Do_Flow_Upgrades_For_Resp', 'Exception in Do_Flow_Upgrades_For_Resp');

4474: END LOOP; -- ends while loop
4475:
4476: EXCEPTION
4477: WHEN OTHERS THEN
4478: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_UNEXPECTED, 'CS_CF_UPG_PKG: Do_Flow_Upgrades_For_Resp', 'Exception in Do_Flow_Upgrades_For_Resp');
4479: IF (get_profiles_for_resp%ISOPEN) THEN
4480: CLOSE get_profiles_for_resp;
4481: END IF;
4482: RAISE;

Line 4511: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_PKG.Clone_Flows_For_Resp', 'Setting flow for respId: ' || l_respId || ' respApplId: ' || l_respApplId);

4507: l_examineKBOption BOOLEAN := TRUE;
4508:
4509: BEGIN
4510:
4511: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_PKG.Clone_Flows_For_Resp', 'Setting flow for respId: ' || l_respId || ' respApplId: ' || l_respApplId);
4512: WHILE (l_index < l_count) LOOP
4513: l_profileOptionName := p_ProfileTable(l_index).profileOptionName;
4514: l_profileOptionValue := p_ProfileTable(l_index).profileOptionValue;
4515:

Line 4591: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_PKG: Do_Flow_Upgrades_For_Appl', 'Processing Do_Flow_Upgrades_For_Appl');

4587: l_ProfileTable CS_CF_UPG_UTL_PKG.ProfileTable;
4588:
4589: BEGIN
4590:
4591: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_PKG: Do_Flow_Upgrades_For_Appl', 'Processing Do_Flow_Upgrades_For_Appl');
4592:
4593:
4594: WHILE (l_index < l_count) LOOP
4595: -- Get the list of profile names and their values

Line 4640: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_UNEXPECTED, 'CS_CF_UPG_PKG: Do_Flow_Upgrades_For_Appl', 'Exception in Do_Flow_Upgrades_For_Appl');

4636: END LOOP; -- ends while loop
4637:
4638: EXCEPTION
4639: WHEN OTHERS THEN
4640: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_UNEXPECTED, 'CS_CF_UPG_PKG: Do_Flow_Upgrades_For_Appl', 'Exception in Do_Flow_Upgrades_For_Appl');
4641: IF (get_profiles_for_appl%ISOPEN) THEN
4642: CLOSE get_profiles_for_appl;
4643: END IF;
4644: RAISE;

Line 4671: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_PKG.Clone_Flows_For_Appl', 'Setting flow for applId: ' || l_applId );

4667: l_examineKBOption BOOLEAN := TRUE;
4668:
4669: BEGIN
4670:
4671: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_PKG.Clone_Flows_For_Appl', 'Setting flow for applId: ' || l_applId );
4672: WHILE (l_index < l_count) LOOP
4673: l_profileOptionName := p_ProfileTable(l_index).profileOptionName;
4674: l_profileOptionValue := p_ProfileTable(l_index).profileOptionValue;
4675:

Line 4757: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_PKG.Do_Flow_Upgrades_For_Global', 'Updating global entry in cs_cf_source_cxt_targets to use 11510 default flow. l_source_context_type_id:' || l_source_context_type_id);

4753: UPDATE cs_cf_source_cxt_targets
4754: SET cust_target_value1 = '10'
4755: WHERE source_context_type_id = l_source_context_type_id;
4756:
4757: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_PKG.Do_Flow_Upgrades_For_Global', 'Updating global entry in cs_cf_source_cxt_targets to use 11510 default flow. l_source_context_type_id:' || l_source_context_type_id);
4758: END IF;
4759:
4760: END IF;
4761: l_examineKBOption := FALSE;

Line 4769: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_UNEXPECTED, 'CS_CF_UPG_PKG.Do_Flow_Upgrades_For_Global', 'Unexpected error in Do_Flow_Upgrades_For_Global');

4765: END LOOP;
4766:
4767: EXCEPTION
4768: WHEN OTHERS THEN
4769: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_UNEXPECTED, 'CS_CF_UPG_PKG.Do_Flow_Upgrades_For_Global', 'Unexpected error in Do_Flow_Upgrades_For_Global');
4770:
4771: IF (l_cur%ISOPEN) THEN
4772: CLOSE l_cur;
4773: END IF;