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;
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:
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
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
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:
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
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:
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
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:
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
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:
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);
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
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:
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);
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;
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: --
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: