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 3365: l_icx_date_format := nvl(fnd_profile.value('ICX_DATE_FORMAT_MASK'),'DD-MON-RRRR');

3361: fetch chr_csr into chr_rec;
3362: close chr_csr;
3363: -- Bug# 4072796
3364: if NOT (p_release_date BETWEEN (chr_rec.start_date + 1) AND chr_rec.end_date) then
3365: l_icx_date_format := nvl(fnd_profile.value('ICX_DATE_FORMAT_MASK'),'DD-MON-RRRR');
3366:
3367: OKL_API.SET_MESSAGE(G_APP_NAME,
3368: 'OKL_LLA_WRONG_TRX_DATE',
3369: 'START_DATE',

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

3462: end if;
3463: end loop;
3464:
3465: if l_asset_num_token IS NOT NULL then
3466: l_icx_date_format := nvl(fnd_profile.value('ICX_DATE_FORMAT_MASK'),'DD-MON-RRRR');
3467: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
3468: p_msg_name => 'OKL_LLA_REL_ASSET_NO_PYMT',
3469: p_token1 => 'ASSET_NUMBER',
3470: p_token1_value => l_asset_num_token,

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

3500: end if;
3501: end loop;
3502:
3503: if l_asset_num_token IS NOT NULL then
3504: l_icx_date_format := nvl(fnd_profile.value('ICX_DATE_FORMAT_MASK'),'DD-MON-RRRR');
3505: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
3506: p_msg_name => 'OKL_LLA_REL_ASSET_NO_PYMT',
3507: p_token1 => 'ASSET_NUMBER',
3508: p_token1_value => l_asset_num_token,