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

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

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

Line 126: and nvl(p_defined_balance_id,hr_api.g_number)

122: (p_comp_lvl_fctr_id => p_comp_lvl_fctr_id,
123: p_object_version_number => p_object_version_number);
124: --
125: if (l_api_updating
126: and nvl(p_defined_balance_id,hr_api.g_number)
127: <> ben_clf_shd.g_old_rec.defined_balance_id
128: or not l_api_updating)
129: and p_defined_balance_id is not null then
130: --

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

208: (p_comp_lvl_fctr_id => p_comp_lvl_fctr_id,
209: p_object_version_number => p_object_version_number);
210: --
211: if (l_api_updating
212: and nvl(p_rndg_rl,hr_api.g_number)
213: <> ben_clf_shd.g_old_rec.rndg_rl
214: or not l_api_updating)
215: and p_rndg_rl is not null then
216: --

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

237: --
238: end if;
239: --
240: -- Unless Rounding Code = Rule, Rounding rule must be blank.
241: if nvl(p_rndg_cd,hr_api.g_varchar2) <> 'RL' and p_rndg_rl is not null then
242: --
243: fnd_message.set_name('BEN', 'BEN_91043_RNDG_RL_NOT_NULL');
244: fnd_message.raise_error;
245: --

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

242: --
243: fnd_message.set_name('BEN', 'BEN_91043_RNDG_RL_NOT_NULL');
244: fnd_message.raise_error;
245: --
246: elsif nvl(p_rndg_cd,hr_api.g_varchar2) = 'RL' and p_rndg_rl is null then
247: --
248: fnd_message.set_name('BEN', 'BEN_92340_RNDG_RL_NULL');
249: fnd_message.raise_error;
250: --

Line 302: <> nvl(ben_clf_shd.g_old_rec.rndg_cd,hr_api.g_varchar2)

298: p_object_version_number => p_object_version_number);
299: --
300: if (l_api_updating
301: and p_rndg_cd
302: <> nvl(ben_clf_shd.g_old_rec.rndg_cd,hr_api.g_varchar2)
303: or not l_api_updating)
304: and p_rndg_cd is not null then
305: --
306: -- check if value of lookup falls within lookup type.

Line 308: if hr_api.not_exists_in_hr_lookups

304: and p_rndg_cd is not null then
305: --
306: -- check if value of lookup falls within lookup type.
307: --
308: if hr_api.not_exists_in_hr_lookups
309: (p_lookup_type => 'BEN_RNDG',
310: p_lookup_code => p_rndg_cd,
311: p_effective_date => p_effective_date) then
312: --

Line 387: and nvl(p_comp_lvl_det_rl,hr_api.g_number)

383: (p_comp_lvl_fctr_id => p_comp_lvl_fctr_id,
384: p_object_version_number => p_object_version_number);
385: --
386: if (l_api_updating
387: and nvl(p_comp_lvl_det_rl,hr_api.g_number)
388: <> ben_clf_shd.g_old_rec.comp_lvl_det_rl
389: or not l_api_updating)
390: and p_comp_lvl_det_rl is not null then
391: --

Line 419: if nvl(p_comp_lvl_det_cd,hr_api.g_varchar2) <> 'RL' and p_comp_lvl_det_rl is not null then

415: -- Bug No 4242978 Added validations for determination rule not null when
416: -- det code is RL and det rule should be null when det code not RL
417: --
418: -- Unless comp_lvl determination Code = Rule, comp_lvl determination rule must be blank.
419: if nvl(p_comp_lvl_det_cd,hr_api.g_varchar2) <> 'RL' and p_comp_lvl_det_rl is not null then
420: --
421: fnd_message.set_name('BEN', 'BEN_94207_COMP_DET_RL_NOT_NULL');
422: fnd_message.raise_error;
423: --

Line 424: elsif nvl(p_comp_lvl_det_cd,hr_api.g_varchar2) = 'RL' and p_comp_lvl_det_rl is null then

420: --
421: fnd_message.set_name('BEN', 'BEN_94207_COMP_DET_RL_NOT_NULL');
422: fnd_message.raise_error;
423: --
424: elsif nvl(p_comp_lvl_det_cd,hr_api.g_varchar2) = 'RL' and p_comp_lvl_det_rl is null then
425: --
426: fnd_message.set_name('BEN', 'BEN_94206_COMP_DET_RL_NULL');
427: fnd_message.raise_error;
428: --

Line 479: <> nvl(ben_clf_shd.g_old_rec.no_mx_comp_flag,hr_api.g_varchar2)

475: p_object_version_number => p_object_version_number);
476: --
477: if (l_api_updating
478: and p_no_mx_comp_flag
479: <> nvl(ben_clf_shd.g_old_rec.no_mx_comp_flag,hr_api.g_varchar2)
480: or not l_api_updating)
481: and p_no_mx_comp_flag is not null then
482: --
483: -- check if value of lookup falls within lookup type.

Line 485: if hr_api.not_exists_in_hr_lookups

481: and p_no_mx_comp_flag is not null then
482: --
483: -- check if value of lookup falls within lookup type.
484: --
485: if hr_api.not_exists_in_hr_lookups
486: (p_lookup_type => 'YES_NO',
487: p_lookup_code => p_no_mx_comp_flag,
488: p_effective_date => p_effective_date) then
489: --

Line 547: <> nvl(ben_clf_shd.g_old_rec.no_mn_comp_flag,hr_api.g_varchar2)

543: p_object_version_number => p_object_version_number);
544: --
545: if (l_api_updating
546: and p_no_mn_comp_flag
547: <> nvl(ben_clf_shd.g_old_rec.no_mn_comp_flag,hr_api.g_varchar2)
548: or not l_api_updating)
549: and p_no_mn_comp_flag is not null then
550: --
551: -- check if value of lookup falls within lookup type.

Line 553: if hr_api.not_exists_in_hr_lookups

549: and p_no_mn_comp_flag is not null then
550: --
551: -- check if value of lookup falls within lookup type.
552: --
553: if hr_api.not_exists_in_hr_lookups
554: (p_lookup_type => 'YES_NO',
555: p_lookup_code => p_no_mn_comp_flag,
556: p_effective_date => p_effective_date) then
557: --

Line 615: <> nvl(ben_clf_shd.g_old_rec.comp_src_cd,hr_api.g_varchar2)

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

Line 621: if hr_api.not_exists_in_hr_lookups

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

Line 691: <> nvl(ben_clf_shd.g_old_rec.comp_lvl_uom,hr_api.g_varchar2)

687: p_object_version_number => p_object_version_number);
688: --
689: if (l_api_updating
690: and p_comp_lvl_uom
691: <> nvl(ben_clf_shd.g_old_rec.comp_lvl_uom,hr_api.g_varchar2)
692: or not l_api_updating)
693: and p_comp_lvl_uom is not null then
694: --
695: -- check if value of lookup falls within fnd_currencies.

Line 697: /* if hr_api.not_exists_in_hr_lookups

693: and p_comp_lvl_uom is not null then
694: --
695: -- check if value of lookup falls within fnd_currencies.
696: --
697: /* if hr_api.not_exists_in_hr_lookups
698: (p_lookup_type => 'HR_UOM',
699: p_lookup_code => p_comp_lvl_uom,
700: p_effective_date => p_effective_date) then
701: --

Line 771: <> nvl(ben_clf_shd.g_old_rec.comp_lvl_det_cd,hr_api.g_varchar2)

767: p_object_version_number => p_object_version_number);
768: --
769: if (l_api_updating
770: and p_comp_lvl_det_cd
771: <> nvl(ben_clf_shd.g_old_rec.comp_lvl_det_cd,hr_api.g_varchar2)
772: or not l_api_updating)
773: and p_comp_lvl_det_cd is not null then
774: --
775: -- check if value of lookup falls within lookup type.

Line 777: if hr_api.not_exists_in_hr_lookups

773: and p_comp_lvl_det_cd is not null then
774: --
775: -- check if value of lookup falls within lookup type.
776: --
777: if hr_api.not_exists_in_hr_lookups
778: (p_lookup_type => 'BEN_COMP_LVL_DET',
779: p_lookup_code => p_comp_lvl_det_cd,
780: p_effective_date => p_effective_date) then
781: --

Line 842: <> nvl(ben_clf_shd.g_old_rec.sttd_sal_prdcty_cd,hr_api.g_varchar2)

838: p_object_version_number => p_object_version_number);
839: --
840: if (l_api_updating
841: and p_sttd_sal_prdcty_cd
842: <> nvl(ben_clf_shd.g_old_rec.sttd_sal_prdcty_cd,hr_api.g_varchar2)
843: or not l_api_updating)
844: and p_sttd_sal_prdcty_cd is not null then
845: --
846: -- check if value of lookup falls within lookup type.

Line 848: if hr_api.not_exists_in_hr_lookups

844: and p_sttd_sal_prdcty_cd is not null then
845: --
846: -- check if value of lookup falls within lookup type.
847: --
848: if hr_api.not_exists_in_hr_lookups
849: (p_lookup_type => 'BEN_ACTY_REF_PERD',
850: p_lookup_code => p_sttd_sal_prdcty_cd,
851: p_effective_date => p_effective_date) then
852: --

Line 911: <> nvl(ben_clf_shd.g_old_rec.comp_alt_val_to_use_cd,hr_api.g_varchar2)

907: p_object_version_number => p_object_version_number);
908: --
909: if (l_api_updating
910: and p_comp_alt_val_to_use_cd
911: <> nvl(ben_clf_shd.g_old_rec.comp_alt_val_to_use_cd,hr_api.g_varchar2)
912: or not l_api_updating)
913: and p_comp_alt_val_to_use_cd is not null then
914: --
915: -- check if value of lookup falls within lookup type.

Line 917: if hr_api.not_exists_in_hr_lookups

913: and p_comp_alt_val_to_use_cd is not null then
914: --
915: -- check if value of lookup falls within lookup type.
916: --
917: if hr_api.not_exists_in_hr_lookups
918: (p_lookup_type => 'BEN_COMP_ALT_VAL_TO_USE',
919: p_lookup_code => p_comp_alt_val_to_use_cd,
920: p_effective_date => p_effective_date) then
921: --

Line 996: and nvl(p_comp_calc_rl,hr_api.g_number)

992: (p_comp_lvl_fctr_id => p_comp_lvl_fctr_id,
993: p_object_version_number => p_object_version_number);
994: --
995: if (l_api_updating
996: and nvl(p_comp_calc_rl,hr_api.g_number)
997: <> ben_clf_shd.g_old_rec.comp_calc_rl
998: or not l_api_updating)
999: and p_comp_calc_rl is not null then
1000: --

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

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

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

1150: hr_utility.set_location('p_day_mo '||p_day_mo, 5);
1151: hr_utility.set_location('p_year '||p_year, 5);
1152: --
1153: if p_day_mo is null then
1154: hr_api.mandatory_arg_error(p_api_name => l_proc,
1155: p_argument => p_label,
1156: p_argument_value => '');
1157: end if;
1158: l_date := to_date(substr('0'||p_day_mo,-4)||l_year,'ddmmyyyy');

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

1494: --
1495: -- Call all supporting business operations
1496: --
1497: --
1498: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1499: --
1500: chk_comp_lvl_fctr_id
1501: (p_comp_lvl_fctr_id => p_rec.comp_lvl_fctr_id,
1502: p_object_version_number => p_rec.object_version_number);

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

1629: --
1630: -- Call all supporting business operations
1631: --
1632: --
1633: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1634: --
1635: chk_comp_lvl_fctr_id
1636: (p_comp_lvl_fctr_id => p_rec.comp_lvl_fctr_id,
1637: p_object_version_number => p_rec.object_version_number);

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

1799: hr_utility.set_location('Entering:'|| l_proc, 10);
1800: --
1801: -- Ensure that all the mandatory parameter are not null
1802: --
1803: hr_api.mandatory_arg_error(p_api_name => l_proc,
1804: p_argument => 'comp_lvl_fctr_id',
1805: p_argument_value => p_comp_lvl_fctr_id);
1806: --
1807: open csr_leg_code;