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

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

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

Line 124: and nvl(p_organization_id,hr_api.g_number)

120: (p_age_fctr_id => p_age_fctr_id,
121: p_object_version_number => p_object_version_number);
122: --
123: if (l_api_updating
124: and nvl(p_organization_id,hr_api.g_number)
125: <> nvl(ben_agf_shd.g_old_rec.organization_id,hr_api.g_number)
126: or not l_api_updating) then
127: --
128: -- check if organization_id value exists in hr_all_organization_units table

Line 125: <> nvl(ben_agf_shd.g_old_rec.organization_id,hr_api.g_number)

121: p_object_version_number => p_object_version_number);
122: --
123: if (l_api_updating
124: and nvl(p_organization_id,hr_api.g_number)
125: <> nvl(ben_agf_shd.g_old_rec.organization_id,hr_api.g_number)
126: or not l_api_updating) then
127: --
128: -- check if organization_id value exists in hr_all_organization_units table
129: --

Line 197: <> nvl(ben_agf_shd.g_old_rec.age_to_use_cd,hr_api.g_varchar2)

193: p_object_version_number => p_object_version_number);
194: --
195: if (l_api_updating
196: and p_age_to_use_cd
197: <> nvl(ben_agf_shd.g_old_rec.age_to_use_cd,hr_api.g_varchar2)
198: or not l_api_updating) and p_age_to_use_cd is not null then
199: --
200: -- check if value of lookup falls within lookup type.
201: --

Line 203: if hr_api.not_exists_in_hr_lookups

199: --
200: -- check if value of lookup falls within lookup type.
201: --
202: --
203: if hr_api.not_exists_in_hr_lookups
204: (p_lookup_type => 'BEN_AGE_TO_USE_CD',
205: p_lookup_code => p_age_to_use_cd,
206: p_effective_date => p_effective_date) then
207: --

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

264: (p_age_fctr_id => p_age_fctr_id,
265: p_object_version_number => p_object_version_number);
266: --
267: if (l_api_updating
268: and nvl(p_rndg_rl,hr_api.g_number)
269: <> ben_agf_shd.g_old_rec.rndg_rl
270: or not l_api_updating)
271: and p_rndg_rl is not null then
272: --

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

290: end if;
291: --
292: -- Bug No 4242978
293: -- Unless Rounding Code = Rule, Rounding rule must be blank.
294: if nvl(p_rndg_cd,hr_api.g_varchar2) <> 'RL' and p_rndg_rl is not null then
295: --
296: fnd_message.set_name('BEN', 'BEN_91043_RNDG_RL_NOT_NULL');
297: fnd_message.raise_error;
298: --

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

295: --
296: fnd_message.set_name('BEN', 'BEN_91043_RNDG_RL_NOT_NULL');
297: fnd_message.raise_error;
298: --
299: elsif nvl(p_rndg_cd,hr_api.g_varchar2) = 'RL' and p_rndg_rl is null then
300: --
301: fnd_message.set_name('BEN', 'BEN_92340_RNDG_RL_NULL');
302: fnd_message.raise_error;
303: --

Line 354: and nvl(p_age_calc_rl,hr_api.g_number)

350: (p_age_fctr_id => p_age_fctr_id,
351: p_object_version_number => p_object_version_number);
352: --
353: if (l_api_updating
354: and nvl(p_age_calc_rl,hr_api.g_number)
355: <> ben_agf_shd.g_old_rec.age_calc_rl
356: or not l_api_updating)
357: and p_age_calc_rl is not null then
358: --

Line 473: <> nvl(ben_agf_shd.g_old_rec.rndg_cd,hr_api.g_varchar2)

469: p_object_version_number => p_object_version_number);
470: --
471: if (l_api_updating
472: and p_rndg_cd
473: <> nvl(ben_agf_shd.g_old_rec.rndg_cd,hr_api.g_varchar2)
474: or not l_api_updating)
475: and p_rndg_cd is not null then
476: --
477: -- check if value of lookup falls within lookup type.

Line 479: if hr_api.not_exists_in_hr_lookups

475: and p_rndg_cd is not null then
476: --
477: -- check if value of lookup falls within lookup type.
478: --
479: if hr_api.not_exists_in_hr_lookups
480: (p_lookup_type => 'BEN_RNDG',
481: p_lookup_code => p_rndg_cd,
482: p_effective_date => p_effective_date) then
483: --

Line 545: and nvl(p_age_det_rl,hr_api.g_number)

541: (p_age_fctr_id => p_age_fctr_id,
542: p_object_version_number => p_object_version_number);
543: --
544: if (l_api_updating
545: and nvl(p_age_det_rl,hr_api.g_number)
546: <> ben_agf_shd.g_old_rec.age_det_rl
547: or not l_api_updating)
548: and p_age_det_rl is not null then
549: --

Line 573: if nvl(p_age_det_cd,hr_api.g_varchar2) <> 'RL' and p_age_det_rl is not null then

569: -- Bug No 4242978 Added validations for determination rule not null when
570: -- det code is RL and det rule should be null when det code not RL
571: --
572: -- Unless AGE determination Code = Rule, AGE determination rule must be blank.
573: if nvl(p_age_det_cd,hr_api.g_varchar2) <> 'RL' and p_age_det_rl is not null then
574: --
575: fnd_message.set_name('BEN', 'BEN_91046_AGE_DET_RL_NOT_NULL');
576: fnd_message.raise_error;
577: --

Line 578: elsif nvl(p_age_det_cd,hr_api.g_varchar2) = 'RL' and p_age_det_rl is null then

574: --
575: fnd_message.set_name('BEN', 'BEN_91046_AGE_DET_RL_NOT_NULL');
576: fnd_message.raise_error;
577: --
578: elsif nvl(p_age_det_cd,hr_api.g_varchar2) = 'RL' and p_age_det_rl is null then
579: --
580: fnd_message.set_name('BEN', 'BEN_91096_AGE_DET_RL_NULL');
581: fnd_message.raise_error;
582: --

Line 633: <> nvl(ben_agf_shd.g_old_rec.age_det_cd,hr_api.g_varchar2)

629: p_object_version_number => p_object_version_number);
630: --
631: if (l_api_updating
632: and p_age_det_cd
633: <> nvl(ben_agf_shd.g_old_rec.age_det_cd,hr_api.g_varchar2)
634: or not l_api_updating)
635: and p_age_det_cd is not null then
636: --
637: -- check if value of lookup falls within lookup type.

Line 639: if hr_api.not_exists_in_hr_lookups

635: and p_age_det_cd is not null then
636: --
637: -- check if value of lookup falls within lookup type.
638: --
639: if hr_api.not_exists_in_hr_lookups
640: (p_lookup_type => 'BEN_AGE_DET',
641: p_lookup_code => p_age_det_cd,
642: p_effective_date => p_effective_date) then
643: --

Line 703: <> nvl(ben_agf_shd.g_old_rec.no_mx_age_flag,hr_api.g_varchar2)

699: p_object_version_number => p_object_version_number);
700: --
701: if (l_api_updating
702: and p_no_mx_age_flag
703: <> nvl(ben_agf_shd.g_old_rec.no_mx_age_flag,hr_api.g_varchar2)
704: or not l_api_updating) then
705: --
706: -- check if value of lookup falls within lookup type.
707: --

Line 709: if hr_api.not_exists_in_hr_lookups

705: --
706: -- check if value of lookup falls within lookup type.
707: --
708: --
709: if hr_api.not_exists_in_hr_lookups
710: (p_lookup_type => 'YES_NO',
711: p_lookup_code => p_no_mx_age_flag,
712: p_effective_date => p_effective_date) then
713: --

Line 773: <> nvl(ben_agf_shd.g_old_rec.no_mn_age_flag,hr_api.g_varchar2)

769: p_object_version_number => p_object_version_number);
770: --
771: if (l_api_updating
772: and p_no_mn_age_flag
773: <> nvl(ben_agf_shd.g_old_rec.no_mn_age_flag,hr_api.g_varchar2)
774: or not l_api_updating) then
775: --
776: -- check if value of lookup falls within lookup type.
777: --

Line 779: if hr_api.not_exists_in_hr_lookups

775: --
776: -- check if value of lookup falls within lookup type.
777: --
778: --
779: if hr_api.not_exists_in_hr_lookups
780: (p_lookup_type => 'YES_NO',
781: p_lookup_code => p_no_mn_age_flag,
782: p_effective_date => p_effective_date) then
783: --

Line 843: <> nvl(ben_agf_shd.g_old_rec.age_uom,hr_api.g_varchar2)

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

Line 849: if hr_api.not_exists_in_hr_lookups

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

Line 937: if nvl( p_no_mn_age_flag, hr_api.g_varchar2) = 'Y'

933: --
934: -- If No Minimum age flag set to "on" (Y),
935: -- then minimum age number must be blank.
936: --
937: if nvl( p_no_mn_age_flag, hr_api.g_varchar2) = 'Y'
938: and p_mn_age_num is not null
939: then
940: fnd_message.set_name('BEN','BEN_91054_MIN_VAL_NOT_NULL');
941: fnd_message.raise_error;

Line 942: elsif nvl( p_no_mn_age_flag, hr_api.g_varchar2) = 'N'

938: and p_mn_age_num is not null
939: then
940: fnd_message.set_name('BEN','BEN_91054_MIN_VAL_NOT_NULL');
941: fnd_message.raise_error;
942: elsif nvl( p_no_mn_age_flag, hr_api.g_varchar2) = 'N'
943: and p_mn_age_num is null
944: then
945: fnd_message.set_name('BEN','BEN_91055_MIN_VAL_REQUIRED');
946: fnd_message.raise_error;

Line 952: if nvl( p_no_mx_age_flag, hr_api.g_varchar2) = 'Y'

948: --
949: -- If No Maximum age flag set to "on" (Y),
950: -- then maximum age number must be blank.
951: --
952: if nvl( p_no_mx_age_flag, hr_api.g_varchar2) = 'Y'
953: and p_mx_age_num is not null
954: then
955: fnd_message.set_name('BEN','BEN_91056_MAX_VAL_NOT_NULL');
956: fnd_message.raise_error;

Line 957: elsif nvl( p_no_mx_age_flag, hr_api.g_varchar2) = 'N'

953: and p_mx_age_num is not null
954: then
955: fnd_message.set_name('BEN','BEN_91056_MAX_VAL_NOT_NULL');
956: fnd_message.raise_error;
957: elsif nvl( p_no_mx_age_flag, hr_api.g_varchar2) = 'N'
958: and p_mx_age_num is null
959: then
960: fnd_message.set_name('BEN','BEN_91057_MAX_VAL_REQUIRED');
961: fnd_message.raise_error;

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

1017: -- p_effective_date => p_effective_date,
1018: p_object_version_number => p_object_version_number);
1019: --
1020: if (l_api_updating
1021: and nvl(p_name,hr_api.g_varchar2)
1022: <> ben_agf_shd.g_old_rec.name
1023: or not l_api_updating)
1024: and p_name is not null then
1025: --

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

1172: --
1173: -- Call all supporting business operations
1174: --
1175: --
1176: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1177: --
1178: chk_age_fctr_id
1179: (p_age_fctr_id => p_rec.age_fctr_id,
1180: p_object_version_number => p_rec.object_version_number);

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

1280: --
1281: -- Call all supporting business operations
1282: --
1283: --
1284: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1285: --
1286: chk_age_fctr_id
1287: (p_age_fctr_id => p_rec.age_fctr_id,
1288: p_object_version_number => p_rec.object_version_number);

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

1419: hr_utility.set_location('Entering:'|| l_proc, 10);
1420: --
1421: -- Ensure that all the mandatory parameter are not null
1422: --
1423: hr_api.mandatory_arg_error(p_api_name => l_proc,
1424: p_argument => 'age_fctr_id',
1425: p_argument_value => p_age_fctr_id);
1426: --
1427: open csr_leg_code;