APPS.OKL_RELEASE_PVT dependencies on FND_PROFILE

Line 837: l_icx_date_format := nvl(fnd_profile.value('ICX_DATE_FORMAT_MASK'),'DD-MON-RRRR');

833:
834: IF NOT ( p_release_date BETWEEN open_period_rec.calendar_period_open_date AND
835: open_period_rec.calendar_period_close_date ) THEN
836:
837: l_icx_date_format := nvl(fnd_profile.value('ICX_DATE_FORMAT_MASK'),'DD-MON-RRRR');
838:
839: l_current_open_period := open_period_rec.period_name||' ('||
840: to_char(open_period_rec.calendar_period_open_date,l_icx_date_format)
841: ||' - '||to_char(open_period_rec.calendar_period_close_date,l_icx_date_format)||')';

Line 3311: l_icx_date_format := nvl(fnd_profile.value('ICX_DATE_FORMAT_MASK'),'DD-MON-RRRR');

3307: fetch chr_csr into chr_rec;
3308: close chr_csr;
3309: -- Bug# 4072796
3310: if NOT (p_release_date BETWEEN (chr_rec.start_date + 1) AND chr_rec.end_date) then
3311: l_icx_date_format := nvl(fnd_profile.value('ICX_DATE_FORMAT_MASK'),'DD-MON-RRRR');
3312:
3313: OKL_API.SET_MESSAGE(G_APP_NAME,
3314: 'OKL_LLA_WRONG_TRX_DATE',
3315: 'START_DATE',

Line 3412: l_icx_date_format := nvl(fnd_profile.value('ICX_DATE_FORMAT_MASK'),'DD-MON-RRRR');

3408: end if;
3409: end loop;
3410:
3411: if l_asset_num_token IS NOT NULL then
3412: l_icx_date_format := nvl(fnd_profile.value('ICX_DATE_FORMAT_MASK'),'DD-MON-RRRR');
3413: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
3414: p_msg_name => 'OKL_LLA_REL_ASSET_NO_PYMT',
3415: p_token1 => 'ASSET_NUMBER',
3416: p_token1_value => l_asset_num_token,

Line 3450: l_icx_date_format := nvl(fnd_profile.value('ICX_DATE_FORMAT_MASK'),'DD-MON-RRRR');

3446: end if;
3447: end loop;
3448:
3449: if l_asset_num_token IS NOT NULL then
3450: l_icx_date_format := nvl(fnd_profile.value('ICX_DATE_FORMAT_MASK'),'DD-MON-RRRR');
3451: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
3452: p_msg_name => 'OKL_LLA_REL_ASSET_NO_PYMT',
3453: p_token1 => 'ASSET_NUMBER',
3454: p_token1_value => l_asset_num_token,