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_LSF_BUS dependencies on HR_API

Line 51: and nvl(p_los_fctr_id,hr_api.g_number)

47: (p_los_fctr_id => p_los_fctr_id,
48: p_object_version_number => p_object_version_number);
49: --
50: if (l_api_updating
51: and nvl(p_los_fctr_id,hr_api.g_number)
52: <> ben_lsf_shd.g_old_rec.los_fctr_id) then
53: --
54: -- raise error as PK has changed
55: --

Line 128: and nvl(p_oab_fast_formula_id,hr_api.g_number)

124: (p_los_fctr_id => p_los_fctr_id,
125: p_object_version_number => p_object_version_number);
126: --
127: if (l_api_updating
128: and nvl(p_oab_fast_formula_id,hr_api.g_number)
129: <> nvl(ben_lsf_shd.g_old_rec.oab_fast_formula_id,hr_api.g_number)
130: or not l_api_updating) then
131: --
132: -- check if oab_fast_formula_id value exists in ben_oab_fast_formula_f table

Line 129: <> nvl(ben_lsf_shd.g_old_rec.oab_fast_formula_id,hr_api.g_number)

125: p_object_version_number => p_object_version_number);
126: --
127: if (l_api_updating
128: and nvl(p_oab_fast_formula_id,hr_api.g_number)
129: <> nvl(ben_lsf_shd.g_old_rec.oab_fast_formula_id,hr_api.g_number)
130: or not l_api_updating) then
131: --
132: -- check if oab_fast_formula_id value exists in ben_oab_fast_formula_f table
133: --

Line 201: <> nvl(ben_lsf_shd.g_old_rec.los_uom,hr_api.g_varchar2)

197: p_object_version_number => p_object_version_number);
198: --
199: if (l_api_updating
200: and p_los_uom
201: <> nvl(ben_lsf_shd.g_old_rec.los_uom,hr_api.g_varchar2)
202: or not l_api_updating)
203: and p_los_uom is not null then
204: --
205: -- check if value of lookup falls within lookup type.

Line 207: if hr_api.not_exists_in_hr_lookups

203: and p_los_uom is not null then
204: --
205: -- check if value of lookup falls within lookup type.
206: --
207: if hr_api.not_exists_in_hr_lookups
208: (p_lookup_type => 'BEN_TM_UOM',
209: p_lookup_code => p_los_uom,
210: p_effective_date => p_effective_date) then
211: --

Line 287: and nvl(p_los_calc_rl,hr_api.g_number)

283: --p_effective_date => p_effective_date,
284: p_object_version_number => p_object_version_number);
285: --
286: if (l_api_updating
287: and nvl(p_los_calc_rl,hr_api.g_number)
288: <>BEN_LSF_SHD.g_old_rec.los_calc_rl
289: or not l_api_updating)
290: and p_los_calc_rl is not null then
291: --

Line 366: <> nvl(ben_lsf_shd.g_old_rec.los_alt_val_to_use_cd,hr_api.g_varchar2)

362: p_object_version_number => p_object_version_number);
363: --
364: if (l_api_updating
365: and p_los_alt_val_to_use_cd
366: <> nvl(ben_lsf_shd.g_old_rec.los_alt_val_to_use_cd,hr_api.g_varchar2)
367: or not l_api_updating)
368: and p_los_alt_val_to_use_cd is not null then
369: --
370: -- check if value of lookup falls within lookup type.

Line 372: if hr_api.not_exists_in_hr_lookups

368: and p_los_alt_val_to_use_cd is not null then
369: --
370: -- check if value of lookup falls within lookup type.
371: --
372: if hr_api.not_exists_in_hr_lookups
373: (p_lookup_type => 'BEN_LOS_ALT_VAL_TO_USE',
374: p_lookup_code => p_los_alt_val_to_use_cd,
375: p_effective_date => p_effective_date) then
376: --

Line 436: <> nvl(ben_lsf_shd.g_old_rec.los_dt_to_use_cd,hr_api.g_varchar2)

432: p_object_version_number => p_object_version_number);
433: --
434: if (l_api_updating
435: and p_los_dt_to_use_cd
436: <> nvl(ben_lsf_shd.g_old_rec.los_dt_to_use_cd,hr_api.g_varchar2)
437: or not l_api_updating)
438: and p_los_dt_to_use_cd is not null then
439: --
440: -- check if value of lookup falls within lookup type.

Line 442: if hr_api.not_exists_in_hr_lookups

438: and p_los_dt_to_use_cd is not null then
439: --
440: -- check if value of lookup falls within lookup type.
441: --
442: if hr_api.not_exists_in_hr_lookups
443: (p_lookup_type => 'BEN_LOS_DT_TO_USE',
444: p_lookup_code => p_los_dt_to_use_cd,
445: p_effective_date => p_effective_date) then
446: --

Line 504: <> nvl(ben_lsf_shd.g_old_rec.rndg_cd,hr_api.g_varchar2)

500: p_object_version_number => p_object_version_number);
501: --
502: if (l_api_updating
503: and p_rndg_cd
504: <> nvl(ben_lsf_shd.g_old_rec.rndg_cd,hr_api.g_varchar2)
505: or not l_api_updating)
506: and p_rndg_cd is not null then
507: --
508: -- check if value of lookup falls within lookup type.

Line 510: if hr_api.not_exists_in_hr_lookups

506: and p_rndg_cd is not null then
507: --
508: -- check if value of lookup falls within lookup type.
509: --
510: if hr_api.not_exists_in_hr_lookups
511: (p_lookup_type => 'BEN_RNDG',
512: p_lookup_code => p_rndg_cd,
513: p_effective_date => p_effective_date) then
514: --

Line 572: <> nvl(ben_lsf_shd.g_old_rec.los_det_cd,hr_api.g_varchar2)

568: p_object_version_number => p_object_version_number);
569: --
570: if (l_api_updating
571: and p_los_det_cd
572: <> nvl(ben_lsf_shd.g_old_rec.los_det_cd,hr_api.g_varchar2)
573: or not l_api_updating)
574: and p_los_det_cd is not null then
575: --
576: -- check if value of lookup falls within lookup type.

Line 578: if hr_api.not_exists_in_hr_lookups

574: and p_los_det_cd is not null then
575: --
576: -- check if value of lookup falls within lookup type.
577: --
578: if hr_api.not_exists_in_hr_lookups
579: (p_lookup_type => 'BEN_LOS_DET',
580: p_lookup_code => p_los_det_cd,
581: p_effective_date => p_effective_date) then
582: --

Line 616: <> nvl(ben_lsf_shd.g_old_rec.no_mn_los_num_apls_flag,hr_api.g_varchar2)

612: p_object_version_number => p_object_version_number);
613: --
614: if (l_api_updating
615: and p_no_mn_los_num_apls_flag
616: <> nvl(ben_lsf_shd.g_old_rec.no_mn_los_num_apls_flag,hr_api.g_varchar2)
617: or not l_api_updating)
618: and p_no_mn_los_num_apls_flag is not null then
619: --
620: -- check if value of lookup falls within lookup type.

Line 622: if hr_api.not_exists_in_hr_lookups

618: and p_no_mn_los_num_apls_flag is not null then
619: --
620: -- check if value of lookup falls within lookup type.
621: --
622: if hr_api.not_exists_in_hr_lookups
623: (p_lookup_type => 'YES_NO',
624: p_lookup_code => p_no_mn_los_num_apls_flag,
625: p_effective_date => p_effective_date) then
626: --

Line 661: <> nvl(ben_lsf_shd.g_old_rec.no_mx_los_num_apls_flag,hr_api.g_varchar2)

657: p_object_version_number => p_object_version_number);
658: --
659: if (l_api_updating
660: and p_no_mx_los_num_apls_flag
661: <> nvl(ben_lsf_shd.g_old_rec.no_mx_los_num_apls_flag,hr_api.g_varchar2)
662: or not l_api_updating)
663: and p_no_mx_los_num_apls_flag is not null then
664: --
665: -- check if value of lookup falls within lookup type.

Line 667: if hr_api.not_exists_in_hr_lookups

663: and p_no_mx_los_num_apls_flag is not null then
664: --
665: -- check if value of lookup falls within lookup type.
666: --
667: if hr_api.not_exists_in_hr_lookups
668: (p_lookup_type => 'YES_NO',
669: p_lookup_code => p_no_mx_los_num_apls_flag,
670: p_effective_date => p_effective_date) then
671: --

Line 752: and nvl(p_los_det_rl,hr_api.g_number)

748: -- p_effective_date => p_effective_date,
749: p_object_version_number => p_object_version_number);
750: --
751: if (l_api_updating
752: and nvl(p_los_det_rl,hr_api.g_number)
753: <>BEN_LSF_SHD.g_old_rec.los_det_rl
754: or not l_api_updating)
755: and p_los_det_rl is not null then
756: --

Line 785: if nvl(p_los_det_cd,hr_api.g_varchar2) <> 'RL' and p_los_det_rl is not null then

781: -- Bug No 4242978 Moved out the following if conditions outside the outer if
782: -- as they have to called from insert_validate also
783: --
784: -- Unless LOS determination Code = Rule, LOS determination rule must be blank.
785: if nvl(p_los_det_cd,hr_api.g_varchar2) <> 'RL' and p_los_det_rl is not null then
786: --
787: fnd_message.set_name('BEN', 'BEN_91071_LOS_DET_RL_NOT_NULL');
788: fnd_message.raise_error;
789: --

Line 790: elsif nvl(p_los_det_cd,hr_api.g_varchar2) = 'RL' and p_los_det_rl is null then

786: --
787: fnd_message.set_name('BEN', 'BEN_91071_LOS_DET_RL_NOT_NULL');
788: fnd_message.raise_error;
789: --
790: elsif nvl(p_los_det_cd,hr_api.g_varchar2) = 'RL' and p_los_det_rl is null then
791: --
792: fnd_message.set_name('BEN', 'BEN_91098_LOS_DET_RL_NULL');
793: fnd_message.raise_error;
794: --

Line 868: and nvl(p_rndg_rl,hr_api.g_number)

864: -- p_effective_date => p_effective_date,
865: p_object_version_number => p_object_version_number);
866: --
867: if (l_api_updating
868: and nvl(p_rndg_rl,hr_api.g_number)
869: <>BEN_LSF_SHD.g_old_rec.rndg_rl
870: or not l_api_updating)
871: and p_rndg_rl is not null then
872: --

Line 898: if nvl(p_rndg_cd,hr_api.g_varchar2) <> 'RL' and p_rndg_rl is not null then

894: --
895: end if;
896: --
897: -- Unless Rounding Code = Rule, Rounding rule must be blank.
898: if nvl(p_rndg_cd,hr_api.g_varchar2) <> 'RL' and p_rndg_rl is not null then
899: --
900: fnd_message.set_name('BEN', 'BEN_91043_RNDG_RL_NOT_NULL');
901: fnd_message.raise_error;
902: --

Line 903: elsif nvl(p_rndg_cd,hr_api.g_varchar2) = 'RL' and p_rndg_rl is null then

899: --
900: fnd_message.set_name('BEN', 'BEN_91043_RNDG_RL_NOT_NULL');
901: fnd_message.raise_error;
902: --
903: elsif nvl(p_rndg_cd,hr_api.g_varchar2) = 'RL' and p_rndg_rl is null then
904: --
905: fnd_message.set_name('BEN', 'BEN_92340_RNDG_RL_NULL');
906: fnd_message.raise_error;
907: --

Line 982: and nvl(p_los_dt_to_use_rl,hr_api.g_number)

978: -- p_effective_date => p_effective_date,
979: p_object_version_number => p_object_version_number);
980: --
981: if (l_api_updating
982: and nvl(p_los_dt_to_use_rl,hr_api.g_number)
983: <>BEN_LSF_SHD.g_old_rec.los_dt_to_use_rl
984: or not l_api_updating)
985: and p_los_dt_to_use_rl is not null then
986: --

Line 1013: if nvl(p_los_dt_to_use_cd,hr_api.g_varchar2) <> 'RL' and p_los_dt_to_use_rl is not null then

1009: end if;
1010: --
1011: --
1012: -- Unless los_dt_to_use Code = Rule, los_dt_to_use rule must be blank.
1013: if nvl(p_los_dt_to_use_cd,hr_api.g_varchar2) <> 'RL' and p_los_dt_to_use_rl is not null then
1014: --
1015: fnd_message.set_name('BEN', 'BEN_91072_LOS_DT_RL_NOT_NULL');
1016: fnd_message.raise_error;
1017: --

Line 1018: elsif nvl(p_los_dt_to_use_cd,hr_api.g_varchar2) = 'RL' and p_los_dt_to_use_rl is null then

1014: --
1015: fnd_message.set_name('BEN', 'BEN_91072_LOS_DT_RL_NOT_NULL');
1016: fnd_message.raise_error;
1017: --
1018: elsif nvl(p_los_dt_to_use_cd,hr_api.g_varchar2) = 'RL' and p_los_dt_to_use_rl is null then
1019: --
1020: fnd_message.set_name('BEN', 'BEN_91099_LOS_DT_RL_NULL');
1021: fnd_message.raise_error;
1022: --

Line 1083: and nvl(p_name,hr_api.g_varchar2)

1079: -- p_effective_date => p_effective_date,
1080: p_object_version_number => p_object_version_number);
1081: --
1082: if (l_api_updating
1083: and nvl(p_name,hr_api.g_varchar2)
1084: <> ben_lsf_shd.g_old_rec.name
1085: or not l_api_updating)
1086: and p_name is not null then
1087: --

Line 1196: if nvl( p_no_mn_los_num_apls_flag, hr_api.g_varchar2) = 'Y'

1192: --
1193: -- If No Minimum Percent value flag set to "on" (Y),
1194: -- then minimum percent value and calc rule must be blank.
1195: --
1196: if nvl( p_no_mn_los_num_apls_flag, hr_api.g_varchar2) = 'Y'
1197: and (p_mn_los_num is not null /*or p_los_calc_rl is not null*/) then
1198: --
1199: fnd_message.set_name('BEN','BEN_92350_MIN_VAL_RULE');
1200: fnd_message.raise_error;

Line 1204: if nvl( p_no_mn_los_num_apls_flag, hr_api.g_varchar2) = 'N' and

1200: fnd_message.raise_error;
1201: --
1202: end if;
1203: --
1204: if nvl( p_no_mn_los_num_apls_flag, hr_api.g_varchar2) = 'N' and
1205: nvl(p_no_mx_los_num_apls_flag, hr_api.g_varchar2) = 'N' and
1206: p_mn_los_num is null and p_mx_los_num is null /* and
1207: p_los_calc_rl is null*/ then
1208: --

Line 1205: nvl(p_no_mx_los_num_apls_flag, hr_api.g_varchar2) = 'N' and

1201: --
1202: end if;
1203: --
1204: if nvl( p_no_mn_los_num_apls_flag, hr_api.g_varchar2) = 'N' and
1205: nvl(p_no_mx_los_num_apls_flag, hr_api.g_varchar2) = 'N' and
1206: p_mn_los_num is null and p_mx_los_num is null /* and
1207: p_los_calc_rl is null*/ then
1208: --
1209: fnd_message.set_name('BEN','BEN_92300_MIN_VAL_OR_RULE_REQ');

Line 1217: if nvl( p_no_mx_los_num_apls_flag, hr_api.g_varchar2) = 'Y'

1213: --
1214: -- If No Maximum Percent value flag set to "on" (Y),
1215: -- then maximum percent value and calc rule must be blank.
1216: --
1217: if nvl( p_no_mx_los_num_apls_flag, hr_api.g_varchar2) = 'Y'
1218: and (p_mx_los_num is not null /* or p_los_calc_rl is not null */) then
1219: --
1220: fnd_message.set_name('BEN','BEN_92301_MAX_VAL_RULE');
1221: fnd_message.raise_error;

Line 1353: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

1349: --
1350: -- Call all supporting business operations
1351: --
1352: --
1353: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1354: --
1355: chk_los_fctr_id
1356: (p_los_fctr_id => p_rec.los_fctr_id,
1357: p_object_version_number => p_rec.object_version_number);

Line 1472: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

1468: --
1469: -- Call all supporting business operations
1470: --
1471: --
1472: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1473: --
1474: chk_los_fctr_id
1475: (p_los_fctr_id => p_rec.los_fctr_id,
1476: p_object_version_number => p_rec.object_version_number);

Line 1622: hr_api.mandatory_arg_error(p_api_name => l_proc,

1618: hr_utility.set_location('Entering:'|| l_proc, 10);
1619: --
1620: -- Ensure that all the mandatory parameter are not null
1621: --
1622: hr_api.mandatory_arg_error(p_api_name => l_proc,
1623: p_argument => 'los_fctr_id',
1624: p_argument_value => p_los_fctr_id);
1625: --
1626: open csr_leg_code;