DBA Data[Home] [Help]

APPS.MSC_SCN_UTILS dependencies on MSC_UTIL

Line 2110: msc_util.msc_debug('New Scenario Name:'||l_scn_name||' ('||sysdate||')('||l_scn_count||')');

2106:
2107: l_scn_name := msc_scn_utils.get_scenario_name(p_scn_id);
2108: select count(*) into l_scn_count from msc_scenarios where scenario_name like l_scn_name||' ('||sysdate||')%';
2109: l_scn_count := l_scn_count+1;
2110: msc_util.msc_debug('New Scenario Name:'||l_scn_name||' ('||sysdate||')('||l_scn_count||')');
2111: update msc_scenarios set scn_version = sysdate,scenario_name = scenario_name||' ('||sysdate||')('||l_scn_count||')' where scenario_id = p_scn_id;
2112:
2113: l_user_id := fnd_profile.value ('USER_ID');
2114: l_login_id := FND_PROFILE.VALUE('LOGIN_ID');

Line 2219: msc_util.msc_debug('Archive Plan Failed for Plan:'||get_plan_name(l_plan_type,l_plan_id,l_plan_run_id));

2215: p_plan_type=>l_plan_type, p_target_plan_name=>l_plan_name, p_publisher=>l_publisher);
2216:
2217: if retcode <> 0 then
2218: --null; -- errored out
2219: msc_util.msc_debug('Archive Plan Failed for Plan:'||get_plan_name(l_plan_type,l_plan_id,l_plan_run_id));
2220: raise exc_error_plan_arch;
2221: end if;
2222: update msc_scenario_plans set plan_run_id = l_plan_run_id where
2223: scenario_id = p_scn_id and plan_id = l_plan_id and plan_type = l_plan_type;

Line 2275: msc_util.msc_debug('Purge Plan Failed for Plan:'||l_plan_run_name);

2271: exit when c_scn_plans%NOTFOUND;
2272:
2273: msc_phub_file_pkg.purge_plan_summary(errbuf,retcode,null,l_plan_run_id);
2274: if retcode <> 0 then
2275: msc_util.msc_debug('Purge Plan Failed for Plan:'||l_plan_run_name);
2276: raise exc_error_purge_scn_pln;
2277: end if;
2278:
2279: end loop;