DBA Data[Home] [Help]

APPS.BEN_EXT_UTIL dependencies on BEN_EXT_THREAD

Line 1448: ben_ext_thread.g_err_num := 92451;

1444: --
1445: if ben_ext_person.g_cm_type_id is null then
1446: hr_utility.set_location(' 514 error '|| p_ext_date_cd , 514);
1447:
1448: ben_ext_thread.g_err_num := 92451;
1449: ben_ext_thread.g_err_name := 'BEN_92451_EXT_INV_CM_DT';
1450: raise ben_ext_thread.g_job_failure_error;
1451:
1452: end if;

Line 1449: ben_ext_thread.g_err_name := 'BEN_92451_EXT_INV_CM_DT';

1445: if ben_ext_person.g_cm_type_id is null then
1446: hr_utility.set_location(' 514 error '|| p_ext_date_cd , 514);
1447:
1448: ben_ext_thread.g_err_num := 92451;
1449: ben_ext_thread.g_err_name := 'BEN_92451_EXT_INV_CM_DT';
1450: raise ben_ext_thread.g_job_failure_error;
1451:
1452: end if;
1453:

Line 1450: raise ben_ext_thread.g_job_failure_error;

1446: hr_utility.set_location(' 514 error '|| p_ext_date_cd , 514);
1447:
1448: ben_ext_thread.g_err_num := 92451;
1449: ben_ext_thread.g_err_name := 'BEN_92451_EXT_INV_CM_DT';
1450: raise ben_ext_thread.g_job_failure_error;
1451:
1452: end if;
1453:
1454: if p_ext_date_cd = 'CTBSD' then --communication to be sent date

Line 1458: ben_ext_thread.g_err_num := 92454;

1454: if p_ext_date_cd = 'CTBSD' then --communication to be sent date
1455:
1456: if ben_ext_person.g_cm_to_be_sent_dt is null then
1457:
1458: ben_ext_thread.g_err_num := 92454;
1459: ben_ext_thread.g_err_name := 'BEN_92454_EXT_INV_TO_BE_SNT_DT';
1460: raise ben_ext_person.detail_error;
1461:
1462: else

Line 1459: ben_ext_thread.g_err_name := 'BEN_92454_EXT_INV_TO_BE_SNT_DT';

1455:
1456: if ben_ext_person.g_cm_to_be_sent_dt is null then
1457:
1458: ben_ext_thread.g_err_num := 92454;
1459: ben_ext_thread.g_err_name := 'BEN_92454_EXT_INV_TO_BE_SNT_DT';
1460: raise ben_ext_person.detail_error;
1461:
1462: else
1463:

Line 1476: ben_ext_thread.g_err_num := 92450;

1472: elsif p_ext_date_cd = 'CLEOD' then -- communication life event occurred date
1473:
1474: if ben_ext_person.g_cm_lf_evt_ocrd_dt is null then
1475:
1476: ben_ext_thread.g_err_num := 92450;
1477: ben_ext_thread.g_err_name := 'BEN_92450_EXT_INV_LER_DT';
1478: raise ben_ext_person.detail_error;
1479:
1480: else

Line 1477: ben_ext_thread.g_err_name := 'BEN_92450_EXT_INV_LER_DT';

1473:
1474: if ben_ext_person.g_cm_lf_evt_ocrd_dt is null then
1475:
1476: ben_ext_thread.g_err_num := 92450;
1477: ben_ext_thread.g_err_name := 'BEN_92450_EXT_INV_LER_DT';
1478: raise ben_ext_person.detail_error;
1479:
1480: else
1481:

Line 1490: ben_ext_thread.g_err_num := 92450;

1486: else -- CDBLEOD communication day before life event occured date
1487:
1488: if ben_ext_person.g_cm_lf_evt_ocrd_dt is null then
1489:
1490: ben_ext_thread.g_err_num := 92450;
1491: ben_ext_thread.g_err_name := 'BEN_92450_EXT_INV_LER_DT';
1492: raise ben_ext_person.detail_error;
1493:
1494: else

Line 1491: ben_ext_thread.g_err_name := 'BEN_92450_EXT_INV_LER_DT';

1487:
1488: if ben_ext_person.g_cm_lf_evt_ocrd_dt is null then
1489:
1490: ben_ext_thread.g_err_num := 92450;
1491: ben_ext_thread.g_err_name := 'BEN_92450_EXT_INV_LER_DT';
1492: raise ben_ext_person.detail_error;
1493:
1494: else
1495:

Line 1506: ben_ext_thread.g_err_num := 92455;

1502: elsif p_ext_date_cd = 'CHAD' then
1503:
1504: if ben_ext_person.g_chg_actl_dt is null then
1505: hr_utility.set_location(' 514 error 1' , 514);
1506: ben_ext_thread.g_err_num := 92455;
1507: ben_ext_thread.g_err_name := 'BEN_92455_EXT_INV_CHG_DT';
1508: raise ben_ext_thread.g_job_failure_error;
1509:
1510: else

Line 1507: ben_ext_thread.g_err_name := 'BEN_92455_EXT_INV_CHG_DT';

1503:
1504: if ben_ext_person.g_chg_actl_dt is null then
1505: hr_utility.set_location(' 514 error 1' , 514);
1506: ben_ext_thread.g_err_num := 92455;
1507: ben_ext_thread.g_err_name := 'BEN_92455_EXT_INV_CHG_DT';
1508: raise ben_ext_thread.g_job_failure_error;
1509:
1510: else
1511:

Line 1508: raise ben_ext_thread.g_job_failure_error;

1504: if ben_ext_person.g_chg_actl_dt is null then
1505: hr_utility.set_location(' 514 error 1' , 514);
1506: ben_ext_thread.g_err_num := 92455;
1507: ben_ext_thread.g_err_name := 'BEN_92455_EXT_INV_CHG_DT';
1508: raise ben_ext_thread.g_job_failure_error;
1509:
1510: else
1511:
1512: l_rslt_dt := trunc(ben_ext_person.g_chg_actl_dt);

Line 1521: ben_ext_thread.g_err_num := 92455;

1517:
1518: if ben_ext_person.g_chg_eff_dt is null then
1519:
1520: hr_utility.set_location(' 514 error 2' , 514);
1521: ben_ext_thread.g_err_num := 92455;
1522: ben_ext_thread.g_err_name := 'BEN_92455_EXT_INV_CHG_DT';
1523: raise ben_ext_thread.g_job_failure_error;
1524:
1525: else

Line 1522: ben_ext_thread.g_err_name := 'BEN_92455_EXT_INV_CHG_DT';

1518: if ben_ext_person.g_chg_eff_dt is null then
1519:
1520: hr_utility.set_location(' 514 error 2' , 514);
1521: ben_ext_thread.g_err_num := 92455;
1522: ben_ext_thread.g_err_name := 'BEN_92455_EXT_INV_CHG_DT';
1523: raise ben_ext_thread.g_job_failure_error;
1524:
1525: else
1526:

Line 1523: raise ben_ext_thread.g_job_failure_error;

1519:
1520: hr_utility.set_location(' 514 error 2' , 514);
1521: ben_ext_thread.g_err_num := 92455;
1522: ben_ext_thread.g_err_name := 'BEN_92455_EXT_INV_CHG_DT';
1523: raise ben_ext_thread.g_job_failure_error;
1524:
1525: else
1526:
1527: l_rslt_dt := trunc(ben_ext_person.g_chg_eff_dt);

Line 1847: ben_ext_thread.g_err_num := 91628;

1843:
1844:
1845: else
1846: --
1847: ben_ext_thread.g_err_num := 91628;
1848: ben_ext_thread.g_err_name := 'BEN_91628_LOOKUP_TYPE_GENERIC';
1849: raise ben_ext_thread.g_job_failure_error;
1850: --
1851: end if;

Line 1848: ben_ext_thread.g_err_name := 'BEN_91628_LOOKUP_TYPE_GENERIC';

1844:
1845: else
1846: --
1847: ben_ext_thread.g_err_num := 91628;
1848: ben_ext_thread.g_err_name := 'BEN_91628_LOOKUP_TYPE_GENERIC';
1849: raise ben_ext_thread.g_job_failure_error;
1850: --
1851: end if;
1852: --

Line 1849: raise ben_ext_thread.g_job_failure_error;

1845: else
1846: --
1847: ben_ext_thread.g_err_num := 91628;
1848: ben_ext_thread.g_err_name := 'BEN_91628_LOOKUP_TYPE_GENERIC';
1849: raise ben_ext_thread.g_job_failure_error;
1850: --
1851: end if;
1852: --
1853: