DBA Data[Home] [Help]

APPS.MSD_VALIDATE_DEMAND_PLAN dependencies on FND_PROFILE

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

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

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

1993: debug_out( 'Entering chk_curr_data ' || to_char(sysdate, 'hh24:mi:ss'));
1994: end if;
1995:
1996: -- currency conversion data
1997: if fnd_profile.value('MSD_CURRENCY_CODE') is not null then
1998: open curr_conv (fnd_profile.value('MSD_CURRENCY_CODE'), l_dp_min_date , l_dp_max_date);
1999: fetch curr_conv into l_cnt;
2000: close curr_conv;
2001: --

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

1994: end if;
1995:
1996: -- currency conversion data
1997: if fnd_profile.value('MSD_CURRENCY_CODE') is not null then
1998: open curr_conv (fnd_profile.value('MSD_CURRENCY_CODE'), l_dp_min_date , l_dp_max_date);
1999: fetch curr_conv into l_cnt;
2000: close curr_conv;
2001: --
2002: if l_cnt = 0 then

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

2000: close curr_conv;
2001: --
2002: if l_cnt = 0 then
2003: -- no currency conversion data
2004: display_message( 'Currency conversion data not found for ' || fnd_profile.value('MSD_CURRENCY_CODE'), WARNING);
2005: end if;
2006: end if;
2007: --
2008: