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

460: --
461: exception
462: --
463: when error_limit then
464: fnd_message.set_name('BEN', 'BEN_92163_BENTMPCM_ERR_LMT');
465: fnd_message.set_token('PROC',l_proc);
466: benutils.write(p_text => fnd_message.get);
467: raise;
468: --

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

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

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

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

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

497: --
498: when others then
499: --
500: benutils.write(p_text => sqlerrm);
501: fnd_message.set_name('BEN','BEN_91663_BENMNGLE_LOGGING');
502: fnd_message.set_token('PROC',l_proc);
503: benutils.write(p_text => fnd_message.get);
504: fnd_message.raise_error;
505: --

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

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

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

499: --
500: benutils.write(p_text => sqlerrm);
501: fnd_message.set_name('BEN','BEN_91663_BENMNGLE_LOGGING');
502: fnd_message.set_token('PROC',l_proc);
503: benutils.write(p_text => fnd_message.get);
504: fnd_message.raise_error;
505: --
506: end write_logfile;
507: --

Line 504: fnd_message.raise_error;

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

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

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

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

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

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

1326: --
1327: g_rec.rep_typ_cd := 'COMMU';
1328: fnd_message.set_name('BEN','BEN_92182_COMM_GNRTD');
1329: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1330: g_rec.text := fnd_message.get;
1331: --
1332: else
1333: --
1334: g_rec.rep_typ_cd := 'NOCOMMU';

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

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

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

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

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

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

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

1555: -- p_person_selection_rule_id and p_person_id are mutually exclusive
1556: --
1557: if g_parm.person_id is not null and
1558: g_parm.person_sel_rl is not null then
1559: fnd_message.set_name('BEN','BEN_91745_RULE_AND_PERSON');
1560: fnd_message.set_token('PROC',l_proc);
1561: fnd_message.set_token('PERSON_ID',to_char(g_parm.person_id));
1562: fnd_message.set_token('PER_SELECT_RL',
1563: 'person_selection_rule :'||g_parm.person_sel_rl);

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

1556: --
1557: if g_parm.person_id is not null and
1558: g_parm.person_sel_rl is not null then
1559: fnd_message.set_name('BEN','BEN_91745_RULE_AND_PERSON');
1560: fnd_message.set_token('PROC',l_proc);
1561: fnd_message.set_token('PERSON_ID',to_char(g_parm.person_id));
1562: fnd_message.set_token('PER_SELECT_RL',
1563: 'person_selection_rule :'||g_parm.person_sel_rl);
1564: fnd_message.raise_error;

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

1557: if g_parm.person_id is not null and
1558: g_parm.person_sel_rl is not null then
1559: fnd_message.set_name('BEN','BEN_91745_RULE_AND_PERSON');
1560: fnd_message.set_token('PROC',l_proc);
1561: fnd_message.set_token('PERSON_ID',to_char(g_parm.person_id));
1562: fnd_message.set_token('PER_SELECT_RL',
1563: 'person_selection_rule :'||g_parm.person_sel_rl);
1564: fnd_message.raise_error;
1565: end if;

Line 1562: fnd_message.set_token('PER_SELECT_RL',

1558: g_parm.person_sel_rl is not null then
1559: fnd_message.set_name('BEN','BEN_91745_RULE_AND_PERSON');
1560: fnd_message.set_token('PROC',l_proc);
1561: fnd_message.set_token('PERSON_ID',to_char(g_parm.person_id));
1562: fnd_message.set_token('PER_SELECT_RL',
1563: 'person_selection_rule :'||g_parm.person_sel_rl);
1564: fnd_message.raise_error;
1565: end if;
1566: --

Line 1564: fnd_message.raise_error;

1560: fnd_message.set_token('PROC',l_proc);
1561: fnd_message.set_token('PERSON_ID',to_char(g_parm.person_id));
1562: fnd_message.set_token('PER_SELECT_RL',
1563: 'person_selection_rule :'||g_parm.person_sel_rl);
1564: fnd_message.raise_error;
1565: end if;
1566: --
1567: -- p_person_id must be of p_person_type_id specified
1568: --

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

1573: --
1574: if not(verify_person_type_id(p_person_id => g_parm.person_id,
1575: p_person_type_id => g_parm.person_type_id)) then
1576: --
1577: fnd_message.set_name('BEN','BEN_91748_PERSON_TYPE');
1578: fnd_message.set_token('PROC',l_proc);
1579: fnd_message.set_token('PERSON_ID',to_char(g_parm.person_id));
1580: fnd_message.set_token('PER_TYPE_ID',to_char(g_parm.person_type_id));
1581: fnd_message.raise_error;

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

1574: if not(verify_person_type_id(p_person_id => g_parm.person_id,
1575: p_person_type_id => g_parm.person_type_id)) then
1576: --
1577: fnd_message.set_name('BEN','BEN_91748_PERSON_TYPE');
1578: fnd_message.set_token('PROC',l_proc);
1579: fnd_message.set_token('PERSON_ID',to_char(g_parm.person_id));
1580: fnd_message.set_token('PER_TYPE_ID',to_char(g_parm.person_type_id));
1581: fnd_message.raise_error;
1582: --

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

1575: p_person_type_id => g_parm.person_type_id)) then
1576: --
1577: fnd_message.set_name('BEN','BEN_91748_PERSON_TYPE');
1578: fnd_message.set_token('PROC',l_proc);
1579: fnd_message.set_token('PERSON_ID',to_char(g_parm.person_id));
1580: fnd_message.set_token('PER_TYPE_ID',to_char(g_parm.person_type_id));
1581: fnd_message.raise_error;
1582: --
1583: end if;

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

1576: --
1577: fnd_message.set_name('BEN','BEN_91748_PERSON_TYPE');
1578: fnd_message.set_token('PROC',l_proc);
1579: fnd_message.set_token('PERSON_ID',to_char(g_parm.person_id));
1580: fnd_message.set_token('PER_TYPE_ID',to_char(g_parm.person_type_id));
1581: fnd_message.raise_error;
1582: --
1583: end if;
1584: --

Line 1581: fnd_message.raise_error;

1577: fnd_message.set_name('BEN','BEN_91748_PERSON_TYPE');
1578: fnd_message.set_token('PROC',l_proc);
1579: fnd_message.set_token('PERSON_ID',to_char(g_parm.person_id));
1580: fnd_message.set_token('PER_TYPE_ID',to_char(g_parm.person_type_id));
1581: fnd_message.raise_error;
1582: --
1583: end if;
1584: --
1585: end if;

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

1588: --
1589: if g_parm.plan_in_pgm_flag = 'N' and
1590: g_parm.pgm_id is not null then
1591: --
1592: fnd_message.set_name('BEN', 'BEN_92164_PLN_NIP_PGM_NULL');
1593: -- If you specify a plan as not in a program then the program should be blank.
1594: fnd_message.set_token('PROC',l_proc);
1595: fnd_message.raise_error;
1596: --

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

1590: g_parm.pgm_id is not null then
1591: --
1592: fnd_message.set_name('BEN', 'BEN_92164_PLN_NIP_PGM_NULL');
1593: -- If you specify a plan as not in a program then the program should be blank.
1594: fnd_message.set_token('PROC',l_proc);
1595: fnd_message.raise_error;
1596: --
1597: end if;
1598: --

Line 1595: fnd_message.raise_error;

1591: --
1592: fnd_message.set_name('BEN', 'BEN_92164_PLN_NIP_PGM_NULL');
1593: -- If you specify a plan as not in a program then the program should be blank.
1594: fnd_message.set_token('PROC',l_proc);
1595: fnd_message.raise_error;
1596: --
1597: end if;
1598: --
1599: -- Business rule for the emerging event trigger type:

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

1608: g_parm.los_fctr_id is null and
1609: g_parm.min_los is null and
1610: g_parm.max_los is null and
1611: g_parm.cmbn_age_los_fctr_id is null then
1612: fnd_message.set_name('BEN','BEN_92165_ATLEAST_ONE_FCTR');
1613: fnd_message.set_token('PROC',l_proc);
1614: fnd_message.raise_error;
1615: end if;
1616: --

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

1609: g_parm.min_los is null and
1610: g_parm.max_los is null and
1611: g_parm.cmbn_age_los_fctr_id is null then
1612: fnd_message.set_name('BEN','BEN_92165_ATLEAST_ONE_FCTR');
1613: fnd_message.set_token('PROC',l_proc);
1614: fnd_message.raise_error;
1615: end if;
1616: --
1617: -- If evaluating LOS then check if the person type is compatible.

Line 1614: fnd_message.raise_error;

1610: g_parm.max_los is null and
1611: g_parm.cmbn_age_los_fctr_id is null then
1612: fnd_message.set_name('BEN','BEN_92165_ATLEAST_ONE_FCTR');
1613: fnd_message.set_token('PROC',l_proc);
1614: fnd_message.raise_error;
1615: end if;
1616: --
1617: -- If evaluating LOS then check if the person type is compatible.
1618: --

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

1629: or l_person_type = 'OTHER' -- External, Contact
1630: or l_person_type = 'APL' -- Applicant
1631: then
1632: --
1633: fnd_message.set_name('BEN','BEN_92166_INVLD_PER_TYPE');
1634: fnd_message.set_token('PROC',l_proc);
1635: fnd_message.set_token('PER_TYP',l_person_type);
1636: fnd_message.raise_error;
1637: --

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

1630: or l_person_type = 'APL' -- Applicant
1631: then
1632: --
1633: fnd_message.set_name('BEN','BEN_92166_INVLD_PER_TYPE');
1634: fnd_message.set_token('PROC',l_proc);
1635: fnd_message.set_token('PER_TYP',l_person_type);
1636: fnd_message.raise_error;
1637: --
1638: end if;

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

1631: then
1632: --
1633: fnd_message.set_name('BEN','BEN_92166_INVLD_PER_TYPE');
1634: fnd_message.set_token('PROC',l_proc);
1635: fnd_message.set_token('PER_TYP',l_person_type);
1636: fnd_message.raise_error;
1637: --
1638: end if;
1639: --

Line 1636: fnd_message.raise_error;

1632: --
1633: fnd_message.set_name('BEN','BEN_92166_INVLD_PER_TYPE');
1634: fnd_message.set_token('PROC',l_proc);
1635: fnd_message.set_token('PER_TYP',l_person_type);
1636: fnd_message.raise_error;
1637: --
1638: end if;
1639: --
1640: end if;

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

1648: --
1649: if g_parm.min_age is not null or
1650: g_parm.max_age is not null then
1651: --
1652: fnd_message.set_name('BEN', 'BEN_92167_NO_MINMAX_WHEN_FCTR');
1653: fnd_message.set_token('PROC',l_proc);
1654: fnd_message.set_token('MIN','Min Age : '||g_parm.min_age);
1655: fnd_message.set_token('MAX','Max Age : '||g_parm.max_age);
1656: --

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

1649: if g_parm.min_age is not null or
1650: g_parm.max_age is not null then
1651: --
1652: fnd_message.set_name('BEN', 'BEN_92167_NO_MINMAX_WHEN_FCTR');
1653: fnd_message.set_token('PROC',l_proc);
1654: fnd_message.set_token('MIN','Min Age : '||g_parm.min_age);
1655: fnd_message.set_token('MAX','Max Age : '||g_parm.max_age);
1656: --
1657: -- Do not specify the min and max values when selecting a predefined

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

1650: g_parm.max_age is not null then
1651: --
1652: fnd_message.set_name('BEN', 'BEN_92167_NO_MINMAX_WHEN_FCTR');
1653: fnd_message.set_token('PROC',l_proc);
1654: fnd_message.set_token('MIN','Min Age : '||g_parm.min_age);
1655: fnd_message.set_token('MAX','Max Age : '||g_parm.max_age);
1656: --
1657: -- Do not specify the min and max values when selecting a predefined
1658: -- FCTR factor.

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

1651: --
1652: fnd_message.set_name('BEN', 'BEN_92167_NO_MINMAX_WHEN_FCTR');
1653: fnd_message.set_token('PROC',l_proc);
1654: fnd_message.set_token('MIN','Min Age : '||g_parm.min_age);
1655: fnd_message.set_token('MAX','Max Age : '||g_parm.max_age);
1656: --
1657: -- Do not specify the min and max values when selecting a predefined
1658: -- FCTR factor.
1659: --

Line 1660: fnd_message.raise_error;

1656: --
1657: -- Do not specify the min and max values when selecting a predefined
1658: -- FCTR factor.
1659: --
1660: fnd_message.raise_error;
1661: --
1662: end if;
1663: --
1664: if g_parm.los_fctr_id is not null or

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

1664: if g_parm.los_fctr_id is not null or
1665: g_parm.min_los is not null or
1666: g_parm.max_los is not null or
1667: g_parm.cmbn_age_los_fctr_id is not null then
1668: fnd_message.set_name('BEN', 'BEN_92168_ONLY_ONE_FCTR');
1669: fnd_message.set_token('PROC',l_proc);
1670: fnd_message.set_token('LOS_FCTR_ID',to_char(g_parm.los_fctr_id));
1671: fnd_message.set_token('AGE_FCTR_ID',to_char(g_parm.age_fctr_id));
1672: fnd_message.set_token('MIN_LOS',to_char(g_parm.min_los));

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

1665: g_parm.min_los is not null or
1666: g_parm.max_los is not null or
1667: g_parm.cmbn_age_los_fctr_id is not null then
1668: fnd_message.set_name('BEN', 'BEN_92168_ONLY_ONE_FCTR');
1669: fnd_message.set_token('PROC',l_proc);
1670: fnd_message.set_token('LOS_FCTR_ID',to_char(g_parm.los_fctr_id));
1671: fnd_message.set_token('AGE_FCTR_ID',to_char(g_parm.age_fctr_id));
1672: fnd_message.set_token('MIN_LOS',to_char(g_parm.min_los));
1673: fnd_message.set_token('MAX_LOS',to_char(g_parm.max_los));

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

1666: g_parm.max_los is not null or
1667: g_parm.cmbn_age_los_fctr_id is not null then
1668: fnd_message.set_name('BEN', 'BEN_92168_ONLY_ONE_FCTR');
1669: fnd_message.set_token('PROC',l_proc);
1670: fnd_message.set_token('LOS_FCTR_ID',to_char(g_parm.los_fctr_id));
1671: fnd_message.set_token('AGE_FCTR_ID',to_char(g_parm.age_fctr_id));
1672: fnd_message.set_token('MIN_LOS',to_char(g_parm.min_los));
1673: fnd_message.set_token('MAX_LOS',to_char(g_parm.max_los));
1674: fnd_message.set_token('MIN_AGE',to_char(g_parm.min_age));

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

1667: g_parm.cmbn_age_los_fctr_id is not null then
1668: fnd_message.set_name('BEN', 'BEN_92168_ONLY_ONE_FCTR');
1669: fnd_message.set_token('PROC',l_proc);
1670: fnd_message.set_token('LOS_FCTR_ID',to_char(g_parm.los_fctr_id));
1671: fnd_message.set_token('AGE_FCTR_ID',to_char(g_parm.age_fctr_id));
1672: fnd_message.set_token('MIN_LOS',to_char(g_parm.min_los));
1673: fnd_message.set_token('MAX_LOS',to_char(g_parm.max_los));
1674: fnd_message.set_token('MIN_AGE',to_char(g_parm.min_age));
1675: fnd_message.set_token('MAX_AGE',to_char(g_parm.max_age));

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

1668: fnd_message.set_name('BEN', 'BEN_92168_ONLY_ONE_FCTR');
1669: fnd_message.set_token('PROC',l_proc);
1670: fnd_message.set_token('LOS_FCTR_ID',to_char(g_parm.los_fctr_id));
1671: fnd_message.set_token('AGE_FCTR_ID',to_char(g_parm.age_fctr_id));
1672: fnd_message.set_token('MIN_LOS',to_char(g_parm.min_los));
1673: fnd_message.set_token('MAX_LOS',to_char(g_parm.max_los));
1674: fnd_message.set_token('MIN_AGE',to_char(g_parm.min_age));
1675: fnd_message.set_token('MAX_AGE',to_char(g_parm.max_age));
1676: fnd_message.set_token('CMBN_AGE_LOS_FCTR_ID',

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

1669: fnd_message.set_token('PROC',l_proc);
1670: fnd_message.set_token('LOS_FCTR_ID',to_char(g_parm.los_fctr_id));
1671: fnd_message.set_token('AGE_FCTR_ID',to_char(g_parm.age_fctr_id));
1672: fnd_message.set_token('MIN_LOS',to_char(g_parm.min_los));
1673: fnd_message.set_token('MAX_LOS',to_char(g_parm.max_los));
1674: fnd_message.set_token('MIN_AGE',to_char(g_parm.min_age));
1675: fnd_message.set_token('MAX_AGE',to_char(g_parm.max_age));
1676: fnd_message.set_token('CMBN_AGE_LOS_FCTR_ID',
1677: to_char(g_parm.cmbn_age_los_fctr_id));

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

1670: fnd_message.set_token('LOS_FCTR_ID',to_char(g_parm.los_fctr_id));
1671: fnd_message.set_token('AGE_FCTR_ID',to_char(g_parm.age_fctr_id));
1672: fnd_message.set_token('MIN_LOS',to_char(g_parm.min_los));
1673: fnd_message.set_token('MAX_LOS',to_char(g_parm.max_los));
1674: fnd_message.set_token('MIN_AGE',to_char(g_parm.min_age));
1675: fnd_message.set_token('MAX_AGE',to_char(g_parm.max_age));
1676: fnd_message.set_token('CMBN_AGE_LOS_FCTR_ID',
1677: to_char(g_parm.cmbn_age_los_fctr_id));
1678: fnd_message.raise_error;

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

1671: fnd_message.set_token('AGE_FCTR_ID',to_char(g_parm.age_fctr_id));
1672: fnd_message.set_token('MIN_LOS',to_char(g_parm.min_los));
1673: fnd_message.set_token('MAX_LOS',to_char(g_parm.max_los));
1674: fnd_message.set_token('MIN_AGE',to_char(g_parm.min_age));
1675: fnd_message.set_token('MAX_AGE',to_char(g_parm.max_age));
1676: fnd_message.set_token('CMBN_AGE_LOS_FCTR_ID',
1677: to_char(g_parm.cmbn_age_los_fctr_id));
1678: fnd_message.raise_error;
1679: end if;

Line 1676: fnd_message.set_token('CMBN_AGE_LOS_FCTR_ID',

1672: fnd_message.set_token('MIN_LOS',to_char(g_parm.min_los));
1673: fnd_message.set_token('MAX_LOS',to_char(g_parm.max_los));
1674: fnd_message.set_token('MIN_AGE',to_char(g_parm.min_age));
1675: fnd_message.set_token('MAX_AGE',to_char(g_parm.max_age));
1676: fnd_message.set_token('CMBN_AGE_LOS_FCTR_ID',
1677: to_char(g_parm.cmbn_age_los_fctr_id));
1678: fnd_message.raise_error;
1679: end if;
1680: --

Line 1678: fnd_message.raise_error;

1674: fnd_message.set_token('MIN_AGE',to_char(g_parm.min_age));
1675: fnd_message.set_token('MAX_AGE',to_char(g_parm.max_age));
1676: fnd_message.set_token('CMBN_AGE_LOS_FCTR_ID',
1677: to_char(g_parm.cmbn_age_los_fctr_id));
1678: fnd_message.raise_error;
1679: end if;
1680: --
1681: end if;
1682: --

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

1686: --
1687: if g_parm.min_los is not null or
1688: g_parm.max_los is not null then
1689: --
1690: fnd_message.set_name('BEN', 'BEN_92167_NO_MINMAX_WHEN_FCTR');
1691: fnd_message.set_token('PROC',l_proc);
1692: fnd_message.set_token('MIN','Min Length of Service : '||g_parm.min_los);
1693: fnd_message.set_token('MAX','Max Length of Service : '||g_parm.max_los);
1694: --

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

1687: if g_parm.min_los is not null or
1688: g_parm.max_los is not null then
1689: --
1690: fnd_message.set_name('BEN', 'BEN_92167_NO_MINMAX_WHEN_FCTR');
1691: fnd_message.set_token('PROC',l_proc);
1692: fnd_message.set_token('MIN','Min Length of Service : '||g_parm.min_los);
1693: fnd_message.set_token('MAX','Max Length of Service : '||g_parm.max_los);
1694: --
1695: -- Do not specify the min and max values when selecting a predefined

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

1688: g_parm.max_los is not null then
1689: --
1690: fnd_message.set_name('BEN', 'BEN_92167_NO_MINMAX_WHEN_FCTR');
1691: fnd_message.set_token('PROC',l_proc);
1692: fnd_message.set_token('MIN','Min Length of Service : '||g_parm.min_los);
1693: fnd_message.set_token('MAX','Max Length of Service : '||g_parm.max_los);
1694: --
1695: -- Do not specify the min and max values when selecting a predefined
1696: -- FCTR factor.

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

1689: --
1690: fnd_message.set_name('BEN', 'BEN_92167_NO_MINMAX_WHEN_FCTR');
1691: fnd_message.set_token('PROC',l_proc);
1692: fnd_message.set_token('MIN','Min Length of Service : '||g_parm.min_los);
1693: fnd_message.set_token('MAX','Max Length of Service : '||g_parm.max_los);
1694: --
1695: -- Do not specify the min and max values when selecting a predefined
1696: -- FCTR factor.
1697: --

Line 1698: fnd_message.raise_error;

1694: --
1695: -- Do not specify the min and max values when selecting a predefined
1696: -- FCTR factor.
1697: --
1698: fnd_message.raise_error;
1699: --
1700: end if;
1701: --
1702: if g_parm.age_fctr_id is not null or

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

1702: if g_parm.age_fctr_id is not null or
1703: g_parm.min_age is not null or
1704: g_parm.max_age is not null or
1705: g_parm.cmbn_age_los_fctr_id is not null then
1706: fnd_message.set_name('BEN', 'BEN_92168_ONLY_ONE_FCTR');
1707: fnd_message.set_token('PROC',l_proc);
1708: fnd_message.set_token('LOS_FCTR_ID',to_char(g_parm.los_fctr_id));
1709: fnd_message.set_token('AGE_FCTR_ID',to_char(g_parm.age_fctr_id));
1710: fnd_message.set_token('MIN_LOS',to_char(g_parm.min_los));

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

1703: g_parm.min_age is not null or
1704: g_parm.max_age is not null or
1705: g_parm.cmbn_age_los_fctr_id is not null then
1706: fnd_message.set_name('BEN', 'BEN_92168_ONLY_ONE_FCTR');
1707: fnd_message.set_token('PROC',l_proc);
1708: fnd_message.set_token('LOS_FCTR_ID',to_char(g_parm.los_fctr_id));
1709: fnd_message.set_token('AGE_FCTR_ID',to_char(g_parm.age_fctr_id));
1710: fnd_message.set_token('MIN_LOS',to_char(g_parm.min_los));
1711: fnd_message.set_token('MAX_LOS',to_char(g_parm.max_los));

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

1704: g_parm.max_age is not null or
1705: g_parm.cmbn_age_los_fctr_id is not null then
1706: fnd_message.set_name('BEN', 'BEN_92168_ONLY_ONE_FCTR');
1707: fnd_message.set_token('PROC',l_proc);
1708: fnd_message.set_token('LOS_FCTR_ID',to_char(g_parm.los_fctr_id));
1709: fnd_message.set_token('AGE_FCTR_ID',to_char(g_parm.age_fctr_id));
1710: fnd_message.set_token('MIN_LOS',to_char(g_parm.min_los));
1711: fnd_message.set_token('MAX_LOS',to_char(g_parm.max_los));
1712: fnd_message.set_token('MIN_AGE',to_char(g_parm.min_age));

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

1705: g_parm.cmbn_age_los_fctr_id is not null then
1706: fnd_message.set_name('BEN', 'BEN_92168_ONLY_ONE_FCTR');
1707: fnd_message.set_token('PROC',l_proc);
1708: fnd_message.set_token('LOS_FCTR_ID',to_char(g_parm.los_fctr_id));
1709: fnd_message.set_token('AGE_FCTR_ID',to_char(g_parm.age_fctr_id));
1710: fnd_message.set_token('MIN_LOS',to_char(g_parm.min_los));
1711: fnd_message.set_token('MAX_LOS',to_char(g_parm.max_los));
1712: fnd_message.set_token('MIN_AGE',to_char(g_parm.min_age));
1713: fnd_message.set_token('MAX_AGE',to_char(g_parm.max_age));

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

1706: fnd_message.set_name('BEN', 'BEN_92168_ONLY_ONE_FCTR');
1707: fnd_message.set_token('PROC',l_proc);
1708: fnd_message.set_token('LOS_FCTR_ID',to_char(g_parm.los_fctr_id));
1709: fnd_message.set_token('AGE_FCTR_ID',to_char(g_parm.age_fctr_id));
1710: fnd_message.set_token('MIN_LOS',to_char(g_parm.min_los));
1711: fnd_message.set_token('MAX_LOS',to_char(g_parm.max_los));
1712: fnd_message.set_token('MIN_AGE',to_char(g_parm.min_age));
1713: fnd_message.set_token('MAX_AGE',to_char(g_parm.max_age));
1714: fnd_message.set_token('CMBN_AGE_LOS_FCTR_ID',

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

1707: fnd_message.set_token('PROC',l_proc);
1708: fnd_message.set_token('LOS_FCTR_ID',to_char(g_parm.los_fctr_id));
1709: fnd_message.set_token('AGE_FCTR_ID',to_char(g_parm.age_fctr_id));
1710: fnd_message.set_token('MIN_LOS',to_char(g_parm.min_los));
1711: fnd_message.set_token('MAX_LOS',to_char(g_parm.max_los));
1712: fnd_message.set_token('MIN_AGE',to_char(g_parm.min_age));
1713: fnd_message.set_token('MAX_AGE',to_char(g_parm.max_age));
1714: fnd_message.set_token('CMBN_AGE_LOS_FCTR_ID',
1715: to_char(g_parm.cmbn_age_los_fctr_id));

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

1708: fnd_message.set_token('LOS_FCTR_ID',to_char(g_parm.los_fctr_id));
1709: fnd_message.set_token('AGE_FCTR_ID',to_char(g_parm.age_fctr_id));
1710: fnd_message.set_token('MIN_LOS',to_char(g_parm.min_los));
1711: fnd_message.set_token('MAX_LOS',to_char(g_parm.max_los));
1712: fnd_message.set_token('MIN_AGE',to_char(g_parm.min_age));
1713: fnd_message.set_token('MAX_AGE',to_char(g_parm.max_age));
1714: fnd_message.set_token('CMBN_AGE_LOS_FCTR_ID',
1715: to_char(g_parm.cmbn_age_los_fctr_id));
1716: fnd_message.raise_error;

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

1709: fnd_message.set_token('AGE_FCTR_ID',to_char(g_parm.age_fctr_id));
1710: fnd_message.set_token('MIN_LOS',to_char(g_parm.min_los));
1711: fnd_message.set_token('MAX_LOS',to_char(g_parm.max_los));
1712: fnd_message.set_token('MIN_AGE',to_char(g_parm.min_age));
1713: fnd_message.set_token('MAX_AGE',to_char(g_parm.max_age));
1714: fnd_message.set_token('CMBN_AGE_LOS_FCTR_ID',
1715: to_char(g_parm.cmbn_age_los_fctr_id));
1716: fnd_message.raise_error;
1717: end if;

Line 1714: fnd_message.set_token('CMBN_AGE_LOS_FCTR_ID',

1710: fnd_message.set_token('MIN_LOS',to_char(g_parm.min_los));
1711: fnd_message.set_token('MAX_LOS',to_char(g_parm.max_los));
1712: fnd_message.set_token('MIN_AGE',to_char(g_parm.min_age));
1713: fnd_message.set_token('MAX_AGE',to_char(g_parm.max_age));
1714: fnd_message.set_token('CMBN_AGE_LOS_FCTR_ID',
1715: to_char(g_parm.cmbn_age_los_fctr_id));
1716: fnd_message.raise_error;
1717: end if;
1718: --

Line 1716: fnd_message.raise_error;

1712: fnd_message.set_token('MIN_AGE',to_char(g_parm.min_age));
1713: fnd_message.set_token('MAX_AGE',to_char(g_parm.max_age));
1714: fnd_message.set_token('CMBN_AGE_LOS_FCTR_ID',
1715: to_char(g_parm.cmbn_age_los_fctr_id));
1716: fnd_message.raise_error;
1717: end if;
1718: --
1719: end if;
1720: --

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1733: fnd_message.set_token('CMBN_AGE_LOS_FCTR_ID',

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

Line 1735: fnd_message.raise_error;

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

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

1744: --
1745: -- Check if the min is greater than then max
1746: --
1747: if g_parm.min_age > g_parm.max_age then
1748: fnd_message.set_name('BEN', 'BEN_92534_MIN_MAX');
1749: fnd_message.set_token('PROC',l_proc);
1750: fnd_message.set_token('MIN','Minimum Age : '||g_parm.min_age);
1751: fnd_message.set_token('MAX','Maximum Age : '||g_parm.max_age);
1752: fnd_message.raise_error;

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

1745: -- Check if the min is greater than then max
1746: --
1747: if g_parm.min_age > g_parm.max_age then
1748: fnd_message.set_name('BEN', 'BEN_92534_MIN_MAX');
1749: fnd_message.set_token('PROC',l_proc);
1750: fnd_message.set_token('MIN','Minimum Age : '||g_parm.min_age);
1751: fnd_message.set_token('MAX','Maximum Age : '||g_parm.max_age);
1752: fnd_message.raise_error;
1753: end if;

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

1746: --
1747: if g_parm.min_age > g_parm.max_age then
1748: fnd_message.set_name('BEN', 'BEN_92534_MIN_MAX');
1749: fnd_message.set_token('PROC',l_proc);
1750: fnd_message.set_token('MIN','Minimum Age : '||g_parm.min_age);
1751: fnd_message.set_token('MAX','Maximum Age : '||g_parm.max_age);
1752: fnd_message.raise_error;
1753: end if;
1754: --

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

1747: if g_parm.min_age > g_parm.max_age then
1748: fnd_message.set_name('BEN', 'BEN_92534_MIN_MAX');
1749: fnd_message.set_token('PROC',l_proc);
1750: fnd_message.set_token('MIN','Minimum Age : '||g_parm.min_age);
1751: fnd_message.set_token('MAX','Maximum Age : '||g_parm.max_age);
1752: fnd_message.raise_error;
1753: end if;
1754: --
1755: -- If only a max value is being provided, error out because if the user

Line 1752: fnd_message.raise_error;

1748: fnd_message.set_name('BEN', 'BEN_92534_MIN_MAX');
1749: fnd_message.set_token('PROC',l_proc);
1750: fnd_message.set_token('MIN','Minimum Age : '||g_parm.min_age);
1751: fnd_message.set_token('MAX','Maximum Age : '||g_parm.max_age);
1752: fnd_message.raise_error;
1753: end if;
1754: --
1755: -- If only a max value is being provided, error out because if the user
1756: -- wants to evaluate a threshold, the min can be used for that purpose

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

1756: -- wants to evaluate a threshold, the min can be used for that purpose
1757: --
1758: if g_parm.min_age is null and
1759: g_parm.max_age is not null then
1760: fnd_message.set_name('BEN', 'BEN_92169_ONLY_MIN_OR_BOTH');
1761: fnd_message.set_token('PROC',l_proc);
1762: fnd_message.set_token('MIN','Minimum Age : '||g_parm.min_age);
1763: fnd_message.set_token('MAX','Maximum Age : '||g_parm.max_age);
1764: -- Only max value specified. Provide only the min value or both min and

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

1757: --
1758: if g_parm.min_age is null and
1759: g_parm.max_age is not null then
1760: fnd_message.set_name('BEN', 'BEN_92169_ONLY_MIN_OR_BOTH');
1761: fnd_message.set_token('PROC',l_proc);
1762: fnd_message.set_token('MIN','Minimum Age : '||g_parm.min_age);
1763: fnd_message.set_token('MAX','Maximum Age : '||g_parm.max_age);
1764: -- Only max value specified. Provide only the min value or both min and
1765: -- max values.

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

1758: if g_parm.min_age is null and
1759: g_parm.max_age is not null then
1760: fnd_message.set_name('BEN', 'BEN_92169_ONLY_MIN_OR_BOTH');
1761: fnd_message.set_token('PROC',l_proc);
1762: fnd_message.set_token('MIN','Minimum Age : '||g_parm.min_age);
1763: fnd_message.set_token('MAX','Maximum Age : '||g_parm.max_age);
1764: -- Only max value specified. Provide only the min value or both min and
1765: -- max values.
1766: fnd_message.raise_error;

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

1759: g_parm.max_age is not null then
1760: fnd_message.set_name('BEN', 'BEN_92169_ONLY_MIN_OR_BOTH');
1761: fnd_message.set_token('PROC',l_proc);
1762: fnd_message.set_token('MIN','Minimum Age : '||g_parm.min_age);
1763: fnd_message.set_token('MAX','Maximum Age : '||g_parm.max_age);
1764: -- Only max value specified. Provide only the min value or both min and
1765: -- max values.
1766: fnd_message.raise_error;
1767: end if;

Line 1766: fnd_message.raise_error;

1762: fnd_message.set_token('MIN','Minimum Age : '||g_parm.min_age);
1763: fnd_message.set_token('MAX','Maximum Age : '||g_parm.max_age);
1764: -- Only max value specified. Provide only the min value or both min and
1765: -- max values.
1766: fnd_message.raise_error;
1767: end if;
1768: --
1769: -- When evaluating this derived factor, all other parameters relating to
1770: -- other derived factors should be null.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1784: fnd_message.set_token('CMBN_AGE_LOS_FCTR_ID',

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

Line 1787: fnd_message.raise_error;

1783: fnd_message.set_token('MAX_AGE',to_char(g_parm.max_age));
1784: fnd_message.set_token('CMBN_AGE_LOS_FCTR_ID',
1785: to_char(g_parm.cmbn_age_los_fctr_id));
1786: --
1787: fnd_message.raise_error;
1788: end if;
1789: --
1790: elsif g_parm.min_los is not null or
1791: g_parm.max_los is not null then

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

1792: --
1793: -- Check if the min is greater than then max
1794: --
1795: if g_parm.min_los > g_parm.max_los then
1796: fnd_message.set_name('BEN', 'BEN_92534_MIN_MAX');
1797: fnd_message.set_token('PROC',l_proc);
1798: fnd_message.set_token('MIN',
1799: 'Minimum Length of Service : '||g_parm.min_los);
1800: fnd_message.set_token('MAX',

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

1793: -- Check if the min is greater than then max
1794: --
1795: if g_parm.min_los > g_parm.max_los then
1796: fnd_message.set_name('BEN', 'BEN_92534_MIN_MAX');
1797: fnd_message.set_token('PROC',l_proc);
1798: fnd_message.set_token('MIN',
1799: 'Minimum Length of Service : '||g_parm.min_los);
1800: fnd_message.set_token('MAX',
1801: 'Maximum Length of Service : '||g_parm.max_los);

Line 1798: fnd_message.set_token('MIN',

1794: --
1795: if g_parm.min_los > g_parm.max_los then
1796: fnd_message.set_name('BEN', 'BEN_92534_MIN_MAX');
1797: fnd_message.set_token('PROC',l_proc);
1798: fnd_message.set_token('MIN',
1799: 'Minimum Length of Service : '||g_parm.min_los);
1800: fnd_message.set_token('MAX',
1801: 'Maximum Length of Service : '||g_parm.max_los);
1802: fnd_message.raise_error;

Line 1800: fnd_message.set_token('MAX',

1796: fnd_message.set_name('BEN', 'BEN_92534_MIN_MAX');
1797: fnd_message.set_token('PROC',l_proc);
1798: fnd_message.set_token('MIN',
1799: 'Minimum Length of Service : '||g_parm.min_los);
1800: fnd_message.set_token('MAX',
1801: 'Maximum Length of Service : '||g_parm.max_los);
1802: fnd_message.raise_error;
1803: end if;
1804: --

Line 1802: fnd_message.raise_error;

1798: fnd_message.set_token('MIN',
1799: 'Minimum Length of Service : '||g_parm.min_los);
1800: fnd_message.set_token('MAX',
1801: 'Maximum Length of Service : '||g_parm.max_los);
1802: fnd_message.raise_error;
1803: end if;
1804: --
1805: -- If only a max value is being provided, error out because if the user
1806: -- wants to evaluate a threshold, the min can be used for that purpose

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

1806: -- wants to evaluate a threshold, the min can be used for that purpose
1807: --
1808: if g_parm.min_los is null and
1809: g_parm.max_los is not null then
1810: fnd_message.set_name('BEN', 'BEN_92169_ONLY_MIN_OR_BOTH');
1811: fnd_message.set_token('PROC',l_proc);
1812: fnd_message.set_token('MIN',
1813: 'Minimum Length of Service : '||g_parm.min_los);
1814: fnd_message.set_token('MAX',

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

1807: --
1808: if g_parm.min_los is null and
1809: g_parm.max_los is not null then
1810: fnd_message.set_name('BEN', 'BEN_92169_ONLY_MIN_OR_BOTH');
1811: fnd_message.set_token('PROC',l_proc);
1812: fnd_message.set_token('MIN',
1813: 'Minimum Length of Service : '||g_parm.min_los);
1814: fnd_message.set_token('MAX',
1815: 'Maximum Length of Service : '||g_parm.max_los);

Line 1812: fnd_message.set_token('MIN',

1808: if g_parm.min_los is null and
1809: g_parm.max_los is not null then
1810: fnd_message.set_name('BEN', 'BEN_92169_ONLY_MIN_OR_BOTH');
1811: fnd_message.set_token('PROC',l_proc);
1812: fnd_message.set_token('MIN',
1813: 'Minimum Length of Service : '||g_parm.min_los);
1814: fnd_message.set_token('MAX',
1815: 'Maximum Length of Service : '||g_parm.max_los);
1816: fnd_message.raise_error;

Line 1814: fnd_message.set_token('MAX',

1810: fnd_message.set_name('BEN', 'BEN_92169_ONLY_MIN_OR_BOTH');
1811: fnd_message.set_token('PROC',l_proc);
1812: fnd_message.set_token('MIN',
1813: 'Minimum Length of Service : '||g_parm.min_los);
1814: fnd_message.set_token('MAX',
1815: 'Maximum Length of Service : '||g_parm.max_los);
1816: fnd_message.raise_error;
1817: end if;
1818: --

Line 1816: fnd_message.raise_error;

1812: fnd_message.set_token('MIN',
1813: 'Minimum Length of Service : '||g_parm.min_los);
1814: fnd_message.set_token('MAX',
1815: 'Maximum Length of Service : '||g_parm.max_los);
1816: fnd_message.raise_error;
1817: end if;
1818: --
1819: -- When evaluating this derived factor, all other parameters relating to
1820: -- other derived factors should be null.

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

1822: if g_parm.age_fctr_id is not null or
1823: g_parm.min_age is not null or
1824: g_parm.max_age is not null or
1825: g_parm.cmbn_age_los_fctr_id is not null then
1826: fnd_message.set_name('BEN', 'BEN_92168_ONLY_ONE_FCTR');
1827: fnd_message.set_token('PROC',l_proc);
1828: fnd_message.set_token('LOS_FCTR_ID',to_char(g_parm.los_fctr_id));
1829: fnd_message.set_token('AGE_FCTR_ID',to_char(g_parm.age_fctr_id));
1830: fnd_message.set_token('MIN_LOS',to_char(g_parm.min_los));

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

1823: g_parm.min_age is not null or
1824: g_parm.max_age is not null or
1825: g_parm.cmbn_age_los_fctr_id is not null then
1826: fnd_message.set_name('BEN', 'BEN_92168_ONLY_ONE_FCTR');
1827: fnd_message.set_token('PROC',l_proc);
1828: fnd_message.set_token('LOS_FCTR_ID',to_char(g_parm.los_fctr_id));
1829: fnd_message.set_token('AGE_FCTR_ID',to_char(g_parm.age_fctr_id));
1830: fnd_message.set_token('MIN_LOS',to_char(g_parm.min_los));
1831: fnd_message.set_token('MAX_LOS',to_char(g_parm.max_los));

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

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

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

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

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

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

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

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

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

1828: fnd_message.set_token('LOS_FCTR_ID',to_char(g_parm.los_fctr_id));
1829: fnd_message.set_token('AGE_FCTR_ID',to_char(g_parm.age_fctr_id));
1830: fnd_message.set_token('MIN_LOS',to_char(g_parm.min_los));
1831: fnd_message.set_token('MAX_LOS',to_char(g_parm.max_los));
1832: fnd_message.set_token('MIN_AGE',to_char(g_parm.min_age));
1833: fnd_message.set_token('MAX_AGE',to_char(g_parm.max_age));
1834: fnd_message.set_token('CMBN_AGE_LOS_FCTR_ID',
1835: to_char(g_parm.cmbn_age_los_fctr_id));
1836: fnd_message.raise_error;

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

1829: fnd_message.set_token('AGE_FCTR_ID',to_char(g_parm.age_fctr_id));
1830: fnd_message.set_token('MIN_LOS',to_char(g_parm.min_los));
1831: fnd_message.set_token('MAX_LOS',to_char(g_parm.max_los));
1832: fnd_message.set_token('MIN_AGE',to_char(g_parm.min_age));
1833: fnd_message.set_token('MAX_AGE',to_char(g_parm.max_age));
1834: fnd_message.set_token('CMBN_AGE_LOS_FCTR_ID',
1835: to_char(g_parm.cmbn_age_los_fctr_id));
1836: fnd_message.raise_error;
1837: end if;

Line 1834: fnd_message.set_token('CMBN_AGE_LOS_FCTR_ID',

1830: fnd_message.set_token('MIN_LOS',to_char(g_parm.min_los));
1831: fnd_message.set_token('MAX_LOS',to_char(g_parm.max_los));
1832: fnd_message.set_token('MIN_AGE',to_char(g_parm.min_age));
1833: fnd_message.set_token('MAX_AGE',to_char(g_parm.max_age));
1834: fnd_message.set_token('CMBN_AGE_LOS_FCTR_ID',
1835: to_char(g_parm.cmbn_age_los_fctr_id));
1836: fnd_message.raise_error;
1837: end if;
1838: --

Line 1836: fnd_message.raise_error;

1832: fnd_message.set_token('MIN_AGE',to_char(g_parm.min_age));
1833: fnd_message.set_token('MAX_AGE',to_char(g_parm.max_age));
1834: fnd_message.set_token('CMBN_AGE_LOS_FCTR_ID',
1835: to_char(g_parm.cmbn_age_los_fctr_id));
1836: fnd_message.raise_error;
1837: end if;
1838: --
1839: end if;
1840: --

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

1850: --
1851: -- If the elig_enrol_cd is being specified, then a comp object must be
1852: -- specified.
1853: --
1854: fnd_message.set_name('BEN', 'BEN_92171_PLAN_OR_PGM');
1855: fnd_message.set_token('PROC',l_proc);
1856: -- A program or a plan must be provided for the mass mailing trigger.
1857: fnd_message.raise_error;
1858: --

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

1851: -- If the elig_enrol_cd is being specified, then a comp object must be
1852: -- specified.
1853: --
1854: fnd_message.set_name('BEN', 'BEN_92171_PLAN_OR_PGM');
1855: fnd_message.set_token('PROC',l_proc);
1856: -- A program or a plan must be provided for the mass mailing trigger.
1857: fnd_message.raise_error;
1858: --
1859: end if;

Line 1857: fnd_message.raise_error;

1853: --
1854: fnd_message.set_name('BEN', 'BEN_92171_PLAN_OR_PGM');
1855: fnd_message.set_token('PROC',l_proc);
1856: -- A program or a plan must be provided for the mass mailing trigger.
1857: fnd_message.raise_error;
1858: --
1859: end if;
1860: --
1861: end if; -- g_parm.cm_trgr_typ_cd = MSSMLG

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

2036: exception
2037: --
2038: when dob_null then
2039: hr_utility.set_location('Exception raised in ' || l_proc, 10);
2040: fnd_message.set_name('BEN', 'BEN_91337_DOB');
2041: fnd_message.set_token('PROC',l_proc);
2042: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2043: -- The person being processed does not have a date of birth.
2044: raise ben_manage_life_events.g_record_error;

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

2037: --
2038: when dob_null then
2039: hr_utility.set_location('Exception raised in ' || l_proc, 10);
2040: fnd_message.set_name('BEN', 'BEN_91337_DOB');
2041: fnd_message.set_token('PROC',l_proc);
2042: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2043: -- The person being processed does not have a date of birth.
2044: raise ben_manage_life_events.g_record_error;
2045: --

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

2038: when dob_null then
2039: hr_utility.set_location('Exception raised in ' || l_proc, 10);
2040: fnd_message.set_name('BEN', 'BEN_91337_DOB');
2041: fnd_message.set_token('PROC',l_proc);
2042: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2043: -- The person being processed does not have a date of birth.
2044: raise ben_manage_life_events.g_record_error;
2045: --
2046: when agf_pgm_or_pl then

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

2044: raise ben_manage_life_events.g_record_error;
2045: --
2046: when agf_pgm_or_pl then
2047: hr_utility.set_location('Exception raised in ' || l_proc, 10);
2048: fnd_message.set_name('BEN','BEN_92181_FCTR_RQR_PGM_OR_PL');
2049: fnd_message.set_token('PROC',l_proc);
2050: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2051: --
2052: -- The derived factor chosen uses a program or a plan year for calculation.

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

2045: --
2046: when agf_pgm_or_pl then
2047: hr_utility.set_location('Exception raised in ' || l_proc, 10);
2048: fnd_message.set_name('BEN','BEN_92181_FCTR_RQR_PGM_OR_PL');
2049: fnd_message.set_token('PROC',l_proc);
2050: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2051: --
2052: -- The derived factor chosen uses a program or a plan year for calculation.
2053: -- Please select a program or plan.

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

2046: when agf_pgm_or_pl then
2047: hr_utility.set_location('Exception raised in ' || l_proc, 10);
2048: fnd_message.set_name('BEN','BEN_92181_FCTR_RQR_PGM_OR_PL');
2049: fnd_message.set_token('PROC',l_proc);
2050: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2051: --
2052: -- The derived factor chosen uses a program or a plan year for calculation.
2053: -- Please select a program or plan.
2054: --

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

2226: --
2227: when lsf_pgm_or_pl then
2228: --
2229: hr_utility.set_location('Leaving : ' || l_proc, 10);
2230: fnd_message.set_name('BEN','BEN_92181_FCTR_RQR_PGM_OR_PL');
2231: fnd_message.set_token('PROC',l_proc);
2232: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2233: --
2234: -- The derived factor chosen uses a program or a plan year for calculation.

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

2227: when lsf_pgm_or_pl then
2228: --
2229: hr_utility.set_location('Leaving : ' || l_proc, 10);
2230: fnd_message.set_name('BEN','BEN_92181_FCTR_RQR_PGM_OR_PL');
2231: fnd_message.set_token('PROC',l_proc);
2232: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2233: --
2234: -- The derived factor chosen uses a program or a plan year for calculation.
2235: -- Please select a program or plan.

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

2228: --
2229: hr_utility.set_location('Leaving : ' || l_proc, 10);
2230: fnd_message.set_name('BEN','BEN_92181_FCTR_RQR_PGM_OR_PL');
2231: fnd_message.set_token('PROC',l_proc);
2232: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2233: --
2234: -- The derived factor chosen uses a program or a plan year for calculation.
2235: -- Please select a program or plan.
2236: --

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

2403: exception
2404: --
2405: when cmbn_pgm_or_pl then
2406: hr_utility.set_location('Exception raised in ' || l_proc, 10);
2407: fnd_message.set_name('BEN','BEN_92181_FCTR_RQR_PGM_OR_PL');
2408: fnd_message.set_token('PROC',l_proc);
2409: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2410: --
2411: -- The derived factor chosen uses a program or plan year for calculation.

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

2404: --
2405: when cmbn_pgm_or_pl then
2406: hr_utility.set_location('Exception raised in ' || l_proc, 10);
2407: fnd_message.set_name('BEN','BEN_92181_FCTR_RQR_PGM_OR_PL');
2408: fnd_message.set_token('PROC',l_proc);
2409: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2410: --
2411: -- The derived factor chosen uses a program or plan year for calculation.
2412: -- Please select a program or plan.

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

2405: when cmbn_pgm_or_pl then
2406: hr_utility.set_location('Exception raised in ' || l_proc, 10);
2407: fnd_message.set_name('BEN','BEN_92181_FCTR_RQR_PGM_OR_PL');
2408: fnd_message.set_token('PROC',l_proc);
2409: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2410: --
2411: -- The derived factor chosen uses a program or plan year for calculation.
2412: -- Please select a program or plan.
2413: --

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

2575: --
2576: g_rec.person_id := l_per_rec.person_id;
2577: g_rec.rep_typ_cd := 'ERRCM';
2578: g_rec.error_message_code := benutils.get_message_name;
2579: g_rec.text := fnd_message.get;
2580: --
2581: benutils.write(p_rec => g_rec);
2582: --
2583: -- Update person action to errored as record has an error

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

2706: rollback to before_communications;
2707: --
2708: g_rec.rep_typ_cd := 'ERRCM';
2709: g_rec.error_message_code := benutils.get_message_name;
2710: g_rec.text := fnd_message.get;
2711: g_rec.person_id := l_per_rec.person_id;
2712: --
2713: benutils.write(p_rec => g_rec);
2714: --

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

2842: rollback to before_communications;
2843: --
2844: g_rec.rep_typ_cd := 'ERRCM';
2845: g_rec.error_message_code := benutils.get_message_name;
2846: g_rec.text := fnd_message.get;
2847: g_rec.person_id := l_per_rec.person_id;
2848: --
2849: benutils.write(p_rec => g_rec);
2850: --

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

2979: hr_utility.set_location ('PERSON ERROR '|| l_proc,10);
2980: --
2981: rollback to before_communications;
2982: --
2983: benutils.write(p_text => fnd_message.get);
2984: --
2985: g_rec.rep_typ_cd := 'ERRCM';
2986: g_rec.error_message_code := benutils.get_message_name;
2987: g_rec.text := fnd_message.get;

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

2983: benutils.write(p_text => fnd_message.get);
2984: --
2985: g_rec.rep_typ_cd := 'ERRCM';
2986: g_rec.error_message_code := benutils.get_message_name;
2987: g_rec.text := fnd_message.get;
2988: g_rec.person_id := l_per_rec.person_id;
2989: --
2990: benutils.write(p_rec => g_rec);
2991: --

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

3078: fetch c_parm into l_parm;
3079: --
3080: if c_parm%notfound then
3081: close c_parm;
3082: fnd_message.set_name('BEN', 'BEN_91753_BENEFIT_ACTION_ERR');
3083: fnd_message.set_token('PROC',l_proc);
3084: fnd_message.raise_error;
3085: end if;
3086: --

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

3079: --
3080: if c_parm%notfound then
3081: close c_parm;
3082: fnd_message.set_name('BEN', 'BEN_91753_BENEFIT_ACTION_ERR');
3083: fnd_message.set_token('PROC',l_proc);
3084: fnd_message.raise_error;
3085: end if;
3086: --
3087: close c_parm;

Line 3084: fnd_message.raise_error;

3080: if c_parm%notfound then
3081: close c_parm;
3082: fnd_message.set_name('BEN', 'BEN_91753_BENEFIT_ACTION_ERR');
3083: fnd_message.set_token('PROC',l_proc);
3084: fnd_message.raise_error;
3085: end if;
3086: --
3087: close c_parm;
3088: --

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

3320: benutils.write(p_text => sqlerrm);
3321: hr_utility.set_location ('BENTMPCM Error '|| l_proc,10);
3322: g_rec.rep_typ_cd := 'FATAL';
3323: g_rec.error_message_code := sqlcode;
3324: g_rec.text := fnd_message.get;
3325: benutils.write(p_rec => g_rec);
3326: --
3327: -- Output log information to log file
3328: --

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

3329: write_logfile;
3330: --
3331: check_all_slaves_finished;
3332: --
3333: fnd_message.set_name('BEN','BEN_92172_BENTMPCM_ERRORED');
3334: fnd_message.set_token('PROC',l_proc);
3335: benutils.write(p_text => fnd_message.get);
3336: benutils.write_table_and_file(p_table => true,
3337: p_file => true);

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

3330: --
3331: check_all_slaves_finished;
3332: --
3333: fnd_message.set_name('BEN','BEN_92172_BENTMPCM_ERRORED');
3334: fnd_message.set_token('PROC',l_proc);
3335: benutils.write(p_text => fnd_message.get);
3336: benutils.write_table_and_file(p_table => true,
3337: p_file => true);
3338: commit;

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

3331: check_all_slaves_finished;
3332: --
3333: fnd_message.set_name('BEN','BEN_92172_BENTMPCM_ERRORED');
3334: fnd_message.set_token('PROC',l_proc);
3335: benutils.write(p_text => fnd_message.get);
3336: benutils.write_table_and_file(p_table => true,
3337: p_file => true);
3338: commit;
3339: --

Line 3340: fnd_message.raise_error;

3336: benutils.write_table_and_file(p_table => true,
3337: p_file => true);
3338: commit;
3339: --
3340: fnd_message.raise_error;
3341: --
3342: end do_multithread;
3343: --
3344: -- ----------------------------------------------------------------------------

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

4810: -- ranges created would have been zero. Raise an error if so.
4811: --
4812: if g_num_ranges = 0 then
4813: --
4814: fnd_message.set_name('BEN', 'BEN_91769_NOONE_TO_PROCESS');
4815: fnd_message.set_token('PROC',l_proc);
4816: fnd_message.raise_error;
4817: --
4818: end if;

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

4811: --
4812: if g_num_ranges = 0 then
4813: --
4814: fnd_message.set_name('BEN', 'BEN_91769_NOONE_TO_PROCESS');
4815: fnd_message.set_token('PROC',l_proc);
4816: fnd_message.raise_error;
4817: --
4818: end if;
4819: --

Line 4816: fnd_message.raise_error;

4812: if g_num_ranges = 0 then
4813: --
4814: fnd_message.set_name('BEN', 'BEN_91769_NOONE_TO_PROCESS');
4815: fnd_message.set_token('PROC',l_proc);
4816: fnd_message.raise_error;
4817: --
4818: end if;
4819: --
4820: -- Set the number of threads to the lesser of the defined number of threads

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

5107: hr_utility.set_location('Entering :'||l_proc,10);
5108: --
5109: -- Default return values for nulls
5110: --
5111: fnd_message.set_name('BEN','BEN_91792_ALL_PROMPT');
5112: --l_all := fnd_message.get;
5113: l_all := substrb(fnd_message.get,1,80); -- bug 2595834
5114: fnd_message.set_name('BEN','BEN_91793_NONE_PROMPT');
5115: l_none := substrb(fnd_message.get,1,80); -- bug 2595834

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

5108: --
5109: -- Default return values for nulls
5110: --
5111: fnd_message.set_name('BEN','BEN_91792_ALL_PROMPT');
5112: --l_all := fnd_message.get;
5113: l_all := substrb(fnd_message.get,1,80); -- bug 2595834
5114: fnd_message.set_name('BEN','BEN_91793_NONE_PROMPT');
5115: l_none := substrb(fnd_message.get,1,80); -- bug 2595834
5116: --l_none := fnd_message.get;

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

5109: -- Default return values for nulls
5110: --
5111: fnd_message.set_name('BEN','BEN_91792_ALL_PROMPT');
5112: --l_all := fnd_message.get;
5113: l_all := substrb(fnd_message.get,1,80); -- bug 2595834
5114: fnd_message.set_name('BEN','BEN_91793_NONE_PROMPT');
5115: l_none := substrb(fnd_message.get,1,80); -- bug 2595834
5116: --l_none := fnd_message.get;
5117: --

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

5110: --
5111: fnd_message.set_name('BEN','BEN_91792_ALL_PROMPT');
5112: --l_all := fnd_message.get;
5113: l_all := substrb(fnd_message.get,1,80); -- bug 2595834
5114: fnd_message.set_name('BEN','BEN_91793_NONE_PROMPT');
5115: l_none := substrb(fnd_message.get,1,80); -- bug 2595834
5116: --l_none := fnd_message.get;
5117: --
5118: open c_benefit_actions;

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

5111: fnd_message.set_name('BEN','BEN_91792_ALL_PROMPT');
5112: --l_all := fnd_message.get;
5113: l_all := substrb(fnd_message.get,1,80); -- bug 2595834
5114: fnd_message.set_name('BEN','BEN_91793_NONE_PROMPT');
5115: l_none := substrb(fnd_message.get,1,80); -- bug 2595834
5116: --l_none := fnd_message.get;
5117: --
5118: open c_benefit_actions;
5119: fetch c_benefit_actions into p_process_date,

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

5112: --l_all := fnd_message.get;
5113: l_all := substrb(fnd_message.get,1,80); -- bug 2595834
5114: fnd_message.set_name('BEN','BEN_91793_NONE_PROMPT');
5115: l_none := substrb(fnd_message.get,1,80); -- bug 2595834
5116: --l_none := fnd_message.get;
5117: --
5118: open c_benefit_actions;
5119: fetch c_benefit_actions into p_process_date,
5120: p_mode,