eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_DETERMINE_COMMUNICATIONS dependencies on FND_MESSAGE

Line 468: fnd_message.set_name('BEN', 'BEN_92163_BENTMPCM_ERR_LMT');

464: --
465: exception
466: --
467: when error_limit then
468: fnd_message.set_name('BEN', 'BEN_92163_BENTMPCM_ERR_LMT');
469: fnd_message.set_token('PROC',l_proc);
470: benutils.write(p_text => fnd_message.get);
471: raise;
472: --

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

465: exception
466: --
467: when error_limit then
468: fnd_message.set_name('BEN', 'BEN_92163_BENTMPCM_ERR_LMT');
469: fnd_message.set_token('PROC',l_proc);
470: benutils.write(p_text => fnd_message.get);
471: raise;
472: --
473: end person_error_cnt;

Line 470: benutils.write(p_text => fnd_message.get);

466: --
467: when error_limit then
468: fnd_message.set_name('BEN', 'BEN_92163_BENTMPCM_ERR_LMT');
469: fnd_message.set_token('PROC',l_proc);
470: benutils.write(p_text => fnd_message.get);
471: raise;
472: --
473: end person_error_cnt;
474: --

Line 505: fnd_message.set_name('BEN','BEN_91663_BENMNGLE_LOGGING');

501: --
502: when others then
503: --
504: benutils.write(p_text => sqlerrm);
505: fnd_message.set_name('BEN','BEN_91663_BENMNGLE_LOGGING');
506: fnd_message.set_token('PROC',l_proc);
507: benutils.write(p_text => fnd_message.get);
508: fnd_message.raise_error;
509: --

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

502: when others then
503: --
504: benutils.write(p_text => sqlerrm);
505: fnd_message.set_name('BEN','BEN_91663_BENMNGLE_LOGGING');
506: fnd_message.set_token('PROC',l_proc);
507: benutils.write(p_text => fnd_message.get);
508: fnd_message.raise_error;
509: --
510: end write_logfile;

Line 507: benutils.write(p_text => fnd_message.get);

503: --
504: benutils.write(p_text => sqlerrm);
505: fnd_message.set_name('BEN','BEN_91663_BENMNGLE_LOGGING');
506: fnd_message.set_token('PROC',l_proc);
507: benutils.write(p_text => fnd_message.get);
508: fnd_message.raise_error;
509: --
510: end write_logfile;
511: --

Line 508: fnd_message.raise_error;

504: benutils.write(p_text => sqlerrm);
505: fnd_message.set_name('BEN','BEN_91663_BENMNGLE_LOGGING');
506: fnd_message.set_token('PROC',l_proc);
507: benutils.write(p_text => fnd_message.get);
508: fnd_message.raise_error;
509: --
510: end write_logfile;
511: --
512: -- ----------------------------------------------------------------------------

Line 1332: fnd_message.set_name('BEN','BEN_92182_COMM_GNRTD');

1328: --
1329: if ben_generate_communications.g_comm_generated then
1330: --
1331: g_rec.rep_typ_cd := 'COMMU';
1332: fnd_message.set_name('BEN','BEN_92182_COMM_GNRTD');
1333: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1334: g_rec.text := fnd_message.get;
1335: --
1336: else

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

1329: if ben_generate_communications.g_comm_generated then
1330: --
1331: g_rec.rep_typ_cd := 'COMMU';
1332: fnd_message.set_name('BEN','BEN_92182_COMM_GNRTD');
1333: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1334: g_rec.text := fnd_message.get;
1335: --
1336: else
1337: --

Line 1334: g_rec.text := fnd_message.get;

1330: --
1331: g_rec.rep_typ_cd := 'COMMU';
1332: fnd_message.set_name('BEN','BEN_92182_COMM_GNRTD');
1333: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1334: g_rec.text := fnd_message.get;
1335: --
1336: else
1337: --
1338: g_rec.rep_typ_cd := 'NOCOMMU';

Line 1339: fnd_message.set_name('BEN','BEN_92183_NO_COMM_GNRTD');

1335: --
1336: else
1337: --
1338: g_rec.rep_typ_cd := 'NOCOMMU';
1339: fnd_message.set_name('BEN','BEN_92183_NO_COMM_GNRTD');
1340: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1341: g_rec.text := fnd_message.get;
1342: --
1343: end if;

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

1336: else
1337: --
1338: g_rec.rep_typ_cd := 'NOCOMMU';
1339: fnd_message.set_name('BEN','BEN_92183_NO_COMM_GNRTD');
1340: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1341: g_rec.text := fnd_message.get;
1342: --
1343: end if;
1344: --

Line 1341: g_rec.text := fnd_message.get;

1337: --
1338: g_rec.rep_typ_cd := 'NOCOMMU';
1339: fnd_message.set_name('BEN','BEN_92183_NO_COMM_GNRTD');
1340: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1341: g_rec.text := fnd_message.get;
1342: --
1343: end if;
1344: --
1345: benutils.write(p_rec => g_rec);

Line 1613: fnd_message.set_name('BEN','BEN_91745_RULE_AND_PERSON');

1609: -- p_person_selection_rule_id and p_person_id are mutually exclusive
1610: --
1611: if g_parm.person_id is not null and
1612: g_parm.person_sel_rl is not null then
1613: fnd_message.set_name('BEN','BEN_91745_RULE_AND_PERSON');
1614: fnd_message.set_token('PROC',l_proc);
1615: fnd_message.set_token('PERSON_ID',to_char(g_parm.person_id));
1616: fnd_message.set_token('PER_SELECT_RL',
1617: 'person_selection_rule :'||g_parm.person_sel_rl);

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

1610: --
1611: if g_parm.person_id is not null and
1612: g_parm.person_sel_rl is not null then
1613: fnd_message.set_name('BEN','BEN_91745_RULE_AND_PERSON');
1614: fnd_message.set_token('PROC',l_proc);
1615: fnd_message.set_token('PERSON_ID',to_char(g_parm.person_id));
1616: fnd_message.set_token('PER_SELECT_RL',
1617: 'person_selection_rule :'||g_parm.person_sel_rl);
1618: fnd_message.raise_error;

Line 1615: fnd_message.set_token('PERSON_ID',to_char(g_parm.person_id));

1611: if g_parm.person_id is not null and
1612: g_parm.person_sel_rl is not null then
1613: fnd_message.set_name('BEN','BEN_91745_RULE_AND_PERSON');
1614: fnd_message.set_token('PROC',l_proc);
1615: fnd_message.set_token('PERSON_ID',to_char(g_parm.person_id));
1616: fnd_message.set_token('PER_SELECT_RL',
1617: 'person_selection_rule :'||g_parm.person_sel_rl);
1618: fnd_message.raise_error;
1619: end if;

Line 1616: fnd_message.set_token('PER_SELECT_RL',

1612: g_parm.person_sel_rl is not null then
1613: fnd_message.set_name('BEN','BEN_91745_RULE_AND_PERSON');
1614: fnd_message.set_token('PROC',l_proc);
1615: fnd_message.set_token('PERSON_ID',to_char(g_parm.person_id));
1616: fnd_message.set_token('PER_SELECT_RL',
1617: 'person_selection_rule :'||g_parm.person_sel_rl);
1618: fnd_message.raise_error;
1619: end if;
1620: --

Line 1618: fnd_message.raise_error;

1614: fnd_message.set_token('PROC',l_proc);
1615: fnd_message.set_token('PERSON_ID',to_char(g_parm.person_id));
1616: fnd_message.set_token('PER_SELECT_RL',
1617: 'person_selection_rule :'||g_parm.person_sel_rl);
1618: fnd_message.raise_error;
1619: end if;
1620: --
1621: -- p_person_id must be of p_person_type_id specified
1622: --

Line 1631: fnd_message.set_name('BEN','BEN_91748_PERSON_TYPE');

1627: --
1628: if not(verify_person_type_id(p_person_id => g_parm.person_id,
1629: p_person_type_id => g_parm.person_type_id)) then
1630: --
1631: fnd_message.set_name('BEN','BEN_91748_PERSON_TYPE');
1632: fnd_message.set_token('PROC',l_proc);
1633: fnd_message.set_token('PERSON_ID',to_char(g_parm.person_id));
1634: fnd_message.set_token('PER_TYPE_ID',to_char(g_parm.person_type_id));
1635: fnd_message.raise_error;

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

1628: if not(verify_person_type_id(p_person_id => g_parm.person_id,
1629: p_person_type_id => g_parm.person_type_id)) then
1630: --
1631: fnd_message.set_name('BEN','BEN_91748_PERSON_TYPE');
1632: fnd_message.set_token('PROC',l_proc);
1633: fnd_message.set_token('PERSON_ID',to_char(g_parm.person_id));
1634: fnd_message.set_token('PER_TYPE_ID',to_char(g_parm.person_type_id));
1635: fnd_message.raise_error;
1636: --

Line 1633: fnd_message.set_token('PERSON_ID',to_char(g_parm.person_id));

1629: p_person_type_id => g_parm.person_type_id)) then
1630: --
1631: fnd_message.set_name('BEN','BEN_91748_PERSON_TYPE');
1632: fnd_message.set_token('PROC',l_proc);
1633: fnd_message.set_token('PERSON_ID',to_char(g_parm.person_id));
1634: fnd_message.set_token('PER_TYPE_ID',to_char(g_parm.person_type_id));
1635: fnd_message.raise_error;
1636: --
1637: end if;

Line 1634: fnd_message.set_token('PER_TYPE_ID',to_char(g_parm.person_type_id));

1630: --
1631: fnd_message.set_name('BEN','BEN_91748_PERSON_TYPE');
1632: fnd_message.set_token('PROC',l_proc);
1633: fnd_message.set_token('PERSON_ID',to_char(g_parm.person_id));
1634: fnd_message.set_token('PER_TYPE_ID',to_char(g_parm.person_type_id));
1635: fnd_message.raise_error;
1636: --
1637: end if;
1638: --

Line 1635: fnd_message.raise_error;

1631: fnd_message.set_name('BEN','BEN_91748_PERSON_TYPE');
1632: fnd_message.set_token('PROC',l_proc);
1633: fnd_message.set_token('PERSON_ID',to_char(g_parm.person_id));
1634: fnd_message.set_token('PER_TYPE_ID',to_char(g_parm.person_type_id));
1635: fnd_message.raise_error;
1636: --
1637: end if;
1638: --
1639: end if;

Line 1646: fnd_message.set_name('BEN', 'BEN_92164_PLN_NIP_PGM_NULL');

1642: --
1643: if g_parm.plan_in_pgm_flag = 'N' and
1644: g_parm.pgm_id is not null then
1645: --
1646: fnd_message.set_name('BEN', 'BEN_92164_PLN_NIP_PGM_NULL');
1647: -- If you specify a plan as not in a program then the program should be blank.
1648: fnd_message.set_token('PROC',l_proc);
1649: fnd_message.raise_error;
1650: --

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

1644: g_parm.pgm_id is not null then
1645: --
1646: fnd_message.set_name('BEN', 'BEN_92164_PLN_NIP_PGM_NULL');
1647: -- If you specify a plan as not in a program then the program should be blank.
1648: fnd_message.set_token('PROC',l_proc);
1649: fnd_message.raise_error;
1650: --
1651: end if;
1652: --

Line 1649: fnd_message.raise_error;

1645: --
1646: fnd_message.set_name('BEN', 'BEN_92164_PLN_NIP_PGM_NULL');
1647: -- If you specify a plan as not in a program then the program should be blank.
1648: fnd_message.set_token('PROC',l_proc);
1649: fnd_message.raise_error;
1650: --
1651: end if;
1652: --
1653: -- Business rule for the emerging event trigger type:

Line 1666: fnd_message.set_name('BEN','BEN_92165_ATLEAST_ONE_FCTR');

1662: g_parm.los_fctr_id is null and
1663: g_parm.min_los is null and
1664: g_parm.max_los is null and
1665: g_parm.cmbn_age_los_fctr_id is null then
1666: fnd_message.set_name('BEN','BEN_92165_ATLEAST_ONE_FCTR');
1667: fnd_message.set_token('PROC',l_proc);
1668: fnd_message.raise_error;
1669: end if;
1670: --

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

1663: g_parm.min_los is null and
1664: g_parm.max_los is null and
1665: g_parm.cmbn_age_los_fctr_id is null then
1666: fnd_message.set_name('BEN','BEN_92165_ATLEAST_ONE_FCTR');
1667: fnd_message.set_token('PROC',l_proc);
1668: fnd_message.raise_error;
1669: end if;
1670: --
1671: -- If evaluating LOS then check if the person type is compatible.

Line 1668: fnd_message.raise_error;

1664: g_parm.max_los is null and
1665: g_parm.cmbn_age_los_fctr_id is null then
1666: fnd_message.set_name('BEN','BEN_92165_ATLEAST_ONE_FCTR');
1667: fnd_message.set_token('PROC',l_proc);
1668: fnd_message.raise_error;
1669: end if;
1670: --
1671: -- If evaluating LOS then check if the person type is compatible.
1672: --

Line 1687: fnd_message.set_name('BEN','BEN_92166_INVLD_PER_TYPE');

1683: or l_person_type = 'OTHER' -- External, Contact
1684: or l_person_type = 'APL' -- Applicant
1685: then
1686: --
1687: fnd_message.set_name('BEN','BEN_92166_INVLD_PER_TYPE');
1688: fnd_message.set_token('PROC',l_proc);
1689: fnd_message.set_token('PER_TYP',l_person_type);
1690: fnd_message.raise_error;
1691: --

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

1684: or l_person_type = 'APL' -- Applicant
1685: then
1686: --
1687: fnd_message.set_name('BEN','BEN_92166_INVLD_PER_TYPE');
1688: fnd_message.set_token('PROC',l_proc);
1689: fnd_message.set_token('PER_TYP',l_person_type);
1690: fnd_message.raise_error;
1691: --
1692: end if;

Line 1689: fnd_message.set_token('PER_TYP',l_person_type);

1685: then
1686: --
1687: fnd_message.set_name('BEN','BEN_92166_INVLD_PER_TYPE');
1688: fnd_message.set_token('PROC',l_proc);
1689: fnd_message.set_token('PER_TYP',l_person_type);
1690: fnd_message.raise_error;
1691: --
1692: end if;
1693: --

Line 1690: fnd_message.raise_error;

1686: --
1687: fnd_message.set_name('BEN','BEN_92166_INVLD_PER_TYPE');
1688: fnd_message.set_token('PROC',l_proc);
1689: fnd_message.set_token('PER_TYP',l_person_type);
1690: fnd_message.raise_error;
1691: --
1692: end if;
1693: --
1694: end if;

Line 1706: fnd_message.set_name('BEN', 'BEN_92167_NO_MINMAX_WHEN_FCTR');

1702: --
1703: if g_parm.min_age is not null or
1704: g_parm.max_age is not null then
1705: --
1706: fnd_message.set_name('BEN', 'BEN_92167_NO_MINMAX_WHEN_FCTR');
1707: fnd_message.set_token('PROC',l_proc);
1708: fnd_message.set_token('MIN','Min Age : '||g_parm.min_age);
1709: fnd_message.set_token('MAX','Max Age : '||g_parm.max_age);
1710: --

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

1703: if g_parm.min_age is not null or
1704: g_parm.max_age is not null then
1705: --
1706: fnd_message.set_name('BEN', 'BEN_92167_NO_MINMAX_WHEN_FCTR');
1707: fnd_message.set_token('PROC',l_proc);
1708: fnd_message.set_token('MIN','Min Age : '||g_parm.min_age);
1709: fnd_message.set_token('MAX','Max Age : '||g_parm.max_age);
1710: --
1711: -- Do not specify the min and max values when selecting a predefined

Line 1708: fnd_message.set_token('MIN','Min Age : '||g_parm.min_age);

1704: g_parm.max_age is not null then
1705: --
1706: fnd_message.set_name('BEN', 'BEN_92167_NO_MINMAX_WHEN_FCTR');
1707: fnd_message.set_token('PROC',l_proc);
1708: fnd_message.set_token('MIN','Min Age : '||g_parm.min_age);
1709: fnd_message.set_token('MAX','Max Age : '||g_parm.max_age);
1710: --
1711: -- Do not specify the min and max values when selecting a predefined
1712: -- FCTR factor.

Line 1709: fnd_message.set_token('MAX','Max Age : '||g_parm.max_age);

1705: --
1706: fnd_message.set_name('BEN', 'BEN_92167_NO_MINMAX_WHEN_FCTR');
1707: fnd_message.set_token('PROC',l_proc);
1708: fnd_message.set_token('MIN','Min Age : '||g_parm.min_age);
1709: fnd_message.set_token('MAX','Max Age : '||g_parm.max_age);
1710: --
1711: -- Do not specify the min and max values when selecting a predefined
1712: -- FCTR factor.
1713: --

Line 1714: fnd_message.raise_error;

1710: --
1711: -- Do not specify the min and max values when selecting a predefined
1712: -- FCTR factor.
1713: --
1714: fnd_message.raise_error;
1715: --
1716: end if;
1717: --
1718: if g_parm.los_fctr_id is not null or

Line 1722: fnd_message.set_name('BEN', 'BEN_92168_ONLY_ONE_FCTR');

1718: if g_parm.los_fctr_id is not null or
1719: g_parm.min_los is not null or
1720: g_parm.max_los is not null or
1721: g_parm.cmbn_age_los_fctr_id is not null then
1722: fnd_message.set_name('BEN', 'BEN_92168_ONLY_ONE_FCTR');
1723: fnd_message.set_token('PROC',l_proc);
1724: fnd_message.set_token('LOS_FCTR_ID',to_char(g_parm.los_fctr_id));
1725: fnd_message.set_token('AGE_FCTR_ID',to_char(g_parm.age_fctr_id));
1726: fnd_message.set_token('MIN_LOS',to_char(g_parm.min_los));

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

1719: g_parm.min_los is not null or
1720: g_parm.max_los is not null or
1721: g_parm.cmbn_age_los_fctr_id is not null then
1722: fnd_message.set_name('BEN', 'BEN_92168_ONLY_ONE_FCTR');
1723: fnd_message.set_token('PROC',l_proc);
1724: fnd_message.set_token('LOS_FCTR_ID',to_char(g_parm.los_fctr_id));
1725: fnd_message.set_token('AGE_FCTR_ID',to_char(g_parm.age_fctr_id));
1726: fnd_message.set_token('MIN_LOS',to_char(g_parm.min_los));
1727: fnd_message.set_token('MAX_LOS',to_char(g_parm.max_los));

Line 1724: fnd_message.set_token('LOS_FCTR_ID',to_char(g_parm.los_fctr_id));

1720: g_parm.max_los is not null or
1721: g_parm.cmbn_age_los_fctr_id is not null then
1722: fnd_message.set_name('BEN', 'BEN_92168_ONLY_ONE_FCTR');
1723: fnd_message.set_token('PROC',l_proc);
1724: fnd_message.set_token('LOS_FCTR_ID',to_char(g_parm.los_fctr_id));
1725: fnd_message.set_token('AGE_FCTR_ID',to_char(g_parm.age_fctr_id));
1726: fnd_message.set_token('MIN_LOS',to_char(g_parm.min_los));
1727: fnd_message.set_token('MAX_LOS',to_char(g_parm.max_los));
1728: fnd_message.set_token('MIN_AGE',to_char(g_parm.min_age));

Line 1725: fnd_message.set_token('AGE_FCTR_ID',to_char(g_parm.age_fctr_id));

1721: g_parm.cmbn_age_los_fctr_id is not null then
1722: fnd_message.set_name('BEN', 'BEN_92168_ONLY_ONE_FCTR');
1723: fnd_message.set_token('PROC',l_proc);
1724: fnd_message.set_token('LOS_FCTR_ID',to_char(g_parm.los_fctr_id));
1725: fnd_message.set_token('AGE_FCTR_ID',to_char(g_parm.age_fctr_id));
1726: fnd_message.set_token('MIN_LOS',to_char(g_parm.min_los));
1727: fnd_message.set_token('MAX_LOS',to_char(g_parm.max_los));
1728: fnd_message.set_token('MIN_AGE',to_char(g_parm.min_age));
1729: fnd_message.set_token('MAX_AGE',to_char(g_parm.max_age));

Line 1726: fnd_message.set_token('MIN_LOS',to_char(g_parm.min_los));

1722: fnd_message.set_name('BEN', 'BEN_92168_ONLY_ONE_FCTR');
1723: fnd_message.set_token('PROC',l_proc);
1724: fnd_message.set_token('LOS_FCTR_ID',to_char(g_parm.los_fctr_id));
1725: fnd_message.set_token('AGE_FCTR_ID',to_char(g_parm.age_fctr_id));
1726: fnd_message.set_token('MIN_LOS',to_char(g_parm.min_los));
1727: fnd_message.set_token('MAX_LOS',to_char(g_parm.max_los));
1728: fnd_message.set_token('MIN_AGE',to_char(g_parm.min_age));
1729: fnd_message.set_token('MAX_AGE',to_char(g_parm.max_age));
1730: fnd_message.set_token('CMBN_AGE_LOS_FCTR_ID',

Line 1727: fnd_message.set_token('MAX_LOS',to_char(g_parm.max_los));

1723: fnd_message.set_token('PROC',l_proc);
1724: fnd_message.set_token('LOS_FCTR_ID',to_char(g_parm.los_fctr_id));
1725: fnd_message.set_token('AGE_FCTR_ID',to_char(g_parm.age_fctr_id));
1726: fnd_message.set_token('MIN_LOS',to_char(g_parm.min_los));
1727: fnd_message.set_token('MAX_LOS',to_char(g_parm.max_los));
1728: fnd_message.set_token('MIN_AGE',to_char(g_parm.min_age));
1729: fnd_message.set_token('MAX_AGE',to_char(g_parm.max_age));
1730: fnd_message.set_token('CMBN_AGE_LOS_FCTR_ID',
1731: to_char(g_parm.cmbn_age_los_fctr_id));

Line 1728: fnd_message.set_token('MIN_AGE',to_char(g_parm.min_age));

1724: fnd_message.set_token('LOS_FCTR_ID',to_char(g_parm.los_fctr_id));
1725: fnd_message.set_token('AGE_FCTR_ID',to_char(g_parm.age_fctr_id));
1726: fnd_message.set_token('MIN_LOS',to_char(g_parm.min_los));
1727: fnd_message.set_token('MAX_LOS',to_char(g_parm.max_los));
1728: fnd_message.set_token('MIN_AGE',to_char(g_parm.min_age));
1729: fnd_message.set_token('MAX_AGE',to_char(g_parm.max_age));
1730: fnd_message.set_token('CMBN_AGE_LOS_FCTR_ID',
1731: to_char(g_parm.cmbn_age_los_fctr_id));
1732: fnd_message.raise_error;

Line 1729: fnd_message.set_token('MAX_AGE',to_char(g_parm.max_age));

1725: fnd_message.set_token('AGE_FCTR_ID',to_char(g_parm.age_fctr_id));
1726: fnd_message.set_token('MIN_LOS',to_char(g_parm.min_los));
1727: fnd_message.set_token('MAX_LOS',to_char(g_parm.max_los));
1728: fnd_message.set_token('MIN_AGE',to_char(g_parm.min_age));
1729: fnd_message.set_token('MAX_AGE',to_char(g_parm.max_age));
1730: fnd_message.set_token('CMBN_AGE_LOS_FCTR_ID',
1731: to_char(g_parm.cmbn_age_los_fctr_id));
1732: fnd_message.raise_error;
1733: end if;

Line 1730: fnd_message.set_token('CMBN_AGE_LOS_FCTR_ID',

1726: fnd_message.set_token('MIN_LOS',to_char(g_parm.min_los));
1727: fnd_message.set_token('MAX_LOS',to_char(g_parm.max_los));
1728: fnd_message.set_token('MIN_AGE',to_char(g_parm.min_age));
1729: fnd_message.set_token('MAX_AGE',to_char(g_parm.max_age));
1730: fnd_message.set_token('CMBN_AGE_LOS_FCTR_ID',
1731: to_char(g_parm.cmbn_age_los_fctr_id));
1732: fnd_message.raise_error;
1733: end if;
1734: --

Line 1732: fnd_message.raise_error;

1728: fnd_message.set_token('MIN_AGE',to_char(g_parm.min_age));
1729: fnd_message.set_token('MAX_AGE',to_char(g_parm.max_age));
1730: fnd_message.set_token('CMBN_AGE_LOS_FCTR_ID',
1731: to_char(g_parm.cmbn_age_los_fctr_id));
1732: fnd_message.raise_error;
1733: end if;
1734: --
1735: end if;
1736: --

Line 1744: fnd_message.set_name('BEN', 'BEN_92167_NO_MINMAX_WHEN_FCTR');

1740: --
1741: if g_parm.min_los is not null or
1742: g_parm.max_los is not null then
1743: --
1744: fnd_message.set_name('BEN', 'BEN_92167_NO_MINMAX_WHEN_FCTR');
1745: fnd_message.set_token('PROC',l_proc);
1746: fnd_message.set_token('MIN','Min Length of Service : '||g_parm.min_los);
1747: fnd_message.set_token('MAX','Max Length of Service : '||g_parm.max_los);
1748: --

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

1741: if g_parm.min_los is not null or
1742: g_parm.max_los is not null then
1743: --
1744: fnd_message.set_name('BEN', 'BEN_92167_NO_MINMAX_WHEN_FCTR');
1745: fnd_message.set_token('PROC',l_proc);
1746: fnd_message.set_token('MIN','Min Length of Service : '||g_parm.min_los);
1747: fnd_message.set_token('MAX','Max Length of Service : '||g_parm.max_los);
1748: --
1749: -- Do not specify the min and max values when selecting a predefined

Line 1746: fnd_message.set_token('MIN','Min Length of Service : '||g_parm.min_los);

1742: g_parm.max_los is not null then
1743: --
1744: fnd_message.set_name('BEN', 'BEN_92167_NO_MINMAX_WHEN_FCTR');
1745: fnd_message.set_token('PROC',l_proc);
1746: fnd_message.set_token('MIN','Min Length of Service : '||g_parm.min_los);
1747: fnd_message.set_token('MAX','Max Length of Service : '||g_parm.max_los);
1748: --
1749: -- Do not specify the min and max values when selecting a predefined
1750: -- FCTR factor.

Line 1747: fnd_message.set_token('MAX','Max Length of Service : '||g_parm.max_los);

1743: --
1744: fnd_message.set_name('BEN', 'BEN_92167_NO_MINMAX_WHEN_FCTR');
1745: fnd_message.set_token('PROC',l_proc);
1746: fnd_message.set_token('MIN','Min Length of Service : '||g_parm.min_los);
1747: fnd_message.set_token('MAX','Max Length of Service : '||g_parm.max_los);
1748: --
1749: -- Do not specify the min and max values when selecting a predefined
1750: -- FCTR factor.
1751: --

Line 1752: fnd_message.raise_error;

1748: --
1749: -- Do not specify the min and max values when selecting a predefined
1750: -- FCTR factor.
1751: --
1752: fnd_message.raise_error;
1753: --
1754: end if;
1755: --
1756: if g_parm.age_fctr_id is not null or

Line 1760: fnd_message.set_name('BEN', 'BEN_92168_ONLY_ONE_FCTR');

1756: if g_parm.age_fctr_id is not null or
1757: g_parm.min_age is not null or
1758: g_parm.max_age is not null or
1759: g_parm.cmbn_age_los_fctr_id is not null then
1760: fnd_message.set_name('BEN', 'BEN_92168_ONLY_ONE_FCTR');
1761: fnd_message.set_token('PROC',l_proc);
1762: fnd_message.set_token('LOS_FCTR_ID',to_char(g_parm.los_fctr_id));
1763: fnd_message.set_token('AGE_FCTR_ID',to_char(g_parm.age_fctr_id));
1764: fnd_message.set_token('MIN_LOS',to_char(g_parm.min_los));

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

1757: g_parm.min_age is not null or
1758: g_parm.max_age is not null or
1759: g_parm.cmbn_age_los_fctr_id is not null then
1760: fnd_message.set_name('BEN', 'BEN_92168_ONLY_ONE_FCTR');
1761: fnd_message.set_token('PROC',l_proc);
1762: fnd_message.set_token('LOS_FCTR_ID',to_char(g_parm.los_fctr_id));
1763: fnd_message.set_token('AGE_FCTR_ID',to_char(g_parm.age_fctr_id));
1764: fnd_message.set_token('MIN_LOS',to_char(g_parm.min_los));
1765: fnd_message.set_token('MAX_LOS',to_char(g_parm.max_los));

Line 1762: fnd_message.set_token('LOS_FCTR_ID',to_char(g_parm.los_fctr_id));

1758: g_parm.max_age is not null or
1759: g_parm.cmbn_age_los_fctr_id is not null then
1760: fnd_message.set_name('BEN', 'BEN_92168_ONLY_ONE_FCTR');
1761: fnd_message.set_token('PROC',l_proc);
1762: fnd_message.set_token('LOS_FCTR_ID',to_char(g_parm.los_fctr_id));
1763: fnd_message.set_token('AGE_FCTR_ID',to_char(g_parm.age_fctr_id));
1764: fnd_message.set_token('MIN_LOS',to_char(g_parm.min_los));
1765: fnd_message.set_token('MAX_LOS',to_char(g_parm.max_los));
1766: fnd_message.set_token('MIN_AGE',to_char(g_parm.min_age));

Line 1763: fnd_message.set_token('AGE_FCTR_ID',to_char(g_parm.age_fctr_id));

1759: g_parm.cmbn_age_los_fctr_id is not null then
1760: fnd_message.set_name('BEN', 'BEN_92168_ONLY_ONE_FCTR');
1761: fnd_message.set_token('PROC',l_proc);
1762: fnd_message.set_token('LOS_FCTR_ID',to_char(g_parm.los_fctr_id));
1763: fnd_message.set_token('AGE_FCTR_ID',to_char(g_parm.age_fctr_id));
1764: fnd_message.set_token('MIN_LOS',to_char(g_parm.min_los));
1765: fnd_message.set_token('MAX_LOS',to_char(g_parm.max_los));
1766: fnd_message.set_token('MIN_AGE',to_char(g_parm.min_age));
1767: fnd_message.set_token('MAX_AGE',to_char(g_parm.max_age));

Line 1764: fnd_message.set_token('MIN_LOS',to_char(g_parm.min_los));

1760: fnd_message.set_name('BEN', 'BEN_92168_ONLY_ONE_FCTR');
1761: fnd_message.set_token('PROC',l_proc);
1762: fnd_message.set_token('LOS_FCTR_ID',to_char(g_parm.los_fctr_id));
1763: fnd_message.set_token('AGE_FCTR_ID',to_char(g_parm.age_fctr_id));
1764: fnd_message.set_token('MIN_LOS',to_char(g_parm.min_los));
1765: fnd_message.set_token('MAX_LOS',to_char(g_parm.max_los));
1766: fnd_message.set_token('MIN_AGE',to_char(g_parm.min_age));
1767: fnd_message.set_token('MAX_AGE',to_char(g_parm.max_age));
1768: fnd_message.set_token('CMBN_AGE_LOS_FCTR_ID',

Line 1765: fnd_message.set_token('MAX_LOS',to_char(g_parm.max_los));

1761: fnd_message.set_token('PROC',l_proc);
1762: fnd_message.set_token('LOS_FCTR_ID',to_char(g_parm.los_fctr_id));
1763: fnd_message.set_token('AGE_FCTR_ID',to_char(g_parm.age_fctr_id));
1764: fnd_message.set_token('MIN_LOS',to_char(g_parm.min_los));
1765: fnd_message.set_token('MAX_LOS',to_char(g_parm.max_los));
1766: fnd_message.set_token('MIN_AGE',to_char(g_parm.min_age));
1767: fnd_message.set_token('MAX_AGE',to_char(g_parm.max_age));
1768: fnd_message.set_token('CMBN_AGE_LOS_FCTR_ID',
1769: to_char(g_parm.cmbn_age_los_fctr_id));

Line 1766: fnd_message.set_token('MIN_AGE',to_char(g_parm.min_age));

1762: fnd_message.set_token('LOS_FCTR_ID',to_char(g_parm.los_fctr_id));
1763: fnd_message.set_token('AGE_FCTR_ID',to_char(g_parm.age_fctr_id));
1764: fnd_message.set_token('MIN_LOS',to_char(g_parm.min_los));
1765: fnd_message.set_token('MAX_LOS',to_char(g_parm.max_los));
1766: fnd_message.set_token('MIN_AGE',to_char(g_parm.min_age));
1767: fnd_message.set_token('MAX_AGE',to_char(g_parm.max_age));
1768: fnd_message.set_token('CMBN_AGE_LOS_FCTR_ID',
1769: to_char(g_parm.cmbn_age_los_fctr_id));
1770: fnd_message.raise_error;

Line 1767: fnd_message.set_token('MAX_AGE',to_char(g_parm.max_age));

1763: fnd_message.set_token('AGE_FCTR_ID',to_char(g_parm.age_fctr_id));
1764: fnd_message.set_token('MIN_LOS',to_char(g_parm.min_los));
1765: fnd_message.set_token('MAX_LOS',to_char(g_parm.max_los));
1766: fnd_message.set_token('MIN_AGE',to_char(g_parm.min_age));
1767: fnd_message.set_token('MAX_AGE',to_char(g_parm.max_age));
1768: fnd_message.set_token('CMBN_AGE_LOS_FCTR_ID',
1769: to_char(g_parm.cmbn_age_los_fctr_id));
1770: fnd_message.raise_error;
1771: end if;

Line 1768: fnd_message.set_token('CMBN_AGE_LOS_FCTR_ID',

1764: fnd_message.set_token('MIN_LOS',to_char(g_parm.min_los));
1765: fnd_message.set_token('MAX_LOS',to_char(g_parm.max_los));
1766: fnd_message.set_token('MIN_AGE',to_char(g_parm.min_age));
1767: fnd_message.set_token('MAX_AGE',to_char(g_parm.max_age));
1768: fnd_message.set_token('CMBN_AGE_LOS_FCTR_ID',
1769: to_char(g_parm.cmbn_age_los_fctr_id));
1770: fnd_message.raise_error;
1771: end if;
1772: --

Line 1770: fnd_message.raise_error;

1766: fnd_message.set_token('MIN_AGE',to_char(g_parm.min_age));
1767: fnd_message.set_token('MAX_AGE',to_char(g_parm.max_age));
1768: fnd_message.set_token('CMBN_AGE_LOS_FCTR_ID',
1769: to_char(g_parm.cmbn_age_los_fctr_id));
1770: fnd_message.raise_error;
1771: end if;
1772: --
1773: end if;
1774: --

Line 1779: fnd_message.set_name('BEN', 'BEN_92168_ONLY_ONE_FCTR');

1775: if g_parm.cmbn_age_los_fctr_id is not null then
1776: --
1777: if g_parm.age_fctr_id is not null or
1778: g_parm.los_fctr_id is not null then
1779: fnd_message.set_name('BEN', 'BEN_92168_ONLY_ONE_FCTR');
1780: fnd_message.set_token('PROC',l_proc);
1781: fnd_message.set_token('LOS_FCTR_ID',to_char(g_parm.los_fctr_id));
1782: fnd_message.set_token('AGE_FCTR_ID',to_char(g_parm.age_fctr_id));
1783: fnd_message.set_token('MIN_LOS',to_char(g_parm.min_los));

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

1776: --
1777: if g_parm.age_fctr_id is not null or
1778: g_parm.los_fctr_id is not null then
1779: fnd_message.set_name('BEN', 'BEN_92168_ONLY_ONE_FCTR');
1780: fnd_message.set_token('PROC',l_proc);
1781: fnd_message.set_token('LOS_FCTR_ID',to_char(g_parm.los_fctr_id));
1782: fnd_message.set_token('AGE_FCTR_ID',to_char(g_parm.age_fctr_id));
1783: fnd_message.set_token('MIN_LOS',to_char(g_parm.min_los));
1784: fnd_message.set_token('MAX_LOS',to_char(g_parm.max_los));

Line 1781: fnd_message.set_token('LOS_FCTR_ID',to_char(g_parm.los_fctr_id));

1777: if g_parm.age_fctr_id is not null or
1778: g_parm.los_fctr_id is not null then
1779: fnd_message.set_name('BEN', 'BEN_92168_ONLY_ONE_FCTR');
1780: fnd_message.set_token('PROC',l_proc);
1781: fnd_message.set_token('LOS_FCTR_ID',to_char(g_parm.los_fctr_id));
1782: fnd_message.set_token('AGE_FCTR_ID',to_char(g_parm.age_fctr_id));
1783: fnd_message.set_token('MIN_LOS',to_char(g_parm.min_los));
1784: fnd_message.set_token('MAX_LOS',to_char(g_parm.max_los));
1785: fnd_message.set_token('MIN_AGE',to_char(g_parm.min_age));

Line 1782: fnd_message.set_token('AGE_FCTR_ID',to_char(g_parm.age_fctr_id));

1778: g_parm.los_fctr_id is not null then
1779: fnd_message.set_name('BEN', 'BEN_92168_ONLY_ONE_FCTR');
1780: fnd_message.set_token('PROC',l_proc);
1781: fnd_message.set_token('LOS_FCTR_ID',to_char(g_parm.los_fctr_id));
1782: fnd_message.set_token('AGE_FCTR_ID',to_char(g_parm.age_fctr_id));
1783: fnd_message.set_token('MIN_LOS',to_char(g_parm.min_los));
1784: fnd_message.set_token('MAX_LOS',to_char(g_parm.max_los));
1785: fnd_message.set_token('MIN_AGE',to_char(g_parm.min_age));
1786: fnd_message.set_token('MAX_AGE',to_char(g_parm.max_age));

Line 1783: fnd_message.set_token('MIN_LOS',to_char(g_parm.min_los));

1779: fnd_message.set_name('BEN', 'BEN_92168_ONLY_ONE_FCTR');
1780: fnd_message.set_token('PROC',l_proc);
1781: fnd_message.set_token('LOS_FCTR_ID',to_char(g_parm.los_fctr_id));
1782: fnd_message.set_token('AGE_FCTR_ID',to_char(g_parm.age_fctr_id));
1783: fnd_message.set_token('MIN_LOS',to_char(g_parm.min_los));
1784: fnd_message.set_token('MAX_LOS',to_char(g_parm.max_los));
1785: fnd_message.set_token('MIN_AGE',to_char(g_parm.min_age));
1786: fnd_message.set_token('MAX_AGE',to_char(g_parm.max_age));
1787: fnd_message.set_token('CMBN_AGE_LOS_FCTR_ID',

Line 1784: fnd_message.set_token('MAX_LOS',to_char(g_parm.max_los));

1780: fnd_message.set_token('PROC',l_proc);
1781: fnd_message.set_token('LOS_FCTR_ID',to_char(g_parm.los_fctr_id));
1782: fnd_message.set_token('AGE_FCTR_ID',to_char(g_parm.age_fctr_id));
1783: fnd_message.set_token('MIN_LOS',to_char(g_parm.min_los));
1784: fnd_message.set_token('MAX_LOS',to_char(g_parm.max_los));
1785: fnd_message.set_token('MIN_AGE',to_char(g_parm.min_age));
1786: fnd_message.set_token('MAX_AGE',to_char(g_parm.max_age));
1787: fnd_message.set_token('CMBN_AGE_LOS_FCTR_ID',
1788: to_char(g_parm.cmbn_age_los_fctr_id));

Line 1785: fnd_message.set_token('MIN_AGE',to_char(g_parm.min_age));

1781: fnd_message.set_token('LOS_FCTR_ID',to_char(g_parm.los_fctr_id));
1782: fnd_message.set_token('AGE_FCTR_ID',to_char(g_parm.age_fctr_id));
1783: fnd_message.set_token('MIN_LOS',to_char(g_parm.min_los));
1784: fnd_message.set_token('MAX_LOS',to_char(g_parm.max_los));
1785: fnd_message.set_token('MIN_AGE',to_char(g_parm.min_age));
1786: fnd_message.set_token('MAX_AGE',to_char(g_parm.max_age));
1787: fnd_message.set_token('CMBN_AGE_LOS_FCTR_ID',
1788: to_char(g_parm.cmbn_age_los_fctr_id));
1789: fnd_message.raise_error;

Line 1786: fnd_message.set_token('MAX_AGE',to_char(g_parm.max_age));

1782: fnd_message.set_token('AGE_FCTR_ID',to_char(g_parm.age_fctr_id));
1783: fnd_message.set_token('MIN_LOS',to_char(g_parm.min_los));
1784: fnd_message.set_token('MAX_LOS',to_char(g_parm.max_los));
1785: fnd_message.set_token('MIN_AGE',to_char(g_parm.min_age));
1786: fnd_message.set_token('MAX_AGE',to_char(g_parm.max_age));
1787: fnd_message.set_token('CMBN_AGE_LOS_FCTR_ID',
1788: to_char(g_parm.cmbn_age_los_fctr_id));
1789: fnd_message.raise_error;
1790: end if;

Line 1787: fnd_message.set_token('CMBN_AGE_LOS_FCTR_ID',

1783: fnd_message.set_token('MIN_LOS',to_char(g_parm.min_los));
1784: fnd_message.set_token('MAX_LOS',to_char(g_parm.max_los));
1785: fnd_message.set_token('MIN_AGE',to_char(g_parm.min_age));
1786: fnd_message.set_token('MAX_AGE',to_char(g_parm.max_age));
1787: fnd_message.set_token('CMBN_AGE_LOS_FCTR_ID',
1788: to_char(g_parm.cmbn_age_los_fctr_id));
1789: fnd_message.raise_error;
1790: end if;
1791: --

Line 1789: fnd_message.raise_error;

1785: fnd_message.set_token('MIN_AGE',to_char(g_parm.min_age));
1786: fnd_message.set_token('MAX_AGE',to_char(g_parm.max_age));
1787: fnd_message.set_token('CMBN_AGE_LOS_FCTR_ID',
1788: to_char(g_parm.cmbn_age_los_fctr_id));
1789: fnd_message.raise_error;
1790: end if;
1791: --
1792: end if;
1793: --

Line 1802: fnd_message.set_name('BEN', 'BEN_92534_MIN_MAX');

1798: --
1799: -- Check if the min is greater than then max
1800: --
1801: if g_parm.min_age > g_parm.max_age then
1802: fnd_message.set_name('BEN', 'BEN_92534_MIN_MAX');
1803: fnd_message.set_token('PROC',l_proc);
1804: fnd_message.set_token('MIN','Minimum Age : '||g_parm.min_age);
1805: fnd_message.set_token('MAX','Maximum Age : '||g_parm.max_age);
1806: fnd_message.raise_error;

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

1799: -- Check if the min is greater than then max
1800: --
1801: if g_parm.min_age > g_parm.max_age then
1802: fnd_message.set_name('BEN', 'BEN_92534_MIN_MAX');
1803: fnd_message.set_token('PROC',l_proc);
1804: fnd_message.set_token('MIN','Minimum Age : '||g_parm.min_age);
1805: fnd_message.set_token('MAX','Maximum Age : '||g_parm.max_age);
1806: fnd_message.raise_error;
1807: end if;

Line 1804: fnd_message.set_token('MIN','Minimum Age : '||g_parm.min_age);

1800: --
1801: if g_parm.min_age > g_parm.max_age then
1802: fnd_message.set_name('BEN', 'BEN_92534_MIN_MAX');
1803: fnd_message.set_token('PROC',l_proc);
1804: fnd_message.set_token('MIN','Minimum Age : '||g_parm.min_age);
1805: fnd_message.set_token('MAX','Maximum Age : '||g_parm.max_age);
1806: fnd_message.raise_error;
1807: end if;
1808: --

Line 1805: fnd_message.set_token('MAX','Maximum Age : '||g_parm.max_age);

1801: if g_parm.min_age > g_parm.max_age then
1802: fnd_message.set_name('BEN', 'BEN_92534_MIN_MAX');
1803: fnd_message.set_token('PROC',l_proc);
1804: fnd_message.set_token('MIN','Minimum Age : '||g_parm.min_age);
1805: fnd_message.set_token('MAX','Maximum Age : '||g_parm.max_age);
1806: fnd_message.raise_error;
1807: end if;
1808: --
1809: -- If only a max value is being provided, error out because if the user

Line 1806: fnd_message.raise_error;

1802: fnd_message.set_name('BEN', 'BEN_92534_MIN_MAX');
1803: fnd_message.set_token('PROC',l_proc);
1804: fnd_message.set_token('MIN','Minimum Age : '||g_parm.min_age);
1805: fnd_message.set_token('MAX','Maximum Age : '||g_parm.max_age);
1806: fnd_message.raise_error;
1807: end if;
1808: --
1809: -- If only a max value is being provided, error out because if the user
1810: -- wants to evaluate a threshold, the min can be used for that purpose

Line 1814: fnd_message.set_name('BEN', 'BEN_92169_ONLY_MIN_OR_BOTH');

1810: -- wants to evaluate a threshold, the min can be used for that purpose
1811: --
1812: if g_parm.min_age is null and
1813: g_parm.max_age is not null then
1814: fnd_message.set_name('BEN', 'BEN_92169_ONLY_MIN_OR_BOTH');
1815: fnd_message.set_token('PROC',l_proc);
1816: fnd_message.set_token('MIN','Minimum Age : '||g_parm.min_age);
1817: fnd_message.set_token('MAX','Maximum Age : '||g_parm.max_age);
1818: -- Only max value specified. Provide only the min value or both min and

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

1811: --
1812: if g_parm.min_age is null and
1813: g_parm.max_age is not null then
1814: fnd_message.set_name('BEN', 'BEN_92169_ONLY_MIN_OR_BOTH');
1815: fnd_message.set_token('PROC',l_proc);
1816: fnd_message.set_token('MIN','Minimum Age : '||g_parm.min_age);
1817: fnd_message.set_token('MAX','Maximum Age : '||g_parm.max_age);
1818: -- Only max value specified. Provide only the min value or both min and
1819: -- max values.

Line 1816: fnd_message.set_token('MIN','Minimum Age : '||g_parm.min_age);

1812: if g_parm.min_age is null and
1813: g_parm.max_age is not null then
1814: fnd_message.set_name('BEN', 'BEN_92169_ONLY_MIN_OR_BOTH');
1815: fnd_message.set_token('PROC',l_proc);
1816: fnd_message.set_token('MIN','Minimum Age : '||g_parm.min_age);
1817: fnd_message.set_token('MAX','Maximum Age : '||g_parm.max_age);
1818: -- Only max value specified. Provide only the min value or both min and
1819: -- max values.
1820: fnd_message.raise_error;

Line 1817: fnd_message.set_token('MAX','Maximum Age : '||g_parm.max_age);

1813: g_parm.max_age is not null then
1814: fnd_message.set_name('BEN', 'BEN_92169_ONLY_MIN_OR_BOTH');
1815: fnd_message.set_token('PROC',l_proc);
1816: fnd_message.set_token('MIN','Minimum Age : '||g_parm.min_age);
1817: fnd_message.set_token('MAX','Maximum Age : '||g_parm.max_age);
1818: -- Only max value specified. Provide only the min value or both min and
1819: -- max values.
1820: fnd_message.raise_error;
1821: end if;

Line 1820: fnd_message.raise_error;

1816: fnd_message.set_token('MIN','Minimum Age : '||g_parm.min_age);
1817: fnd_message.set_token('MAX','Maximum Age : '||g_parm.max_age);
1818: -- Only max value specified. Provide only the min value or both min and
1819: -- max values.
1820: fnd_message.raise_error;
1821: end if;
1822: --
1823: -- When evaluating this derived factor, all other parameters relating to
1824: -- other derived factors should be null.

Line 1830: fnd_message.set_name('BEN', 'BEN_92168_ONLY_ONE_FCTR');

1826: if g_parm.los_fctr_id is not null or
1827: g_parm.min_los is not null or
1828: g_parm.max_los is not null or
1829: g_parm.cmbn_age_los_fctr_id is not null then
1830: fnd_message.set_name('BEN', 'BEN_92168_ONLY_ONE_FCTR');
1831: fnd_message.set_token('PROC',l_proc);
1832: fnd_message.set_token('LOS_FCTR_ID',to_char(g_parm.los_fctr_id));
1833: fnd_message.set_token('AGE_FCTR_ID',to_char(g_parm.age_fctr_id));
1834: fnd_message.set_token('MIN_LOS',to_char(g_parm.min_los));

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

1827: g_parm.min_los is not null or
1828: g_parm.max_los is not null or
1829: g_parm.cmbn_age_los_fctr_id is not null then
1830: fnd_message.set_name('BEN', 'BEN_92168_ONLY_ONE_FCTR');
1831: fnd_message.set_token('PROC',l_proc);
1832: fnd_message.set_token('LOS_FCTR_ID',to_char(g_parm.los_fctr_id));
1833: fnd_message.set_token('AGE_FCTR_ID',to_char(g_parm.age_fctr_id));
1834: fnd_message.set_token('MIN_LOS',to_char(g_parm.min_los));
1835: fnd_message.set_token('MAX_LOS',to_char(g_parm.max_los));

Line 1832: fnd_message.set_token('LOS_FCTR_ID',to_char(g_parm.los_fctr_id));

1828: g_parm.max_los is not null or
1829: g_parm.cmbn_age_los_fctr_id is not null then
1830: fnd_message.set_name('BEN', 'BEN_92168_ONLY_ONE_FCTR');
1831: fnd_message.set_token('PROC',l_proc);
1832: fnd_message.set_token('LOS_FCTR_ID',to_char(g_parm.los_fctr_id));
1833: fnd_message.set_token('AGE_FCTR_ID',to_char(g_parm.age_fctr_id));
1834: fnd_message.set_token('MIN_LOS',to_char(g_parm.min_los));
1835: fnd_message.set_token('MAX_LOS',to_char(g_parm.max_los));
1836: fnd_message.set_token('MIN_AGE',to_char(g_parm.min_age));

Line 1833: fnd_message.set_token('AGE_FCTR_ID',to_char(g_parm.age_fctr_id));

1829: g_parm.cmbn_age_los_fctr_id is not null then
1830: fnd_message.set_name('BEN', 'BEN_92168_ONLY_ONE_FCTR');
1831: fnd_message.set_token('PROC',l_proc);
1832: fnd_message.set_token('LOS_FCTR_ID',to_char(g_parm.los_fctr_id));
1833: fnd_message.set_token('AGE_FCTR_ID',to_char(g_parm.age_fctr_id));
1834: fnd_message.set_token('MIN_LOS',to_char(g_parm.min_los));
1835: fnd_message.set_token('MAX_LOS',to_char(g_parm.max_los));
1836: fnd_message.set_token('MIN_AGE',to_char(g_parm.min_age));
1837: fnd_message.set_token('MAX_AGE',to_char(g_parm.max_age));

Line 1834: fnd_message.set_token('MIN_LOS',to_char(g_parm.min_los));

1830: fnd_message.set_name('BEN', 'BEN_92168_ONLY_ONE_FCTR');
1831: fnd_message.set_token('PROC',l_proc);
1832: fnd_message.set_token('LOS_FCTR_ID',to_char(g_parm.los_fctr_id));
1833: fnd_message.set_token('AGE_FCTR_ID',to_char(g_parm.age_fctr_id));
1834: fnd_message.set_token('MIN_LOS',to_char(g_parm.min_los));
1835: fnd_message.set_token('MAX_LOS',to_char(g_parm.max_los));
1836: fnd_message.set_token('MIN_AGE',to_char(g_parm.min_age));
1837: fnd_message.set_token('MAX_AGE',to_char(g_parm.max_age));
1838: fnd_message.set_token('CMBN_AGE_LOS_FCTR_ID',

Line 1835: fnd_message.set_token('MAX_LOS',to_char(g_parm.max_los));

1831: fnd_message.set_token('PROC',l_proc);
1832: fnd_message.set_token('LOS_FCTR_ID',to_char(g_parm.los_fctr_id));
1833: fnd_message.set_token('AGE_FCTR_ID',to_char(g_parm.age_fctr_id));
1834: fnd_message.set_token('MIN_LOS',to_char(g_parm.min_los));
1835: fnd_message.set_token('MAX_LOS',to_char(g_parm.max_los));
1836: fnd_message.set_token('MIN_AGE',to_char(g_parm.min_age));
1837: fnd_message.set_token('MAX_AGE',to_char(g_parm.max_age));
1838: fnd_message.set_token('CMBN_AGE_LOS_FCTR_ID',
1839: to_char(g_parm.cmbn_age_los_fctr_id));

Line 1836: fnd_message.set_token('MIN_AGE',to_char(g_parm.min_age));

1832: fnd_message.set_token('LOS_FCTR_ID',to_char(g_parm.los_fctr_id));
1833: fnd_message.set_token('AGE_FCTR_ID',to_char(g_parm.age_fctr_id));
1834: fnd_message.set_token('MIN_LOS',to_char(g_parm.min_los));
1835: fnd_message.set_token('MAX_LOS',to_char(g_parm.max_los));
1836: fnd_message.set_token('MIN_AGE',to_char(g_parm.min_age));
1837: fnd_message.set_token('MAX_AGE',to_char(g_parm.max_age));
1838: fnd_message.set_token('CMBN_AGE_LOS_FCTR_ID',
1839: to_char(g_parm.cmbn_age_los_fctr_id));
1840: --

Line 1837: fnd_message.set_token('MAX_AGE',to_char(g_parm.max_age));

1833: fnd_message.set_token('AGE_FCTR_ID',to_char(g_parm.age_fctr_id));
1834: fnd_message.set_token('MIN_LOS',to_char(g_parm.min_los));
1835: fnd_message.set_token('MAX_LOS',to_char(g_parm.max_los));
1836: fnd_message.set_token('MIN_AGE',to_char(g_parm.min_age));
1837: fnd_message.set_token('MAX_AGE',to_char(g_parm.max_age));
1838: fnd_message.set_token('CMBN_AGE_LOS_FCTR_ID',
1839: to_char(g_parm.cmbn_age_los_fctr_id));
1840: --
1841: fnd_message.raise_error;

Line 1838: fnd_message.set_token('CMBN_AGE_LOS_FCTR_ID',

1834: fnd_message.set_token('MIN_LOS',to_char(g_parm.min_los));
1835: fnd_message.set_token('MAX_LOS',to_char(g_parm.max_los));
1836: fnd_message.set_token('MIN_AGE',to_char(g_parm.min_age));
1837: fnd_message.set_token('MAX_AGE',to_char(g_parm.max_age));
1838: fnd_message.set_token('CMBN_AGE_LOS_FCTR_ID',
1839: to_char(g_parm.cmbn_age_los_fctr_id));
1840: --
1841: fnd_message.raise_error;
1842: end if;

Line 1841: fnd_message.raise_error;

1837: fnd_message.set_token('MAX_AGE',to_char(g_parm.max_age));
1838: fnd_message.set_token('CMBN_AGE_LOS_FCTR_ID',
1839: to_char(g_parm.cmbn_age_los_fctr_id));
1840: --
1841: fnd_message.raise_error;
1842: end if;
1843: --
1844: elsif g_parm.min_los is not null or
1845: g_parm.max_los is not null then

Line 1850: fnd_message.set_name('BEN', 'BEN_92534_MIN_MAX');

1846: --
1847: -- Check if the min is greater than then max
1848: --
1849: if g_parm.min_los > g_parm.max_los then
1850: fnd_message.set_name('BEN', 'BEN_92534_MIN_MAX');
1851: fnd_message.set_token('PROC',l_proc);
1852: fnd_message.set_token('MIN',
1853: 'Minimum Length of Service : '||g_parm.min_los);
1854: fnd_message.set_token('MAX',

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

1847: -- Check if the min is greater than then max
1848: --
1849: if g_parm.min_los > g_parm.max_los then
1850: fnd_message.set_name('BEN', 'BEN_92534_MIN_MAX');
1851: fnd_message.set_token('PROC',l_proc);
1852: fnd_message.set_token('MIN',
1853: 'Minimum Length of Service : '||g_parm.min_los);
1854: fnd_message.set_token('MAX',
1855: 'Maximum Length of Service : '||g_parm.max_los);

Line 1852: fnd_message.set_token('MIN',

1848: --
1849: if g_parm.min_los > g_parm.max_los then
1850: fnd_message.set_name('BEN', 'BEN_92534_MIN_MAX');
1851: fnd_message.set_token('PROC',l_proc);
1852: fnd_message.set_token('MIN',
1853: 'Minimum Length of Service : '||g_parm.min_los);
1854: fnd_message.set_token('MAX',
1855: 'Maximum Length of Service : '||g_parm.max_los);
1856: fnd_message.raise_error;

Line 1854: fnd_message.set_token('MAX',

1850: fnd_message.set_name('BEN', 'BEN_92534_MIN_MAX');
1851: fnd_message.set_token('PROC',l_proc);
1852: fnd_message.set_token('MIN',
1853: 'Minimum Length of Service : '||g_parm.min_los);
1854: fnd_message.set_token('MAX',
1855: 'Maximum Length of Service : '||g_parm.max_los);
1856: fnd_message.raise_error;
1857: end if;
1858: --

Line 1856: fnd_message.raise_error;

1852: fnd_message.set_token('MIN',
1853: 'Minimum Length of Service : '||g_parm.min_los);
1854: fnd_message.set_token('MAX',
1855: 'Maximum Length of Service : '||g_parm.max_los);
1856: fnd_message.raise_error;
1857: end if;
1858: --
1859: -- If only a max value is being provided, error out because if the user
1860: -- wants to evaluate a threshold, the min can be used for that purpose

Line 1864: fnd_message.set_name('BEN', 'BEN_92169_ONLY_MIN_OR_BOTH');

1860: -- wants to evaluate a threshold, the min can be used for that purpose
1861: --
1862: if g_parm.min_los is null and
1863: g_parm.max_los is not null then
1864: fnd_message.set_name('BEN', 'BEN_92169_ONLY_MIN_OR_BOTH');
1865: fnd_message.set_token('PROC',l_proc);
1866: fnd_message.set_token('MIN',
1867: 'Minimum Length of Service : '||g_parm.min_los);
1868: fnd_message.set_token('MAX',

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

1861: --
1862: if g_parm.min_los is null and
1863: g_parm.max_los is not null then
1864: fnd_message.set_name('BEN', 'BEN_92169_ONLY_MIN_OR_BOTH');
1865: fnd_message.set_token('PROC',l_proc);
1866: fnd_message.set_token('MIN',
1867: 'Minimum Length of Service : '||g_parm.min_los);
1868: fnd_message.set_token('MAX',
1869: 'Maximum Length of Service : '||g_parm.max_los);

Line 1866: fnd_message.set_token('MIN',

1862: if g_parm.min_los is null and
1863: g_parm.max_los is not null then
1864: fnd_message.set_name('BEN', 'BEN_92169_ONLY_MIN_OR_BOTH');
1865: fnd_message.set_token('PROC',l_proc);
1866: fnd_message.set_token('MIN',
1867: 'Minimum Length of Service : '||g_parm.min_los);
1868: fnd_message.set_token('MAX',
1869: 'Maximum Length of Service : '||g_parm.max_los);
1870: fnd_message.raise_error;

Line 1868: fnd_message.set_token('MAX',

1864: fnd_message.set_name('BEN', 'BEN_92169_ONLY_MIN_OR_BOTH');
1865: fnd_message.set_token('PROC',l_proc);
1866: fnd_message.set_token('MIN',
1867: 'Minimum Length of Service : '||g_parm.min_los);
1868: fnd_message.set_token('MAX',
1869: 'Maximum Length of Service : '||g_parm.max_los);
1870: fnd_message.raise_error;
1871: end if;
1872: --

Line 1870: fnd_message.raise_error;

1866: fnd_message.set_token('MIN',
1867: 'Minimum Length of Service : '||g_parm.min_los);
1868: fnd_message.set_token('MAX',
1869: 'Maximum Length of Service : '||g_parm.max_los);
1870: fnd_message.raise_error;
1871: end if;
1872: --
1873: -- When evaluating this derived factor, all other parameters relating to
1874: -- other derived factors should be null.

Line 1880: fnd_message.set_name('BEN', 'BEN_92168_ONLY_ONE_FCTR');

1876: if g_parm.age_fctr_id is not null or
1877: g_parm.min_age is not null or
1878: g_parm.max_age is not null or
1879: g_parm.cmbn_age_los_fctr_id is not null then
1880: fnd_message.set_name('BEN', 'BEN_92168_ONLY_ONE_FCTR');
1881: fnd_message.set_token('PROC',l_proc);
1882: fnd_message.set_token('LOS_FCTR_ID',to_char(g_parm.los_fctr_id));
1883: fnd_message.set_token('AGE_FCTR_ID',to_char(g_parm.age_fctr_id));
1884: fnd_message.set_token('MIN_LOS',to_char(g_parm.min_los));

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

1877: g_parm.min_age is not null or
1878: g_parm.max_age is not null or
1879: g_parm.cmbn_age_los_fctr_id is not null then
1880: fnd_message.set_name('BEN', 'BEN_92168_ONLY_ONE_FCTR');
1881: fnd_message.set_token('PROC',l_proc);
1882: fnd_message.set_token('LOS_FCTR_ID',to_char(g_parm.los_fctr_id));
1883: fnd_message.set_token('AGE_FCTR_ID',to_char(g_parm.age_fctr_id));
1884: fnd_message.set_token('MIN_LOS',to_char(g_parm.min_los));
1885: fnd_message.set_token('MAX_LOS',to_char(g_parm.max_los));

Line 1882: fnd_message.set_token('LOS_FCTR_ID',to_char(g_parm.los_fctr_id));

1878: g_parm.max_age is not null or
1879: g_parm.cmbn_age_los_fctr_id is not null then
1880: fnd_message.set_name('BEN', 'BEN_92168_ONLY_ONE_FCTR');
1881: fnd_message.set_token('PROC',l_proc);
1882: fnd_message.set_token('LOS_FCTR_ID',to_char(g_parm.los_fctr_id));
1883: fnd_message.set_token('AGE_FCTR_ID',to_char(g_parm.age_fctr_id));
1884: fnd_message.set_token('MIN_LOS',to_char(g_parm.min_los));
1885: fnd_message.set_token('MAX_LOS',to_char(g_parm.max_los));
1886: fnd_message.set_token('MIN_AGE',to_char(g_parm.min_age));

Line 1883: fnd_message.set_token('AGE_FCTR_ID',to_char(g_parm.age_fctr_id));

1879: g_parm.cmbn_age_los_fctr_id is not null then
1880: fnd_message.set_name('BEN', 'BEN_92168_ONLY_ONE_FCTR');
1881: fnd_message.set_token('PROC',l_proc);
1882: fnd_message.set_token('LOS_FCTR_ID',to_char(g_parm.los_fctr_id));
1883: fnd_message.set_token('AGE_FCTR_ID',to_char(g_parm.age_fctr_id));
1884: fnd_message.set_token('MIN_LOS',to_char(g_parm.min_los));
1885: fnd_message.set_token('MAX_LOS',to_char(g_parm.max_los));
1886: fnd_message.set_token('MIN_AGE',to_char(g_parm.min_age));
1887: fnd_message.set_token('MAX_AGE',to_char(g_parm.max_age));

Line 1884: fnd_message.set_token('MIN_LOS',to_char(g_parm.min_los));

1880: fnd_message.set_name('BEN', 'BEN_92168_ONLY_ONE_FCTR');
1881: fnd_message.set_token('PROC',l_proc);
1882: fnd_message.set_token('LOS_FCTR_ID',to_char(g_parm.los_fctr_id));
1883: fnd_message.set_token('AGE_FCTR_ID',to_char(g_parm.age_fctr_id));
1884: fnd_message.set_token('MIN_LOS',to_char(g_parm.min_los));
1885: fnd_message.set_token('MAX_LOS',to_char(g_parm.max_los));
1886: fnd_message.set_token('MIN_AGE',to_char(g_parm.min_age));
1887: fnd_message.set_token('MAX_AGE',to_char(g_parm.max_age));
1888: fnd_message.set_token('CMBN_AGE_LOS_FCTR_ID',

Line 1885: fnd_message.set_token('MAX_LOS',to_char(g_parm.max_los));

1881: fnd_message.set_token('PROC',l_proc);
1882: fnd_message.set_token('LOS_FCTR_ID',to_char(g_parm.los_fctr_id));
1883: fnd_message.set_token('AGE_FCTR_ID',to_char(g_parm.age_fctr_id));
1884: fnd_message.set_token('MIN_LOS',to_char(g_parm.min_los));
1885: fnd_message.set_token('MAX_LOS',to_char(g_parm.max_los));
1886: fnd_message.set_token('MIN_AGE',to_char(g_parm.min_age));
1887: fnd_message.set_token('MAX_AGE',to_char(g_parm.max_age));
1888: fnd_message.set_token('CMBN_AGE_LOS_FCTR_ID',
1889: to_char(g_parm.cmbn_age_los_fctr_id));

Line 1886: fnd_message.set_token('MIN_AGE',to_char(g_parm.min_age));

1882: fnd_message.set_token('LOS_FCTR_ID',to_char(g_parm.los_fctr_id));
1883: fnd_message.set_token('AGE_FCTR_ID',to_char(g_parm.age_fctr_id));
1884: fnd_message.set_token('MIN_LOS',to_char(g_parm.min_los));
1885: fnd_message.set_token('MAX_LOS',to_char(g_parm.max_los));
1886: fnd_message.set_token('MIN_AGE',to_char(g_parm.min_age));
1887: fnd_message.set_token('MAX_AGE',to_char(g_parm.max_age));
1888: fnd_message.set_token('CMBN_AGE_LOS_FCTR_ID',
1889: to_char(g_parm.cmbn_age_los_fctr_id));
1890: fnd_message.raise_error;

Line 1887: fnd_message.set_token('MAX_AGE',to_char(g_parm.max_age));

1883: fnd_message.set_token('AGE_FCTR_ID',to_char(g_parm.age_fctr_id));
1884: fnd_message.set_token('MIN_LOS',to_char(g_parm.min_los));
1885: fnd_message.set_token('MAX_LOS',to_char(g_parm.max_los));
1886: fnd_message.set_token('MIN_AGE',to_char(g_parm.min_age));
1887: fnd_message.set_token('MAX_AGE',to_char(g_parm.max_age));
1888: fnd_message.set_token('CMBN_AGE_LOS_FCTR_ID',
1889: to_char(g_parm.cmbn_age_los_fctr_id));
1890: fnd_message.raise_error;
1891: end if;

Line 1888: fnd_message.set_token('CMBN_AGE_LOS_FCTR_ID',

1884: fnd_message.set_token('MIN_LOS',to_char(g_parm.min_los));
1885: fnd_message.set_token('MAX_LOS',to_char(g_parm.max_los));
1886: fnd_message.set_token('MIN_AGE',to_char(g_parm.min_age));
1887: fnd_message.set_token('MAX_AGE',to_char(g_parm.max_age));
1888: fnd_message.set_token('CMBN_AGE_LOS_FCTR_ID',
1889: to_char(g_parm.cmbn_age_los_fctr_id));
1890: fnd_message.raise_error;
1891: end if;
1892: --

Line 1890: fnd_message.raise_error;

1886: fnd_message.set_token('MIN_AGE',to_char(g_parm.min_age));
1887: fnd_message.set_token('MAX_AGE',to_char(g_parm.max_age));
1888: fnd_message.set_token('CMBN_AGE_LOS_FCTR_ID',
1889: to_char(g_parm.cmbn_age_los_fctr_id));
1890: fnd_message.raise_error;
1891: end if;
1892: --
1893: end if;
1894: --

Line 1908: fnd_message.set_name('BEN', 'BEN_92171_PLAN_OR_PGM');

1904: --
1905: -- If the elig_enrol_cd is being specified, then a comp object must be
1906: -- specified.
1907: --
1908: fnd_message.set_name('BEN', 'BEN_92171_PLAN_OR_PGM');
1909: fnd_message.set_token('PROC',l_proc);
1910: -- A program or a plan must be provided for the mass mailing trigger.
1911: fnd_message.raise_error;
1912: --

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

1905: -- If the elig_enrol_cd is being specified, then a comp object must be
1906: -- specified.
1907: --
1908: fnd_message.set_name('BEN', 'BEN_92171_PLAN_OR_PGM');
1909: fnd_message.set_token('PROC',l_proc);
1910: -- A program or a plan must be provided for the mass mailing trigger.
1911: fnd_message.raise_error;
1912: --
1913: end if;

Line 1911: fnd_message.raise_error;

1907: --
1908: fnd_message.set_name('BEN', 'BEN_92171_PLAN_OR_PGM');
1909: fnd_message.set_token('PROC',l_proc);
1910: -- A program or a plan must be provided for the mass mailing trigger.
1911: fnd_message.raise_error;
1912: --
1913: end if;
1914: --
1915: end if; -- g_parm.cm_trgr_typ_cd = MSSMLG

Line 2094: fnd_message.set_name('BEN', 'BEN_91337_DOB');

2090: exception
2091: --
2092: when dob_null then
2093: hr_utility.set_location('Exception raised in ' || l_proc, 10);
2094: fnd_message.set_name('BEN', 'BEN_91337_DOB');
2095: fnd_message.set_token('PROC',l_proc);
2096: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2097: -- The person being processed does not have a date of birth.
2098: raise ben_manage_life_events.g_record_error;

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

2091: --
2092: when dob_null then
2093: hr_utility.set_location('Exception raised in ' || l_proc, 10);
2094: fnd_message.set_name('BEN', 'BEN_91337_DOB');
2095: fnd_message.set_token('PROC',l_proc);
2096: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2097: -- The person being processed does not have a date of birth.
2098: raise ben_manage_life_events.g_record_error;
2099: --

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

2092: when dob_null then
2093: hr_utility.set_location('Exception raised in ' || l_proc, 10);
2094: fnd_message.set_name('BEN', 'BEN_91337_DOB');
2095: fnd_message.set_token('PROC',l_proc);
2096: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2097: -- The person being processed does not have a date of birth.
2098: raise ben_manage_life_events.g_record_error;
2099: --
2100: when agf_pgm_or_pl then

Line 2102: fnd_message.set_name('BEN','BEN_92181_FCTR_RQR_PGM_OR_PL');

2098: raise ben_manage_life_events.g_record_error;
2099: --
2100: when agf_pgm_or_pl then
2101: hr_utility.set_location('Exception raised in ' || l_proc, 10);
2102: fnd_message.set_name('BEN','BEN_92181_FCTR_RQR_PGM_OR_PL');
2103: fnd_message.set_token('PROC',l_proc);
2104: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2105: --
2106: -- The derived factor chosen uses a program or a plan year for calculation.

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

2099: --
2100: when agf_pgm_or_pl then
2101: hr_utility.set_location('Exception raised in ' || l_proc, 10);
2102: fnd_message.set_name('BEN','BEN_92181_FCTR_RQR_PGM_OR_PL');
2103: fnd_message.set_token('PROC',l_proc);
2104: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2105: --
2106: -- The derived factor chosen uses a program or a plan year for calculation.
2107: -- Please select a program or plan.

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

2100: when agf_pgm_or_pl then
2101: hr_utility.set_location('Exception raised in ' || l_proc, 10);
2102: fnd_message.set_name('BEN','BEN_92181_FCTR_RQR_PGM_OR_PL');
2103: fnd_message.set_token('PROC',l_proc);
2104: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2105: --
2106: -- The derived factor chosen uses a program or a plan year for calculation.
2107: -- Please select a program or plan.
2108: --

Line 2284: fnd_message.set_name('BEN','BEN_92181_FCTR_RQR_PGM_OR_PL');

2280: --
2281: when lsf_pgm_or_pl then
2282: --
2283: hr_utility.set_location('Leaving : ' || l_proc, 10);
2284: fnd_message.set_name('BEN','BEN_92181_FCTR_RQR_PGM_OR_PL');
2285: fnd_message.set_token('PROC',l_proc);
2286: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2287: --
2288: -- The derived factor chosen uses a program or a plan year for calculation.

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

2281: when lsf_pgm_or_pl then
2282: --
2283: hr_utility.set_location('Leaving : ' || l_proc, 10);
2284: fnd_message.set_name('BEN','BEN_92181_FCTR_RQR_PGM_OR_PL');
2285: fnd_message.set_token('PROC',l_proc);
2286: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2287: --
2288: -- The derived factor chosen uses a program or a plan year for calculation.
2289: -- Please select a program or plan.

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

2282: --
2283: hr_utility.set_location('Leaving : ' || l_proc, 10);
2284: fnd_message.set_name('BEN','BEN_92181_FCTR_RQR_PGM_OR_PL');
2285: fnd_message.set_token('PROC',l_proc);
2286: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2287: --
2288: -- The derived factor chosen uses a program or a plan year for calculation.
2289: -- Please select a program or plan.
2290: --

Line 2461: fnd_message.set_name('BEN','BEN_92181_FCTR_RQR_PGM_OR_PL');

2457: exception
2458: --
2459: when cmbn_pgm_or_pl then
2460: hr_utility.set_location('Exception raised in ' || l_proc, 10);
2461: fnd_message.set_name('BEN','BEN_92181_FCTR_RQR_PGM_OR_PL');
2462: fnd_message.set_token('PROC',l_proc);
2463: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2464: --
2465: -- The derived factor chosen uses a program or plan year for calculation.

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

2458: --
2459: when cmbn_pgm_or_pl then
2460: hr_utility.set_location('Exception raised in ' || l_proc, 10);
2461: fnd_message.set_name('BEN','BEN_92181_FCTR_RQR_PGM_OR_PL');
2462: fnd_message.set_token('PROC',l_proc);
2463: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2464: --
2465: -- The derived factor chosen uses a program or plan year for calculation.
2466: -- Please select a program or plan.

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

2459: when cmbn_pgm_or_pl then
2460: hr_utility.set_location('Exception raised in ' || l_proc, 10);
2461: fnd_message.set_name('BEN','BEN_92181_FCTR_RQR_PGM_OR_PL');
2462: fnd_message.set_token('PROC',l_proc);
2463: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2464: --
2465: -- The derived factor chosen uses a program or plan year for calculation.
2466: -- Please select a program or plan.
2467: --

Line 2637: g_rec.text := fnd_message.get;

2633: --
2634: g_rec.person_id := l_per_rec.person_id;
2635: g_rec.rep_typ_cd := 'ERRCM';
2636: g_rec.error_message_code := benutils.get_message_name;
2637: g_rec.text := fnd_message.get;
2638: --
2639: benutils.write(p_rec => g_rec);
2640: --
2641: -- Update person action to errored as record has an error

Line 2768: g_rec.text := fnd_message.get;

2764: rollback to before_communications;
2765: --
2766: g_rec.rep_typ_cd := 'ERRCM';
2767: g_rec.error_message_code := benutils.get_message_name;
2768: g_rec.text := fnd_message.get;
2769: g_rec.person_id := l_per_rec.person_id;
2770: --
2771: benutils.write(p_rec => g_rec);
2772: --

Line 2904: g_rec.text := fnd_message.get;

2900: rollback to before_communications;
2901: --
2902: g_rec.rep_typ_cd := 'ERRCM';
2903: g_rec.error_message_code := benutils.get_message_name;
2904: g_rec.text := fnd_message.get;
2905: g_rec.person_id := l_per_rec.person_id;
2906: --
2907: benutils.write(p_rec => g_rec);
2908: --

Line 3041: benutils.write(p_text => fnd_message.get);

3037: hr_utility.set_location ('PERSON ERROR '|| l_proc,10);
3038: --
3039: rollback to before_communications;
3040: --
3041: benutils.write(p_text => fnd_message.get);
3042: --
3043: g_rec.rep_typ_cd := 'ERRCM';
3044: g_rec.error_message_code := benutils.get_message_name;
3045: g_rec.text := fnd_message.get;

Line 3045: g_rec.text := fnd_message.get;

3041: benutils.write(p_text => fnd_message.get);
3042: --
3043: g_rec.rep_typ_cd := 'ERRCM';
3044: g_rec.error_message_code := benutils.get_message_name;
3045: g_rec.text := fnd_message.get;
3046: g_rec.person_id := l_per_rec.person_id;
3047: --
3048: benutils.write(p_rec => g_rec);
3049: --

Line 3140: fnd_message.set_name('BEN', 'BEN_91753_BENEFIT_ACTION_ERR');

3136: fetch c_parm into l_parm;
3137: --
3138: if c_parm%notfound then
3139: close c_parm;
3140: fnd_message.set_name('BEN', 'BEN_91753_BENEFIT_ACTION_ERR');
3141: fnd_message.set_token('PROC',l_proc);
3142: fnd_message.raise_error;
3143: end if;
3144: --

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

3137: --
3138: if c_parm%notfound then
3139: close c_parm;
3140: fnd_message.set_name('BEN', 'BEN_91753_BENEFIT_ACTION_ERR');
3141: fnd_message.set_token('PROC',l_proc);
3142: fnd_message.raise_error;
3143: end if;
3144: --
3145: close c_parm;

Line 3142: fnd_message.raise_error;

3138: if c_parm%notfound then
3139: close c_parm;
3140: fnd_message.set_name('BEN', 'BEN_91753_BENEFIT_ACTION_ERR');
3141: fnd_message.set_token('PROC',l_proc);
3142: fnd_message.raise_error;
3143: end if;
3144: --
3145: close c_parm;
3146: --

Line 3382: g_rec.text := fnd_message.get;

3378: benutils.write(p_text => sqlerrm);
3379: hr_utility.set_location ('BENTMPCM Error '|| l_proc,10);
3380: g_rec.rep_typ_cd := 'FATAL';
3381: g_rec.error_message_code := sqlcode;
3382: g_rec.text := fnd_message.get;
3383: benutils.write(p_rec => g_rec);
3384: --
3385: -- Output log information to log file
3386: --

Line 3391: fnd_message.set_name('BEN','BEN_92172_BENTMPCM_ERRORED');

3387: write_logfile;
3388: --
3389: check_all_slaves_finished;
3390: --
3391: fnd_message.set_name('BEN','BEN_92172_BENTMPCM_ERRORED');
3392: fnd_message.set_token('PROC',l_proc);
3393: benutils.write(p_text => fnd_message.get);
3394: benutils.write_table_and_file(p_table => true,
3395: p_file => true);

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

3388: --
3389: check_all_slaves_finished;
3390: --
3391: fnd_message.set_name('BEN','BEN_92172_BENTMPCM_ERRORED');
3392: fnd_message.set_token('PROC',l_proc);
3393: benutils.write(p_text => fnd_message.get);
3394: benutils.write_table_and_file(p_table => true,
3395: p_file => true);
3396: commit;

Line 3393: benutils.write(p_text => fnd_message.get);

3389: check_all_slaves_finished;
3390: --
3391: fnd_message.set_name('BEN','BEN_92172_BENTMPCM_ERRORED');
3392: fnd_message.set_token('PROC',l_proc);
3393: benutils.write(p_text => fnd_message.get);
3394: benutils.write_table_and_file(p_table => true,
3395: p_file => true);
3396: commit;
3397: --

Line 3398: fnd_message.raise_error;

3394: benutils.write_table_and_file(p_table => true,
3395: p_file => true);
3396: commit;
3397: --
3398: fnd_message.raise_error;
3399: --
3400: end do_multithread;
3401: --
3402: -- ----------------------------------------------------------------------------

Line 4879: fnd_message.set_name('BEN', 'BEN_91769_NOONE_TO_PROCESS');

4875: -- ranges created would have been zero. Raise an error if so.
4876: --
4877: if g_num_ranges = 0 then
4878: --
4879: fnd_message.set_name('BEN', 'BEN_91769_NOONE_TO_PROCESS');
4880: fnd_message.set_token('PROC',l_proc);
4881: fnd_message.raise_error;
4882: --
4883: end if;

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

4876: --
4877: if g_num_ranges = 0 then
4878: --
4879: fnd_message.set_name('BEN', 'BEN_91769_NOONE_TO_PROCESS');
4880: fnd_message.set_token('PROC',l_proc);
4881: fnd_message.raise_error;
4882: --
4883: end if;
4884: --

Line 4881: fnd_message.raise_error;

4877: if g_num_ranges = 0 then
4878: --
4879: fnd_message.set_name('BEN', 'BEN_91769_NOONE_TO_PROCESS');
4880: fnd_message.set_token('PROC',l_proc);
4881: fnd_message.raise_error;
4882: --
4883: end if;
4884: --
4885: -- Set the number of threads to the lesser of the defined number of threads

Line 5176: fnd_message.set_name('BEN','BEN_91792_ALL_PROMPT');

5172: hr_utility.set_location('Entering :'||l_proc,10);
5173: --
5174: -- Default return values for nulls
5175: --
5176: fnd_message.set_name('BEN','BEN_91792_ALL_PROMPT');
5177: --l_all := fnd_message.get;
5178: l_all := substrb(fnd_message.get,1,80); -- bug 2595834
5179: fnd_message.set_name('BEN','BEN_91793_NONE_PROMPT');
5180: l_none := substrb(fnd_message.get,1,80); -- bug 2595834

Line 5177: --l_all := fnd_message.get;

5173: --
5174: -- Default return values for nulls
5175: --
5176: fnd_message.set_name('BEN','BEN_91792_ALL_PROMPT');
5177: --l_all := fnd_message.get;
5178: l_all := substrb(fnd_message.get,1,80); -- bug 2595834
5179: fnd_message.set_name('BEN','BEN_91793_NONE_PROMPT');
5180: l_none := substrb(fnd_message.get,1,80); -- bug 2595834
5181: --l_none := fnd_message.get;

Line 5178: l_all := substrb(fnd_message.get,1,80); -- bug 2595834

5174: -- Default return values for nulls
5175: --
5176: fnd_message.set_name('BEN','BEN_91792_ALL_PROMPT');
5177: --l_all := fnd_message.get;
5178: l_all := substrb(fnd_message.get,1,80); -- bug 2595834
5179: fnd_message.set_name('BEN','BEN_91793_NONE_PROMPT');
5180: l_none := substrb(fnd_message.get,1,80); -- bug 2595834
5181: --l_none := fnd_message.get;
5182: --

Line 5179: fnd_message.set_name('BEN','BEN_91793_NONE_PROMPT');

5175: --
5176: fnd_message.set_name('BEN','BEN_91792_ALL_PROMPT');
5177: --l_all := fnd_message.get;
5178: l_all := substrb(fnd_message.get,1,80); -- bug 2595834
5179: fnd_message.set_name('BEN','BEN_91793_NONE_PROMPT');
5180: l_none := substrb(fnd_message.get,1,80); -- bug 2595834
5181: --l_none := fnd_message.get;
5182: --
5183: open c_benefit_actions;

Line 5180: l_none := substrb(fnd_message.get,1,80); -- bug 2595834

5176: fnd_message.set_name('BEN','BEN_91792_ALL_PROMPT');
5177: --l_all := fnd_message.get;
5178: l_all := substrb(fnd_message.get,1,80); -- bug 2595834
5179: fnd_message.set_name('BEN','BEN_91793_NONE_PROMPT');
5180: l_none := substrb(fnd_message.get,1,80); -- bug 2595834
5181: --l_none := fnd_message.get;
5182: --
5183: open c_benefit_actions;
5184: fetch c_benefit_actions into p_process_date,

Line 5181: --l_none := fnd_message.get;

5177: --l_all := fnd_message.get;
5178: l_all := substrb(fnd_message.get,1,80); -- bug 2595834
5179: fnd_message.set_name('BEN','BEN_91793_NONE_PROMPT');
5180: l_none := substrb(fnd_message.get,1,80); -- bug 2595834
5181: --l_none := fnd_message.get;
5182: --
5183: open c_benefit_actions;
5184: fetch c_benefit_actions into p_process_date,
5185: p_mode,