DBA Data[Home] [Help]

APPS.BEN_ELEMENT_ENTRY dependencies on FND_MESSAGE

Line 693: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');

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;

Line 694: fnd_message.set_token('PROC',l_proc);

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

Line 695: --fnd_message.set_token('FORMULA',l_input_va_calc_rl_rec.input_va_calc_rl);

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;

Line 696: fnd_message.set_token('PARAMETER',g_outputs(l_count).name);

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

Line 697: fnd_message.raise_error;

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;

Line 1201: fnd_message.set_name('BEN','BEN_91723_NO_ENRT_RT_ABR_FOUND');

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;

Line 1202: fnd_message.set_token('PROC',l_proc);

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

Line 1203: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));

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;

Line 1204: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));

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;

Line 1205: fnd_message.raise_error;

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

Line 1578: fnd_message.set_name('BEN', 'BEN_92458_NO_ASG_PAYROLL');

1574: /*
1575: if g_debug then
1576: hr_utility.set_location('BEN_92458_NO_ASG_PAYROLL PERSON:'|| to_char(p_person_id),5);
1577: end if;
1578: fnd_message.set_name('BEN', 'BEN_92458_NO_ASG_PAYROLL');
1579: fnd_message.set_token('PROC',l_proc);
1580: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1581: fnd_message.set_token('ASSIGNMENT_ID',to_char(p_assignment_id));
1582: fnd_message.raise_error;

Line 1579: fnd_message.set_token('PROC',l_proc);

1575: if g_debug then
1576: hr_utility.set_location('BEN_92458_NO_ASG_PAYROLL PERSON:'|| to_char(p_person_id),5);
1577: end if;
1578: fnd_message.set_name('BEN', 'BEN_92458_NO_ASG_PAYROLL');
1579: fnd_message.set_token('PROC',l_proc);
1580: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1581: fnd_message.set_token('ASSIGNMENT_ID',to_char(p_assignment_id));
1582: fnd_message.raise_error;
1583: */

Line 1580: fnd_message.set_token('PERSON_ID',to_char(p_person_id));

1576: hr_utility.set_location('BEN_92458_NO_ASG_PAYROLL PERSON:'|| to_char(p_person_id),5);
1577: end if;
1578: fnd_message.set_name('BEN', 'BEN_92458_NO_ASG_PAYROLL');
1579: fnd_message.set_token('PROC',l_proc);
1580: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1581: fnd_message.set_token('ASSIGNMENT_ID',to_char(p_assignment_id));
1582: fnd_message.raise_error;
1583: */
1584: if g_debug then

Line 1581: fnd_message.set_token('ASSIGNMENT_ID',to_char(p_assignment_id));

1577: end if;
1578: fnd_message.set_name('BEN', 'BEN_92458_NO_ASG_PAYROLL');
1579: fnd_message.set_token('PROC',l_proc);
1580: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1581: fnd_message.set_token('ASSIGNMENT_ID',to_char(p_assignment_id));
1582: fnd_message.raise_error;
1583: */
1584: if g_debug then
1585: hr_utility.set_location('BEN_93606_NO_ASG_PAYROLL PERSON:'|| to_char(p_person_id),5);

Line 1582: fnd_message.raise_error;

1578: fnd_message.set_name('BEN', 'BEN_92458_NO_ASG_PAYROLL');
1579: fnd_message.set_token('PROC',l_proc);
1580: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1581: fnd_message.set_token('ASSIGNMENT_ID',to_char(p_assignment_id));
1582: fnd_message.raise_error;
1583: */
1584: if g_debug then
1585: hr_utility.set_location('BEN_93606_NO_ASG_PAYROLL PERSON:'|| to_char(p_person_id),5);
1586: end if;

Line 1587: fnd_message.set_name('BEN', 'BEN_93606_NO_ASG_PAYROLL');

1583: */
1584: if g_debug then
1585: hr_utility.set_location('BEN_93606_NO_ASG_PAYROLL PERSON:'|| to_char(p_person_id),5);
1586: end if;
1587: fnd_message.set_name('BEN', 'BEN_93606_NO_ASG_PAYROLL');
1588: fnd_message.set_token('ABR_NAME', l_name);
1589: fnd_message.set_token('PROC',l_proc);
1590: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1591: fnd_message.set_token('ASSIGNMENT_ID',to_char(p_assignment_id));

Line 1588: fnd_message.set_token('ABR_NAME', l_name);

1584: if g_debug then
1585: hr_utility.set_location('BEN_93606_NO_ASG_PAYROLL PERSON:'|| to_char(p_person_id),5);
1586: end if;
1587: fnd_message.set_name('BEN', 'BEN_93606_NO_ASG_PAYROLL');
1588: fnd_message.set_token('ABR_NAME', l_name);
1589: fnd_message.set_token('PROC',l_proc);
1590: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1591: fnd_message.set_token('ASSIGNMENT_ID',to_char(p_assignment_id));
1592: fnd_message.raise_error;

Line 1589: fnd_message.set_token('PROC',l_proc);

1585: hr_utility.set_location('BEN_93606_NO_ASG_PAYROLL PERSON:'|| to_char(p_person_id),5);
1586: end if;
1587: fnd_message.set_name('BEN', 'BEN_93606_NO_ASG_PAYROLL');
1588: fnd_message.set_token('ABR_NAME', l_name);
1589: fnd_message.set_token('PROC',l_proc);
1590: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1591: fnd_message.set_token('ASSIGNMENT_ID',to_char(p_assignment_id));
1592: fnd_message.raise_error;
1593: end if;

Line 1590: fnd_message.set_token('PERSON_ID',to_char(p_person_id));

1586: end if;
1587: fnd_message.set_name('BEN', 'BEN_93606_NO_ASG_PAYROLL');
1588: fnd_message.set_token('ABR_NAME', l_name);
1589: fnd_message.set_token('PROC',l_proc);
1590: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1591: fnd_message.set_token('ASSIGNMENT_ID',to_char(p_assignment_id));
1592: fnd_message.raise_error;
1593: end if;
1594: --

Line 1591: fnd_message.set_token('ASSIGNMENT_ID',to_char(p_assignment_id));

1587: fnd_message.set_name('BEN', 'BEN_93606_NO_ASG_PAYROLL');
1588: fnd_message.set_token('ABR_NAME', l_name);
1589: fnd_message.set_token('PROC',l_proc);
1590: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1591: fnd_message.set_token('ASSIGNMENT_ID',to_char(p_assignment_id));
1592: fnd_message.raise_error;
1593: end if;
1594: --
1595: end if;

Line 1592: fnd_message.raise_error;

1588: fnd_message.set_token('ABR_NAME', l_name);
1589: fnd_message.set_token('PROC',l_proc);
1590: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1591: fnd_message.set_token('ASSIGNMENT_ID',to_char(p_assignment_id));
1592: fnd_message.raise_error;
1593: end if;
1594: --
1595: end if;
1596: --

Line 1623: fnd_message.set_name('BEN', 'BEN_92458_NO_ASG_PAYROLL');

1619: /*
1620: if g_debug then
1621: hr_utility.set_location('BEN_92458_NO_ASG_PAYROLL PERSON:'|| to_char(p_person_id),5);
1622: end if;
1623: fnd_message.set_name('BEN', 'BEN_92458_NO_ASG_PAYROLL');
1624: fnd_message.set_token('PROC',l_proc);
1625: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1626: fnd_message.set_token('ASSIGNMENT_ID',to_char(p_assignment_id));
1627: fnd_message.raise_error;

Line 1624: fnd_message.set_token('PROC',l_proc);

1620: if g_debug then
1621: hr_utility.set_location('BEN_92458_NO_ASG_PAYROLL PERSON:'|| to_char(p_person_id),5);
1622: end if;
1623: fnd_message.set_name('BEN', 'BEN_92458_NO_ASG_PAYROLL');
1624: fnd_message.set_token('PROC',l_proc);
1625: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1626: fnd_message.set_token('ASSIGNMENT_ID',to_char(p_assignment_id));
1627: fnd_message.raise_error;
1628: */

Line 1625: fnd_message.set_token('PERSON_ID',to_char(p_person_id));

1621: hr_utility.set_location('BEN_92458_NO_ASG_PAYROLL PERSON:'|| to_char(p_person_id),5);
1622: end if;
1623: fnd_message.set_name('BEN', 'BEN_92458_NO_ASG_PAYROLL');
1624: fnd_message.set_token('PROC',l_proc);
1625: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1626: fnd_message.set_token('ASSIGNMENT_ID',to_char(p_assignment_id));
1627: fnd_message.raise_error;
1628: */
1629: if g_debug then

Line 1626: fnd_message.set_token('ASSIGNMENT_ID',to_char(p_assignment_id));

1622: end if;
1623: fnd_message.set_name('BEN', 'BEN_92458_NO_ASG_PAYROLL');
1624: fnd_message.set_token('PROC',l_proc);
1625: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1626: fnd_message.set_token('ASSIGNMENT_ID',to_char(p_assignment_id));
1627: fnd_message.raise_error;
1628: */
1629: if g_debug then
1630: hr_utility.set_location('BEN_93606_NO_ASG_PAYROLL PERSON:'|| to_char(p_person_id),5);

Line 1627: fnd_message.raise_error;

1623: fnd_message.set_name('BEN', 'BEN_92458_NO_ASG_PAYROLL');
1624: fnd_message.set_token('PROC',l_proc);
1625: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1626: fnd_message.set_token('ASSIGNMENT_ID',to_char(p_assignment_id));
1627: fnd_message.raise_error;
1628: */
1629: if g_debug then
1630: hr_utility.set_location('BEN_93606_NO_ASG_PAYROLL PERSON:'|| to_char(p_person_id),5);
1631: end if;

Line 1632: fnd_message.set_name('BEN', 'BEN_93606_NO_ASG_PAYROLL');

1628: */
1629: if g_debug then
1630: hr_utility.set_location('BEN_93606_NO_ASG_PAYROLL PERSON:'|| to_char(p_person_id),5);
1631: end if;
1632: fnd_message.set_name('BEN', 'BEN_93606_NO_ASG_PAYROLL');
1633: fnd_message.set_token('ABR_NAME', l_name);
1634: fnd_message.set_token('PROC',l_proc);
1635: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1636: fnd_message.set_token('ASSIGNMENT_ID',to_char(p_assignment_id));

Line 1633: fnd_message.set_token('ABR_NAME', l_name);

1629: if g_debug then
1630: hr_utility.set_location('BEN_93606_NO_ASG_PAYROLL PERSON:'|| to_char(p_person_id),5);
1631: end if;
1632: fnd_message.set_name('BEN', 'BEN_93606_NO_ASG_PAYROLL');
1633: fnd_message.set_token('ABR_NAME', l_name);
1634: fnd_message.set_token('PROC',l_proc);
1635: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1636: fnd_message.set_token('ASSIGNMENT_ID',to_char(p_assignment_id));
1637: fnd_message.raise_error;

Line 1634: fnd_message.set_token('PROC',l_proc);

1630: hr_utility.set_location('BEN_93606_NO_ASG_PAYROLL PERSON:'|| to_char(p_person_id),5);
1631: end if;
1632: fnd_message.set_name('BEN', 'BEN_93606_NO_ASG_PAYROLL');
1633: fnd_message.set_token('ABR_NAME', l_name);
1634: fnd_message.set_token('PROC',l_proc);
1635: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1636: fnd_message.set_token('ASSIGNMENT_ID',to_char(p_assignment_id));
1637: fnd_message.raise_error;
1638: end if;

Line 1635: fnd_message.set_token('PERSON_ID',to_char(p_person_id));

1631: end if;
1632: fnd_message.set_name('BEN', 'BEN_93606_NO_ASG_PAYROLL');
1633: fnd_message.set_token('ABR_NAME', l_name);
1634: fnd_message.set_token('PROC',l_proc);
1635: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1636: fnd_message.set_token('ASSIGNMENT_ID',to_char(p_assignment_id));
1637: fnd_message.raise_error;
1638: end if;
1639: end if;

Line 1636: fnd_message.set_token('ASSIGNMENT_ID',to_char(p_assignment_id));

1632: fnd_message.set_name('BEN', 'BEN_93606_NO_ASG_PAYROLL');
1633: fnd_message.set_token('ABR_NAME', l_name);
1634: fnd_message.set_token('PROC',l_proc);
1635: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1636: fnd_message.set_token('ASSIGNMENT_ID',to_char(p_assignment_id));
1637: fnd_message.raise_error;
1638: end if;
1639: end if;
1640: return TRUE;

Line 1637: fnd_message.raise_error;

1633: fnd_message.set_token('ABR_NAME', l_name);
1634: fnd_message.set_token('PROC',l_proc);
1635: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1636: fnd_message.set_token('ASSIGNMENT_ID',to_char(p_assignment_id));
1637: fnd_message.raise_error;
1638: end if;
1639: end if;
1640: return TRUE;
1641: --

Line 1652: fnd_message.set_name('BEN', 'BEN_92347_NO_DFLT_PAYROLL');

1648: if p_payroll_id is null then
1649: if g_debug then
1650: hr_utility.set_location('BEN_92347_NO_DFLT_PAYROLL',25);
1651: end if;
1652: fnd_message.set_name('BEN', 'BEN_92347_NO_DFLT_PAYROLL');
1653: fnd_message.set_token('PROC',l_proc);
1654: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1655: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
1656: fnd_message.set_token('BG_ID',to_char(p_business_group_id));

Line 1653: fnd_message.set_token('PROC',l_proc);

1649: if g_debug then
1650: hr_utility.set_location('BEN_92347_NO_DFLT_PAYROLL',25);
1651: end if;
1652: fnd_message.set_name('BEN', 'BEN_92347_NO_DFLT_PAYROLL');
1653: fnd_message.set_token('PROC',l_proc);
1654: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1655: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
1656: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
1657: fnd_message.raise_error;

Line 1654: fnd_message.set_token('PERSON_ID',to_char(p_person_id));

1650: hr_utility.set_location('BEN_92347_NO_DFLT_PAYROLL',25);
1651: end if;
1652: fnd_message.set_name('BEN', 'BEN_92347_NO_DFLT_PAYROLL');
1653: fnd_message.set_token('PROC',l_proc);
1654: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1655: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
1656: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
1657: fnd_message.raise_error;
1658: else

Line 1655: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));

1651: end if;
1652: fnd_message.set_name('BEN', 'BEN_92347_NO_DFLT_PAYROLL');
1653: fnd_message.set_token('PROC',l_proc);
1654: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1655: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
1656: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
1657: fnd_message.raise_error;
1658: else
1659: if g_debug then

Line 1656: fnd_message.set_token('BG_ID',to_char(p_business_group_id));

1652: fnd_message.set_name('BEN', 'BEN_92347_NO_DFLT_PAYROLL');
1653: fnd_message.set_token('PROC',l_proc);
1654: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1655: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
1656: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
1657: fnd_message.raise_error;
1658: else
1659: if g_debug then
1660: hr_utility.set_location('Leaving-returning false:' ||l_proc,5);

Line 1657: fnd_message.raise_error;

1653: fnd_message.set_token('PROC',l_proc);
1654: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1655: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
1656: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
1657: fnd_message.raise_error;
1658: else
1659: if g_debug then
1660: hr_utility.set_location('Leaving-returning false:' ||l_proc,5);
1661: end if;

Line 1835: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');

1831: when others then
1832: if g_debug then
1833: hr_utility.set_location('BEN_92311_FORMULA_VAL_PARAM',5);
1834: end if;
1835: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
1836: fnd_message.set_token('PROC',l_proc);
1837: fnd_message.set_token('FORMULA',p_prtl_mo_det_mthd_rl);
1838: fnd_message.set_token('PARAMETER',l_outputs(l_outputs.first).name);
1839: fnd_message.raise_error;

Line 1836: fnd_message.set_token('PROC',l_proc);

1832: if g_debug then
1833: hr_utility.set_location('BEN_92311_FORMULA_VAL_PARAM',5);
1834: end if;
1835: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
1836: fnd_message.set_token('PROC',l_proc);
1837: fnd_message.set_token('FORMULA',p_prtl_mo_det_mthd_rl);
1838: fnd_message.set_token('PARAMETER',l_outputs(l_outputs.first).name);
1839: fnd_message.raise_error;
1840: --

Line 1837: fnd_message.set_token('FORMULA',p_prtl_mo_det_mthd_rl);

1833: hr_utility.set_location('BEN_92311_FORMULA_VAL_PARAM',5);
1834: end if;
1835: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
1836: fnd_message.set_token('PROC',l_proc);
1837: fnd_message.set_token('FORMULA',p_prtl_mo_det_mthd_rl);
1838: fnd_message.set_token('PARAMETER',l_outputs(l_outputs.first).name);
1839: fnd_message.raise_error;
1840: --
1841: end;

Line 1838: fnd_message.set_token('PARAMETER',l_outputs(l_outputs.first).name);

1834: end if;
1835: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
1836: fnd_message.set_token('PROC',l_proc);
1837: fnd_message.set_token('FORMULA',p_prtl_mo_det_mthd_rl);
1838: fnd_message.set_token('PARAMETER',l_outputs(l_outputs.first).name);
1839: fnd_message.raise_error;
1840: --
1841: end;
1842: end if;

Line 1839: fnd_message.raise_error;

1835: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
1836: fnd_message.set_token('PROC',l_proc);
1837: fnd_message.set_token('FORMULA',p_prtl_mo_det_mthd_rl);
1838: fnd_message.set_token('PARAMETER',l_outputs(l_outputs.first).name);
1839: fnd_message.raise_error;
1840: --
1841: end;
1842: end if;
1843: --

Line 1948: fnd_message.set_name('BEN', 'BEN_92343_NO_PCT_VAL_OR_RL');

1944: --
1945: if g_debug then
1946: hr_utility.set_location('BEN_92343_NO_PCT_VAL_OR_RL',5);
1947: end if;
1948: fnd_message.set_name('BEN', 'BEN_92343_NO_PCT_VAL_OR_RL');
1949: fnd_message.set_token('PROC',l_proc);
1950: fnd_message.set_token('PRTL_MO_RT_PRTN_VAL_ID',
1951: to_char(p_rec.prtl_mo_rt_prtn_val_id));
1952: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));

Line 1949: fnd_message.set_token('PROC',l_proc);

1945: if g_debug then
1946: hr_utility.set_location('BEN_92343_NO_PCT_VAL_OR_RL',5);
1947: end if;
1948: fnd_message.set_name('BEN', 'BEN_92343_NO_PCT_VAL_OR_RL');
1949: fnd_message.set_token('PROC',l_proc);
1950: fnd_message.set_token('PRTL_MO_RT_PRTN_VAL_ID',
1951: to_char(p_rec.prtl_mo_rt_prtn_val_id));
1952: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
1953: fnd_message.set_token('ACTL_PREM_ID',to_char(p_actl_prem_id));

Line 1950: fnd_message.set_token('PRTL_MO_RT_PRTN_VAL_ID',

1946: hr_utility.set_location('BEN_92343_NO_PCT_VAL_OR_RL',5);
1947: end if;
1948: fnd_message.set_name('BEN', 'BEN_92343_NO_PCT_VAL_OR_RL');
1949: fnd_message.set_token('PROC',l_proc);
1950: fnd_message.set_token('PRTL_MO_RT_PRTN_VAL_ID',
1951: to_char(p_rec.prtl_mo_rt_prtn_val_id));
1952: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
1953: fnd_message.set_token('ACTL_PREM_ID',to_char(p_actl_prem_id));
1954: fnd_message.set_token('CVG_AMT_CALC_MTHD_ID',

Line 1952: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));

1948: fnd_message.set_name('BEN', 'BEN_92343_NO_PCT_VAL_OR_RL');
1949: fnd_message.set_token('PROC',l_proc);
1950: fnd_message.set_token('PRTL_MO_RT_PRTN_VAL_ID',
1951: to_char(p_rec.prtl_mo_rt_prtn_val_id));
1952: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
1953: fnd_message.set_token('ACTL_PREM_ID',to_char(p_actl_prem_id));
1954: fnd_message.set_token('CVG_AMT_CALC_MTHD_ID',
1955: to_char(p_cvg_amt_calc_mthd_id));
1956: fnd_message.raise_error;

Line 1953: fnd_message.set_token('ACTL_PREM_ID',to_char(p_actl_prem_id));

1949: fnd_message.set_token('PROC',l_proc);
1950: fnd_message.set_token('PRTL_MO_RT_PRTN_VAL_ID',
1951: to_char(p_rec.prtl_mo_rt_prtn_val_id));
1952: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
1953: fnd_message.set_token('ACTL_PREM_ID',to_char(p_actl_prem_id));
1954: fnd_message.set_token('CVG_AMT_CALC_MTHD_ID',
1955: to_char(p_cvg_amt_calc_mthd_id));
1956: fnd_message.raise_error;
1957: else

Line 1954: fnd_message.set_token('CVG_AMT_CALC_MTHD_ID',

1950: fnd_message.set_token('PRTL_MO_RT_PRTN_VAL_ID',
1951: to_char(p_rec.prtl_mo_rt_prtn_val_id));
1952: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
1953: fnd_message.set_token('ACTL_PREM_ID',to_char(p_actl_prem_id));
1954: fnd_message.set_token('CVG_AMT_CALC_MTHD_ID',
1955: to_char(p_cvg_amt_calc_mthd_id));
1956: fnd_message.raise_error;
1957: else
1958: --

Line 1956: fnd_message.raise_error;

1952: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
1953: fnd_message.set_token('ACTL_PREM_ID',to_char(p_actl_prem_id));
1954: fnd_message.set_token('CVG_AMT_CALC_MTHD_ID',
1955: to_char(p_cvg_amt_calc_mthd_id));
1956: fnd_message.raise_error;
1957: else
1958: --
1959: -- Get pct_val from rule execution.
1960: --

Line 1987: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');

1983: when others then
1984: if g_debug then
1985: hr_utility.set_location('BEN_92311_FORMULA_VAL_PARAM',15);
1986: end if;
1987: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
1988: fnd_message.set_token('PROC',l_proc);
1989: fnd_message.set_token('FORMULA',p_rec.prtl_mo_prortn_rl);
1990: fnd_message.set_token('PARAMETER',
1991: l_outputs(l_outputs.first).name);

Line 1988: fnd_message.set_token('PROC',l_proc);

1984: if g_debug then
1985: hr_utility.set_location('BEN_92311_FORMULA_VAL_PARAM',15);
1986: end if;
1987: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
1988: fnd_message.set_token('PROC',l_proc);
1989: fnd_message.set_token('FORMULA',p_rec.prtl_mo_prortn_rl);
1990: fnd_message.set_token('PARAMETER',
1991: l_outputs(l_outputs.first).name);
1992: fnd_message.raise_error;

Line 1989: fnd_message.set_token('FORMULA',p_rec.prtl_mo_prortn_rl);

1985: hr_utility.set_location('BEN_92311_FORMULA_VAL_PARAM',15);
1986: end if;
1987: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
1988: fnd_message.set_token('PROC',l_proc);
1989: fnd_message.set_token('FORMULA',p_rec.prtl_mo_prortn_rl);
1990: fnd_message.set_token('PARAMETER',
1991: l_outputs(l_outputs.first).name);
1992: fnd_message.raise_error;
1993: --

Line 1990: fnd_message.set_token('PARAMETER',

1986: end if;
1987: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
1988: fnd_message.set_token('PROC',l_proc);
1989: fnd_message.set_token('FORMULA',p_rec.prtl_mo_prortn_rl);
1990: fnd_message.set_token('PARAMETER',
1991: l_outputs(l_outputs.first).name);
1992: fnd_message.raise_error;
1993: --
1994: end;

Line 1992: fnd_message.raise_error;

1988: fnd_message.set_token('PROC',l_proc);
1989: fnd_message.set_token('FORMULA',p_rec.prtl_mo_prortn_rl);
1990: fnd_message.set_token('PARAMETER',
1991: l_outputs(l_outputs.first).name);
1992: fnd_message.raise_error;
1993: --
1994: end;
1995: --
1996: end if;

Line 2077: fnd_message.set_name('BEN', 'BEN_92348_UNKNOWN_PRTN_DET_CD');

2073: --
2074: if g_debug then
2075: hr_utility.set_location('BEN_92348_UNKNOWN_PRTN_DET_CD',15);
2076: end if;
2077: fnd_message.set_name('BEN', 'BEN_92348_UNKNOWN_PRTN_DET_CD');
2078: fnd_message.set_token('PROC',l_proc);
2079: fnd_message.set_token('PRTL_MO_DET_MTHD_CD',p_prtl_mo_det_mthd_cd);
2080: fnd_message.raise_error;
2081: end if;

Line 2078: fnd_message.set_token('PROC',l_proc);

2074: if g_debug then
2075: hr_utility.set_location('BEN_92348_UNKNOWN_PRTN_DET_CD',15);
2076: end if;
2077: fnd_message.set_name('BEN', 'BEN_92348_UNKNOWN_PRTN_DET_CD');
2078: fnd_message.set_token('PROC',l_proc);
2079: fnd_message.set_token('PRTL_MO_DET_MTHD_CD',p_prtl_mo_det_mthd_cd);
2080: fnd_message.raise_error;
2081: end if;
2082: --

Line 2079: fnd_message.set_token('PRTL_MO_DET_MTHD_CD',p_prtl_mo_det_mthd_cd);

2075: hr_utility.set_location('BEN_92348_UNKNOWN_PRTN_DET_CD',15);
2076: end if;
2077: fnd_message.set_name('BEN', 'BEN_92348_UNKNOWN_PRTN_DET_CD');
2078: fnd_message.set_token('PROC',l_proc);
2079: fnd_message.set_token('PRTL_MO_DET_MTHD_CD',p_prtl_mo_det_mthd_cd);
2080: fnd_message.raise_error;
2081: end if;
2082: --
2083: if (p_rndg_cd is not null or

Line 2080: fnd_message.raise_error;

2076: end if;
2077: fnd_message.set_name('BEN', 'BEN_92348_UNKNOWN_PRTN_DET_CD');
2078: fnd_message.set_token('PROC',l_proc);
2079: fnd_message.set_token('PRTL_MO_DET_MTHD_CD',p_prtl_mo_det_mthd_cd);
2080: fnd_message.raise_error;
2081: end if;
2082: --
2083: if (p_rndg_cd is not null or
2084: p_rndg_rl is not null) and

Line 2316: fnd_message.set_name('BEN', 'BEN_93289_ASG_ABR_NOT_FOUND');

2312: if c_getasgdets%notfound then
2313: --
2314: close c_getasgdets;
2315: --
2316: fnd_message.set_name('BEN', 'BEN_93289_ASG_ABR_NOT_FOUND');
2317: fnd_message.set_token('ACTY_BASE_RT_NAME',g_acty_base_rt_name);
2318: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
2319: if g_debug then
2320: hr_utility.set_location('ASG: BEN_93289_ASG_ABR_NOT_FOUND',5); -- 2105656

Line 2317: fnd_message.set_token('ACTY_BASE_RT_NAME',g_acty_base_rt_name);

2313: --
2314: close c_getasgdets;
2315: --
2316: fnd_message.set_name('BEN', 'BEN_93289_ASG_ABR_NOT_FOUND');
2317: fnd_message.set_token('ACTY_BASE_RT_NAME',g_acty_base_rt_name);
2318: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
2319: if g_debug then
2320: hr_utility.set_location('ASG: BEN_93289_ASG_ABR_NOT_FOUND',5); -- 2105656
2321: end if;

Line 2318: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));

2314: close c_getasgdets;
2315: --
2316: fnd_message.set_name('BEN', 'BEN_93289_ASG_ABR_NOT_FOUND');
2317: fnd_message.set_token('ACTY_BASE_RT_NAME',g_acty_base_rt_name);
2318: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
2319: if g_debug then
2320: hr_utility.set_location('ASG: BEN_93289_ASG_ABR_NOT_FOUND',5); -- 2105656
2321: end if;
2322: fnd_message.raise_error;

Line 2322: fnd_message.raise_error;

2318: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
2319: if g_debug then
2320: hr_utility.set_location('ASG: BEN_93289_ASG_ABR_NOT_FOUND',5); -- 2105656
2321: end if;
2322: fnd_message.raise_error;
2323: --
2324: end if;
2325: if g_debug then
2326: hr_utility.set_location('c_getasgdets is not null',999);

Line 2430: fnd_message.set_name('BEN', 'BEN_92344_NO_ELEMENT_LINK');

2426: end loop;
2427: --
2428: if l_link_count = 0 then
2429: --
2430: fnd_message.set_name('BEN', 'BEN_92344_NO_ELEMENT_LINK');
2431: fnd_message.set_token('PROC',l_proc);
2432: fnd_message.set_token('ASSIGNMENT_ID',to_char(p_assignment_id));
2433: fnd_message.set_token('ELEMENT_TYPE_ID',to_char(p_element_type_id));
2434: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));

Line 2431: fnd_message.set_token('PROC',l_proc);

2427: --
2428: if l_link_count = 0 then
2429: --
2430: fnd_message.set_name('BEN', 'BEN_92344_NO_ELEMENT_LINK');
2431: fnd_message.set_token('PROC',l_proc);
2432: fnd_message.set_token('ASSIGNMENT_ID',to_char(p_assignment_id));
2433: fnd_message.set_token('ELEMENT_TYPE_ID',to_char(p_element_type_id));
2434: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
2435: if g_debug then

Line 2432: fnd_message.set_token('ASSIGNMENT_ID',to_char(p_assignment_id));

2428: if l_link_count = 0 then
2429: --
2430: fnd_message.set_name('BEN', 'BEN_92344_NO_ELEMENT_LINK');
2431: fnd_message.set_token('PROC',l_proc);
2432: fnd_message.set_token('ASSIGNMENT_ID',to_char(p_assignment_id));
2433: fnd_message.set_token('ELEMENT_TYPE_ID',to_char(p_element_type_id));
2434: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
2435: if g_debug then
2436: hr_utility.set_location('ELK: BEN_92344_NO_ELEMENT_LINK',5);

Line 2433: fnd_message.set_token('ELEMENT_TYPE_ID',to_char(p_element_type_id));

2429: --
2430: fnd_message.set_name('BEN', 'BEN_92344_NO_ELEMENT_LINK');
2431: fnd_message.set_token('PROC',l_proc);
2432: fnd_message.set_token('ASSIGNMENT_ID',to_char(p_assignment_id));
2433: fnd_message.set_token('ELEMENT_TYPE_ID',to_char(p_element_type_id));
2434: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
2435: if g_debug then
2436: hr_utility.set_location('ELK: BEN_92344_NO_ELEMENT_LINK',5);
2437: end if;

Line 2434: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));

2430: fnd_message.set_name('BEN', 'BEN_92344_NO_ELEMENT_LINK');
2431: fnd_message.set_token('PROC',l_proc);
2432: fnd_message.set_token('ASSIGNMENT_ID',to_char(p_assignment_id));
2433: fnd_message.set_token('ELEMENT_TYPE_ID',to_char(p_element_type_id));
2434: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
2435: if g_debug then
2436: hr_utility.set_location('ELK: BEN_92344_NO_ELEMENT_LINK',5);
2437: end if;
2438: --

Line 2441: fnd_message.set_name('BEN', 'BEN_93288_ASG_ELEM_LNK_INELIG');

2437: end if;
2438: --
2439: elsif l_elk_count = 0 then -- bug 2105656
2440: --
2441: fnd_message.set_name('BEN', 'BEN_93288_ASG_ELEM_LNK_INELIG');
2442: fnd_message.set_token('ASSIGNMENT_ID',to_char(p_assignment_id));
2443: fnd_message.set_token('ELEMENT_TYPE_ID',to_char(p_element_type_id));
2444: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
2445: if g_debug then

Line 2442: fnd_message.set_token('ASSIGNMENT_ID',to_char(p_assignment_id));

2438: --
2439: elsif l_elk_count = 0 then -- bug 2105656
2440: --
2441: fnd_message.set_name('BEN', 'BEN_93288_ASG_ELEM_LNK_INELIG');
2442: fnd_message.set_token('ASSIGNMENT_ID',to_char(p_assignment_id));
2443: fnd_message.set_token('ELEMENT_TYPE_ID',to_char(p_element_type_id));
2444: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
2445: if g_debug then
2446: hr_utility.set_location('ELK: BEN_93288_ASG_ELEM_LNK_INELIG',6);

Line 2443: fnd_message.set_token('ELEMENT_TYPE_ID',to_char(p_element_type_id));

2439: elsif l_elk_count = 0 then -- bug 2105656
2440: --
2441: fnd_message.set_name('BEN', 'BEN_93288_ASG_ELEM_LNK_INELIG');
2442: fnd_message.set_token('ASSIGNMENT_ID',to_char(p_assignment_id));
2443: fnd_message.set_token('ELEMENT_TYPE_ID',to_char(p_element_type_id));
2444: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
2445: if g_debug then
2446: hr_utility.set_location('ELK: BEN_93288_ASG_ELEM_LNK_INELIG',6);
2447: end if;

Line 2444: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));

2440: --
2441: fnd_message.set_name('BEN', 'BEN_93288_ASG_ELEM_LNK_INELIG');
2442: fnd_message.set_token('ASSIGNMENT_ID',to_char(p_assignment_id));
2443: fnd_message.set_token('ELEMENT_TYPE_ID',to_char(p_element_type_id));
2444: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
2445: if g_debug then
2446: hr_utility.set_location('ELK: BEN_93288_ASG_ELEM_LNK_INELIG',6);
2447: end if;
2448: --

Line 2585: fnd_message.set_name('BEN','BEN_93448_FUTURE_BEN_ENTRY');

2581: if c_chk_rt%found then
2582: --
2583: close c_future_ee;
2584: close c_chk_rt;
2585: fnd_message.set_name('BEN','BEN_93448_FUTURE_BEN_ENTRY');
2586: fnd_message.set_token('P_RATE',l_rt_rec.rt_name);
2587: fnd_message.set_token('P_DATE',to_char(l_future_ee_rec.effective_start_date));
2588: fnd_message.raise_error;
2589: --

Line 2586: fnd_message.set_token('P_RATE',l_rt_rec.rt_name);

2582: --
2583: close c_future_ee;
2584: close c_chk_rt;
2585: fnd_message.set_name('BEN','BEN_93448_FUTURE_BEN_ENTRY');
2586: fnd_message.set_token('P_RATE',l_rt_rec.rt_name);
2587: fnd_message.set_token('P_DATE',to_char(l_future_ee_rec.effective_start_date));
2588: fnd_message.raise_error;
2589: --
2590: end if;

Line 2587: fnd_message.set_token('P_DATE',to_char(l_future_ee_rec.effective_start_date));

2583: close c_future_ee;
2584: close c_chk_rt;
2585: fnd_message.set_name('BEN','BEN_93448_FUTURE_BEN_ENTRY');
2586: fnd_message.set_token('P_RATE',l_rt_rec.rt_name);
2587: fnd_message.set_token('P_DATE',to_char(l_future_ee_rec.effective_start_date));
2588: fnd_message.raise_error;
2589: --
2590: end if;
2591: close c_chk_rt;

Line 2588: fnd_message.raise_error;

2584: close c_chk_rt;
2585: fnd_message.set_name('BEN','BEN_93448_FUTURE_BEN_ENTRY');
2586: fnd_message.set_token('P_RATE',l_rt_rec.rt_name);
2587: fnd_message.set_token('P_DATE',to_char(l_future_ee_rec.effective_start_date));
2588: fnd_message.raise_error;
2589: --
2590: end if;
2591: close c_chk_rt;
2592: py_element_entry_api.delete_element_entry

Line 2608: fnd_message.set_name('BEN','BEN_93447_FUTURE_USER_ENTRY');

2604: -- User created entry. Throw error
2605: --
2606: if p_multiple_entries_flag ='N' then
2607: close c_future_ee;
2608: fnd_message.set_name('BEN','BEN_93447_FUTURE_USER_ENTRY');
2609: fnd_message.set_token('P_DATE',to_char(l_future_ee_rec.effective_start_date));
2610: fnd_message.set_token('P_ELEMENT',l_future_ee_rec.element_name);
2611: fnd_message.raise_error;
2612: end if;

Line 2609: fnd_message.set_token('P_DATE',to_char(l_future_ee_rec.effective_start_date));

2605: --
2606: if p_multiple_entries_flag ='N' then
2607: close c_future_ee;
2608: fnd_message.set_name('BEN','BEN_93447_FUTURE_USER_ENTRY');
2609: fnd_message.set_token('P_DATE',to_char(l_future_ee_rec.effective_start_date));
2610: fnd_message.set_token('P_ELEMENT',l_future_ee_rec.element_name);
2611: fnd_message.raise_error;
2612: end if;
2613: end if;

Line 2610: fnd_message.set_token('P_ELEMENT',l_future_ee_rec.element_name);

2606: if p_multiple_entries_flag ='N' then
2607: close c_future_ee;
2608: fnd_message.set_name('BEN','BEN_93447_FUTURE_USER_ENTRY');
2609: fnd_message.set_token('P_DATE',to_char(l_future_ee_rec.effective_start_date));
2610: fnd_message.set_token('P_ELEMENT',l_future_ee_rec.element_name);
2611: fnd_message.raise_error;
2612: end if;
2613: end if;
2614:

Line 2611: fnd_message.raise_error;

2607: close c_future_ee;
2608: fnd_message.set_name('BEN','BEN_93447_FUTURE_USER_ENTRY');
2609: fnd_message.set_token('P_DATE',to_char(l_future_ee_rec.effective_start_date));
2610: fnd_message.set_token('P_ELEMENT',l_future_ee_rec.element_name);
2611: fnd_message.raise_error;
2612: end if;
2613: end if;
2614:
2615: end loop;

Line 3541: l_encoded_message := fnd_message.get;

3537: when others then
3538: ben_on_line_lf_evt.get_ser_message(l_encoded_message,
3539: l_app_short_name,
3540: l_message_name);
3541: l_encoded_message := fnd_message.get;
3542: --
3543: if l_message_name like '%HR_6284_ELE_ENTRY_DT_ASG_DEL%' or
3544: l_message_name like '%HR_7187_DT_CANNOT_EXTEND_END%' then
3545: -- assignment is not eligible for link beyond this date.

Line 3551: fnd_message.set_name(l_app_short_name,l_message_name);

3547: --
3548: null;
3549: else
3550: if l_app_short_name is not null then
3551: fnd_message.set_name(l_app_short_name,l_message_name);
3552: fnd_message.raise_error;
3553: else
3554: raise;
3555: end if;

Line 3552: fnd_message.raise_error;

3548: null;
3549: else
3550: if l_app_short_name is not null then
3551: fnd_message.set_name(l_app_short_name,l_message_name);
3552: fnd_message.raise_error;
3553: else
3554: raise;
3555: end if;
3556: end if;

Line 3741: l_encoded_message := fnd_message.get;

3737: when others then
3738: ben_on_line_lf_evt.get_ser_message(l_encoded_message,
3739: l_app_short_name,
3740: l_message_name);
3741: l_encoded_message := fnd_message.get;
3742: --
3743: if l_message_name like '%HR_6284_ELE_ENTRY_DT_ASG_DEL%' or
3744: l_message_name like '%HR_7187_DT_CANNOT_EXTEND_END%' then
3745: -- assignment is not eligible for link beyond this date.

Line 3751: fnd_message.set_name(l_app_short_name,l_message_name);

3747: --
3748: null;
3749: else
3750: if l_app_short_name is not null then
3751: fnd_message.set_name(l_app_short_name,l_message_name);
3752: fnd_message.raise_error;
3753: else
3754: raise;
3755: end if;

Line 3752: fnd_message.raise_error;

3748: null;
3749: else
3750: if l_app_short_name is not null then
3751: fnd_message.set_name(l_app_short_name,l_message_name);
3752: fnd_message.raise_error;
3753: else
3754: raise;
3755: end if;
3756: end if;

Line 3808: fnd_message.set_name('BEN', 'BEN_92103_NO_PRTT_RT_VAL');

3804: hr_utility.set_location('BEN_92103_NO_PRTT_RT_VAL',170);
3805: end if;
3806: close c_get_prtt_rt_val;
3807: --
3808: fnd_message.set_name('BEN', 'BEN_92103_NO_PRTT_RT_VAL');
3809: fnd_message.set_token('PROC',l_proc);
3810: fnd_message.set_token('PRTT_RT_VAL',to_char(p_prtt_rt_val_id));
3811: fnd_message.raise_error;
3812: --

Line 3809: fnd_message.set_token('PROC',l_proc);

3805: end if;
3806: close c_get_prtt_rt_val;
3807: --
3808: fnd_message.set_name('BEN', 'BEN_92103_NO_PRTT_RT_VAL');
3809: fnd_message.set_token('PROC',l_proc);
3810: fnd_message.set_token('PRTT_RT_VAL',to_char(p_prtt_rt_val_id));
3811: fnd_message.raise_error;
3812: --
3813: end if;

Line 3810: fnd_message.set_token('PRTT_RT_VAL',to_char(p_prtt_rt_val_id));

3806: close c_get_prtt_rt_val;
3807: --
3808: fnd_message.set_name('BEN', 'BEN_92103_NO_PRTT_RT_VAL');
3809: fnd_message.set_token('PROC',l_proc);
3810: fnd_message.set_token('PRTT_RT_VAL',to_char(p_prtt_rt_val_id));
3811: fnd_message.raise_error;
3812: --
3813: end if;
3814: close c_get_prtt_rt_val;

Line 3811: fnd_message.raise_error;

3807: --
3808: fnd_message.set_name('BEN', 'BEN_92103_NO_PRTT_RT_VAL');
3809: fnd_message.set_token('PROC',l_proc);
3810: fnd_message.set_token('PRTT_RT_VAL',to_char(p_prtt_rt_val_id));
3811: fnd_message.raise_error;
3812: --
3813: end if;
3814: close c_get_prtt_rt_val;
3815: end if;

Line 3844: fnd_message.set_name('BEN','BEN_91723_NO_ENRT_RT_ABR_FOUND');

3840: close get_abr_info;
3841: if g_debug then
3842: hr_utility.set_location('BEN_91723_NO_ENRT_RT_ABR_FOUND',5);
3843: end if;
3844: fnd_message.set_name('BEN','BEN_91723_NO_ENRT_RT_ABR_FOUND');
3845: fnd_message.set_token('PROC',l_proc);
3846: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
3847: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
3848: fnd_message.raise_error;

Line 3845: fnd_message.set_token('PROC',l_proc);

3841: if g_debug then
3842: hr_utility.set_location('BEN_91723_NO_ENRT_RT_ABR_FOUND',5);
3843: end if;
3844: fnd_message.set_name('BEN','BEN_91723_NO_ENRT_RT_ABR_FOUND');
3845: fnd_message.set_token('PROC',l_proc);
3846: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
3847: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
3848: fnd_message.raise_error;
3849: end if;

Line 3846: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));

3842: hr_utility.set_location('BEN_91723_NO_ENRT_RT_ABR_FOUND',5);
3843: end if;
3844: fnd_message.set_name('BEN','BEN_91723_NO_ENRT_RT_ABR_FOUND');
3845: fnd_message.set_token('PROC',l_proc);
3846: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
3847: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
3848: fnd_message.raise_error;
3849: end if;
3850: close get_abr_info;

Line 3847: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));

3843: end if;
3844: fnd_message.set_name('BEN','BEN_91723_NO_ENRT_RT_ABR_FOUND');
3845: fnd_message.set_token('PROC',l_proc);
3846: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
3847: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
3848: fnd_message.raise_error;
3849: end if;
3850: close get_abr_info;
3851:

Line 3848: fnd_message.raise_error;

3844: fnd_message.set_name('BEN','BEN_91723_NO_ENRT_RT_ABR_FOUND');
3845: fnd_message.set_token('PROC',l_proc);
3846: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
3847: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
3848: fnd_message.raise_error;
3849: end if;
3850: close get_abr_info;
3851:
3852: g_acty_base_rt_name := l_get_abr_info.name;

Line 3967: fnd_message.raise_error;

3963: if l_element_link_id is null then
3964: --
3965: -- error message already set on stack.
3966: --
3967: fnd_message.raise_error;
3968: end if;
3969:
3970: l_old_element_link_id := l_element_link_id;
3971:

Line 4120: fnd_message.set_name('BEN','BEN_92690_ELMNT_ALRDY_USD');

4116: fetch c_dup_prv into l_abr_name;
4117: if c_dup_prv%found then
4118: --
4119: close c_dup_prv;
4120: fnd_message.set_name('BEN','BEN_92690_ELMNT_ALRDY_USD');
4121: fnd_message.set_token('P_RATE1',l_abr_name);
4122: fnd_message.set_token('P_RATE2',g_acty_base_rt_name);
4123: fnd_message.raise_error;
4124: --

Line 4121: fnd_message.set_token('P_RATE1',l_abr_name);

4117: if c_dup_prv%found then
4118: --
4119: close c_dup_prv;
4120: fnd_message.set_name('BEN','BEN_92690_ELMNT_ALRDY_USD');
4121: fnd_message.set_token('P_RATE1',l_abr_name);
4122: fnd_message.set_token('P_RATE2',g_acty_base_rt_name);
4123: fnd_message.raise_error;
4124: --
4125: end if;

Line 4122: fnd_message.set_token('P_RATE2',g_acty_base_rt_name);

4118: --
4119: close c_dup_prv;
4120: fnd_message.set_name('BEN','BEN_92690_ELMNT_ALRDY_USD');
4121: fnd_message.set_token('P_RATE1',l_abr_name);
4122: fnd_message.set_token('P_RATE2',g_acty_base_rt_name);
4123: fnd_message.raise_error;
4124: --
4125: end if;
4126: close c_dup_prv;

Line 4123: fnd_message.raise_error;

4119: close c_dup_prv;
4120: fnd_message.set_name('BEN','BEN_92690_ELMNT_ALRDY_USD');
4121: fnd_message.set_token('P_RATE1',l_abr_name);
4122: fnd_message.set_token('P_RATE2',g_acty_base_rt_name);
4123: fnd_message.raise_error;
4124: --
4125: end if;
4126: close c_dup_prv;
4127: --

Line 4135: fnd_message.set_name('BEN','BEN_93450_ELE_MULTIPLE_RSLT');

4131: fetch c_dup_rslt into l_abr_name;
4132: if c_dup_rslt%found then
4133: --
4134: close c_dup_rslt;
4135: fnd_message.set_name('BEN','BEN_93450_ELE_MULTIPLE_RSLT');
4136: fnd_message.set_token('P_RATE1',l_abr_name);
4137: fnd_message.set_token('P_RATE2',g_acty_base_rt_name);
4138: fnd_message.raise_error;
4139: --

Line 4136: fnd_message.set_token('P_RATE1',l_abr_name);

4132: if c_dup_rslt%found then
4133: --
4134: close c_dup_rslt;
4135: fnd_message.set_name('BEN','BEN_93450_ELE_MULTIPLE_RSLT');
4136: fnd_message.set_token('P_RATE1',l_abr_name);
4137: fnd_message.set_token('P_RATE2',g_acty_base_rt_name);
4138: fnd_message.raise_error;
4139: --
4140: end if;

Line 4137: fnd_message.set_token('P_RATE2',g_acty_base_rt_name);

4133: --
4134: close c_dup_rslt;
4135: fnd_message.set_name('BEN','BEN_93450_ELE_MULTIPLE_RSLT');
4136: fnd_message.set_token('P_RATE1',l_abr_name);
4137: fnd_message.set_token('P_RATE2',g_acty_base_rt_name);
4138: fnd_message.raise_error;
4139: --
4140: end if;
4141: close c_dup_rslt;

Line 4138: fnd_message.raise_error;

4134: close c_dup_rslt;
4135: fnd_message.set_name('BEN','BEN_93450_ELE_MULTIPLE_RSLT');
4136: fnd_message.set_token('P_RATE1',l_abr_name);
4137: fnd_message.set_token('P_RATE2',g_acty_base_rt_name);
4138: fnd_message.raise_error;
4139: --
4140: end if;
4141: close c_dup_rslt;
4142:

Line 4198: l_encoded_message := fnd_message.get;

4194: when others then
4195: ben_on_line_lf_evt.get_ser_message(l_encoded_message,
4196: l_app_short_name,
4197: l_message_name);
4198: l_encoded_message := fnd_message.get;
4199: --
4200: if l_message_name like '%HR_6284_ELE_ENTRY_DT_ASG_DEL%' or
4201: l_message_name like '%HR_7187_DT_CANNOT_EXTEND_END%' then
4202: --

Line 4209: fnd_message.set_name(l_app_short_name,l_message_name);

4205: --
4206: null;
4207: else
4208: if l_app_short_name is not null then
4209: fnd_message.set_name(l_app_short_name,l_message_name);
4210: fnd_message.raise_error;
4211: else
4212: raise;
4213: end if;

Line 4210: fnd_message.raise_error;

4206: null;
4207: else
4208: if l_app_short_name is not null then
4209: fnd_message.set_name(l_app_short_name,l_message_name);
4210: fnd_message.raise_error;
4211: else
4212: raise;
4213: end if;
4214: end if;

Line 4298: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');

4294: when others then
4295: if g_debug then
4296: hr_utility.set_location('BEN_92311_FORMULA_VAL_PARAM',30);
4297: end if;
4298: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
4299: fnd_message.set_token('PROC',l_proc);
4300: fnd_message.set_token('FORMULA',l_get_abr_info.prtl_mo_det_mthd_rl);
4301: fnd_message.set_token('PARAMETER',
4302: l_outputs(l_outputs.first).name);

Line 4299: fnd_message.set_token('PROC',l_proc);

4295: if g_debug then
4296: hr_utility.set_location('BEN_92311_FORMULA_VAL_PARAM',30);
4297: end if;
4298: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
4299: fnd_message.set_token('PROC',l_proc);
4300: fnd_message.set_token('FORMULA',l_get_abr_info.prtl_mo_det_mthd_rl);
4301: fnd_message.set_token('PARAMETER',
4302: l_outputs(l_outputs.first).name);
4303: fnd_message.raise_error;

Line 4300: fnd_message.set_token('FORMULA',l_get_abr_info.prtl_mo_det_mthd_rl);

4296: hr_utility.set_location('BEN_92311_FORMULA_VAL_PARAM',30);
4297: end if;
4298: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
4299: fnd_message.set_token('PROC',l_proc);
4300: fnd_message.set_token('FORMULA',l_get_abr_info.prtl_mo_det_mthd_rl);
4301: fnd_message.set_token('PARAMETER',
4302: l_outputs(l_outputs.first).name);
4303: fnd_message.raise_error;
4304: --

Line 4301: fnd_message.set_token('PARAMETER',

4297: end if;
4298: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
4299: fnd_message.set_token('PROC',l_proc);
4300: fnd_message.set_token('FORMULA',l_get_abr_info.prtl_mo_det_mthd_rl);
4301: fnd_message.set_token('PARAMETER',
4302: l_outputs(l_outputs.first).name);
4303: fnd_message.raise_error;
4304: --
4305: end;

Line 4303: fnd_message.raise_error;

4299: fnd_message.set_token('PROC',l_proc);
4300: fnd_message.set_token('FORMULA',l_get_abr_info.prtl_mo_det_mthd_rl);
4301: fnd_message.set_token('PARAMETER',
4302: l_outputs(l_outputs.first).name);
4303: fnd_message.raise_error;
4304: --
4305: end;
4306: end if;
4307: -- ELE :

Line 4426: fnd_message.set_name('BEN','BEN_93368_DETERMINE_PAY_PERIOD');

4422: --
4423: if l_last_pp_end_dt is null and
4424: ben_epe_cache.g_currepe_row.elig_per_elctbl_chc_id is null then
4425: --
4426: fnd_message.set_name('BEN','BEN_93368_DETERMINE_PAY_PERIOD');
4427: fnd_message.raise_error;
4428: --
4429: end if;
4430: --

Line 4427: fnd_message.raise_error;

4423: if l_last_pp_end_dt is null and
4424: ben_epe_cache.g_currepe_row.elig_per_elctbl_chc_id is null then
4425: --
4426: fnd_message.set_name('BEN','BEN_93368_DETERMINE_PAY_PERIOD');
4427: fnd_message.raise_error;
4428: --
4429: end if;
4430: --
4431: -- Bug 2149438

Line 4783: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');

4779: --
4780: if g_debug then
4781: hr_utility.set_location('BEN_91628_LOOKUP_TYPE_GENERIC',30);
4782: end if;
4783: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
4784: fnd_message.set_token('FIELD','p_one_ann_pymt_cd');
4785: fnd_message.set_token('TYPE','BEN_ONE_ANN_PYMT');
4786: fnd_message.set_token('VALUE',l_get_abr_info.one_ann_pymt_cd);
4787: fnd_message.raise_error;

Line 4784: fnd_message.set_token('FIELD','p_one_ann_pymt_cd');

4780: if g_debug then
4781: hr_utility.set_location('BEN_91628_LOOKUP_TYPE_GENERIC',30);
4782: end if;
4783: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
4784: fnd_message.set_token('FIELD','p_one_ann_pymt_cd');
4785: fnd_message.set_token('TYPE','BEN_ONE_ANN_PYMT');
4786: fnd_message.set_token('VALUE',l_get_abr_info.one_ann_pymt_cd);
4787: fnd_message.raise_error;
4788: end if;

Line 4785: fnd_message.set_token('TYPE','BEN_ONE_ANN_PYMT');

4781: hr_utility.set_location('BEN_91628_LOOKUP_TYPE_GENERIC',30);
4782: end if;
4783: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
4784: fnd_message.set_token('FIELD','p_one_ann_pymt_cd');
4785: fnd_message.set_token('TYPE','BEN_ONE_ANN_PYMT');
4786: fnd_message.set_token('VALUE',l_get_abr_info.one_ann_pymt_cd);
4787: fnd_message.raise_error;
4788: end if;
4789: end if;

Line 4786: fnd_message.set_token('VALUE',l_get_abr_info.one_ann_pymt_cd);

4782: end if;
4783: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
4784: fnd_message.set_token('FIELD','p_one_ann_pymt_cd');
4785: fnd_message.set_token('TYPE','BEN_ONE_ANN_PYMT');
4786: fnd_message.set_token('VALUE',l_get_abr_info.one_ann_pymt_cd);
4787: fnd_message.raise_error;
4788: end if;
4789: end if;
4790:

Line 4787: fnd_message.raise_error;

4783: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
4784: fnd_message.set_token('FIELD','p_one_ann_pymt_cd');
4785: fnd_message.set_token('TYPE','BEN_ONE_ANN_PYMT');
4786: fnd_message.set_token('VALUE',l_get_abr_info.one_ann_pymt_cd);
4787: fnd_message.raise_error;
4788: end if;
4789: end if;
4790:
4791: -- ELE :

Line 4929: fnd_message.set_name('BEN', 'BEN_92346_PAYROLL_NOT_DEFINED');

4925: close c_pps_next_month;
4926: if g_debug then
4927: hr_utility.set_location('BEN_92346_PAYROLL_NOT_DEFINED',30);
4928: end if;
4929: fnd_message.set_name('BEN', 'BEN_92346_PAYROLL_NOT_DEFINED');
4930: fnd_message.set_token('PROC',l_proc);
4931: fnd_message.raise_error;
4932: end if;
4933: hr_elements.check_element_freq(

Line 4930: fnd_message.set_token('PROC',l_proc);

4926: if g_debug then
4927: hr_utility.set_location('BEN_92346_PAYROLL_NOT_DEFINED',30);
4928: end if;
4929: fnd_message.set_name('BEN', 'BEN_92346_PAYROLL_NOT_DEFINED');
4930: fnd_message.set_token('PROC',l_proc);
4931: fnd_message.raise_error;
4932: end if;
4933: hr_elements.check_element_freq(
4934: p_payroll_id =>l_payroll_id,

Line 4931: fnd_message.raise_error;

4927: hr_utility.set_location('BEN_92346_PAYROLL_NOT_DEFINED',30);
4928: end if;
4929: fnd_message.set_name('BEN', 'BEN_92346_PAYROLL_NOT_DEFINED');
4930: fnd_message.set_token('PROC',l_proc);
4931: fnd_message.raise_error;
4932: end if;
4933: hr_elements.check_element_freq(
4934: p_payroll_id =>l_payroll_id,
4935: p_bg_id =>p_business_group_id,

Line 4963: fnd_message.set_name('BEN', 'BEN_92346_PAYROLL_NOT_DEFINED');

4959: close c_pps_next_month;
4960: if g_debug then
4961: hr_utility.set_location('BEN_92346_PAYROLL_NOT_DEFINED',32);
4962: end if;
4963: fnd_message.set_name('BEN', 'BEN_92346_PAYROLL_NOT_DEFINED');
4964: fnd_message.set_token('PROC',l_proc);
4965: fnd_message.raise_error;
4966: end if;
4967: hr_elements.check_element_freq(

Line 4964: fnd_message.set_token('PROC',l_proc);

4960: if g_debug then
4961: hr_utility.set_location('BEN_92346_PAYROLL_NOT_DEFINED',32);
4962: end if;
4963: fnd_message.set_name('BEN', 'BEN_92346_PAYROLL_NOT_DEFINED');
4964: fnd_message.set_token('PROC',l_proc);
4965: fnd_message.raise_error;
4966: end if;
4967: hr_elements.check_element_freq(
4968: p_payroll_id =>l_payroll_id,

Line 4965: fnd_message.raise_error;

4961: hr_utility.set_location('BEN_92346_PAYROLL_NOT_DEFINED',32);
4962: end if;
4963: fnd_message.set_name('BEN', 'BEN_92346_PAYROLL_NOT_DEFINED');
4964: fnd_message.set_token('PROC',l_proc);
4965: fnd_message.raise_error;
4966: end if;
4967: hr_elements.check_element_freq(
4968: p_payroll_id =>l_payroll_id,
4969: p_bg_id =>p_business_group_id,

Line 5010: fnd_message.set_name('BEN', 'BEN_92346_PAYROLL_NOT_DEFINED');

5006: close c_pps_next_month;
5007: if g_debug then
5008: hr_utility.set_location('BEN_92346_PAYROLL_NOT_DEFINED',34);
5009: end if;
5010: fnd_message.set_name('BEN', 'BEN_92346_PAYROLL_NOT_DEFINED');
5011: fnd_message.set_token('PROC',l_proc);
5012: fnd_message.raise_error;
5013: end if;
5014: hr_elements.check_element_freq(

Line 5011: fnd_message.set_token('PROC',l_proc);

5007: if g_debug then
5008: hr_utility.set_location('BEN_92346_PAYROLL_NOT_DEFINED',34);
5009: end if;
5010: fnd_message.set_name('BEN', 'BEN_92346_PAYROLL_NOT_DEFINED');
5011: fnd_message.set_token('PROC',l_proc);
5012: fnd_message.raise_error;
5013: end if;
5014: hr_elements.check_element_freq(
5015: p_payroll_id => l_payroll_id,

Line 5012: fnd_message.raise_error;

5008: hr_utility.set_location('BEN_92346_PAYROLL_NOT_DEFINED',34);
5009: end if;
5010: fnd_message.set_name('BEN', 'BEN_92346_PAYROLL_NOT_DEFINED');
5011: fnd_message.set_token('PROC',l_proc);
5012: fnd_message.raise_error;
5013: end if;
5014: hr_elements.check_element_freq(
5015: p_payroll_id => l_payroll_id,
5016: p_bg_id => p_business_group_id,

Line 5192: fnd_message.set_name('BEN', 'BEN_92101_NO_RATE');

5188: close get_current_value;
5189: if g_debug then
5190: hr_utility.set_location('BEN_92101_NO_RATE ',90);
5191: end if;
5192: fnd_message.set_name('BEN', 'BEN_92101_NO_RATE');
5193: fnd_message.set_token('PROC',l_proc);
5194: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_element_entry_id));
5195: fnd_message.set_token('INPUT_VALUE_ID',to_char(l_input_value_id));
5196: fnd_message.set_token('EFFECTIVE_DATE',to_char(l_zero_pp_date));

Line 5193: fnd_message.set_token('PROC',l_proc);

5189: if g_debug then
5190: hr_utility.set_location('BEN_92101_NO_RATE ',90);
5191: end if;
5192: fnd_message.set_name('BEN', 'BEN_92101_NO_RATE');
5193: fnd_message.set_token('PROC',l_proc);
5194: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_element_entry_id));
5195: fnd_message.set_token('INPUT_VALUE_ID',to_char(l_input_value_id));
5196: fnd_message.set_token('EFFECTIVE_DATE',to_char(l_zero_pp_date));
5197: fnd_message.set_token('ABR_NAME',l_get_abr_info.name); -- Bug 2519349

Line 5194: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_element_entry_id));

5190: hr_utility.set_location('BEN_92101_NO_RATE ',90);
5191: end if;
5192: fnd_message.set_name('BEN', 'BEN_92101_NO_RATE');
5193: fnd_message.set_token('PROC',l_proc);
5194: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_element_entry_id));
5195: fnd_message.set_token('INPUT_VALUE_ID',to_char(l_input_value_id));
5196: fnd_message.set_token('EFFECTIVE_DATE',to_char(l_zero_pp_date));
5197: fnd_message.set_token('ABR_NAME',l_get_abr_info.name); -- Bug 2519349
5198: fnd_message.raise_error;

Line 5195: fnd_message.set_token('INPUT_VALUE_ID',to_char(l_input_value_id));

5191: end if;
5192: fnd_message.set_name('BEN', 'BEN_92101_NO_RATE');
5193: fnd_message.set_token('PROC',l_proc);
5194: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_element_entry_id));
5195: fnd_message.set_token('INPUT_VALUE_ID',to_char(l_input_value_id));
5196: fnd_message.set_token('EFFECTIVE_DATE',to_char(l_zero_pp_date));
5197: fnd_message.set_token('ABR_NAME',l_get_abr_info.name); -- Bug 2519349
5198: fnd_message.raise_error;
5199: end if;

Line 5196: fnd_message.set_token('EFFECTIVE_DATE',to_char(l_zero_pp_date));

5192: fnd_message.set_name('BEN', 'BEN_92101_NO_RATE');
5193: fnd_message.set_token('PROC',l_proc);
5194: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_element_entry_id));
5195: fnd_message.set_token('INPUT_VALUE_ID',to_char(l_input_value_id));
5196: fnd_message.set_token('EFFECTIVE_DATE',to_char(l_zero_pp_date));
5197: fnd_message.set_token('ABR_NAME',l_get_abr_info.name); -- Bug 2519349
5198: fnd_message.raise_error;
5199: end if;
5200: close get_current_value;

Line 5197: fnd_message.set_token('ABR_NAME',l_get_abr_info.name); -- Bug 2519349

5193: fnd_message.set_token('PROC',l_proc);
5194: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_element_entry_id));
5195: fnd_message.set_token('INPUT_VALUE_ID',to_char(l_input_value_id));
5196: fnd_message.set_token('EFFECTIVE_DATE',to_char(l_zero_pp_date));
5197: fnd_message.set_token('ABR_NAME',l_get_abr_info.name); -- Bug 2519349
5198: fnd_message.raise_error;
5199: end if;
5200: close get_current_value;
5201:

Line 5198: fnd_message.raise_error;

5194: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_element_entry_id));
5195: fnd_message.set_token('INPUT_VALUE_ID',to_char(l_input_value_id));
5196: fnd_message.set_token('EFFECTIVE_DATE',to_char(l_zero_pp_date));
5197: fnd_message.set_token('ABR_NAME',l_get_abr_info.name); -- Bug 2519349
5198: fnd_message.raise_error;
5199: end if;
5200: close get_current_value;
5201:
5202: --

Line 5508: fnd_message.set_name('BEN', 'BEN_92101_NO_RATE');

5504: close get_current_value;
5505: if g_debug then
5506: hr_utility.set_location('BEN_92101_NO_RATE ',92);
5507: end if;
5508: fnd_message.set_name('BEN', 'BEN_92101_NO_RATE');
5509: fnd_message.set_token('PROC',l_proc);
5510: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_element_entry_id));
5511: fnd_message.set_token('INPUT_VALUE_ID',to_char(l_input_value_id));
5512: fnd_message.set_token('EFFECTIVE_DATE',to_char(l_special_pp_date));

Line 5509: fnd_message.set_token('PROC',l_proc);

5505: if g_debug then
5506: hr_utility.set_location('BEN_92101_NO_RATE ',92);
5507: end if;
5508: fnd_message.set_name('BEN', 'BEN_92101_NO_RATE');
5509: fnd_message.set_token('PROC',l_proc);
5510: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_element_entry_id));
5511: fnd_message.set_token('INPUT_VALUE_ID',to_char(l_input_value_id));
5512: fnd_message.set_token('EFFECTIVE_DATE',to_char(l_special_pp_date));
5513: fnd_message.set_token('ABR_NAME',l_get_abr_info.name); -- Bug 2519349

Line 5510: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_element_entry_id));

5506: hr_utility.set_location('BEN_92101_NO_RATE ',92);
5507: end if;
5508: fnd_message.set_name('BEN', 'BEN_92101_NO_RATE');
5509: fnd_message.set_token('PROC',l_proc);
5510: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_element_entry_id));
5511: fnd_message.set_token('INPUT_VALUE_ID',to_char(l_input_value_id));
5512: fnd_message.set_token('EFFECTIVE_DATE',to_char(l_special_pp_date));
5513: fnd_message.set_token('ABR_NAME',l_get_abr_info.name); -- Bug 2519349
5514: fnd_message.raise_error;

Line 5511: fnd_message.set_token('INPUT_VALUE_ID',to_char(l_input_value_id));

5507: end if;
5508: fnd_message.set_name('BEN', 'BEN_92101_NO_RATE');
5509: fnd_message.set_token('PROC',l_proc);
5510: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_element_entry_id));
5511: fnd_message.set_token('INPUT_VALUE_ID',to_char(l_input_value_id));
5512: fnd_message.set_token('EFFECTIVE_DATE',to_char(l_special_pp_date));
5513: fnd_message.set_token('ABR_NAME',l_get_abr_info.name); -- Bug 2519349
5514: fnd_message.raise_error;
5515: end if;

Line 5512: fnd_message.set_token('EFFECTIVE_DATE',to_char(l_special_pp_date));

5508: fnd_message.set_name('BEN', 'BEN_92101_NO_RATE');
5509: fnd_message.set_token('PROC',l_proc);
5510: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_element_entry_id));
5511: fnd_message.set_token('INPUT_VALUE_ID',to_char(l_input_value_id));
5512: fnd_message.set_token('EFFECTIVE_DATE',to_char(l_special_pp_date));
5513: fnd_message.set_token('ABR_NAME',l_get_abr_info.name); -- Bug 2519349
5514: fnd_message.raise_error;
5515: end if;
5516: close get_current_value;

Line 5513: fnd_message.set_token('ABR_NAME',l_get_abr_info.name); -- Bug 2519349

5509: fnd_message.set_token('PROC',l_proc);
5510: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_element_entry_id));
5511: fnd_message.set_token('INPUT_VALUE_ID',to_char(l_input_value_id));
5512: fnd_message.set_token('EFFECTIVE_DATE',to_char(l_special_pp_date));
5513: fnd_message.set_token('ABR_NAME',l_get_abr_info.name); -- Bug 2519349
5514: fnd_message.raise_error;
5515: end if;
5516: close get_current_value;
5517:

Line 5514: fnd_message.raise_error;

5510: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_element_entry_id));
5511: fnd_message.set_token('INPUT_VALUE_ID',to_char(l_input_value_id));
5512: fnd_message.set_token('EFFECTIVE_DATE',to_char(l_special_pp_date));
5513: fnd_message.set_token('ABR_NAME',l_get_abr_info.name); -- Bug 2519349
5514: fnd_message.raise_error;
5515: end if;
5516: close get_current_value;
5517:
5518: if l_uom is null then

Line 5873: fnd_message.set_name('BEN', 'BEN_92101_NO_RATE');

5869: close get_current_value;
5870: if g_debug then
5871: hr_utility.set_location('BEN_92101_NO_RATE ',94);
5872: end if;
5873: fnd_message.set_name('BEN', 'BEN_92101_NO_RATE');
5874: fnd_message.set_token('PROC',l_proc);
5875: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_element_entry_id));
5876: fnd_message.set_token('INPUT_VALUE_ID',to_char(l_input_value_id));
5877: fnd_message.set_token('EFFECTIVE_DATE',to_char(l_normal_pp_date));

Line 5874: fnd_message.set_token('PROC',l_proc);

5870: if g_debug then
5871: hr_utility.set_location('BEN_92101_NO_RATE ',94);
5872: end if;
5873: fnd_message.set_name('BEN', 'BEN_92101_NO_RATE');
5874: fnd_message.set_token('PROC',l_proc);
5875: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_element_entry_id));
5876: fnd_message.set_token('INPUT_VALUE_ID',to_char(l_input_value_id));
5877: fnd_message.set_token('EFFECTIVE_DATE',to_char(l_normal_pp_date));
5878: fnd_message.set_token('ABR_NAME',l_get_abr_info.name); -- Bug 2519349

Line 5875: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_element_entry_id));

5871: hr_utility.set_location('BEN_92101_NO_RATE ',94);
5872: end if;
5873: fnd_message.set_name('BEN', 'BEN_92101_NO_RATE');
5874: fnd_message.set_token('PROC',l_proc);
5875: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_element_entry_id));
5876: fnd_message.set_token('INPUT_VALUE_ID',to_char(l_input_value_id));
5877: fnd_message.set_token('EFFECTIVE_DATE',to_char(l_normal_pp_date));
5878: fnd_message.set_token('ABR_NAME',l_get_abr_info.name); -- Bug 2519349
5879: fnd_message.raise_error;

Line 5876: fnd_message.set_token('INPUT_VALUE_ID',to_char(l_input_value_id));

5872: end if;
5873: fnd_message.set_name('BEN', 'BEN_92101_NO_RATE');
5874: fnd_message.set_token('PROC',l_proc);
5875: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_element_entry_id));
5876: fnd_message.set_token('INPUT_VALUE_ID',to_char(l_input_value_id));
5877: fnd_message.set_token('EFFECTIVE_DATE',to_char(l_normal_pp_date));
5878: fnd_message.set_token('ABR_NAME',l_get_abr_info.name); -- Bug 2519349
5879: fnd_message.raise_error;
5880: end if;

Line 5877: fnd_message.set_token('EFFECTIVE_DATE',to_char(l_normal_pp_date));

5873: fnd_message.set_name('BEN', 'BEN_92101_NO_RATE');
5874: fnd_message.set_token('PROC',l_proc);
5875: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_element_entry_id));
5876: fnd_message.set_token('INPUT_VALUE_ID',to_char(l_input_value_id));
5877: fnd_message.set_token('EFFECTIVE_DATE',to_char(l_normal_pp_date));
5878: fnd_message.set_token('ABR_NAME',l_get_abr_info.name); -- Bug 2519349
5879: fnd_message.raise_error;
5880: end if;
5881: close get_current_value;

Line 5878: fnd_message.set_token('ABR_NAME',l_get_abr_info.name); -- Bug 2519349

5874: fnd_message.set_token('PROC',l_proc);
5875: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_element_entry_id));
5876: fnd_message.set_token('INPUT_VALUE_ID',to_char(l_input_value_id));
5877: fnd_message.set_token('EFFECTIVE_DATE',to_char(l_normal_pp_date));
5878: fnd_message.set_token('ABR_NAME',l_get_abr_info.name); -- Bug 2519349
5879: fnd_message.raise_error;
5880: end if;
5881: close get_current_value;
5882: --

Line 5879: fnd_message.raise_error;

5875: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_element_entry_id));
5876: fnd_message.set_token('INPUT_VALUE_ID',to_char(l_input_value_id));
5877: fnd_message.set_token('EFFECTIVE_DATE',to_char(l_normal_pp_date));
5878: fnd_message.set_token('ABR_NAME',l_get_abr_info.name); -- Bug 2519349
5879: fnd_message.raise_error;
5880: end if;
5881: close get_current_value;
5882: --
5883: if l_uom is null then

Line 6396: fnd_message.set_name('BEN',l_message_name);

6392: p_person_id => p_person_id);
6393: --
6394: if fnd_global.conc_request_id not in ( 0,-1) then
6395: --
6396: fnd_message.set_name('BEN',l_message_name);
6397: fnd_message.set_token('PARMA',l_element_name);
6398: fnd_message.set_token('PARMB',to_char(l_effective_end_date));
6399: l_string := fnd_message.get;
6400: benutils.write(p_text => l_string);

Line 6397: fnd_message.set_token('PARMA',l_element_name);

6393: --
6394: if fnd_global.conc_request_id not in ( 0,-1) then
6395: --
6396: fnd_message.set_name('BEN',l_message_name);
6397: fnd_message.set_token('PARMA',l_element_name);
6398: fnd_message.set_token('PARMB',to_char(l_effective_end_date));
6399: l_string := fnd_message.get;
6400: benutils.write(p_text => l_string);
6401: --

Line 6398: fnd_message.set_token('PARMB',to_char(l_effective_end_date));

6394: if fnd_global.conc_request_id not in ( 0,-1) then
6395: --
6396: fnd_message.set_name('BEN',l_message_name);
6397: fnd_message.set_token('PARMA',l_element_name);
6398: fnd_message.set_token('PARMB',to_char(l_effective_end_date));
6399: l_string := fnd_message.get;
6400: benutils.write(p_text => l_string);
6401: --
6402: end if;

Line 6399: l_string := fnd_message.get;

6395: --
6396: fnd_message.set_name('BEN',l_message_name);
6397: fnd_message.set_token('PARMA',l_element_name);
6398: fnd_message.set_token('PARMB',to_char(l_effective_end_date));
6399: l_string := fnd_message.get;
6400: benutils.write(p_text => l_string);
6401: --
6402: end if;
6403: --

Line 6442: fnd_message.set_name('BEN', 'BEN_92102_NO_ENTRY_CREATED');

6438: --
6439: if g_debug then
6440: hr_utility.set_location('BEN_92102_NO_ENTRY_CREATED',140);
6441: end if;
6442: fnd_message.set_name('BEN', 'BEN_92102_NO_ENTRY_CREATED');
6443: fnd_message.set_token('PROC',l_proc);
6444: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_old_element_link_id));
6445: fnd_message.set_token('INPUT_VALUE_ID',to_char(l_input_value_id));
6446: fnd_message.set_token('EFFECTIVE_DATE',to_char(l_rt_strt_dt));

Line 6443: fnd_message.set_token('PROC',l_proc);

6439: if g_debug then
6440: hr_utility.set_location('BEN_92102_NO_ENTRY_CREATED',140);
6441: end if;
6442: fnd_message.set_name('BEN', 'BEN_92102_NO_ENTRY_CREATED');
6443: fnd_message.set_token('PROC',l_proc);
6444: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_old_element_link_id));
6445: fnd_message.set_token('INPUT_VALUE_ID',to_char(l_input_value_id));
6446: fnd_message.set_token('EFFECTIVE_DATE',to_char(l_rt_strt_dt));
6447: fnd_message.raise_error;

Line 6444: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_old_element_link_id));

6440: hr_utility.set_location('BEN_92102_NO_ENTRY_CREATED',140);
6441: end if;
6442: fnd_message.set_name('BEN', 'BEN_92102_NO_ENTRY_CREATED');
6443: fnd_message.set_token('PROC',l_proc);
6444: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_old_element_link_id));
6445: fnd_message.set_token('INPUT_VALUE_ID',to_char(l_input_value_id));
6446: fnd_message.set_token('EFFECTIVE_DATE',to_char(l_rt_strt_dt));
6447: fnd_message.raise_error;
6448: --

Line 6445: fnd_message.set_token('INPUT_VALUE_ID',to_char(l_input_value_id));

6441: end if;
6442: fnd_message.set_name('BEN', 'BEN_92102_NO_ENTRY_CREATED');
6443: fnd_message.set_token('PROC',l_proc);
6444: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_old_element_link_id));
6445: fnd_message.set_token('INPUT_VALUE_ID',to_char(l_input_value_id));
6446: fnd_message.set_token('EFFECTIVE_DATE',to_char(l_rt_strt_dt));
6447: fnd_message.raise_error;
6448: --
6449: end if;

Line 6446: fnd_message.set_token('EFFECTIVE_DATE',to_char(l_rt_strt_dt));

6442: fnd_message.set_name('BEN', 'BEN_92102_NO_ENTRY_CREATED');
6443: fnd_message.set_token('PROC',l_proc);
6444: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_old_element_link_id));
6445: fnd_message.set_token('INPUT_VALUE_ID',to_char(l_input_value_id));
6446: fnd_message.set_token('EFFECTIVE_DATE',to_char(l_rt_strt_dt));
6447: fnd_message.raise_error;
6448: --
6449: end if;
6450: close get_element_entry;

Line 6447: fnd_message.raise_error;

6443: fnd_message.set_token('PROC',l_proc);
6444: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_old_element_link_id));
6445: fnd_message.set_token('INPUT_VALUE_ID',to_char(l_input_value_id));
6446: fnd_message.set_token('EFFECTIVE_DATE',to_char(l_rt_strt_dt));
6447: fnd_message.raise_error;
6448: --
6449: end if;
6450: close get_element_entry;
6451: --

Line 6550: fnd_message.set_name('BEN','BEN_92455_STRT_RUN_RESULTS');

6546: p_person_id => p_person_id);
6547:
6548: if fnd_global.conc_request_id in ( 0,-1) then
6549: --
6550: fnd_message.set_name('BEN','BEN_92455_STRT_RUN_RESULTS');
6551: fnd_message.set_token('PARMA', fnd_date.date_to_chardate(g_max_end_date));
6552: l_string := fnd_message.get;
6553: benutils.write(p_text => l_string);
6554: --

Line 6551: fnd_message.set_token('PARMA', fnd_date.date_to_chardate(g_max_end_date));

6547:
6548: if fnd_global.conc_request_id in ( 0,-1) then
6549: --
6550: fnd_message.set_name('BEN','BEN_92455_STRT_RUN_RESULTS');
6551: fnd_message.set_token('PARMA', fnd_date.date_to_chardate(g_max_end_date));
6552: l_string := fnd_message.get;
6553: benutils.write(p_text => l_string);
6554: --
6555: end if;

Line 6552: l_string := fnd_message.get;

6548: if fnd_global.conc_request_id in ( 0,-1) then
6549: --
6550: fnd_message.set_name('BEN','BEN_92455_STRT_RUN_RESULTS');
6551: fnd_message.set_token('PARMA', fnd_date.date_to_chardate(g_max_end_date));
6552: l_string := fnd_message.get;
6553: benutils.write(p_text => l_string);
6554: --
6555: end if;
6556: g_msg_displayed := 1;

Line 6882: fnd_message.set_name('BEN', 'BEN_92103_NO_PRTT_RT_VAL');

6878: hr_utility.set_location('BEN_92103_NO_PRTT_RT_VAL',170);
6879: end if;
6880: close c_get_prtt_rt_val;
6881: --
6882: fnd_message.set_name('BEN', 'BEN_92103_NO_PRTT_RT_VAL');
6883: fnd_message.set_token('PROC',l_proc);
6884: fnd_message.set_token('PRTT_RT_VAL',to_char(p_prtt_rt_val_id));
6885: fnd_message.raise_error;
6886: --

Line 6883: fnd_message.set_token('PROC',l_proc);

6879: end if;
6880: close c_get_prtt_rt_val;
6881: --
6882: fnd_message.set_name('BEN', 'BEN_92103_NO_PRTT_RT_VAL');
6883: fnd_message.set_token('PROC',l_proc);
6884: fnd_message.set_token('PRTT_RT_VAL',to_char(p_prtt_rt_val_id));
6885: fnd_message.raise_error;
6886: --
6887: end if;

Line 6884: fnd_message.set_token('PRTT_RT_VAL',to_char(p_prtt_rt_val_id));

6880: close c_get_prtt_rt_val;
6881: --
6882: fnd_message.set_name('BEN', 'BEN_92103_NO_PRTT_RT_VAL');
6883: fnd_message.set_token('PROC',l_proc);
6884: fnd_message.set_token('PRTT_RT_VAL',to_char(p_prtt_rt_val_id));
6885: fnd_message.raise_error;
6886: --
6887: end if;
6888: close c_get_prtt_rt_val;

Line 6885: fnd_message.raise_error;

6881: --
6882: fnd_message.set_name('BEN', 'BEN_92103_NO_PRTT_RT_VAL');
6883: fnd_message.set_token('PROC',l_proc);
6884: fnd_message.set_token('PRTT_RT_VAL',to_char(p_prtt_rt_val_id));
6885: fnd_message.raise_error;
6886: --
6887: end if;
6888: close c_get_prtt_rt_val;
6889: --

Line 6909: fnd_message.set_name('BEN','BEN_91723_NO_ENRT_RT_ABR_FOUND');

6905: close get_abr_info;
6906: if g_debug then
6907: hr_utility.set_location('BEN_91723_NO_ENRT_RT_ABR_FOUND',30);
6908: end if;
6909: fnd_message.set_name('BEN','BEN_91723_NO_ENRT_RT_ABR_FOUND');
6910: fnd_message.set_token('PROC',l_proc);
6911: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
6912: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
6913: fnd_message.raise_error;

Line 6910: fnd_message.set_token('PROC',l_proc);

6906: if g_debug then
6907: hr_utility.set_location('BEN_91723_NO_ENRT_RT_ABR_FOUND',30);
6908: end if;
6909: fnd_message.set_name('BEN','BEN_91723_NO_ENRT_RT_ABR_FOUND');
6910: fnd_message.set_token('PROC',l_proc);
6911: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
6912: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
6913: fnd_message.raise_error;
6914: end if;

Line 6911: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));

6907: hr_utility.set_location('BEN_91723_NO_ENRT_RT_ABR_FOUND',30);
6908: end if;
6909: fnd_message.set_name('BEN','BEN_91723_NO_ENRT_RT_ABR_FOUND');
6910: fnd_message.set_token('PROC',l_proc);
6911: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
6912: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
6913: fnd_message.raise_error;
6914: end if;
6915: close get_abr_info;

Line 6912: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));

6908: end if;
6909: fnd_message.set_name('BEN','BEN_91723_NO_ENRT_RT_ABR_FOUND');
6910: fnd_message.set_token('PROC',l_proc);
6911: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
6912: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
6913: fnd_message.raise_error;
6914: end if;
6915: close get_abr_info;
6916: --

Line 6913: fnd_message.raise_error;

6909: fnd_message.set_name('BEN','BEN_91723_NO_ENRT_RT_ABR_FOUND');
6910: fnd_message.set_token('PROC',l_proc);
6911: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
6912: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
6913: fnd_message.raise_error;
6914: end if;
6915: close get_abr_info;
6916: --
6917: -- get the element type and input value based on entry value attached to

Line 7090: fnd_message.set_name('BEN', 'BEN_92105_NO_PRIOR_ENROLLMENT');

7086: if g_debug then
7087: hr_utility.set_location('BEN_92105_NO_PRIOR_ENROLLMENT',40);
7088: end if;
7089: close get_last_element_entry;
7090: fnd_message.set_name('BEN', 'BEN_92105_NO_PRIOR_ENROLLMENT');
7091: fnd_message.set_token('PROC',l_proc);
7092: fnd_message.set_token('ELEMENT_TYPE_ID',to_char(l_element_type_id));
7093: fnd_message.set_token('ASSGN_ID',to_char(l_assignment_id));
7094: fnd_message.set_token('PRTT_RT_VAL_ID',to_char(p_prtt_rt_val_id));

Line 7091: fnd_message.set_token('PROC',l_proc);

7087: hr_utility.set_location('BEN_92105_NO_PRIOR_ENROLLMENT',40);
7088: end if;
7089: close get_last_element_entry;
7090: fnd_message.set_name('BEN', 'BEN_92105_NO_PRIOR_ENROLLMENT');
7091: fnd_message.set_token('PROC',l_proc);
7092: fnd_message.set_token('ELEMENT_TYPE_ID',to_char(l_element_type_id));
7093: fnd_message.set_token('ASSGN_ID',to_char(l_assignment_id));
7094: fnd_message.set_token('PRTT_RT_VAL_ID',to_char(p_prtt_rt_val_id));
7095: fnd_message.raise_error;

Line 7092: fnd_message.set_token('ELEMENT_TYPE_ID',to_char(l_element_type_id));

7088: end if;
7089: close get_last_element_entry;
7090: fnd_message.set_name('BEN', 'BEN_92105_NO_PRIOR_ENROLLMENT');
7091: fnd_message.set_token('PROC',l_proc);
7092: fnd_message.set_token('ELEMENT_TYPE_ID',to_char(l_element_type_id));
7093: fnd_message.set_token('ASSGN_ID',to_char(l_assignment_id));
7094: fnd_message.set_token('PRTT_RT_VAL_ID',to_char(p_prtt_rt_val_id));
7095: fnd_message.raise_error;
7096: --

Line 7093: fnd_message.set_token('ASSGN_ID',to_char(l_assignment_id));

7089: close get_last_element_entry;
7090: fnd_message.set_name('BEN', 'BEN_92105_NO_PRIOR_ENROLLMENT');
7091: fnd_message.set_token('PROC',l_proc);
7092: fnd_message.set_token('ELEMENT_TYPE_ID',to_char(l_element_type_id));
7093: fnd_message.set_token('ASSGN_ID',to_char(l_assignment_id));
7094: fnd_message.set_token('PRTT_RT_VAL_ID',to_char(p_prtt_rt_val_id));
7095: fnd_message.raise_error;
7096: --
7097: end if;

Line 7094: fnd_message.set_token('PRTT_RT_VAL_ID',to_char(p_prtt_rt_val_id));

7090: fnd_message.set_name('BEN', 'BEN_92105_NO_PRIOR_ENROLLMENT');
7091: fnd_message.set_token('PROC',l_proc);
7092: fnd_message.set_token('ELEMENT_TYPE_ID',to_char(l_element_type_id));
7093: fnd_message.set_token('ASSGN_ID',to_char(l_assignment_id));
7094: fnd_message.set_token('PRTT_RT_VAL_ID',to_char(p_prtt_rt_val_id));
7095: fnd_message.raise_error;
7096: --
7097: end if;
7098: close get_last_element_entry;

Line 7095: fnd_message.raise_error;

7091: fnd_message.set_token('PROC',l_proc);
7092: fnd_message.set_token('ELEMENT_TYPE_ID',to_char(l_element_type_id));
7093: fnd_message.set_token('ASSGN_ID',to_char(l_assignment_id));
7094: fnd_message.set_token('PRTT_RT_VAL_ID',to_char(p_prtt_rt_val_id));
7095: fnd_message.raise_error;
7096: --
7097: end if;
7098: close get_last_element_entry;
7099:

Line 7268: l_encoded_message := fnd_message.get;

7264: when others then
7265: ben_on_line_lf_evt.get_ser_message(l_encoded_message,
7266: l_app_short_name,
7267: l_message_name);
7268: l_encoded_message := fnd_message.get;
7269: --
7270: if l_message_name like '%HR_6284_ELE_ENTRY_DT_ASG_DEL%' or
7271: l_message_name like '%HR_7187_DT_CANNOT_EXTEND_END%' then
7272: --

Line 7278: fnd_message.set_name(l_app_short_name,l_message_name);

7274: --
7275: null;
7276: else
7277: if l_app_short_name is not null then
7278: fnd_message.set_name(l_app_short_name,l_message_name);
7279: fnd_message.raise_error;
7280: else
7281: raise;
7282: end if;

Line 7279: fnd_message.raise_error;

7275: null;
7276: else
7277: if l_app_short_name is not null then
7278: fnd_message.set_name(l_app_short_name,l_message_name);
7279: fnd_message.raise_error;
7280: else
7281: raise;
7282: end if;
7283: end if;

Line 7437: fnd_message.set_name('BEN',l_message_name);

7433: p_person_id => p_person_id);
7434: --
7435: if fnd_global.conc_request_id in ( 0,-1) then
7436: --
7437: fnd_message.set_name('BEN',l_message_name);
7438: fnd_message.set_token('PARMA',l_element_name);
7439: fnd_message.set_token('PARMB',to_char(l_effective_date));
7440: l_string := fnd_message.get;
7441: benutils.write(p_text => l_string);

Line 7438: fnd_message.set_token('PARMA',l_element_name);

7434: --
7435: if fnd_global.conc_request_id in ( 0,-1) then
7436: --
7437: fnd_message.set_name('BEN',l_message_name);
7438: fnd_message.set_token('PARMA',l_element_name);
7439: fnd_message.set_token('PARMB',to_char(l_effective_date));
7440: l_string := fnd_message.get;
7441: benutils.write(p_text => l_string);
7442: --

Line 7439: fnd_message.set_token('PARMB',to_char(l_effective_date));

7435: if fnd_global.conc_request_id in ( 0,-1) then
7436: --
7437: fnd_message.set_name('BEN',l_message_name);
7438: fnd_message.set_token('PARMA',l_element_name);
7439: fnd_message.set_token('PARMB',to_char(l_effective_date));
7440: l_string := fnd_message.get;
7441: benutils.write(p_text => l_string);
7442: --
7443: end if;

Line 7440: l_string := fnd_message.get;

7436: --
7437: fnd_message.set_name('BEN',l_message_name);
7438: fnd_message.set_token('PARMA',l_element_name);
7439: fnd_message.set_token('PARMB',to_char(l_effective_date));
7440: l_string := fnd_message.get;
7441: benutils.write(p_text => l_string);
7442: --
7443: end if;
7444:

Line 7713: fnd_message.set_name('BEN', 'BEN_92106_PRTT_NO_ASGN');

7709:
7710: if g_debug then
7711: hr_utility.set_location('BEN_92106_PRTT_NO_ASGN',5);
7712: end if;
7713: fnd_message.set_name('BEN', 'BEN_92106_PRTT_NO_ASGN');
7714: fnd_message.set_token('PROC',l_proc);
7715: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
7716: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
7717: fnd_message.raise_error;

Line 7714: fnd_message.set_token('PROC',l_proc);

7710: if g_debug then
7711: hr_utility.set_location('BEN_92106_PRTT_NO_ASGN',5);
7712: end if;
7713: fnd_message.set_name('BEN', 'BEN_92106_PRTT_NO_ASGN');
7714: fnd_message.set_token('PROC',l_proc);
7715: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
7716: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
7717: fnd_message.raise_error;
7718:

Line 7715: fnd_message.set_token('PERSON_ID',to_char(p_person_id));

7711: hr_utility.set_location('BEN_92106_PRTT_NO_ASGN',5);
7712: end if;
7713: fnd_message.set_name('BEN', 'BEN_92106_PRTT_NO_ASGN');
7714: fnd_message.set_token('PROC',l_proc);
7715: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
7716: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
7717: fnd_message.raise_error;
7718:
7719: end if;

Line 7716: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));

7712: end if;
7713: fnd_message.set_name('BEN', 'BEN_92106_PRTT_NO_ASGN');
7714: fnd_message.set_token('PROC',l_proc);
7715: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
7716: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
7717: fnd_message.raise_error;
7718:
7719: end if;
7720: if g_debug then

Line 7717: fnd_message.raise_error;

7713: fnd_message.set_name('BEN', 'BEN_92106_PRTT_NO_ASGN');
7714: fnd_message.set_token('PROC',l_proc);
7715: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
7716: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
7717: fnd_message.raise_error;
7718:
7719: end if;
7720: if g_debug then
7721: hr_utility.set_location('l_assignment_id='||l_assignment_id,6);

Line 7747: fnd_message.set_name('BEN','BEN_91723_NO_ENRT_RT_ABR_FOUND');

7743: close get_abr_info;
7744: if g_debug then
7745: hr_utility.set_location('BEN_91723_NO_ENRT_RT_ABR_FOUND',40);
7746: end if;
7747: fnd_message.set_name('BEN','BEN_91723_NO_ENRT_RT_ABR_FOUND');
7748: fnd_message.set_token('PROC',l_proc);
7749: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
7750: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
7751: fnd_message.raise_error;

Line 7748: fnd_message.set_token('PROC',l_proc);

7744: if g_debug then
7745: hr_utility.set_location('BEN_91723_NO_ENRT_RT_ABR_FOUND',40);
7746: end if;
7747: fnd_message.set_name('BEN','BEN_91723_NO_ENRT_RT_ABR_FOUND');
7748: fnd_message.set_token('PROC',l_proc);
7749: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
7750: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
7751: fnd_message.raise_error;
7752: end if;

Line 7749: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));

7745: hr_utility.set_location('BEN_91723_NO_ENRT_RT_ABR_FOUND',40);
7746: end if;
7747: fnd_message.set_name('BEN','BEN_91723_NO_ENRT_RT_ABR_FOUND');
7748: fnd_message.set_token('PROC',l_proc);
7749: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
7750: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
7751: fnd_message.raise_error;
7752: end if;
7753: close get_abr_info;

Line 7750: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));

7746: end if;
7747: fnd_message.set_name('BEN','BEN_91723_NO_ENRT_RT_ABR_FOUND');
7748: fnd_message.set_token('PROC',l_proc);
7749: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
7750: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
7751: fnd_message.raise_error;
7752: end if;
7753: close get_abr_info;
7754: l_rt_end_dt := p_rt_end_date;

Line 7751: fnd_message.raise_error;

7747: fnd_message.set_name('BEN','BEN_91723_NO_ENRT_RT_ABR_FOUND');
7748: fnd_message.set_token('PROC',l_proc);
7749: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
7750: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
7751: fnd_message.raise_error;
7752: end if;
7753: close get_abr_info;
7754: l_rt_end_dt := p_rt_end_date;
7755:

Line 7898: fnd_message.set_name('BEN', 'BEN_92102_NO_ENTRY_CREATED');

7894: --
7895: if g_debug then
7896: hr_utility.set_location('BEN_92102_NO_ENTRY_CREATED',140);
7897: end if;
7898: fnd_message.set_name('BEN', 'BEN_92102_NO_ENTRY_CREATED');
7899: fnd_message.set_token('PROC',l_proc);
7900: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_element_entry_id));
7901: fnd_message.set_token('INPUT_VALUE_ID',to_char(p_input_value_id));
7902: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_rt_strt_date));

Line 7899: fnd_message.set_token('PROC',l_proc);

7895: if g_debug then
7896: hr_utility.set_location('BEN_92102_NO_ENTRY_CREATED',140);
7897: end if;
7898: fnd_message.set_name('BEN', 'BEN_92102_NO_ENTRY_CREATED');
7899: fnd_message.set_token('PROC',l_proc);
7900: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_element_entry_id));
7901: fnd_message.set_token('INPUT_VALUE_ID',to_char(p_input_value_id));
7902: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_rt_strt_date));
7903: fnd_message.raise_error;

Line 7900: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_element_entry_id));

7896: hr_utility.set_location('BEN_92102_NO_ENTRY_CREATED',140);
7897: end if;
7898: fnd_message.set_name('BEN', 'BEN_92102_NO_ENTRY_CREATED');
7899: fnd_message.set_token('PROC',l_proc);
7900: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_element_entry_id));
7901: fnd_message.set_token('INPUT_VALUE_ID',to_char(p_input_value_id));
7902: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_rt_strt_date));
7903: fnd_message.raise_error;
7904: --

Line 7901: fnd_message.set_token('INPUT_VALUE_ID',to_char(p_input_value_id));

7897: end if;
7898: fnd_message.set_name('BEN', 'BEN_92102_NO_ENTRY_CREATED');
7899: fnd_message.set_token('PROC',l_proc);
7900: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_element_entry_id));
7901: fnd_message.set_token('INPUT_VALUE_ID',to_char(p_input_value_id));
7902: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_rt_strt_date));
7903: fnd_message.raise_error;
7904: --
7905: end if;

Line 7902: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_rt_strt_date));

7898: fnd_message.set_name('BEN', 'BEN_92102_NO_ENTRY_CREATED');
7899: fnd_message.set_token('PROC',l_proc);
7900: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_element_entry_id));
7901: fnd_message.set_token('INPUT_VALUE_ID',to_char(p_input_value_id));
7902: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_rt_strt_date));
7903: fnd_message.raise_error;
7904: --
7905: end if;
7906: close get_created_entry_value;

Line 7903: fnd_message.raise_error;

7899: fnd_message.set_token('PROC',l_proc);
7900: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_element_entry_id));
7901: fnd_message.set_token('INPUT_VALUE_ID',to_char(p_input_value_id));
7902: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_rt_strt_date));
7903: fnd_message.raise_error;
7904: --
7905: end if;
7906: close get_created_entry_value;
7907: if g_debug then

Line 7923: fnd_message.set_name('BEN', 'BEN_92103_NO_PRTT_RT_VAL');

7919: hr_utility.set_location('BEN_92103_NO_PRTT_RT_VAL',170);
7920: end if;
7921: close c_get_prtt_rt_val;
7922: --
7923: fnd_message.set_name('BEN', 'BEN_92103_NO_PRTT_RT_VAL');
7924: fnd_message.set_token('PROC',l_proc);
7925: fnd_message.set_token('PRTT_RT_VAL',to_char(p_prtt_rt_val_id));
7926: fnd_message.raise_error;
7927: --

Line 7924: fnd_message.set_token('PROC',l_proc);

7920: end if;
7921: close c_get_prtt_rt_val;
7922: --
7923: fnd_message.set_name('BEN', 'BEN_92103_NO_PRTT_RT_VAL');
7924: fnd_message.set_token('PROC',l_proc);
7925: fnd_message.set_token('PRTT_RT_VAL',to_char(p_prtt_rt_val_id));
7926: fnd_message.raise_error;
7927: --
7928: end if;

Line 7925: fnd_message.set_token('PRTT_RT_VAL',to_char(p_prtt_rt_val_id));

7921: close c_get_prtt_rt_val;
7922: --
7923: fnd_message.set_name('BEN', 'BEN_92103_NO_PRTT_RT_VAL');
7924: fnd_message.set_token('PROC',l_proc);
7925: fnd_message.set_token('PRTT_RT_VAL',to_char(p_prtt_rt_val_id));
7926: fnd_message.raise_error;
7927: --
7928: end if;
7929: close c_get_prtt_rt_val;

Line 7926: fnd_message.raise_error;

7922: --
7923: fnd_message.set_name('BEN', 'BEN_92103_NO_PRTT_RT_VAL');
7924: fnd_message.set_token('PROC',l_proc);
7925: fnd_message.set_token('PRTT_RT_VAL',to_char(p_prtt_rt_val_id));
7926: fnd_message.raise_error;
7927: --
7928: end if;
7929: close c_get_prtt_rt_val;
7930: --

Line 8374: fnd_message.set_name('BEN', 'BEN_92103_NO_PRTT_RT_VAL');

8370: hr_utility.set_location('BEN_92103_NO_PRTT_RT_VAL',170);
8371: end if;
8372: close c_get_prtt_rt_val;
8373: --
8374: fnd_message.set_name('BEN', 'BEN_92103_NO_PRTT_RT_VAL');
8375: fnd_message.set_token('PROC',l_proc);
8376: fnd_message.set_token('PRTT_RT_VAL',to_char(p_prtt_rt_val_id));
8377: fnd_message.raise_error;
8378: --

Line 8375: fnd_message.set_token('PROC',l_proc);

8371: end if;
8372: close c_get_prtt_rt_val;
8373: --
8374: fnd_message.set_name('BEN', 'BEN_92103_NO_PRTT_RT_VAL');
8375: fnd_message.set_token('PROC',l_proc);
8376: fnd_message.set_token('PRTT_RT_VAL',to_char(p_prtt_rt_val_id));
8377: fnd_message.raise_error;
8378: --
8379: end if;

Line 8376: fnd_message.set_token('PRTT_RT_VAL',to_char(p_prtt_rt_val_id));

8372: close c_get_prtt_rt_val;
8373: --
8374: fnd_message.set_name('BEN', 'BEN_92103_NO_PRTT_RT_VAL');
8375: fnd_message.set_token('PROC',l_proc);
8376: fnd_message.set_token('PRTT_RT_VAL',to_char(p_prtt_rt_val_id));
8377: fnd_message.raise_error;
8378: --
8379: end if;
8380: close c_get_prtt_rt_val;

Line 8377: fnd_message.raise_error;

8373: --
8374: fnd_message.set_name('BEN', 'BEN_92103_NO_PRTT_RT_VAL');
8375: fnd_message.set_token('PROC',l_proc);
8376: fnd_message.set_token('PRTT_RT_VAL',to_char(p_prtt_rt_val_id));
8377: fnd_message.raise_error;
8378: --
8379: end if;
8380: close c_get_prtt_rt_val;
8381: --

Line 8446: fnd_message.set_name('BEN','BEN_91723_NO_ENRT_RT_ABR_FOUND');

8442: close get_abr_info;
8443: if g_debug then
8444: hr_utility.set_location('BEN_91723_NO_ENRT_RT_ABR_FOUND',40);
8445: end if;
8446: fnd_message.set_name('BEN','BEN_91723_NO_ENRT_RT_ABR_FOUND');
8447: fnd_message.set_token('PROC',l_proc);
8448: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
8449: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
8450: fnd_message.raise_error;

Line 8447: fnd_message.set_token('PROC',l_proc);

8443: if g_debug then
8444: hr_utility.set_location('BEN_91723_NO_ENRT_RT_ABR_FOUND',40);
8445: end if;
8446: fnd_message.set_name('BEN','BEN_91723_NO_ENRT_RT_ABR_FOUND');
8447: fnd_message.set_token('PROC',l_proc);
8448: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
8449: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
8450: fnd_message.raise_error;
8451: end if;

Line 8448: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));

8444: hr_utility.set_location('BEN_91723_NO_ENRT_RT_ABR_FOUND',40);
8445: end if;
8446: fnd_message.set_name('BEN','BEN_91723_NO_ENRT_RT_ABR_FOUND');
8447: fnd_message.set_token('PROC',l_proc);
8448: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
8449: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
8450: fnd_message.raise_error;
8451: end if;
8452: close get_abr_info;

Line 8449: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));

8445: end if;
8446: fnd_message.set_name('BEN','BEN_91723_NO_ENRT_RT_ABR_FOUND');
8447: fnd_message.set_token('PROC',l_proc);
8448: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
8449: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
8450: fnd_message.raise_error;
8451: end if;
8452: close get_abr_info;
8453:

Line 8450: fnd_message.raise_error;

8446: fnd_message.set_name('BEN','BEN_91723_NO_ENRT_RT_ABR_FOUND');
8447: fnd_message.set_token('PROC',l_proc);
8448: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
8449: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
8450: fnd_message.raise_error;
8451: end if;
8452: close get_abr_info;
8453:
8454: hr_utility.set_location('l_abr_rcrrg_cd '||l_abr_rcrrg_cd,40);

Line 8501: fnd_message.set_name('BEN','BEN_93455_ELE_ALREADY_ENDED');

8497: p_person_id => p_person_id);
8498: --
8499: if fnd_global.conc_request_id in ( 0,-1) then
8500: --
8501: fnd_message.set_name('BEN','BEN_93455_ELE_ALREADY_ENDED');
8502: fnd_message.set_token('PARMA',l_element_name);
8503: fnd_message.set_token('PARMB',to_char(l_effective_date));
8504: l_string := fnd_message.get;
8505: benutils.write(p_text => l_string);

Line 8502: fnd_message.set_token('PARMA',l_element_name);

8498: --
8499: if fnd_global.conc_request_id in ( 0,-1) then
8500: --
8501: fnd_message.set_name('BEN','BEN_93455_ELE_ALREADY_ENDED');
8502: fnd_message.set_token('PARMA',l_element_name);
8503: fnd_message.set_token('PARMB',to_char(l_effective_date));
8504: l_string := fnd_message.get;
8505: benutils.write(p_text => l_string);
8506: --

Line 8503: fnd_message.set_token('PARMB',to_char(l_effective_date));

8499: if fnd_global.conc_request_id in ( 0,-1) then
8500: --
8501: fnd_message.set_name('BEN','BEN_93455_ELE_ALREADY_ENDED');
8502: fnd_message.set_token('PARMA',l_element_name);
8503: fnd_message.set_token('PARMB',to_char(l_effective_date));
8504: l_string := fnd_message.get;
8505: benutils.write(p_text => l_string);
8506: --
8507: end if;

Line 8504: l_string := fnd_message.get;

8500: --
8501: fnd_message.set_name('BEN','BEN_93455_ELE_ALREADY_ENDED');
8502: fnd_message.set_token('PARMA',l_element_name);
8503: fnd_message.set_token('PARMB',to_char(l_effective_date));
8504: l_string := fnd_message.get;
8505: benutils.write(p_text => l_string);
8506: --
8507: end if;
8508: --

Line 8612: fnd_message.set_name('BEN','BEN_92456_END_RUN_RESULTS');

8608: p_person_id => p_person_id);
8609:
8610: if fnd_global.conc_request_id not in ( 0,-1) then
8611: --
8612: fnd_message.set_name('BEN','BEN_92456_END_RUN_RESULTS');
8613: fnd_message.set_token('PARMA',fnd_date.date_to_chardate(g_max_end_date));
8614: l_string := fnd_message.get;
8615: benutils.write(p_text => l_string);
8616: --

Line 8613: fnd_message.set_token('PARMA',fnd_date.date_to_chardate(g_max_end_date));

8609:
8610: if fnd_global.conc_request_id not in ( 0,-1) then
8611: --
8612: fnd_message.set_name('BEN','BEN_92456_END_RUN_RESULTS');
8613: fnd_message.set_token('PARMA',fnd_date.date_to_chardate(g_max_end_date));
8614: l_string := fnd_message.get;
8615: benutils.write(p_text => l_string);
8616: --
8617: end if;

Line 8614: l_string := fnd_message.get;

8610: if fnd_global.conc_request_id not in ( 0,-1) then
8611: --
8612: fnd_message.set_name('BEN','BEN_92456_END_RUN_RESULTS');
8613: fnd_message.set_token('PARMA',fnd_date.date_to_chardate(g_max_end_date));
8614: l_string := fnd_message.get;
8615: benutils.write(p_text => l_string);
8616: --
8617: end if;
8618: g_msg_displayed :=1;

Line 9109: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');

9105: when others then
9106: if g_debug then
9107: hr_utility.set_location('BEN_92311_FORMULA_VAL_PARAM',46);
9108: end if;
9109: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
9110: fnd_message.set_token('PROC',l_proc);
9111: fnd_message.set_token('FORMULA',l_prtl_mo_det_mthd_rl);
9112: fnd_message.set_token('PARAMETER',
9113: l_outputs(l_outputs.first).name);

Line 9110: fnd_message.set_token('PROC',l_proc);

9106: if g_debug then
9107: hr_utility.set_location('BEN_92311_FORMULA_VAL_PARAM',46);
9108: end if;
9109: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
9110: fnd_message.set_token('PROC',l_proc);
9111: fnd_message.set_token('FORMULA',l_prtl_mo_det_mthd_rl);
9112: fnd_message.set_token('PARAMETER',
9113: l_outputs(l_outputs.first).name);
9114: fnd_message.raise_error;

Line 9111: fnd_message.set_token('FORMULA',l_prtl_mo_det_mthd_rl);

9107: hr_utility.set_location('BEN_92311_FORMULA_VAL_PARAM',46);
9108: end if;
9109: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
9110: fnd_message.set_token('PROC',l_proc);
9111: fnd_message.set_token('FORMULA',l_prtl_mo_det_mthd_rl);
9112: fnd_message.set_token('PARAMETER',
9113: l_outputs(l_outputs.first).name);
9114: fnd_message.raise_error;
9115: --

Line 9112: fnd_message.set_token('PARAMETER',

9108: end if;
9109: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
9110: fnd_message.set_token('PROC',l_proc);
9111: fnd_message.set_token('FORMULA',l_prtl_mo_det_mthd_rl);
9112: fnd_message.set_token('PARAMETER',
9113: l_outputs(l_outputs.first).name);
9114: fnd_message.raise_error;
9115: --
9116: end;

Line 9114: fnd_message.raise_error;

9110: fnd_message.set_token('PROC',l_proc);
9111: fnd_message.set_token('FORMULA',l_prtl_mo_det_mthd_rl);
9112: fnd_message.set_token('PARAMETER',
9113: l_outputs(l_outputs.first).name);
9114: fnd_message.raise_error;
9115: --
9116: end;
9117: end if;
9118: --

Line 9223: fnd_message.set_name('BEN', 'BEN_92346_PAYROLL_NOT_DEFINED');

9219: close c_get_current_pp;
9220: if g_debug then
9221: hr_utility.set_location('BEN_92346_PAYROLL_NOT_DEFINED',48);
9222: end if;
9223: fnd_message.set_name('BEN', 'BEN_92346_PAYROLL_NOT_DEFINED');
9224: fnd_message.set_token('PROC',l_proc);
9225: fnd_message.raise_error;
9226: end if;
9227: --

Line 9224: fnd_message.set_token('PROC',l_proc);

9220: if g_debug then
9221: hr_utility.set_location('BEN_92346_PAYROLL_NOT_DEFINED',48);
9222: end if;
9223: fnd_message.set_name('BEN', 'BEN_92346_PAYROLL_NOT_DEFINED');
9224: fnd_message.set_token('PROC',l_proc);
9225: fnd_message.raise_error;
9226: end if;
9227: --
9228: close c_get_current_pp;

Line 9225: fnd_message.raise_error;

9221: hr_utility.set_location('BEN_92346_PAYROLL_NOT_DEFINED',48);
9222: end if;
9223: fnd_message.set_name('BEN', 'BEN_92346_PAYROLL_NOT_DEFINED');
9224: fnd_message.set_token('PROC',l_proc);
9225: fnd_message.raise_error;
9226: end if;
9227: --
9228: close c_get_current_pp;
9229: --

Line 9263: fnd_message.set_name('BEN', 'BEN_92939_NO_PRORATION');

9259: (p_application_short_name => 'BEN',
9260: p_message_name => 'BEN_92939_NO_PRORATION',
9261: p_person_id => p_person_id);
9262: --
9263: fnd_message.set_name('BEN', 'BEN_92939_NO_PRORATION');
9264: if fnd_global.conc_request_id <> -1 then
9265: benutils.write(fnd_message.get);
9266: end if;
9267: --

Line 9265: benutils.write(fnd_message.get);

9261: p_person_id => p_person_id);
9262: --
9263: fnd_message.set_name('BEN', 'BEN_92939_NO_PRORATION');
9264: if fnd_global.conc_request_id <> -1 then
9265: benutils.write(fnd_message.get);
9266: end if;
9267: --
9268: l_immediate_end := true;
9269: end if;

Line 9287: fnd_message.set_name('BEN', 'BEN_92346_PAYROLL_NOT_DEFINED');

9283: close c_get_current_pp;
9284: if g_debug then
9285: hr_utility.set_location('BEN_92346_PAYROLL_NOT_DEFINED',48);
9286: end if;
9287: fnd_message.set_name('BEN', 'BEN_92346_PAYROLL_NOT_DEFINED');
9288: fnd_message.set_token('PROC',l_proc);
9289: fnd_message.raise_error;
9290: end if;
9291: --

Line 9288: fnd_message.set_token('PROC',l_proc);

9284: if g_debug then
9285: hr_utility.set_location('BEN_92346_PAYROLL_NOT_DEFINED',48);
9286: end if;
9287: fnd_message.set_name('BEN', 'BEN_92346_PAYROLL_NOT_DEFINED');
9288: fnd_message.set_token('PROC',l_proc);
9289: fnd_message.raise_error;
9290: end if;
9291: --
9292: close c_get_current_pp;

Line 9289: fnd_message.raise_error;

9285: hr_utility.set_location('BEN_92346_PAYROLL_NOT_DEFINED',48);
9286: end if;
9287: fnd_message.set_name('BEN', 'BEN_92346_PAYROLL_NOT_DEFINED');
9288: fnd_message.set_token('PROC',l_proc);
9289: fnd_message.raise_error;
9290: end if;
9291: --
9292: close c_get_current_pp;
9293: end if; -- l_remainder > 0

Line 9312: fnd_message.set_name('BEN', 'BEN_92346_PAYROLL_NOT_DEFINED');

9308: close c_pps_prev_month;
9309: if g_debug then
9310: hr_utility.set_location('BEN_92346_PAYROLL_NOT_DEFINED',50);
9311: end if;
9312: fnd_message.set_name('BEN', 'BEN_92346_PAYROLL_NOT_DEFINED');
9313: fnd_message.set_token('PROC',l_proc);
9314: fnd_message.raise_error;
9315: end if;
9316: hr_elements.check_element_freq(

Line 9313: fnd_message.set_token('PROC',l_proc);

9309: if g_debug then
9310: hr_utility.set_location('BEN_92346_PAYROLL_NOT_DEFINED',50);
9311: end if;
9312: fnd_message.set_name('BEN', 'BEN_92346_PAYROLL_NOT_DEFINED');
9313: fnd_message.set_token('PROC',l_proc);
9314: fnd_message.raise_error;
9315: end if;
9316: hr_elements.check_element_freq(
9317: p_payroll_id =>l_payroll_id,

Line 9314: fnd_message.raise_error;

9310: hr_utility.set_location('BEN_92346_PAYROLL_NOT_DEFINED',50);
9311: end if;
9312: fnd_message.set_name('BEN', 'BEN_92346_PAYROLL_NOT_DEFINED');
9313: fnd_message.set_token('PROC',l_proc);
9314: fnd_message.raise_error;
9315: end if;
9316: hr_elements.check_element_freq(
9317: p_payroll_id =>l_payroll_id,
9318: p_bg_id =>p_business_group_id,

Line 9804: fnd_message.raise_error;

9800: if l_element_link_id is null then
9801: --
9802: -- error message already set on stack.
9803: --
9804: fnd_message.raise_error;
9805: end if;
9806: hr_utility.set_location( 'entering', 30.2);
9807: py_element_entry_api.create_element_entry
9808: (p_validate =>p_validate

Line 9870: fnd_message.set_name('BEN', 'BEN_92102_NO_ENTRY_CREATED');

9866: --
9867: if g_debug then
9868: hr_utility.set_location('BEN_92102_NO_ENTRY_CREATED',140);
9869: end if;
9870: fnd_message.set_name('BEN', 'BEN_92102_NO_ENTRY_CREATED');
9871: fnd_message.set_token('PROC','Create_reimburse_element');
9872: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_element_link_id));
9873: fnd_message.set_token('INPUT_VALUE_ID',to_char(l_input_value_id));
9874: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));

Line 9871: fnd_message.set_token('PROC','Create_reimburse_element');

9867: if g_debug then
9868: hr_utility.set_location('BEN_92102_NO_ENTRY_CREATED',140);
9869: end if;
9870: fnd_message.set_name('BEN', 'BEN_92102_NO_ENTRY_CREATED');
9871: fnd_message.set_token('PROC','Create_reimburse_element');
9872: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_element_link_id));
9873: fnd_message.set_token('INPUT_VALUE_ID',to_char(l_input_value_id));
9874: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
9875: fnd_message.raise_error;

Line 9872: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_element_link_id));

9868: hr_utility.set_location('BEN_92102_NO_ENTRY_CREATED',140);
9869: end if;
9870: fnd_message.set_name('BEN', 'BEN_92102_NO_ENTRY_CREATED');
9871: fnd_message.set_token('PROC','Create_reimburse_element');
9872: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_element_link_id));
9873: fnd_message.set_token('INPUT_VALUE_ID',to_char(l_input_value_id));
9874: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
9875: fnd_message.raise_error;
9876: else

Line 9873: fnd_message.set_token('INPUT_VALUE_ID',to_char(l_input_value_id));

9869: end if;
9870: fnd_message.set_name('BEN', 'BEN_92102_NO_ENTRY_CREATED');
9871: fnd_message.set_token('PROC','Create_reimburse_element');
9872: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_element_link_id));
9873: fnd_message.set_token('INPUT_VALUE_ID',to_char(l_input_value_id));
9874: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
9875: fnd_message.raise_error;
9876: else
9877: --

Line 9874: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));

9870: fnd_message.set_name('BEN', 'BEN_92102_NO_ENTRY_CREATED');
9871: fnd_message.set_token('PROC','Create_reimburse_element');
9872: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_element_link_id));
9873: fnd_message.set_token('INPUT_VALUE_ID',to_char(l_input_value_id));
9874: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
9875: fnd_message.raise_error;
9876: else
9877: --
9878: ben_prtt_rmt_aprvd_pymt_api.update_prtt_rmt_aprvd_pymt

Line 9875: fnd_message.raise_error;

9871: fnd_message.set_token('PROC','Create_reimburse_element');
9872: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_element_link_id));
9873: fnd_message.set_token('INPUT_VALUE_ID',to_char(l_input_value_id));
9874: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
9875: fnd_message.raise_error;
9876: else
9877: --
9878: ben_prtt_rmt_aprvd_pymt_api.update_prtt_rmt_aprvd_pymt
9879: (p_prtt_rmt_aprvd_fr_pymt_id => p_prtt_rmt_aprvd_fr_pymt_id,

Line 9965: fnd_message.set_name ('BEN','BEN_93341_PRCCSD_IN_PAYROLL');

9961: p_effective_date), 1,1) ;
9962: --
9963: if l_processed_flag = 'Y' then
9964: --
9965: fnd_message.set_name ('BEN','BEN_93341_PRCCSD_IN_PAYROLL');
9966: fnd_message.raise_error;
9967: --
9968: end if;
9969: --

Line 9966: fnd_message.raise_error;

9962: --
9963: if l_processed_flag = 'Y' then
9964: --
9965: fnd_message.set_name ('BEN','BEN_93341_PRCCSD_IN_PAYROLL');
9966: fnd_message.raise_error;
9967: --
9968: end if;
9969: --
9970: open c_element_entry (l_ele_rec.element_entry_id);