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

Line 54: and nvl(p_pl_typ_id,hr_api.g_number)

50: p_pl_typ_id => p_pl_typ_id,
51: p_object_version_number => p_object_version_number);
52: --
53: if (l_api_updating
54: and nvl(p_pl_typ_id,hr_api.g_number)
55: <> ben_ptp_shd.g_old_rec.pl_typ_id) then
56: --
57: -- raise error as PK has changed
58: --

Line 124: <> nvl(ben_ptp_shd.g_old_rec.no_mn_enrl_num_dfnd_flag,hr_api.g_varchar2)

120: p_object_version_number => p_object_version_number);
121: --
122: if (l_api_updating
123: and p_no_mn_enrl_num_dfnd_flag
124: <> nvl(ben_ptp_shd.g_old_rec.no_mn_enrl_num_dfnd_flag,hr_api.g_varchar2)
125: or not l_api_updating)
126: and p_no_mn_enrl_num_dfnd_flag is not null then
127: --
128: -- check if value of lookup falls within lookup type.

Line 130: if hr_api.not_exists_in_hr_lookups

126: and p_no_mn_enrl_num_dfnd_flag is not null then
127: --
128: -- check if value of lookup falls within lookup type.
129: --
130: if hr_api.not_exists_in_hr_lookups
131: (p_lookup_type => 'YES_NO',
132: p_lookup_code => p_no_mn_enrl_num_dfnd_flag,
133: p_effective_date => p_effective_date) then
134: --

Line 193: <> nvl(ben_ptp_shd.g_old_rec.no_mx_enrl_num_dfnd_flag,hr_api.g_varchar2)

189: p_object_version_number => p_object_version_number);
190: --
191: if (l_api_updating
192: and p_no_mx_enrl_num_dfnd_flag
193: <> nvl(ben_ptp_shd.g_old_rec.no_mx_enrl_num_dfnd_flag,hr_api.g_varchar2)
194: or not l_api_updating)
195: and p_no_mx_enrl_num_dfnd_flag is not null then
196: --
197: -- check if value of lookup falls within lookup type.

Line 199: if hr_api.not_exists_in_hr_lookups

195: and p_no_mx_enrl_num_dfnd_flag is not null then
196: --
197: -- check if value of lookup falls within lookup type.
198: --
199: if hr_api.not_exists_in_hr_lookups
200: (p_lookup_type => 'YES_NO',
201: p_lookup_code => p_no_mx_enrl_num_dfnd_flag,
202: p_effective_date => p_effective_date) then
203: --

Line 262: <> nvl(ben_ptp_shd.g_old_rec.opt_typ_cd,hr_api.g_varchar2)

258: p_object_version_number => p_object_version_number);
259: --
260: if (l_api_updating
261: and p_opt_typ_cd
262: <> nvl(ben_ptp_shd.g_old_rec.opt_typ_cd,hr_api.g_varchar2)
263: or not l_api_updating) then
264: --
265: -- check if value of lookup falls within lookup type.
266: --

Line 268: if hr_api.not_exists_in_hr_lookups

264: --
265: -- check if value of lookup falls within lookup type.
266: --
267: --
268: if hr_api.not_exists_in_hr_lookups
269: (p_lookup_type => 'BEN_OPT_TYP',
270: p_lookup_code => p_opt_typ_cd,
271: p_effective_date => p_effective_date) then
272: --

Line 355: and p_opt_typ_cd <> nvl(ben_ptp_shd.g_old_rec.opt_typ_cd,hr_api.g_varchar2)

351: p_effective_date => p_effective_date,
352: p_object_version_number => p_object_version_number);
353: --
354: if (l_api_updating
355: and p_opt_typ_cd <> nvl(ben_ptp_shd.g_old_rec.opt_typ_cd,hr_api.g_varchar2)
356: and nvl(ben_ptp_shd.g_old_rec.opt_typ_cd,hr_api.g_varchar2) = 'COMP')
357: then
358: --
359: --

Line 356: and nvl(ben_ptp_shd.g_old_rec.opt_typ_cd,hr_api.g_varchar2) = 'COMP')

352: p_object_version_number => p_object_version_number);
353: --
354: if (l_api_updating
355: and p_opt_typ_cd <> nvl(ben_ptp_shd.g_old_rec.opt_typ_cd,hr_api.g_varchar2)
356: and nvl(ben_ptp_shd.g_old_rec.opt_typ_cd,hr_api.g_varchar2) = 'COMP')
357: then
358: --
359: --
360: open c1;

Line 430: <> nvl(ben_ptp_shd.g_old_rec.opt_dsply_fmt_cd,hr_api.g_varchar2)

426: p_object_version_number => p_object_version_number);
427: --
428: if (l_api_updating
429: and p_opt_dsply_fmt_cd
430: <> nvl(ben_ptp_shd.g_old_rec.opt_dsply_fmt_cd,hr_api.g_varchar2)
431: or not l_api_updating)
432: and p_opt_dsply_fmt_cd is not null then
433: --
434: -- check if value of lookup falls within lookup type.

Line 437: if hr_api.not_exists_in_hr_lookups

433: --
434: -- check if value of lookup falls within lookup type.
435: --
436: --
437: if hr_api.not_exists_in_hr_lookups
438: (p_lookup_type => 'BEN_OPT_DSPLY_FMT',
439: p_lookup_code => p_opt_dsply_fmt_cd,
440: p_effective_date => p_effective_date) then
441: --

Line 523: <> nvl(ben_ptp_shd.g_old_rec.comp_typ_cd,hr_api.g_varchar2)

519: p_object_version_number => p_object_version_number);
520: --
521: if (l_api_updating
522: and p_comp_typ_cd
523: <> nvl(ben_ptp_shd.g_old_rec.comp_typ_cd,hr_api.g_varchar2)
524: or not l_api_updating)
525: and p_comp_typ_cd is not null then
526: --
527: -- check if value of lookup falls within lookup type.

Line 530: if hr_api.not_exists_in_hr_lookups

526: --
527: -- check if value of lookup falls within lookup type.
528: --
529: --
530: if hr_api.not_exists_in_hr_lookups
531: (p_lookup_type => 'BEN_COMP_TYP',
532: p_lookup_code => p_comp_typ_cd,
533: p_effective_date => p_effective_date) then
534: --

Line 593: <> nvl(ben_ptp_shd.g_old_rec.pl_typ_stat_cd,hr_api.g_varchar2)

589: p_object_version_number => p_object_version_number);
590: --
591: if (l_api_updating
592: and p_pl_typ_stat_cd
593: <> nvl(ben_ptp_shd.g_old_rec.pl_typ_stat_cd,hr_api.g_varchar2)
594: or not l_api_updating)
595: and p_pl_typ_stat_cd is not null then
596: --
597: -- check if value of lookup falls within lookup type.

Line 599: if hr_api.not_exists_in_hr_lookups

595: and p_pl_typ_stat_cd is not null then
596: --
597: -- check if value of lookup falls within lookup type.
598: --
599: if hr_api.not_exists_in_hr_lookups
600: (p_lookup_type => 'BEN_STAT',
601: p_lookup_code => p_pl_typ_stat_cd,
602: p_effective_date => p_effective_date) then
603: --

Line 668: and pl_typ_id <> nvl(p_pl_typ_id, hr_api.g_number)

664: cursor csr_name is
665: select null
666: from BEN_PL_TYP_F
667: where name = p_name
668: and pl_typ_id <> nvl(p_pl_typ_id, hr_api.g_number)
669: and business_group_id + 0 = p_business_group_id
670: and p_validation_start_date <= effective_end_date
671: and p_validation_end_date >= effective_start_date;
672: --

Line 779: if nvl( p_no_mx_enrl_num_dfnd_flag, hr_api.g_varchar2) <> 'N'

775: --
776: -- If No Maximum enrolled allowed flag set to "on" (Y),
777: -- then maximum enroll allowed number must be 0.
778: --
779: if nvl( p_no_mx_enrl_num_dfnd_flag, hr_api.g_varchar2) <> 'N'
780: and (nvl(p_mx_enrl_alwd_num, 0) <> 0) then
781: fnd_message.set_name('BEN','BEN_91056_MIN_VAL_NOT_NULL');
782: fnd_message.raise_error;
783: end if;

Line 785: if nvl( p_no_mn_enrl_num_dfnd_flag, hr_api.g_varchar2) <> 'N'

781: fnd_message.set_name('BEN','BEN_91056_MIN_VAL_NOT_NULL');
782: fnd_message.raise_error;
783: end if;
784: --
785: if nvl( p_no_mn_enrl_num_dfnd_flag, hr_api.g_varchar2) <> 'N'
786: and (nvl(p_mn_enrl_rqd_num, 0) <> 0) then
787: fnd_message.set_name('BEN','BEN_91054_MIN_VAL_NOT_NULL');
788: fnd_message.raise_error;
789: end if;

Line 844: and pl_typ_id <> nvl(p_pl_typ_id, hr_api.g_number)

840: cursor c_opt_typ_cd is
841: select 1
842: from ben_pl_typ_f
843: where opt_typ_cd = 'GSP'
844: and pl_typ_id <> nvl(p_pl_typ_id, hr_api.g_number)
845: and p_effective_date between effective_start_date and effective_end_date
846: and business_group_id = p_business_group_id
847: ;
848:

Line 936: hr_api.mandatory_arg_error

932: hr_utility.set_location('Entering:'||l_proc, 5);
933: --
934: -- Ensure that the p_datetrack_mode argument is not null
935: --
936: hr_api.mandatory_arg_error
937: (p_api_name => l_proc,
938: p_argument => 'datetrack_mode',
939: p_argument_value => p_datetrack_mode);
940: --

Line 948: hr_api.mandatory_arg_error

944: --
945: --
946: -- Ensure the arguments are not null
947: --
948: hr_api.mandatory_arg_error
949: (p_api_name => l_proc,
950: p_argument => 'validation_start_date',
951: p_argument_value => p_validation_start_date);
952: --

Line 953: hr_api.mandatory_arg_error

949: (p_api_name => l_proc,
950: p_argument => 'validation_start_date',
951: p_argument_value => p_validation_start_date);
952: --
953: hr_api.mandatory_arg_error
954: (p_api_name => l_proc,
955: p_argument => 'validation_end_date',
956: p_argument_value => p_validation_end_date);
957: --

Line 1033: hr_api.mandatory_arg_error

1029: hr_utility.set_location('Entering:'||l_proc, 5);
1030: --
1031: -- Ensure that the p_datetrack_mode argument is not null
1032: --
1033: hr_api.mandatory_arg_error
1034: (p_api_name => l_proc,
1035: p_argument => 'datetrack_mode',
1036: p_argument_value => p_datetrack_mode);
1037: --

Line 1047: hr_api.mandatory_arg_error

1043: --
1044: --
1045: -- Ensure the arguments are not null
1046: --
1047: hr_api.mandatory_arg_error
1048: (p_api_name => l_proc,
1049: p_argument => 'validation_start_date',
1050: p_argument_value => p_validation_start_date);
1051: --

Line 1052: hr_api.mandatory_arg_error

1048: (p_api_name => l_proc,
1049: p_argument => 'validation_start_date',
1050: p_argument_value => p_validation_start_date);
1051: --
1052: hr_api.mandatory_arg_error
1053: (p_api_name => l_proc,
1054: p_argument => 'validation_end_date',
1055: p_argument_value => p_validation_end_date);
1056: --

Line 1057: hr_api.mandatory_arg_error

1053: (p_api_name => l_proc,
1054: p_argument => 'validation_end_date',
1055: p_argument_value => p_validation_end_date);
1056: --
1057: hr_api.mandatory_arg_error
1058: (p_api_name => l_proc,
1059: p_argument => 'pl_typ_id',
1060: p_argument_value => p_pl_typ_id);
1061: --

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

1129: -- Call all supporting business operations
1130: --
1131: --
1132: if p_rec.business_group_id is not null and p_rec.legislation_code is null then
1133: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1134: end if;
1135: --
1136: chk_pl_typ_id
1137: (p_pl_typ_id => p_rec.pl_typ_id,

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

1221: -- Call all supporting business operations
1222: --
1223: --
1224: if p_rec.business_group_id is not null and p_rec.legislation_code is null then
1225: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1226: end if;
1227: --
1228: chk_pl_typ_id
1229: (p_pl_typ_id => p_rec.pl_typ_id,

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

1368: hr_utility.set_location('Entering:'|| l_proc, 10);
1369: --
1370: -- Ensure that all the mandatory parameter are not null
1371: --
1372: hr_api.mandatory_arg_error(p_api_name => l_proc,
1373: p_argument => 'pl_typ_id',
1374: p_argument_value => p_pl_typ_id);
1375: --
1376: open csr_leg_code;