1440: --
1441: if ben_ext_person.g_cm_type_id is null then
1442: hr_utility.set_location(' 514 error '|| p_ext_date_cd , 514);
1443:
1444: ben_ext_thread.g_err_num := 92451;
1445: ben_ext_thread.g_err_name := 'BEN_92451_EXT_INV_CM_DT';
1446: raise ben_ext_thread.g_job_failure_error;
1447:
1448: end if;
1441: if ben_ext_person.g_cm_type_id is null then
1442: hr_utility.set_location(' 514 error '|| p_ext_date_cd , 514);
1443:
1444: ben_ext_thread.g_err_num := 92451;
1445: ben_ext_thread.g_err_name := 'BEN_92451_EXT_INV_CM_DT';
1446: raise ben_ext_thread.g_job_failure_error;
1447:
1448: end if;
1449:
1442: hr_utility.set_location(' 514 error '|| p_ext_date_cd , 514);
1443:
1444: ben_ext_thread.g_err_num := 92451;
1445: ben_ext_thread.g_err_name := 'BEN_92451_EXT_INV_CM_DT';
1446: raise ben_ext_thread.g_job_failure_error;
1447:
1448: end if;
1449:
1450: if p_ext_date_cd = 'CTBSD' then --communication to be sent date
1450: if p_ext_date_cd = 'CTBSD' then --communication to be sent date
1451:
1452: if ben_ext_person.g_cm_to_be_sent_dt is null then
1453:
1454: ben_ext_thread.g_err_num := 92454;
1455: ben_ext_thread.g_err_name := 'BEN_92454_EXT_INV_TO_BE_SNT_DT';
1456: raise ben_ext_person.detail_error;
1457:
1458: else
1451:
1452: if ben_ext_person.g_cm_to_be_sent_dt is null then
1453:
1454: ben_ext_thread.g_err_num := 92454;
1455: ben_ext_thread.g_err_name := 'BEN_92454_EXT_INV_TO_BE_SNT_DT';
1456: raise ben_ext_person.detail_error;
1457:
1458: else
1459:
1468: elsif p_ext_date_cd = 'CLEOD' then -- communication life event occurred date
1469:
1470: if ben_ext_person.g_cm_lf_evt_ocrd_dt is null then
1471:
1472: ben_ext_thread.g_err_num := 92450;
1473: ben_ext_thread.g_err_name := 'BEN_92450_EXT_INV_LER_DT';
1474: raise ben_ext_person.detail_error;
1475:
1476: else
1469:
1470: if ben_ext_person.g_cm_lf_evt_ocrd_dt is null then
1471:
1472: ben_ext_thread.g_err_num := 92450;
1473: ben_ext_thread.g_err_name := 'BEN_92450_EXT_INV_LER_DT';
1474: raise ben_ext_person.detail_error;
1475:
1476: else
1477:
1482: else -- CDBLEOD communication day before life event occured date
1483:
1484: if ben_ext_person.g_cm_lf_evt_ocrd_dt is null then
1485:
1486: ben_ext_thread.g_err_num := 92450;
1487: ben_ext_thread.g_err_name := 'BEN_92450_EXT_INV_LER_DT';
1488: raise ben_ext_person.detail_error;
1489:
1490: else
1483:
1484: if ben_ext_person.g_cm_lf_evt_ocrd_dt is null then
1485:
1486: ben_ext_thread.g_err_num := 92450;
1487: ben_ext_thread.g_err_name := 'BEN_92450_EXT_INV_LER_DT';
1488: raise ben_ext_person.detail_error;
1489:
1490: else
1491:
1498: elsif p_ext_date_cd = 'CHAD' then
1499:
1500: if ben_ext_person.g_chg_actl_dt is null then
1501: hr_utility.set_location(' 514 error 1' , 514);
1502: ben_ext_thread.g_err_num := 92455;
1503: ben_ext_thread.g_err_name := 'BEN_92455_EXT_INV_CHG_DT';
1504: raise ben_ext_thread.g_job_failure_error;
1505:
1506: else
1499:
1500: if ben_ext_person.g_chg_actl_dt is null then
1501: hr_utility.set_location(' 514 error 1' , 514);
1502: ben_ext_thread.g_err_num := 92455;
1503: ben_ext_thread.g_err_name := 'BEN_92455_EXT_INV_CHG_DT';
1504: raise ben_ext_thread.g_job_failure_error;
1505:
1506: else
1507:
1500: if ben_ext_person.g_chg_actl_dt is null then
1501: hr_utility.set_location(' 514 error 1' , 514);
1502: ben_ext_thread.g_err_num := 92455;
1503: ben_ext_thread.g_err_name := 'BEN_92455_EXT_INV_CHG_DT';
1504: raise ben_ext_thread.g_job_failure_error;
1505:
1506: else
1507:
1508: l_rslt_dt := trunc(ben_ext_person.g_chg_actl_dt);
1513:
1514: if ben_ext_person.g_chg_eff_dt is null then
1515:
1516: hr_utility.set_location(' 514 error 2' , 514);
1517: ben_ext_thread.g_err_num := 92455;
1518: ben_ext_thread.g_err_name := 'BEN_92455_EXT_INV_CHG_DT';
1519: raise ben_ext_thread.g_job_failure_error;
1520:
1521: else
1514: if ben_ext_person.g_chg_eff_dt is null then
1515:
1516: hr_utility.set_location(' 514 error 2' , 514);
1517: ben_ext_thread.g_err_num := 92455;
1518: ben_ext_thread.g_err_name := 'BEN_92455_EXT_INV_CHG_DT';
1519: raise ben_ext_thread.g_job_failure_error;
1520:
1521: else
1522:
1515:
1516: hr_utility.set_location(' 514 error 2' , 514);
1517: ben_ext_thread.g_err_num := 92455;
1518: ben_ext_thread.g_err_name := 'BEN_92455_EXT_INV_CHG_DT';
1519: raise ben_ext_thread.g_job_failure_error;
1520:
1521: else
1522:
1523: l_rslt_dt := trunc(ben_ext_person.g_chg_eff_dt);
1839:
1840:
1841: else
1842: --
1843: ben_ext_thread.g_err_num := 91628;
1844: ben_ext_thread.g_err_name := 'BEN_91628_LOOKUP_TYPE_GENERIC';
1845: raise ben_ext_thread.g_job_failure_error;
1846: --
1847: end if;
1840:
1841: else
1842: --
1843: ben_ext_thread.g_err_num := 91628;
1844: ben_ext_thread.g_err_name := 'BEN_91628_LOOKUP_TYPE_GENERIC';
1845: raise ben_ext_thread.g_job_failure_error;
1846: --
1847: end if;
1848: --
1841: else
1842: --
1843: ben_ext_thread.g_err_num := 91628;
1844: ben_ext_thread.g_err_name := 'BEN_91628_LOOKUP_TYPE_GENERIC';
1845: raise ben_ext_thread.g_job_failure_error;
1846: --
1847: end if;
1848: --
1849: