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

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

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

Line 140: and nvl(p_dpnt_cvg_elig_det_rl,hr_api.g_number)

136: p_effective_date => p_effective_date,
137: p_object_version_number => p_object_version_number);
138: --
139: if (l_api_updating
140: and nvl(p_dpnt_cvg_elig_det_rl,hr_api.g_number)
141: <> ben_dce_shd.g_old_rec.dpnt_cvg_elig_det_rl
142: or not l_api_updating)
143: and p_dpnt_cvg_elig_det_rl is not null then
144: --

Line 219: <> nvl(ben_dce_shd.g_old_rec.dpnt_cvg_eligy_prfl_stat_cd,hr_api.g_varchar2)

215: p_object_version_number => p_object_version_number);
216: --
217: if (l_api_updating
218: and p_dpnt_cvg_eligy_prfl_stat_cd
219: <> nvl(ben_dce_shd.g_old_rec.dpnt_cvg_eligy_prfl_stat_cd,hr_api.g_varchar2)
220: or not l_api_updating)
221: and p_dpnt_cvg_eligy_prfl_stat_cd is not null then
222: --
223: -- check if value of lookup falls within lookup type.

Line 225: if hr_api.not_exists_in_hr_lookups

221: and p_dpnt_cvg_eligy_prfl_stat_cd is not null then
222: --
223: -- check if value of lookup falls within lookup type.
224: --
225: if hr_api.not_exists_in_hr_lookups
226: (p_lookup_type => 'BEN_STAT',
227: p_lookup_code => p_dpnt_cvg_eligy_prfl_stat_cd,
228: p_effective_date => p_effective_date) then
229: --

Line 289: and dpnt_cvg_eligy_prfl_id <> nvl(p_dpnt_cvg_eligy_prfl_id, hr_api.g_number)

285: cursor csr_name is
286: select null
287: from BEN_DPNT_CVG_ELIGY_PRFL_F
288: where name = p_name
289: and dpnt_cvg_eligy_prfl_id <> nvl(p_dpnt_cvg_eligy_prfl_id, hr_api.g_number)
290: and business_group_id + 0 = p_business_group_id
291: and p_validate_start_date <= effective_end_date
292: and p_validate_end_date >= effective_start_date;
293: --

Line 380: if hr_api.not_exists_in_hr_lookups

376: --
377: hr_utility.set_location('Entering:'||l_proc, 5);
378: --
379: --
380: if hr_api.not_exists_in_hr_lookups
381: (p_lookup_type => 'YES_NO',
382: p_lookup_code =>p_dpnt_rlshp_flag,
383: p_effective_date => p_effective_date) then
384: --

Line 395: if hr_api.not_exists_in_hr_lookups

391: --
392: end if;
393: --
394:
395: if hr_api.not_exists_in_hr_lookups
396: (p_lookup_type => 'YES_NO',
397: p_lookup_code =>p_dpnt_age_flag,
398: p_effective_date => p_effective_date) then
399: --

Line 408: if hr_api.not_exists_in_hr_lookups

404: fnd_message.set_token('FIELD','dpnt_age_flag ');
405: fnd_message.raise_error;
406: --
407: end if;
408: if hr_api.not_exists_in_hr_lookups
409: (p_lookup_type => 'YES_NO',
410: p_lookup_code =>p_dpnt_stud_flag,
411: p_effective_date => p_effective_date) then
412: --

Line 421: if hr_api.not_exists_in_hr_lookups

417: fnd_message.set_token('FIELD','dpnt_stud_flag ');
418: fnd_message.raise_error;
419: --
420: end if;
421: if hr_api.not_exists_in_hr_lookups
422: (p_lookup_type => 'YES_NO',
423: p_lookup_code =>p_dpnt_dsbld_flag,
424: p_effective_date => p_effective_date) then
425: --

Line 434: if hr_api.not_exists_in_hr_lookups

430: fnd_message.set_token('FIELD','dpnt_dsbld_flag ');
431: fnd_message.raise_error;
432: --
433: end if;
434: if hr_api.not_exists_in_hr_lookups
435: (p_lookup_type => 'YES_NO',
436: p_lookup_code =>p_dpnt_mrtl_flag,
437: p_effective_date => p_effective_date) then
438: --

Line 447: if hr_api.not_exists_in_hr_lookups

443: fnd_message.set_token('FIELD','dpnt_mrtl_flag ');
444: fnd_message.raise_error;
445: --
446: end if;
447: if hr_api.not_exists_in_hr_lookups
448: (p_lookup_type => 'YES_NO',
449: p_lookup_code =>p_dpnt_mltry_flag,
450: p_effective_date => p_effective_date) then
451: --

Line 460: if hr_api.not_exists_in_hr_lookups

456: fnd_message.set_token('FIELD','dpnt_mltry_flag ');
457: fnd_message.raise_error;
458: --
459: end if;
460: if hr_api.not_exists_in_hr_lookups
461: (p_lookup_type => 'YES_NO',
462: p_lookup_code =>p_dpnt_pstl_flag,
463: p_effective_date => p_effective_date) then
464: --

Line 473: if hr_api.not_exists_in_hr_lookups

469: fnd_message.set_token('FIELD','dpnt_pstl_flag ');
470: fnd_message.raise_error;
471: --
472: end if;
473: if hr_api.not_exists_in_hr_lookups
474: (p_lookup_type => 'YES_NO',
475: p_lookup_code =>p_dpnt_cvrd_in_anthr_pl_flag,
476: p_effective_date => p_effective_date) then
477: --

Line 486: if hr_api.not_exists_in_hr_lookups

482: fnd_message.set_token('FIELD','dpnt_cvrd_in_anthr_pl_flag ');
483: fnd_message.raise_error;
484: --
485: end if;
486: if hr_api.not_exists_in_hr_lookups
487: (p_lookup_type => 'YES_NO',
488: p_lookup_code =>p_dpnt_dsgnt_crntly_enrld_flag,
489: p_effective_date => p_effective_date) then
490: --

Line 531: (p_regn_id in number default hr_api.g_number,

527: --
528: -- {End Of Comments}
529: -- ----------------------------------------------------------------------------
530: Procedure dt_update_validate
531: (p_regn_id in number default hr_api.g_number,
532: p_datetrack_mode in varchar2,
533: p_validation_start_date in date,
534: p_validation_end_date in date) Is
535: --

Line 545: hr_api.mandatory_arg_error

541: hr_utility.set_location('Entering:'||l_proc, 5);
542: --
543: -- Ensure that the p_datetrack_mode argument is not null
544: --
545: hr_api.mandatory_arg_error
546: (p_api_name => l_proc,
547: p_argument => 'datetrack_mode',
548: p_argument_value => p_datetrack_mode);
549: --

Line 557: hr_api.mandatory_arg_error

553: --
554: --
555: -- Ensure the arguments are not null
556: --
557: hr_api.mandatory_arg_error
558: (p_api_name => l_proc,
559: p_argument => 'validation_start_date',
560: p_argument_value => p_validation_start_date);
561: --

Line 562: hr_api.mandatory_arg_error

558: (p_api_name => l_proc,
559: p_argument => 'validation_start_date',
560: p_argument_value => p_validation_start_date);
561: --
562: hr_api.mandatory_arg_error
563: (p_api_name => l_proc,
564: p_argument => 'validation_end_date',
565: p_argument_value => p_validation_end_date);
566: --

Line 567: If ((nvl(p_regn_id, hr_api.g_number) <> hr_api.g_number) and

563: (p_api_name => l_proc,
564: p_argument => 'validation_end_date',
565: p_argument_value => p_validation_end_date);
566: --
567: If ((nvl(p_regn_id, hr_api.g_number) <> hr_api.g_number) and
568: NOT (dt_api.check_min_max_dates
569: (p_base_table_name => 'ben_regn_f',
570: p_base_key_column => 'regn_id',
571: p_base_key_value => p_regn_id,

Line 650: hr_api.mandatory_arg_error

646: hr_utility.set_location('Entering:'||l_proc, 5);
647: --
648: -- Ensure that the p_datetrack_mode argument is not null
649: --
650: hr_api.mandatory_arg_error
651: (p_api_name => l_proc,
652: p_argument => 'datetrack_mode',
653: p_argument_value => p_datetrack_mode);
654: --

Line 664: hr_api.mandatory_arg_error

660: --
661: --
662: -- Ensure the arguments are not null
663: --
664: hr_api.mandatory_arg_error
665: (p_api_name => l_proc,
666: p_argument => 'validation_start_date',
667: p_argument_value => p_validation_start_date);
668: --

Line 669: hr_api.mandatory_arg_error

665: (p_api_name => l_proc,
666: p_argument => 'validation_start_date',
667: p_argument_value => p_validation_start_date);
668: --
669: hr_api.mandatory_arg_error
670: (p_api_name => l_proc,
671: p_argument => 'validation_end_date',
672: p_argument_value => p_validation_end_date);
673: --

Line 674: hr_api.mandatory_arg_error

670: (p_api_name => l_proc,
671: p_argument => 'validation_end_date',
672: p_argument_value => p_validation_end_date);
673: --
674: hr_api.mandatory_arg_error
675: (p_api_name => l_proc,
676: p_argument => 'dpnt_cvg_eligy_prfl_id',
677: p_argument_value => p_dpnt_cvg_eligy_prfl_id);
678: --

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

802: --
803: -- Call all supporting business operations
804: --
805: --
806: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
807: --
808: chk_dpnt_cvg_eligy_prfl_id
809: (p_dpnt_cvg_eligy_prfl_id => p_rec.dpnt_cvg_eligy_prfl_id,
810: p_effective_date => p_effective_date,

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

865: --
866: -- Call all supporting business operations
867: --
868: --
869: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
870: --
871: chk_dpnt_cvg_eligy_prfl_id
872: (p_dpnt_cvg_eligy_prfl_id => p_rec.dpnt_cvg_eligy_prfl_id,
873: p_effective_date => p_effective_date,

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

972: hr_utility.set_location('Entering:'|| l_proc, 10);
973: --
974: -- Ensure that all the mandatory parameter are not null
975: --
976: hr_api.mandatory_arg_error(p_api_name => l_proc,
977: p_argument => 'dpnt_cvg_eligy_prfl_id',
978: p_argument_value => p_dpnt_cvg_eligy_prfl_id);
979: --
980: open csr_leg_code;