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_UTL_PKG dependencies on FND_LOG

Line 63: log_mesg(FND_LOG.LEVEL_STATEMENT,'CS_CF_UPG_UTL_PKG.Eval_SR_Account_Option', 'site level value customized. Profile option value: ' || l_profile_option_value);

59: l_upgrade_required := TRUE;
60: p_siteProfilesTable(p_site_index).profileOptionName := 'IBU_A_SR_ACCOUNT_OPTION';
61: p_siteProfilesTable(p_site_index).profileOptionValue := l_profile_option_value;
62: p_site_index := p_site_index + 1;
63: log_mesg(FND_LOG.LEVEL_STATEMENT,'CS_CF_UPG_UTL_PKG.Eval_SR_Account_Option', 'site level value customized. Profile option value: ' || l_profile_option_value);
64: END IF;
65: ELSIF (l_level_id = 10002) THEN
66: -- there should not have been a value set at the appl level
67: -- If there is a vvalue, then it is customized

Line 69: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Account_Option', 'appl level value customized. Profile option value: ' || l_profile_option_value);

65: ELSIF (l_level_id = 10002) THEN
66: -- there should not have been a value set at the appl level
67: -- If there is a vvalue, then it is customized
68: l_upgrade_required := TRUE;
69: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Account_Option', 'appl level value customized. Profile option value: ' || l_profile_option_value);
70: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Account_Option', 'Application Id: ' || to_char(l_level_value));
71: IF NOT(Appl_Already_Exists(p_applTable, l_level_value)) THEN
72: p_applTable(p_appl_index) := l_level_value;
73: p_appl_index := p_appl_index + 1;

Line 70: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Account_Option', 'Application Id: ' || to_char(l_level_value));

66: -- there should not have been a value set at the appl level
67: -- If there is a vvalue, then it is customized
68: l_upgrade_required := TRUE;
69: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Account_Option', 'appl level value customized. Profile option value: ' || l_profile_option_value);
70: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Account_Option', 'Application Id: ' || to_char(l_level_value));
71: IF NOT(Appl_Already_Exists(p_applTable, l_level_value)) THEN
72: p_applTable(p_appl_index) := l_level_value;
73: p_appl_index := p_appl_index + 1;
74: END IF;

Line 79: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Account_Option', 'resp level value customized. Profile option value: ' || l_profile_option_value);

75: ELSIF (l_level_id = 10003) THEN
76: -- there should not have been a value set at the resp level
77: -- If there is a value, then it is customized
78: l_upgrade_required := TRUE;
79: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Account_Option', 'resp level value customized. Profile option value: ' || l_profile_option_value);
80:
81: log_mesg(FND_LOG.LEVEL_STATEMENT,'CS_CF_UPG_UTL_PKG.Eval_SR_Account_Option', 'Resp id: ' || to_char(l_level_value) || ' Resp Appl Id: ' || to_char(l_level_value_appl_id));
82:
83:

Line 81: log_mesg(FND_LOG.LEVEL_STATEMENT,'CS_CF_UPG_UTL_PKG.Eval_SR_Account_Option', 'Resp id: ' || to_char(l_level_value) || ' Resp Appl Id: ' || to_char(l_level_value_appl_id));

77: -- If there is a value, then it is customized
78: l_upgrade_required := TRUE;
79: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Account_Option', 'resp level value customized. Profile option value: ' || l_profile_option_value);
80:
81: log_mesg(FND_LOG.LEVEL_STATEMENT,'CS_CF_UPG_UTL_PKG.Eval_SR_Account_Option', 'Resp id: ' || to_char(l_level_value) || ' Resp Appl Id: ' || to_char(l_level_value_appl_id));
82:
83:
84: IF NOT (Resp_Already_Exists(p_respTable, l_level_value, l_level_value_appl_id)) THEN
85: p_respTable(p_resp_index).respId := l_level_value;

Line 102: log_mesg(FND_LOG.LEVEL_UNEXPECTED, 'CS_CF_UPG_UTL_PKG:Eval_SR_Account_Option', 'Exception in Eval_SR_Account_Option');

98: return l_upgrade_required;
99:
100: EXCEPTION
101: WHEN OTHERS THEN
102: log_mesg(FND_LOG.LEVEL_UNEXPECTED, 'CS_CF_UPG_UTL_PKG:Eval_SR_Account_Option', 'Exception in Eval_SR_Account_Option');
103: IF (get_profile_option_values%ISOPEN) THEN
104: CLOSE get_profile_option_values;
105: END IF;
106: RAISE;

Line 161: log_mesg(FND_LOG.LEVEL_STATEMENT,'CS_CF_UPG_UTL_PKG.Eval_SR_Problem_Code_Option', 'site level value customized. Profile option value: ' || l_profile_option_value);

157: l_upgrade_required := TRUE;
158: p_siteProfilesTable(p_site_index).profileOptionName := 'IBU_A_SR_PROB_CODE_MANDATORY';
159: p_siteProfilesTable(p_site_index).profileOptionValue := l_profile_option_value;
160: p_site_index := p_site_index + 1;
161: log_mesg(FND_LOG.LEVEL_STATEMENT,'CS_CF_UPG_UTL_PKG.Eval_SR_Problem_Code_Option', 'site level value customized. Profile option value: ' || l_profile_option_value);
162: END IF;
163: ELSIF (l_level_id = 10002) THEN
164: -- there should not have been a value set at the appl level
165: -- If there is a vvalue, then it is customized

Line 167: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Problem_Code_Option', 'appl level value customized. Profile option value: ' || l_profile_option_value);

163: ELSIF (l_level_id = 10002) THEN
164: -- there should not have been a value set at the appl level
165: -- If there is a vvalue, then it is customized
166: l_upgrade_required := TRUE;
167: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Problem_Code_Option', 'appl level value customized. Profile option value: ' || l_profile_option_value);
168: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Problem_Option', 'Application Id: ' || to_char(l_level_value));
169: IF NOT(Appl_Already_Exists(p_applTable, l_level_value)) THEN
170: p_applTable(p_appl_index) := l_level_value;
171: p_appl_index := p_appl_index + 1;

Line 168: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Problem_Option', 'Application Id: ' || to_char(l_level_value));

164: -- there should not have been a value set at the appl level
165: -- If there is a vvalue, then it is customized
166: l_upgrade_required := TRUE;
167: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Problem_Code_Option', 'appl level value customized. Profile option value: ' || l_profile_option_value);
168: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Problem_Option', 'Application Id: ' || to_char(l_level_value));
169: IF NOT(Appl_Already_Exists(p_applTable, l_level_value)) THEN
170: p_applTable(p_appl_index) := l_level_value;
171: p_appl_index := p_appl_index + 1;
172: END IF;

Line 177: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Problem_Code_Option', 'resp level value customized. Profile option value: ' || l_profile_option_value);

173: ELSIF (l_level_id = 10003) THEN
174: -- there should not be any values, so if there is,
175: -- it must be a customization
176: l_upgrade_required := TRUE;
177: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Problem_Code_Option', 'resp level value customized. Profile option value: ' || l_profile_option_value);
178:
179: log_mesg(FND_LOG.LEVEL_STATEMENT,'CS_CF_UPG_UTL_PKG.Eval_SR_Problem_Code_Option', 'Resp id: ' || to_char(l_level_value) || ' Resp Appl Id: ' || to_char(l_level_value_appl_id));
180:
181:

Line 179: log_mesg(FND_LOG.LEVEL_STATEMENT,'CS_CF_UPG_UTL_PKG.Eval_SR_Problem_Code_Option', 'Resp id: ' || to_char(l_level_value) || ' Resp Appl Id: ' || to_char(l_level_value_appl_id));

175: -- it must be a customization
176: l_upgrade_required := TRUE;
177: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Problem_Code_Option', 'resp level value customized. Profile option value: ' || l_profile_option_value);
178:
179: log_mesg(FND_LOG.LEVEL_STATEMENT,'CS_CF_UPG_UTL_PKG.Eval_SR_Problem_Code_Option', 'Resp id: ' || to_char(l_level_value) || ' Resp Appl Id: ' || to_char(l_level_value_appl_id));
180:
181:
182: IF NOT (Resp_Already_Exists(p_respTable, l_level_value, l_level_value_appl_id)) THEN
183: p_respTable(p_resp_index).respId := l_level_value;

Line 200: log_mesg(FND_LOG.LEVEL_UNEXPECTED, 'CS_CF_UPG_UTL_PKG:Eval_SR_Problem_Code_Option', 'Exception in Eval_SR_Problem_Code_Option');

196: return l_upgrade_required;
197:
198: EXCEPTION
199: WHEN OTHERS THEN
200: log_mesg(FND_LOG.LEVEL_UNEXPECTED, 'CS_CF_UPG_UTL_PKG:Eval_SR_Problem_Code_Option', 'Exception in Eval_SR_Problem_Code_Option');
201: IF (get_profile_option_values%ISOPEN) THEN
202: CLOSE get_profile_option_values;
203: END IF;
204: IF (get_profile_option_count%ISOPEN) THEN

Line 244: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Prod_Creation_Option', 'site level value customized. Profile option value: ' || l_profile_option_value);

240: WHILE get_profile_option_values%FOUND LOOP
241:
242: IF (l_level_id = 10001) THEN
243: IF (l_profile_option_value <> 'USE_BOTH_INVENTORY_AND_INSTALL') THEN
244: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Prod_Creation_Option', 'site level value customized. Profile option value: ' || l_profile_option_value);
245: p_siteProfilesTable(p_site_index).profileOptionName := 'IBU_SR_CREATION_PRODUCT_OPTION';
246: p_siteProfilesTAble(p_site_index).profileOptionValue := l_profile_option_value;
247: p_site_index := p_site_index + 1;
248: l_upgrade_required := TRUE;

Line 254: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Prod_Creation_Option', 'appl level value customized. Profile option value: ' || l_profile_option_value);

250: ELSIF (l_level_id = 10002) THEN
251: -- There wasn't any seeded value for the app level. Therefore,
252: -- this must be a customization
253: l_upgrade_required := TRUE;
254: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Prod_Creation_Option', 'appl level value customized. Profile option value: ' || l_profile_option_value);
255: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Prod_Creation_Option', 'Application Id: ' || to_char(l_level_value));
256:
257: IF NOT(Appl_Already_Exists(p_ApplTable, l_level_value)) THEN
258: p_ApplTable(p_appl_index) := l_level_value;

Line 255: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Prod_Creation_Option', 'Application Id: ' || to_char(l_level_value));

251: -- There wasn't any seeded value for the app level. Therefore,
252: -- this must be a customization
253: l_upgrade_required := TRUE;
254: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Prod_Creation_Option', 'appl level value customized. Profile option value: ' || l_profile_option_value);
255: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Prod_Creation_Option', 'Application Id: ' || to_char(l_level_value));
256:
257: IF NOT(Appl_Already_Exists(p_ApplTable, l_level_value)) THEN
258: p_ApplTable(p_appl_index) := l_level_value;
259: p_appl_index := p_appl_index + 1;

Line 265: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Prod_Creation_Option', 'resp level value customized. Profile option value: ' || l_profile_option_value);

261: ELSIF (l_level_id = 10003) THEN
262: -- There wasn't any seeded value for the resp level. Therefore,
263: -- this must be a customization
264: l_upgrade_required := TRUE;
265: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Prod_Creation_Option', 'resp level value customized. Profile option value: ' || l_profile_option_value);
266: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Prod_Creation_Option', 'Resp id: ' || to_char(l_level_value) || ' Resp Appl Id: ' || to_char(l_level_value_appl_id));
267: IF NOT (Resp_Already_Exists(p_RespTable, l_level_value, l_level_value_appl_id)) THEN
268: p_RespTable(p_resp_index).respId := l_level_value;
269: p_RespTable(p_resp_index).respApplId := l_level_value_appl_id;

Line 266: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Prod_Creation_Option', 'Resp id: ' || to_char(l_level_value) || ' Resp Appl Id: ' || to_char(l_level_value_appl_id));

262: -- There wasn't any seeded value for the resp level. Therefore,
263: -- this must be a customization
264: l_upgrade_required := TRUE;
265: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Prod_Creation_Option', 'resp level value customized. Profile option value: ' || l_profile_option_value);
266: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Prod_Creation_Option', 'Resp id: ' || to_char(l_level_value) || ' Resp Appl Id: ' || to_char(l_level_value_appl_id));
267: IF NOT (Resp_Already_Exists(p_RespTable, l_level_value, l_level_value_appl_id)) THEN
268: p_RespTable(p_resp_index).respId := l_level_value;
269: p_RespTable(p_resp_index).respApplId := l_level_value_appl_id;
270: p_resp_index := p_resp_index + 1;

Line 285: log_mesg(FND_LOG.LEVEL_UNEXPECTED, 'CS_CF_UPG_UTL_PKG.Eval_SR_Prod_Creation_Option', 'Exception in Eval_SR_Prod_Creation_Option');

281: return l_upgrade_required;
282:
283: EXCEPTION
284: WHEN OTHERS THEN
285: log_mesg(FND_LOG.LEVEL_UNEXPECTED, 'CS_CF_UPG_UTL_PKG.Eval_SR_Prod_Creation_Option', 'Exception in Eval_SR_Prod_Creation_Option');
286: IF (get_profile_option_values%ISOPEN) THEN
287: CLOSE get_profile_option_values;
288: END IF;
289: RAISE;

Line 326: log_mesg(FND_LOG.LEVEL_STATEMENT,'CS_CF_UPG_UTL_PKG.Eval_SR_Addr_Display', 'site level value customized. Profile option value: ' || l_profile_option_value);

322: IF (l_level_id = 10001) THEN
323: -- There wasn't any seeded value for the site level. Therefore, this
324: -- must be a customization
325: l_upgrade_required := TRUE;
326: log_mesg(FND_LOG.LEVEL_STATEMENT,'CS_CF_UPG_UTL_PKG.Eval_SR_Addr_Display', 'site level value customized. Profile option value: ' || l_profile_option_value);
327: p_siteProfilesTable(p_site_index).profileOptionName := 'IBU_SR_ADDR_DISPLAY';
328: p_siteProfilesTable(p_site_index).profileOptionValue := l_profile_option_value;
329: p_site_index := p_site_index + 1;
330:

Line 335: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Addr_Display', 'appl level value customized. Profile option value: ' || l_profile_option_value);

331: ELSIF (l_level_id = 10002) THEN
332: -- There wasn't any seeded value for the app level. Therefore,
333: -- this must be a customization
334: l_upgrade_required := TRUE;
335: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Addr_Display', 'appl level value customized. Profile option value: ' || l_profile_option_value);
336: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Addr_Display', 'Application Id: ' || to_char(l_level_value));
337: IF NOT (Appl_Already_Exists(p_applTable, l_level_value)) THEN
338: p_ApplTable(p_appl_index) := l_level_value;
339: p_appl_index := p_appl_index + 1;

Line 336: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Addr_Display', 'Application Id: ' || to_char(l_level_value));

332: -- There wasn't any seeded value for the app level. Therefore,
333: -- this must be a customization
334: l_upgrade_required := TRUE;
335: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Addr_Display', 'appl level value customized. Profile option value: ' || l_profile_option_value);
336: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Addr_Display', 'Application Id: ' || to_char(l_level_value));
337: IF NOT (Appl_Already_Exists(p_applTable, l_level_value)) THEN
338: p_ApplTable(p_appl_index) := l_level_value;
339: p_appl_index := p_appl_index + 1;
340: END IF;

Line 345: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Addr_Display', 'resp level value customized. Profile option value: ' || l_profile_option_value);

341: ELSIF (l_level_id = 10003) THEN
342: -- There wasn't any seeded value for the resp level. Therefore,
343: -- this must be a customization
344: l_upgrade_required := TRUE;
345: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Addr_Display', 'resp level value customized. Profile option value: ' || l_profile_option_value);
346: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Addr_Display', 'Resp id: ' || to_char(l_level_value) || ' Resp Appl Id: ' || to_char(l_level_value_appl_id));
347: IF NOT (Resp_Already_Exists(p_RespTable, l_level_value, l_level_value_appl_id)) THEN
348: p_RespTable(p_resp_index).respId := l_level_value;
349: p_RespTable(p_resp_index).respApplId := l_level_value_appl_id;

Line 346: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Addr_Display', 'Resp id: ' || to_char(l_level_value) || ' Resp Appl Id: ' || to_char(l_level_value_appl_id));

342: -- There wasn't any seeded value for the resp level. Therefore,
343: -- this must be a customization
344: l_upgrade_required := TRUE;
345: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Addr_Display', 'resp level value customized. Profile option value: ' || l_profile_option_value);
346: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Addr_Display', 'Resp id: ' || to_char(l_level_value) || ' Resp Appl Id: ' || to_char(l_level_value_appl_id));
347: IF NOT (Resp_Already_Exists(p_RespTable, l_level_value, l_level_value_appl_id)) THEN
348: p_RespTable(p_resp_index).respId := l_level_value;
349: p_RespTable(p_resp_index).respApplId := l_level_value_appl_id;
350: p_resp_index := p_resp_index + 1;

Line 365: log_mesg(FND_LOG.LEVEL_UNEXPECTED, 'CS_CF_UPG_UTL_PKG.Eval_SR_Addr_Display', 'Exception in Eval_SR_Addr_Display');

361: return l_upgrade_required;
362:
363: EXCEPTION
364: WHEN OTHERS THEN
365: log_mesg(FND_LOG.LEVEL_UNEXPECTED, 'CS_CF_UPG_UTL_PKG.Eval_SR_Addr_Display', 'Exception in Eval_SR_Addr_Display');
366: IF (get_profile_option_values%ISOPEN) THEN
367: CLOSE get_profile_option_values;
368: END IF;
369: RAISE;

Line 408: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Addr_Mandatory', 'site level value customized. Profile option value: ' || l_profile_option_value);

404: IF (l_level_id = 10001) THEN
405: -- There wasn't any seeded value for the site level. Therefore, this
406: -- must be a customization
407: l_upgrade_required := TRUE;
408: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Addr_Mandatory', 'site level value customized. Profile option value: ' || l_profile_option_value);
409: p_siteProfilesTable(p_site_index).profileOptionName := 'IBU_SR_ADDR_MANDATORY';
410: p_siteProfilesTAble(p_site_index).profileOptionValue := l_profile_option_value;
411: p_site_index := p_site_index + 1;
412: ELSIF (l_level_id = 10002) THEN

Line 416: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Addr_Mandatory', 'appl level value customized. Profile option value: ' || l_profile_option_value);

412: ELSIF (l_level_id = 10002) THEN
413: -- There wasn't any seeded value for the app level. Therefore,
414: -- this must be a customization
415: l_upgrade_required := TRUE;
416: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Addr_Mandatory', 'appl level value customized. Profile option value: ' || l_profile_option_value);
417: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Addr_Mandatory','Application Id: ' || to_char(l_level_value));
418: IF NOT (Appl_Already_Exists(p_ApplTable, l_level_value)) THEN
419: p_ApplTable(p_appl_index) := l_level_value;
420: p_appl_index := p_appl_index + 1;

Line 417: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Addr_Mandatory','Application Id: ' || to_char(l_level_value));

413: -- There wasn't any seeded value for the app level. Therefore,
414: -- this must be a customization
415: l_upgrade_required := TRUE;
416: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Addr_Mandatory', 'appl level value customized. Profile option value: ' || l_profile_option_value);
417: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Addr_Mandatory','Application Id: ' || to_char(l_level_value));
418: IF NOT (Appl_Already_Exists(p_ApplTable, l_level_value)) THEN
419: p_ApplTable(p_appl_index) := l_level_value;
420: p_appl_index := p_appl_index + 1;
421: END IF;

Line 426: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Addr_Mandatory', 'resp level value customized. Profile option value: ' || l_profile_option_value);

422: ELSIF (l_level_id = 10003) THEN
423: -- There wasn't any seeded value for the resp level. Therefore,
424: -- this must be a customization
425: l_upgrade_required := TRUE;
426: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Addr_Mandatory', 'resp level value customized. Profile option value: ' || l_profile_option_value);
427: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Addr_Mandatory','Resp id: ' || to_char(l_level_value) || ' Resp Appl Id: ' || to_char(l_level_value_appl_id));
428: IF NOT (Resp_Already_Exists(p_RespTable, l_level_value, l_level_value_appl_id)) THEN
429: p_RespTable(p_resp_index).respId := l_level_value;
430: p_RespTable(p_resp_index).respApplId := l_level_value_appl_id;

Line 427: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Addr_Mandatory','Resp id: ' || to_char(l_level_value) || ' Resp Appl Id: ' || to_char(l_level_value_appl_id));

423: -- There wasn't any seeded value for the resp level. Therefore,
424: -- this must be a customization
425: l_upgrade_required := TRUE;
426: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Addr_Mandatory', 'resp level value customized. Profile option value: ' || l_profile_option_value);
427: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Addr_Mandatory','Resp id: ' || to_char(l_level_value) || ' Resp Appl Id: ' || to_char(l_level_value_appl_id));
428: IF NOT (Resp_Already_Exists(p_RespTable, l_level_value, l_level_value_appl_id)) THEN
429: p_RespTable(p_resp_index).respId := l_level_value;
430: p_RespTable(p_resp_index).respApplId := l_level_value_appl_id;
431: p_resp_index := p_resp_index + 1;

Line 446: log_mesg(FND_LOG.LEVEL_UNEXPECTED, 'CS_CF_UPG_UTL_PKG.Eval_SR_Addr_Mandatory', 'Exception in Eval_SR_Addr_Mandatory');

442: return l_upgrade_required;
443:
444: EXCEPTION
445: WHEN OTHERS THEN
446: log_mesg(FND_LOG.LEVEL_UNEXPECTED, 'CS_CF_UPG_UTL_PKG.Eval_SR_Addr_Mandatory', 'Exception in Eval_SR_Addr_Mandatory');
447: IF (get_profile_option_values%ISOPEN) THEN
448: CLOSE get_profile_option_values;
449: END IF;
450: RAISE;

Line 489: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_BillTo_Address', 'site level value customized. Profile option value: ' || l_profile_option_value);

485: IF (l_level_id = 10001) THEN
486: -- check if the value set at site is equal to
487: -- value seeded out-of-the-box
488: IF (l_profile_option_value <> 'NOTDISPLAYED') THEN
489: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_BillTo_Address', 'site level value customized. Profile option value: ' || l_profile_option_value);
490: p_siteProfilesTable(p_site_index).profileOptionName := 'IBU_SR_BILLTO_ADDRESS_OPTION';
491: p_siteProfilesTAble(p_site_index).profileOptionValue := l_profile_option_value;
492: p_site_index := p_site_index + 1;
493: l_upgrade_required := TRUE;

Line 499: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_BillTo_Address', 'appl level value customized. Profile option value: ' || l_profile_option_value);

495: ELSIF (l_level_id = 10002) THEN
496: -- There wasn't any seeded value for the app level. Therefore,
497: -- this must be a customization
498: l_upgrade_required := TRUE;
499: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_BillTo_Address', 'appl level value customized. Profile option value: ' || l_profile_option_value);
500: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_BillTo_Address','Application Id: ' || to_char(l_level_value));
501: IF NOT (Appl_Already_Exists(p_ApplTable, l_level_value)) THEN
502: p_ApplTable(p_appl_index) := l_level_value;
503: p_appl_index := p_appl_index + 1;

Line 500: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_BillTo_Address','Application Id: ' || to_char(l_level_value));

496: -- There wasn't any seeded value for the app level. Therefore,
497: -- this must be a customization
498: l_upgrade_required := TRUE;
499: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_BillTo_Address', 'appl level value customized. Profile option value: ' || l_profile_option_value);
500: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_BillTo_Address','Application Id: ' || to_char(l_level_value));
501: IF NOT (Appl_Already_Exists(p_ApplTable, l_level_value)) THEN
502: p_ApplTable(p_appl_index) := l_level_value;
503: p_appl_index := p_appl_index + 1;
504: END IF;

Line 509: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_BillTo_Address', 'resp level value customized. Profile option value: ' || l_profile_option_value);

505: ELSIF (l_level_id = 10003) THEN
506: -- there should not have been a value set at the resp level
507: -- If there is a value, then it is customized
508: l_upgrade_required := TRUE;
509: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_BillTo_Address', 'resp level value customized. Profile option value: ' || l_profile_option_value);
510: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_BillTo_Address', 'Resp id: ' || to_char(l_level_value) || ' Resp Appl Id: ' || to_char(l_level_value_appl_id));
511: IF NOT (Resp_Already_Exists(p_respTable, l_level_value, l_level_value_appl_id)) THEN
512: p_respTable(p_resp_index).respId := l_level_value;
513: p_respTable(p_resp_index).respApplId := l_level_value_appl_id;

Line 510: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_BillTo_Address', 'Resp id: ' || to_char(l_level_value) || ' Resp Appl Id: ' || to_char(l_level_value_appl_id));

506: -- there should not have been a value set at the resp level
507: -- If there is a value, then it is customized
508: l_upgrade_required := TRUE;
509: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_BillTo_Address', 'resp level value customized. Profile option value: ' || l_profile_option_value);
510: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_BillTo_Address', 'Resp id: ' || to_char(l_level_value) || ' Resp Appl Id: ' || to_char(l_level_value_appl_id));
511: IF NOT (Resp_Already_Exists(p_respTable, l_level_value, l_level_value_appl_id)) THEN
512: p_respTable(p_resp_index).respId := l_level_value;
513: p_respTable(p_resp_index).respApplId := l_level_value_appl_id;
514: p_resp_index := p_resp_index + 1;

Line 529: log_mesg(FND_LOG.LEVEL_UNEXPECTED, 'CS_CF_UPG_UTL_PKG.Eval_SR_BillTo_Address', 'Exception in Eval_SR_BillTo_Address_Option');

525: return l_upgrade_required;
526:
527: EXCEPTION
528: WHEN OTHERS THEN
529: log_mesg(FND_LOG.LEVEL_UNEXPECTED, 'CS_CF_UPG_UTL_PKG.Eval_SR_BillTo_Address', 'Exception in Eval_SR_BillTo_Address_Option');
530: IF (get_profile_option_values%ISOPEN) THEN
531: CLOSE get_profile_option_values;
532: END IF;
533: RAISE;

Line 571: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_BillTo_Contact', 'site level value customized. Profile option value: ' || l_profile_option_value);

567: IF (l_level_id = 10001) THEN
568: -- check if the value set at site is equal to
569: -- value seeded out-of-the-box
570: IF (l_profile_option_value <> 'NOTDISPLAYED') THEN
571: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_BillTo_Contact', 'site level value customized. Profile option value: ' || l_profile_option_value);
572: p_siteProfilesTable(p_site_index).profileOptionName := 'IBU_SR_BILLTO_CONTACT_OPTION';
573: p_siteProfilesTAble(p_site_index).profileOptionValue := l_profile_option_value;
574: p_site_index := p_site_index + 1;
575: l_upgrade_required := TRUE;

Line 581: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_BillTo_Contact', 'appl level value customized. Profile option value: ' || l_profile_option_value);

577: ELSIF (l_level_id = 10002) THEN
578: -- There wasn't any seeded value for the app level. Therefore,
579: -- this must be a customization
580: l_upgrade_required := TRUE;
581: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_BillTo_Contact', 'appl level value customized. Profile option value: ' || l_profile_option_value);
582: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_BillTo_Contact','Application Id: ' || to_char(l_level_value));
583: IF NOT (Appl_Already_Exists(p_ApplTable, l_level_value)) THEN
584: p_ApplTable(p_appl_index) := l_level_value;
585: p_appl_index := p_appl_index + 1;

Line 582: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_BillTo_Contact','Application Id: ' || to_char(l_level_value));

578: -- There wasn't any seeded value for the app level. Therefore,
579: -- this must be a customization
580: l_upgrade_required := TRUE;
581: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_BillTo_Contact', 'appl level value customized. Profile option value: ' || l_profile_option_value);
582: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_BillTo_Contact','Application Id: ' || to_char(l_level_value));
583: IF NOT (Appl_Already_Exists(p_ApplTable, l_level_value)) THEN
584: p_ApplTable(p_appl_index) := l_level_value;
585: p_appl_index := p_appl_index + 1;
586: END IF;

Line 590: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_BillTo_Contact', 'resp level value customized. Profile option value: ' || l_profile_option_value);

586: END IF;
587: ELSIF (l_level_id = 10003) THEN
588: -- there should not have been a value set at the resp level
589: -- If there is a value, then it is customized
590: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_BillTo_Contact', 'resp level value customized. Profile option value: ' || l_profile_option_value);
591: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_BillTo_Contact', 'Resp id: ' || to_char(l_level_value) || ' Resp Appl Id: ' || to_char(l_level_value_appl_id));
592: l_upgrade_required := TRUE;
593: IF NOT (Resp_Already_Exists(p_respTable, l_level_value, l_level_value_appl_id)) THEN
594: p_respTable(p_resp_index).respId := l_level_value;

Line 591: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_BillTo_Contact', 'Resp id: ' || to_char(l_level_value) || ' Resp Appl Id: ' || to_char(l_level_value_appl_id));

587: ELSIF (l_level_id = 10003) THEN
588: -- there should not have been a value set at the resp level
589: -- If there is a value, then it is customized
590: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_BillTo_Contact', 'resp level value customized. Profile option value: ' || l_profile_option_value);
591: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_BillTo_Contact', 'Resp id: ' || to_char(l_level_value) || ' Resp Appl Id: ' || to_char(l_level_value_appl_id));
592: l_upgrade_required := TRUE;
593: IF NOT (Resp_Already_Exists(p_respTable, l_level_value, l_level_value_appl_id)) THEN
594: p_respTable(p_resp_index).respId := l_level_value;
595: p_respTable(p_resp_index).respApplId := l_level_value_appl_id;

Line 611: log_mesg(FND_LOG.LEVEL_UNEXPECTED, 'CS_CF_UPG_UTL_PKG.Eval_SR_BillTo_Contact_Option', 'Exception in Eval_SR_BillTo_Contact_Option');

607: return l_upgrade_required;
608:
609: EXCEPTION
610: WHEN OTHERS THEN
611: log_mesg(FND_LOG.LEVEL_UNEXPECTED, 'CS_CF_UPG_UTL_PKG.Eval_SR_BillTo_Contact_Option', 'Exception in Eval_SR_BillTo_Contact_Option');
612: IF (get_profile_option_values%ISOPEN) THEN
613: CLOSE get_profile_option_values;
614: END IF;
615: RAISE;

Line 653: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_ShipTo_Address', 'site level value customized. Profile option value: ' || l_profile_option_value);

649: IF (l_level_id = 10001) THEN
650: -- check if the value set at site is equal to
651: -- value seeded out-of-the-box
652: IF (l_profile_option_value <> 'NOTDISPLAYED') THEN
653: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_ShipTo_Address', 'site level value customized. Profile option value: ' || l_profile_option_value);
654: p_siteProfilesTable(p_site_index).profileOptionName := 'IBU_A_SR_SHIPTO_ADDRESS_OPTION';
655: p_siteProfilesTable(p_site_index).profileOptionValue := l_profile_option_value;
656: p_site_index := p_site_index + 1;
657: l_upgrade_required := TRUE;

Line 663: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_ShipTo_Address_Option', 'appl level value customized. Profile option value: ' || l_profile_option_value);

659: ELSIF (l_level_id = 10002) THEN
660: -- there should not have been a value set at the appl level
661: -- if there is a value, then it is customized
662: l_upgrade_required := TRUE;
663: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_ShipTo_Address_Option', 'appl level value customized. Profile option value: ' || l_profile_option_value);
664: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_ShipTo_Address_Option', 'Application Id: ' || to_char(l_level_value));
665: IF NOT(Appl_Already_Exists(p_applTable, l_level_value)) THEN
666: p_applTable(p_appl_index) := l_level_value;
667: p_appl_index := p_appl_index + 1;

Line 664: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_ShipTo_Address_Option', 'Application Id: ' || to_char(l_level_value));

660: -- there should not have been a value set at the appl level
661: -- if there is a value, then it is customized
662: l_upgrade_required := TRUE;
663: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_ShipTo_Address_Option', 'appl level value customized. Profile option value: ' || l_profile_option_value);
664: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_ShipTo_Address_Option', 'Application Id: ' || to_char(l_level_value));
665: IF NOT(Appl_Already_Exists(p_applTable, l_level_value)) THEN
666: p_applTable(p_appl_index) := l_level_value;
667: p_appl_index := p_appl_index + 1;
668: END IF;

Line 674: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_ShipTo_Address_Option', 'resp level value customized. Profile option value: ' || l_profile_option_value);

670: ELSIF (l_level_id = 10003) THEN
671: -- there should not have been a value set at the resp level
672: -- If there is a value, then it is customized
673: l_upgrade_required := TRUE;
674: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_ShipTo_Address_Option', 'resp level value customized. Profile option value: ' || l_profile_option_value);
675: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_ShipTo_Address_Option', 'Resp id: ' || to_char(l_level_value) || ' Resp Appl Id: ' || to_char(l_level_value_appl_id));
676: l_upgrade_required := TRUE;
677: IF NOT (Resp_Already_Exists(p_respTable, l_level_value, l_level_value_appl_id)) THEN
678: p_respTable(p_resp_index).respId := l_level_value;

Line 675: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_ShipTo_Address_Option', 'Resp id: ' || to_char(l_level_value) || ' Resp Appl Id: ' || to_char(l_level_value_appl_id));

671: -- there should not have been a value set at the resp level
672: -- If there is a value, then it is customized
673: l_upgrade_required := TRUE;
674: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_ShipTo_Address_Option', 'resp level value customized. Profile option value: ' || l_profile_option_value);
675: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_ShipTo_Address_Option', 'Resp id: ' || to_char(l_level_value) || ' Resp Appl Id: ' || to_char(l_level_value_appl_id));
676: l_upgrade_required := TRUE;
677: IF NOT (Resp_Already_Exists(p_respTable, l_level_value, l_level_value_appl_id)) THEN
678: p_respTable(p_resp_index).respId := l_level_value;
679: p_respTable(p_resp_index).respApplId := l_level_value_appl_id;

Line 695: log_mesg(FND_LOG.LEVEL_UNEXPECTED, 'CS_CF_UPG_UTL_PKG.Eval_SR_ShipTo_Address_Option', 'Exception in Eval_SR_ShipTo_Address_Option');

691: return l_upgrade_required;
692:
693: EXCEPTION
694: WHEN OTHERS THEN
695: log_mesg(FND_LOG.LEVEL_UNEXPECTED, 'CS_CF_UPG_UTL_PKG.Eval_SR_ShipTo_Address_Option', 'Exception in Eval_SR_ShipTo_Address_Option');
696: IF (get_profile_option_values%ISOPEN) THEN
697: CLOSE get_profile_option_values;
698: END IF;
699: RAISE;

Line 737: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_ShipTo_Contact', 'site level value customized. Profile option value: ' || l_profile_option_value);

733: IF (l_level_id = 10001) THEN
734: -- check if the value set at site is equal to
735: -- value seeded out-of-the-box
736: IF (l_profile_option_value <> 'NOTDISPLAYED') THEN
737: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_ShipTo_Contact', 'site level value customized. Profile option value: ' || l_profile_option_value);
738: p_siteProfilesTable(p_site_index).profileOptionName := 'IBU_A_SR_SHIPTO_CONTACT_OPTION';
739: p_siteProfilesTable(p_site_index).profileOptionValue := l_profile_option_value;
740: p_site_index := p_site_index + 1;
741: l_upgrade_required := TRUE;

Line 747: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_ShipTo_Contact_Option', 'appl level value customized. Profile option value: ' || l_profile_option_value);

743: ELSIF (l_level_id = 10002) THEN
744: -- there should not have been a value set at the appl level
745: -- if there is a value, then it is customized
746: l_upgrade_required := TRUE;
747: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_ShipTo_Contact_Option', 'appl level value customized. Profile option value: ' || l_profile_option_value);
748: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_ShipTo_Contact_Option', 'Application Id: ' || to_char(l_level_value));
749: IF NOT(Appl_Already_Exists(p_applTable, l_level_value)) THEN
750: p_applTable(p_appl_index) := l_level_value;
751: p_appl_index := p_appl_index + 1;

Line 748: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_ShipTo_Contact_Option', 'Application Id: ' || to_char(l_level_value));

744: -- there should not have been a value set at the appl level
745: -- if there is a value, then it is customized
746: l_upgrade_required := TRUE;
747: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_ShipTo_Contact_Option', 'appl level value customized. Profile option value: ' || l_profile_option_value);
748: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_ShipTo_Contact_Option', 'Application Id: ' || to_char(l_level_value));
749: IF NOT(Appl_Already_Exists(p_applTable, l_level_value)) THEN
750: p_applTable(p_appl_index) := l_level_value;
751: p_appl_index := p_appl_index + 1;
752: END IF;

Line 757: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_ShipTo_Contact_Option', 'resp level value customized. Profile option value: ' || l_profile_option_value);

753: ELSIF (l_level_id = 10003) THEN
754: -- there should not have been a value set at the resp level
755: -- If there is a value, then it is customized
756: l_upgrade_required := TRUE;
757: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_ShipTo_Contact_Option', 'resp level value customized. Profile option value: ' || l_profile_option_value);
758: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_ShipTo_Contact_Option','Resp id: ' || to_char(l_level_value) || ' Resp Appl Id: ' || to_char(l_level_value_appl_id));
759: l_upgrade_required := TRUE;
760: IF NOT (Resp_Already_Exists(p_respTable, l_level_value, l_level_value_appl_id)) THEN
761: p_respTable(p_resp_index).respId := l_level_value;

Line 758: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_ShipTo_Contact_Option','Resp id: ' || to_char(l_level_value) || ' Resp Appl Id: ' || to_char(l_level_value_appl_id));

754: -- there should not have been a value set at the resp level
755: -- If there is a value, then it is customized
756: l_upgrade_required := TRUE;
757: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_ShipTo_Contact_Option', 'resp level value customized. Profile option value: ' || l_profile_option_value);
758: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_ShipTo_Contact_Option','Resp id: ' || to_char(l_level_value) || ' Resp Appl Id: ' || to_char(l_level_value_appl_id));
759: l_upgrade_required := TRUE;
760: IF NOT (Resp_Already_Exists(p_respTable, l_level_value, l_level_value_appl_id)) THEN
761: p_respTable(p_resp_index).respId := l_level_value;
762: p_respTable(p_resp_index).respApplId := l_level_value_appl_id;

Line 778: log_mesg(FND_LOG.LEVEL_UNEXPECTED, 'CS_CF_UPG_UTL_PKG.Eval_SR_ShipTo_Contact_Option', 'Exception in Eval_SR_ShipTo_Contact_Option');

774: return l_upgrade_required;
775:
776: EXCEPTION
777: WHEN OTHERS THEN
778: log_mesg(FND_LOG.LEVEL_UNEXPECTED, 'CS_CF_UPG_UTL_PKG.Eval_SR_ShipTo_Contact_Option', 'Exception in Eval_SR_ShipTo_Contact_Option');
779: IF (get_profile_option_values%ISOPEN) THEN
780: CLOSE get_profile_option_values;
781: END IF;
782: RAISE;

Line 821: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_InstalledAt_Addr', 'site level value customized. Profile option value: ' || l_profile_option_value);

817: IF (l_level_id = 10001) THEN
818: -- check if the value set at site is equal to
819: -- value seeded out-of-the-box
820: IF (l_profile_option_value <> 'NOTDISPLAYED') THEN
821: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_InstalledAt_Addr', 'site level value customized. Profile option value: ' || l_profile_option_value);
822: p_siteProfilesTable(p_site_index).profileOptionName := 'IBU_A_SR_INSTALLEDAT_ADDRESS_OPTION';
823: p_siteProfilesTable(p_site_index).profileOptionValue := l_profile_option_value;
824: p_site_index := p_site_index + 1;
825: l_upgrade_required := TRUE;

Line 831: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_InstalledAt_Addr', 'appl level value customized. Profile option value: ' || l_profile_option_value);

827: ELSIF (l_level_id = 10002) THEN
828: -- there should not have been a value set at the appl level
829: -- if there is a value, then it is customized
830: l_upgrade_required := TRUE;
831: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_InstalledAt_Addr', 'appl level value customized. Profile option value: ' || l_profile_option_value);
832: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_InstalledAt_Addr', 'Application Id: ' || to_char(l_level_value));
833: IF NOT(Appl_Already_Exists(p_applTable, l_level_value)) THEN
834: p_applTable(p_appl_index) := l_level_value;
835: p_appl_index := p_appl_index + 1;

Line 832: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_InstalledAt_Addr', 'Application Id: ' || to_char(l_level_value));

828: -- there should not have been a value set at the appl level
829: -- if there is a value, then it is customized
830: l_upgrade_required := TRUE;
831: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_InstalledAt_Addr', 'appl level value customized. Profile option value: ' || l_profile_option_value);
832: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_InstalledAt_Addr', 'Application Id: ' || to_char(l_level_value));
833: IF NOT(Appl_Already_Exists(p_applTable, l_level_value)) THEN
834: p_applTable(p_appl_index) := l_level_value;
835: p_appl_index := p_appl_index + 1;
836: END IF;

Line 841: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_InstalledAt_Addr', 'resp level value customized. Profile option value: ' || l_profile_option_value);

837: ELSIF (l_level_id = 10003) THEN
838: -- there should not have been a value set at the resp level
839: -- If there is a value, then it is customized
840: l_upgrade_required := TRUE;
841: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_InstalledAt_Addr', 'resp level value customized. Profile option value: ' || l_profile_option_value);
842: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_InstalledAt_Addr', 'Resp id: ' || to_char(l_level_value) || ' Resp Appl Id: ' || to_char(l_level_value_appl_id));
843: l_upgrade_required := TRUE;
844: IF NOT (Resp_Already_Exists(p_respTable, l_level_value, l_level_value_appl_id)) THEN
845: p_respTable(p_resp_index).respId := l_level_value;

Line 842: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_InstalledAt_Addr', 'Resp id: ' || to_char(l_level_value) || ' Resp Appl Id: ' || to_char(l_level_value_appl_id));

838: -- there should not have been a value set at the resp level
839: -- If there is a value, then it is customized
840: l_upgrade_required := TRUE;
841: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_InstalledAt_Addr', 'resp level value customized. Profile option value: ' || l_profile_option_value);
842: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_InstalledAt_Addr', 'Resp id: ' || to_char(l_level_value) || ' Resp Appl Id: ' || to_char(l_level_value_appl_id));
843: l_upgrade_required := TRUE;
844: IF NOT (Resp_Already_Exists(p_respTable, l_level_value, l_level_value_appl_id)) THEN
845: p_respTable(p_resp_index).respId := l_level_value;
846: p_respTable(p_resp_index).respApplId := l_level_value_appl_id;

Line 862: log_mesg(FND_LOG.LEVEL_UNEXPECTED, 'CS_CF_UPG_UTL_PKG.Eval_SR_InstalledAt_Addr', 'Exception in Eval_SR_InstalledAt_Address');

858: return l_upgrade_required;
859:
860: EXCEPTION
861: WHEN OTHERS THEN
862: log_mesg(FND_LOG.LEVEL_UNEXPECTED, 'CS_CF_UPG_UTL_PKG.Eval_SR_InstalledAt_Addr', 'Exception in Eval_SR_InstalledAt_Address');
863: IF (get_profile_option_values%ISOPEN) THEN
864: CLOSE get_profile_option_values;
865: END IF;
866: RAISE;

Line 906: log_mesg(FND_LOG.LEVEL_STATEMENT,'CS_CF_UPG_UTL_PKG.Eval_SR_Attachment_Option', 'site level value customized. Profile option value: ' || l_profile_option_value);

902: IF (l_level_id = 10001) THEN
903: -- check if the value set at site is equal to
904: -- value seeded out-of-the-box
905: IF (l_profile_option_value <> 'SHOWDURINGBOTH') THEN
906: log_mesg(FND_LOG.LEVEL_STATEMENT,'CS_CF_UPG_UTL_PKG.Eval_SR_Attachment_Option', 'site level value customized. Profile option value: ' || l_profile_option_value);
907: p_siteProfilesTable(p_site_index).profileOptionName := 'IBU_A_SR_ATTACHMENT_OPTION';
908: p_siteProfilesTable(p_site_index).profileOptionValue := l_profile_option_value;
909: p_site_index := p_site_index + 1;
910: l_upgrade_required := TRUE;

Line 916: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Attachment_Option', 'appl level value customized. Profile option value: ' || l_profile_option_value);

912: ELSIF (l_level_id = 10002) THEN
913: -- there should not have been a value set at the appl level
914: -- if there is a value, then it is customized
915: l_upgrade_required := TRUE;
916: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Attachment_Option', 'appl level value customized. Profile option value: ' || l_profile_option_value);
917: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Attachment_Option', 'Application Id: ' || to_char(l_level_value));
918: IF NOT(Appl_Already_Exists(p_applTable, l_level_value)) THEN
919: p_applTable(p_appl_index) := l_level_value;
920: p_appl_index := p_appl_index + 1;

Line 917: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Attachment_Option', 'Application Id: ' || to_char(l_level_value));

913: -- there should not have been a value set at the appl level
914: -- if there is a value, then it is customized
915: l_upgrade_required := TRUE;
916: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Attachment_Option', 'appl level value customized. Profile option value: ' || l_profile_option_value);
917: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Attachment_Option', 'Application Id: ' || to_char(l_level_value));
918: IF NOT(Appl_Already_Exists(p_applTable, l_level_value)) THEN
919: p_applTable(p_appl_index) := l_level_value;
920: p_appl_index := p_appl_index + 1;
921: END IF;

Line 926: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Attachment_Option', 'resp level value customized. Profile option value: ' || l_profile_option_value);

922: ELSIF (l_level_id = 10003) THEN
923: -- there should not have been a value set at the resp level
924: -- If there is a value, then it is customized
925: l_upgrade_required := TRUE;
926: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Attachment_Option', 'resp level value customized. Profile option value: ' || l_profile_option_value);
927: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Attachment_Option','Resp id: ' || to_char(l_level_value) || ' Resp Appl Id: ' || to_char(l_level_value_appl_id));
928: l_upgrade_required := TRUE;
929: IF NOT (Resp_Already_Exists(p_respTable, l_level_value, l_level_value_appl_id)) THEN
930: p_respTable(p_resp_index).respId := l_level_value;

Line 927: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Attachment_Option','Resp id: ' || to_char(l_level_value) || ' Resp Appl Id: ' || to_char(l_level_value_appl_id));

923: -- there should not have been a value set at the resp level
924: -- If there is a value, then it is customized
925: l_upgrade_required := TRUE;
926: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Attachment_Option', 'resp level value customized. Profile option value: ' || l_profile_option_value);
927: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Attachment_Option','Resp id: ' || to_char(l_level_value) || ' Resp Appl Id: ' || to_char(l_level_value_appl_id));
928: l_upgrade_required := TRUE;
929: IF NOT (Resp_Already_Exists(p_respTable, l_level_value, l_level_value_appl_id)) THEN
930: p_respTable(p_resp_index).respId := l_level_value;
931: p_respTable(p_resp_index).respApplId := l_level_value_appl_id;

Line 947: log_mesg(FND_LOG.LEVEL_UNEXPECTED, 'CS_CF_UPG_UTL_PKG.Eval_SR_Attachment_Option', 'Exception in Eval_SR_ShipTo_Address_Option');

943: return l_upgrade_required;
944:
945: EXCEPTION
946: WHEN OTHERS THEN
947: log_mesg(FND_LOG.LEVEL_UNEXPECTED, 'CS_CF_UPG_UTL_PKG.Eval_SR_Attachment_Option', 'Exception in Eval_SR_ShipTo_Address_Option');
948: IF (get_profile_option_values%ISOPEN) THEN
949: CLOSE get_profile_option_values;
950: END IF;
951: RAISE;

Line 987: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Task_Display', 'site level value customized. Profile option value: ' || l_profile_option_value);

983: l_profile_option_value;
984: WHILE get_profile_option_values%FOUND LOOP
985: IF (l_level_id = 10001) THEN
986: IF (l_profile_option_value <> 'N') THEN
987: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Task_Display', 'site level value customized. Profile option value: ' || l_profile_option_value);
988: p_siteProfilesTable(p_site_index).profileOptionName := 'IBU_SR_TASK_DISPLAY';
989: p_siteProfilesTable(p_site_index).profileOptionValue := l_profile_option_value;
990: p_site_index := p_site_index + 1;
991: l_upgrade_required := TRUE;

Line 997: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Task_Display', 'appl level value customized. Profile option value: ' || l_profile_option_value);

993: ELSIF (l_level_id = 10002) THEN
994: -- There wasn't any seeded value for the app level. Therefore,
995: -- this must be a customization
996: l_upgrade_required := TRUE;
997: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Task_Display', 'appl level value customized. Profile option value: ' || l_profile_option_value);
998: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Task_Display', 'Application Id: ' || to_char(l_level_value));
999: IF NOT (Appl_Already_Exists(p_ApplTable, l_level_value)) THEN
1000: p_ApplTable(p_appl_index) := l_level_value;
1001: p_appl_index := p_appl_index + 1;

Line 998: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Task_Display', 'Application Id: ' || to_char(l_level_value));

994: -- There wasn't any seeded value for the app level. Therefore,
995: -- this must be a customization
996: l_upgrade_required := TRUE;
997: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Task_Display', 'appl level value customized. Profile option value: ' || l_profile_option_value);
998: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Task_Display', 'Application Id: ' || to_char(l_level_value));
999: IF NOT (Appl_Already_Exists(p_ApplTable, l_level_value)) THEN
1000: p_ApplTable(p_appl_index) := l_level_value;
1001: p_appl_index := p_appl_index + 1;
1002: END IF;

Line 1007: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Task_Display', 'resp level value customized. Profile option value: ' || l_profile_option_value);

1003: ELSIF (l_level_id = 10003) THEN
1004: -- There wasn't any seeded value for the resp level. Therefore,
1005: -- this must be a customization
1006: l_upgrade_required := TRUE;
1007: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Task_Display', 'resp level value customized. Profile option value: ' || l_profile_option_value);
1008: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Task_Display', 'Resp id: ' || to_char(l_level_value) || ' Resp Appl Id: ' || to_char(l_level_value_appl_id));
1009: IF NOT(Resp_Already_Exists(p_RespTable, l_level_value, l_level_value_appl_id)) THEN
1010: p_RespTable(p_resp_index).respId := l_level_value;
1011: p_RespTable(p_resp_index).respApplId := l_level_value_appl_id;

Line 1008: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Task_Display', 'Resp id: ' || to_char(l_level_value) || ' Resp Appl Id: ' || to_char(l_level_value_appl_id));

1004: -- There wasn't any seeded value for the resp level. Therefore,
1005: -- this must be a customization
1006: l_upgrade_required := TRUE;
1007: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Task_Display', 'resp level value customized. Profile option value: ' || l_profile_option_value);
1008: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Task_Display', 'Resp id: ' || to_char(l_level_value) || ' Resp Appl Id: ' || to_char(l_level_value_appl_id));
1009: IF NOT(Resp_Already_Exists(p_RespTable, l_level_value, l_level_value_appl_id)) THEN
1010: p_RespTable(p_resp_index).respId := l_level_value;
1011: p_RespTable(p_resp_index).respApplId := l_level_value_appl_id;
1012: p_resp_index := p_resp_index + 1;

Line 1027: log_mesg(FND_LOG.LEVEL_UNEXPECTED, 'CS_CF_UPG_UTL_PKG.Eval_SR_Task_Display','Exception in Eval_SR_ShipTo_Address_Option');

1023: return l_upgrade_required;
1024:
1025: EXCEPTION
1026: WHEN OTHERS THEN
1027: log_mesg(FND_LOG.LEVEL_UNEXPECTED, 'CS_CF_UPG_UTL_PKG.Eval_SR_Task_Display','Exception in Eval_SR_ShipTo_Address_Option');
1028: IF (get_profile_option_values%ISOPEN) THEN
1029: CLOSE get_profile_option_values;
1030: END IF;
1031: RAISE;

Line 1070: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Enable_Interaction_Logging', 'site level value customized. Profile option value: ' || l_profile_option_value);

1066: IF (l_level_id = 10001) THEN
1067: -- check if the value set at site is equal to
1068: -- value seeded out-of-the-box
1069: IF (l_profile_option_value <> 'N') THEN
1070: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Enable_Interaction_Logging', 'site level value customized. Profile option value: ' || l_profile_option_value);
1071: p_siteProfilesTable(p_site_index).profileOptionName := 'IBU_A_SR_ENABLE_INTERACTION_LOGGING';
1072: p_siteProfilesTable(p_site_index).profileOptionValue := l_profile_option_value;
1073: p_site_index := p_site_index + 1;
1074: l_upgrade_required := TRUE;

Line 1080: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Enable_Interaction_Logging', 'appl level value customized. Profile option value: ' || l_profile_option_value);

1076: ELSIF (l_level_id = 10002) THEN
1077: -- There wasn't any seeded value for the app level. Therefore,
1078: -- this must be a customization
1079: l_upgrade_required := TRUE;
1080: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Enable_Interaction_Logging', 'appl level value customized. Profile option value: ' || l_profile_option_value);
1081: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Enable_Interaction_Logging', 'Application Id: ' || to_char(l_level_value));
1082: IF NOT (Appl_Already_Exists(p_ApplTable, l_level_value)) THEN
1083: p_ApplTable(p_appl_index) := l_level_value;
1084: p_appl_index := p_appl_index + 1;

Line 1081: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Enable_Interaction_Logging', 'Application Id: ' || to_char(l_level_value));

1077: -- There wasn't any seeded value for the app level. Therefore,
1078: -- this must be a customization
1079: l_upgrade_required := TRUE;
1080: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Enable_Interaction_Logging', 'appl level value customized. Profile option value: ' || l_profile_option_value);
1081: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Enable_Interaction_Logging', 'Application Id: ' || to_char(l_level_value));
1082: IF NOT (Appl_Already_Exists(p_ApplTable, l_level_value)) THEN
1083: p_ApplTable(p_appl_index) := l_level_value;
1084: p_appl_index := p_appl_index + 1;
1085: END IF;

Line 1090: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Enable_Interaction_Logging', 'resp level value customized. Profile option value: ' || l_profile_option_value);

1086: ELSIF (l_level_id = 10003) THEN
1087: -- there should not have been a value set at the resp level
1088: -- If there is a value, then it is customized
1089: l_upgrade_required := TRUE;
1090: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Enable_Interaction_Logging', 'resp level value customized. Profile option value: ' || l_profile_option_value);
1091: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Enable_Interaction_Logging', 'Resp id: ' || to_char(l_level_value) || ' Resp Appl Id: ' || to_char(l_level_value_appl_id));
1092: IF NOT (Resp_Already_Exists(p_respTable, l_level_value, l_level_value_appl_id)) THEN
1093: p_respTable(p_resp_index).respId := l_level_value;
1094: p_respTable(p_resp_index).respApplId := l_level_value_appl_id;

Line 1091: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Enable_Interaction_Logging', 'Resp id: ' || to_char(l_level_value) || ' Resp Appl Id: ' || to_char(l_level_value_appl_id));

1087: -- there should not have been a value set at the resp level
1088: -- If there is a value, then it is customized
1089: l_upgrade_required := TRUE;
1090: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Enable_Interaction_Logging', 'resp level value customized. Profile option value: ' || l_profile_option_value);
1091: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Enable_Interaction_Logging', 'Resp id: ' || to_char(l_level_value) || ' Resp Appl Id: ' || to_char(l_level_value_appl_id));
1092: IF NOT (Resp_Already_Exists(p_respTable, l_level_value, l_level_value_appl_id)) THEN
1093: p_respTable(p_resp_index).respId := l_level_value;
1094: p_respTable(p_resp_index).respApplId := l_level_value_appl_id;
1095: p_resp_index := p_resp_index + 1;

Line 1110: log_mesg(FND_LOG.LEVEL_UNEXPECTED, 'CS_CF_UPG_UTL_PKG.Eval_SR_Enable_Interact_Log', 'Exception in Eval_SR_Enable_Interact_Log');

1106: return l_upgrade_required;
1107:
1108: EXCEPTION
1109: WHEN OTHERS THEN
1110: log_mesg(FND_LOG.LEVEL_UNEXPECTED, 'CS_CF_UPG_UTL_PKG.Eval_SR_Enable_Interact_Log', 'Exception in Eval_SR_Enable_Interact_Log');
1111: IF (get_profile_option_values%ISOPEN) THEN
1112: CLOSE get_profile_option_values;
1113: END IF;
1114: RAISE;

Line 1150: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_KB_Option','site level value customized. Profile option value: ' || l_profile_option_value);

1146: l_profile_option_value;
1147: WHILE get_profile_option_values%FOUND LOOP
1148: IF (l_level_id = 10001) THEN
1149: IF (l_profile_option_value <> 'PROMPT') THEN
1150: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_KB_Option','site level value customized. Profile option value: ' || l_profile_option_value);
1151: p_siteProfilesTable(p_site_index).profileOptionName := 'IBU_A_SR_KB_OPTION';
1152: p_siteProfilesTable(p_site_index).profileOptionValue := l_profile_option_value;
1153: p_site_index := p_site_index + 1;
1154:

Line 1161: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_KB_Option', 'appl level value customized. Profile option value: ' || l_profile_option_value);

1157: ELSIF (l_level_id = 10002) THEN
1158: -- There wasn't any seeded value for the app level. Therefore,
1159: -- this must be a customization
1160: l_upgrade_required := TRUE;
1161: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_KB_Option', 'appl level value customized. Profile option value: ' || l_profile_option_value);
1162: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_KB_Option', 'Application Id: ' || to_char(l_level_value));
1163: IF NOT (Appl_Already_Exists(p_ApplTable, l_level_value)) THEN
1164: p_ApplTable(p_appl_index) := l_level_value;
1165: p_appl_index := p_appl_index + 1;

Line 1162: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_KB_Option', 'Application Id: ' || to_char(l_level_value));

1158: -- There wasn't any seeded value for the app level. Therefore,
1159: -- this must be a customization
1160: l_upgrade_required := TRUE;
1161: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_KB_Option', 'appl level value customized. Profile option value: ' || l_profile_option_value);
1162: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_KB_Option', 'Application Id: ' || to_char(l_level_value));
1163: IF NOT (Appl_Already_Exists(p_ApplTable, l_level_value)) THEN
1164: p_ApplTable(p_appl_index) := l_level_value;
1165: p_appl_index := p_appl_index + 1;
1166: END IF;

Line 1171: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_KB_Option', 'resp level value customized. Profile option value: ' || l_profile_option_value);

1167: ELSIF (l_level_id = 10003) THEN
1168: -- There wasn't any seeded value for the resp level. Therefore,
1169: -- this must be a customization
1170: l_upgrade_required := TRUE;
1171: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_KB_Option', 'resp level value customized. Profile option value: ' || l_profile_option_value);
1172: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_KB_Option', 'Resp id: ' || to_char(l_level_value) || ' Resp Appl Id: ' || to_char(l_level_value_appl_id));
1173: IF NOT (Resp_Already_Exists(p_RespTable, l_level_value, l_level_value_appl_id)) THEN
1174: p_RespTable(p_resp_index).respId := l_level_value;
1175: p_RespTable(p_resp_index).respApplId := l_level_value_appl_id;

Line 1172: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_KB_Option', 'Resp id: ' || to_char(l_level_value) || ' Resp Appl Id: ' || to_char(l_level_value_appl_id));

1168: -- There wasn't any seeded value for the resp level. Therefore,
1169: -- this must be a customization
1170: l_upgrade_required := TRUE;
1171: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_KB_Option', 'resp level value customized. Profile option value: ' || l_profile_option_value);
1172: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_KB_Option', 'Resp id: ' || to_char(l_level_value) || ' Resp Appl Id: ' || to_char(l_level_value_appl_id));
1173: IF NOT (Resp_Already_Exists(p_RespTable, l_level_value, l_level_value_appl_id)) THEN
1174: p_RespTable(p_resp_index).respId := l_level_value;
1175: p_RespTable(p_resp_index).respApplId := l_level_value_appl_id;
1176: p_resp_index := p_resp_index + 1;

Line 1191: log_mesg(FND_LOG.LEVEL_UNEXPECTED, 'CS_CF_UPG_UTL_PKG:Eval_SR_ShipTo_Address_Option', 'Exception in Eval_SR_ShipTo_Address_Option');

1187: return l_upgrade_required;
1188:
1189: EXCEPTION
1190: WHEN OTHERS THEN
1191: log_mesg(FND_LOG.LEVEL_UNEXPECTED, 'CS_CF_UPG_UTL_PKG:Eval_SR_ShipTo_Address_Option', 'Exception in Eval_SR_ShipTo_Address_Option');
1192: IF (get_profile_option_values%ISOPEN) THEN
1193: CLOSE get_profile_option_values;
1194: END IF;
1195: RAISE;

Line 1231: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Enable_Template', 'site level value customized. Profile option value: ' || l_profile_option_value);

1227: l_profile_option_value;
1228: WHILE get_profile_option_values%FOUND LOOP
1229: IF (l_level_id = 10001) THEN
1230: IF (l_profile_option_value <> 'Y') THEN
1231: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Enable_Template', 'site level value customized. Profile option value: ' || l_profile_option_value);
1232: p_siteProfilesTable(p_site_index).profileOptionName := 'IBU_SR_ENABLE_TEMPLATE';
1233: p_siteProfilesTable(p_site_index).profileOptionValue := l_profile_option_value;
1234: p_site_index := p_site_index + 1;
1235: l_upgrade_required := TRUE;

Line 1239: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Enable_Template', 'appl level value customized. Profile option value: ' || l_profile_option_value);

1235: l_upgrade_required := TRUE;
1236: END IF;
1237: ELSIF (l_level_id = 10002) THEN
1238: IF(l_profile_option_value <> 'Y') THEN
1239: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Enable_Template', 'appl level value customized. Profile option value: ' || l_profile_option_value);
1240: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Enable_Template', 'Application Id: ' || to_char(l_level_value));
1241: IF NOT (Appl_Already_Exists(p_ApplTable, l_level_value)) THEN
1242: p_ApplTable(p_appl_index) := l_level_value;
1243: p_appl_index := p_appl_index + 1;

Line 1240: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Enable_Template', 'Application Id: ' || to_char(l_level_value));

1236: END IF;
1237: ELSIF (l_level_id = 10002) THEN
1238: IF(l_profile_option_value <> 'Y') THEN
1239: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Enable_Template', 'appl level value customized. Profile option value: ' || l_profile_option_value);
1240: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Enable_Template', 'Application Id: ' || to_char(l_level_value));
1241: IF NOT (Appl_Already_Exists(p_ApplTable, l_level_value)) THEN
1242: p_ApplTable(p_appl_index) := l_level_value;
1243: p_appl_index := p_appl_index + 1;
1244: END IF;

Line 1251: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Enable_Template', 'resp level value customized. Profile option value: ' || l_profile_option_value);

1247: ELSIF (l_level_id = 10003) THEN
1248: -- There wasn't any seeded value for the resp level. Therefore,
1249: -- this must be a customization
1250: l_upgrade_required := TRUE;
1251: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Enable_Template', 'resp level value customized. Profile option value: ' || l_profile_option_value);
1252: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Enable_Template','Resp id: ' || to_char(l_level_value) || ' Resp Appl Id: ' || to_char(l_level_value_appl_id));
1253: IF NOT (Resp_Already_Exists(p_RespTable, l_level_value, l_level_value_appl_id)) THEN
1254: p_RespTable(p_resp_index).respId := l_level_value;
1255: p_RespTable(p_resp_index).respApplId := l_level_value_appl_id;

Line 1252: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Enable_Template','Resp id: ' || to_char(l_level_value) || ' Resp Appl Id: ' || to_char(l_level_value_appl_id));

1248: -- There wasn't any seeded value for the resp level. Therefore,
1249: -- this must be a customization
1250: l_upgrade_required := TRUE;
1251: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Enable_Template', 'resp level value customized. Profile option value: ' || l_profile_option_value);
1252: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Enable_Template','Resp id: ' || to_char(l_level_value) || ' Resp Appl Id: ' || to_char(l_level_value_appl_id));
1253: IF NOT (Resp_Already_Exists(p_RespTable, l_level_value, l_level_value_appl_id)) THEN
1254: p_RespTable(p_resp_index).respId := l_level_value;
1255: p_RespTable(p_resp_index).respApplId := l_level_value_appl_id;
1256: p_resp_index := p_resp_index + 1;

Line 1271: log_mesg(FND_LOG.LEVEL_UNEXPECTED, 'CS_CF_UPG_UTL_PKG.Eval_SR_Enable_Template','Exception in Eval_SR_Enable_Template');

1267: return l_upgrade_required;
1268:
1269: EXCEPTION
1270: WHEN OTHERS THEN
1271: log_mesg(FND_LOG.LEVEL_UNEXPECTED, 'CS_CF_UPG_UTL_PKG.Eval_SR_Enable_Template','Exception in Eval_SR_Enable_Template');
1272: IF (get_profile_option_values%ISOPEN) THEN
1273: CLOSE get_profile_option_values;
1274: END IF;
1275: RAISE;

Line 1311: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Enable_Template', 'site level value customized. Profile option value: ' || l_profile_option_value);

1307: l_profile_option_value;
1308: WHILE get_profile_option_values%FOUND LOOP
1309: IF (l_level_id = 10001) THEN
1310: IF (l_profile_option_value <> 'Y') THEN
1311: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Enable_Template', 'site level value customized. Profile option value: ' || l_profile_option_value);
1312: p_siteProfilesTable(p_site_index).profileOptionName := 'IBU_SR_ENABLE_TEMPLATE';
1313: p_siteProfilesTable(p_site_index).profileOptionValue := l_profile_option_value;
1314: p_site_index := p_site_index + 1;
1315: l_upgrade_required := TRUE;

Line 1321: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Product_Selection', 'appl level value customized. Profile option value: ' || l_profile_option_value);

1317: ELSIF (l_level_id = 10002) THEN
1318: -- there wasn't any seeded value for the appl level. Therefore,
1319: -- this must be a customization
1320: l_upgrade_required := TRUE;
1321: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Product_Selection', 'appl level value customized. Profile option value: ' || l_profile_option_value);
1322: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Product_Selection', 'Application Id: ' || to_char(l_level_value));
1323: IF NOT (Appl_Already_Exists(p_ApplTable, l_level_value)) THEN
1324: p_ApplTable(p_appl_index) := l_level_value;
1325: p_appl_index := p_appl_index + 1;

Line 1322: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Product_Selection', 'Application Id: ' || to_char(l_level_value));

1318: -- there wasn't any seeded value for the appl level. Therefore,
1319: -- this must be a customization
1320: l_upgrade_required := TRUE;
1321: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Product_Selection', 'appl level value customized. Profile option value: ' || l_profile_option_value);
1322: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Product_Selection', 'Application Id: ' || to_char(l_level_value));
1323: IF NOT (Appl_Already_Exists(p_ApplTable, l_level_value)) THEN
1324: p_ApplTable(p_appl_index) := l_level_value;
1325: p_appl_index := p_appl_index + 1;
1326: END IF;

Line 1331: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Product_Selection', 'resp level value customized. Profile option value: ' || l_profile_option_value);

1327: ELSIF (l_level_id = 10003) THEN
1328: -- There wasn't any seeded value for the resp level. Therefore,
1329: -- this must be a customization
1330: l_upgrade_required := TRUE;
1331: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Product_Selection', 'resp level value customized. Profile option value: ' || l_profile_option_value);
1332: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Product_Selection','Resp id: ' || to_char(l_level_value) || ' Resp Appl Id: ' || to_char(l_level_value_appl_id));
1333: IF NOT (Resp_Already_Exists(p_RespTable, l_level_value, l_level_value_appl_id)) THEN
1334: p_RespTable(p_resp_index).respId := l_level_value;
1335: p_RespTable(p_resp_index).respApplId := l_level_value_appl_id;

Line 1332: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Product_Selection','Resp id: ' || to_char(l_level_value) || ' Resp Appl Id: ' || to_char(l_level_value_appl_id));

1328: -- There wasn't any seeded value for the resp level. Therefore,
1329: -- this must be a customization
1330: l_upgrade_required := TRUE;
1331: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Product_Selection', 'resp level value customized. Profile option value: ' || l_profile_option_value);
1332: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Product_Selection','Resp id: ' || to_char(l_level_value) || ' Resp Appl Id: ' || to_char(l_level_value_appl_id));
1333: IF NOT (Resp_Already_Exists(p_RespTable, l_level_value, l_level_value_appl_id)) THEN
1334: p_RespTable(p_resp_index).respId := l_level_value;
1335: p_RespTable(p_resp_index).respApplId := l_level_value_appl_id;
1336: p_resp_index := p_resp_index + 1;

Line 1351: log_mesg(FND_LOG.LEVEL_UNEXPECTED, 'CS_CF_UPG_UTL_PKG.Eval_SR_Product_Selection','Exception in Eval_SR_Product_Selection');

1347: return l_upgrade_required;
1348:
1349: EXCEPTION
1350: WHEN OTHERS THEN
1351: log_mesg(FND_LOG.LEVEL_UNEXPECTED, 'CS_CF_UPG_UTL_PKG.Eval_SR_Product_Selection','Exception in Eval_SR_Product_Selection');
1352: IF (get_profile_option_values%ISOPEN) THEN
1353: CLOSE get_profile_option_values;
1354: END IF;
1355: RAISE;

Line 1568: log_mesg(FND_LOG.LEVEL_STATEMENT,'CS_CF_UPG_UTL_PKG.Insert_New_Target', 'Called Inserting new target row for sourceCode: ' || p_sourceCode || ' contextType: ' || p_contextType);

1564: FROM CS_CF_SOURCE_CXT_TARGETS
1565: WHERE source_context_type_id = p_contextTypeId;
1566:
1567: BEGIN
1568: log_mesg(FND_LOG.LEVEL_STATEMENT,'CS_CF_UPG_UTL_PKG.Insert_New_Target', 'Called Inserting new target row for sourceCode: ' || p_sourceCode || ' contextType: ' || p_contextType);
1569:
1570: OPEN source_context_type_id(p_sourceCode, p_contextType);
1571: FETCH source_context_type_id INTO l_source_context_type_id;
1572: CLOSE source_context_type_id;

Line 1641: log_mesg(FND_LOG.LEVEL_STATEMENT,'CS_CF_UPG_UTL_PKG.Insert_New_Target', 'Global context: last_updated_by:' || u_last_updated_by || 'created_by:' || u_created_by);

1637: u_additional_info14,
1638: u_additional_info15;
1639:
1640: CLOSE target_values_global;
1641: log_mesg(FND_LOG.LEVEL_STATEMENT,'CS_CF_UPG_UTL_PKG.Insert_New_Target', 'Global context: last_updated_by:' || u_last_updated_by || 'created_by:' || u_created_by);
1642: END IF;
1643: END IF;
1644:
1645: IF (p_contextType <> 'GLOBAL' AND (l_count = 0)) THEN

Line 1650: log_mesg(FND_LOG.LEVEL_STATEMENT,'CS_CF_UPG_UTL_PKG.Insert_New_Target', 'Inserting new target row for sourceCode: ' || p_sourceCode || ' contextTargetId: ' || l_source_context_target_id);

1646: SELECT cs_cf_source_cxt_targets_s.nextval
1647: INTO l_source_context_target_id
1648: FROM dual;
1649:
1650: log_mesg(FND_LOG.LEVEL_STATEMENT,'CS_CF_UPG_UTL_PKG.Insert_New_Target', 'Inserting new target row for sourceCode: ' || p_sourceCode || ' contextTargetId: ' || l_source_context_target_id);
1651: log_mesg(FND_LOG.LEVEL_STATEMENT,'CS_CF_UPG_UTL_PKG.Insert_New_Target', ' contextTypeId: ' || l_source_context_type_id || ' p_contextValue1: ' || p_contextValue1 || ' p_contextValue2: ' || p_contextValue2 );
1652:
1653: CS_CF_SOURCE_CXT_TARGETS_PKG.Insert_Row(
1654: X_ROWID => l_rowid,

Line 1651: log_mesg(FND_LOG.LEVEL_STATEMENT,'CS_CF_UPG_UTL_PKG.Insert_New_Target', ' contextTypeId: ' || l_source_context_type_id || ' p_contextValue1: ' || p_contextValue1 || ' p_contextValue2: ' || p_contextValue2 );

1647: INTO l_source_context_target_id
1648: FROM dual;
1649:
1650: log_mesg(FND_LOG.LEVEL_STATEMENT,'CS_CF_UPG_UTL_PKG.Insert_New_Target', 'Inserting new target row for sourceCode: ' || p_sourceCode || ' contextTargetId: ' || l_source_context_target_id);
1651: log_mesg(FND_LOG.LEVEL_STATEMENT,'CS_CF_UPG_UTL_PKG.Insert_New_Target', ' contextTypeId: ' || l_source_context_type_id || ' p_contextValue1: ' || p_contextValue1 || ' p_contextValue2: ' || p_contextValue2 );
1652:
1653: CS_CF_SOURCE_CXT_TARGETS_PKG.Insert_Row(
1654: X_ROWID => l_rowid,
1655: X_SOURCE_CONTEXT_TARGET_ID => l_source_context_target_id,

Line 1716: log_mesg(FND_LOG.LEVEL_STATEMENT,'CS_CF_UPG_UTL_PKG.Insert_New_Target', 'Updating target row for sourceCode: ' || p_sourceCode || ' contextTargetId: ' || l_source_context_target_id);

1712: -- row present after installation.
1713: -- We also keep the last_update_date to be the same because
1714: -- we want future ldt changes to overwrite this row.
1715:
1716: log_mesg(FND_LOG.LEVEL_STATEMENT,'CS_CF_UPG_UTL_PKG.Insert_New_Target', 'Updating target row for sourceCode: ' || p_sourceCode || ' contextTargetId: ' || l_source_context_target_id);
1717: log_mesg(FND_LOG.LEVEL_STATEMENT,'CS_CF_UPG_UTL_PKG.Insert_New_Target', ' contextTypeId: ' || l_source_context_type_id || ' p_contextValue1: ' || p_contextValue1 || ' p_contextValue2: ' || p_contextValue2 );
1718:
1719: CS_CF_SOURCE_CXT_TARGETS_PKG.UPDATE_ROW(
1720: X_SOURCE_CONTEXT_TARGET_ID => u_source_context_target_id,

Line 1717: log_mesg(FND_LOG.LEVEL_STATEMENT,'CS_CF_UPG_UTL_PKG.Insert_New_Target', ' contextTypeId: ' || l_source_context_type_id || ' p_contextValue1: ' || p_contextValue1 || ' p_contextValue2: ' || p_contextValue2 );

1713: -- We also keep the last_update_date to be the same because
1714: -- we want future ldt changes to overwrite this row.
1715:
1716: log_mesg(FND_LOG.LEVEL_STATEMENT,'CS_CF_UPG_UTL_PKG.Insert_New_Target', 'Updating target row for sourceCode: ' || p_sourceCode || ' contextTargetId: ' || l_source_context_target_id);
1717: log_mesg(FND_LOG.LEVEL_STATEMENT,'CS_CF_UPG_UTL_PKG.Insert_New_Target', ' contextTypeId: ' || l_source_context_type_id || ' p_contextValue1: ' || p_contextValue1 || ' p_contextValue2: ' || p_contextValue2 );
1718:
1719: CS_CF_SOURCE_CXT_TARGETS_PKG.UPDATE_ROW(
1720: X_SOURCE_CONTEXT_TARGET_ID => u_source_context_target_id,
1721: X_SOURCE_CONTEXT_TYPE_ID => l_source_context_type_id,

Line 1771: log_mesg(FND_LOG.LEVEL_UNEXPECTED, 'CS_CF_UPG_UTL_PKG.Insert_New_Target', 'Unexpected error: There should be at least one entry at the global level for source code ' || p_sourceCode);

1767: END IF;
1768:
1769: EXCEPTION
1770: WHEN no_row_found THEN
1771: log_mesg(FND_LOG.LEVEL_UNEXPECTED, 'CS_CF_UPG_UTL_PKG.Insert_New_Target', 'Unexpected error: There should be at least one entry at the global level for source code ' || p_sourceCode);
1772: RAISE;
1773: WHEN OTHERS THEN
1774: log_mesg(FND_LOG.LEVEL_UNEXPECTED, 'CS_CF_UPG_UTL_PKG:Insert_New_Target', 'Exception for sourceCode: ' || p_sourceCode || 'contextType: ' || p_contextType);
1775: IF (source_context_type_id%ISOPEN) THEN

Line 1774: log_mesg(FND_LOG.LEVEL_UNEXPECTED, 'CS_CF_UPG_UTL_PKG:Insert_New_Target', 'Exception for sourceCode: ' || p_sourceCode || 'contextType: ' || p_contextType);

1770: WHEN no_row_found THEN
1771: log_mesg(FND_LOG.LEVEL_UNEXPECTED, 'CS_CF_UPG_UTL_PKG.Insert_New_Target', 'Unexpected error: There should be at least one entry at the global level for source code ' || p_sourceCode);
1772: RAISE;
1773: WHEN OTHERS THEN
1774: log_mesg(FND_LOG.LEVEL_UNEXPECTED, 'CS_CF_UPG_UTL_PKG:Insert_New_Target', 'Exception for sourceCode: ' || p_sourceCode || 'contextType: ' || p_contextType);
1775: IF (source_context_type_id%ISOPEN) THEN
1776: CLOSE source_context_type_id;
1777: END IF;
1778: IF (target_count_resp%ISOPEN) THEN

Line 1851: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG:Clone_Region', 'Cloning Region for p_regionCode: ' || p_regionCode || ' p_regionApplId: ' || to_char(p_regionApplId));

1847: p_regionApplId,
1848: p_newRegionCode,
1849: p_newRegionApplId);
1850:
1851: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG:Clone_Region', 'Cloning Region for p_regionCode: ' || p_regionCode || ' p_regionApplId: ' || to_char(p_regionApplId));
1852: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG:Clone_Region', ' p_newRegionCode: ' || p_newRegionCode || ' p_newRegionApplId: ' || to_char(p_newRegionApplId));
1853:
1854: OPEN r_csr(p_newRegionCode, p_newRegionApplId);
1855: FETCH r_csr INTO r_rec;

Line 1852: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG:Clone_Region', ' p_newRegionCode: ' || p_newRegionCode || ' p_newRegionApplId: ' || to_char(p_newRegionApplId));

1848: p_newRegionCode,
1849: p_newRegionApplId);
1850:
1851: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG:Clone_Region', 'Cloning Region for p_regionCode: ' || p_regionCode || ' p_regionApplId: ' || to_char(p_regionApplId));
1852: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG:Clone_Region', ' p_newRegionCode: ' || p_newRegionCode || ' p_newRegionApplId: ' || to_char(p_newRegionApplId));
1853:
1854: OPEN r_csr(p_newRegionCode, p_newRegionApplId);
1855: FETCH r_csr INTO r_rec;
1856:

Line 1859: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG:Clone_Region', ' Could not find cloned region');

1855: FETCH r_csr INTO r_rec;
1856:
1857: b_success := r_csr%FOUND;
1858: IF (not b_success) THEN
1859: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG:Clone_Region', ' Could not find cloned region');
1860: close r_csr;
1861: RAISE PROGRAM_ERROR;
1862: ELSE
1863: close r_csr;

Line 1927: log_mesg(FND_LOG.LEVEL_UNEXPECTED, 'CS_CF_UPG_UTL_PKG:Clone_Region', 'Unexpected exception - p_regionCode: ' || p_regionCode || ' p_regionApplId: ' || to_char(p_regionApplId));

1923: END IF;
1924:
1925: EXCEPTION
1926: WHEN OTHERS THEN
1927: log_mesg(FND_LOG.LEVEL_UNEXPECTED, 'CS_CF_UPG_UTL_PKG:Clone_Region', 'Unexpected exception - p_regionCode: ' || p_regionCode || ' p_regionApplId: ' || to_char(p_regionApplId));
1928: log_mesg(FND_LOG.LEVEL_UNEXPECTED, 'CS_CF_UPG_UTL_PKG:Clone_Region', ' p_newRegionCode: ' || p_newRegionCode || ' p_newRegionApplId: ' || to_char(p_newRegionApplId));
1929:
1930: IF (r_csr%ISOPEN) THEN
1931: CLOSE r_csr;

Line 1928: log_mesg(FND_LOG.LEVEL_UNEXPECTED, 'CS_CF_UPG_UTL_PKG:Clone_Region', ' p_newRegionCode: ' || p_newRegionCode || ' p_newRegionApplId: ' || to_char(p_newRegionApplId));

1924:
1925: EXCEPTION
1926: WHEN OTHERS THEN
1927: log_mesg(FND_LOG.LEVEL_UNEXPECTED, 'CS_CF_UPG_UTL_PKG:Clone_Region', 'Unexpected exception - p_regionCode: ' || p_regionCode || ' p_regionApplId: ' || to_char(p_regionApplId));
1928: log_mesg(FND_LOG.LEVEL_UNEXPECTED, 'CS_CF_UPG_UTL_PKG:Clone_Region', ' p_newRegionCode: ' || p_newRegionCode || ' p_newRegionApplId: ' || to_char(p_newRegionApplId));
1929:
1930: IF (r_csr%ISOPEN) THEN
1931: CLOSE r_csr;
1932: END IF;

Line 2361: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UTL_UPG_PKG.UpdateRegionItems', 'Updating region items for p_regionCode: ' || p_regionCode || ' p_attributeCode: ' || p_attributeCode );

2357: X_ATTRIBUTE15 => l_attribute15);
2358:
2359: END IF;
2360:
2361: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UTL_UPG_PKG.UpdateRegionItems', 'Updating region items for p_regionCode: ' || p_regionCode || ' p_attributeCode: ' || p_attributeCode );
2362:
2363: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UTL_UPG_PKG.UpdateRegionItems', ' p_displayFlag: ' || p_displayFlag || ' p_mandatoryFlag: ' || p_mandatoryFlag || ' p_subRegionCode: ' || l_subRegionCode);
2364:
2365: EXCEPTION

Line 2363: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UTL_UPG_PKG.UpdateRegionItems', ' p_displayFlag: ' || p_displayFlag || ' p_mandatoryFlag: ' || p_mandatoryFlag || ' p_subRegionCode: ' || l_subRegionCode);

2359: END IF;
2360:
2361: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UTL_UPG_PKG.UpdateRegionItems', 'Updating region items for p_regionCode: ' || p_regionCode || ' p_attributeCode: ' || p_attributeCode );
2362:
2363: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UTL_UPG_PKG.UpdateRegionItems', ' p_displayFlag: ' || p_displayFlag || ' p_mandatoryFlag: ' || p_mandatoryFlag || ' p_subRegionCode: ' || l_subRegionCode);
2364:
2365: EXCEPTION
2366: WHEN OTHERS THEN
2367: log_mesg(FND_LOG.LEVEL_UNEXPECTED, 'CS_CF_UTL_UPG_PKG.UpdateRegionItems', 'Exception for p_regionCode: ' || p_regionCode || ' p_attributeCode: ' || p_attributeCode );

Line 2367: log_mesg(FND_LOG.LEVEL_UNEXPECTED, 'CS_CF_UTL_UPG_PKG.UpdateRegionItems', 'Exception for p_regionCode: ' || p_regionCode || ' p_attributeCode: ' || p_attributeCode );

2363: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UTL_UPG_PKG.UpdateRegionItems', ' p_displayFlag: ' || p_displayFlag || ' p_mandatoryFlag: ' || p_mandatoryFlag || ' p_subRegionCode: ' || l_subRegionCode);
2364:
2365: EXCEPTION
2366: WHEN OTHERS THEN
2367: log_mesg(FND_LOG.LEVEL_UNEXPECTED, 'CS_CF_UTL_UPG_PKG.UpdateRegionItems', 'Exception for p_regionCode: ' || p_regionCode || ' p_attributeCode: ' || p_attributeCode );
2368: log_mesg(FND_LOG.LEVEL_UNEXPECTED, 'CS_CF_UTL_UPG_PKG.UpdateRegionItems', ' p_displayFlag: ' || p_displayFlag || ' p_mandatoryFlag: ' || p_mandatoryFlag || ' p_subRegionCode: ' || l_subRegionCode);
2369: RAISE;
2370: END UpdateRegionItems;
2371:

Line 2368: log_mesg(FND_LOG.LEVEL_UNEXPECTED, 'CS_CF_UTL_UPG_PKG.UpdateRegionItems', ' p_displayFlag: ' || p_displayFlag || ' p_mandatoryFlag: ' || p_mandatoryFlag || ' p_subRegionCode: ' || l_subRegionCode);

2364:
2365: EXCEPTION
2366: WHEN OTHERS THEN
2367: log_mesg(FND_LOG.LEVEL_UNEXPECTED, 'CS_CF_UTL_UPG_PKG.UpdateRegionItems', 'Exception for p_regionCode: ' || p_regionCode || ' p_attributeCode: ' || p_attributeCode );
2368: log_mesg(FND_LOG.LEVEL_UNEXPECTED, 'CS_CF_UTL_UPG_PKG.UpdateRegionItems', ' p_displayFlag: ' || p_displayFlag || ' p_mandatoryFlag: ' || p_mandatoryFlag || ' p_subRegionCode: ' || l_subRegionCode);
2369: RAISE;
2370: END UpdateRegionItems;
2371:
2372: PROCEDURE getAddressProfileValues(p_ProfileTable IN CS_CF_UPG_UTL_PKG.ProfileTable,

Line 2431: log_mesg(FND_LOG.LEVEL_UNEXPECTED, 'CS_CF_UPG_UTL_PKG:getAddressProfileOptions', 'Unexpected exception in getAddressProfileOptions');

2427: END LOOP;
2428:
2429: EXCEPTION
2430: WHEN OTHERS THEN
2431: log_mesg(FND_LOG.LEVEL_UNEXPECTED, 'CS_CF_UPG_UTL_PKG:getAddressProfileOptions', 'Unexpected exception in getAddressProfileOptions');
2432: RAISE;
2433:
2434: END getAddressProfileValues;
2435:

Line 2465: log_mesg(FND_LOG.LEVEL_UNEXPECTED, 'CS_CF_UPG_UTL_PKG:getAttachmentProbCodeValues', 'Unexpected exception in getAttachmentProbCodeValues');

2461: END LOOP;
2462:
2463: EXCEPTION
2464: WHEN OTHERS THEN
2465: log_mesg(FND_LOG.LEVEL_UNEXPECTED, 'CS_CF_UPG_UTL_PKG:getAttachmentProbCodeValues', 'Unexpected exception in getAttachmentProbCodeValues');
2466: RAISE;
2467:
2468: END getAttachmentProbCodeValues;
2469:

Line 2482: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG:setup_log', 'System time at the start of the upgrade process is: ' || fnd_date.date_to_charDT(sysdate));

2478: FND_FILE.PUT_LINE(FND_FILE.LOG, '*** PLEASE DO NOT DISCARD. THIS FILE MAY BE REFERENCED IN THE FUTURE TO DIAGNOSE ISSUES EXPERIENCED BY THE CUSTOMER. *** ');
2479:
2480: FND_FILE.PUT_LINE(FND_FILE.LOG, '');
2481:
2482: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG:setup_log', 'System time at the start of the upgrade process is: ' || fnd_date.date_to_charDT(sysdate));
2483:
2484: END setup_log;
2485:
2486:

Line 2496: IF (p_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2492: FND_FILE.PUT_LINE(FND_FILE.LOG, p_module || '- ' || p_text);
2493: --DBMS_OUTPUT.PUT_LINE(p_module || '-' || p_text);
2494:
2495: /*
2496: IF (p_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2497: FND_LOG.STRING(p_level, p_module, p_text);
2498: END IF;
2499: */
2500: END log_mesg;

Line 2497: FND_LOG.STRING(p_level, p_module, p_text);

2493: --DBMS_OUTPUT.PUT_LINE(p_module || '-' || p_text);
2494:
2495: /*
2496: IF (p_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2497: FND_LOG.STRING(p_level, p_module, p_text);
2498: END IF;
2499: */
2500: END log_mesg;
2501:

Line 2506: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.wrapup', 'Upgrade process completed at: ' || fnd_date.date_to_charDT(sysdate));

2502: PROCEDURE wrapup(p_status IN VARCHAR2)
2503: IS
2504: BEGIN
2505: IF (p_status = 'SUCCESS') THEN
2506: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.wrapup', 'Upgrade process completed at: ' || fnd_date.date_to_charDT(sysdate));
2507: ELSIF (p_status = 'ERROR') THEN
2508: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.wrapup', 'Upgrade process terminated at: ' || fnd_date.date_to_charDT(sysdate));
2509: END IF;
2510:

Line 2508: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.wrapup', 'Upgrade process terminated at: ' || fnd_date.date_to_charDT(sysdate));

2504: BEGIN
2505: IF (p_status = 'SUCCESS') THEN
2506: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.wrapup', 'Upgrade process completed at: ' || fnd_date.date_to_charDT(sysdate));
2507: ELSIF (p_status = 'ERROR') THEN
2508: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.wrapup', 'Upgrade process terminated at: ' || fnd_date.date_to_charDT(sysdate));
2509: END IF;
2510:
2511: End wrapup;
2512:

Line 2606: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_UNEXPECTED, 'CS_CF_UPG_UTL_PKG: Flows_Not_Already_Cloned', ' Unexpected exception in Flows_Not_Already_Cloned');

2602: END IF;
2603:
2604: EXCEPTION
2605: WHEN OTHERS THEN
2606: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_UNEXPECTED, 'CS_CF_UPG_UTL_PKG: Flows_Not_Already_Cloned', ' Unexpected exception in Flows_Not_Already_Cloned');
2607: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_UNEXPECTED, 'CS_CF_UPG_UTL_PKG: Flows_Not_Already_Cloned', ' p_flowId = ' + to_char(p_flowId));
2608:
2609: IF (l_cur%ISOPEN) THEN
2610: CLOSE l_cur;

Line 2607: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_UNEXPECTED, 'CS_CF_UPG_UTL_PKG: Flows_Not_Already_Cloned', ' p_flowId = ' + to_char(p_flowId));

2603:
2604: EXCEPTION
2605: WHEN OTHERS THEN
2606: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_UNEXPECTED, 'CS_CF_UPG_UTL_PKG: Flows_Not_Already_Cloned', ' Unexpected exception in Flows_Not_Already_Cloned');
2607: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_UNEXPECTED, 'CS_CF_UPG_UTL_PKG: Flows_Not_Already_Cloned', ' p_flowId = ' + to_char(p_flowId));
2608:
2609: IF (l_cur%ISOPEN) THEN
2610: CLOSE l_cur;
2611: END IF;

Line 2640: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG:configProfileCustomized', ' Could not find configuration profile');

2636: FETCH l_cur INTO l_lub;
2637:
2638: b_success := l_cur%FOUND;
2639: IF (NOT b_success) THEN
2640: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG:configProfileCustomized', ' Could not find configuration profile');
2641: CLOSE l_cur;
2642: RAISE PROGRAM_ERROR;
2643: ELSE
2644: CLOSE l_cur;

Line 2654: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_UNEXPECTED, 'CS_CF_UPG_UTL_PKG: configProfileCustomized', ' Unexpected exception in configProfileCustomized');

2650: END IF;
2651:
2652: EXCEPTION
2653: WHEN OTHERS THEN
2654: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_UNEXPECTED, 'CS_CF_UPG_UTL_PKG: configProfileCustomized', ' Unexpected exception in configProfileCustomized');
2655: IF (l_cur%ISOPEN) THEN
2656: CLOSE l_cur;
2657: END IF;
2658: RAISE;

Line 2693: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Clone_Flow', ' Cloning Flow for p_newFlowId = ' || to_char(p_newFlowId));

2689: l_created_by NUMBER := fnd_load_util.owner_id('ORACLE');
2690:
2691: BEGIN
2692:
2693: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Clone_Flow', ' Cloning Flow for p_newFlowId = ' || to_char(p_newFlowId));
2694: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Clone_Flow', ' Cloning Flow for p_flowId = ' || to_char(p_flowId));
2695:
2696: OPEN l_flow_cur(p_flowId);
2697: FETCH l_flow_cur INTO l_flow_rec;

Line 2694: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Clone_Flow', ' Cloning Flow for p_flowId = ' || to_char(p_flowId));

2690:
2691: BEGIN
2692:
2693: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Clone_Flow', ' Cloning Flow for p_newFlowId = ' || to_char(p_newFlowId));
2694: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Clone_Flow', ' Cloning Flow for p_flowId = ' || to_char(p_flowId));
2695:
2696: OPEN l_flow_cur(p_flowId);
2697: FETCH l_flow_cur INTO l_flow_rec;
2698:

Line 2701: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Clone_Flow', ' Could not successfully execute cursor! ');

2697: FETCH l_flow_cur INTO l_flow_rec;
2698:
2699: b_success := l_flow_cur%FOUND;
2700: IF (NOT b_success) THEN
2701: log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Clone_Flow', ' Could not successfully execute cursor! ');
2702: close l_flow_cur;
2703: RAISE PROGRAM_ERROR;
2704: ELSE
2705: close l_flow_cur;

Line 2779: log_mesg(FND_LOG.LEVEL_UNEXPECTED, 'CS_CF_UPG_UTL_PKG:Clone_Flow',

2775: END IF;
2776:
2777: EXCEPTION
2778: WHEN OTHERS THEN
2779: log_mesg(FND_LOG.LEVEL_UNEXPECTED, 'CS_CF_UPG_UTL_PKG:Clone_Flow',
2780: 'Unexpected exception - p_newFlowId: ' || to_char(p_newFlowId) || ' p_flowId: ' || to_char(p_flowId));
2781:
2782: IF (l_page_cur%ISOPEN) THEN
2783: CLOSE l_page_cur;