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

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

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

Line 124: <> nvl(ben_bpl_shd.g_old_rec.prtt_ro_of_unusd_amt_flag,hr_api.g_varchar2)

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

Line 130: if hr_api.not_exists_in_hr_lookups

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

Line 198: <> nvl(ben_bpl_shd.g_old_rec.acty_ref_perd_cd,hr_api.g_varchar2)

194: p_object_version_number => p_object_version_number);
195: --
196: if (l_api_updating
197: and p_acty_ref_perd_cd
198: <> nvl(ben_bpl_shd.g_old_rec.acty_ref_perd_cd,hr_api.g_varchar2)
199: or not l_api_updating) then
200: --
201: -- check if value of lookup falls within lookup type.
202: --

Line 204: if hr_api.not_exists_in_hr_lookups

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

Line 218: if hr_api.not_exists_in_hr_lookups

214: fnd_message.set_token('TYPE','BEN_ACTY_REF_PERD');
215: fnd_message.raise_error;
216: --
217: end if;
218: if hr_api.not_exists_in_hr_lookups
219: (p_lookup_type => 'BEN_ACTY_REF_PERD',
220: p_lookup_code => p_cmcd_ref_perd_cd,
221: p_effective_date => p_effective_date) then
222: --

Line 269: (p_acty_base_rt_id in number default hr_api.g_number,

265: --
266: -- {End Of Comments}
267: -- ----------------------------------------------------------------------------
268: Procedure dt_update_validate
269: (p_acty_base_rt_id in number default hr_api.g_number,
270: p_per_in_ler_id in number default hr_api.g_number,
271: p_bnft_prvdr_pool_id in number default hr_api.g_number,
272: p_prtt_enrt_rslt_id in number default hr_api.g_number,
273: p_datetrack_mode in varchar2,

Line 270: p_per_in_ler_id in number default hr_api.g_number,

266: -- {End Of Comments}
267: -- ----------------------------------------------------------------------------
268: Procedure dt_update_validate
269: (p_acty_base_rt_id in number default hr_api.g_number,
270: p_per_in_ler_id in number default hr_api.g_number,
271: p_bnft_prvdr_pool_id in number default hr_api.g_number,
272: p_prtt_enrt_rslt_id in number default hr_api.g_number,
273: p_datetrack_mode in varchar2,
274: p_validation_start_date in date,

Line 271: p_bnft_prvdr_pool_id in number default hr_api.g_number,

267: -- ----------------------------------------------------------------------------
268: Procedure dt_update_validate
269: (p_acty_base_rt_id in number default hr_api.g_number,
270: p_per_in_ler_id in number default hr_api.g_number,
271: p_bnft_prvdr_pool_id in number default hr_api.g_number,
272: p_prtt_enrt_rslt_id in number default hr_api.g_number,
273: p_datetrack_mode in varchar2,
274: p_validation_start_date in date,
275: p_validation_end_date in date) Is

Line 272: p_prtt_enrt_rslt_id in number default hr_api.g_number,

268: Procedure dt_update_validate
269: (p_acty_base_rt_id in number default hr_api.g_number,
270: p_per_in_ler_id in number default hr_api.g_number,
271: p_bnft_prvdr_pool_id in number default hr_api.g_number,
272: p_prtt_enrt_rslt_id in number default hr_api.g_number,
273: p_datetrack_mode in varchar2,
274: p_validation_start_date in date,
275: p_validation_end_date in date) Is
276: --

Line 286: hr_api.mandatory_arg_error

282: hr_utility.set_location('Entering:'||l_proc, 5);
283: --
284: -- Ensure that the p_datetrack_mode argument is not null
285: --
286: hr_api.mandatory_arg_error
287: (p_api_name => l_proc,
288: p_argument => 'datetrack_mode',
289: p_argument_value => p_datetrack_mode);
290: --

Line 298: hr_api.mandatory_arg_error

294: --
295: --
296: -- Ensure the arguments are not null
297: --
298: hr_api.mandatory_arg_error
299: (p_api_name => l_proc,
300: p_argument => 'validation_start_date',
301: p_argument_value => p_validation_start_date);
302: --

Line 303: hr_api.mandatory_arg_error

299: (p_api_name => l_proc,
300: p_argument => 'validation_start_date',
301: p_argument_value => p_validation_start_date);
302: --
303: hr_api.mandatory_arg_error
304: (p_api_name => l_proc,
305: p_argument => 'validation_end_date',
306: p_argument_value => p_validation_end_date);
307: --

Line 308: If ((nvl(p_acty_base_rt_id, hr_api.g_number) <> hr_api.g_number) and

304: (p_api_name => l_proc,
305: p_argument => 'validation_end_date',
306: p_argument_value => p_validation_end_date);
307: --
308: If ((nvl(p_acty_base_rt_id, hr_api.g_number) <> hr_api.g_number) and
309: NOT (dt_api.check_min_max_dates
310: (p_base_table_name => 'ben_acty_base_rt_f',
311: p_base_key_column => 'acty_base_rt_id',
312: p_base_key_value => p_acty_base_rt_id,

Line 318: If ((nvl(p_bnft_prvdr_pool_id, hr_api.g_number) <> hr_api.g_number) and

314: p_to_date => p_validation_end_date))) Then
315: l_table_name := 'ben_acty_base_rt_f';
316: Raise l_integrity_error;
317: End If;
318: If ((nvl(p_bnft_prvdr_pool_id, hr_api.g_number) <> hr_api.g_number) and
319: NOT (dt_api.check_min_max_dates
320: (p_base_table_name => 'ben_bnft_prvdr_pool_f',
321: p_base_key_column => 'bnft_prvdr_pool_id',
322: p_base_key_value => p_bnft_prvdr_pool_id,

Line 328: If ((nvl(p_prtt_enrt_rslt_id, hr_api.g_number) <> hr_api.g_number) and

324: p_to_date => p_validation_end_date))) Then
325: l_table_name := 'ben_bnft_prvdr_pool_f';
326: Raise l_integrity_error;
327: End If;
328: If ((nvl(p_prtt_enrt_rslt_id, hr_api.g_number) <> hr_api.g_number) and
329: NOT (dt_api.check_min_max_dates
330: (p_base_table_name => 'ben_prtt_enrt_rslt_f',
331: p_base_key_column => 'prtt_enrt_rslt_id',
332: p_base_key_value => p_prtt_enrt_rslt_id,

Line 411: hr_api.mandatory_arg_error

407: hr_utility.set_location('Entering:'||l_proc, 5);
408: --
409: -- Ensure that the p_datetrack_mode argument is not null
410: --
411: hr_api.mandatory_arg_error
412: (p_api_name => l_proc,
413: p_argument => 'datetrack_mode',
414: p_argument_value => p_datetrack_mode);
415: --

Line 425: hr_api.mandatory_arg_error

421: --
422: --
423: -- Ensure the arguments are not null
424: --
425: hr_api.mandatory_arg_error
426: (p_api_name => l_proc,
427: p_argument => 'validation_start_date',
428: p_argument_value => p_validation_start_date);
429: --

Line 430: hr_api.mandatory_arg_error

426: (p_api_name => l_proc,
427: p_argument => 'validation_start_date',
428: p_argument_value => p_validation_start_date);
429: --
430: hr_api.mandatory_arg_error
431: (p_api_name => l_proc,
432: p_argument => 'validation_end_date',
433: p_argument_value => p_validation_end_date);
434: --

Line 435: hr_api.mandatory_arg_error

431: (p_api_name => l_proc,
432: p_argument => 'validation_end_date',
433: p_argument_value => p_validation_end_date);
434: --
435: hr_api.mandatory_arg_error
436: (p_api_name => l_proc,
437: p_argument => 'bnft_prvdd_ldgr_id',
438: p_argument_value => p_bnft_prvdd_ldgr_id);
439: --

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

478: --
479: -- Call all supporting business operations
480: --
481: --
482: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
483:
484: chk_bnft_prvdd_ldgr_id
485: (p_bnft_prvdd_ldgr_id => p_rec.bnft_prvdd_ldgr_id,
486: p_effective_date => p_effective_date,

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

518: Begin
519: hr_utility.set_location('Entering:'||l_proc, 5);
520:
521: -- Call all supporting business operations
522: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
523:
524: chk_bnft_prvdd_ldgr_id
525: (p_bnft_prvdd_ldgr_id => p_rec.bnft_prvdd_ldgr_id,
526: p_effective_date => p_effective_date,

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

606: hr_utility.set_location('Entering:'|| l_proc, 10);
607: --
608: -- Ensure that all the mandatory parameter are not null
609: --
610: hr_api.mandatory_arg_error(p_api_name => l_proc,
611: p_argument => 'bnft_prvdd_ldgr_id',
612: p_argument_value => p_bnft_prvdd_ldgr_id);
613: --
614: open csr_leg_code;