APPS.BEN_DISTRIBUTE_RATES dependencies on FND_MESSAGE

Line 355: fnd_message.set_name('BEN','BEN_92310_FORMULA_RET_PARAM');

351: -- Account for cases where formula returns an unknown
352: -- variable name
353: hr_utility.set_location('In the Loop wrong Name ',10);
354: --
355: fnd_message.set_name('BEN','BEN_92310_FORMULA_RET_PARAM');
356: fnd_message.set_token('PROC',l_package);
357: fnd_message.set_token('FORMULA',p_formula_id);
358: fnd_message.set_token('PARAMETER',l_outputs(l_count).name);
359: fnd_message.raise_error;

Line 356: fnd_message.set_token('PROC',l_package);

352: -- variable name
353: hr_utility.set_location('In the Loop wrong Name ',10);
354: --
355: fnd_message.set_name('BEN','BEN_92310_FORMULA_RET_PARAM');
356: fnd_message.set_token('PROC',l_package);
357: fnd_message.set_token('FORMULA',p_formula_id);
358: fnd_message.set_token('PARAMETER',l_outputs(l_count).name);
359: fnd_message.raise_error;
360: --

Line 357: fnd_message.set_token('FORMULA',p_formula_id);

353: hr_utility.set_location('In the Loop wrong Name ',10);
354: --
355: fnd_message.set_name('BEN','BEN_92310_FORMULA_RET_PARAM');
356: fnd_message.set_token('PROC',l_package);
357: fnd_message.set_token('FORMULA',p_formula_id);
358: fnd_message.set_token('PARAMETER',l_outputs(l_count).name);
359: fnd_message.raise_error;
360: --
361: end if;

Line 358: fnd_message.set_token('PARAMETER',l_outputs(l_count).name);

354: --
355: fnd_message.set_name('BEN','BEN_92310_FORMULA_RET_PARAM');
356: fnd_message.set_token('PROC',l_package);
357: fnd_message.set_token('FORMULA',p_formula_id);
358: fnd_message.set_token('PARAMETER',l_outputs(l_count).name);
359: fnd_message.raise_error;
360: --
361: end if;
362: --

Line 359: fnd_message.raise_error;

355: fnd_message.set_name('BEN','BEN_92310_FORMULA_RET_PARAM');
356: fnd_message.set_token('PROC',l_package);
357: fnd_message.set_token('FORMULA',p_formula_id);
358: fnd_message.set_token('PARAMETER',l_outputs(l_count).name);
359: fnd_message.raise_error;
360: --
361: end if;
362: --
363: exception when others then

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

363: exception when others then
364: --
365: hr_utility.set_location('BEN_92311_FORMULA_VAL_PARAM ',10);
366: --
367: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
368: fnd_message.set_token('PROC',l_package);
369: fnd_message.set_token('FORMULA',p_formula_id);
370: fnd_message.set_token('PARAMETER',l_outputs(l_count).name);
371: fnd_message.raise_error;

Line 368: fnd_message.set_token('PROC',l_package);

364: --
365: hr_utility.set_location('BEN_92311_FORMULA_VAL_PARAM ',10);
366: --
367: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
368: fnd_message.set_token('PROC',l_package);
369: fnd_message.set_token('FORMULA',p_formula_id);
370: fnd_message.set_token('PARAMETER',l_outputs(l_count).name);
371: fnd_message.raise_error;
372: --

Line 369: fnd_message.set_token('FORMULA',p_formula_id);

365: hr_utility.set_location('BEN_92311_FORMULA_VAL_PARAM ',10);
366: --
367: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
368: fnd_message.set_token('PROC',l_package);
369: fnd_message.set_token('FORMULA',p_formula_id);
370: fnd_message.set_token('PARAMETER',l_outputs(l_count).name);
371: fnd_message.raise_error;
372: --
373: end;

Line 370: fnd_message.set_token('PARAMETER',l_outputs(l_count).name);

366: --
367: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
368: fnd_message.set_token('PROC',l_package);
369: fnd_message.set_token('FORMULA',p_formula_id);
370: fnd_message.set_token('PARAMETER',l_outputs(l_count).name);
371: fnd_message.raise_error;
372: --
373: end;
374: end loop ;

Line 371: fnd_message.raise_error;

367: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
368: fnd_message.set_token('PROC',l_package);
369: fnd_message.set_token('FORMULA',p_formula_id);
370: fnd_message.set_token('PARAMETER',l_outputs(l_count).name);
371: fnd_message.raise_error;
372: --
373: end;
374: end loop ;
375: ELSE

Line 550: fnd_message.set_name('BEN','BEN_91824_START_DT_AFTR_END_DT');

546: -- Start Date should be less than end date.
547: --
548: if p_end_date < p_start_date then
549: --
550: fnd_message.set_name('BEN','BEN_91824_START_DT_AFTR_END_DT');
551: fnd_message.set_token('PROC',l_package);
552: fnd_message.set_token('START_DT',to_char(p_start_date));
553: fnd_message.set_token('END_DT',to_char(p_end_date));
554: fnd_message.raise_error;

Line 551: fnd_message.set_token('PROC',l_package);

547: --
548: if p_end_date < p_start_date then
549: --
550: fnd_message.set_name('BEN','BEN_91824_START_DT_AFTR_END_DT');
551: fnd_message.set_token('PROC',l_package);
552: fnd_message.set_token('START_DT',to_char(p_start_date));
553: fnd_message.set_token('END_DT',to_char(p_end_date));
554: fnd_message.raise_error;
555: --

Line 552: fnd_message.set_token('START_DT',to_char(p_start_date));

548: if p_end_date < p_start_date then
549: --
550: fnd_message.set_name('BEN','BEN_91824_START_DT_AFTR_END_DT');
551: fnd_message.set_token('PROC',l_package);
552: fnd_message.set_token('START_DT',to_char(p_start_date));
553: fnd_message.set_token('END_DT',to_char(p_end_date));
554: fnd_message.raise_error;
555: --
556: else

Line 553: fnd_message.set_token('END_DT',to_char(p_end_date));

549: --
550: fnd_message.set_name('BEN','BEN_91824_START_DT_AFTR_END_DT');
551: fnd_message.set_token('PROC',l_package);
552: fnd_message.set_token('START_DT',to_char(p_start_date));
553: fnd_message.set_token('END_DT',to_char(p_end_date));
554: fnd_message.raise_error;
555: --
556: else
557: --

Line 554: fnd_message.raise_error;

550: fnd_message.set_name('BEN','BEN_91824_START_DT_AFTR_END_DT');
551: fnd_message.set_token('PROC',l_package);
552: fnd_message.set_token('START_DT',to_char(p_start_date));
553: fnd_message.set_token('END_DT',to_char(p_end_date));
554: fnd_message.raise_error;
555: --
556: else
557: --
558: -- need to add 1 day to correctly calc time between 2 dates.

Line 607: fnd_message.set_name('BEN','BEN_92403_PAYROLL_ID_REQ');

603: --
604: l_periods := 0;
605: --
606: if p_payroll_id is null then
607: fnd_message.set_name('BEN','BEN_92403_PAYROLL_ID_REQ');
608: fnd_message.set_token('PROC',l_package);
609: fnd_message.raise_error;
610: end if;
611: -- Check if period_type of the payroll is

Line 608: fnd_message.set_token('PROC',l_package);

604: l_periods := 0;
605: --
606: if p_payroll_id is null then
607: fnd_message.set_name('BEN','BEN_92403_PAYROLL_ID_REQ');
608: fnd_message.set_token('PROC',l_package);
609: fnd_message.raise_error;
610: end if;
611: -- Check if period_type of the payroll is
612: -- either Calendar or Lunar month

Line 609: fnd_message.raise_error;

605: --
606: if p_payroll_id is null then
607: fnd_message.set_name('BEN','BEN_92403_PAYROLL_ID_REQ');
608: fnd_message.set_token('PROC',l_package);
609: fnd_message.raise_error;
610: end if;
611: -- Check if period_type of the payroll is
612: -- either Calendar or Lunar month
613: -- Standard skip rules aren't applied to these

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

846: if g_debug then
847: hr_utility.set_location('l_tot_perd = 0 and l_periods = 0 ' ,234);
848: end if;
849: --
850: fnd_message.set_name('BEN', 'BEN_92346_PAYROLL_NOT_DEFINED');
851: fnd_message.set_token('PROC',l_package);
852: fnd_message.raise_error;
853: end if;
854: --

Line 851: fnd_message.set_token('PROC',l_package);

847: hr_utility.set_location('l_tot_perd = 0 and l_periods = 0 ' ,234);
848: end if;
849: --
850: fnd_message.set_name('BEN', 'BEN_92346_PAYROLL_NOT_DEFINED');
851: fnd_message.set_token('PROC',l_package);
852: fnd_message.raise_error;
853: end if;
854: --
855: if p_acty_ref_perd_cd = 'EPP' then

Line 852: fnd_message.raise_error;

848: end if;
849: --
850: fnd_message.set_name('BEN', 'BEN_92346_PAYROLL_NOT_DEFINED');
851: fnd_message.set_token('PROC',l_package);
852: fnd_message.raise_error;
853: end if;
854: --
855: if p_acty_ref_perd_cd = 'EPP' then
856: --

Line 889: fnd_message.set_name('BEN','BEN_92403_PAYROLL_ID_REQ');

885: --
886: l_periods := 0;
887: --
888: if p_payroll_id is null then
889: fnd_message.set_name('BEN','BEN_92403_PAYROLL_ID_REQ');
890: fnd_message.set_token('PROC',l_package);
891: fnd_message.raise_error;
892: end if;
893: --

Line 890: fnd_message.set_token('PROC',l_package);

886: l_periods := 0;
887: --
888: if p_payroll_id is null then
889: fnd_message.set_name('BEN','BEN_92403_PAYROLL_ID_REQ');
890: fnd_message.set_token('PROC',l_package);
891: fnd_message.raise_error;
892: end if;
893: --
894: -- Check whether any element rule available for the element type.

Line 891: fnd_message.raise_error;

887: --
888: if p_payroll_id is null then
889: fnd_message.set_name('BEN','BEN_92403_PAYROLL_ID_REQ');
890: fnd_message.set_token('PROC',l_package);
891: fnd_message.raise_error;
892: end if;
893: --
894: -- Check whether any element rule available for the element type.
895: -- If not, do not call the payroll check routine.

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

954: if l_periods = 0 then
955: --
956: -- Raise error as payroll was not found.
957: --
958: fnd_message.set_name('BEN', 'BEN_92346_PAYROLL_NOT_DEFINED');
959: fnd_message.set_token('PROC',l_package);
960: fnd_message.raise_error;
961: end if;
962:

Line 959: fnd_message.set_token('PROC',l_package);

955: --
956: -- Raise error as payroll was not found.
957: --
958: fnd_message.set_name('BEN', 'BEN_92346_PAYROLL_NOT_DEFINED');
959: fnd_message.set_token('PROC',l_package);
960: fnd_message.raise_error;
961: end if;
962:
963:

Line 960: fnd_message.raise_error;

956: -- Raise error as payroll was not found.
957: --
958: fnd_message.set_name('BEN', 'BEN_92346_PAYROLL_NOT_DEFINED');
959: fnd_message.set_token('PROC',l_package);
960: fnd_message.raise_error;
961: end if;
962:
963:
964: elsif p_acty_ref_perd_cd = 'BWK' then

Line 1023: fnd_message.set_name('BEN','BEN_91299_INV_ACTY_REF_PERD_CD');

1019: else
1020: --
1021: -- Invalid Activity reference period code.
1022: --
1023: fnd_message.set_name('BEN','BEN_91299_INV_ACTY_REF_PERD_CD');
1024: fnd_message.set_token('PROC',l_package);
1025: fnd_message.set_token('ACTY_REF_PERD_CD',p_acty_ref_perd_cd);
1026: fnd_message.raise_error;
1027: --

Line 1024: fnd_message.set_token('PROC',l_package);

1020: --
1021: -- Invalid Activity reference period code.
1022: --
1023: fnd_message.set_name('BEN','BEN_91299_INV_ACTY_REF_PERD_CD');
1024: fnd_message.set_token('PROC',l_package);
1025: fnd_message.set_token('ACTY_REF_PERD_CD',p_acty_ref_perd_cd);
1026: fnd_message.raise_error;
1027: --
1028: end if;

Line 1025: fnd_message.set_token('ACTY_REF_PERD_CD',p_acty_ref_perd_cd);

1021: -- Invalid Activity reference period code.
1022: --
1023: fnd_message.set_name('BEN','BEN_91299_INV_ACTY_REF_PERD_CD');
1024: fnd_message.set_token('PROC',l_package);
1025: fnd_message.set_token('ACTY_REF_PERD_CD',p_acty_ref_perd_cd);
1026: fnd_message.raise_error;
1027: --
1028: end if;
1029:

Line 1026: fnd_message.raise_error;

1022: --
1023: fnd_message.set_name('BEN','BEN_91299_INV_ACTY_REF_PERD_CD');
1024: fnd_message.set_token('PROC',l_package);
1025: fnd_message.set_token('ACTY_REF_PERD_CD',p_acty_ref_perd_cd);
1026: fnd_message.raise_error;
1027: --
1028: end if;
1029:
1030: if g_debug then

Line 1040: fnd_message.raise_error;

1036:
1037: exception
1038: --
1039: when others then
1040: fnd_message.raise_error;
1041: --
1042: end get_periods_between;
1043: --
1044: --overloaded the function to calculate periods based on cheque dateS

Line 1239: fnd_message.set_name('BEN','BEN_91824_START_DT_AFTR_END_DT');

1235: -- Start Date should be less than end date.
1236: --
1237: if p_end_date < p_start_date then
1238: --
1239: fnd_message.set_name('BEN','BEN_91824_START_DT_AFTR_END_DT');
1240: fnd_message.set_token('PROC',l_package);
1241: fnd_message.set_token('START_DT',to_char(p_start_date));
1242: fnd_message.set_token('END_DT',to_char(p_end_date));
1243: fnd_message.raise_error;

Line 1240: fnd_message.set_token('PROC',l_package);

1236: --
1237: if p_end_date < p_start_date then
1238: --
1239: fnd_message.set_name('BEN','BEN_91824_START_DT_AFTR_END_DT');
1240: fnd_message.set_token('PROC',l_package);
1241: fnd_message.set_token('START_DT',to_char(p_start_date));
1242: fnd_message.set_token('END_DT',to_char(p_end_date));
1243: fnd_message.raise_error;
1244: --

Line 1241: fnd_message.set_token('START_DT',to_char(p_start_date));

1237: if p_end_date < p_start_date then
1238: --
1239: fnd_message.set_name('BEN','BEN_91824_START_DT_AFTR_END_DT');
1240: fnd_message.set_token('PROC',l_package);
1241: fnd_message.set_token('START_DT',to_char(p_start_date));
1242: fnd_message.set_token('END_DT',to_char(p_end_date));
1243: fnd_message.raise_error;
1244: --
1245: else

Line 1242: fnd_message.set_token('END_DT',to_char(p_end_date));

1238: --
1239: fnd_message.set_name('BEN','BEN_91824_START_DT_AFTR_END_DT');
1240: fnd_message.set_token('PROC',l_package);
1241: fnd_message.set_token('START_DT',to_char(p_start_date));
1242: fnd_message.set_token('END_DT',to_char(p_end_date));
1243: fnd_message.raise_error;
1244: --
1245: else
1246: --

Line 1243: fnd_message.raise_error;

1239: fnd_message.set_name('BEN','BEN_91824_START_DT_AFTR_END_DT');
1240: fnd_message.set_token('PROC',l_package);
1241: fnd_message.set_token('START_DT',to_char(p_start_date));
1242: fnd_message.set_token('END_DT',to_char(p_end_date));
1243: fnd_message.raise_error;
1244: --
1245: else
1246: --
1247: -- need to add 1 day to correctly calc time between 2 dates.

Line 1295: fnd_message.set_name('BEN','BEN_92403_PAYROLL_ID_REQ');

1291: --
1292: l_periods := 0;
1293: --
1294: if p_payroll_id is null then
1295: fnd_message.set_name('BEN','BEN_92403_PAYROLL_ID_REQ');
1296: fnd_message.set_token('PROC',l_package);
1297: fnd_message.raise_error;
1298: end if;
1299: -- Check if period_type of the payroll is

Line 1296: fnd_message.set_token('PROC',l_package);

1292: l_periods := 0;
1293: --
1294: if p_payroll_id is null then
1295: fnd_message.set_name('BEN','BEN_92403_PAYROLL_ID_REQ');
1296: fnd_message.set_token('PROC',l_package);
1297: fnd_message.raise_error;
1298: end if;
1299: -- Check if period_type of the payroll is
1300: -- either Calendar or Lunar month

Line 1297: fnd_message.raise_error;

1293: --
1294: if p_payroll_id is null then
1295: fnd_message.set_name('BEN','BEN_92403_PAYROLL_ID_REQ');
1296: fnd_message.set_token('PROC',l_package);
1297: fnd_message.raise_error;
1298: end if;
1299: -- Check if period_type of the payroll is
1300: -- either Calendar or Lunar month
1301: -- Standard skip rules aren't applied to these

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

1520: if g_debug then
1521: hr_utility.set_location('l_tot_perd = 0 and l_periods = 0 ' ,234);
1522: end if;
1523: --
1524: fnd_message.set_name('BEN', 'BEN_92346_PAYROLL_NOT_DEFINED');
1525: fnd_message.set_token('PROC',l_package);
1526: fnd_message.raise_error;
1527: end if;
1528: --

Line 1525: fnd_message.set_token('PROC',l_package);

1521: hr_utility.set_location('l_tot_perd = 0 and l_periods = 0 ' ,234);
1522: end if;
1523: --
1524: fnd_message.set_name('BEN', 'BEN_92346_PAYROLL_NOT_DEFINED');
1525: fnd_message.set_token('PROC',l_package);
1526: fnd_message.raise_error;
1527: end if;
1528: --
1529: if p_acty_ref_perd_cd = 'EPP' then

Line 1526: fnd_message.raise_error;

1522: end if;
1523: --
1524: fnd_message.set_name('BEN', 'BEN_92346_PAYROLL_NOT_DEFINED');
1525: fnd_message.set_token('PROC',l_package);
1526: fnd_message.raise_error;
1527: end if;
1528: --
1529: if p_acty_ref_perd_cd = 'EPP' then
1530: --

Line 1648: fnd_message.set_name('BEN','BEN_91299_INV_ACTY_REF_PERD_CD');

1644: else
1645: --
1646: -- Invalid Activity reference period code.
1647: --
1648: fnd_message.set_name('BEN','BEN_91299_INV_ACTY_REF_PERD_CD');
1649: fnd_message.set_token('PROC',l_package);
1650: fnd_message.set_token('ACTY_REF_PERD_CD',p_acty_ref_perd_cd);
1651: fnd_message.raise_error;
1652: --

Line 1649: fnd_message.set_token('PROC',l_package);

1645: --
1646: -- Invalid Activity reference period code.
1647: --
1648: fnd_message.set_name('BEN','BEN_91299_INV_ACTY_REF_PERD_CD');
1649: fnd_message.set_token('PROC',l_package);
1650: fnd_message.set_token('ACTY_REF_PERD_CD',p_acty_ref_perd_cd);
1651: fnd_message.raise_error;
1652: --
1653: end if;

Line 1650: fnd_message.set_token('ACTY_REF_PERD_CD',p_acty_ref_perd_cd);

1646: -- Invalid Activity reference period code.
1647: --
1648: fnd_message.set_name('BEN','BEN_91299_INV_ACTY_REF_PERD_CD');
1649: fnd_message.set_token('PROC',l_package);
1650: fnd_message.set_token('ACTY_REF_PERD_CD',p_acty_ref_perd_cd);
1651: fnd_message.raise_error;
1652: --
1653: end if;
1654:

Line 1651: fnd_message.raise_error;

1647: --
1648: fnd_message.set_name('BEN','BEN_91299_INV_ACTY_REF_PERD_CD');
1649: fnd_message.set_token('PROC',l_package);
1650: fnd_message.set_token('ACTY_REF_PERD_CD',p_acty_ref_perd_cd);
1651: fnd_message.raise_error;
1652: --
1653: end if;
1654:
1655: if g_debug then

Line 1665: fnd_message.raise_error;

1661:
1662: exception
1663: --
1664: when others then
1665: fnd_message.raise_error;
1666: --
1667: end get_periods_between;
1668: --
1669: ---------------------------------------------------------------------------

Line 2159: fnd_message.raise_error;

2155: --
2156: exception
2157: --
2158: when others then
2159: fnd_message.raise_error;
2160: --
2161: end get_balance;
2162: ---------------------------------------------------------------------------
2163: -- This procedure set the start date, end date, activity reference

Line 2400: fnd_message.set_name('BEN','BEN_91825_ENRT_RT_NOT_FOUND');

2396: --
2397: if c_ecr%notfound then
2398: --
2399: close c_ecr;
2400: fnd_message.set_name('BEN','BEN_91825_ENRT_RT_NOT_FOUND');
2401: fnd_message.set_token('PROC',l_package);
2402: fnd_message.set_token('ENRT_RT_ID',to_char(p_enrt_rt_id));
2403: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
2404: fnd_message.raise_error;

Line 2401: fnd_message.set_token('PROC',l_package);

2397: if c_ecr%notfound then
2398: --
2399: close c_ecr;
2400: fnd_message.set_name('BEN','BEN_91825_ENRT_RT_NOT_FOUND');
2401: fnd_message.set_token('PROC',l_package);
2402: fnd_message.set_token('ENRT_RT_ID',to_char(p_enrt_rt_id));
2403: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
2404: fnd_message.raise_error;
2405: --

Line 2402: fnd_message.set_token('ENRT_RT_ID',to_char(p_enrt_rt_id));

2398: --
2399: close c_ecr;
2400: fnd_message.set_name('BEN','BEN_91825_ENRT_RT_NOT_FOUND');
2401: fnd_message.set_token('PROC',l_package);
2402: fnd_message.set_token('ENRT_RT_ID',to_char(p_enrt_rt_id));
2403: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
2404: fnd_message.raise_error;
2405: --
2406: else

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

2399: close c_ecr;
2400: fnd_message.set_name('BEN','BEN_91825_ENRT_RT_NOT_FOUND');
2401: fnd_message.set_token('PROC',l_package);
2402: fnd_message.set_token('ENRT_RT_ID',to_char(p_enrt_rt_id));
2403: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
2404: fnd_message.raise_error;
2405: --
2406: else
2407: --

Line 2404: fnd_message.raise_error;

2400: fnd_message.set_name('BEN','BEN_91825_ENRT_RT_NOT_FOUND');
2401: fnd_message.set_token('PROC',l_package);
2402: fnd_message.set_token('ENRT_RT_ID',to_char(p_enrt_rt_id));
2403: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
2404: fnd_message.raise_error;
2405: --
2406: else
2407: --
2408: close c_ecr;

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

2460: --
2461: close c_epe;
2462: -- hr_utility.set_location('BEN_91457_ELCTBL_CHC_NOT_FOUND ID:'||
2463: -- to_char(p_elig_per_elctbl_chc_id), 50);
2464: fnd_message.set_name('BEN','BEN_91457_ELCTBL_CHC_NOT_FOUND');
2465: fnd_message.set_token('ID',to_char(p_elig_per_elctbl_chc_id));
2466: fnd_message.set_token('PROC',l_package);
2467: fnd_message.raise_error;
2468: --

Line 2465: fnd_message.set_token('ID',to_char(p_elig_per_elctbl_chc_id));

2461: close c_epe;
2462: -- hr_utility.set_location('BEN_91457_ELCTBL_CHC_NOT_FOUND ID:'||
2463: -- to_char(p_elig_per_elctbl_chc_id), 50);
2464: fnd_message.set_name('BEN','BEN_91457_ELCTBL_CHC_NOT_FOUND');
2465: fnd_message.set_token('ID',to_char(p_elig_per_elctbl_chc_id));
2466: fnd_message.set_token('PROC',l_package);
2467: fnd_message.raise_error;
2468: --
2469: else

Line 2466: fnd_message.set_token('PROC',l_package);

2462: -- hr_utility.set_location('BEN_91457_ELCTBL_CHC_NOT_FOUND ID:'||
2463: -- to_char(p_elig_per_elctbl_chc_id), 50);
2464: fnd_message.set_name('BEN','BEN_91457_ELCTBL_CHC_NOT_FOUND');
2465: fnd_message.set_token('ID',to_char(p_elig_per_elctbl_chc_id));
2466: fnd_message.set_token('PROC',l_package);
2467: fnd_message.raise_error;
2468: --
2469: else
2470: --

Line 2467: fnd_message.raise_error;

2463: -- to_char(p_elig_per_elctbl_chc_id), 50);
2464: fnd_message.set_name('BEN','BEN_91457_ELCTBL_CHC_NOT_FOUND');
2465: fnd_message.set_token('ID',to_char(p_elig_per_elctbl_chc_id));
2466: fnd_message.set_token('PROC',l_package);
2467: fnd_message.raise_error;
2468: --
2469: else
2470: --
2471: close c_epe;

Line 2495: fnd_message.set_name('BEN','BEN_91884_CHC_N_RT_NOT_FOUND');

2491: --
2492: else
2493: --
2494: -- hr_utility.set_location('BEN_91884_CHC_N_RT_NOT_FOUND:', 50);
2495: fnd_message.set_name('BEN','BEN_91884_CHC_N_RT_NOT_FOUND');
2496: fnd_message.set_token('PROC',l_package);
2497: fnd_message.raise_error;
2498: --
2499: end if;

Line 2496: fnd_message.set_token('PROC',l_package);

2492: else
2493: --
2494: -- hr_utility.set_location('BEN_91884_CHC_N_RT_NOT_FOUND:', 50);
2495: fnd_message.set_name('BEN','BEN_91884_CHC_N_RT_NOT_FOUND');
2496: fnd_message.set_token('PROC',l_package);
2497: fnd_message.raise_error;
2498: --
2499: end if;
2500: --

Line 2497: fnd_message.raise_error;

2493: --
2494: -- hr_utility.set_location('BEN_91884_CHC_N_RT_NOT_FOUND:', 50);
2495: fnd_message.set_name('BEN','BEN_91884_CHC_N_RT_NOT_FOUND');
2496: fnd_message.set_token('PROC',l_package);
2497: fnd_message.raise_error;
2498: --
2499: end if;
2500: --
2501: --end if;

Line 2570: fnd_message.set_name('BEN','BEN_91334_PLAN_YR_PERD');

2566: l_yrp.end_date := TO_DATE('12/31/'||l_year,'MM/DD/YYYY');
2567: --
2568: else
2569: --
2570: fnd_message.set_name('BEN','BEN_91334_PLAN_YR_PERD');
2571: fnd_message.set_token('PROC',l_package);
2572: fnd_message.raise_error;
2573: --
2574: end if;

Line 2571: fnd_message.set_token('PROC',l_package);

2567: --
2568: else
2569: --
2570: fnd_message.set_name('BEN','BEN_91334_PLAN_YR_PERD');
2571: fnd_message.set_token('PROC',l_package);
2572: fnd_message.raise_error;
2573: --
2574: end if;
2575: --

Line 2572: fnd_message.raise_error;

2568: else
2569: --
2570: fnd_message.set_name('BEN','BEN_91334_PLAN_YR_PERD');
2571: fnd_message.set_token('PROC',l_package);
2572: fnd_message.raise_error;
2573: --
2574: end if;
2575: --
2576: end if;

Line 2670: fnd_message.raise_error;

2666: end if;
2667: p_start_date := l_start_date_nc_buffer; -- no copy changes
2668: p_end_date := l_end_date_nc_buffer; -- no copy changes
2669: p_yr_start_date := null; -- no copy changes
2670: fnd_message.raise_error;
2671: --
2672: end set_default_dates;
2673: --
2674: ---------------------------------------------------------------------------

Line 3002: fnd_message.raise_error;

2998: --
2999: exception
3000: --
3001: when others then
3002: fnd_message.raise_error;
3003: --
3004: end period_to_annual;
3005:
3006: --

Line 3335: fnd_message.raise_error;

3331: --
3332: exception
3333: --
3334: when others then
3335: fnd_message.raise_error;
3336: --
3337: end period_to_annual;
3338:
3339: --

Line 3747: fnd_message.raise_error;

3743: --
3744: exception
3745: --
3746: when others then
3747: fnd_message.raise_error;
3748: --
3749: end annual_to_period;
3750: --
3751: ---------------------------------------------------------------------------

Line 4160: fnd_message.raise_error;

4156: --
4157: exception
4158: --
4159: when others then
4160: fnd_message.raise_error;
4161: --
4162: end annual_to_period;
4163: function annual_to_period_out(p_amount in number,
4164: p_enrt_rt_id in number default null,

Line 4440: fnd_message.raise_error;

4436: exception
4437: --
4438: when others then
4439: p_pp_in_yr_used_num := null; -- no copy changes
4440: fnd_message.raise_error;
4441: --
4442: end annual_to_period_out;
4443: ---------------------------------------------------------------------------
4444: -- compare_balances

Line 4549: fnd_message.set_name('BEN','BEN_92404_NEED_MORE_VARS');

4545: close get_epe;
4546: elsif (p_pgm_id is null and p_pl_id is null and p_oipl_id is null)
4547: or p_per_in_ler_id is null or p_business_group_id is null
4548: or p_lf_evt_ocrd_dt is null then
4549: fnd_message.set_name('BEN','BEN_92404_NEED_MORE_VARS');
4550: fnd_message.set_token('PROC',l_package);
4551: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
4552: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
4553: fnd_message.set_token('PL_ID',to_char(p_pl_id));

Line 4550: fnd_message.set_token('PROC',l_package);

4546: elsif (p_pgm_id is null and p_pl_id is null and p_oipl_id is null)
4547: or p_per_in_ler_id is null or p_business_group_id is null
4548: or p_lf_evt_ocrd_dt is null then
4549: fnd_message.set_name('BEN','BEN_92404_NEED_MORE_VARS');
4550: fnd_message.set_token('PROC',l_package);
4551: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
4552: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
4553: fnd_message.set_token('PL_ID',to_char(p_pl_id));
4554: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));

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

4547: or p_per_in_ler_id is null or p_business_group_id is null
4548: or p_lf_evt_ocrd_dt is null then
4549: fnd_message.set_name('BEN','BEN_92404_NEED_MORE_VARS');
4550: fnd_message.set_token('PROC',l_package);
4551: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
4552: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
4553: fnd_message.set_token('PL_ID',to_char(p_pl_id));
4554: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
4555: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));

Line 4552: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));

4548: or p_lf_evt_ocrd_dt is null then
4549: fnd_message.set_name('BEN','BEN_92404_NEED_MORE_VARS');
4550: fnd_message.set_token('PROC',l_package);
4551: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
4552: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
4553: fnd_message.set_token('PL_ID',to_char(p_pl_id));
4554: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
4555: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
4556: fnd_message.set_token('BG_ID',to_char(p_business_group_id));

Line 4553: fnd_message.set_token('PL_ID',to_char(p_pl_id));

4549: fnd_message.set_name('BEN','BEN_92404_NEED_MORE_VARS');
4550: fnd_message.set_token('PROC',l_package);
4551: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
4552: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
4553: fnd_message.set_token('PL_ID',to_char(p_pl_id));
4554: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
4555: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
4556: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
4557: fnd_message.set_token('LF_EVT_OCRD_DT',to_char(p_lf_evt_ocrd_dt));

Line 4554: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));

4550: fnd_message.set_token('PROC',l_package);
4551: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
4552: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
4553: fnd_message.set_token('PL_ID',to_char(p_pl_id));
4554: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
4555: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
4556: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
4557: fnd_message.set_token('LF_EVT_OCRD_DT',to_char(p_lf_evt_ocrd_dt));
4558: fnd_message.raise_error;

Line 4555: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));

4551: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
4552: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
4553: fnd_message.set_token('PL_ID',to_char(p_pl_id));
4554: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
4555: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
4556: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
4557: fnd_message.set_token('LF_EVT_OCRD_DT',to_char(p_lf_evt_ocrd_dt));
4558: fnd_message.raise_error;
4559: else

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

4552: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
4553: fnd_message.set_token('PL_ID',to_char(p_pl_id));
4554: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
4555: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
4556: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
4557: fnd_message.set_token('LF_EVT_OCRD_DT',to_char(p_lf_evt_ocrd_dt));
4558: fnd_message.raise_error;
4559: else
4560: --

Line 4557: fnd_message.set_token('LF_EVT_OCRD_DT',to_char(p_lf_evt_ocrd_dt));

4553: fnd_message.set_token('PL_ID',to_char(p_pl_id));
4554: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
4555: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
4556: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
4557: fnd_message.set_token('LF_EVT_OCRD_DT',to_char(p_lf_evt_ocrd_dt));
4558: fnd_message.raise_error;
4559: else
4560: --
4561: open c_pel;

Line 4558: fnd_message.raise_error;

4554: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
4555: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
4556: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
4557: fnd_message.set_token('LF_EVT_OCRD_DT',to_char(p_lf_evt_ocrd_dt));
4558: fnd_message.raise_error;
4559: else
4560: --
4561: open c_pel;
4562: fetch c_pel into l_get_epe.enrt_perd_id,

Line 4577: fnd_message.set_name('BEN','BEN_92405_NEED_ENTERED_VAL');

4573: --
4574: end if;
4575:
4576: if p_entered_ann_val is null and p_perform_edit_flag = 'Y' then
4577: fnd_message.set_name('BEN','BEN_92405_NEED_ENTERED_VAL');
4578: fnd_message.set_token('PROC',l_package);
4579: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
4580: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
4581: fnd_message.set_token('PL_ID',to_char(p_pl_id));

Line 4578: fnd_message.set_token('PROC',l_package);

4574: end if;
4575:
4576: if p_entered_ann_val is null and p_perform_edit_flag = 'Y' then
4577: fnd_message.set_name('BEN','BEN_92405_NEED_ENTERED_VAL');
4578: fnd_message.set_token('PROC',l_package);
4579: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
4580: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
4581: fnd_message.set_token('PL_ID',to_char(p_pl_id));
4582: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));

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

4575:
4576: if p_entered_ann_val is null and p_perform_edit_flag = 'Y' then
4577: fnd_message.set_name('BEN','BEN_92405_NEED_ENTERED_VAL');
4578: fnd_message.set_token('PROC',l_package);
4579: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
4580: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
4581: fnd_message.set_token('PL_ID',to_char(p_pl_id));
4582: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
4583: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));

Line 4580: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));

4576: if p_entered_ann_val is null and p_perform_edit_flag = 'Y' then
4577: fnd_message.set_name('BEN','BEN_92405_NEED_ENTERED_VAL');
4578: fnd_message.set_token('PROC',l_package);
4579: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
4580: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
4581: fnd_message.set_token('PL_ID',to_char(p_pl_id));
4582: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
4583: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
4584: fnd_message.set_token('BG_ID',to_char(p_business_group_id));

Line 4581: fnd_message.set_token('PL_ID',to_char(p_pl_id));

4577: fnd_message.set_name('BEN','BEN_92405_NEED_ENTERED_VAL');
4578: fnd_message.set_token('PROC',l_package);
4579: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
4580: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
4581: fnd_message.set_token('PL_ID',to_char(p_pl_id));
4582: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
4583: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
4584: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
4585: fnd_message.raise_error;

Line 4582: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));

4578: fnd_message.set_token('PROC',l_package);
4579: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
4580: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
4581: fnd_message.set_token('PL_ID',to_char(p_pl_id));
4582: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
4583: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
4584: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
4585: fnd_message.raise_error;
4586: end if;

Line 4583: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));

4579: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
4580: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
4581: fnd_message.set_token('PL_ID',to_char(p_pl_id));
4582: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
4583: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
4584: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
4585: fnd_message.raise_error;
4586: end if;
4587:

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

4580: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
4581: fnd_message.set_token('PL_ID',to_char(p_pl_id));
4582: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
4583: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
4584: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
4585: fnd_message.raise_error;
4586: end if;
4587:
4588: p_ptd_balance := null;

Line 4585: fnd_message.raise_error;

4581: fnd_message.set_token('PL_ID',to_char(p_pl_id));
4582: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
4583: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
4584: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
4585: fnd_message.raise_error;
4586: end if;
4587:
4588: p_ptd_balance := null;
4589: p_clm_balance := null;

Line 4621: fnd_message.set_name('BEN','BEN_92406_BELOW_PTD');

4617: if p_ptd_balance is not null and p_entered_ann_val < p_ptd_balance and
4618: p_perform_edit_flag = 'Y' then
4619: -- The period-to-date is what the prtt has already paid into this plan.
4620: -- Do not allow their elected annual value to fall below the ptd-balance.
4621: fnd_message.set_name('BEN','BEN_92406_BELOW_PTD');
4622: fnd_message.set_token('PROC',l_package);
4623: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
4624: fnd_message.set_token('ANN_VAL',to_char(p_entered_ann_val));
4625: fnd_message.set_token('PTD_BAL',to_char(p_ptd_balance));

Line 4622: fnd_message.set_token('PROC',l_package);

4618: p_perform_edit_flag = 'Y' then
4619: -- The period-to-date is what the prtt has already paid into this plan.
4620: -- Do not allow their elected annual value to fall below the ptd-balance.
4621: fnd_message.set_name('BEN','BEN_92406_BELOW_PTD');
4622: fnd_message.set_token('PROC',l_package);
4623: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
4624: fnd_message.set_token('ANN_VAL',to_char(p_entered_ann_val));
4625: fnd_message.set_token('PTD_BAL',to_char(p_ptd_balance));
4626: fnd_message.raise_error;

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

4619: -- The period-to-date is what the prtt has already paid into this plan.
4620: -- Do not allow their elected annual value to fall below the ptd-balance.
4621: fnd_message.set_name('BEN','BEN_92406_BELOW_PTD');
4622: fnd_message.set_token('PROC',l_package);
4623: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
4624: fnd_message.set_token('ANN_VAL',to_char(p_entered_ann_val));
4625: fnd_message.set_token('PTD_BAL',to_char(p_ptd_balance));
4626: fnd_message.raise_error;
4627: end if;

Line 4624: fnd_message.set_token('ANN_VAL',to_char(p_entered_ann_val));

4620: -- Do not allow their elected annual value to fall below the ptd-balance.
4621: fnd_message.set_name('BEN','BEN_92406_BELOW_PTD');
4622: fnd_message.set_token('PROC',l_package);
4623: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
4624: fnd_message.set_token('ANN_VAL',to_char(p_entered_ann_val));
4625: fnd_message.set_token('PTD_BAL',to_char(p_ptd_balance));
4626: fnd_message.raise_error;
4627: end if;
4628: end if;

Line 4625: fnd_message.set_token('PTD_BAL',to_char(p_ptd_balance));

4621: fnd_message.set_name('BEN','BEN_92406_BELOW_PTD');
4622: fnd_message.set_token('PROC',l_package);
4623: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
4624: fnd_message.set_token('ANN_VAL',to_char(p_entered_ann_val));
4625: fnd_message.set_token('PTD_BAL',to_char(p_ptd_balance));
4626: fnd_message.raise_error;
4627: end if;
4628: end if;
4629:

Line 4626: fnd_message.raise_error;

4622: fnd_message.set_token('PROC',l_package);
4623: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
4624: fnd_message.set_token('ANN_VAL',to_char(p_entered_ann_val));
4625: fnd_message.set_token('PTD_BAL',to_char(p_ptd_balance));
4626: fnd_message.raise_error;
4627: end if;
4628: end if;
4629:
4630: if l_abr_balance.clm_comp_lvl_fctr_id is not null then

Line 4649: fnd_message.set_name('BEN','BEN_92407_BELOW_CLM');

4645: if p_clm_balance is not null and p_entered_ann_val < p_clm_balance and
4646: p_perform_edit_flag = 'Y' then
4647: --The claims-to-date is what the prtt has already claimed against the FSA
4648: --Do not allow their elected annual value to fall below the clm-balance.
4649: fnd_message.set_name('BEN','BEN_92407_BELOW_CLM');
4650: fnd_message.set_token('PROC',l_package);
4651: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
4652: fnd_message.set_token('ANN_VAL',to_char(p_entered_ann_val));
4653: fnd_message.set_token('CLM_BAL',to_char(p_clm_balance));

Line 4650: fnd_message.set_token('PROC',l_package);

4646: p_perform_edit_flag = 'Y' then
4647: --The claims-to-date is what the prtt has already claimed against the FSA
4648: --Do not allow their elected annual value to fall below the clm-balance.
4649: fnd_message.set_name('BEN','BEN_92407_BELOW_CLM');
4650: fnd_message.set_token('PROC',l_package);
4651: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
4652: fnd_message.set_token('ANN_VAL',to_char(p_entered_ann_val));
4653: fnd_message.set_token('CLM_BAL',to_char(p_clm_balance));
4654: fnd_message.raise_error;

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

4647: --The claims-to-date is what the prtt has already claimed against the FSA
4648: --Do not allow their elected annual value to fall below the clm-balance.
4649: fnd_message.set_name('BEN','BEN_92407_BELOW_CLM');
4650: fnd_message.set_token('PROC',l_package);
4651: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
4652: fnd_message.set_token('ANN_VAL',to_char(p_entered_ann_val));
4653: fnd_message.set_token('CLM_BAL',to_char(p_clm_balance));
4654: fnd_message.raise_error;
4655: end if;

Line 4652: fnd_message.set_token('ANN_VAL',to_char(p_entered_ann_val));

4648: --Do not allow their elected annual value to fall below the clm-balance.
4649: fnd_message.set_name('BEN','BEN_92407_BELOW_CLM');
4650: fnd_message.set_token('PROC',l_package);
4651: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
4652: fnd_message.set_token('ANN_VAL',to_char(p_entered_ann_val));
4653: fnd_message.set_token('CLM_BAL',to_char(p_clm_balance));
4654: fnd_message.raise_error;
4655: end if;
4656: end if;

Line 4653: fnd_message.set_token('CLM_BAL',to_char(p_clm_balance));

4649: fnd_message.set_name('BEN','BEN_92407_BELOW_CLM');
4650: fnd_message.set_token('PROC',l_package);
4651: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
4652: fnd_message.set_token('ANN_VAL',to_char(p_entered_ann_val));
4653: fnd_message.set_token('CLM_BAL',to_char(p_clm_balance));
4654: fnd_message.raise_error;
4655: end if;
4656: end if;
4657:

Line 4654: fnd_message.raise_error;

4650: fnd_message.set_token('PROC',l_package);
4651: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
4652: fnd_message.set_token('ANN_VAL',to_char(p_entered_ann_val));
4653: fnd_message.set_token('CLM_BAL',to_char(p_clm_balance));
4654: fnd_message.raise_error;
4655: end if;
4656: end if;
4657:
4658: if g_debug then

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

4810: open get_epe_pl_yr;
4811: fetch get_epe_pl_yr into l_get_epe_pl_yr;
4812: if get_epe_pl_yr%NOTFOUND or get_epe_pl_yr%NOTFOUND is null then
4813: close get_epe_pl_yr;
4814: fnd_message.set_name('BEN','BEN_92408_EPE_PL_YR_NOTF');
4815: fnd_message.set_token('PROC',l_package);
4816: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
4817: fnd_message.set_token('CHC',to_char(p_elig_per_elctbl_chc_id));
4818: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));

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

4811: fetch get_epe_pl_yr into l_get_epe_pl_yr;
4812: if get_epe_pl_yr%NOTFOUND or get_epe_pl_yr%NOTFOUND is null then
4813: close get_epe_pl_yr;
4814: fnd_message.set_name('BEN','BEN_92408_EPE_PL_YR_NOTF');
4815: fnd_message.set_token('PROC',l_package);
4816: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
4817: fnd_message.set_token('CHC',to_char(p_elig_per_elctbl_chc_id));
4818: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
4819: fnd_message.raise_error;

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

4812: if get_epe_pl_yr%NOTFOUND or get_epe_pl_yr%NOTFOUND is null then
4813: close get_epe_pl_yr;
4814: fnd_message.set_name('BEN','BEN_92408_EPE_PL_YR_NOTF');
4815: fnd_message.set_token('PROC',l_package);
4816: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
4817: fnd_message.set_token('CHC',to_char(p_elig_per_elctbl_chc_id));
4818: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
4819: fnd_message.raise_error;
4820: end if;

Line 4817: fnd_message.set_token('CHC',to_char(p_elig_per_elctbl_chc_id));

4813: close get_epe_pl_yr;
4814: fnd_message.set_name('BEN','BEN_92408_EPE_PL_YR_NOTF');
4815: fnd_message.set_token('PROC',l_package);
4816: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
4817: fnd_message.set_token('CHC',to_char(p_elig_per_elctbl_chc_id));
4818: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
4819: fnd_message.raise_error;
4820: end if;
4821: close get_epe_pl_yr;

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

4814: fnd_message.set_name('BEN','BEN_92408_EPE_PL_YR_NOTF');
4815: fnd_message.set_token('PROC',l_package);
4816: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
4817: fnd_message.set_token('CHC',to_char(p_elig_per_elctbl_chc_id));
4818: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
4819: fnd_message.raise_error;
4820: end if;
4821: close get_epe_pl_yr;
4822: --

Line 4819: fnd_message.raise_error;

4815: fnd_message.set_token('PROC',l_package);
4816: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
4817: fnd_message.set_token('CHC',to_char(p_elig_per_elctbl_chc_id));
4818: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
4819: fnd_message.raise_error;
4820: end if;
4821: close get_epe_pl_yr;
4822: --
4823: -- Bug No 4290565

Line 4894: fnd_message.set_name('BEN','BEN_92409_ASG_NOT_FOUND');

4890: open get_asg_info;
4891: fetch get_asg_info into l_get_asg_info;
4892: if get_asg_info%NOTFOUND or get_asg_info%NOTFOUND is null then
4893: close get_asg_info;
4894: fnd_message.set_name('BEN','BEN_92409_ASG_NOT_FOUND');
4895: fnd_message.set_token('PROC',l_package);
4896: fnd_message.set_token('PERSON',to_char(p_person_id));
4897: fnd_message.raise_error;
4898: end if;

Line 4895: fnd_message.set_token('PROC',l_package);

4891: fetch get_asg_info into l_get_asg_info;
4892: if get_asg_info%NOTFOUND or get_asg_info%NOTFOUND is null then
4893: close get_asg_info;
4894: fnd_message.set_name('BEN','BEN_92409_ASG_NOT_FOUND');
4895: fnd_message.set_token('PROC',l_package);
4896: fnd_message.set_token('PERSON',to_char(p_person_id));
4897: fnd_message.raise_error;
4898: end if;
4899: close get_asg_info;

Line 4896: fnd_message.set_token('PERSON',to_char(p_person_id));

4892: if get_asg_info%NOTFOUND or get_asg_info%NOTFOUND is null then
4893: close get_asg_info;
4894: fnd_message.set_name('BEN','BEN_92409_ASG_NOT_FOUND');
4895: fnd_message.set_token('PROC',l_package);
4896: fnd_message.set_token('PERSON',to_char(p_person_id));
4897: fnd_message.raise_error;
4898: end if;
4899: close get_asg_info;
4900: end if;

Line 4897: fnd_message.raise_error;

4893: close get_asg_info;
4894: fnd_message.set_name('BEN','BEN_92409_ASG_NOT_FOUND');
4895: fnd_message.set_token('PROC',l_package);
4896: fnd_message.set_token('PERSON',to_char(p_person_id));
4897: fnd_message.raise_error;
4898: end if;
4899: close get_asg_info;
4900: end if;
4901: