APPS.OKI_ALERT_UTIL_PVT dependencies on FND_PROFILE

Line 401: fnd_profile.value('ICX_DATE_FORMAT_MASK'));

397: l_message_id VARCHAR2(40) := NULL ;
398:
399: BEGIN
400: l_end_date := TO_CHAR(ADD_MONTHS(p_qtr_end_date, ((3 * p_number_of_qtrs) * -1)),
401: fnd_profile.value('ICX_DATE_FORMAT_MASK'));
402:
403: RETURN l_end_date ;
404:
405: EXCEPTION

Line 450: RETURN TO_CHAR(l_qtr_end_date, fnd_profile.value('ICX_DATE_FORMAT_MASK')) ;

446: FETCH get_qtr_end_date_csr INTO rec_get_qtr_end_date_csr ;
447: l_qtr_end_date := rec_get_qtr_end_date_csr.qtr_end_date ;
448: CLOSE get_qtr_end_date_csr ;
449:
450: RETURN TO_CHAR(l_qtr_end_date, fnd_profile.value('ICX_DATE_FORMAT_MASK')) ;
451:
452: EXCEPTION
453: WHEN OTHERS THEN
454: -- return the error number to the calling program;

Line 461: g_alert_dist_list := fnd_profile.value('OKI_ALERT_DIST_LIST');

457: END dflt_gv_qed ;
458: */
459: BEGIN
460: -- Initialization Block
461: g_alert_dist_list := fnd_profile.value('OKI_ALERT_DIST_LIST');
462: g_alert_publish_dir := fnd_profile.value('OKI_ALERT_PUBLISH_DIR');
463: g_utl_file_dest := fnd_profile.value('OKI_UTL_FILE_DEST');
464: g_oki_parent_url := fnd_profile.value('OKI_ALERT_URL');
465:

Line 462: g_alert_publish_dir := fnd_profile.value('OKI_ALERT_PUBLISH_DIR');

458: */
459: BEGIN
460: -- Initialization Block
461: g_alert_dist_list := fnd_profile.value('OKI_ALERT_DIST_LIST');
462: g_alert_publish_dir := fnd_profile.value('OKI_ALERT_PUBLISH_DIR');
463: g_utl_file_dest := fnd_profile.value('OKI_UTL_FILE_DEST');
464: g_oki_parent_url := fnd_profile.value('OKI_ALERT_URL');
465:
466: fnd_file.put_line( which => fnd_file.log

Line 463: g_utl_file_dest := fnd_profile.value('OKI_UTL_FILE_DEST');

459: BEGIN
460: -- Initialization Block
461: g_alert_dist_list := fnd_profile.value('OKI_ALERT_DIST_LIST');
462: g_alert_publish_dir := fnd_profile.value('OKI_ALERT_PUBLISH_DIR');
463: g_utl_file_dest := fnd_profile.value('OKI_UTL_FILE_DEST');
464: g_oki_parent_url := fnd_profile.value('OKI_ALERT_URL');
465:
466: fnd_file.put_line( which => fnd_file.log
467: , buff => 'Alert Dist List :'||g_alert_dist_list);

Line 464: g_oki_parent_url := fnd_profile.value('OKI_ALERT_URL');

460: -- Initialization Block
461: g_alert_dist_list := fnd_profile.value('OKI_ALERT_DIST_LIST');
462: g_alert_publish_dir := fnd_profile.value('OKI_ALERT_PUBLISH_DIR');
463: g_utl_file_dest := fnd_profile.value('OKI_UTL_FILE_DEST');
464: g_oki_parent_url := fnd_profile.value('OKI_ALERT_URL');
465:
466: fnd_file.put_line( which => fnd_file.log
467: , buff => 'Alert Dist List :'||g_alert_dist_list);
468: fnd_file.put_line( which => fnd_file.log