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

Line 50: hr_utility.set_location(hr_api.g_package||'not_exists_in_hr_lookups', 10);

46: -- If the value is not known then go onto check against the
47: -- hr_lookups view. Just in case there has been a change to
48: -- the system defined lookup.
49: end if;
50: hr_utility.set_location(hr_api.g_package||'not_exists_in_hr_lookups', 10);
51: --
52: open csr_hr_look;
53: fetch csr_hr_look into l_exists;
54: if csr_hr_look%notfound then

Line 103: hr_utility.set_location(hr_api.g_package||'not_exists_in_hrstanlookups', 10);

99: -- If the value is not known then go onto check against the
100: -- hr_lookups view. Just in case there has been a change to
101: -- the system defined lookup.
102: end if;
103: hr_utility.set_location(hr_api.g_package||'not_exists_in_hrstanlookups', 10);
104: --
105: open csr_hr_look;
106: fetch csr_hr_look into l_exists;
107: if csr_hr_look%notfound then

Line 193: hr_api.mandatory_arg_error

189: hr_utility.set_location('Entering:'|| l_proc, 10);
190: --
191: -- Ensure that all the mandatory parameter are not null
192: --
193: hr_api.mandatory_arg_error
194: (p_api_name => l_proc
195: ,p_argument => 'ext_crit_val_id'
196: ,p_argument_value => p_ext_crit_val_id
197: );

Line 216: hr_api.set_security_group_id

212: close csr_sec_grp;
213: --
214: -- Set the security_group_id in CLIENT_INFO
215: --
216: hr_api.set_security_group_id
217: (p_security_group_id => l_security_group_id
218: );
219: --
220: hr_utility.set_location(' Leaving:'|| l_proc, 20);

Line 266: and nvl(p_ext_crit_val_id,hr_api.g_number)

262: (p_ext_crit_val_id => p_ext_crit_val_id,
263: p_object_version_number => p_object_version_number);
264: --
265: if (l_api_updating
266: and nvl(p_ext_crit_val_id,hr_api.g_number)
267: <> ben_xcv_shd.g_old_rec.ext_crit_val_id) then
268: --
269: -- raise error as PK has changed
270: --

Line 338: and nvl(p_ext_crit_typ_id,hr_api.g_number)

334: (p_ext_crit_val_id => p_ext_crit_val_id,
335: p_object_version_number => p_object_version_number);
336: --
337: if (l_api_updating
338: and nvl(p_ext_crit_typ_id,hr_api.g_number)
339: <> nvl(ben_xcv_shd.g_old_rec.ext_crit_typ_id,hr_api.g_number)
340: or not l_api_updating) then
341: --
342: -- check if ext_crit_typ_id value exists in ben_ext_crit_typ table

Line 339: <> nvl(ben_xcv_shd.g_old_rec.ext_crit_typ_id,hr_api.g_number)

335: p_object_version_number => p_object_version_number);
336: --
337: if (l_api_updating
338: and nvl(p_ext_crit_typ_id,hr_api.g_number)
339: <> nvl(ben_xcv_shd.g_old_rec.ext_crit_typ_id,hr_api.g_number)
340: or not l_api_updating) then
341: --
342: -- check if ext_crit_typ_id value exists in ben_ext_crit_typ table
343: --

Line 400: and nvl(p_ext_crit_bg_id,hr_api.g_number)

396: (p_ext_crit_val_id => p_ext_crit_val_id,
397: p_object_version_number => p_object_version_number);
398: --
399: if (l_api_updating
400: and nvl(p_ext_crit_bg_id,hr_api.g_number)
401: <> nvl(ben_xcv_shd.g_old_rec.ext_crit_bg_id,hr_api.g_number)
402: or not l_api_updating) then
403: --
404: -- check if ext_crit_typ_id value exists in ben_ext_crit_typ table

Line 401: <> nvl(ben_xcv_shd.g_old_rec.ext_crit_bg_id,hr_api.g_number)

397: p_object_version_number => p_object_version_number);
398: --
399: if (l_api_updating
400: and nvl(p_ext_crit_bg_id,hr_api.g_number)
401: <> nvl(ben_xcv_shd.g_old_rec.ext_crit_bg_id,hr_api.g_number)
402: or not l_api_updating) then
403: --
404: -- check if ext_crit_typ_id value exists in ben_ext_crit_typ table
405: --

Line 578: and nvl(p_val_1,hr_api.g_varchar2)

574: (p_ext_crit_val_id => p_ext_crit_val_id,
575: p_object_version_number => p_object_version_number);
576: --
577: if (l_api_updating
578: and nvl(p_val_1,hr_api.g_varchar2)
579: <> nvl(ben_xcv_shd.g_old_rec.val_1,hr_api.g_varchar2)
580: or not l_api_updating) then
581: --
582: -- val_1 is mandatory

Line 579: <> nvl(ben_xcv_shd.g_old_rec.val_1,hr_api.g_varchar2)

575: p_object_version_number => p_object_version_number);
576: --
577: if (l_api_updating
578: and nvl(p_val_1,hr_api.g_varchar2)
579: <> nvl(ben_xcv_shd.g_old_rec.val_1,hr_api.g_varchar2)
580: or not l_api_updating) then
581: --
582: -- val_1 is mandatory
583: --

Line 626: if hr_api.not_exists_in_hr_lookups

622: -- check if value of lookup falls within lookup type.
623: --
624: if p_business_group_id is not null then
625: /* BG is set, so use the existing call, with no modifications*/
626: if hr_api.not_exists_in_hr_lookups
627: (p_lookup_type => 'US_STATE',
628: p_lookup_code => p_val_1,
629: p_effective_date => p_effective_date) then
630: --

Line 713: if hr_api.not_exists_in_hr_lookups

709: -- check if value of lookup falls within lookup type.
710: --
711: if p_business_group_id is not null then
712: /* BG is set, so use the existing call, with no modifications*/
713: if hr_api.not_exists_in_hr_lookups
714: (p_lookup_type => 'BEN_EXT_CHG_TYP',
715: p_lookup_code => p_val_1,
716: p_effective_date => p_effective_date) then
717: --

Line 763: if hr_api.not_exists_in_hr_lookups

759: --
760: if p_val_2 is null or p_val_2 = 'BEN' then
761: if p_business_group_id is not null then
762: /* BG is set, so use the existing call, with no modifications*/
763: if hr_api.not_exists_in_hr_lookups
764: (p_lookup_type => 'BEN_EXT_CHG_EVT',
765: p_lookup_code => p_val_1,
766: p_effective_date => p_effective_date) then
767: --

Line 933: and nvl(p_val_2,hr_api.g_varchar2)

929: (p_ext_crit_val_id => p_ext_crit_val_id,
930: p_object_version_number => p_object_version_number);
931: --
932: if (l_api_updating
933: and nvl(p_val_2,hr_api.g_varchar2)
934: <> nvl(ben_xcv_shd.g_old_rec.val_2,hr_api.g_varchar2)
935: or not l_api_updating) then
936: --
937: open c1;

Line 934: <> nvl(ben_xcv_shd.g_old_rec.val_2,hr_api.g_varchar2)

930: p_object_version_number => p_object_version_number);
931: --
932: if (l_api_updating
933: and nvl(p_val_2,hr_api.g_varchar2)
934: <> nvl(ben_xcv_shd.g_old_rec.val_2,hr_api.g_varchar2)
935: or not l_api_updating) then
936: --
937: open c1;
938: -- won't fail because already checked in above edit.

Line 1031: (nvl(p_val_1,hr_api.g_varchar2)

1027: p_object_version_number => p_object_version_number);
1028: --
1029: if (l_api_updating
1030: and
1031: (nvl(p_val_1,hr_api.g_varchar2)
1032: <> nvl(ben_xcv_shd.g_old_rec.val_1,hr_api.g_varchar2) or
1033: nvl(p_val_2,hr_api.g_varchar2)
1034: <> nvl(ben_xcv_shd.g_old_rec.val_2,hr_api.g_varchar2))
1035: or not l_api_updating) then

Line 1032: <> nvl(ben_xcv_shd.g_old_rec.val_1,hr_api.g_varchar2) or

1028: --
1029: if (l_api_updating
1030: and
1031: (nvl(p_val_1,hr_api.g_varchar2)
1032: <> nvl(ben_xcv_shd.g_old_rec.val_1,hr_api.g_varchar2) or
1033: nvl(p_val_2,hr_api.g_varchar2)
1034: <> nvl(ben_xcv_shd.g_old_rec.val_2,hr_api.g_varchar2))
1035: or not l_api_updating) then
1036: --

Line 1033: nvl(p_val_2,hr_api.g_varchar2)

1029: if (l_api_updating
1030: and
1031: (nvl(p_val_1,hr_api.g_varchar2)
1032: <> nvl(ben_xcv_shd.g_old_rec.val_1,hr_api.g_varchar2) or
1033: nvl(p_val_2,hr_api.g_varchar2)
1034: <> nvl(ben_xcv_shd.g_old_rec.val_2,hr_api.g_varchar2))
1035: or not l_api_updating) then
1036: --
1037: open c1;

Line 1034: <> nvl(ben_xcv_shd.g_old_rec.val_2,hr_api.g_varchar2))

1030: and
1031: (nvl(p_val_1,hr_api.g_varchar2)
1032: <> nvl(ben_xcv_shd.g_old_rec.val_1,hr_api.g_varchar2) or
1033: nvl(p_val_2,hr_api.g_varchar2)
1034: <> nvl(ben_xcv_shd.g_old_rec.val_2,hr_api.g_varchar2))
1035: or not l_api_updating) then
1036: --
1037: open c1;
1038: fetch c1 into l_crit_typ_cd;

Line 1079: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate bus_grp

1075: chk_startup_action(True
1076: ,p_rec.business_group_id
1077: ,p_rec.legislation_code);
1078: IF hr_startup_data_api_support.g_startup_mode NOT IN ('GENERIC','STARTUP') THEN
1079: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate bus_grp
1080: END IF;
1081: --
1082: chk_ext_crit_val_id
1083: (p_ext_crit_val_id => p_rec.ext_crit_val_id,

Line 1148: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate bus_grp

1144: chk_startup_action(False
1145: ,p_rec.business_group_id
1146: ,p_rec.legislation_code);
1147: IF hr_startup_data_api_support.g_startup_mode NOT IN ('GENERIC','STARTUP') THEN
1148: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate bus_grp
1149: END IF;
1150: --
1151: chk_ext_crit_val_id
1152: (p_ext_crit_val_id => p_rec.ext_crit_val_id,

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

1242: hr_utility.set_location('Entering:'|| l_proc, 10);
1243: --
1244: -- Ensure that all the mandatory parameter are not null
1245: --
1246: hr_api.mandatory_arg_error(p_api_name => l_proc,
1247: p_argument => 'ext_crit_val_id',
1248: p_argument_value => p_ext_crit_val_id);
1249: --
1250: open csr_leg_code;