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

Line 38: hr_api.mandatory_arg_error

34: hr_utility.set_location('Entering:'|| l_proc, 10);
35: --
36: -- Ensure that all the mandatory parameter are not null
37: --
38: hr_api.mandatory_arg_error
39: (p_api_name => l_proc
40: ,p_argument => 'ext_data_elmt_id'
41: ,p_argument_value => p_ext_data_elmt_id
42: );

Line 61: hr_api.set_security_group_id

57: close csr_sec_grp;
58: --
59: -- Set the security_group_id in CLIENT_INFO
60: --
61: hr_api.set_security_group_id
62: (p_security_group_id => l_security_group_id
63: );
64: --
65: hr_utility.set_location(' Leaving:'|| l_proc, 20);

Line 111: and nvl(p_ext_data_elmt_id,hr_api.g_number)

107: (p_ext_data_elmt_id => p_ext_data_elmt_id,
108: p_object_version_number => p_object_version_number);
109: --
110: if (l_api_updating
111: and nvl(p_ext_data_elmt_id,hr_api.g_number)
112: <> ben_xel_shd.g_old_rec.ext_data_elmt_id) then
113: --
114: -- raise error as PK has changed
115: --

Line 189: <> nvl(ben_xel_shd.g_old_rec.frmt_mask_cd,hr_api.g_varchar2)

185: p_object_version_number => p_object_version_number);
186: --
187: if (l_api_updating
188: and p_frmt_mask_cd
189: <> nvl(ben_xel_shd.g_old_rec.frmt_mask_cd,hr_api.g_varchar2)
190: or not l_api_updating)
191: and p_frmt_mask_cd is not null then
192: --
193: -- check if value of lookup falls within lookup type.

Line 196: if hr_api.not_exists_in_hr_lookups

192: --
193: -- check if value of lookup falls within lookup type.
194: --
195: if p_business_group_id is not null then
196: if hr_api.not_exists_in_hr_lookups
197: (p_lookup_type => 'BEN_EXT_FRMT_MASK',
198: p_lookup_code => p_frmt_mask_cd,
199: p_effective_date => p_effective_date) then
200: --

Line 211: if hr_api.not_exists_in_hrstanlookups

207: --
208: end if;
209: --
210: else
211: if hr_api.not_exists_in_hrstanlookups
212: (p_lookup_type => 'BEN_EXT_FRMT_MASK',
213: p_lookup_code => p_frmt_mask_cd,
214: p_effective_date => p_effective_date) then
215: --

Line 336: and nvl(p_data_elmt_rl,hr_api.g_number)

332: (p_ext_data_elmt_id => p_ext_data_elmt_id,
333: p_object_version_number => p_object_version_number);
334: --
335: if (l_api_updating
336: and nvl(p_data_elmt_rl,hr_api.g_number)
337: <> ben_xel_shd.g_old_rec.data_elmt_rl
338: or not l_api_updating)
339: and p_data_elmt_rl is not null then
340: --

Line 524: and ( ( p_data_elmt_typ_cd <> nvl(ben_xel_shd.g_old_rec.data_elmt_typ_cd,hr_api.g_varchar2))

520: (p_ext_data_elmt_id => p_ext_data_elmt_id,
521: p_object_version_number => p_object_version_number);
522: --
523: if (l_api_updating
524: and ( ( p_data_elmt_typ_cd <> nvl(ben_xel_shd.g_old_rec.data_elmt_typ_cd,hr_api.g_varchar2))
525: or( nvl(p_string_val,hr_api.g_varchar2) <> nvl(ben_xel_shd.g_old_rec.string_val,hr_api.g_varchar2))
526: or( nvl(p_max_length_num,hr_api.g_number) <> nvl(ben_xel_shd.g_old_rec.max_length_num,hr_api.g_number))
527: or( nvl(p_data_elmt_rl,hr_api.g_number) <> nvl(ben_xel_shd.g_old_rec.data_elmt_rl,hr_api.g_number))
528: or( nvl(p_ttl_fnctn_cd,hr_api.g_varchar2) <> nvl(ben_xel_shd.g_old_rec.ttl_fnctn_cd,hr_api.g_varchar2))

Line 525: or( nvl(p_string_val,hr_api.g_varchar2) <> nvl(ben_xel_shd.g_old_rec.string_val,hr_api.g_varchar2))

521: p_object_version_number => p_object_version_number);
522: --
523: if (l_api_updating
524: and ( ( p_data_elmt_typ_cd <> nvl(ben_xel_shd.g_old_rec.data_elmt_typ_cd,hr_api.g_varchar2))
525: or( nvl(p_string_val,hr_api.g_varchar2) <> nvl(ben_xel_shd.g_old_rec.string_val,hr_api.g_varchar2))
526: or( nvl(p_max_length_num,hr_api.g_number) <> nvl(ben_xel_shd.g_old_rec.max_length_num,hr_api.g_number))
527: or( nvl(p_data_elmt_rl,hr_api.g_number) <> nvl(ben_xel_shd.g_old_rec.data_elmt_rl,hr_api.g_number))
528: or( nvl(p_ttl_fnctn_cd,hr_api.g_varchar2) <> nvl(ben_xel_shd.g_old_rec.ttl_fnctn_cd,hr_api.g_varchar2))
529: or( nvl(p_defined_balance_id,hr_api.g_number) <> nvl(ben_xel_shd.g_old_rec.defined_balance_id,hr_api.g_number))

Line 526: or( nvl(p_max_length_num,hr_api.g_number) <> nvl(ben_xel_shd.g_old_rec.max_length_num,hr_api.g_number))

522: --
523: if (l_api_updating
524: and ( ( p_data_elmt_typ_cd <> nvl(ben_xel_shd.g_old_rec.data_elmt_typ_cd,hr_api.g_varchar2))
525: or( nvl(p_string_val,hr_api.g_varchar2) <> nvl(ben_xel_shd.g_old_rec.string_val,hr_api.g_varchar2))
526: or( nvl(p_max_length_num,hr_api.g_number) <> nvl(ben_xel_shd.g_old_rec.max_length_num,hr_api.g_number))
527: or( nvl(p_data_elmt_rl,hr_api.g_number) <> nvl(ben_xel_shd.g_old_rec.data_elmt_rl,hr_api.g_number))
528: or( nvl(p_ttl_fnctn_cd,hr_api.g_varchar2) <> nvl(ben_xel_shd.g_old_rec.ttl_fnctn_cd,hr_api.g_varchar2))
529: or( nvl(p_defined_balance_id,hr_api.g_number) <> nvl(ben_xel_shd.g_old_rec.defined_balance_id,hr_api.g_number))
530: )

Line 527: or( nvl(p_data_elmt_rl,hr_api.g_number) <> nvl(ben_xel_shd.g_old_rec.data_elmt_rl,hr_api.g_number))

523: if (l_api_updating
524: and ( ( p_data_elmt_typ_cd <> nvl(ben_xel_shd.g_old_rec.data_elmt_typ_cd,hr_api.g_varchar2))
525: or( nvl(p_string_val,hr_api.g_varchar2) <> nvl(ben_xel_shd.g_old_rec.string_val,hr_api.g_varchar2))
526: or( nvl(p_max_length_num,hr_api.g_number) <> nvl(ben_xel_shd.g_old_rec.max_length_num,hr_api.g_number))
527: or( nvl(p_data_elmt_rl,hr_api.g_number) <> nvl(ben_xel_shd.g_old_rec.data_elmt_rl,hr_api.g_number))
528: or( nvl(p_ttl_fnctn_cd,hr_api.g_varchar2) <> nvl(ben_xel_shd.g_old_rec.ttl_fnctn_cd,hr_api.g_varchar2))
529: or( nvl(p_defined_balance_id,hr_api.g_number) <> nvl(ben_xel_shd.g_old_rec.defined_balance_id,hr_api.g_number))
530: )
531: or not l_api_updating)

Line 528: or( nvl(p_ttl_fnctn_cd,hr_api.g_varchar2) <> nvl(ben_xel_shd.g_old_rec.ttl_fnctn_cd,hr_api.g_varchar2))

524: and ( ( p_data_elmt_typ_cd <> nvl(ben_xel_shd.g_old_rec.data_elmt_typ_cd,hr_api.g_varchar2))
525: or( nvl(p_string_val,hr_api.g_varchar2) <> nvl(ben_xel_shd.g_old_rec.string_val,hr_api.g_varchar2))
526: or( nvl(p_max_length_num,hr_api.g_number) <> nvl(ben_xel_shd.g_old_rec.max_length_num,hr_api.g_number))
527: or( nvl(p_data_elmt_rl,hr_api.g_number) <> nvl(ben_xel_shd.g_old_rec.data_elmt_rl,hr_api.g_number))
528: or( nvl(p_ttl_fnctn_cd,hr_api.g_varchar2) <> nvl(ben_xel_shd.g_old_rec.ttl_fnctn_cd,hr_api.g_varchar2))
529: or( nvl(p_defined_balance_id,hr_api.g_number) <> nvl(ben_xel_shd.g_old_rec.defined_balance_id,hr_api.g_number))
530: )
531: or not l_api_updating)
532: and p_data_elmt_typ_cd is not null then

Line 529: or( nvl(p_defined_balance_id,hr_api.g_number) <> nvl(ben_xel_shd.g_old_rec.defined_balance_id,hr_api.g_number))

525: or( nvl(p_string_val,hr_api.g_varchar2) <> nvl(ben_xel_shd.g_old_rec.string_val,hr_api.g_varchar2))
526: or( nvl(p_max_length_num,hr_api.g_number) <> nvl(ben_xel_shd.g_old_rec.max_length_num,hr_api.g_number))
527: or( nvl(p_data_elmt_rl,hr_api.g_number) <> nvl(ben_xel_shd.g_old_rec.data_elmt_rl,hr_api.g_number))
528: or( nvl(p_ttl_fnctn_cd,hr_api.g_varchar2) <> nvl(ben_xel_shd.g_old_rec.ttl_fnctn_cd,hr_api.g_varchar2))
529: or( nvl(p_defined_balance_id,hr_api.g_number) <> nvl(ben_xel_shd.g_old_rec.defined_balance_id,hr_api.g_number))
530: )
531: or not l_api_updating)
532: and p_data_elmt_typ_cd is not null then
533: --

Line 538: if hr_api.not_exists_in_hr_lookups

534: -- check if value of lookup falls within lookup type.
535: --
536: hr_utility.set_location('update mode :' || p_string_val ||' '|| ben_xel_shd.g_old_rec.string_val, 5);
537: if p_business_group_id is not null then
538: if hr_api.not_exists_in_hr_lookups
539: (p_lookup_type => 'BEN_EXT_DATA_ELMT_TYP',
540: p_lookup_code => p_data_elmt_typ_cd,
541: p_effective_date => p_effective_date) then
542: --

Line 553: if hr_api.not_exists_in_hrstanlookups

549: --
550: end if;
551: --
552: else
553: if hr_api.not_exists_in_hrstanlookups
554: (p_lookup_type => 'BEN_EXT_DATA_ELMT_TYP',
555: p_lookup_code => p_data_elmt_typ_cd,
556: p_effective_date => p_effective_date) then
557: --

Line 657: <> nvl(ben_xel_shd.g_old_rec.just_cd,hr_api.g_varchar2)

653: p_object_version_number => p_object_version_number);
654: --
655: if (l_api_updating
656: and p_just_cd
657: <> nvl(ben_xel_shd.g_old_rec.just_cd,hr_api.g_varchar2)
658: or not l_api_updating)
659: and p_just_cd is not null then
660: --
661: -- check if value of lookup falls within lookup type.

Line 664: if hr_api.not_exists_in_hr_lookups

660: --
661: -- check if value of lookup falls within lookup type.
662: --
663: if p_business_group_id is not null then
664: if hr_api.not_exists_in_hr_lookups
665: (p_lookup_type => 'BEN_EXT_JUST',
666: p_lookup_code => p_just_cd,
667: p_effective_date => p_effective_date) then
668: --

Line 679: if hr_api.not_exists_in_hrstanlookups

675: --
676: end if;
677: --
678: else
679: if hr_api.not_exists_in_hrstanlookups
680: (p_lookup_type => 'BEN_EXT_JUST',
681: p_lookup_code => p_just_cd,
682: p_effective_date => p_effective_date) then
683: --

Line 754: <> nvl(ben_xel_shd.g_old_rec.defined_balance_id,hr_api.g_number)

750: p_object_version_number => p_object_version_number);
751: --
752: if (l_api_updating
753: and p_defined_balance_id
754: <> nvl(ben_xel_shd.g_old_rec.defined_balance_id,hr_api.g_number)
755: or not l_api_updating)
756: and p_defined_balance_id is not null then
757: --
758: -- check if value of lookup falls within lookup type.

Line 925: and nvl(p_ttl_fnctn_cd,hr_api.g_varchar2)

921: p_object_version_number => p_object_version_number);
922: --
923: hr_utility.set_location('p_ttl_fnctn_cd:'||p_ttl_fnctn_cd, 15);
924: if (l_api_updating
925: and nvl(p_ttl_fnctn_cd,hr_api.g_varchar2)
926: <> nvl(ben_xel_shd.g_old_rec.ttl_fnctn_cd,hr_api.g_varchar2)
927: or not l_api_updating) then
928: --
929: if p_ttl_fnctn_cd = 'CNT' then

Line 926: <> nvl(ben_xel_shd.g_old_rec.ttl_fnctn_cd,hr_api.g_varchar2)

922: --
923: hr_utility.set_location('p_ttl_fnctn_cd:'||p_ttl_fnctn_cd, 15);
924: if (l_api_updating
925: and nvl(p_ttl_fnctn_cd,hr_api.g_varchar2)
926: <> nvl(ben_xel_shd.g_old_rec.ttl_fnctn_cd,hr_api.g_varchar2)
927: or not l_api_updating) then
928: --
929: if p_ttl_fnctn_cd = 'CNT' then
930: if p_ttl_sum_ext_data_elmt_id is not null then

Line 974: and nvl(p_ttl_sum_ext_data_elmt_id,hr_api.g_number)

970: end if;
971: end if;
972: --
973: if (l_api_updating
974: and nvl(p_ttl_sum_ext_data_elmt_id,hr_api.g_number)
975: <> nvl(ben_xel_shd.g_old_rec.ttl_sum_ext_data_elmt_id,hr_api.g_number)
976: or not l_api_updating) then
977: if p_ttl_sum_ext_data_elmt_id is not null and p_ttl_fnctn_cd <> 'SUM' then
978: fnd_message.set_name('BEN','BEN_92200_CHK_SUM_DATA_ELMT');

Line 975: <> nvl(ben_xel_shd.g_old_rec.ttl_sum_ext_data_elmt_id,hr_api.g_number)

971: end if;
972: --
973: if (l_api_updating
974: and nvl(p_ttl_sum_ext_data_elmt_id,hr_api.g_number)
975: <> nvl(ben_xel_shd.g_old_rec.ttl_sum_ext_data_elmt_id,hr_api.g_number)
976: or not l_api_updating) then
977: if p_ttl_sum_ext_data_elmt_id is not null and p_ttl_fnctn_cd <> 'SUM' then
978: fnd_message.set_name('BEN','BEN_92200_CHK_SUM_DATA_ELMT');
979: fnd_message.raise_error;

Line 989: and nvl(p_ttl_cond_ext_data_elmt_id,hr_api.g_number)

985: end if;
986: hr_utility.set_location('p_ttl_fnctn_cd:'||p_ttl_fnctn_cd, 15);
987: hr_utility.set_location('p_ttl_cond_ext_data_elmt_id:'||p_ttl_cond_ext_data_elmt_id, 15);
988: if (l_api_updating
989: and nvl(p_ttl_cond_ext_data_elmt_id,hr_api.g_number)
990: <> nvl(ben_xel_shd.g_old_rec.ttl_cond_ext_data_elmt_id,hr_api.g_number)
991: or not l_api_updating) then
992: --
993: if p_ttl_cond_ext_data_elmt_id is not null then

Line 990: <> nvl(ben_xel_shd.g_old_rec.ttl_cond_ext_data_elmt_id,hr_api.g_number)

986: hr_utility.set_location('p_ttl_fnctn_cd:'||p_ttl_fnctn_cd, 15);
987: hr_utility.set_location('p_ttl_cond_ext_data_elmt_id:'||p_ttl_cond_ext_data_elmt_id, 15);
988: if (l_api_updating
989: and nvl(p_ttl_cond_ext_data_elmt_id,hr_api.g_number)
990: <> nvl(ben_xel_shd.g_old_rec.ttl_cond_ext_data_elmt_id,hr_api.g_number)
991: or not l_api_updating) then
992: --
993: if p_ttl_cond_ext_data_elmt_id is not null then
994: if p_ttl_fnctn_cd is null then

Line 1076: l_legislation_code := hr_api.return_legislation_code (

1072: --
1073: -- Get the legislation code for this business group
1074:
1075: IF p_rec.business_group_id IS NOT NULL THEN
1076: l_legislation_code := hr_api.return_legislation_code (
1077: p_business_group_id=> p_rec.business_group_id
1078: );
1079: ELSE
1080: l_legislation_code := p_rec.legislation_code;

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

1084: ,p_rec.business_group_id
1085: ,l_legislation_code);
1086: -- ,p_rec.legislation_code);
1087: IF hr_startup_data_api_support.g_startup_mode NOT IN ('GENERIC','STARTUP') THEN
1088: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate bus_grp
1089: END IF;
1090: --
1091: chk_ext_data_elmt_id
1092: (p_ext_data_elmt_id => p_rec.ext_data_elmt_id,

Line 1185: l_legislation_code := hr_api.return_legislation_code (

1181: --
1182: -- Get the legislation code for this business group
1183:
1184: IF p_rec.business_group_id IS NOT NULL THEN
1185: l_legislation_code := hr_api.return_legislation_code (
1186: p_business_group_id=> p_rec.business_group_id
1187: );
1188: ELSE
1189: l_legislation_code := p_rec.legislation_code;

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

1193: ,p_rec.business_group_id
1194: ,l_legislation_code);
1195: -- ,p_rec.legislation_code);
1196: IF hr_startup_data_api_support.g_startup_mode NOT IN ('GENERIC','STARTUP') THEN
1197: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate bus_grp
1198: END IF;
1199: --
1200: chk_ext_data_elmt_id
1201: (p_ext_data_elmt_id => p_rec.ext_data_elmt_id,

Line 1295: l_legislation_code := hr_api.return_legislation_code (

1291: --
1292: -- Get the legislation code for this business group
1293:
1294: IF ben_xel_shd.g_old_rec.business_group_id IS NOT NULL THEN
1295: l_legislation_code := hr_api.return_legislation_code (
1296: p_business_group_id=> ben_xel_shd.g_old_rec.business_group_id
1297: );
1298: ELSE
1299: l_legislation_code := ben_xel_shd.g_old_rec.legislation_code;

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

1336: hr_utility.set_location('Entering:'|| l_proc, 10);
1337: --
1338: -- Ensure that all the mandatory parameter are not null
1339: --
1340: hr_api.mandatory_arg_error(p_api_name => l_proc,
1341: p_argument => 'ext_data_elmt_id',
1342: p_argument_value => p_ext_data_elmt_id);
1343: --
1344: open csr_leg_code;