DBA Data[Home] [Help]

APPS.MSD_VALIDATE_DEMAND_PLAN dependencies on FND_PROFILE

Line 100: l_debug VARCHAR2(240) := NVL(fnd_profile.value('MRP_DEBUG'), 'N');

96: SUCCESS Constant varchar2(30):='SUCCESS';
97:
98: C_YES_FLAG Constant varchar2(30):= 'Y';
99:
100: l_debug VARCHAR2(240) := NVL(fnd_profile.value('MRP_DEBUG'), 'N');
101:
102: --
103: -- get demand plan record
104: --

Line 2012: if fnd_profile.value('MSD_CURRENCY_CODE') is not null then

2008: debug_out( 'Entering chk_curr_data ' || to_char(sysdate, 'hh24:mi:ss'));
2009: end if;
2010:
2011: -- currency conversion data
2012: if fnd_profile.value('MSD_CURRENCY_CODE') is not null then
2013: open curr_conv (fnd_profile.value('MSD_CURRENCY_CODE'), l_dp_min_date , l_dp_max_date);
2014: fetch curr_conv into l_cnt;
2015: close curr_conv;
2016: --

Line 2013: open curr_conv (fnd_profile.value('MSD_CURRENCY_CODE'), l_dp_min_date , l_dp_max_date);

2009: end if;
2010:
2011: -- currency conversion data
2012: if fnd_profile.value('MSD_CURRENCY_CODE') is not null then
2013: open curr_conv (fnd_profile.value('MSD_CURRENCY_CODE'), l_dp_min_date , l_dp_max_date);
2014: fetch curr_conv into l_cnt;
2015: close curr_conv;
2016: --
2017: if l_cnt = 0 then

Line 2019: display_message( 'Currency conversion data not found for ' || fnd_profile.value('MSD_CURRENCY_CODE'), WARNING);

2015: close curr_conv;
2016: --
2017: if l_cnt = 0 then
2018: -- no currency conversion data
2019: display_message( 'Currency conversion data not found for ' || fnd_profile.value('MSD_CURRENCY_CODE'), WARNING);
2020: end if;
2021: end if;
2022: --
2023: