689: exception
690: --
691: when others then
692: --
693: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
694: fnd_message.set_token('PROC',l_proc);
695: --fnd_message.set_token('FORMULA',l_input_va_calc_rl_rec.input_va_calc_rl);
696: fnd_message.set_token('PARAMETER',g_outputs(l_count).name);
697: fnd_message.raise_error;
690: --
691: when others then
692: --
693: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
694: fnd_message.set_token('PROC',l_proc);
695: --fnd_message.set_token('FORMULA',l_input_va_calc_rl_rec.input_va_calc_rl);
696: fnd_message.set_token('PARAMETER',g_outputs(l_count).name);
697: fnd_message.raise_error;
698: --
691: when others then
692: --
693: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
694: fnd_message.set_token('PROC',l_proc);
695: --fnd_message.set_token('FORMULA',l_input_va_calc_rl_rec.input_va_calc_rl);
696: fnd_message.set_token('PARAMETER',g_outputs(l_count).name);
697: fnd_message.raise_error;
698: --
699: end;
692: --
693: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
694: fnd_message.set_token('PROC',l_proc);
695: --fnd_message.set_token('FORMULA',l_input_va_calc_rl_rec.input_va_calc_rl);
696: fnd_message.set_token('PARAMETER',g_outputs(l_count).name);
697: fnd_message.raise_error;
698: --
699: end;
700: --
693: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
694: fnd_message.set_token('PROC',l_proc);
695: --fnd_message.set_token('FORMULA',l_input_va_calc_rl_rec.input_va_calc_rl);
696: fnd_message.set_token('PARAMETER',g_outputs(l_count).name);
697: fnd_message.raise_error;
698: --
699: end;
700: --
701: end loop;
1197: close get_asmt_to_use_cd;
1198: if g_debug then
1199: hr_utility.set_location('BEN_91723_NO_ENRT_RT_ABR_FOUND',30);
1200: end if;
1201: fnd_message.set_name('BEN','BEN_91723_NO_ENRT_RT_ABR_FOUND');
1202: fnd_message.set_token('PROC',l_proc);
1203: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
1204: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
1205: fnd_message.raise_error;
1198: if g_debug then
1199: hr_utility.set_location('BEN_91723_NO_ENRT_RT_ABR_FOUND',30);
1200: end if;
1201: fnd_message.set_name('BEN','BEN_91723_NO_ENRT_RT_ABR_FOUND');
1202: fnd_message.set_token('PROC',l_proc);
1203: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
1204: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
1205: fnd_message.raise_error;
1206: else
1199: hr_utility.set_location('BEN_91723_NO_ENRT_RT_ABR_FOUND',30);
1200: end if;
1201: fnd_message.set_name('BEN','BEN_91723_NO_ENRT_RT_ABR_FOUND');
1202: fnd_message.set_token('PROC',l_proc);
1203: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
1204: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
1205: fnd_message.raise_error;
1206: else
1207: close get_asmt_to_use_cd;
1200: end if;
1201: fnd_message.set_name('BEN','BEN_91723_NO_ENRT_RT_ABR_FOUND');
1202: fnd_message.set_token('PROC',l_proc);
1203: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
1204: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
1205: fnd_message.raise_error;
1206: else
1207: close get_asmt_to_use_cd;
1208: end if;
1201: fnd_message.set_name('BEN','BEN_91723_NO_ENRT_RT_ABR_FOUND');
1202: fnd_message.set_token('PROC',l_proc);
1203: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
1204: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
1205: fnd_message.raise_error;
1206: else
1207: close get_asmt_to_use_cd;
1208: end if;
1209: --
1575: /*
1576: if g_debug then
1577: hr_utility.set_location('BEN_92458_NO_ASG_PAYROLL PERSON:'|| to_char(p_person_id),5);
1578: end if;
1579: fnd_message.set_name('BEN', 'BEN_92458_NO_ASG_PAYROLL');
1580: fnd_message.set_token('PROC',l_proc);
1581: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1582: fnd_message.set_token('ASSIGNMENT_ID',to_char(p_assignment_id));
1583: fnd_message.raise_error;
1576: if g_debug then
1577: hr_utility.set_location('BEN_92458_NO_ASG_PAYROLL PERSON:'|| to_char(p_person_id),5);
1578: end if;
1579: fnd_message.set_name('BEN', 'BEN_92458_NO_ASG_PAYROLL');
1580: fnd_message.set_token('PROC',l_proc);
1581: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1582: fnd_message.set_token('ASSIGNMENT_ID',to_char(p_assignment_id));
1583: fnd_message.raise_error;
1584: */
1577: hr_utility.set_location('BEN_92458_NO_ASG_PAYROLL PERSON:'|| to_char(p_person_id),5);
1578: end if;
1579: fnd_message.set_name('BEN', 'BEN_92458_NO_ASG_PAYROLL');
1580: fnd_message.set_token('PROC',l_proc);
1581: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1582: fnd_message.set_token('ASSIGNMENT_ID',to_char(p_assignment_id));
1583: fnd_message.raise_error;
1584: */
1585: if g_debug then
1578: end if;
1579: fnd_message.set_name('BEN', 'BEN_92458_NO_ASG_PAYROLL');
1580: fnd_message.set_token('PROC',l_proc);
1581: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1582: fnd_message.set_token('ASSIGNMENT_ID',to_char(p_assignment_id));
1583: fnd_message.raise_error;
1584: */
1585: if g_debug then
1586: hr_utility.set_location('BEN_93606_NO_ASG_PAYROLL PERSON:'|| to_char(p_person_id),5);
1579: fnd_message.set_name('BEN', 'BEN_92458_NO_ASG_PAYROLL');
1580: fnd_message.set_token('PROC',l_proc);
1581: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1582: fnd_message.set_token('ASSIGNMENT_ID',to_char(p_assignment_id));
1583: fnd_message.raise_error;
1584: */
1585: if g_debug then
1586: hr_utility.set_location('BEN_93606_NO_ASG_PAYROLL PERSON:'|| to_char(p_person_id),5);
1587: end if;
1584: */
1585: if g_debug then
1586: hr_utility.set_location('BEN_93606_NO_ASG_PAYROLL PERSON:'|| to_char(p_person_id),5);
1587: end if;
1588: fnd_message.set_name('BEN', 'BEN_93606_NO_ASG_PAYROLL');
1589: fnd_message.set_token('ABR_NAME', l_name);
1590: fnd_message.set_token('PROC',l_proc);
1591: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1592: fnd_message.set_token('ASSIGNMENT_ID',to_char(p_assignment_id));
1585: if g_debug then
1586: hr_utility.set_location('BEN_93606_NO_ASG_PAYROLL PERSON:'|| to_char(p_person_id),5);
1587: end if;
1588: fnd_message.set_name('BEN', 'BEN_93606_NO_ASG_PAYROLL');
1589: fnd_message.set_token('ABR_NAME', l_name);
1590: fnd_message.set_token('PROC',l_proc);
1591: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1592: fnd_message.set_token('ASSIGNMENT_ID',to_char(p_assignment_id));
1593: fnd_message.raise_error;
1586: hr_utility.set_location('BEN_93606_NO_ASG_PAYROLL PERSON:'|| to_char(p_person_id),5);
1587: end if;
1588: fnd_message.set_name('BEN', 'BEN_93606_NO_ASG_PAYROLL');
1589: fnd_message.set_token('ABR_NAME', l_name);
1590: fnd_message.set_token('PROC',l_proc);
1591: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1592: fnd_message.set_token('ASSIGNMENT_ID',to_char(p_assignment_id));
1593: fnd_message.raise_error;
1594: end if;
1587: end if;
1588: fnd_message.set_name('BEN', 'BEN_93606_NO_ASG_PAYROLL');
1589: fnd_message.set_token('ABR_NAME', l_name);
1590: fnd_message.set_token('PROC',l_proc);
1591: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1592: fnd_message.set_token('ASSIGNMENT_ID',to_char(p_assignment_id));
1593: fnd_message.raise_error;
1594: end if;
1595: --
1588: fnd_message.set_name('BEN', 'BEN_93606_NO_ASG_PAYROLL');
1589: fnd_message.set_token('ABR_NAME', l_name);
1590: fnd_message.set_token('PROC',l_proc);
1591: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1592: fnd_message.set_token('ASSIGNMENT_ID',to_char(p_assignment_id));
1593: fnd_message.raise_error;
1594: end if;
1595: --
1596: end if;
1589: fnd_message.set_token('ABR_NAME', l_name);
1590: fnd_message.set_token('PROC',l_proc);
1591: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1592: fnd_message.set_token('ASSIGNMENT_ID',to_char(p_assignment_id));
1593: fnd_message.raise_error;
1594: end if;
1595: --
1596: end if;
1597: --
1620: /*
1621: if g_debug then
1622: hr_utility.set_location('BEN_92458_NO_ASG_PAYROLL PERSON:'|| to_char(p_person_id),5);
1623: end if;
1624: fnd_message.set_name('BEN', 'BEN_92458_NO_ASG_PAYROLL');
1625: fnd_message.set_token('PROC',l_proc);
1626: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1627: fnd_message.set_token('ASSIGNMENT_ID',to_char(p_assignment_id));
1628: fnd_message.raise_error;
1621: if g_debug then
1622: hr_utility.set_location('BEN_92458_NO_ASG_PAYROLL PERSON:'|| to_char(p_person_id),5);
1623: end if;
1624: fnd_message.set_name('BEN', 'BEN_92458_NO_ASG_PAYROLL');
1625: fnd_message.set_token('PROC',l_proc);
1626: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1627: fnd_message.set_token('ASSIGNMENT_ID',to_char(p_assignment_id));
1628: fnd_message.raise_error;
1629: */
1622: hr_utility.set_location('BEN_92458_NO_ASG_PAYROLL PERSON:'|| to_char(p_person_id),5);
1623: end if;
1624: fnd_message.set_name('BEN', 'BEN_92458_NO_ASG_PAYROLL');
1625: fnd_message.set_token('PROC',l_proc);
1626: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1627: fnd_message.set_token('ASSIGNMENT_ID',to_char(p_assignment_id));
1628: fnd_message.raise_error;
1629: */
1630: if g_debug then
1623: end if;
1624: fnd_message.set_name('BEN', 'BEN_92458_NO_ASG_PAYROLL');
1625: fnd_message.set_token('PROC',l_proc);
1626: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1627: fnd_message.set_token('ASSIGNMENT_ID',to_char(p_assignment_id));
1628: fnd_message.raise_error;
1629: */
1630: if g_debug then
1631: hr_utility.set_location('BEN_93606_NO_ASG_PAYROLL PERSON:'|| to_char(p_person_id),5);
1624: fnd_message.set_name('BEN', 'BEN_92458_NO_ASG_PAYROLL');
1625: fnd_message.set_token('PROC',l_proc);
1626: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1627: fnd_message.set_token('ASSIGNMENT_ID',to_char(p_assignment_id));
1628: fnd_message.raise_error;
1629: */
1630: if g_debug then
1631: hr_utility.set_location('BEN_93606_NO_ASG_PAYROLL PERSON:'|| to_char(p_person_id),5);
1632: end if;
1629: */
1630: if g_debug then
1631: hr_utility.set_location('BEN_93606_NO_ASG_PAYROLL PERSON:'|| to_char(p_person_id),5);
1632: end if;
1633: fnd_message.set_name('BEN', 'BEN_93606_NO_ASG_PAYROLL');
1634: fnd_message.set_token('ABR_NAME', l_name);
1635: fnd_message.set_token('PROC',l_proc);
1636: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1637: fnd_message.set_token('ASSIGNMENT_ID',to_char(p_assignment_id));
1630: if g_debug then
1631: hr_utility.set_location('BEN_93606_NO_ASG_PAYROLL PERSON:'|| to_char(p_person_id),5);
1632: end if;
1633: fnd_message.set_name('BEN', 'BEN_93606_NO_ASG_PAYROLL');
1634: fnd_message.set_token('ABR_NAME', l_name);
1635: fnd_message.set_token('PROC',l_proc);
1636: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1637: fnd_message.set_token('ASSIGNMENT_ID',to_char(p_assignment_id));
1638: fnd_message.raise_error;
1631: hr_utility.set_location('BEN_93606_NO_ASG_PAYROLL PERSON:'|| to_char(p_person_id),5);
1632: end if;
1633: fnd_message.set_name('BEN', 'BEN_93606_NO_ASG_PAYROLL');
1634: fnd_message.set_token('ABR_NAME', l_name);
1635: fnd_message.set_token('PROC',l_proc);
1636: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1637: fnd_message.set_token('ASSIGNMENT_ID',to_char(p_assignment_id));
1638: fnd_message.raise_error;
1639: end if;
1632: end if;
1633: fnd_message.set_name('BEN', 'BEN_93606_NO_ASG_PAYROLL');
1634: fnd_message.set_token('ABR_NAME', l_name);
1635: fnd_message.set_token('PROC',l_proc);
1636: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1637: fnd_message.set_token('ASSIGNMENT_ID',to_char(p_assignment_id));
1638: fnd_message.raise_error;
1639: end if;
1640: end if;
1633: fnd_message.set_name('BEN', 'BEN_93606_NO_ASG_PAYROLL');
1634: fnd_message.set_token('ABR_NAME', l_name);
1635: fnd_message.set_token('PROC',l_proc);
1636: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1637: fnd_message.set_token('ASSIGNMENT_ID',to_char(p_assignment_id));
1638: fnd_message.raise_error;
1639: end if;
1640: end if;
1641: return TRUE;
1634: fnd_message.set_token('ABR_NAME', l_name);
1635: fnd_message.set_token('PROC',l_proc);
1636: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1637: fnd_message.set_token('ASSIGNMENT_ID',to_char(p_assignment_id));
1638: fnd_message.raise_error;
1639: end if;
1640: end if;
1641: return TRUE;
1642: --
1649: if p_payroll_id is null then
1650: if g_debug then
1651: hr_utility.set_location('BEN_92347_NO_DFLT_PAYROLL',25);
1652: end if;
1653: fnd_message.set_name('BEN', 'BEN_92347_NO_DFLT_PAYROLL');
1654: fnd_message.set_token('PROC',l_proc);
1655: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1656: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
1657: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
1650: if g_debug then
1651: hr_utility.set_location('BEN_92347_NO_DFLT_PAYROLL',25);
1652: end if;
1653: fnd_message.set_name('BEN', 'BEN_92347_NO_DFLT_PAYROLL');
1654: fnd_message.set_token('PROC',l_proc);
1655: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1656: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
1657: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
1658: fnd_message.raise_error;
1651: hr_utility.set_location('BEN_92347_NO_DFLT_PAYROLL',25);
1652: end if;
1653: fnd_message.set_name('BEN', 'BEN_92347_NO_DFLT_PAYROLL');
1654: fnd_message.set_token('PROC',l_proc);
1655: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1656: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
1657: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
1658: fnd_message.raise_error;
1659: else
1652: end if;
1653: fnd_message.set_name('BEN', 'BEN_92347_NO_DFLT_PAYROLL');
1654: fnd_message.set_token('PROC',l_proc);
1655: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1656: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
1657: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
1658: fnd_message.raise_error;
1659: else
1660: if g_debug then
1653: fnd_message.set_name('BEN', 'BEN_92347_NO_DFLT_PAYROLL');
1654: fnd_message.set_token('PROC',l_proc);
1655: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1656: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
1657: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
1658: fnd_message.raise_error;
1659: else
1660: if g_debug then
1661: hr_utility.set_location('Leaving-returning false:' ||l_proc,5);
1654: fnd_message.set_token('PROC',l_proc);
1655: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1656: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
1657: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
1658: fnd_message.raise_error;
1659: else
1660: if g_debug then
1661: hr_utility.set_location('Leaving-returning false:' ||l_proc,5);
1662: end if;
1856: when others then
1857: if g_debug then
1858: hr_utility.set_location('BEN_92311_FORMULA_VAL_PARAM',5);
1859: end if;
1860: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
1861: fnd_message.set_token('PROC',l_proc);
1862: fnd_message.set_token('FORMULA',p_prtl_mo_det_mthd_rl);
1863: fnd_message.set_token('PARAMETER',l_outputs(l_outputs.first).name);
1864: fnd_message.raise_error;
1857: if g_debug then
1858: hr_utility.set_location('BEN_92311_FORMULA_VAL_PARAM',5);
1859: end if;
1860: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
1861: fnd_message.set_token('PROC',l_proc);
1862: fnd_message.set_token('FORMULA',p_prtl_mo_det_mthd_rl);
1863: fnd_message.set_token('PARAMETER',l_outputs(l_outputs.first).name);
1864: fnd_message.raise_error;
1865: --
1858: hr_utility.set_location('BEN_92311_FORMULA_VAL_PARAM',5);
1859: end if;
1860: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
1861: fnd_message.set_token('PROC',l_proc);
1862: fnd_message.set_token('FORMULA',p_prtl_mo_det_mthd_rl);
1863: fnd_message.set_token('PARAMETER',l_outputs(l_outputs.first).name);
1864: fnd_message.raise_error;
1865: --
1866: end;
1859: end if;
1860: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
1861: fnd_message.set_token('PROC',l_proc);
1862: fnd_message.set_token('FORMULA',p_prtl_mo_det_mthd_rl);
1863: fnd_message.set_token('PARAMETER',l_outputs(l_outputs.first).name);
1864: fnd_message.raise_error;
1865: --
1866: end;
1867: end if;
1860: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
1861: fnd_message.set_token('PROC',l_proc);
1862: fnd_message.set_token('FORMULA',p_prtl_mo_det_mthd_rl);
1863: fnd_message.set_token('PARAMETER',l_outputs(l_outputs.first).name);
1864: fnd_message.raise_error;
1865: --
1866: end;
1867: end if;
1868: --
1969: --
1970: if g_debug then
1971: hr_utility.set_location('BEN_92343_NO_PCT_VAL_OR_RL',5);
1972: end if;
1973: fnd_message.set_name('BEN', 'BEN_92343_NO_PCT_VAL_OR_RL');
1974: fnd_message.set_token('PROC',l_proc);
1975: fnd_message.set_token('PRTL_MO_RT_PRTN_VAL_ID',
1976: to_char(p_rec.prtl_mo_rt_prtn_val_id));
1977: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
1970: if g_debug then
1971: hr_utility.set_location('BEN_92343_NO_PCT_VAL_OR_RL',5);
1972: end if;
1973: fnd_message.set_name('BEN', 'BEN_92343_NO_PCT_VAL_OR_RL');
1974: fnd_message.set_token('PROC',l_proc);
1975: fnd_message.set_token('PRTL_MO_RT_PRTN_VAL_ID',
1976: to_char(p_rec.prtl_mo_rt_prtn_val_id));
1977: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
1978: fnd_message.set_token('ACTL_PREM_ID',to_char(p_actl_prem_id));
1971: hr_utility.set_location('BEN_92343_NO_PCT_VAL_OR_RL',5);
1972: end if;
1973: fnd_message.set_name('BEN', 'BEN_92343_NO_PCT_VAL_OR_RL');
1974: fnd_message.set_token('PROC',l_proc);
1975: fnd_message.set_token('PRTL_MO_RT_PRTN_VAL_ID',
1976: to_char(p_rec.prtl_mo_rt_prtn_val_id));
1977: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
1978: fnd_message.set_token('ACTL_PREM_ID',to_char(p_actl_prem_id));
1979: fnd_message.set_token('CVG_AMT_CALC_MTHD_ID',
1973: fnd_message.set_name('BEN', 'BEN_92343_NO_PCT_VAL_OR_RL');
1974: fnd_message.set_token('PROC',l_proc);
1975: fnd_message.set_token('PRTL_MO_RT_PRTN_VAL_ID',
1976: to_char(p_rec.prtl_mo_rt_prtn_val_id));
1977: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
1978: fnd_message.set_token('ACTL_PREM_ID',to_char(p_actl_prem_id));
1979: fnd_message.set_token('CVG_AMT_CALC_MTHD_ID',
1980: to_char(p_cvg_amt_calc_mthd_id));
1981: fnd_message.raise_error;
1974: fnd_message.set_token('PROC',l_proc);
1975: fnd_message.set_token('PRTL_MO_RT_PRTN_VAL_ID',
1976: to_char(p_rec.prtl_mo_rt_prtn_val_id));
1977: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
1978: fnd_message.set_token('ACTL_PREM_ID',to_char(p_actl_prem_id));
1979: fnd_message.set_token('CVG_AMT_CALC_MTHD_ID',
1980: to_char(p_cvg_amt_calc_mthd_id));
1981: fnd_message.raise_error;
1982: else
1975: fnd_message.set_token('PRTL_MO_RT_PRTN_VAL_ID',
1976: to_char(p_rec.prtl_mo_rt_prtn_val_id));
1977: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
1978: fnd_message.set_token('ACTL_PREM_ID',to_char(p_actl_prem_id));
1979: fnd_message.set_token('CVG_AMT_CALC_MTHD_ID',
1980: to_char(p_cvg_amt_calc_mthd_id));
1981: fnd_message.raise_error;
1982: else
1983: --
1977: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
1978: fnd_message.set_token('ACTL_PREM_ID',to_char(p_actl_prem_id));
1979: fnd_message.set_token('CVG_AMT_CALC_MTHD_ID',
1980: to_char(p_cvg_amt_calc_mthd_id));
1981: fnd_message.raise_error;
1982: else
1983: --
1984: -- Get the choice id. 14076301.
1985: --
2017: when others then
2018: if g_debug then
2019: hr_utility.set_location('BEN_92311_FORMULA_VAL_PARAM',15);
2020: end if;
2021: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
2022: fnd_message.set_token('PROC',l_proc);
2023: fnd_message.set_token('FORMULA',p_rec.prtl_mo_prortn_rl);
2024: fnd_message.set_token('PARAMETER',
2025: l_outputs(l_outputs.first).name);
2018: if g_debug then
2019: hr_utility.set_location('BEN_92311_FORMULA_VAL_PARAM',15);
2020: end if;
2021: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
2022: fnd_message.set_token('PROC',l_proc);
2023: fnd_message.set_token('FORMULA',p_rec.prtl_mo_prortn_rl);
2024: fnd_message.set_token('PARAMETER',
2025: l_outputs(l_outputs.first).name);
2026: fnd_message.raise_error;
2019: hr_utility.set_location('BEN_92311_FORMULA_VAL_PARAM',15);
2020: end if;
2021: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
2022: fnd_message.set_token('PROC',l_proc);
2023: fnd_message.set_token('FORMULA',p_rec.prtl_mo_prortn_rl);
2024: fnd_message.set_token('PARAMETER',
2025: l_outputs(l_outputs.first).name);
2026: fnd_message.raise_error;
2027: --
2020: end if;
2021: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
2022: fnd_message.set_token('PROC',l_proc);
2023: fnd_message.set_token('FORMULA',p_rec.prtl_mo_prortn_rl);
2024: fnd_message.set_token('PARAMETER',
2025: l_outputs(l_outputs.first).name);
2026: fnd_message.raise_error;
2027: --
2028: end;
2022: fnd_message.set_token('PROC',l_proc);
2023: fnd_message.set_token('FORMULA',p_rec.prtl_mo_prortn_rl);
2024: fnd_message.set_token('PARAMETER',
2025: l_outputs(l_outputs.first).name);
2026: fnd_message.raise_error;
2027: --
2028: end;
2029: --
2030: end if;
2107: --
2108: if g_debug then
2109: hr_utility.set_location('BEN_92348_UNKNOWN_PRTN_DET_CD',15);
2110: end if;
2111: fnd_message.set_name('BEN', 'BEN_92348_UNKNOWN_PRTN_DET_CD');
2112: fnd_message.set_token('PROC',l_proc);
2113: fnd_message.set_token('PRTL_MO_DET_MTHD_CD',p_prtl_mo_det_mthd_cd);
2114: fnd_message.raise_error;
2115: end if;
2108: if g_debug then
2109: hr_utility.set_location('BEN_92348_UNKNOWN_PRTN_DET_CD',15);
2110: end if;
2111: fnd_message.set_name('BEN', 'BEN_92348_UNKNOWN_PRTN_DET_CD');
2112: fnd_message.set_token('PROC',l_proc);
2113: fnd_message.set_token('PRTL_MO_DET_MTHD_CD',p_prtl_mo_det_mthd_cd);
2114: fnd_message.raise_error;
2115: end if;
2116: --
2109: hr_utility.set_location('BEN_92348_UNKNOWN_PRTN_DET_CD',15);
2110: end if;
2111: fnd_message.set_name('BEN', 'BEN_92348_UNKNOWN_PRTN_DET_CD');
2112: fnd_message.set_token('PROC',l_proc);
2113: fnd_message.set_token('PRTL_MO_DET_MTHD_CD',p_prtl_mo_det_mthd_cd);
2114: fnd_message.raise_error;
2115: end if;
2116: --
2117: if (p_rndg_cd is not null or
2110: end if;
2111: fnd_message.set_name('BEN', 'BEN_92348_UNKNOWN_PRTN_DET_CD');
2112: fnd_message.set_token('PROC',l_proc);
2113: fnd_message.set_token('PRTL_MO_DET_MTHD_CD',p_prtl_mo_det_mthd_cd);
2114: fnd_message.raise_error;
2115: end if;
2116: --
2117: if (p_rndg_cd is not null or
2118: p_rndg_rl is not null) and
2346: if c_getasgdets%notfound then
2347: --
2348: close c_getasgdets;
2349: --
2350: fnd_message.set_name('BEN', 'BEN_93289_ASG_ABR_NOT_FOUND');
2351: fnd_message.set_token('ACTY_BASE_RT_NAME',g_acty_base_rt_name);
2352: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
2353: if g_debug then
2354: hr_utility.set_location('ASG: BEN_93289_ASG_ABR_NOT_FOUND',5); -- 2105656
2347: --
2348: close c_getasgdets;
2349: --
2350: fnd_message.set_name('BEN', 'BEN_93289_ASG_ABR_NOT_FOUND');
2351: fnd_message.set_token('ACTY_BASE_RT_NAME',g_acty_base_rt_name);
2352: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
2353: if g_debug then
2354: hr_utility.set_location('ASG: BEN_93289_ASG_ABR_NOT_FOUND',5); -- 2105656
2355: end if;
2348: close c_getasgdets;
2349: --
2350: fnd_message.set_name('BEN', 'BEN_93289_ASG_ABR_NOT_FOUND');
2351: fnd_message.set_token('ACTY_BASE_RT_NAME',g_acty_base_rt_name);
2352: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
2353: if g_debug then
2354: hr_utility.set_location('ASG: BEN_93289_ASG_ABR_NOT_FOUND',5); -- 2105656
2355: end if;
2356: fnd_message.raise_error;
2352: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
2353: if g_debug then
2354: hr_utility.set_location('ASG: BEN_93289_ASG_ABR_NOT_FOUND',5); -- 2105656
2355: end if;
2356: fnd_message.raise_error;
2357: --
2358: end if;
2359: if g_debug then
2360: hr_utility.set_location('c_getasgdets is not null',999);
2460: end loop;
2461: --
2462: if l_link_count = 0 then
2463: --
2464: fnd_message.set_name('BEN', 'BEN_92344_NO_ELEMENT_LINK');
2465: fnd_message.set_token('PROC',l_proc);
2466: fnd_message.set_token('ASSIGNMENT_ID',to_char(p_assignment_id));
2467: fnd_message.set_token('ELEMENT_TYPE_ID',to_char(p_element_type_id));
2468: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
2461: --
2462: if l_link_count = 0 then
2463: --
2464: fnd_message.set_name('BEN', 'BEN_92344_NO_ELEMENT_LINK');
2465: fnd_message.set_token('PROC',l_proc);
2466: fnd_message.set_token('ASSIGNMENT_ID',to_char(p_assignment_id));
2467: fnd_message.set_token('ELEMENT_TYPE_ID',to_char(p_element_type_id));
2468: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
2469: if g_debug then
2462: if l_link_count = 0 then
2463: --
2464: fnd_message.set_name('BEN', 'BEN_92344_NO_ELEMENT_LINK');
2465: fnd_message.set_token('PROC',l_proc);
2466: fnd_message.set_token('ASSIGNMENT_ID',to_char(p_assignment_id));
2467: fnd_message.set_token('ELEMENT_TYPE_ID',to_char(p_element_type_id));
2468: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
2469: if g_debug then
2470: hr_utility.set_location('ELK: BEN_92344_NO_ELEMENT_LINK',5);
2463: --
2464: fnd_message.set_name('BEN', 'BEN_92344_NO_ELEMENT_LINK');
2465: fnd_message.set_token('PROC',l_proc);
2466: fnd_message.set_token('ASSIGNMENT_ID',to_char(p_assignment_id));
2467: fnd_message.set_token('ELEMENT_TYPE_ID',to_char(p_element_type_id));
2468: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
2469: if g_debug then
2470: hr_utility.set_location('ELK: BEN_92344_NO_ELEMENT_LINK',5);
2471: end if;
2464: fnd_message.set_name('BEN', 'BEN_92344_NO_ELEMENT_LINK');
2465: fnd_message.set_token('PROC',l_proc);
2466: fnd_message.set_token('ASSIGNMENT_ID',to_char(p_assignment_id));
2467: fnd_message.set_token('ELEMENT_TYPE_ID',to_char(p_element_type_id));
2468: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
2469: if g_debug then
2470: hr_utility.set_location('ELK: BEN_92344_NO_ELEMENT_LINK',5);
2471: end if;
2472: --
2471: end if;
2472: --
2473: elsif l_elk_count = 0 then -- bug 2105656
2474: --
2475: fnd_message.set_name('BEN', 'BEN_93288_ASG_ELEM_LNK_INELIG');
2476: fnd_message.set_token('ASSIGNMENT_ID',to_char(p_assignment_id));
2477: fnd_message.set_token('ELEMENT_TYPE_ID',to_char(p_element_type_id));
2478: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
2479: if g_debug then
2472: --
2473: elsif l_elk_count = 0 then -- bug 2105656
2474: --
2475: fnd_message.set_name('BEN', 'BEN_93288_ASG_ELEM_LNK_INELIG');
2476: fnd_message.set_token('ASSIGNMENT_ID',to_char(p_assignment_id));
2477: fnd_message.set_token('ELEMENT_TYPE_ID',to_char(p_element_type_id));
2478: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
2479: if g_debug then
2480: hr_utility.set_location('ELK: BEN_93288_ASG_ELEM_LNK_INELIG',6);
2473: elsif l_elk_count = 0 then -- bug 2105656
2474: --
2475: fnd_message.set_name('BEN', 'BEN_93288_ASG_ELEM_LNK_INELIG');
2476: fnd_message.set_token('ASSIGNMENT_ID',to_char(p_assignment_id));
2477: fnd_message.set_token('ELEMENT_TYPE_ID',to_char(p_element_type_id));
2478: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
2479: if g_debug then
2480: hr_utility.set_location('ELK: BEN_93288_ASG_ELEM_LNK_INELIG',6);
2481: end if;
2474: --
2475: fnd_message.set_name('BEN', 'BEN_93288_ASG_ELEM_LNK_INELIG');
2476: fnd_message.set_token('ASSIGNMENT_ID',to_char(p_assignment_id));
2477: fnd_message.set_token('ELEMENT_TYPE_ID',to_char(p_element_type_id));
2478: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
2479: if g_debug then
2480: hr_utility.set_location('ELK: BEN_93288_ASG_ELEM_LNK_INELIG',6);
2481: end if;
2482: --
2615: if c_chk_rt%found then
2616: --
2617: close c_future_ee;
2618: close c_chk_rt;
2619: fnd_message.set_name('BEN','BEN_93448_FUTURE_BEN_ENTRY');
2620: fnd_message.set_token('P_RATE',l_rt_rec.rt_name);
2621: fnd_message.set_token('P_DATE',to_char(l_future_ee_rec.effective_start_date));
2622: fnd_message.raise_error;
2623: --
2616: --
2617: close c_future_ee;
2618: close c_chk_rt;
2619: fnd_message.set_name('BEN','BEN_93448_FUTURE_BEN_ENTRY');
2620: fnd_message.set_token('P_RATE',l_rt_rec.rt_name);
2621: fnd_message.set_token('P_DATE',to_char(l_future_ee_rec.effective_start_date));
2622: fnd_message.raise_error;
2623: --
2624: end if;
2617: close c_future_ee;
2618: close c_chk_rt;
2619: fnd_message.set_name('BEN','BEN_93448_FUTURE_BEN_ENTRY');
2620: fnd_message.set_token('P_RATE',l_rt_rec.rt_name);
2621: fnd_message.set_token('P_DATE',to_char(l_future_ee_rec.effective_start_date));
2622: fnd_message.raise_error;
2623: --
2624: end if;
2625: close c_chk_rt;
2618: close c_chk_rt;
2619: fnd_message.set_name('BEN','BEN_93448_FUTURE_BEN_ENTRY');
2620: fnd_message.set_token('P_RATE',l_rt_rec.rt_name);
2621: fnd_message.set_token('P_DATE',to_char(l_future_ee_rec.effective_start_date));
2622: fnd_message.raise_error;
2623: --
2624: end if;
2625: close c_chk_rt;
2626: py_element_entry_api.delete_element_entry
2638: -- User created entry. Throw error
2639: --
2640: if p_multiple_entries_flag ='N' then
2641: close c_future_ee;
2642: fnd_message.set_name('BEN','BEN_93447_FUTURE_USER_ENTRY');
2643: fnd_message.set_token('P_DATE',to_char(l_future_ee_rec.effective_start_date));
2644: fnd_message.set_token('P_ELEMENT',l_future_ee_rec.element_name);
2645: fnd_message.raise_error;
2646: end if;
2639: --
2640: if p_multiple_entries_flag ='N' then
2641: close c_future_ee;
2642: fnd_message.set_name('BEN','BEN_93447_FUTURE_USER_ENTRY');
2643: fnd_message.set_token('P_DATE',to_char(l_future_ee_rec.effective_start_date));
2644: fnd_message.set_token('P_ELEMENT',l_future_ee_rec.element_name);
2645: fnd_message.raise_error;
2646: end if;
2647: end if;
2640: if p_multiple_entries_flag ='N' then
2641: close c_future_ee;
2642: fnd_message.set_name('BEN','BEN_93447_FUTURE_USER_ENTRY');
2643: fnd_message.set_token('P_DATE',to_char(l_future_ee_rec.effective_start_date));
2644: fnd_message.set_token('P_ELEMENT',l_future_ee_rec.element_name);
2645: fnd_message.raise_error;
2646: end if;
2647: end if;
2648:
2641: close c_future_ee;
2642: fnd_message.set_name('BEN','BEN_93447_FUTURE_USER_ENTRY');
2643: fnd_message.set_token('P_DATE',to_char(l_future_ee_rec.effective_start_date));
2644: fnd_message.set_token('P_ELEMENT',l_future_ee_rec.element_name);
2645: fnd_message.raise_error;
2646: end if;
2647: end if;
2648:
2649: end loop;
3782: when others then
3783: ben_on_line_lf_evt.get_ser_message(l_encoded_message,
3784: l_app_short_name,
3785: l_message_name);
3786: l_encoded_message := fnd_message.get;
3787: --
3788: if l_message_name like '%HR_6284_ELE_ENTRY_DT_ASG_DEL%' or
3789: l_message_name like '%HR_7187_DT_CANNOT_EXTEND_END%' then
3790: -- assignment is not eligible for link beyond this date.
3792: --
3793: null;
3794: else
3795: if l_app_short_name is not null then
3796: fnd_message.set_name(l_app_short_name,l_message_name);
3797: fnd_message.raise_error;
3798: else
3799: raise;
3800: end if;
3793: null;
3794: else
3795: if l_app_short_name is not null then
3796: fnd_message.set_name(l_app_short_name,l_message_name);
3797: fnd_message.raise_error;
3798: else
3799: raise;
3800: end if;
3801: end if;
4043: when others then
4044: ben_on_line_lf_evt.get_ser_message(l_encoded_message,
4045: l_app_short_name,
4046: l_message_name);
4047: l_encoded_message := fnd_message.get;
4048: --
4049: if l_message_name like '%HR_6284_ELE_ENTRY_DT_ASG_DEL%' or
4050: l_message_name like '%HR_7187_DT_CANNOT_EXTEND_END%' then
4051: -- assignment is not eligible for link beyond this date.
4053: --
4054: null;
4055: else
4056: if l_app_short_name is not null then
4057: fnd_message.set_name(l_app_short_name,l_message_name);
4058: fnd_message.raise_error;
4059: else
4060: raise;
4061: end if;
4054: null;
4055: else
4056: if l_app_short_name is not null then
4057: fnd_message.set_name(l_app_short_name,l_message_name);
4058: fnd_message.raise_error;
4059: else
4060: raise;
4061: end if;
4062: end if;
4110: hr_utility.set_location('BEN_92103_NO_PRTT_RT_VAL',170);
4111: end if;
4112: close c_get_prtt_rt_val;
4113: --
4114: fnd_message.set_name('BEN', 'BEN_92103_NO_PRTT_RT_VAL');
4115: fnd_message.set_token('PROC',l_proc);
4116: fnd_message.set_token('PRTT_RT_VAL',to_char(p_prtt_rt_val_id));
4117: fnd_message.raise_error;
4118: --
4111: end if;
4112: close c_get_prtt_rt_val;
4113: --
4114: fnd_message.set_name('BEN', 'BEN_92103_NO_PRTT_RT_VAL');
4115: fnd_message.set_token('PROC',l_proc);
4116: fnd_message.set_token('PRTT_RT_VAL',to_char(p_prtt_rt_val_id));
4117: fnd_message.raise_error;
4118: --
4119: end if;
4112: close c_get_prtt_rt_val;
4113: --
4114: fnd_message.set_name('BEN', 'BEN_92103_NO_PRTT_RT_VAL');
4115: fnd_message.set_token('PROC',l_proc);
4116: fnd_message.set_token('PRTT_RT_VAL',to_char(p_prtt_rt_val_id));
4117: fnd_message.raise_error;
4118: --
4119: end if;
4120: close c_get_prtt_rt_val;
4113: --
4114: fnd_message.set_name('BEN', 'BEN_92103_NO_PRTT_RT_VAL');
4115: fnd_message.set_token('PROC',l_proc);
4116: fnd_message.set_token('PRTT_RT_VAL',to_char(p_prtt_rt_val_id));
4117: fnd_message.raise_error;
4118: --
4119: end if;
4120: close c_get_prtt_rt_val;
4121: end if;
4146: close get_abr_info;
4147: if g_debug then
4148: hr_utility.set_location('BEN_91723_NO_ENRT_RT_ABR_FOUND',5);
4149: end if;
4150: fnd_message.set_name('BEN','BEN_91723_NO_ENRT_RT_ABR_FOUND');
4151: fnd_message.set_token('PROC',l_proc);
4152: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
4153: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
4154: fnd_message.raise_error;
4147: if g_debug then
4148: hr_utility.set_location('BEN_91723_NO_ENRT_RT_ABR_FOUND',5);
4149: end if;
4150: fnd_message.set_name('BEN','BEN_91723_NO_ENRT_RT_ABR_FOUND');
4151: fnd_message.set_token('PROC',l_proc);
4152: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
4153: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
4154: fnd_message.raise_error;
4155: end if;
4148: hr_utility.set_location('BEN_91723_NO_ENRT_RT_ABR_FOUND',5);
4149: end if;
4150: fnd_message.set_name('BEN','BEN_91723_NO_ENRT_RT_ABR_FOUND');
4151: fnd_message.set_token('PROC',l_proc);
4152: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
4153: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
4154: fnd_message.raise_error;
4155: end if;
4156: close get_abr_info;
4149: end if;
4150: fnd_message.set_name('BEN','BEN_91723_NO_ENRT_RT_ABR_FOUND');
4151: fnd_message.set_token('PROC',l_proc);
4152: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
4153: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
4154: fnd_message.raise_error;
4155: end if;
4156: close get_abr_info;
4157:
4150: fnd_message.set_name('BEN','BEN_91723_NO_ENRT_RT_ABR_FOUND');
4151: fnd_message.set_token('PROC',l_proc);
4152: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
4153: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
4154: fnd_message.raise_error;
4155: end if;
4156: close get_abr_info;
4157:
4158: g_acty_base_rt_name := l_get_abr_info.name;
4269: if l_element_link_id is null then
4270: --
4271: -- error message already set on stack.
4272: --
4273: fnd_message.raise_error;
4274: end if;
4275:
4276: l_old_element_link_id := l_element_link_id;
4277:
4422: fetch c_dup_prv into l_abr_name;
4423: if c_dup_prv%found then
4424: --
4425: close c_dup_prv;
4426: fnd_message.set_name('BEN','BEN_92690_ELMNT_ALRDY_USD');
4427: fnd_message.set_token('P_RATE1',l_abr_name);
4428: fnd_message.set_token('P_RATE2',g_acty_base_rt_name);
4429: fnd_message.raise_error;
4430: --
4423: if c_dup_prv%found then
4424: --
4425: close c_dup_prv;
4426: fnd_message.set_name('BEN','BEN_92690_ELMNT_ALRDY_USD');
4427: fnd_message.set_token('P_RATE1',l_abr_name);
4428: fnd_message.set_token('P_RATE2',g_acty_base_rt_name);
4429: fnd_message.raise_error;
4430: --
4431: end if;
4424: --
4425: close c_dup_prv;
4426: fnd_message.set_name('BEN','BEN_92690_ELMNT_ALRDY_USD');
4427: fnd_message.set_token('P_RATE1',l_abr_name);
4428: fnd_message.set_token('P_RATE2',g_acty_base_rt_name);
4429: fnd_message.raise_error;
4430: --
4431: end if;
4432: close c_dup_prv;
4425: close c_dup_prv;
4426: fnd_message.set_name('BEN','BEN_92690_ELMNT_ALRDY_USD');
4427: fnd_message.set_token('P_RATE1',l_abr_name);
4428: fnd_message.set_token('P_RATE2',g_acty_base_rt_name);
4429: fnd_message.raise_error;
4430: --
4431: end if;
4432: close c_dup_prv;
4433: --
4437: fetch c_dup_rslt into l_abr_name;
4438: if c_dup_rslt%found then
4439: --
4440: close c_dup_rslt;
4441: fnd_message.set_name('BEN','BEN_93450_ELE_MULTIPLE_RSLT');
4442: fnd_message.set_token('P_RATE1',l_abr_name);
4443: fnd_message.set_token('P_RATE2',g_acty_base_rt_name);
4444: fnd_message.raise_error;
4445: --
4438: if c_dup_rslt%found then
4439: --
4440: close c_dup_rslt;
4441: fnd_message.set_name('BEN','BEN_93450_ELE_MULTIPLE_RSLT');
4442: fnd_message.set_token('P_RATE1',l_abr_name);
4443: fnd_message.set_token('P_RATE2',g_acty_base_rt_name);
4444: fnd_message.raise_error;
4445: --
4446: end if;
4439: --
4440: close c_dup_rslt;
4441: fnd_message.set_name('BEN','BEN_93450_ELE_MULTIPLE_RSLT');
4442: fnd_message.set_token('P_RATE1',l_abr_name);
4443: fnd_message.set_token('P_RATE2',g_acty_base_rt_name);
4444: fnd_message.raise_error;
4445: --
4446: end if;
4447: close c_dup_rslt;
4440: close c_dup_rslt;
4441: fnd_message.set_name('BEN','BEN_93450_ELE_MULTIPLE_RSLT');
4442: fnd_message.set_token('P_RATE1',l_abr_name);
4443: fnd_message.set_token('P_RATE2',g_acty_base_rt_name);
4444: fnd_message.raise_error;
4445: --
4446: end if;
4447: close c_dup_rslt;
4448:
4500: when others then
4501: ben_on_line_lf_evt.get_ser_message(l_encoded_message,
4502: l_app_short_name,
4503: l_message_name);
4504: l_encoded_message := fnd_message.get;
4505: --
4506: if l_message_name like '%HR_6284_ELE_ENTRY_DT_ASG_DEL%' or
4507: l_message_name like '%HR_7187_DT_CANNOT_EXTEND_END%' then
4508: --
4511: --
4512: null;
4513: else
4514: if l_app_short_name is not null then
4515: fnd_message.set_name(l_app_short_name,l_message_name);
4516: fnd_message.raise_error;
4517: else
4518: raise;
4519: end if;
4512: null;
4513: else
4514: if l_app_short_name is not null then
4515: fnd_message.set_name(l_app_short_name,l_message_name);
4516: fnd_message.raise_error;
4517: else
4518: raise;
4519: end if;
4520: end if;
4600: when others then
4601: if g_debug then
4602: hr_utility.set_location('BEN_92311_FORMULA_VAL_PARAM',30);
4603: end if;
4604: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
4605: fnd_message.set_token('PROC',l_proc);
4606: fnd_message.set_token('FORMULA',l_get_abr_info.prtl_mo_det_mthd_rl);
4607: fnd_message.set_token('PARAMETER',
4608: l_outputs(l_outputs.first).name);
4601: if g_debug then
4602: hr_utility.set_location('BEN_92311_FORMULA_VAL_PARAM',30);
4603: end if;
4604: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
4605: fnd_message.set_token('PROC',l_proc);
4606: fnd_message.set_token('FORMULA',l_get_abr_info.prtl_mo_det_mthd_rl);
4607: fnd_message.set_token('PARAMETER',
4608: l_outputs(l_outputs.first).name);
4609: fnd_message.raise_error;
4602: hr_utility.set_location('BEN_92311_FORMULA_VAL_PARAM',30);
4603: end if;
4604: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
4605: fnd_message.set_token('PROC',l_proc);
4606: fnd_message.set_token('FORMULA',l_get_abr_info.prtl_mo_det_mthd_rl);
4607: fnd_message.set_token('PARAMETER',
4608: l_outputs(l_outputs.first).name);
4609: fnd_message.raise_error;
4610: --
4603: end if;
4604: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
4605: fnd_message.set_token('PROC',l_proc);
4606: fnd_message.set_token('FORMULA',l_get_abr_info.prtl_mo_det_mthd_rl);
4607: fnd_message.set_token('PARAMETER',
4608: l_outputs(l_outputs.first).name);
4609: fnd_message.raise_error;
4610: --
4611: end;
4605: fnd_message.set_token('PROC',l_proc);
4606: fnd_message.set_token('FORMULA',l_get_abr_info.prtl_mo_det_mthd_rl);
4607: fnd_message.set_token('PARAMETER',
4608: l_outputs(l_outputs.first).name);
4609: fnd_message.raise_error;
4610: --
4611: end;
4612: end if;
4613: -- ELE :
4736: --
4737: if l_last_pp_end_dt is null and
4738: ben_epe_cache.g_currepe_row.elig_per_elctbl_chc_id is null then
4739: --
4740: fnd_message.set_name('BEN','BEN_93368_DETERMINE_PAY_PERIOD');
4741: fnd_message.raise_error;
4742: --
4743: end if;
4744: --
4737: if l_last_pp_end_dt is null and
4738: ben_epe_cache.g_currepe_row.elig_per_elctbl_chc_id is null then
4739: --
4740: fnd_message.set_name('BEN','BEN_93368_DETERMINE_PAY_PERIOD');
4741: fnd_message.raise_error;
4742: --
4743: end if;
4744: --
4745: -- Bug 2149438
5125: --
5126: if g_debug then
5127: hr_utility.set_location('BEN_91628_LOOKUP_TYPE_GENERIC',30);
5128: end if;
5129: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
5130: fnd_message.set_token('FIELD','p_one_ann_pymt_cd');
5131: fnd_message.set_token('TYPE','BEN_ONE_ANN_PYMT');
5132: fnd_message.set_token('VALUE',l_get_abr_info.one_ann_pymt_cd);
5133: fnd_message.raise_error;
5126: if g_debug then
5127: hr_utility.set_location('BEN_91628_LOOKUP_TYPE_GENERIC',30);
5128: end if;
5129: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
5130: fnd_message.set_token('FIELD','p_one_ann_pymt_cd');
5131: fnd_message.set_token('TYPE','BEN_ONE_ANN_PYMT');
5132: fnd_message.set_token('VALUE',l_get_abr_info.one_ann_pymt_cd);
5133: fnd_message.raise_error;
5134: end if;
5127: hr_utility.set_location('BEN_91628_LOOKUP_TYPE_GENERIC',30);
5128: end if;
5129: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
5130: fnd_message.set_token('FIELD','p_one_ann_pymt_cd');
5131: fnd_message.set_token('TYPE','BEN_ONE_ANN_PYMT');
5132: fnd_message.set_token('VALUE',l_get_abr_info.one_ann_pymt_cd);
5133: fnd_message.raise_error;
5134: end if;
5135: end if;
5128: end if;
5129: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
5130: fnd_message.set_token('FIELD','p_one_ann_pymt_cd');
5131: fnd_message.set_token('TYPE','BEN_ONE_ANN_PYMT');
5132: fnd_message.set_token('VALUE',l_get_abr_info.one_ann_pymt_cd);
5133: fnd_message.raise_error;
5134: end if;
5135: end if;
5136:
5129: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
5130: fnd_message.set_token('FIELD','p_one_ann_pymt_cd');
5131: fnd_message.set_token('TYPE','BEN_ONE_ANN_PYMT');
5132: fnd_message.set_token('VALUE',l_get_abr_info.one_ann_pymt_cd);
5133: fnd_message.raise_error;
5134: end if;
5135: end if;
5136:
5137: -- ELE :
5271: close c_pps_next_month;
5272: if g_debug then
5273: hr_utility.set_location('BEN_92346_PAYROLL_NOT_DEFINED',30);
5274: end if;
5275: fnd_message.set_name('BEN', 'BEN_92346_PAYROLL_NOT_DEFINED');
5276: fnd_message.set_token('PROC',l_proc);
5277: fnd_message.raise_error;
5278: end if;
5279: hr_elements.check_element_freq(
5272: if g_debug then
5273: hr_utility.set_location('BEN_92346_PAYROLL_NOT_DEFINED',30);
5274: end if;
5275: fnd_message.set_name('BEN', 'BEN_92346_PAYROLL_NOT_DEFINED');
5276: fnd_message.set_token('PROC',l_proc);
5277: fnd_message.raise_error;
5278: end if;
5279: hr_elements.check_element_freq(
5280: p_payroll_id =>l_payroll_id,
5273: hr_utility.set_location('BEN_92346_PAYROLL_NOT_DEFINED',30);
5274: end if;
5275: fnd_message.set_name('BEN', 'BEN_92346_PAYROLL_NOT_DEFINED');
5276: fnd_message.set_token('PROC',l_proc);
5277: fnd_message.raise_error;
5278: end if;
5279: hr_elements.check_element_freq(
5280: p_payroll_id =>l_payroll_id,
5281: p_bg_id =>p_business_group_id,
5305: close c_pps_next_month;
5306: if g_debug then
5307: hr_utility.set_location('BEN_92346_PAYROLL_NOT_DEFINED',32);
5308: end if;
5309: fnd_message.set_name('BEN', 'BEN_92346_PAYROLL_NOT_DEFINED');
5310: fnd_message.set_token('PROC',l_proc);
5311: fnd_message.raise_error;
5312: end if;
5313: hr_elements.check_element_freq(
5306: if g_debug then
5307: hr_utility.set_location('BEN_92346_PAYROLL_NOT_DEFINED',32);
5308: end if;
5309: fnd_message.set_name('BEN', 'BEN_92346_PAYROLL_NOT_DEFINED');
5310: fnd_message.set_token('PROC',l_proc);
5311: fnd_message.raise_error;
5312: end if;
5313: hr_elements.check_element_freq(
5314: p_payroll_id =>l_payroll_id,
5307: hr_utility.set_location('BEN_92346_PAYROLL_NOT_DEFINED',32);
5308: end if;
5309: fnd_message.set_name('BEN', 'BEN_92346_PAYROLL_NOT_DEFINED');
5310: fnd_message.set_token('PROC',l_proc);
5311: fnd_message.raise_error;
5312: end if;
5313: hr_elements.check_element_freq(
5314: p_payroll_id =>l_payroll_id,
5315: p_bg_id =>p_business_group_id,
5352: close c_pps_next_month;
5353: if g_debug then
5354: hr_utility.set_location('BEN_92346_PAYROLL_NOT_DEFINED',34);
5355: end if;
5356: fnd_message.set_name('BEN', 'BEN_92346_PAYROLL_NOT_DEFINED');
5357: fnd_message.set_token('PROC',l_proc);
5358: fnd_message.raise_error;
5359: end if;
5360: hr_elements.check_element_freq(
5353: if g_debug then
5354: hr_utility.set_location('BEN_92346_PAYROLL_NOT_DEFINED',34);
5355: end if;
5356: fnd_message.set_name('BEN', 'BEN_92346_PAYROLL_NOT_DEFINED');
5357: fnd_message.set_token('PROC',l_proc);
5358: fnd_message.raise_error;
5359: end if;
5360: hr_elements.check_element_freq(
5361: p_payroll_id => l_payroll_id,
5354: hr_utility.set_location('BEN_92346_PAYROLL_NOT_DEFINED',34);
5355: end if;
5356: fnd_message.set_name('BEN', 'BEN_92346_PAYROLL_NOT_DEFINED');
5357: fnd_message.set_token('PROC',l_proc);
5358: fnd_message.raise_error;
5359: end if;
5360: hr_elements.check_element_freq(
5361: p_payroll_id => l_payroll_id,
5362: p_bg_id => p_business_group_id,
5534: close get_current_value;
5535: if g_debug then
5536: hr_utility.set_location('BEN_92101_NO_RATE ',90);
5537: end if;
5538: fnd_message.set_name('BEN', 'BEN_92101_NO_RATE');
5539: fnd_message.set_token('PROC',l_proc);
5540: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_element_entry_id));
5541: fnd_message.set_token('INPUT_VALUE_ID',to_char(l_input_value_id));
5542: fnd_message.set_token('EFFECTIVE_DATE',to_char(l_zero_pp_date));
5535: if g_debug then
5536: hr_utility.set_location('BEN_92101_NO_RATE ',90);
5537: end if;
5538: fnd_message.set_name('BEN', 'BEN_92101_NO_RATE');
5539: fnd_message.set_token('PROC',l_proc);
5540: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_element_entry_id));
5541: fnd_message.set_token('INPUT_VALUE_ID',to_char(l_input_value_id));
5542: fnd_message.set_token('EFFECTIVE_DATE',to_char(l_zero_pp_date));
5543: fnd_message.set_token('ABR_NAME',l_get_abr_info.name); -- Bug 2519349
5536: hr_utility.set_location('BEN_92101_NO_RATE ',90);
5537: end if;
5538: fnd_message.set_name('BEN', 'BEN_92101_NO_RATE');
5539: fnd_message.set_token('PROC',l_proc);
5540: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_element_entry_id));
5541: fnd_message.set_token('INPUT_VALUE_ID',to_char(l_input_value_id));
5542: fnd_message.set_token('EFFECTIVE_DATE',to_char(l_zero_pp_date));
5543: fnd_message.set_token('ABR_NAME',l_get_abr_info.name); -- Bug 2519349
5544: fnd_message.raise_error;
5537: end if;
5538: fnd_message.set_name('BEN', 'BEN_92101_NO_RATE');
5539: fnd_message.set_token('PROC',l_proc);
5540: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_element_entry_id));
5541: fnd_message.set_token('INPUT_VALUE_ID',to_char(l_input_value_id));
5542: fnd_message.set_token('EFFECTIVE_DATE',to_char(l_zero_pp_date));
5543: fnd_message.set_token('ABR_NAME',l_get_abr_info.name); -- Bug 2519349
5544: fnd_message.raise_error;
5545: end if;
5538: fnd_message.set_name('BEN', 'BEN_92101_NO_RATE');
5539: fnd_message.set_token('PROC',l_proc);
5540: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_element_entry_id));
5541: fnd_message.set_token('INPUT_VALUE_ID',to_char(l_input_value_id));
5542: fnd_message.set_token('EFFECTIVE_DATE',to_char(l_zero_pp_date));
5543: fnd_message.set_token('ABR_NAME',l_get_abr_info.name); -- Bug 2519349
5544: fnd_message.raise_error;
5545: end if;
5546: close get_current_value;
5539: fnd_message.set_token('PROC',l_proc);
5540: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_element_entry_id));
5541: fnd_message.set_token('INPUT_VALUE_ID',to_char(l_input_value_id));
5542: fnd_message.set_token('EFFECTIVE_DATE',to_char(l_zero_pp_date));
5543: fnd_message.set_token('ABR_NAME',l_get_abr_info.name); -- Bug 2519349
5544: fnd_message.raise_error;
5545: end if;
5546: close get_current_value;
5547:
5540: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_element_entry_id));
5541: fnd_message.set_token('INPUT_VALUE_ID',to_char(l_input_value_id));
5542: fnd_message.set_token('EFFECTIVE_DATE',to_char(l_zero_pp_date));
5543: fnd_message.set_token('ABR_NAME',l_get_abr_info.name); -- Bug 2519349
5544: fnd_message.raise_error;
5545: end if;
5546: close get_current_value;
5547:
5548: --
5850: close get_current_value;
5851: if g_debug then
5852: hr_utility.set_location('BEN_92101_NO_RATE ',92);
5853: end if;
5854: fnd_message.set_name('BEN', 'BEN_92101_NO_RATE');
5855: fnd_message.set_token('PROC',l_proc);
5856: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_element_entry_id));
5857: fnd_message.set_token('INPUT_VALUE_ID',to_char(l_input_value_id));
5858: fnd_message.set_token('EFFECTIVE_DATE',to_char(l_special_pp_date));
5851: if g_debug then
5852: hr_utility.set_location('BEN_92101_NO_RATE ',92);
5853: end if;
5854: fnd_message.set_name('BEN', 'BEN_92101_NO_RATE');
5855: fnd_message.set_token('PROC',l_proc);
5856: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_element_entry_id));
5857: fnd_message.set_token('INPUT_VALUE_ID',to_char(l_input_value_id));
5858: fnd_message.set_token('EFFECTIVE_DATE',to_char(l_special_pp_date));
5859: fnd_message.set_token('ABR_NAME',l_get_abr_info.name); -- Bug 2519349
5852: hr_utility.set_location('BEN_92101_NO_RATE ',92);
5853: end if;
5854: fnd_message.set_name('BEN', 'BEN_92101_NO_RATE');
5855: fnd_message.set_token('PROC',l_proc);
5856: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_element_entry_id));
5857: fnd_message.set_token('INPUT_VALUE_ID',to_char(l_input_value_id));
5858: fnd_message.set_token('EFFECTIVE_DATE',to_char(l_special_pp_date));
5859: fnd_message.set_token('ABR_NAME',l_get_abr_info.name); -- Bug 2519349
5860: fnd_message.raise_error;
5853: end if;
5854: fnd_message.set_name('BEN', 'BEN_92101_NO_RATE');
5855: fnd_message.set_token('PROC',l_proc);
5856: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_element_entry_id));
5857: fnd_message.set_token('INPUT_VALUE_ID',to_char(l_input_value_id));
5858: fnd_message.set_token('EFFECTIVE_DATE',to_char(l_special_pp_date));
5859: fnd_message.set_token('ABR_NAME',l_get_abr_info.name); -- Bug 2519349
5860: fnd_message.raise_error;
5861: end if;
5854: fnd_message.set_name('BEN', 'BEN_92101_NO_RATE');
5855: fnd_message.set_token('PROC',l_proc);
5856: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_element_entry_id));
5857: fnd_message.set_token('INPUT_VALUE_ID',to_char(l_input_value_id));
5858: fnd_message.set_token('EFFECTIVE_DATE',to_char(l_special_pp_date));
5859: fnd_message.set_token('ABR_NAME',l_get_abr_info.name); -- Bug 2519349
5860: fnd_message.raise_error;
5861: end if;
5862: close get_current_value;
5855: fnd_message.set_token('PROC',l_proc);
5856: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_element_entry_id));
5857: fnd_message.set_token('INPUT_VALUE_ID',to_char(l_input_value_id));
5858: fnd_message.set_token('EFFECTIVE_DATE',to_char(l_special_pp_date));
5859: fnd_message.set_token('ABR_NAME',l_get_abr_info.name); -- Bug 2519349
5860: fnd_message.raise_error;
5861: end if;
5862: close get_current_value;
5863:
5856: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_element_entry_id));
5857: fnd_message.set_token('INPUT_VALUE_ID',to_char(l_input_value_id));
5858: fnd_message.set_token('EFFECTIVE_DATE',to_char(l_special_pp_date));
5859: fnd_message.set_token('ABR_NAME',l_get_abr_info.name); -- Bug 2519349
5860: fnd_message.raise_error;
5861: end if;
5862: close get_current_value;
5863:
5864: if l_uom is null then
6237: close get_current_value;
6238: if g_debug then
6239: hr_utility.set_location('BEN_92101_NO_RATE ',94);
6240: end if;
6241: fnd_message.set_name('BEN', 'BEN_92101_NO_RATE');
6242: fnd_message.set_token('PROC',l_proc);
6243: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_element_entry_id));
6244: fnd_message.set_token('INPUT_VALUE_ID',to_char(l_input_value_id));
6245: fnd_message.set_token('EFFECTIVE_DATE',to_char(l_normal_pp_date));
6238: if g_debug then
6239: hr_utility.set_location('BEN_92101_NO_RATE ',94);
6240: end if;
6241: fnd_message.set_name('BEN', 'BEN_92101_NO_RATE');
6242: fnd_message.set_token('PROC',l_proc);
6243: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_element_entry_id));
6244: fnd_message.set_token('INPUT_VALUE_ID',to_char(l_input_value_id));
6245: fnd_message.set_token('EFFECTIVE_DATE',to_char(l_normal_pp_date));
6246: fnd_message.set_token('ABR_NAME',l_get_abr_info.name); -- Bug 2519349
6239: hr_utility.set_location('BEN_92101_NO_RATE ',94);
6240: end if;
6241: fnd_message.set_name('BEN', 'BEN_92101_NO_RATE');
6242: fnd_message.set_token('PROC',l_proc);
6243: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_element_entry_id));
6244: fnd_message.set_token('INPUT_VALUE_ID',to_char(l_input_value_id));
6245: fnd_message.set_token('EFFECTIVE_DATE',to_char(l_normal_pp_date));
6246: fnd_message.set_token('ABR_NAME',l_get_abr_info.name); -- Bug 2519349
6247: fnd_message.raise_error;
6240: end if;
6241: fnd_message.set_name('BEN', 'BEN_92101_NO_RATE');
6242: fnd_message.set_token('PROC',l_proc);
6243: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_element_entry_id));
6244: fnd_message.set_token('INPUT_VALUE_ID',to_char(l_input_value_id));
6245: fnd_message.set_token('EFFECTIVE_DATE',to_char(l_normal_pp_date));
6246: fnd_message.set_token('ABR_NAME',l_get_abr_info.name); -- Bug 2519349
6247: fnd_message.raise_error;
6248: end if;
6241: fnd_message.set_name('BEN', 'BEN_92101_NO_RATE');
6242: fnd_message.set_token('PROC',l_proc);
6243: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_element_entry_id));
6244: fnd_message.set_token('INPUT_VALUE_ID',to_char(l_input_value_id));
6245: fnd_message.set_token('EFFECTIVE_DATE',to_char(l_normal_pp_date));
6246: fnd_message.set_token('ABR_NAME',l_get_abr_info.name); -- Bug 2519349
6247: fnd_message.raise_error;
6248: end if;
6249: close get_current_value;
6242: fnd_message.set_token('PROC',l_proc);
6243: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_element_entry_id));
6244: fnd_message.set_token('INPUT_VALUE_ID',to_char(l_input_value_id));
6245: fnd_message.set_token('EFFECTIVE_DATE',to_char(l_normal_pp_date));
6246: fnd_message.set_token('ABR_NAME',l_get_abr_info.name); -- Bug 2519349
6247: fnd_message.raise_error;
6248: end if;
6249: close get_current_value;
6250: --
6243: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_element_entry_id));
6244: fnd_message.set_token('INPUT_VALUE_ID',to_char(l_input_value_id));
6245: fnd_message.set_token('EFFECTIVE_DATE',to_char(l_normal_pp_date));
6246: fnd_message.set_token('ABR_NAME',l_get_abr_info.name); -- Bug 2519349
6247: fnd_message.raise_error;
6248: end if;
6249: close get_current_value;
6250: --
6251: if l_uom is null then
6953: p_person_id => p_person_id);
6954: --
6955: if fnd_global.conc_request_id not in ( 0,-1) then
6956: --
6957: fnd_message.set_name('BEN',l_message_name);
6958: fnd_message.set_token('PARMA',l_element_name);
6959: fnd_message.set_token('PARMB',to_char(l_effective_end_date));
6960: l_string := fnd_message.get;
6961: benutils.write(p_text => l_string);
6954: --
6955: if fnd_global.conc_request_id not in ( 0,-1) then
6956: --
6957: fnd_message.set_name('BEN',l_message_name);
6958: fnd_message.set_token('PARMA',l_element_name);
6959: fnd_message.set_token('PARMB',to_char(l_effective_end_date));
6960: l_string := fnd_message.get;
6961: benutils.write(p_text => l_string);
6962: --
6955: if fnd_global.conc_request_id not in ( 0,-1) then
6956: --
6957: fnd_message.set_name('BEN',l_message_name);
6958: fnd_message.set_token('PARMA',l_element_name);
6959: fnd_message.set_token('PARMB',to_char(l_effective_end_date));
6960: l_string := fnd_message.get;
6961: benutils.write(p_text => l_string);
6962: --
6963: end if;
6956: --
6957: fnd_message.set_name('BEN',l_message_name);
6958: fnd_message.set_token('PARMA',l_element_name);
6959: fnd_message.set_token('PARMB',to_char(l_effective_end_date));
6960: l_string := fnd_message.get;
6961: benutils.write(p_text => l_string);
6962: --
6963: end if;
6964: --
6999: --
7000: if g_debug then
7001: hr_utility.set_location('BEN_92102_NO_ENTRY_CREATED',140);
7002: end if;
7003: fnd_message.set_name('BEN', 'BEN_92102_NO_ENTRY_CREATED');
7004: fnd_message.set_token('PROC',l_proc);
7005: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_old_element_link_id));
7006: fnd_message.set_token('INPUT_VALUE_ID',to_char(l_input_value_id));
7007: fnd_message.set_token('EFFECTIVE_DATE',to_char(l_rt_strt_dt));
7000: if g_debug then
7001: hr_utility.set_location('BEN_92102_NO_ENTRY_CREATED',140);
7002: end if;
7003: fnd_message.set_name('BEN', 'BEN_92102_NO_ENTRY_CREATED');
7004: fnd_message.set_token('PROC',l_proc);
7005: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_old_element_link_id));
7006: fnd_message.set_token('INPUT_VALUE_ID',to_char(l_input_value_id));
7007: fnd_message.set_token('EFFECTIVE_DATE',to_char(l_rt_strt_dt));
7008: fnd_message.raise_error;
7001: hr_utility.set_location('BEN_92102_NO_ENTRY_CREATED',140);
7002: end if;
7003: fnd_message.set_name('BEN', 'BEN_92102_NO_ENTRY_CREATED');
7004: fnd_message.set_token('PROC',l_proc);
7005: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_old_element_link_id));
7006: fnd_message.set_token('INPUT_VALUE_ID',to_char(l_input_value_id));
7007: fnd_message.set_token('EFFECTIVE_DATE',to_char(l_rt_strt_dt));
7008: fnd_message.raise_error;
7009: --
7002: end if;
7003: fnd_message.set_name('BEN', 'BEN_92102_NO_ENTRY_CREATED');
7004: fnd_message.set_token('PROC',l_proc);
7005: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_old_element_link_id));
7006: fnd_message.set_token('INPUT_VALUE_ID',to_char(l_input_value_id));
7007: fnd_message.set_token('EFFECTIVE_DATE',to_char(l_rt_strt_dt));
7008: fnd_message.raise_error;
7009: --
7010: end if;
7003: fnd_message.set_name('BEN', 'BEN_92102_NO_ENTRY_CREATED');
7004: fnd_message.set_token('PROC',l_proc);
7005: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_old_element_link_id));
7006: fnd_message.set_token('INPUT_VALUE_ID',to_char(l_input_value_id));
7007: fnd_message.set_token('EFFECTIVE_DATE',to_char(l_rt_strt_dt));
7008: fnd_message.raise_error;
7009: --
7010: end if;
7011: close get_element_entry;
7004: fnd_message.set_token('PROC',l_proc);
7005: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_old_element_link_id));
7006: fnd_message.set_token('INPUT_VALUE_ID',to_char(l_input_value_id));
7007: fnd_message.set_token('EFFECTIVE_DATE',to_char(l_rt_strt_dt));
7008: fnd_message.raise_error;
7009: --
7010: end if;
7011: close get_element_entry;
7012: --
7107: p_person_id => p_person_id);
7108:
7109: if fnd_global.conc_request_id in ( 0,-1) then
7110: --
7111: fnd_message.set_name('BEN','BEN_92455_STRT_RUN_RESULTS');
7112: fnd_message.set_token('PARMA', fnd_date.date_to_chardate(g_max_end_date,calendar_aware=>2));
7113: l_string := fnd_message.get;
7114: benutils.write(p_text => l_string);
7115: --
7108:
7109: if fnd_global.conc_request_id in ( 0,-1) then
7110: --
7111: fnd_message.set_name('BEN','BEN_92455_STRT_RUN_RESULTS');
7112: fnd_message.set_token('PARMA', fnd_date.date_to_chardate(g_max_end_date,calendar_aware=>2));
7113: l_string := fnd_message.get;
7114: benutils.write(p_text => l_string);
7115: --
7116: end if;
7109: if fnd_global.conc_request_id in ( 0,-1) then
7110: --
7111: fnd_message.set_name('BEN','BEN_92455_STRT_RUN_RESULTS');
7112: fnd_message.set_token('PARMA', fnd_date.date_to_chardate(g_max_end_date,calendar_aware=>2));
7113: l_string := fnd_message.get;
7114: benutils.write(p_text => l_string);
7115: --
7116: end if;
7117: g_msg_displayed := 1;
7439: hr_utility.set_location('BEN_92103_NO_PRTT_RT_VAL',170);
7440: end if;
7441: close c_get_prtt_rt_val;
7442: --
7443: fnd_message.set_name('BEN', 'BEN_92103_NO_PRTT_RT_VAL');
7444: fnd_message.set_token('PROC',l_proc);
7445: fnd_message.set_token('PRTT_RT_VAL',to_char(p_prtt_rt_val_id));
7446: fnd_message.raise_error;
7447: --
7440: end if;
7441: close c_get_prtt_rt_val;
7442: --
7443: fnd_message.set_name('BEN', 'BEN_92103_NO_PRTT_RT_VAL');
7444: fnd_message.set_token('PROC',l_proc);
7445: fnd_message.set_token('PRTT_RT_VAL',to_char(p_prtt_rt_val_id));
7446: fnd_message.raise_error;
7447: --
7448: end if;
7441: close c_get_prtt_rt_val;
7442: --
7443: fnd_message.set_name('BEN', 'BEN_92103_NO_PRTT_RT_VAL');
7444: fnd_message.set_token('PROC',l_proc);
7445: fnd_message.set_token('PRTT_RT_VAL',to_char(p_prtt_rt_val_id));
7446: fnd_message.raise_error;
7447: --
7448: end if;
7449: close c_get_prtt_rt_val;
7442: --
7443: fnd_message.set_name('BEN', 'BEN_92103_NO_PRTT_RT_VAL');
7444: fnd_message.set_token('PROC',l_proc);
7445: fnd_message.set_token('PRTT_RT_VAL',to_char(p_prtt_rt_val_id));
7446: fnd_message.raise_error;
7447: --
7448: end if;
7449: close c_get_prtt_rt_val;
7450: --
7466: close get_abr_info;
7467: if g_debug then
7468: hr_utility.set_location('BEN_91723_NO_ENRT_RT_ABR_FOUND',30);
7469: end if;
7470: fnd_message.set_name('BEN','BEN_91723_NO_ENRT_RT_ABR_FOUND');
7471: fnd_message.set_token('PROC',l_proc);
7472: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
7473: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
7474: fnd_message.raise_error;
7467: if g_debug then
7468: hr_utility.set_location('BEN_91723_NO_ENRT_RT_ABR_FOUND',30);
7469: end if;
7470: fnd_message.set_name('BEN','BEN_91723_NO_ENRT_RT_ABR_FOUND');
7471: fnd_message.set_token('PROC',l_proc);
7472: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
7473: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
7474: fnd_message.raise_error;
7475: end if;
7468: hr_utility.set_location('BEN_91723_NO_ENRT_RT_ABR_FOUND',30);
7469: end if;
7470: fnd_message.set_name('BEN','BEN_91723_NO_ENRT_RT_ABR_FOUND');
7471: fnd_message.set_token('PROC',l_proc);
7472: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
7473: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
7474: fnd_message.raise_error;
7475: end if;
7476: close get_abr_info;
7469: end if;
7470: fnd_message.set_name('BEN','BEN_91723_NO_ENRT_RT_ABR_FOUND');
7471: fnd_message.set_token('PROC',l_proc);
7472: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
7473: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
7474: fnd_message.raise_error;
7475: end if;
7476: close get_abr_info;
7477: --
7470: fnd_message.set_name('BEN','BEN_91723_NO_ENRT_RT_ABR_FOUND');
7471: fnd_message.set_token('PROC',l_proc);
7472: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
7473: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
7474: fnd_message.raise_error;
7475: end if;
7476: close get_abr_info;
7477: --
7478: -- get the element type and input value based on entry value attached to
7647: if g_debug then
7648: hr_utility.set_location('BEN_92105_NO_PRIOR_ENROLLMENT',40);
7649: end if;
7650: close get_last_element_entry;
7651: fnd_message.set_name('BEN', 'BEN_92105_NO_PRIOR_ENROLLMENT');
7652: fnd_message.set_token('PROC',l_proc);
7653: fnd_message.set_token('ELEMENT_TYPE_ID',to_char(l_element_type_id));
7654: fnd_message.set_token('ASSGN_ID',to_char(l_assignment_id));
7655: fnd_message.set_token('PRTT_RT_VAL_ID',to_char(p_prtt_rt_val_id));
7648: hr_utility.set_location('BEN_92105_NO_PRIOR_ENROLLMENT',40);
7649: end if;
7650: close get_last_element_entry;
7651: fnd_message.set_name('BEN', 'BEN_92105_NO_PRIOR_ENROLLMENT');
7652: fnd_message.set_token('PROC',l_proc);
7653: fnd_message.set_token('ELEMENT_TYPE_ID',to_char(l_element_type_id));
7654: fnd_message.set_token('ASSGN_ID',to_char(l_assignment_id));
7655: fnd_message.set_token('PRTT_RT_VAL_ID',to_char(p_prtt_rt_val_id));
7656: fnd_message.raise_error;
7649: end if;
7650: close get_last_element_entry;
7651: fnd_message.set_name('BEN', 'BEN_92105_NO_PRIOR_ENROLLMENT');
7652: fnd_message.set_token('PROC',l_proc);
7653: fnd_message.set_token('ELEMENT_TYPE_ID',to_char(l_element_type_id));
7654: fnd_message.set_token('ASSGN_ID',to_char(l_assignment_id));
7655: fnd_message.set_token('PRTT_RT_VAL_ID',to_char(p_prtt_rt_val_id));
7656: fnd_message.raise_error;
7657: --
7650: close get_last_element_entry;
7651: fnd_message.set_name('BEN', 'BEN_92105_NO_PRIOR_ENROLLMENT');
7652: fnd_message.set_token('PROC',l_proc);
7653: fnd_message.set_token('ELEMENT_TYPE_ID',to_char(l_element_type_id));
7654: fnd_message.set_token('ASSGN_ID',to_char(l_assignment_id));
7655: fnd_message.set_token('PRTT_RT_VAL_ID',to_char(p_prtt_rt_val_id));
7656: fnd_message.raise_error;
7657: --
7658: end if;
7651: fnd_message.set_name('BEN', 'BEN_92105_NO_PRIOR_ENROLLMENT');
7652: fnd_message.set_token('PROC',l_proc);
7653: fnd_message.set_token('ELEMENT_TYPE_ID',to_char(l_element_type_id));
7654: fnd_message.set_token('ASSGN_ID',to_char(l_assignment_id));
7655: fnd_message.set_token('PRTT_RT_VAL_ID',to_char(p_prtt_rt_val_id));
7656: fnd_message.raise_error;
7657: --
7658: end if;
7659: close get_last_element_entry;
7652: fnd_message.set_token('PROC',l_proc);
7653: fnd_message.set_token('ELEMENT_TYPE_ID',to_char(l_element_type_id));
7654: fnd_message.set_token('ASSGN_ID',to_char(l_assignment_id));
7655: fnd_message.set_token('PRTT_RT_VAL_ID',to_char(p_prtt_rt_val_id));
7656: fnd_message.raise_error;
7657: --
7658: end if;
7659: close get_last_element_entry;
7660:
7825: when others then
7826: ben_on_line_lf_evt.get_ser_message(l_encoded_message,
7827: l_app_short_name,
7828: l_message_name);
7829: l_encoded_message := fnd_message.get;
7830: --
7831: if l_message_name like '%HR_6284_ELE_ENTRY_DT_ASG_DEL%' or
7832: l_message_name like '%HR_7187_DT_CANNOT_EXTEND_END%' then
7833: --
7835: --
7836: null;
7837: else
7838: if l_app_short_name is not null then
7839: fnd_message.set_name(l_app_short_name,l_message_name);
7840: fnd_message.raise_error;
7841: else
7842: raise;
7843: end if;
7836: null;
7837: else
7838: if l_app_short_name is not null then
7839: fnd_message.set_name(l_app_short_name,l_message_name);
7840: fnd_message.raise_error;
7841: else
7842: raise;
7843: end if;
7844: end if;
7994: p_person_id => p_person_id);
7995: --
7996: if fnd_global.conc_request_id in ( 0,-1) then
7997: --
7998: fnd_message.set_name('BEN',l_message_name);
7999: fnd_message.set_token('PARMA',l_element_name);
8000: fnd_message.set_token('PARMB',to_char(l_effective_date));
8001: l_string := fnd_message.get;
8002: benutils.write(p_text => l_string);
7995: --
7996: if fnd_global.conc_request_id in ( 0,-1) then
7997: --
7998: fnd_message.set_name('BEN',l_message_name);
7999: fnd_message.set_token('PARMA',l_element_name);
8000: fnd_message.set_token('PARMB',to_char(l_effective_date));
8001: l_string := fnd_message.get;
8002: benutils.write(p_text => l_string);
8003: --
7996: if fnd_global.conc_request_id in ( 0,-1) then
7997: --
7998: fnd_message.set_name('BEN',l_message_name);
7999: fnd_message.set_token('PARMA',l_element_name);
8000: fnd_message.set_token('PARMB',to_char(l_effective_date));
8001: l_string := fnd_message.get;
8002: benutils.write(p_text => l_string);
8003: --
8004: end if;
7997: --
7998: fnd_message.set_name('BEN',l_message_name);
7999: fnd_message.set_token('PARMA',l_element_name);
8000: fnd_message.set_token('PARMB',to_char(l_effective_date));
8001: l_string := fnd_message.get;
8002: benutils.write(p_text => l_string);
8003: --
8004: end if;
8005:
8270:
8271: if g_debug then
8272: hr_utility.set_location('BEN_92106_PRTT_NO_ASGN',5);
8273: end if;
8274: fnd_message.set_name('BEN', 'BEN_92106_PRTT_NO_ASGN');
8275: fnd_message.set_token('PROC',l_proc);
8276: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
8277: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
8278: fnd_message.raise_error;
8271: if g_debug then
8272: hr_utility.set_location('BEN_92106_PRTT_NO_ASGN',5);
8273: end if;
8274: fnd_message.set_name('BEN', 'BEN_92106_PRTT_NO_ASGN');
8275: fnd_message.set_token('PROC',l_proc);
8276: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
8277: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
8278: fnd_message.raise_error;
8279:
8272: hr_utility.set_location('BEN_92106_PRTT_NO_ASGN',5);
8273: end if;
8274: fnd_message.set_name('BEN', 'BEN_92106_PRTT_NO_ASGN');
8275: fnd_message.set_token('PROC',l_proc);
8276: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
8277: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
8278: fnd_message.raise_error;
8279:
8280: end if;
8273: end if;
8274: fnd_message.set_name('BEN', 'BEN_92106_PRTT_NO_ASGN');
8275: fnd_message.set_token('PROC',l_proc);
8276: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
8277: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
8278: fnd_message.raise_error;
8279:
8280: end if;
8281: if g_debug then
8274: fnd_message.set_name('BEN', 'BEN_92106_PRTT_NO_ASGN');
8275: fnd_message.set_token('PROC',l_proc);
8276: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
8277: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
8278: fnd_message.raise_error;
8279:
8280: end if;
8281: if g_debug then
8282: hr_utility.set_location('l_assignment_id='||l_assignment_id,6);
8304: close get_abr_info;
8305: if g_debug then
8306: hr_utility.set_location('BEN_91723_NO_ENRT_RT_ABR_FOUND',40);
8307: end if;
8308: fnd_message.set_name('BEN','BEN_91723_NO_ENRT_RT_ABR_FOUND');
8309: fnd_message.set_token('PROC',l_proc);
8310: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
8311: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
8312: fnd_message.raise_error;
8305: if g_debug then
8306: hr_utility.set_location('BEN_91723_NO_ENRT_RT_ABR_FOUND',40);
8307: end if;
8308: fnd_message.set_name('BEN','BEN_91723_NO_ENRT_RT_ABR_FOUND');
8309: fnd_message.set_token('PROC',l_proc);
8310: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
8311: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
8312: fnd_message.raise_error;
8313: end if;
8306: hr_utility.set_location('BEN_91723_NO_ENRT_RT_ABR_FOUND',40);
8307: end if;
8308: fnd_message.set_name('BEN','BEN_91723_NO_ENRT_RT_ABR_FOUND');
8309: fnd_message.set_token('PROC',l_proc);
8310: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
8311: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
8312: fnd_message.raise_error;
8313: end if;
8314: close get_abr_info;
8307: end if;
8308: fnd_message.set_name('BEN','BEN_91723_NO_ENRT_RT_ABR_FOUND');
8309: fnd_message.set_token('PROC',l_proc);
8310: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
8311: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
8312: fnd_message.raise_error;
8313: end if;
8314: close get_abr_info;
8315: l_rt_end_dt := p_rt_end_date;
8308: fnd_message.set_name('BEN','BEN_91723_NO_ENRT_RT_ABR_FOUND');
8309: fnd_message.set_token('PROC',l_proc);
8310: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
8311: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
8312: fnd_message.raise_error;
8313: end if;
8314: close get_abr_info;
8315: l_rt_end_dt := p_rt_end_date;
8316:
8455: --
8456: if g_debug then
8457: hr_utility.set_location('BEN_92102_NO_ENTRY_CREATED',140);
8458: end if;
8459: fnd_message.set_name('BEN', 'BEN_92102_NO_ENTRY_CREATED');
8460: fnd_message.set_token('PROC',l_proc);
8461: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_element_entry_id));
8462: fnd_message.set_token('INPUT_VALUE_ID',to_char(p_input_value_id));
8463: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_rt_strt_date));
8456: if g_debug then
8457: hr_utility.set_location('BEN_92102_NO_ENTRY_CREATED',140);
8458: end if;
8459: fnd_message.set_name('BEN', 'BEN_92102_NO_ENTRY_CREATED');
8460: fnd_message.set_token('PROC',l_proc);
8461: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_element_entry_id));
8462: fnd_message.set_token('INPUT_VALUE_ID',to_char(p_input_value_id));
8463: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_rt_strt_date));
8464: fnd_message.raise_error;
8457: hr_utility.set_location('BEN_92102_NO_ENTRY_CREATED',140);
8458: end if;
8459: fnd_message.set_name('BEN', 'BEN_92102_NO_ENTRY_CREATED');
8460: fnd_message.set_token('PROC',l_proc);
8461: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_element_entry_id));
8462: fnd_message.set_token('INPUT_VALUE_ID',to_char(p_input_value_id));
8463: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_rt_strt_date));
8464: fnd_message.raise_error;
8465: --
8458: end if;
8459: fnd_message.set_name('BEN', 'BEN_92102_NO_ENTRY_CREATED');
8460: fnd_message.set_token('PROC',l_proc);
8461: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_element_entry_id));
8462: fnd_message.set_token('INPUT_VALUE_ID',to_char(p_input_value_id));
8463: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_rt_strt_date));
8464: fnd_message.raise_error;
8465: --
8466: end if;
8459: fnd_message.set_name('BEN', 'BEN_92102_NO_ENTRY_CREATED');
8460: fnd_message.set_token('PROC',l_proc);
8461: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_element_entry_id));
8462: fnd_message.set_token('INPUT_VALUE_ID',to_char(p_input_value_id));
8463: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_rt_strt_date));
8464: fnd_message.raise_error;
8465: --
8466: end if;
8467: close get_created_entry_value;
8460: fnd_message.set_token('PROC',l_proc);
8461: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_element_entry_id));
8462: fnd_message.set_token('INPUT_VALUE_ID',to_char(p_input_value_id));
8463: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_rt_strt_date));
8464: fnd_message.raise_error;
8465: --
8466: end if;
8467: close get_created_entry_value;
8468: if g_debug then
8480: hr_utility.set_location('BEN_92103_NO_PRTT_RT_VAL',170);
8481: end if;
8482: close c_get_prtt_rt_val;
8483: --
8484: fnd_message.set_name('BEN', 'BEN_92103_NO_PRTT_RT_VAL');
8485: fnd_message.set_token('PROC',l_proc);
8486: fnd_message.set_token('PRTT_RT_VAL',to_char(p_prtt_rt_val_id));
8487: fnd_message.raise_error;
8488: --
8481: end if;
8482: close c_get_prtt_rt_val;
8483: --
8484: fnd_message.set_name('BEN', 'BEN_92103_NO_PRTT_RT_VAL');
8485: fnd_message.set_token('PROC',l_proc);
8486: fnd_message.set_token('PRTT_RT_VAL',to_char(p_prtt_rt_val_id));
8487: fnd_message.raise_error;
8488: --
8489: end if;
8482: close c_get_prtt_rt_val;
8483: --
8484: fnd_message.set_name('BEN', 'BEN_92103_NO_PRTT_RT_VAL');
8485: fnd_message.set_token('PROC',l_proc);
8486: fnd_message.set_token('PRTT_RT_VAL',to_char(p_prtt_rt_val_id));
8487: fnd_message.raise_error;
8488: --
8489: end if;
8490: close c_get_prtt_rt_val;
8483: --
8484: fnd_message.set_name('BEN', 'BEN_92103_NO_PRTT_RT_VAL');
8485: fnd_message.set_token('PROC',l_proc);
8486: fnd_message.set_token('PRTT_RT_VAL',to_char(p_prtt_rt_val_id));
8487: fnd_message.raise_error;
8488: --
8489: end if;
8490: close c_get_prtt_rt_val;
8491: --
9049: hr_utility.set_location('BEN_92103_NO_PRTT_RT_VAL',170);
9050: end if;
9051: close c_get_prtt_rt_val;
9052: --
9053: fnd_message.set_name('BEN', 'BEN_92103_NO_PRTT_RT_VAL');
9054: fnd_message.set_token('PROC',l_proc);
9055: fnd_message.set_token('PRTT_RT_VAL',to_char(p_prtt_rt_val_id));
9056: fnd_message.raise_error;
9057: --
9050: end if;
9051: close c_get_prtt_rt_val;
9052: --
9053: fnd_message.set_name('BEN', 'BEN_92103_NO_PRTT_RT_VAL');
9054: fnd_message.set_token('PROC',l_proc);
9055: fnd_message.set_token('PRTT_RT_VAL',to_char(p_prtt_rt_val_id));
9056: fnd_message.raise_error;
9057: --
9058: end if;
9051: close c_get_prtt_rt_val;
9052: --
9053: fnd_message.set_name('BEN', 'BEN_92103_NO_PRTT_RT_VAL');
9054: fnd_message.set_token('PROC',l_proc);
9055: fnd_message.set_token('PRTT_RT_VAL',to_char(p_prtt_rt_val_id));
9056: fnd_message.raise_error;
9057: --
9058: end if;
9059: close c_get_prtt_rt_val;
9052: --
9053: fnd_message.set_name('BEN', 'BEN_92103_NO_PRTT_RT_VAL');
9054: fnd_message.set_token('PROC',l_proc);
9055: fnd_message.set_token('PRTT_RT_VAL',to_char(p_prtt_rt_val_id));
9056: fnd_message.raise_error;
9057: --
9058: end if;
9059: close c_get_prtt_rt_val;
9060: --
9121: close get_abr_info;
9122: if g_debug then
9123: hr_utility.set_location('BEN_91723_NO_ENRT_RT_ABR_FOUND',40);
9124: end if;
9125: fnd_message.set_name('BEN','BEN_91723_NO_ENRT_RT_ABR_FOUND');
9126: fnd_message.set_token('PROC',l_proc);
9127: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
9128: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
9129: fnd_message.raise_error;
9122: if g_debug then
9123: hr_utility.set_location('BEN_91723_NO_ENRT_RT_ABR_FOUND',40);
9124: end if;
9125: fnd_message.set_name('BEN','BEN_91723_NO_ENRT_RT_ABR_FOUND');
9126: fnd_message.set_token('PROC',l_proc);
9127: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
9128: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
9129: fnd_message.raise_error;
9130: end if;
9123: hr_utility.set_location('BEN_91723_NO_ENRT_RT_ABR_FOUND',40);
9124: end if;
9125: fnd_message.set_name('BEN','BEN_91723_NO_ENRT_RT_ABR_FOUND');
9126: fnd_message.set_token('PROC',l_proc);
9127: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
9128: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
9129: fnd_message.raise_error;
9130: end if;
9131: close get_abr_info;
9124: end if;
9125: fnd_message.set_name('BEN','BEN_91723_NO_ENRT_RT_ABR_FOUND');
9126: fnd_message.set_token('PROC',l_proc);
9127: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
9128: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
9129: fnd_message.raise_error;
9130: end if;
9131: close get_abr_info;
9132:
9125: fnd_message.set_name('BEN','BEN_91723_NO_ENRT_RT_ABR_FOUND');
9126: fnd_message.set_token('PROC',l_proc);
9127: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
9128: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
9129: fnd_message.raise_error;
9130: end if;
9131: close get_abr_info;
9132:
9133: hr_utility.set_location('l_abr_rcrrg_cd '||l_abr_rcrrg_cd,40);
9176: p_person_id => p_person_id);
9177: --
9178: if fnd_global.conc_request_id in ( 0,-1) then
9179: --
9180: fnd_message.set_name('BEN','BEN_93455_ELE_ALREADY_ENDED');
9181: fnd_message.set_token('PARMA',l_element_name);
9182: fnd_message.set_token('PARMB',to_char(l_effective_date));
9183: l_string := fnd_message.get;
9184: benutils.write(p_text => l_string);
9177: --
9178: if fnd_global.conc_request_id in ( 0,-1) then
9179: --
9180: fnd_message.set_name('BEN','BEN_93455_ELE_ALREADY_ENDED');
9181: fnd_message.set_token('PARMA',l_element_name);
9182: fnd_message.set_token('PARMB',to_char(l_effective_date));
9183: l_string := fnd_message.get;
9184: benutils.write(p_text => l_string);
9185: --
9178: if fnd_global.conc_request_id in ( 0,-1) then
9179: --
9180: fnd_message.set_name('BEN','BEN_93455_ELE_ALREADY_ENDED');
9181: fnd_message.set_token('PARMA',l_element_name);
9182: fnd_message.set_token('PARMB',to_char(l_effective_date));
9183: l_string := fnd_message.get;
9184: benutils.write(p_text => l_string);
9185: --
9186: end if;
9179: --
9180: fnd_message.set_name('BEN','BEN_93455_ELE_ALREADY_ENDED');
9181: fnd_message.set_token('PARMA',l_element_name);
9182: fnd_message.set_token('PARMB',to_char(l_effective_date));
9183: l_string := fnd_message.get;
9184: benutils.write(p_text => l_string);
9185: --
9186: end if;
9187: --
9287: p_person_id => p_person_id);
9288:
9289: if fnd_global.conc_request_id not in ( 0,-1) then
9290: --
9291: fnd_message.set_name('BEN','BEN_92456_END_RUN_RESULTS');
9292: fnd_message.set_token('PARMA',fnd_date.date_to_chardate(g_max_end_date,calendar_aware=>2));
9293: l_string := fnd_message.get;
9294: benutils.write(p_text => l_string);
9295: --
9288:
9289: if fnd_global.conc_request_id not in ( 0,-1) then
9290: --
9291: fnd_message.set_name('BEN','BEN_92456_END_RUN_RESULTS');
9292: fnd_message.set_token('PARMA',fnd_date.date_to_chardate(g_max_end_date,calendar_aware=>2));
9293: l_string := fnd_message.get;
9294: benutils.write(p_text => l_string);
9295: --
9296: end if;
9289: if fnd_global.conc_request_id not in ( 0,-1) then
9290: --
9291: fnd_message.set_name('BEN','BEN_92456_END_RUN_RESULTS');
9292: fnd_message.set_token('PARMA',fnd_date.date_to_chardate(g_max_end_date,calendar_aware=>2));
9293: l_string := fnd_message.get;
9294: benutils.write(p_text => l_string);
9295: --
9296: end if;
9297: g_msg_displayed :=1;
9837: when others then
9838: if g_debug then
9839: hr_utility.set_location('BEN_92311_FORMULA_VAL_PARAM',46);
9840: end if;
9841: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
9842: fnd_message.set_token('PROC',l_proc);
9843: fnd_message.set_token('FORMULA',l_prtl_mo_det_mthd_rl);
9844: fnd_message.set_token('PARAMETER',
9845: l_outputs(l_outputs.first).name);
9838: if g_debug then
9839: hr_utility.set_location('BEN_92311_FORMULA_VAL_PARAM',46);
9840: end if;
9841: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
9842: fnd_message.set_token('PROC',l_proc);
9843: fnd_message.set_token('FORMULA',l_prtl_mo_det_mthd_rl);
9844: fnd_message.set_token('PARAMETER',
9845: l_outputs(l_outputs.first).name);
9846: fnd_message.raise_error;
9839: hr_utility.set_location('BEN_92311_FORMULA_VAL_PARAM',46);
9840: end if;
9841: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
9842: fnd_message.set_token('PROC',l_proc);
9843: fnd_message.set_token('FORMULA',l_prtl_mo_det_mthd_rl);
9844: fnd_message.set_token('PARAMETER',
9845: l_outputs(l_outputs.first).name);
9846: fnd_message.raise_error;
9847: --
9840: end if;
9841: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
9842: fnd_message.set_token('PROC',l_proc);
9843: fnd_message.set_token('FORMULA',l_prtl_mo_det_mthd_rl);
9844: fnd_message.set_token('PARAMETER',
9845: l_outputs(l_outputs.first).name);
9846: fnd_message.raise_error;
9847: --
9848: end;
9842: fnd_message.set_token('PROC',l_proc);
9843: fnd_message.set_token('FORMULA',l_prtl_mo_det_mthd_rl);
9844: fnd_message.set_token('PARAMETER',
9845: l_outputs(l_outputs.first).name);
9846: fnd_message.raise_error;
9847: --
9848: end;
9849: end if;
9850: --
9951: close c_get_current_pp;
9952: if g_debug then
9953: hr_utility.set_location('BEN_92346_PAYROLL_NOT_DEFINED',48);
9954: end if;
9955: fnd_message.set_name('BEN', 'BEN_92346_PAYROLL_NOT_DEFINED');
9956: fnd_message.set_token('PROC',l_proc);
9957: fnd_message.raise_error;
9958: end if;
9959: --
9952: if g_debug then
9953: hr_utility.set_location('BEN_92346_PAYROLL_NOT_DEFINED',48);
9954: end if;
9955: fnd_message.set_name('BEN', 'BEN_92346_PAYROLL_NOT_DEFINED');
9956: fnd_message.set_token('PROC',l_proc);
9957: fnd_message.raise_error;
9958: end if;
9959: --
9960: close c_get_current_pp;
9953: hr_utility.set_location('BEN_92346_PAYROLL_NOT_DEFINED',48);
9954: end if;
9955: fnd_message.set_name('BEN', 'BEN_92346_PAYROLL_NOT_DEFINED');
9956: fnd_message.set_token('PROC',l_proc);
9957: fnd_message.raise_error;
9958: end if;
9959: --
9960: close c_get_current_pp;
9961: --
9991: (p_application_short_name => 'BEN',
9992: p_message_name => 'BEN_92939_NO_PRORATION',
9993: p_person_id => p_person_id);
9994: --
9995: fnd_message.set_name('BEN', 'BEN_92939_NO_PRORATION');
9996: if fnd_global.conc_request_id <> -1 then
9997: benutils.write(fnd_message.get);
9998: end if;
9999: --
9993: p_person_id => p_person_id);
9994: --
9995: fnd_message.set_name('BEN', 'BEN_92939_NO_PRORATION');
9996: if fnd_global.conc_request_id <> -1 then
9997: benutils.write(fnd_message.get);
9998: end if;
9999: --
10000: l_immediate_end := true;
10001: end if;
10015: close c_get_current_pp;
10016: if g_debug then
10017: hr_utility.set_location('BEN_92346_PAYROLL_NOT_DEFINED',48);
10018: end if;
10019: fnd_message.set_name('BEN', 'BEN_92346_PAYROLL_NOT_DEFINED');
10020: fnd_message.set_token('PROC',l_proc);
10021: fnd_message.raise_error;
10022: end if;
10023: --
10016: if g_debug then
10017: hr_utility.set_location('BEN_92346_PAYROLL_NOT_DEFINED',48);
10018: end if;
10019: fnd_message.set_name('BEN', 'BEN_92346_PAYROLL_NOT_DEFINED');
10020: fnd_message.set_token('PROC',l_proc);
10021: fnd_message.raise_error;
10022: end if;
10023: --
10024: close c_get_current_pp;
10017: hr_utility.set_location('BEN_92346_PAYROLL_NOT_DEFINED',48);
10018: end if;
10019: fnd_message.set_name('BEN', 'BEN_92346_PAYROLL_NOT_DEFINED');
10020: fnd_message.set_token('PROC',l_proc);
10021: fnd_message.raise_error;
10022: end if;
10023: --
10024: close c_get_current_pp;
10025: end if; -- l_remainder > 0
10040: close c_pps_prev_month;
10041: if g_debug then
10042: hr_utility.set_location('BEN_92346_PAYROLL_NOT_DEFINED',50);
10043: end if;
10044: fnd_message.set_name('BEN', 'BEN_92346_PAYROLL_NOT_DEFINED');
10045: fnd_message.set_token('PROC',l_proc);
10046: fnd_message.raise_error;
10047: end if;
10048: hr_elements.check_element_freq(
10041: if g_debug then
10042: hr_utility.set_location('BEN_92346_PAYROLL_NOT_DEFINED',50);
10043: end if;
10044: fnd_message.set_name('BEN', 'BEN_92346_PAYROLL_NOT_DEFINED');
10045: fnd_message.set_token('PROC',l_proc);
10046: fnd_message.raise_error;
10047: end if;
10048: hr_elements.check_element_freq(
10049: p_payroll_id =>l_payroll_id,
10042: hr_utility.set_location('BEN_92346_PAYROLL_NOT_DEFINED',50);
10043: end if;
10044: fnd_message.set_name('BEN', 'BEN_92346_PAYROLL_NOT_DEFINED');
10045: fnd_message.set_token('PROC',l_proc);
10046: fnd_message.raise_error;
10047: end if;
10048: hr_elements.check_element_freq(
10049: p_payroll_id =>l_payroll_id,
10050: p_bg_id =>p_business_group_id,
10539: if l_element_link_id is null then
10540: --
10541: -- error message already set on stack.
10542: --
10543: fnd_message.raise_error;
10544: end if;
10545: hr_utility.set_location( 'entering', 30.2);
10546: py_element_entry_api.create_element_entry
10547: (p_validate =>p_validate
10605: --
10606: if g_debug then
10607: hr_utility.set_location('BEN_92102_NO_ENTRY_CREATED',140);
10608: end if;
10609: fnd_message.set_name('BEN', 'BEN_92102_NO_ENTRY_CREATED');
10610: fnd_message.set_token('PROC','Create_reimburse_element');
10611: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_element_link_id));
10612: fnd_message.set_token('INPUT_VALUE_ID',to_char(l_input_value_id));
10613: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
10606: if g_debug then
10607: hr_utility.set_location('BEN_92102_NO_ENTRY_CREATED',140);
10608: end if;
10609: fnd_message.set_name('BEN', 'BEN_92102_NO_ENTRY_CREATED');
10610: fnd_message.set_token('PROC','Create_reimburse_element');
10611: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_element_link_id));
10612: fnd_message.set_token('INPUT_VALUE_ID',to_char(l_input_value_id));
10613: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
10614: fnd_message.raise_error;
10607: hr_utility.set_location('BEN_92102_NO_ENTRY_CREATED',140);
10608: end if;
10609: fnd_message.set_name('BEN', 'BEN_92102_NO_ENTRY_CREATED');
10610: fnd_message.set_token('PROC','Create_reimburse_element');
10611: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_element_link_id));
10612: fnd_message.set_token('INPUT_VALUE_ID',to_char(l_input_value_id));
10613: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
10614: fnd_message.raise_error;
10615: else
10608: end if;
10609: fnd_message.set_name('BEN', 'BEN_92102_NO_ENTRY_CREATED');
10610: fnd_message.set_token('PROC','Create_reimburse_element');
10611: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_element_link_id));
10612: fnd_message.set_token('INPUT_VALUE_ID',to_char(l_input_value_id));
10613: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
10614: fnd_message.raise_error;
10615: else
10616: --
10609: fnd_message.set_name('BEN', 'BEN_92102_NO_ENTRY_CREATED');
10610: fnd_message.set_token('PROC','Create_reimburse_element');
10611: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_element_link_id));
10612: fnd_message.set_token('INPUT_VALUE_ID',to_char(l_input_value_id));
10613: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
10614: fnd_message.raise_error;
10615: else
10616: --
10617: ben_prtt_rmt_aprvd_pymt_api.update_prtt_rmt_aprvd_pymt
10610: fnd_message.set_token('PROC','Create_reimburse_element');
10611: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_element_link_id));
10612: fnd_message.set_token('INPUT_VALUE_ID',to_char(l_input_value_id));
10613: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
10614: fnd_message.raise_error;
10615: else
10616: --
10617: ben_prtt_rmt_aprvd_pymt_api.update_prtt_rmt_aprvd_pymt
10618: (p_prtt_rmt_aprvd_fr_pymt_id => p_prtt_rmt_aprvd_fr_pymt_id,
10700: p_effective_date), 1,1) ;
10701: --
10702: if l_processed_flag = 'Y' then
10703: --
10704: fnd_message.set_name ('BEN','BEN_93341_PRCCSD_IN_PAYROLL');
10705: fnd_message.raise_error;
10706: --
10707: end if;
10708: --
10701: --
10702: if l_processed_flag = 'Y' then
10703: --
10704: fnd_message.set_name ('BEN','BEN_93341_PRCCSD_IN_PAYROLL');
10705: fnd_message.raise_error;
10706: --
10707: end if;
10708: --
10709: open c_element_entry (l_ele_rec.element_entry_id);