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 1579: fnd_message.set_name('BEN', 'BEN_92458_NO_ASG_PAYROLL');

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

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

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

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

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

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

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

Line 1583: fnd_message.raise_error;

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

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

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

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

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

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

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

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

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

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

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

Line 1593: fnd_message.raise_error;

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

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

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

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

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

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

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

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

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

Line 1628: fnd_message.raise_error;

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

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

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

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

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

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

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

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

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

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

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

Line 1638: fnd_message.raise_error;

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

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

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

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

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

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

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

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

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

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

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

Line 1658: fnd_message.raise_error;

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

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

1856: when others then
1857: if g_debug then
1858: hr_utility.set_location('BEN_92311_FORMULA_VAL_PARAM',5);
1859: end if;
1860: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
1861: fnd_message.set_token('PROC',l_proc);
1862: fnd_message.set_token('FORMULA',p_prtl_mo_det_mthd_rl);
1863: fnd_message.set_token('PARAMETER',l_outputs(l_outputs.first).name);
1864: fnd_message.raise_error;

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

1857: if g_debug then
1858: hr_utility.set_location('BEN_92311_FORMULA_VAL_PARAM',5);
1859: end if;
1860: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
1861: fnd_message.set_token('PROC',l_proc);
1862: fnd_message.set_token('FORMULA',p_prtl_mo_det_mthd_rl);
1863: fnd_message.set_token('PARAMETER',l_outputs(l_outputs.first).name);
1864: fnd_message.raise_error;
1865: --

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

1858: hr_utility.set_location('BEN_92311_FORMULA_VAL_PARAM',5);
1859: end if;
1860: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
1861: fnd_message.set_token('PROC',l_proc);
1862: fnd_message.set_token('FORMULA',p_prtl_mo_det_mthd_rl);
1863: fnd_message.set_token('PARAMETER',l_outputs(l_outputs.first).name);
1864: fnd_message.raise_error;
1865: --
1866: end;

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

1859: end if;
1860: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
1861: fnd_message.set_token('PROC',l_proc);
1862: fnd_message.set_token('FORMULA',p_prtl_mo_det_mthd_rl);
1863: fnd_message.set_token('PARAMETER',l_outputs(l_outputs.first).name);
1864: fnd_message.raise_error;
1865: --
1866: end;
1867: end if;

Line 1864: fnd_message.raise_error;

1860: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
1861: fnd_message.set_token('PROC',l_proc);
1862: fnd_message.set_token('FORMULA',p_prtl_mo_det_mthd_rl);
1863: fnd_message.set_token('PARAMETER',l_outputs(l_outputs.first).name);
1864: fnd_message.raise_error;
1865: --
1866: end;
1867: end if;
1868: --

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

1969: --
1970: if g_debug then
1971: hr_utility.set_location('BEN_92343_NO_PCT_VAL_OR_RL',5);
1972: end if;
1973: fnd_message.set_name('BEN', 'BEN_92343_NO_PCT_VAL_OR_RL');
1974: fnd_message.set_token('PROC',l_proc);
1975: fnd_message.set_token('PRTL_MO_RT_PRTN_VAL_ID',
1976: to_char(p_rec.prtl_mo_rt_prtn_val_id));
1977: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));

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

1970: if g_debug then
1971: hr_utility.set_location('BEN_92343_NO_PCT_VAL_OR_RL',5);
1972: end if;
1973: fnd_message.set_name('BEN', 'BEN_92343_NO_PCT_VAL_OR_RL');
1974: fnd_message.set_token('PROC',l_proc);
1975: fnd_message.set_token('PRTL_MO_RT_PRTN_VAL_ID',
1976: to_char(p_rec.prtl_mo_rt_prtn_val_id));
1977: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
1978: fnd_message.set_token('ACTL_PREM_ID',to_char(p_actl_prem_id));

Line 1975: fnd_message.set_token('PRTL_MO_RT_PRTN_VAL_ID',

1971: hr_utility.set_location('BEN_92343_NO_PCT_VAL_OR_RL',5);
1972: end if;
1973: fnd_message.set_name('BEN', 'BEN_92343_NO_PCT_VAL_OR_RL');
1974: fnd_message.set_token('PROC',l_proc);
1975: fnd_message.set_token('PRTL_MO_RT_PRTN_VAL_ID',
1976: to_char(p_rec.prtl_mo_rt_prtn_val_id));
1977: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
1978: fnd_message.set_token('ACTL_PREM_ID',to_char(p_actl_prem_id));
1979: fnd_message.set_token('CVG_AMT_CALC_MTHD_ID',

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

1973: fnd_message.set_name('BEN', 'BEN_92343_NO_PCT_VAL_OR_RL');
1974: fnd_message.set_token('PROC',l_proc);
1975: fnd_message.set_token('PRTL_MO_RT_PRTN_VAL_ID',
1976: to_char(p_rec.prtl_mo_rt_prtn_val_id));
1977: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
1978: fnd_message.set_token('ACTL_PREM_ID',to_char(p_actl_prem_id));
1979: fnd_message.set_token('CVG_AMT_CALC_MTHD_ID',
1980: to_char(p_cvg_amt_calc_mthd_id));
1981: fnd_message.raise_error;

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

1974: fnd_message.set_token('PROC',l_proc);
1975: fnd_message.set_token('PRTL_MO_RT_PRTN_VAL_ID',
1976: to_char(p_rec.prtl_mo_rt_prtn_val_id));
1977: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
1978: fnd_message.set_token('ACTL_PREM_ID',to_char(p_actl_prem_id));
1979: fnd_message.set_token('CVG_AMT_CALC_MTHD_ID',
1980: to_char(p_cvg_amt_calc_mthd_id));
1981: fnd_message.raise_error;
1982: else

Line 1979: fnd_message.set_token('CVG_AMT_CALC_MTHD_ID',

1975: fnd_message.set_token('PRTL_MO_RT_PRTN_VAL_ID',
1976: to_char(p_rec.prtl_mo_rt_prtn_val_id));
1977: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
1978: fnd_message.set_token('ACTL_PREM_ID',to_char(p_actl_prem_id));
1979: fnd_message.set_token('CVG_AMT_CALC_MTHD_ID',
1980: to_char(p_cvg_amt_calc_mthd_id));
1981: fnd_message.raise_error;
1982: else
1983: --

Line 1981: fnd_message.raise_error;

1977: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
1978: fnd_message.set_token('ACTL_PREM_ID',to_char(p_actl_prem_id));
1979: fnd_message.set_token('CVG_AMT_CALC_MTHD_ID',
1980: to_char(p_cvg_amt_calc_mthd_id));
1981: fnd_message.raise_error;
1982: else
1983: --
1984: -- Get the choice id. 14076301.
1985: --

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

2017: when others then
2018: if g_debug then
2019: hr_utility.set_location('BEN_92311_FORMULA_VAL_PARAM',15);
2020: end if;
2021: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
2022: fnd_message.set_token('PROC',l_proc);
2023: fnd_message.set_token('FORMULA',p_rec.prtl_mo_prortn_rl);
2024: fnd_message.set_token('PARAMETER',
2025: l_outputs(l_outputs.first).name);

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

2018: if g_debug then
2019: hr_utility.set_location('BEN_92311_FORMULA_VAL_PARAM',15);
2020: end if;
2021: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
2022: fnd_message.set_token('PROC',l_proc);
2023: fnd_message.set_token('FORMULA',p_rec.prtl_mo_prortn_rl);
2024: fnd_message.set_token('PARAMETER',
2025: l_outputs(l_outputs.first).name);
2026: fnd_message.raise_error;

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

2019: hr_utility.set_location('BEN_92311_FORMULA_VAL_PARAM',15);
2020: end if;
2021: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
2022: fnd_message.set_token('PROC',l_proc);
2023: fnd_message.set_token('FORMULA',p_rec.prtl_mo_prortn_rl);
2024: fnd_message.set_token('PARAMETER',
2025: l_outputs(l_outputs.first).name);
2026: fnd_message.raise_error;
2027: --

Line 2024: fnd_message.set_token('PARAMETER',

2020: end if;
2021: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
2022: fnd_message.set_token('PROC',l_proc);
2023: fnd_message.set_token('FORMULA',p_rec.prtl_mo_prortn_rl);
2024: fnd_message.set_token('PARAMETER',
2025: l_outputs(l_outputs.first).name);
2026: fnd_message.raise_error;
2027: --
2028: end;

Line 2026: fnd_message.raise_error;

2022: fnd_message.set_token('PROC',l_proc);
2023: fnd_message.set_token('FORMULA',p_rec.prtl_mo_prortn_rl);
2024: fnd_message.set_token('PARAMETER',
2025: l_outputs(l_outputs.first).name);
2026: fnd_message.raise_error;
2027: --
2028: end;
2029: --
2030: end if;

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

2107: --
2108: if g_debug then
2109: hr_utility.set_location('BEN_92348_UNKNOWN_PRTN_DET_CD',15);
2110: end if;
2111: fnd_message.set_name('BEN', 'BEN_92348_UNKNOWN_PRTN_DET_CD');
2112: fnd_message.set_token('PROC',l_proc);
2113: fnd_message.set_token('PRTL_MO_DET_MTHD_CD',p_prtl_mo_det_mthd_cd);
2114: fnd_message.raise_error;
2115: end if;

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

2108: if g_debug then
2109: hr_utility.set_location('BEN_92348_UNKNOWN_PRTN_DET_CD',15);
2110: end if;
2111: fnd_message.set_name('BEN', 'BEN_92348_UNKNOWN_PRTN_DET_CD');
2112: fnd_message.set_token('PROC',l_proc);
2113: fnd_message.set_token('PRTL_MO_DET_MTHD_CD',p_prtl_mo_det_mthd_cd);
2114: fnd_message.raise_error;
2115: end if;
2116: --

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

2109: hr_utility.set_location('BEN_92348_UNKNOWN_PRTN_DET_CD',15);
2110: end if;
2111: fnd_message.set_name('BEN', 'BEN_92348_UNKNOWN_PRTN_DET_CD');
2112: fnd_message.set_token('PROC',l_proc);
2113: fnd_message.set_token('PRTL_MO_DET_MTHD_CD',p_prtl_mo_det_mthd_cd);
2114: fnd_message.raise_error;
2115: end if;
2116: --
2117: if (p_rndg_cd is not null or

Line 2114: fnd_message.raise_error;

2110: end if;
2111: fnd_message.set_name('BEN', 'BEN_92348_UNKNOWN_PRTN_DET_CD');
2112: fnd_message.set_token('PROC',l_proc);
2113: fnd_message.set_token('PRTL_MO_DET_MTHD_CD',p_prtl_mo_det_mthd_cd);
2114: fnd_message.raise_error;
2115: end if;
2116: --
2117: if (p_rndg_cd is not null or
2118: p_rndg_rl is not null) and

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

2346: if c_getasgdets%notfound then
2347: --
2348: close c_getasgdets;
2349: --
2350: fnd_message.set_name('BEN', 'BEN_93289_ASG_ABR_NOT_FOUND');
2351: fnd_message.set_token('ACTY_BASE_RT_NAME',g_acty_base_rt_name);
2352: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
2353: if g_debug then
2354: hr_utility.set_location('ASG: BEN_93289_ASG_ABR_NOT_FOUND',5); -- 2105656

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

2347: --
2348: close c_getasgdets;
2349: --
2350: fnd_message.set_name('BEN', 'BEN_93289_ASG_ABR_NOT_FOUND');
2351: fnd_message.set_token('ACTY_BASE_RT_NAME',g_acty_base_rt_name);
2352: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
2353: if g_debug then
2354: hr_utility.set_location('ASG: BEN_93289_ASG_ABR_NOT_FOUND',5); -- 2105656
2355: end if;

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

2348: close c_getasgdets;
2349: --
2350: fnd_message.set_name('BEN', 'BEN_93289_ASG_ABR_NOT_FOUND');
2351: fnd_message.set_token('ACTY_BASE_RT_NAME',g_acty_base_rt_name);
2352: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
2353: if g_debug then
2354: hr_utility.set_location('ASG: BEN_93289_ASG_ABR_NOT_FOUND',5); -- 2105656
2355: end if;
2356: fnd_message.raise_error;

Line 2356: fnd_message.raise_error;

2352: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
2353: if g_debug then
2354: hr_utility.set_location('ASG: BEN_93289_ASG_ABR_NOT_FOUND',5); -- 2105656
2355: end if;
2356: fnd_message.raise_error;
2357: --
2358: end if;
2359: if g_debug then
2360: hr_utility.set_location('c_getasgdets is not null',999);

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

2460: end loop;
2461: --
2462: if l_link_count = 0 then
2463: --
2464: fnd_message.set_name('BEN', 'BEN_92344_NO_ELEMENT_LINK');
2465: fnd_message.set_token('PROC',l_proc);
2466: fnd_message.set_token('ASSIGNMENT_ID',to_char(p_assignment_id));
2467: fnd_message.set_token('ELEMENT_TYPE_ID',to_char(p_element_type_id));
2468: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));

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

2461: --
2462: if l_link_count = 0 then
2463: --
2464: fnd_message.set_name('BEN', 'BEN_92344_NO_ELEMENT_LINK');
2465: fnd_message.set_token('PROC',l_proc);
2466: fnd_message.set_token('ASSIGNMENT_ID',to_char(p_assignment_id));
2467: fnd_message.set_token('ELEMENT_TYPE_ID',to_char(p_element_type_id));
2468: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
2469: if g_debug then

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

2462: if l_link_count = 0 then
2463: --
2464: fnd_message.set_name('BEN', 'BEN_92344_NO_ELEMENT_LINK');
2465: fnd_message.set_token('PROC',l_proc);
2466: fnd_message.set_token('ASSIGNMENT_ID',to_char(p_assignment_id));
2467: fnd_message.set_token('ELEMENT_TYPE_ID',to_char(p_element_type_id));
2468: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
2469: if g_debug then
2470: hr_utility.set_location('ELK: BEN_92344_NO_ELEMENT_LINK',5);

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

2463: --
2464: fnd_message.set_name('BEN', 'BEN_92344_NO_ELEMENT_LINK');
2465: fnd_message.set_token('PROC',l_proc);
2466: fnd_message.set_token('ASSIGNMENT_ID',to_char(p_assignment_id));
2467: fnd_message.set_token('ELEMENT_TYPE_ID',to_char(p_element_type_id));
2468: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
2469: if g_debug then
2470: hr_utility.set_location('ELK: BEN_92344_NO_ELEMENT_LINK',5);
2471: end if;

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

2464: fnd_message.set_name('BEN', 'BEN_92344_NO_ELEMENT_LINK');
2465: fnd_message.set_token('PROC',l_proc);
2466: fnd_message.set_token('ASSIGNMENT_ID',to_char(p_assignment_id));
2467: fnd_message.set_token('ELEMENT_TYPE_ID',to_char(p_element_type_id));
2468: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
2469: if g_debug then
2470: hr_utility.set_location('ELK: BEN_92344_NO_ELEMENT_LINK',5);
2471: end if;
2472: --

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

2471: end if;
2472: --
2473: elsif l_elk_count = 0 then -- bug 2105656
2474: --
2475: fnd_message.set_name('BEN', 'BEN_93288_ASG_ELEM_LNK_INELIG');
2476: fnd_message.set_token('ASSIGNMENT_ID',to_char(p_assignment_id));
2477: fnd_message.set_token('ELEMENT_TYPE_ID',to_char(p_element_type_id));
2478: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
2479: if g_debug then

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

2472: --
2473: elsif l_elk_count = 0 then -- bug 2105656
2474: --
2475: fnd_message.set_name('BEN', 'BEN_93288_ASG_ELEM_LNK_INELIG');
2476: fnd_message.set_token('ASSIGNMENT_ID',to_char(p_assignment_id));
2477: fnd_message.set_token('ELEMENT_TYPE_ID',to_char(p_element_type_id));
2478: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
2479: if g_debug then
2480: hr_utility.set_location('ELK: BEN_93288_ASG_ELEM_LNK_INELIG',6);

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

2473: elsif l_elk_count = 0 then -- bug 2105656
2474: --
2475: fnd_message.set_name('BEN', 'BEN_93288_ASG_ELEM_LNK_INELIG');
2476: fnd_message.set_token('ASSIGNMENT_ID',to_char(p_assignment_id));
2477: fnd_message.set_token('ELEMENT_TYPE_ID',to_char(p_element_type_id));
2478: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
2479: if g_debug then
2480: hr_utility.set_location('ELK: BEN_93288_ASG_ELEM_LNK_INELIG',6);
2481: end if;

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

2474: --
2475: fnd_message.set_name('BEN', 'BEN_93288_ASG_ELEM_LNK_INELIG');
2476: fnd_message.set_token('ASSIGNMENT_ID',to_char(p_assignment_id));
2477: fnd_message.set_token('ELEMENT_TYPE_ID',to_char(p_element_type_id));
2478: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
2479: if g_debug then
2480: hr_utility.set_location('ELK: BEN_93288_ASG_ELEM_LNK_INELIG',6);
2481: end if;
2482: --

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

2615: if c_chk_rt%found then
2616: --
2617: close c_future_ee;
2618: close c_chk_rt;
2619: fnd_message.set_name('BEN','BEN_93448_FUTURE_BEN_ENTRY');
2620: fnd_message.set_token('P_RATE',l_rt_rec.rt_name);
2621: fnd_message.set_token('P_DATE',to_char(l_future_ee_rec.effective_start_date));
2622: fnd_message.raise_error;
2623: --

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

2616: --
2617: close c_future_ee;
2618: close c_chk_rt;
2619: fnd_message.set_name('BEN','BEN_93448_FUTURE_BEN_ENTRY');
2620: fnd_message.set_token('P_RATE',l_rt_rec.rt_name);
2621: fnd_message.set_token('P_DATE',to_char(l_future_ee_rec.effective_start_date));
2622: fnd_message.raise_error;
2623: --
2624: end if;

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

2617: close c_future_ee;
2618: close c_chk_rt;
2619: fnd_message.set_name('BEN','BEN_93448_FUTURE_BEN_ENTRY');
2620: fnd_message.set_token('P_RATE',l_rt_rec.rt_name);
2621: fnd_message.set_token('P_DATE',to_char(l_future_ee_rec.effective_start_date));
2622: fnd_message.raise_error;
2623: --
2624: end if;
2625: close c_chk_rt;

Line 2622: fnd_message.raise_error;

2618: close c_chk_rt;
2619: fnd_message.set_name('BEN','BEN_93448_FUTURE_BEN_ENTRY');
2620: fnd_message.set_token('P_RATE',l_rt_rec.rt_name);
2621: fnd_message.set_token('P_DATE',to_char(l_future_ee_rec.effective_start_date));
2622: fnd_message.raise_error;
2623: --
2624: end if;
2625: close c_chk_rt;
2626: py_element_entry_api.delete_element_entry

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

2638: -- User created entry. Throw error
2639: --
2640: if p_multiple_entries_flag ='N' then
2641: close c_future_ee;
2642: fnd_message.set_name('BEN','BEN_93447_FUTURE_USER_ENTRY');
2643: fnd_message.set_token('P_DATE',to_char(l_future_ee_rec.effective_start_date));
2644: fnd_message.set_token('P_ELEMENT',l_future_ee_rec.element_name);
2645: fnd_message.raise_error;
2646: end if;

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

2639: --
2640: if p_multiple_entries_flag ='N' then
2641: close c_future_ee;
2642: fnd_message.set_name('BEN','BEN_93447_FUTURE_USER_ENTRY');
2643: fnd_message.set_token('P_DATE',to_char(l_future_ee_rec.effective_start_date));
2644: fnd_message.set_token('P_ELEMENT',l_future_ee_rec.element_name);
2645: fnd_message.raise_error;
2646: end if;
2647: end if;

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

2640: if p_multiple_entries_flag ='N' then
2641: close c_future_ee;
2642: fnd_message.set_name('BEN','BEN_93447_FUTURE_USER_ENTRY');
2643: fnd_message.set_token('P_DATE',to_char(l_future_ee_rec.effective_start_date));
2644: fnd_message.set_token('P_ELEMENT',l_future_ee_rec.element_name);
2645: fnd_message.raise_error;
2646: end if;
2647: end if;
2648:

Line 2645: fnd_message.raise_error;

2641: close c_future_ee;
2642: fnd_message.set_name('BEN','BEN_93447_FUTURE_USER_ENTRY');
2643: fnd_message.set_token('P_DATE',to_char(l_future_ee_rec.effective_start_date));
2644: fnd_message.set_token('P_ELEMENT',l_future_ee_rec.element_name);
2645: fnd_message.raise_error;
2646: end if;
2647: end if;
2648:
2649: end loop;

Line 3786: l_encoded_message := fnd_message.get;

3782: when others then
3783: ben_on_line_lf_evt.get_ser_message(l_encoded_message,
3784: l_app_short_name,
3785: l_message_name);
3786: l_encoded_message := fnd_message.get;
3787: --
3788: if l_message_name like '%HR_6284_ELE_ENTRY_DT_ASG_DEL%' or
3789: l_message_name like '%HR_7187_DT_CANNOT_EXTEND_END%' then
3790: -- assignment is not eligible for link beyond this date.

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

3792: --
3793: null;
3794: else
3795: if l_app_short_name is not null then
3796: fnd_message.set_name(l_app_short_name,l_message_name);
3797: fnd_message.raise_error;
3798: else
3799: raise;
3800: end if;

Line 3797: fnd_message.raise_error;

3793: null;
3794: else
3795: if l_app_short_name is not null then
3796: fnd_message.set_name(l_app_short_name,l_message_name);
3797: fnd_message.raise_error;
3798: else
3799: raise;
3800: end if;
3801: end if;

Line 4047: l_encoded_message := fnd_message.get;

4043: when others then
4044: ben_on_line_lf_evt.get_ser_message(l_encoded_message,
4045: l_app_short_name,
4046: l_message_name);
4047: l_encoded_message := fnd_message.get;
4048: --
4049: if l_message_name like '%HR_6284_ELE_ENTRY_DT_ASG_DEL%' or
4050: l_message_name like '%HR_7187_DT_CANNOT_EXTEND_END%' then
4051: -- assignment is not eligible for link beyond this date.

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

4053: --
4054: null;
4055: else
4056: if l_app_short_name is not null then
4057: fnd_message.set_name(l_app_short_name,l_message_name);
4058: fnd_message.raise_error;
4059: else
4060: raise;
4061: end if;

Line 4058: fnd_message.raise_error;

4054: null;
4055: else
4056: if l_app_short_name is not null then
4057: fnd_message.set_name(l_app_short_name,l_message_name);
4058: fnd_message.raise_error;
4059: else
4060: raise;
4061: end if;
4062: end if;

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

4110: hr_utility.set_location('BEN_92103_NO_PRTT_RT_VAL',170);
4111: end if;
4112: close c_get_prtt_rt_val;
4113: --
4114: fnd_message.set_name('BEN', 'BEN_92103_NO_PRTT_RT_VAL');
4115: fnd_message.set_token('PROC',l_proc);
4116: fnd_message.set_token('PRTT_RT_VAL',to_char(p_prtt_rt_val_id));
4117: fnd_message.raise_error;
4118: --

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

4111: end if;
4112: close c_get_prtt_rt_val;
4113: --
4114: fnd_message.set_name('BEN', 'BEN_92103_NO_PRTT_RT_VAL');
4115: fnd_message.set_token('PROC',l_proc);
4116: fnd_message.set_token('PRTT_RT_VAL',to_char(p_prtt_rt_val_id));
4117: fnd_message.raise_error;
4118: --
4119: end if;

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

4112: close c_get_prtt_rt_val;
4113: --
4114: fnd_message.set_name('BEN', 'BEN_92103_NO_PRTT_RT_VAL');
4115: fnd_message.set_token('PROC',l_proc);
4116: fnd_message.set_token('PRTT_RT_VAL',to_char(p_prtt_rt_val_id));
4117: fnd_message.raise_error;
4118: --
4119: end if;
4120: close c_get_prtt_rt_val;

Line 4117: fnd_message.raise_error;

4113: --
4114: fnd_message.set_name('BEN', 'BEN_92103_NO_PRTT_RT_VAL');
4115: fnd_message.set_token('PROC',l_proc);
4116: fnd_message.set_token('PRTT_RT_VAL',to_char(p_prtt_rt_val_id));
4117: fnd_message.raise_error;
4118: --
4119: end if;
4120: close c_get_prtt_rt_val;
4121: end if;

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

4146: close get_abr_info;
4147: if g_debug then
4148: hr_utility.set_location('BEN_91723_NO_ENRT_RT_ABR_FOUND',5);
4149: end if;
4150: fnd_message.set_name('BEN','BEN_91723_NO_ENRT_RT_ABR_FOUND');
4151: fnd_message.set_token('PROC',l_proc);
4152: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
4153: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
4154: fnd_message.raise_error;

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

4147: if g_debug then
4148: hr_utility.set_location('BEN_91723_NO_ENRT_RT_ABR_FOUND',5);
4149: end if;
4150: fnd_message.set_name('BEN','BEN_91723_NO_ENRT_RT_ABR_FOUND');
4151: fnd_message.set_token('PROC',l_proc);
4152: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
4153: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
4154: fnd_message.raise_error;
4155: end if;

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

4148: hr_utility.set_location('BEN_91723_NO_ENRT_RT_ABR_FOUND',5);
4149: end if;
4150: fnd_message.set_name('BEN','BEN_91723_NO_ENRT_RT_ABR_FOUND');
4151: fnd_message.set_token('PROC',l_proc);
4152: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
4153: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
4154: fnd_message.raise_error;
4155: end if;
4156: close get_abr_info;

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

4149: end if;
4150: fnd_message.set_name('BEN','BEN_91723_NO_ENRT_RT_ABR_FOUND');
4151: fnd_message.set_token('PROC',l_proc);
4152: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
4153: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
4154: fnd_message.raise_error;
4155: end if;
4156: close get_abr_info;
4157:

Line 4154: fnd_message.raise_error;

4150: fnd_message.set_name('BEN','BEN_91723_NO_ENRT_RT_ABR_FOUND');
4151: fnd_message.set_token('PROC',l_proc);
4152: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
4153: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
4154: fnd_message.raise_error;
4155: end if;
4156: close get_abr_info;
4157:
4158: g_acty_base_rt_name := l_get_abr_info.name;

Line 4273: fnd_message.raise_error;

4269: if l_element_link_id is null then
4270: --
4271: -- error message already set on stack.
4272: --
4273: fnd_message.raise_error;
4274: end if;
4275:
4276: l_old_element_link_id := l_element_link_id;
4277:

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

4422: fetch c_dup_prv into l_abr_name;
4423: if c_dup_prv%found then
4424: --
4425: close c_dup_prv;
4426: fnd_message.set_name('BEN','BEN_92690_ELMNT_ALRDY_USD');
4427: fnd_message.set_token('P_RATE1',l_abr_name);
4428: fnd_message.set_token('P_RATE2',g_acty_base_rt_name);
4429: fnd_message.raise_error;
4430: --

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

4423: if c_dup_prv%found then
4424: --
4425: close c_dup_prv;
4426: fnd_message.set_name('BEN','BEN_92690_ELMNT_ALRDY_USD');
4427: fnd_message.set_token('P_RATE1',l_abr_name);
4428: fnd_message.set_token('P_RATE2',g_acty_base_rt_name);
4429: fnd_message.raise_error;
4430: --
4431: end if;

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

4424: --
4425: close c_dup_prv;
4426: fnd_message.set_name('BEN','BEN_92690_ELMNT_ALRDY_USD');
4427: fnd_message.set_token('P_RATE1',l_abr_name);
4428: fnd_message.set_token('P_RATE2',g_acty_base_rt_name);
4429: fnd_message.raise_error;
4430: --
4431: end if;
4432: close c_dup_prv;

Line 4429: fnd_message.raise_error;

4425: close c_dup_prv;
4426: fnd_message.set_name('BEN','BEN_92690_ELMNT_ALRDY_USD');
4427: fnd_message.set_token('P_RATE1',l_abr_name);
4428: fnd_message.set_token('P_RATE2',g_acty_base_rt_name);
4429: fnd_message.raise_error;
4430: --
4431: end if;
4432: close c_dup_prv;
4433: --

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

4437: fetch c_dup_rslt into l_abr_name;
4438: if c_dup_rslt%found then
4439: --
4440: close c_dup_rslt;
4441: fnd_message.set_name('BEN','BEN_93450_ELE_MULTIPLE_RSLT');
4442: fnd_message.set_token('P_RATE1',l_abr_name);
4443: fnd_message.set_token('P_RATE2',g_acty_base_rt_name);
4444: fnd_message.raise_error;
4445: --

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

4438: if c_dup_rslt%found then
4439: --
4440: close c_dup_rslt;
4441: fnd_message.set_name('BEN','BEN_93450_ELE_MULTIPLE_RSLT');
4442: fnd_message.set_token('P_RATE1',l_abr_name);
4443: fnd_message.set_token('P_RATE2',g_acty_base_rt_name);
4444: fnd_message.raise_error;
4445: --
4446: end if;

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

4439: --
4440: close c_dup_rslt;
4441: fnd_message.set_name('BEN','BEN_93450_ELE_MULTIPLE_RSLT');
4442: fnd_message.set_token('P_RATE1',l_abr_name);
4443: fnd_message.set_token('P_RATE2',g_acty_base_rt_name);
4444: fnd_message.raise_error;
4445: --
4446: end if;
4447: close c_dup_rslt;

Line 4444: fnd_message.raise_error;

4440: close c_dup_rslt;
4441: fnd_message.set_name('BEN','BEN_93450_ELE_MULTIPLE_RSLT');
4442: fnd_message.set_token('P_RATE1',l_abr_name);
4443: fnd_message.set_token('P_RATE2',g_acty_base_rt_name);
4444: fnd_message.raise_error;
4445: --
4446: end if;
4447: close c_dup_rslt;
4448:

Line 4504: l_encoded_message := fnd_message.get;

4500: when others then
4501: ben_on_line_lf_evt.get_ser_message(l_encoded_message,
4502: l_app_short_name,
4503: l_message_name);
4504: l_encoded_message := fnd_message.get;
4505: --
4506: if l_message_name like '%HR_6284_ELE_ENTRY_DT_ASG_DEL%' or
4507: l_message_name like '%HR_7187_DT_CANNOT_EXTEND_END%' then
4508: --

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

4511: --
4512: null;
4513: else
4514: if l_app_short_name is not null then
4515: fnd_message.set_name(l_app_short_name,l_message_name);
4516: fnd_message.raise_error;
4517: else
4518: raise;
4519: end if;

Line 4516: fnd_message.raise_error;

4512: null;
4513: else
4514: if l_app_short_name is not null then
4515: fnd_message.set_name(l_app_short_name,l_message_name);
4516: fnd_message.raise_error;
4517: else
4518: raise;
4519: end if;
4520: end if;

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

4600: when others then
4601: if g_debug then
4602: hr_utility.set_location('BEN_92311_FORMULA_VAL_PARAM',30);
4603: end if;
4604: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
4605: fnd_message.set_token('PROC',l_proc);
4606: fnd_message.set_token('FORMULA',l_get_abr_info.prtl_mo_det_mthd_rl);
4607: fnd_message.set_token('PARAMETER',
4608: l_outputs(l_outputs.first).name);

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

4601: if g_debug then
4602: hr_utility.set_location('BEN_92311_FORMULA_VAL_PARAM',30);
4603: end if;
4604: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
4605: fnd_message.set_token('PROC',l_proc);
4606: fnd_message.set_token('FORMULA',l_get_abr_info.prtl_mo_det_mthd_rl);
4607: fnd_message.set_token('PARAMETER',
4608: l_outputs(l_outputs.first).name);
4609: fnd_message.raise_error;

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

4602: hr_utility.set_location('BEN_92311_FORMULA_VAL_PARAM',30);
4603: end if;
4604: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
4605: fnd_message.set_token('PROC',l_proc);
4606: fnd_message.set_token('FORMULA',l_get_abr_info.prtl_mo_det_mthd_rl);
4607: fnd_message.set_token('PARAMETER',
4608: l_outputs(l_outputs.first).name);
4609: fnd_message.raise_error;
4610: --

Line 4607: fnd_message.set_token('PARAMETER',

4603: end if;
4604: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
4605: fnd_message.set_token('PROC',l_proc);
4606: fnd_message.set_token('FORMULA',l_get_abr_info.prtl_mo_det_mthd_rl);
4607: fnd_message.set_token('PARAMETER',
4608: l_outputs(l_outputs.first).name);
4609: fnd_message.raise_error;
4610: --
4611: end;

Line 4609: fnd_message.raise_error;

4605: fnd_message.set_token('PROC',l_proc);
4606: fnd_message.set_token('FORMULA',l_get_abr_info.prtl_mo_det_mthd_rl);
4607: fnd_message.set_token('PARAMETER',
4608: l_outputs(l_outputs.first).name);
4609: fnd_message.raise_error;
4610: --
4611: end;
4612: end if;
4613: -- ELE :

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

4736: --
4737: if l_last_pp_end_dt is null and
4738: ben_epe_cache.g_currepe_row.elig_per_elctbl_chc_id is null then
4739: --
4740: fnd_message.set_name('BEN','BEN_93368_DETERMINE_PAY_PERIOD');
4741: fnd_message.raise_error;
4742: --
4743: end if;
4744: --

Line 4741: fnd_message.raise_error;

4737: if l_last_pp_end_dt is null and
4738: ben_epe_cache.g_currepe_row.elig_per_elctbl_chc_id is null then
4739: --
4740: fnd_message.set_name('BEN','BEN_93368_DETERMINE_PAY_PERIOD');
4741: fnd_message.raise_error;
4742: --
4743: end if;
4744: --
4745: -- Bug 2149438

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

5125: --
5126: if g_debug then
5127: hr_utility.set_location('BEN_91628_LOOKUP_TYPE_GENERIC',30);
5128: end if;
5129: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
5130: fnd_message.set_token('FIELD','p_one_ann_pymt_cd');
5131: fnd_message.set_token('TYPE','BEN_ONE_ANN_PYMT');
5132: fnd_message.set_token('VALUE',l_get_abr_info.one_ann_pymt_cd);
5133: fnd_message.raise_error;

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

5126: if g_debug then
5127: hr_utility.set_location('BEN_91628_LOOKUP_TYPE_GENERIC',30);
5128: end if;
5129: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
5130: fnd_message.set_token('FIELD','p_one_ann_pymt_cd');
5131: fnd_message.set_token('TYPE','BEN_ONE_ANN_PYMT');
5132: fnd_message.set_token('VALUE',l_get_abr_info.one_ann_pymt_cd);
5133: fnd_message.raise_error;
5134: end if;

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

5127: hr_utility.set_location('BEN_91628_LOOKUP_TYPE_GENERIC',30);
5128: end if;
5129: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
5130: fnd_message.set_token('FIELD','p_one_ann_pymt_cd');
5131: fnd_message.set_token('TYPE','BEN_ONE_ANN_PYMT');
5132: fnd_message.set_token('VALUE',l_get_abr_info.one_ann_pymt_cd);
5133: fnd_message.raise_error;
5134: end if;
5135: end if;

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

5128: end if;
5129: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
5130: fnd_message.set_token('FIELD','p_one_ann_pymt_cd');
5131: fnd_message.set_token('TYPE','BEN_ONE_ANN_PYMT');
5132: fnd_message.set_token('VALUE',l_get_abr_info.one_ann_pymt_cd);
5133: fnd_message.raise_error;
5134: end if;
5135: end if;
5136:

Line 5133: fnd_message.raise_error;

5129: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
5130: fnd_message.set_token('FIELD','p_one_ann_pymt_cd');
5131: fnd_message.set_token('TYPE','BEN_ONE_ANN_PYMT');
5132: fnd_message.set_token('VALUE',l_get_abr_info.one_ann_pymt_cd);
5133: fnd_message.raise_error;
5134: end if;
5135: end if;
5136:
5137: -- ELE :

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

5271: close c_pps_next_month;
5272: if g_debug then
5273: hr_utility.set_location('BEN_92346_PAYROLL_NOT_DEFINED',30);
5274: end if;
5275: fnd_message.set_name('BEN', 'BEN_92346_PAYROLL_NOT_DEFINED');
5276: fnd_message.set_token('PROC',l_proc);
5277: fnd_message.raise_error;
5278: end if;
5279: hr_elements.check_element_freq(

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

5272: if g_debug then
5273: hr_utility.set_location('BEN_92346_PAYROLL_NOT_DEFINED',30);
5274: end if;
5275: fnd_message.set_name('BEN', 'BEN_92346_PAYROLL_NOT_DEFINED');
5276: fnd_message.set_token('PROC',l_proc);
5277: fnd_message.raise_error;
5278: end if;
5279: hr_elements.check_element_freq(
5280: p_payroll_id =>l_payroll_id,

Line 5277: fnd_message.raise_error;

5273: hr_utility.set_location('BEN_92346_PAYROLL_NOT_DEFINED',30);
5274: end if;
5275: fnd_message.set_name('BEN', 'BEN_92346_PAYROLL_NOT_DEFINED');
5276: fnd_message.set_token('PROC',l_proc);
5277: fnd_message.raise_error;
5278: end if;
5279: hr_elements.check_element_freq(
5280: p_payroll_id =>l_payroll_id,
5281: p_bg_id =>p_business_group_id,

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

5305: close c_pps_next_month;
5306: if g_debug then
5307: hr_utility.set_location('BEN_92346_PAYROLL_NOT_DEFINED',32);
5308: end if;
5309: fnd_message.set_name('BEN', 'BEN_92346_PAYROLL_NOT_DEFINED');
5310: fnd_message.set_token('PROC',l_proc);
5311: fnd_message.raise_error;
5312: end if;
5313: hr_elements.check_element_freq(

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

5306: if g_debug then
5307: hr_utility.set_location('BEN_92346_PAYROLL_NOT_DEFINED',32);
5308: end if;
5309: fnd_message.set_name('BEN', 'BEN_92346_PAYROLL_NOT_DEFINED');
5310: fnd_message.set_token('PROC',l_proc);
5311: fnd_message.raise_error;
5312: end if;
5313: hr_elements.check_element_freq(
5314: p_payroll_id =>l_payroll_id,

Line 5311: fnd_message.raise_error;

5307: hr_utility.set_location('BEN_92346_PAYROLL_NOT_DEFINED',32);
5308: end if;
5309: fnd_message.set_name('BEN', 'BEN_92346_PAYROLL_NOT_DEFINED');
5310: fnd_message.set_token('PROC',l_proc);
5311: fnd_message.raise_error;
5312: end if;
5313: hr_elements.check_element_freq(
5314: p_payroll_id =>l_payroll_id,
5315: p_bg_id =>p_business_group_id,

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

5352: close c_pps_next_month;
5353: if g_debug then
5354: hr_utility.set_location('BEN_92346_PAYROLL_NOT_DEFINED',34);
5355: end if;
5356: fnd_message.set_name('BEN', 'BEN_92346_PAYROLL_NOT_DEFINED');
5357: fnd_message.set_token('PROC',l_proc);
5358: fnd_message.raise_error;
5359: end if;
5360: hr_elements.check_element_freq(

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

5353: if g_debug then
5354: hr_utility.set_location('BEN_92346_PAYROLL_NOT_DEFINED',34);
5355: end if;
5356: fnd_message.set_name('BEN', 'BEN_92346_PAYROLL_NOT_DEFINED');
5357: fnd_message.set_token('PROC',l_proc);
5358: fnd_message.raise_error;
5359: end if;
5360: hr_elements.check_element_freq(
5361: p_payroll_id => l_payroll_id,

Line 5358: fnd_message.raise_error;

5354: hr_utility.set_location('BEN_92346_PAYROLL_NOT_DEFINED',34);
5355: end if;
5356: fnd_message.set_name('BEN', 'BEN_92346_PAYROLL_NOT_DEFINED');
5357: fnd_message.set_token('PROC',l_proc);
5358: fnd_message.raise_error;
5359: end if;
5360: hr_elements.check_element_freq(
5361: p_payroll_id => l_payroll_id,
5362: p_bg_id => p_business_group_id,

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

5534: close get_current_value;
5535: if g_debug then
5536: hr_utility.set_location('BEN_92101_NO_RATE ',90);
5537: end if;
5538: fnd_message.set_name('BEN', 'BEN_92101_NO_RATE');
5539: fnd_message.set_token('PROC',l_proc);
5540: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_element_entry_id));
5541: fnd_message.set_token('INPUT_VALUE_ID',to_char(l_input_value_id));
5542: fnd_message.set_token('EFFECTIVE_DATE',to_char(l_zero_pp_date));

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

5535: if g_debug then
5536: hr_utility.set_location('BEN_92101_NO_RATE ',90);
5537: end if;
5538: fnd_message.set_name('BEN', 'BEN_92101_NO_RATE');
5539: fnd_message.set_token('PROC',l_proc);
5540: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_element_entry_id));
5541: fnd_message.set_token('INPUT_VALUE_ID',to_char(l_input_value_id));
5542: fnd_message.set_token('EFFECTIVE_DATE',to_char(l_zero_pp_date));
5543: fnd_message.set_token('ABR_NAME',l_get_abr_info.name); -- Bug 2519349

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

5536: hr_utility.set_location('BEN_92101_NO_RATE ',90);
5537: end if;
5538: fnd_message.set_name('BEN', 'BEN_92101_NO_RATE');
5539: fnd_message.set_token('PROC',l_proc);
5540: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_element_entry_id));
5541: fnd_message.set_token('INPUT_VALUE_ID',to_char(l_input_value_id));
5542: fnd_message.set_token('EFFECTIVE_DATE',to_char(l_zero_pp_date));
5543: fnd_message.set_token('ABR_NAME',l_get_abr_info.name); -- Bug 2519349
5544: fnd_message.raise_error;

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

5537: end if;
5538: fnd_message.set_name('BEN', 'BEN_92101_NO_RATE');
5539: fnd_message.set_token('PROC',l_proc);
5540: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_element_entry_id));
5541: fnd_message.set_token('INPUT_VALUE_ID',to_char(l_input_value_id));
5542: fnd_message.set_token('EFFECTIVE_DATE',to_char(l_zero_pp_date));
5543: fnd_message.set_token('ABR_NAME',l_get_abr_info.name); -- Bug 2519349
5544: fnd_message.raise_error;
5545: end if;

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

5538: fnd_message.set_name('BEN', 'BEN_92101_NO_RATE');
5539: fnd_message.set_token('PROC',l_proc);
5540: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_element_entry_id));
5541: fnd_message.set_token('INPUT_VALUE_ID',to_char(l_input_value_id));
5542: fnd_message.set_token('EFFECTIVE_DATE',to_char(l_zero_pp_date));
5543: fnd_message.set_token('ABR_NAME',l_get_abr_info.name); -- Bug 2519349
5544: fnd_message.raise_error;
5545: end if;
5546: close get_current_value;

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

5539: fnd_message.set_token('PROC',l_proc);
5540: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_element_entry_id));
5541: fnd_message.set_token('INPUT_VALUE_ID',to_char(l_input_value_id));
5542: fnd_message.set_token('EFFECTIVE_DATE',to_char(l_zero_pp_date));
5543: fnd_message.set_token('ABR_NAME',l_get_abr_info.name); -- Bug 2519349
5544: fnd_message.raise_error;
5545: end if;
5546: close get_current_value;
5547:

Line 5544: fnd_message.raise_error;

5540: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_element_entry_id));
5541: fnd_message.set_token('INPUT_VALUE_ID',to_char(l_input_value_id));
5542: fnd_message.set_token('EFFECTIVE_DATE',to_char(l_zero_pp_date));
5543: fnd_message.set_token('ABR_NAME',l_get_abr_info.name); -- Bug 2519349
5544: fnd_message.raise_error;
5545: end if;
5546: close get_current_value;
5547:
5548: --

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

5850: close get_current_value;
5851: if g_debug then
5852: hr_utility.set_location('BEN_92101_NO_RATE ',92);
5853: end if;
5854: fnd_message.set_name('BEN', 'BEN_92101_NO_RATE');
5855: fnd_message.set_token('PROC',l_proc);
5856: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_element_entry_id));
5857: fnd_message.set_token('INPUT_VALUE_ID',to_char(l_input_value_id));
5858: fnd_message.set_token('EFFECTIVE_DATE',to_char(l_special_pp_date));

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

5851: if g_debug then
5852: hr_utility.set_location('BEN_92101_NO_RATE ',92);
5853: end if;
5854: fnd_message.set_name('BEN', 'BEN_92101_NO_RATE');
5855: fnd_message.set_token('PROC',l_proc);
5856: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_element_entry_id));
5857: fnd_message.set_token('INPUT_VALUE_ID',to_char(l_input_value_id));
5858: fnd_message.set_token('EFFECTIVE_DATE',to_char(l_special_pp_date));
5859: fnd_message.set_token('ABR_NAME',l_get_abr_info.name); -- Bug 2519349

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

5852: hr_utility.set_location('BEN_92101_NO_RATE ',92);
5853: end if;
5854: fnd_message.set_name('BEN', 'BEN_92101_NO_RATE');
5855: fnd_message.set_token('PROC',l_proc);
5856: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_element_entry_id));
5857: fnd_message.set_token('INPUT_VALUE_ID',to_char(l_input_value_id));
5858: fnd_message.set_token('EFFECTIVE_DATE',to_char(l_special_pp_date));
5859: fnd_message.set_token('ABR_NAME',l_get_abr_info.name); -- Bug 2519349
5860: fnd_message.raise_error;

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

5853: end if;
5854: fnd_message.set_name('BEN', 'BEN_92101_NO_RATE');
5855: fnd_message.set_token('PROC',l_proc);
5856: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_element_entry_id));
5857: fnd_message.set_token('INPUT_VALUE_ID',to_char(l_input_value_id));
5858: fnd_message.set_token('EFFECTIVE_DATE',to_char(l_special_pp_date));
5859: fnd_message.set_token('ABR_NAME',l_get_abr_info.name); -- Bug 2519349
5860: fnd_message.raise_error;
5861: end if;

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

5854: fnd_message.set_name('BEN', 'BEN_92101_NO_RATE');
5855: fnd_message.set_token('PROC',l_proc);
5856: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_element_entry_id));
5857: fnd_message.set_token('INPUT_VALUE_ID',to_char(l_input_value_id));
5858: fnd_message.set_token('EFFECTIVE_DATE',to_char(l_special_pp_date));
5859: fnd_message.set_token('ABR_NAME',l_get_abr_info.name); -- Bug 2519349
5860: fnd_message.raise_error;
5861: end if;
5862: close get_current_value;

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

5855: fnd_message.set_token('PROC',l_proc);
5856: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_element_entry_id));
5857: fnd_message.set_token('INPUT_VALUE_ID',to_char(l_input_value_id));
5858: fnd_message.set_token('EFFECTIVE_DATE',to_char(l_special_pp_date));
5859: fnd_message.set_token('ABR_NAME',l_get_abr_info.name); -- Bug 2519349
5860: fnd_message.raise_error;
5861: end if;
5862: close get_current_value;
5863:

Line 5860: fnd_message.raise_error;

5856: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_element_entry_id));
5857: fnd_message.set_token('INPUT_VALUE_ID',to_char(l_input_value_id));
5858: fnd_message.set_token('EFFECTIVE_DATE',to_char(l_special_pp_date));
5859: fnd_message.set_token('ABR_NAME',l_get_abr_info.name); -- Bug 2519349
5860: fnd_message.raise_error;
5861: end if;
5862: close get_current_value;
5863:
5864: if l_uom is null then

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

6237: close get_current_value;
6238: if g_debug then
6239: hr_utility.set_location('BEN_92101_NO_RATE ',94);
6240: end if;
6241: fnd_message.set_name('BEN', 'BEN_92101_NO_RATE');
6242: fnd_message.set_token('PROC',l_proc);
6243: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_element_entry_id));
6244: fnd_message.set_token('INPUT_VALUE_ID',to_char(l_input_value_id));
6245: fnd_message.set_token('EFFECTIVE_DATE',to_char(l_normal_pp_date));

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

6238: if g_debug then
6239: hr_utility.set_location('BEN_92101_NO_RATE ',94);
6240: end if;
6241: fnd_message.set_name('BEN', 'BEN_92101_NO_RATE');
6242: fnd_message.set_token('PROC',l_proc);
6243: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_element_entry_id));
6244: fnd_message.set_token('INPUT_VALUE_ID',to_char(l_input_value_id));
6245: fnd_message.set_token('EFFECTIVE_DATE',to_char(l_normal_pp_date));
6246: fnd_message.set_token('ABR_NAME',l_get_abr_info.name); -- Bug 2519349

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

6239: hr_utility.set_location('BEN_92101_NO_RATE ',94);
6240: end if;
6241: fnd_message.set_name('BEN', 'BEN_92101_NO_RATE');
6242: fnd_message.set_token('PROC',l_proc);
6243: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_element_entry_id));
6244: fnd_message.set_token('INPUT_VALUE_ID',to_char(l_input_value_id));
6245: fnd_message.set_token('EFFECTIVE_DATE',to_char(l_normal_pp_date));
6246: fnd_message.set_token('ABR_NAME',l_get_abr_info.name); -- Bug 2519349
6247: fnd_message.raise_error;

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

6240: end if;
6241: fnd_message.set_name('BEN', 'BEN_92101_NO_RATE');
6242: fnd_message.set_token('PROC',l_proc);
6243: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_element_entry_id));
6244: fnd_message.set_token('INPUT_VALUE_ID',to_char(l_input_value_id));
6245: fnd_message.set_token('EFFECTIVE_DATE',to_char(l_normal_pp_date));
6246: fnd_message.set_token('ABR_NAME',l_get_abr_info.name); -- Bug 2519349
6247: fnd_message.raise_error;
6248: end if;

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

6241: fnd_message.set_name('BEN', 'BEN_92101_NO_RATE');
6242: fnd_message.set_token('PROC',l_proc);
6243: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_element_entry_id));
6244: fnd_message.set_token('INPUT_VALUE_ID',to_char(l_input_value_id));
6245: fnd_message.set_token('EFFECTIVE_DATE',to_char(l_normal_pp_date));
6246: fnd_message.set_token('ABR_NAME',l_get_abr_info.name); -- Bug 2519349
6247: fnd_message.raise_error;
6248: end if;
6249: close get_current_value;

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

6242: fnd_message.set_token('PROC',l_proc);
6243: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_element_entry_id));
6244: fnd_message.set_token('INPUT_VALUE_ID',to_char(l_input_value_id));
6245: fnd_message.set_token('EFFECTIVE_DATE',to_char(l_normal_pp_date));
6246: fnd_message.set_token('ABR_NAME',l_get_abr_info.name); -- Bug 2519349
6247: fnd_message.raise_error;
6248: end if;
6249: close get_current_value;
6250: --

Line 6247: fnd_message.raise_error;

6243: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_element_entry_id));
6244: fnd_message.set_token('INPUT_VALUE_ID',to_char(l_input_value_id));
6245: fnd_message.set_token('EFFECTIVE_DATE',to_char(l_normal_pp_date));
6246: fnd_message.set_token('ABR_NAME',l_get_abr_info.name); -- Bug 2519349
6247: fnd_message.raise_error;
6248: end if;
6249: close get_current_value;
6250: --
6251: if l_uom is null then

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

6953: p_person_id => p_person_id);
6954: --
6955: if fnd_global.conc_request_id not in ( 0,-1) then
6956: --
6957: fnd_message.set_name('BEN',l_message_name);
6958: fnd_message.set_token('PARMA',l_element_name);
6959: fnd_message.set_token('PARMB',to_char(l_effective_end_date));
6960: l_string := fnd_message.get;
6961: benutils.write(p_text => l_string);

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

6954: --
6955: if fnd_global.conc_request_id not in ( 0,-1) then
6956: --
6957: fnd_message.set_name('BEN',l_message_name);
6958: fnd_message.set_token('PARMA',l_element_name);
6959: fnd_message.set_token('PARMB',to_char(l_effective_end_date));
6960: l_string := fnd_message.get;
6961: benutils.write(p_text => l_string);
6962: --

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

6955: if fnd_global.conc_request_id not in ( 0,-1) then
6956: --
6957: fnd_message.set_name('BEN',l_message_name);
6958: fnd_message.set_token('PARMA',l_element_name);
6959: fnd_message.set_token('PARMB',to_char(l_effective_end_date));
6960: l_string := fnd_message.get;
6961: benutils.write(p_text => l_string);
6962: --
6963: end if;

Line 6960: l_string := fnd_message.get;

6956: --
6957: fnd_message.set_name('BEN',l_message_name);
6958: fnd_message.set_token('PARMA',l_element_name);
6959: fnd_message.set_token('PARMB',to_char(l_effective_end_date));
6960: l_string := fnd_message.get;
6961: benutils.write(p_text => l_string);
6962: --
6963: end if;
6964: --

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

6999: --
7000: if g_debug then
7001: hr_utility.set_location('BEN_92102_NO_ENTRY_CREATED',140);
7002: end if;
7003: fnd_message.set_name('BEN', 'BEN_92102_NO_ENTRY_CREATED');
7004: fnd_message.set_token('PROC',l_proc);
7005: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_old_element_link_id));
7006: fnd_message.set_token('INPUT_VALUE_ID',to_char(l_input_value_id));
7007: fnd_message.set_token('EFFECTIVE_DATE',to_char(l_rt_strt_dt));

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

7000: if g_debug then
7001: hr_utility.set_location('BEN_92102_NO_ENTRY_CREATED',140);
7002: end if;
7003: fnd_message.set_name('BEN', 'BEN_92102_NO_ENTRY_CREATED');
7004: fnd_message.set_token('PROC',l_proc);
7005: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_old_element_link_id));
7006: fnd_message.set_token('INPUT_VALUE_ID',to_char(l_input_value_id));
7007: fnd_message.set_token('EFFECTIVE_DATE',to_char(l_rt_strt_dt));
7008: fnd_message.raise_error;

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

7001: hr_utility.set_location('BEN_92102_NO_ENTRY_CREATED',140);
7002: end if;
7003: fnd_message.set_name('BEN', 'BEN_92102_NO_ENTRY_CREATED');
7004: fnd_message.set_token('PROC',l_proc);
7005: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_old_element_link_id));
7006: fnd_message.set_token('INPUT_VALUE_ID',to_char(l_input_value_id));
7007: fnd_message.set_token('EFFECTIVE_DATE',to_char(l_rt_strt_dt));
7008: fnd_message.raise_error;
7009: --

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

7002: end if;
7003: fnd_message.set_name('BEN', 'BEN_92102_NO_ENTRY_CREATED');
7004: fnd_message.set_token('PROC',l_proc);
7005: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_old_element_link_id));
7006: fnd_message.set_token('INPUT_VALUE_ID',to_char(l_input_value_id));
7007: fnd_message.set_token('EFFECTIVE_DATE',to_char(l_rt_strt_dt));
7008: fnd_message.raise_error;
7009: --
7010: end if;

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

7003: fnd_message.set_name('BEN', 'BEN_92102_NO_ENTRY_CREATED');
7004: fnd_message.set_token('PROC',l_proc);
7005: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_old_element_link_id));
7006: fnd_message.set_token('INPUT_VALUE_ID',to_char(l_input_value_id));
7007: fnd_message.set_token('EFFECTIVE_DATE',to_char(l_rt_strt_dt));
7008: fnd_message.raise_error;
7009: --
7010: end if;
7011: close get_element_entry;

Line 7008: fnd_message.raise_error;

7004: fnd_message.set_token('PROC',l_proc);
7005: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_old_element_link_id));
7006: fnd_message.set_token('INPUT_VALUE_ID',to_char(l_input_value_id));
7007: fnd_message.set_token('EFFECTIVE_DATE',to_char(l_rt_strt_dt));
7008: fnd_message.raise_error;
7009: --
7010: end if;
7011: close get_element_entry;
7012: --

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

7107: p_person_id => p_person_id);
7108:
7109: if fnd_global.conc_request_id in ( 0,-1) then
7110: --
7111: fnd_message.set_name('BEN','BEN_92455_STRT_RUN_RESULTS');
7112: fnd_message.set_token('PARMA', fnd_date.date_to_chardate(g_max_end_date,calendar_aware=>2));
7113: l_string := fnd_message.get;
7114: benutils.write(p_text => l_string);
7115: --

Line 7112: fnd_message.set_token('PARMA', fnd_date.date_to_chardate(g_max_end_date,calendar_aware=>2));

7108:
7109: if fnd_global.conc_request_id in ( 0,-1) then
7110: --
7111: fnd_message.set_name('BEN','BEN_92455_STRT_RUN_RESULTS');
7112: fnd_message.set_token('PARMA', fnd_date.date_to_chardate(g_max_end_date,calendar_aware=>2));
7113: l_string := fnd_message.get;
7114: benutils.write(p_text => l_string);
7115: --
7116: end if;

Line 7113: l_string := fnd_message.get;

7109: if fnd_global.conc_request_id in ( 0,-1) then
7110: --
7111: fnd_message.set_name('BEN','BEN_92455_STRT_RUN_RESULTS');
7112: fnd_message.set_token('PARMA', fnd_date.date_to_chardate(g_max_end_date,calendar_aware=>2));
7113: l_string := fnd_message.get;
7114: benutils.write(p_text => l_string);
7115: --
7116: end if;
7117: g_msg_displayed := 1;

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

7439: hr_utility.set_location('BEN_92103_NO_PRTT_RT_VAL',170);
7440: end if;
7441: close c_get_prtt_rt_val;
7442: --
7443: fnd_message.set_name('BEN', 'BEN_92103_NO_PRTT_RT_VAL');
7444: fnd_message.set_token('PROC',l_proc);
7445: fnd_message.set_token('PRTT_RT_VAL',to_char(p_prtt_rt_val_id));
7446: fnd_message.raise_error;
7447: --

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

7440: end if;
7441: close c_get_prtt_rt_val;
7442: --
7443: fnd_message.set_name('BEN', 'BEN_92103_NO_PRTT_RT_VAL');
7444: fnd_message.set_token('PROC',l_proc);
7445: fnd_message.set_token('PRTT_RT_VAL',to_char(p_prtt_rt_val_id));
7446: fnd_message.raise_error;
7447: --
7448: end if;

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

7441: close c_get_prtt_rt_val;
7442: --
7443: fnd_message.set_name('BEN', 'BEN_92103_NO_PRTT_RT_VAL');
7444: fnd_message.set_token('PROC',l_proc);
7445: fnd_message.set_token('PRTT_RT_VAL',to_char(p_prtt_rt_val_id));
7446: fnd_message.raise_error;
7447: --
7448: end if;
7449: close c_get_prtt_rt_val;

Line 7446: fnd_message.raise_error;

7442: --
7443: fnd_message.set_name('BEN', 'BEN_92103_NO_PRTT_RT_VAL');
7444: fnd_message.set_token('PROC',l_proc);
7445: fnd_message.set_token('PRTT_RT_VAL',to_char(p_prtt_rt_val_id));
7446: fnd_message.raise_error;
7447: --
7448: end if;
7449: close c_get_prtt_rt_val;
7450: --

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

7466: close get_abr_info;
7467: if g_debug then
7468: hr_utility.set_location('BEN_91723_NO_ENRT_RT_ABR_FOUND',30);
7469: end if;
7470: fnd_message.set_name('BEN','BEN_91723_NO_ENRT_RT_ABR_FOUND');
7471: fnd_message.set_token('PROC',l_proc);
7472: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
7473: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
7474: fnd_message.raise_error;

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

7467: if g_debug then
7468: hr_utility.set_location('BEN_91723_NO_ENRT_RT_ABR_FOUND',30);
7469: end if;
7470: fnd_message.set_name('BEN','BEN_91723_NO_ENRT_RT_ABR_FOUND');
7471: fnd_message.set_token('PROC',l_proc);
7472: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
7473: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
7474: fnd_message.raise_error;
7475: end if;

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

7468: hr_utility.set_location('BEN_91723_NO_ENRT_RT_ABR_FOUND',30);
7469: end if;
7470: fnd_message.set_name('BEN','BEN_91723_NO_ENRT_RT_ABR_FOUND');
7471: fnd_message.set_token('PROC',l_proc);
7472: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
7473: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
7474: fnd_message.raise_error;
7475: end if;
7476: close get_abr_info;

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

7469: end if;
7470: fnd_message.set_name('BEN','BEN_91723_NO_ENRT_RT_ABR_FOUND');
7471: fnd_message.set_token('PROC',l_proc);
7472: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
7473: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
7474: fnd_message.raise_error;
7475: end if;
7476: close get_abr_info;
7477: --

Line 7474: fnd_message.raise_error;

7470: fnd_message.set_name('BEN','BEN_91723_NO_ENRT_RT_ABR_FOUND');
7471: fnd_message.set_token('PROC',l_proc);
7472: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
7473: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
7474: fnd_message.raise_error;
7475: end if;
7476: close get_abr_info;
7477: --
7478: -- get the element type and input value based on entry value attached to

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

7647: if g_debug then
7648: hr_utility.set_location('BEN_92105_NO_PRIOR_ENROLLMENT',40);
7649: end if;
7650: close get_last_element_entry;
7651: fnd_message.set_name('BEN', 'BEN_92105_NO_PRIOR_ENROLLMENT');
7652: fnd_message.set_token('PROC',l_proc);
7653: fnd_message.set_token('ELEMENT_TYPE_ID',to_char(l_element_type_id));
7654: fnd_message.set_token('ASSGN_ID',to_char(l_assignment_id));
7655: fnd_message.set_token('PRTT_RT_VAL_ID',to_char(p_prtt_rt_val_id));

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

7648: hr_utility.set_location('BEN_92105_NO_PRIOR_ENROLLMENT',40);
7649: end if;
7650: close get_last_element_entry;
7651: fnd_message.set_name('BEN', 'BEN_92105_NO_PRIOR_ENROLLMENT');
7652: fnd_message.set_token('PROC',l_proc);
7653: fnd_message.set_token('ELEMENT_TYPE_ID',to_char(l_element_type_id));
7654: fnd_message.set_token('ASSGN_ID',to_char(l_assignment_id));
7655: fnd_message.set_token('PRTT_RT_VAL_ID',to_char(p_prtt_rt_val_id));
7656: fnd_message.raise_error;

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

7649: end if;
7650: close get_last_element_entry;
7651: fnd_message.set_name('BEN', 'BEN_92105_NO_PRIOR_ENROLLMENT');
7652: fnd_message.set_token('PROC',l_proc);
7653: fnd_message.set_token('ELEMENT_TYPE_ID',to_char(l_element_type_id));
7654: fnd_message.set_token('ASSGN_ID',to_char(l_assignment_id));
7655: fnd_message.set_token('PRTT_RT_VAL_ID',to_char(p_prtt_rt_val_id));
7656: fnd_message.raise_error;
7657: --

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

7650: close get_last_element_entry;
7651: fnd_message.set_name('BEN', 'BEN_92105_NO_PRIOR_ENROLLMENT');
7652: fnd_message.set_token('PROC',l_proc);
7653: fnd_message.set_token('ELEMENT_TYPE_ID',to_char(l_element_type_id));
7654: fnd_message.set_token('ASSGN_ID',to_char(l_assignment_id));
7655: fnd_message.set_token('PRTT_RT_VAL_ID',to_char(p_prtt_rt_val_id));
7656: fnd_message.raise_error;
7657: --
7658: end if;

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

7651: fnd_message.set_name('BEN', 'BEN_92105_NO_PRIOR_ENROLLMENT');
7652: fnd_message.set_token('PROC',l_proc);
7653: fnd_message.set_token('ELEMENT_TYPE_ID',to_char(l_element_type_id));
7654: fnd_message.set_token('ASSGN_ID',to_char(l_assignment_id));
7655: fnd_message.set_token('PRTT_RT_VAL_ID',to_char(p_prtt_rt_val_id));
7656: fnd_message.raise_error;
7657: --
7658: end if;
7659: close get_last_element_entry;

Line 7656: fnd_message.raise_error;

7652: fnd_message.set_token('PROC',l_proc);
7653: fnd_message.set_token('ELEMENT_TYPE_ID',to_char(l_element_type_id));
7654: fnd_message.set_token('ASSGN_ID',to_char(l_assignment_id));
7655: fnd_message.set_token('PRTT_RT_VAL_ID',to_char(p_prtt_rt_val_id));
7656: fnd_message.raise_error;
7657: --
7658: end if;
7659: close get_last_element_entry;
7660:

Line 7829: l_encoded_message := fnd_message.get;

7825: when others then
7826: ben_on_line_lf_evt.get_ser_message(l_encoded_message,
7827: l_app_short_name,
7828: l_message_name);
7829: l_encoded_message := fnd_message.get;
7830: --
7831: if l_message_name like '%HR_6284_ELE_ENTRY_DT_ASG_DEL%' or
7832: l_message_name like '%HR_7187_DT_CANNOT_EXTEND_END%' then
7833: --

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

7835: --
7836: null;
7837: else
7838: if l_app_short_name is not null then
7839: fnd_message.set_name(l_app_short_name,l_message_name);
7840: fnd_message.raise_error;
7841: else
7842: raise;
7843: end if;

Line 7840: fnd_message.raise_error;

7836: null;
7837: else
7838: if l_app_short_name is not null then
7839: fnd_message.set_name(l_app_short_name,l_message_name);
7840: fnd_message.raise_error;
7841: else
7842: raise;
7843: end if;
7844: end if;

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

7994: p_person_id => p_person_id);
7995: --
7996: if fnd_global.conc_request_id in ( 0,-1) then
7997: --
7998: fnd_message.set_name('BEN',l_message_name);
7999: fnd_message.set_token('PARMA',l_element_name);
8000: fnd_message.set_token('PARMB',to_char(l_effective_date));
8001: l_string := fnd_message.get;
8002: benutils.write(p_text => l_string);

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

7995: --
7996: if fnd_global.conc_request_id in ( 0,-1) then
7997: --
7998: fnd_message.set_name('BEN',l_message_name);
7999: fnd_message.set_token('PARMA',l_element_name);
8000: fnd_message.set_token('PARMB',to_char(l_effective_date));
8001: l_string := fnd_message.get;
8002: benutils.write(p_text => l_string);
8003: --

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

7996: if fnd_global.conc_request_id in ( 0,-1) then
7997: --
7998: fnd_message.set_name('BEN',l_message_name);
7999: fnd_message.set_token('PARMA',l_element_name);
8000: fnd_message.set_token('PARMB',to_char(l_effective_date));
8001: l_string := fnd_message.get;
8002: benutils.write(p_text => l_string);
8003: --
8004: end if;

Line 8001: l_string := fnd_message.get;

7997: --
7998: fnd_message.set_name('BEN',l_message_name);
7999: fnd_message.set_token('PARMA',l_element_name);
8000: fnd_message.set_token('PARMB',to_char(l_effective_date));
8001: l_string := fnd_message.get;
8002: benutils.write(p_text => l_string);
8003: --
8004: end if;
8005:

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

8270:
8271: if g_debug then
8272: hr_utility.set_location('BEN_92106_PRTT_NO_ASGN',5);
8273: end if;
8274: fnd_message.set_name('BEN', 'BEN_92106_PRTT_NO_ASGN');
8275: fnd_message.set_token('PROC',l_proc);
8276: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
8277: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
8278: fnd_message.raise_error;

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

8271: if g_debug then
8272: hr_utility.set_location('BEN_92106_PRTT_NO_ASGN',5);
8273: end if;
8274: fnd_message.set_name('BEN', 'BEN_92106_PRTT_NO_ASGN');
8275: fnd_message.set_token('PROC',l_proc);
8276: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
8277: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
8278: fnd_message.raise_error;
8279:

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

8272: hr_utility.set_location('BEN_92106_PRTT_NO_ASGN',5);
8273: end if;
8274: fnd_message.set_name('BEN', 'BEN_92106_PRTT_NO_ASGN');
8275: fnd_message.set_token('PROC',l_proc);
8276: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
8277: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
8278: fnd_message.raise_error;
8279:
8280: end if;

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

8273: end if;
8274: fnd_message.set_name('BEN', 'BEN_92106_PRTT_NO_ASGN');
8275: fnd_message.set_token('PROC',l_proc);
8276: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
8277: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
8278: fnd_message.raise_error;
8279:
8280: end if;
8281: if g_debug then

Line 8278: fnd_message.raise_error;

8274: fnd_message.set_name('BEN', 'BEN_92106_PRTT_NO_ASGN');
8275: fnd_message.set_token('PROC',l_proc);
8276: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
8277: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
8278: fnd_message.raise_error;
8279:
8280: end if;
8281: if g_debug then
8282: hr_utility.set_location('l_assignment_id='||l_assignment_id,6);

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

8304: close get_abr_info;
8305: if g_debug then
8306: hr_utility.set_location('BEN_91723_NO_ENRT_RT_ABR_FOUND',40);
8307: end if;
8308: fnd_message.set_name('BEN','BEN_91723_NO_ENRT_RT_ABR_FOUND');
8309: fnd_message.set_token('PROC',l_proc);
8310: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
8311: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
8312: fnd_message.raise_error;

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

8305: if g_debug then
8306: hr_utility.set_location('BEN_91723_NO_ENRT_RT_ABR_FOUND',40);
8307: end if;
8308: fnd_message.set_name('BEN','BEN_91723_NO_ENRT_RT_ABR_FOUND');
8309: fnd_message.set_token('PROC',l_proc);
8310: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
8311: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
8312: fnd_message.raise_error;
8313: end if;

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

8306: hr_utility.set_location('BEN_91723_NO_ENRT_RT_ABR_FOUND',40);
8307: end if;
8308: fnd_message.set_name('BEN','BEN_91723_NO_ENRT_RT_ABR_FOUND');
8309: fnd_message.set_token('PROC',l_proc);
8310: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
8311: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
8312: fnd_message.raise_error;
8313: end if;
8314: close get_abr_info;

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

8307: end if;
8308: fnd_message.set_name('BEN','BEN_91723_NO_ENRT_RT_ABR_FOUND');
8309: fnd_message.set_token('PROC',l_proc);
8310: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
8311: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
8312: fnd_message.raise_error;
8313: end if;
8314: close get_abr_info;
8315: l_rt_end_dt := p_rt_end_date;

Line 8312: fnd_message.raise_error;

8308: fnd_message.set_name('BEN','BEN_91723_NO_ENRT_RT_ABR_FOUND');
8309: fnd_message.set_token('PROC',l_proc);
8310: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
8311: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
8312: fnd_message.raise_error;
8313: end if;
8314: close get_abr_info;
8315: l_rt_end_dt := p_rt_end_date;
8316:

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

8455: --
8456: if g_debug then
8457: hr_utility.set_location('BEN_92102_NO_ENTRY_CREATED',140);
8458: end if;
8459: fnd_message.set_name('BEN', 'BEN_92102_NO_ENTRY_CREATED');
8460: fnd_message.set_token('PROC',l_proc);
8461: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_element_entry_id));
8462: fnd_message.set_token('INPUT_VALUE_ID',to_char(p_input_value_id));
8463: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_rt_strt_date));

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

8456: if g_debug then
8457: hr_utility.set_location('BEN_92102_NO_ENTRY_CREATED',140);
8458: end if;
8459: fnd_message.set_name('BEN', 'BEN_92102_NO_ENTRY_CREATED');
8460: fnd_message.set_token('PROC',l_proc);
8461: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_element_entry_id));
8462: fnd_message.set_token('INPUT_VALUE_ID',to_char(p_input_value_id));
8463: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_rt_strt_date));
8464: fnd_message.raise_error;

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

8457: hr_utility.set_location('BEN_92102_NO_ENTRY_CREATED',140);
8458: end if;
8459: fnd_message.set_name('BEN', 'BEN_92102_NO_ENTRY_CREATED');
8460: fnd_message.set_token('PROC',l_proc);
8461: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_element_entry_id));
8462: fnd_message.set_token('INPUT_VALUE_ID',to_char(p_input_value_id));
8463: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_rt_strt_date));
8464: fnd_message.raise_error;
8465: --

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

8458: end if;
8459: fnd_message.set_name('BEN', 'BEN_92102_NO_ENTRY_CREATED');
8460: fnd_message.set_token('PROC',l_proc);
8461: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_element_entry_id));
8462: fnd_message.set_token('INPUT_VALUE_ID',to_char(p_input_value_id));
8463: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_rt_strt_date));
8464: fnd_message.raise_error;
8465: --
8466: end if;

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

8459: fnd_message.set_name('BEN', 'BEN_92102_NO_ENTRY_CREATED');
8460: fnd_message.set_token('PROC',l_proc);
8461: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_element_entry_id));
8462: fnd_message.set_token('INPUT_VALUE_ID',to_char(p_input_value_id));
8463: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_rt_strt_date));
8464: fnd_message.raise_error;
8465: --
8466: end if;
8467: close get_created_entry_value;

Line 8464: fnd_message.raise_error;

8460: fnd_message.set_token('PROC',l_proc);
8461: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_element_entry_id));
8462: fnd_message.set_token('INPUT_VALUE_ID',to_char(p_input_value_id));
8463: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_rt_strt_date));
8464: fnd_message.raise_error;
8465: --
8466: end if;
8467: close get_created_entry_value;
8468: if g_debug then

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

8480: hr_utility.set_location('BEN_92103_NO_PRTT_RT_VAL',170);
8481: end if;
8482: close c_get_prtt_rt_val;
8483: --
8484: fnd_message.set_name('BEN', 'BEN_92103_NO_PRTT_RT_VAL');
8485: fnd_message.set_token('PROC',l_proc);
8486: fnd_message.set_token('PRTT_RT_VAL',to_char(p_prtt_rt_val_id));
8487: fnd_message.raise_error;
8488: --

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

8481: end if;
8482: close c_get_prtt_rt_val;
8483: --
8484: fnd_message.set_name('BEN', 'BEN_92103_NO_PRTT_RT_VAL');
8485: fnd_message.set_token('PROC',l_proc);
8486: fnd_message.set_token('PRTT_RT_VAL',to_char(p_prtt_rt_val_id));
8487: fnd_message.raise_error;
8488: --
8489: end if;

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

8482: close c_get_prtt_rt_val;
8483: --
8484: fnd_message.set_name('BEN', 'BEN_92103_NO_PRTT_RT_VAL');
8485: fnd_message.set_token('PROC',l_proc);
8486: fnd_message.set_token('PRTT_RT_VAL',to_char(p_prtt_rt_val_id));
8487: fnd_message.raise_error;
8488: --
8489: end if;
8490: close c_get_prtt_rt_val;

Line 8487: fnd_message.raise_error;

8483: --
8484: fnd_message.set_name('BEN', 'BEN_92103_NO_PRTT_RT_VAL');
8485: fnd_message.set_token('PROC',l_proc);
8486: fnd_message.set_token('PRTT_RT_VAL',to_char(p_prtt_rt_val_id));
8487: fnd_message.raise_error;
8488: --
8489: end if;
8490: close c_get_prtt_rt_val;
8491: --

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

9049: hr_utility.set_location('BEN_92103_NO_PRTT_RT_VAL',170);
9050: end if;
9051: close c_get_prtt_rt_val;
9052: --
9053: fnd_message.set_name('BEN', 'BEN_92103_NO_PRTT_RT_VAL');
9054: fnd_message.set_token('PROC',l_proc);
9055: fnd_message.set_token('PRTT_RT_VAL',to_char(p_prtt_rt_val_id));
9056: fnd_message.raise_error;
9057: --

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

9050: end if;
9051: close c_get_prtt_rt_val;
9052: --
9053: fnd_message.set_name('BEN', 'BEN_92103_NO_PRTT_RT_VAL');
9054: fnd_message.set_token('PROC',l_proc);
9055: fnd_message.set_token('PRTT_RT_VAL',to_char(p_prtt_rt_val_id));
9056: fnd_message.raise_error;
9057: --
9058: end if;

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

9051: close c_get_prtt_rt_val;
9052: --
9053: fnd_message.set_name('BEN', 'BEN_92103_NO_PRTT_RT_VAL');
9054: fnd_message.set_token('PROC',l_proc);
9055: fnd_message.set_token('PRTT_RT_VAL',to_char(p_prtt_rt_val_id));
9056: fnd_message.raise_error;
9057: --
9058: end if;
9059: close c_get_prtt_rt_val;

Line 9056: fnd_message.raise_error;

9052: --
9053: fnd_message.set_name('BEN', 'BEN_92103_NO_PRTT_RT_VAL');
9054: fnd_message.set_token('PROC',l_proc);
9055: fnd_message.set_token('PRTT_RT_VAL',to_char(p_prtt_rt_val_id));
9056: fnd_message.raise_error;
9057: --
9058: end if;
9059: close c_get_prtt_rt_val;
9060: --

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

9121: close get_abr_info;
9122: if g_debug then
9123: hr_utility.set_location('BEN_91723_NO_ENRT_RT_ABR_FOUND',40);
9124: end if;
9125: fnd_message.set_name('BEN','BEN_91723_NO_ENRT_RT_ABR_FOUND');
9126: fnd_message.set_token('PROC',l_proc);
9127: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
9128: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
9129: fnd_message.raise_error;

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

9122: if g_debug then
9123: hr_utility.set_location('BEN_91723_NO_ENRT_RT_ABR_FOUND',40);
9124: end if;
9125: fnd_message.set_name('BEN','BEN_91723_NO_ENRT_RT_ABR_FOUND');
9126: fnd_message.set_token('PROC',l_proc);
9127: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
9128: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
9129: fnd_message.raise_error;
9130: end if;

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

9123: hr_utility.set_location('BEN_91723_NO_ENRT_RT_ABR_FOUND',40);
9124: end if;
9125: fnd_message.set_name('BEN','BEN_91723_NO_ENRT_RT_ABR_FOUND');
9126: fnd_message.set_token('PROC',l_proc);
9127: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
9128: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
9129: fnd_message.raise_error;
9130: end if;
9131: close get_abr_info;

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

9124: end if;
9125: fnd_message.set_name('BEN','BEN_91723_NO_ENRT_RT_ABR_FOUND');
9126: fnd_message.set_token('PROC',l_proc);
9127: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
9128: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
9129: fnd_message.raise_error;
9130: end if;
9131: close get_abr_info;
9132:

Line 9129: fnd_message.raise_error;

9125: fnd_message.set_name('BEN','BEN_91723_NO_ENRT_RT_ABR_FOUND');
9126: fnd_message.set_token('PROC',l_proc);
9127: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
9128: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
9129: fnd_message.raise_error;
9130: end if;
9131: close get_abr_info;
9132:
9133: hr_utility.set_location('l_abr_rcrrg_cd '||l_abr_rcrrg_cd,40);

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

9176: p_person_id => p_person_id);
9177: --
9178: if fnd_global.conc_request_id in ( 0,-1) then
9179: --
9180: fnd_message.set_name('BEN','BEN_93455_ELE_ALREADY_ENDED');
9181: fnd_message.set_token('PARMA',l_element_name);
9182: fnd_message.set_token('PARMB',to_char(l_effective_date));
9183: l_string := fnd_message.get;
9184: benutils.write(p_text => l_string);

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

9177: --
9178: if fnd_global.conc_request_id in ( 0,-1) then
9179: --
9180: fnd_message.set_name('BEN','BEN_93455_ELE_ALREADY_ENDED');
9181: fnd_message.set_token('PARMA',l_element_name);
9182: fnd_message.set_token('PARMB',to_char(l_effective_date));
9183: l_string := fnd_message.get;
9184: benutils.write(p_text => l_string);
9185: --

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

9178: if fnd_global.conc_request_id in ( 0,-1) then
9179: --
9180: fnd_message.set_name('BEN','BEN_93455_ELE_ALREADY_ENDED');
9181: fnd_message.set_token('PARMA',l_element_name);
9182: fnd_message.set_token('PARMB',to_char(l_effective_date));
9183: l_string := fnd_message.get;
9184: benutils.write(p_text => l_string);
9185: --
9186: end if;

Line 9183: l_string := fnd_message.get;

9179: --
9180: fnd_message.set_name('BEN','BEN_93455_ELE_ALREADY_ENDED');
9181: fnd_message.set_token('PARMA',l_element_name);
9182: fnd_message.set_token('PARMB',to_char(l_effective_date));
9183: l_string := fnd_message.get;
9184: benutils.write(p_text => l_string);
9185: --
9186: end if;
9187: --

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

9287: p_person_id => p_person_id);
9288:
9289: if fnd_global.conc_request_id not in ( 0,-1) then
9290: --
9291: fnd_message.set_name('BEN','BEN_92456_END_RUN_RESULTS');
9292: fnd_message.set_token('PARMA',fnd_date.date_to_chardate(g_max_end_date,calendar_aware=>2));
9293: l_string := fnd_message.get;
9294: benutils.write(p_text => l_string);
9295: --

Line 9292: fnd_message.set_token('PARMA',fnd_date.date_to_chardate(g_max_end_date,calendar_aware=>2));

9288:
9289: if fnd_global.conc_request_id not in ( 0,-1) then
9290: --
9291: fnd_message.set_name('BEN','BEN_92456_END_RUN_RESULTS');
9292: fnd_message.set_token('PARMA',fnd_date.date_to_chardate(g_max_end_date,calendar_aware=>2));
9293: l_string := fnd_message.get;
9294: benutils.write(p_text => l_string);
9295: --
9296: end if;

Line 9293: l_string := fnd_message.get;

9289: if fnd_global.conc_request_id not in ( 0,-1) then
9290: --
9291: fnd_message.set_name('BEN','BEN_92456_END_RUN_RESULTS');
9292: fnd_message.set_token('PARMA',fnd_date.date_to_chardate(g_max_end_date,calendar_aware=>2));
9293: l_string := fnd_message.get;
9294: benutils.write(p_text => l_string);
9295: --
9296: end if;
9297: g_msg_displayed :=1;

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

9837: when others then
9838: if g_debug then
9839: hr_utility.set_location('BEN_92311_FORMULA_VAL_PARAM',46);
9840: end if;
9841: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
9842: fnd_message.set_token('PROC',l_proc);
9843: fnd_message.set_token('FORMULA',l_prtl_mo_det_mthd_rl);
9844: fnd_message.set_token('PARAMETER',
9845: l_outputs(l_outputs.first).name);

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

9838: if g_debug then
9839: hr_utility.set_location('BEN_92311_FORMULA_VAL_PARAM',46);
9840: end if;
9841: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
9842: fnd_message.set_token('PROC',l_proc);
9843: fnd_message.set_token('FORMULA',l_prtl_mo_det_mthd_rl);
9844: fnd_message.set_token('PARAMETER',
9845: l_outputs(l_outputs.first).name);
9846: fnd_message.raise_error;

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

9839: hr_utility.set_location('BEN_92311_FORMULA_VAL_PARAM',46);
9840: end if;
9841: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
9842: fnd_message.set_token('PROC',l_proc);
9843: fnd_message.set_token('FORMULA',l_prtl_mo_det_mthd_rl);
9844: fnd_message.set_token('PARAMETER',
9845: l_outputs(l_outputs.first).name);
9846: fnd_message.raise_error;
9847: --

Line 9844: fnd_message.set_token('PARAMETER',

9840: end if;
9841: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
9842: fnd_message.set_token('PROC',l_proc);
9843: fnd_message.set_token('FORMULA',l_prtl_mo_det_mthd_rl);
9844: fnd_message.set_token('PARAMETER',
9845: l_outputs(l_outputs.first).name);
9846: fnd_message.raise_error;
9847: --
9848: end;

Line 9846: fnd_message.raise_error;

9842: fnd_message.set_token('PROC',l_proc);
9843: fnd_message.set_token('FORMULA',l_prtl_mo_det_mthd_rl);
9844: fnd_message.set_token('PARAMETER',
9845: l_outputs(l_outputs.first).name);
9846: fnd_message.raise_error;
9847: --
9848: end;
9849: end if;
9850: --

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

9951: close c_get_current_pp;
9952: if g_debug then
9953: hr_utility.set_location('BEN_92346_PAYROLL_NOT_DEFINED',48);
9954: end if;
9955: fnd_message.set_name('BEN', 'BEN_92346_PAYROLL_NOT_DEFINED');
9956: fnd_message.set_token('PROC',l_proc);
9957: fnd_message.raise_error;
9958: end if;
9959: --

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

9952: if g_debug then
9953: hr_utility.set_location('BEN_92346_PAYROLL_NOT_DEFINED',48);
9954: end if;
9955: fnd_message.set_name('BEN', 'BEN_92346_PAYROLL_NOT_DEFINED');
9956: fnd_message.set_token('PROC',l_proc);
9957: fnd_message.raise_error;
9958: end if;
9959: --
9960: close c_get_current_pp;

Line 9957: fnd_message.raise_error;

9953: hr_utility.set_location('BEN_92346_PAYROLL_NOT_DEFINED',48);
9954: end if;
9955: fnd_message.set_name('BEN', 'BEN_92346_PAYROLL_NOT_DEFINED');
9956: fnd_message.set_token('PROC',l_proc);
9957: fnd_message.raise_error;
9958: end if;
9959: --
9960: close c_get_current_pp;
9961: --

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

9991: (p_application_short_name => 'BEN',
9992: p_message_name => 'BEN_92939_NO_PRORATION',
9993: p_person_id => p_person_id);
9994: --
9995: fnd_message.set_name('BEN', 'BEN_92939_NO_PRORATION');
9996: if fnd_global.conc_request_id <> -1 then
9997: benutils.write(fnd_message.get);
9998: end if;
9999: --

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

9993: p_person_id => p_person_id);
9994: --
9995: fnd_message.set_name('BEN', 'BEN_92939_NO_PRORATION');
9996: if fnd_global.conc_request_id <> -1 then
9997: benutils.write(fnd_message.get);
9998: end if;
9999: --
10000: l_immediate_end := true;
10001: end if;

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

10015: close c_get_current_pp;
10016: if g_debug then
10017: hr_utility.set_location('BEN_92346_PAYROLL_NOT_DEFINED',48);
10018: end if;
10019: fnd_message.set_name('BEN', 'BEN_92346_PAYROLL_NOT_DEFINED');
10020: fnd_message.set_token('PROC',l_proc);
10021: fnd_message.raise_error;
10022: end if;
10023: --

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

10016: if g_debug then
10017: hr_utility.set_location('BEN_92346_PAYROLL_NOT_DEFINED',48);
10018: end if;
10019: fnd_message.set_name('BEN', 'BEN_92346_PAYROLL_NOT_DEFINED');
10020: fnd_message.set_token('PROC',l_proc);
10021: fnd_message.raise_error;
10022: end if;
10023: --
10024: close c_get_current_pp;

Line 10021: fnd_message.raise_error;

10017: hr_utility.set_location('BEN_92346_PAYROLL_NOT_DEFINED',48);
10018: end if;
10019: fnd_message.set_name('BEN', 'BEN_92346_PAYROLL_NOT_DEFINED');
10020: fnd_message.set_token('PROC',l_proc);
10021: fnd_message.raise_error;
10022: end if;
10023: --
10024: close c_get_current_pp;
10025: end if; -- l_remainder > 0

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

10040: close c_pps_prev_month;
10041: if g_debug then
10042: hr_utility.set_location('BEN_92346_PAYROLL_NOT_DEFINED',50);
10043: end if;
10044: fnd_message.set_name('BEN', 'BEN_92346_PAYROLL_NOT_DEFINED');
10045: fnd_message.set_token('PROC',l_proc);
10046: fnd_message.raise_error;
10047: end if;
10048: hr_elements.check_element_freq(

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

10041: if g_debug then
10042: hr_utility.set_location('BEN_92346_PAYROLL_NOT_DEFINED',50);
10043: end if;
10044: fnd_message.set_name('BEN', 'BEN_92346_PAYROLL_NOT_DEFINED');
10045: fnd_message.set_token('PROC',l_proc);
10046: fnd_message.raise_error;
10047: end if;
10048: hr_elements.check_element_freq(
10049: p_payroll_id =>l_payroll_id,

Line 10046: fnd_message.raise_error;

10042: hr_utility.set_location('BEN_92346_PAYROLL_NOT_DEFINED',50);
10043: end if;
10044: fnd_message.set_name('BEN', 'BEN_92346_PAYROLL_NOT_DEFINED');
10045: fnd_message.set_token('PROC',l_proc);
10046: fnd_message.raise_error;
10047: end if;
10048: hr_elements.check_element_freq(
10049: p_payroll_id =>l_payroll_id,
10050: p_bg_id =>p_business_group_id,

Line 10543: fnd_message.raise_error;

10539: if l_element_link_id is null then
10540: --
10541: -- error message already set on stack.
10542: --
10543: fnd_message.raise_error;
10544: end if;
10545: hr_utility.set_location( 'entering', 30.2);
10546: py_element_entry_api.create_element_entry
10547: (p_validate =>p_validate

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

10605: --
10606: if g_debug then
10607: hr_utility.set_location('BEN_92102_NO_ENTRY_CREATED',140);
10608: end if;
10609: fnd_message.set_name('BEN', 'BEN_92102_NO_ENTRY_CREATED');
10610: fnd_message.set_token('PROC','Create_reimburse_element');
10611: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_element_link_id));
10612: fnd_message.set_token('INPUT_VALUE_ID',to_char(l_input_value_id));
10613: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));

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

10606: if g_debug then
10607: hr_utility.set_location('BEN_92102_NO_ENTRY_CREATED',140);
10608: end if;
10609: fnd_message.set_name('BEN', 'BEN_92102_NO_ENTRY_CREATED');
10610: fnd_message.set_token('PROC','Create_reimburse_element');
10611: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_element_link_id));
10612: fnd_message.set_token('INPUT_VALUE_ID',to_char(l_input_value_id));
10613: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
10614: fnd_message.raise_error;

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

10607: hr_utility.set_location('BEN_92102_NO_ENTRY_CREATED',140);
10608: end if;
10609: fnd_message.set_name('BEN', 'BEN_92102_NO_ENTRY_CREATED');
10610: fnd_message.set_token('PROC','Create_reimburse_element');
10611: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_element_link_id));
10612: fnd_message.set_token('INPUT_VALUE_ID',to_char(l_input_value_id));
10613: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
10614: fnd_message.raise_error;
10615: else

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

10608: end if;
10609: fnd_message.set_name('BEN', 'BEN_92102_NO_ENTRY_CREATED');
10610: fnd_message.set_token('PROC','Create_reimburse_element');
10611: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_element_link_id));
10612: fnd_message.set_token('INPUT_VALUE_ID',to_char(l_input_value_id));
10613: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
10614: fnd_message.raise_error;
10615: else
10616: --

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

10609: fnd_message.set_name('BEN', 'BEN_92102_NO_ENTRY_CREATED');
10610: fnd_message.set_token('PROC','Create_reimburse_element');
10611: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_element_link_id));
10612: fnd_message.set_token('INPUT_VALUE_ID',to_char(l_input_value_id));
10613: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
10614: fnd_message.raise_error;
10615: else
10616: --
10617: ben_prtt_rmt_aprvd_pymt_api.update_prtt_rmt_aprvd_pymt

Line 10614: fnd_message.raise_error;

10610: fnd_message.set_token('PROC','Create_reimburse_element');
10611: fnd_message.set_token('ELEMENT_ENTRY_ID',to_char(l_element_link_id));
10612: fnd_message.set_token('INPUT_VALUE_ID',to_char(l_input_value_id));
10613: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
10614: fnd_message.raise_error;
10615: else
10616: --
10617: ben_prtt_rmt_aprvd_pymt_api.update_prtt_rmt_aprvd_pymt
10618: (p_prtt_rmt_aprvd_fr_pymt_id => p_prtt_rmt_aprvd_fr_pymt_id,

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

10700: p_effective_date), 1,1) ;
10701: --
10702: if l_processed_flag = 'Y' then
10703: --
10704: fnd_message.set_name ('BEN','BEN_93341_PRCCSD_IN_PAYROLL');
10705: fnd_message.raise_error;
10706: --
10707: end if;
10708: --

Line 10705: fnd_message.raise_error;

10701: --
10702: if l_processed_flag = 'Y' then
10703: --
10704: fnd_message.set_name ('BEN','BEN_93341_PRCCSD_IN_PAYROLL');
10705: fnd_message.raise_error;
10706: --
10707: end if;
10708: --
10709: open c_element_entry (l_ele_rec.element_entry_id);