DBA Data[Home] [Help]

APPS.BEN_EXT_UTIL dependencies on BEN_EXT_THREAD

Line 1444: ben_ext_thread.g_err_num := 92451;

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;

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

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:

Line 1446: raise ben_ext_thread.g_job_failure_error;

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

Line 1454: ben_ext_thread.g_err_num := 92454;

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

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

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:

Line 1472: ben_ext_thread.g_err_num := 92450;

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

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

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:

Line 1486: ben_ext_thread.g_err_num := 92450;

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

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

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:

Line 1502: ben_ext_thread.g_err_num := 92455;

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

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

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:

Line 1504: raise ben_ext_thread.g_job_failure_error;

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

Line 1517: ben_ext_thread.g_err_num := 92455;

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

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

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:

Line 1519: raise ben_ext_thread.g_job_failure_error;

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

Line 1843: ben_ext_thread.g_err_num := 91628;

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;

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

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

Line 1845: raise ben_ext_thread.g_job_failure_error;

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: