APPS.BEN_LDC_BUS dependencies on HR_API

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

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

Line 127: and ler_chg_dpnt_cvg_id <> nvl(p_ler_chg_dpnt_cvg_id, hr_api.g_number)

123: cursor chk_unique is
124: select null
125: from ben_ler_chg_dpnt_cvg_f
126: where ler_id = p_ler_id
127: and ler_chg_dpnt_cvg_id <> nvl(p_ler_chg_dpnt_cvg_id, hr_api.g_number)
128: and (ptip_id = p_ptip_id or pgm_id = p_pgm_id or pl_id = p_pl_id)
129: and business_group_id + 0 = p_business_group_id
130: and p_validation_start_date <= effective_end_date
131: and p_validation_end_date >= effective_start_date;

Line 144: <> nvl(ben_ldc_shd.g_old_rec.ler_id,hr_api.g_number)

140: p_object_version_number => p_object_version_number);
141: --
142: if (l_api_updating
143: and p_ler_id
144: <> nvl(ben_ldc_shd.g_old_rec.ler_id,hr_api.g_number)
145: or not l_api_updating) then
146: --
147: -- this value must be unique
148: --

Line 231: and nvl(p_cvg_eff_end_rl,hr_api.g_number)

227: p_effective_date => p_effective_date,
228: p_object_version_number => p_object_version_number);
229: --
230: if (l_api_updating
231: and nvl(p_cvg_eff_end_rl,hr_api.g_number)
232: <> ben_ldc_shd.g_old_rec.cvg_eff_end_rl
233: or not l_api_updating)
234: and p_cvg_eff_end_rl is not null then
235: --

Line 324: and nvl(p_cvg_eff_strt_rl,hr_api.g_number)

320: p_effective_date => p_effective_date,
321: p_object_version_number => p_object_version_number);
322: --
323: if (l_api_updating
324: and nvl(p_cvg_eff_strt_rl,hr_api.g_number)
325: <> ben_ldc_shd.g_old_rec.cvg_eff_strt_rl
326: or not l_api_updating)
327: and p_cvg_eff_strt_rl is not null then
328: --

Line 417: and nvl(p_ler_chg_dpnt_cvg_rl,hr_api.g_number)

413: p_effective_date => p_effective_date,
414: p_object_version_number => p_object_version_number);
415: --
416: if (l_api_updating
417: and nvl(p_ler_chg_dpnt_cvg_rl,hr_api.g_number)
418: <> ben_ldc_shd.g_old_rec.ler_chg_dpnt_cvg_rl
419: or not l_api_updating)
420: and p_ler_chg_dpnt_cvg_rl is not null then
421: --

Line 494: <> nvl(ben_ldc_shd.g_old_rec.cvg_eff_strt_cd,hr_api.g_varchar2)

490: p_object_version_number => p_object_version_number);
491: --
492: if (l_api_updating
493: and p_cvg_eff_strt_cd
494: <> nvl(ben_ldc_shd.g_old_rec.cvg_eff_strt_cd,hr_api.g_varchar2)
495: or not l_api_updating)
496: and p_cvg_eff_strt_cd is not null then
497: --
498: -- check if value of lookup falls within lookup type.

Line 500: if hr_api.not_exists_in_hr_lookups

496: and p_cvg_eff_strt_cd is not null then
497: --
498: -- check if value of lookup falls within lookup type.
499: --
500: if hr_api.not_exists_in_hr_lookups
501: (p_lookup_type => 'BEN_DPNT_CVG_STRT',
502: p_lookup_code => p_cvg_eff_strt_cd,
503: p_effective_date => p_effective_date) then
504: --

Line 565: <> nvl(ben_ldc_shd.g_old_rec.cvg_eff_end_cd,hr_api.g_varchar2)

561: p_object_version_number => p_object_version_number);
562: --
563: if (l_api_updating
564: and p_cvg_eff_end_cd
565: <> nvl(ben_ldc_shd.g_old_rec.cvg_eff_end_cd,hr_api.g_varchar2)
566: or not l_api_updating)
567: and p_cvg_eff_end_cd is not null then
568: --
569: -- check if value of lookup falls within lookup type.

Line 571: if hr_api.not_exists_in_hr_lookups

567: and p_cvg_eff_end_cd is not null then
568: --
569: -- check if value of lookup falls within lookup type.
570: --
571: if hr_api.not_exists_in_hr_lookups
572: (p_lookup_type => 'BEN_DPNT_CVG_END',
573: p_lookup_code => p_cvg_eff_end_cd,
574: p_effective_date => p_effective_date) then
575: --

Line 636: <> nvl(ben_ldc_shd.g_old_rec.add_rmv_cvg_cd,hr_api.g_varchar2)

632: p_object_version_number => p_object_version_number);
633: --
634: if (l_api_updating
635: and p_add_rmv_cvg_cd
636: <> nvl(ben_ldc_shd.g_old_rec.add_rmv_cvg_cd,hr_api.g_varchar2)
637: or not l_api_updating) then
638: --
639: -- check if value of lookup falls within lookup type.
640: --

Line 642: if hr_api.not_exists_in_hr_lookups

638: --
639: -- check if value of lookup falls within lookup type.
640: --
641: --
642: if hr_api.not_exists_in_hr_lookups
643: (p_lookup_type => 'BEN_ADD_RMV',
644: p_lookup_code => p_add_rmv_cvg_cd,
645: p_effective_date => p_effective_date) then
646: --

Line 793: <> nvl(ben_ldc_shd.g_old_rec.ler_chg_dpnt_cvg_cd,hr_api.g_varchar2)

789: p_object_version_number => p_object_version_number);
790: --
791: if (l_api_updating
792: and p_ler_chg_dpnt_cvg_cd
793: <> nvl(ben_ldc_shd.g_old_rec.ler_chg_dpnt_cvg_cd,hr_api.g_varchar2)
794: or not l_api_updating)
795: and p_ler_chg_dpnt_cvg_cd is not null then
796: --
797: -- check if value of lookup falls within lookup type.

Line 799: if hr_api.not_exists_in_hr_lookups

795: and p_ler_chg_dpnt_cvg_cd is not null then
796: --
797: -- check if value of lookup falls within lookup type.
798: --
799: if hr_api.not_exists_in_hr_lookups
800: (p_lookup_type => 'BEN_LER_CHG_DPNT_CVG',
801: p_lookup_code => p_ler_chg_dpnt_cvg_cd,
802: p_effective_date => p_effective_date) then
803: --

Line 886: (nvl(p_cvg_eff_strt_cd,hr_api.g_varchar2)

882: p_object_version_number => p_object_version_number);
883: --
884: if (l_api_updating
885: and
886: (nvl(p_cvg_eff_strt_cd,hr_api.g_varchar2)
887: <> nvl(ben_ldc_shd.g_old_rec.cvg_eff_strt_cd,hr_api.g_varchar2) or
888: nvl(p_cvg_eff_strt_rl,hr_api.g_number)
889: <> nvl(ben_ldc_shd.g_old_rec.cvg_eff_strt_rl,hr_api.g_number))
890: or not l_api_updating) then

Line 887: <> nvl(ben_ldc_shd.g_old_rec.cvg_eff_strt_cd,hr_api.g_varchar2) or

883: --
884: if (l_api_updating
885: and
886: (nvl(p_cvg_eff_strt_cd,hr_api.g_varchar2)
887: <> nvl(ben_ldc_shd.g_old_rec.cvg_eff_strt_cd,hr_api.g_varchar2) or
888: nvl(p_cvg_eff_strt_rl,hr_api.g_number)
889: <> nvl(ben_ldc_shd.g_old_rec.cvg_eff_strt_rl,hr_api.g_number))
890: or not l_api_updating) then
891: --

Line 888: nvl(p_cvg_eff_strt_rl,hr_api.g_number)

884: if (l_api_updating
885: and
886: (nvl(p_cvg_eff_strt_cd,hr_api.g_varchar2)
887: <> nvl(ben_ldc_shd.g_old_rec.cvg_eff_strt_cd,hr_api.g_varchar2) or
888: nvl(p_cvg_eff_strt_rl,hr_api.g_number)
889: <> nvl(ben_ldc_shd.g_old_rec.cvg_eff_strt_rl,hr_api.g_number))
890: or not l_api_updating) then
891: --
892: if (p_cvg_eff_strt_cd = 'RL' and p_cvg_eff_strt_rl is null) then

Line 889: <> nvl(ben_ldc_shd.g_old_rec.cvg_eff_strt_rl,hr_api.g_number))

885: and
886: (nvl(p_cvg_eff_strt_cd,hr_api.g_varchar2)
887: <> nvl(ben_ldc_shd.g_old_rec.cvg_eff_strt_cd,hr_api.g_varchar2) or
888: nvl(p_cvg_eff_strt_rl,hr_api.g_number)
889: <> nvl(ben_ldc_shd.g_old_rec.cvg_eff_strt_rl,hr_api.g_number))
890: or not l_api_updating) then
891: --
892: if (p_cvg_eff_strt_cd = 'RL' and p_cvg_eff_strt_rl is null) then
893: --

Line 900: if nvl(p_cvg_eff_strt_cd,hr_api.g_varchar2) <> 'RL' and p_cvg_eff_strt_rl is not null then

896: -- please word this message like 'If you choose a Coverage Start Code of "Rule",
897: -- you must choose a Coverage Start Rule.'
898: end if;
899: --
900: if nvl(p_cvg_eff_strt_cd,hr_api.g_varchar2) <> 'RL' and p_cvg_eff_strt_rl is not null then
901: --
902: fnd_message.set_name('BEN','BEN_91624_CD_RL_2');
903: fnd_message.raise_error;
904: end if;

Line 961: (nvl(p_cvg_eff_end_cd,hr_api.g_varchar2)

957: p_object_version_number => p_object_version_number);
958: --
959: if (l_api_updating
960: and
961: (nvl(p_cvg_eff_end_cd,hr_api.g_varchar2)
962: <> nvl(ben_ldc_shd.g_old_rec.cvg_eff_end_cd,hr_api.g_varchar2) or
963: nvl(p_cvg_eff_end_rl,hr_api.g_number)
964: <> nvl(ben_ldc_shd.g_old_rec.cvg_eff_end_rl,hr_api.g_number))
965: or not l_api_updating) then

Line 962: <> nvl(ben_ldc_shd.g_old_rec.cvg_eff_end_cd,hr_api.g_varchar2) or

958: --
959: if (l_api_updating
960: and
961: (nvl(p_cvg_eff_end_cd,hr_api.g_varchar2)
962: <> nvl(ben_ldc_shd.g_old_rec.cvg_eff_end_cd,hr_api.g_varchar2) or
963: nvl(p_cvg_eff_end_rl,hr_api.g_number)
964: <> nvl(ben_ldc_shd.g_old_rec.cvg_eff_end_rl,hr_api.g_number))
965: or not l_api_updating) then
966: --

Line 963: nvl(p_cvg_eff_end_rl,hr_api.g_number)

959: if (l_api_updating
960: and
961: (nvl(p_cvg_eff_end_cd,hr_api.g_varchar2)
962: <> nvl(ben_ldc_shd.g_old_rec.cvg_eff_end_cd,hr_api.g_varchar2) or
963: nvl(p_cvg_eff_end_rl,hr_api.g_number)
964: <> nvl(ben_ldc_shd.g_old_rec.cvg_eff_end_rl,hr_api.g_number))
965: or not l_api_updating) then
966: --
967: if (p_cvg_eff_end_cd = 'RL' and p_cvg_eff_end_rl is null) then

Line 964: <> nvl(ben_ldc_shd.g_old_rec.cvg_eff_end_rl,hr_api.g_number))

960: and
961: (nvl(p_cvg_eff_end_cd,hr_api.g_varchar2)
962: <> nvl(ben_ldc_shd.g_old_rec.cvg_eff_end_cd,hr_api.g_varchar2) or
963: nvl(p_cvg_eff_end_rl,hr_api.g_number)
964: <> nvl(ben_ldc_shd.g_old_rec.cvg_eff_end_rl,hr_api.g_number))
965: or not l_api_updating) then
966: --
967: if (p_cvg_eff_end_cd = 'RL' and p_cvg_eff_end_rl is null) then
968: --

Line 975: if nvl(p_cvg_eff_end_cd,hr_api.g_varchar2) <> 'RL' and p_cvg_eff_end_rl is not null then

971: -- please word this message like 'If you choose a Coverage Start Code of "Rule",
972: -- you must choose a Coverage Start Rule.'
973: end if;
974: --
975: if nvl(p_cvg_eff_end_cd,hr_api.g_varchar2) <> 'RL' and p_cvg_eff_end_rl is not null then
976: --
977: fnd_message.set_name('BEN','BEN_91624_CD_RL_2');
978: fnd_message.raise_error;
979: -- please word this message like 'If you choose a Coverage Start Rule,

Line 1038: (nvl(p_ler_chg_dpnt_cvg_cd,hr_api.g_varchar2)

1034: p_object_version_number => p_object_version_number);
1035: --
1036: if (l_api_updating
1037: and
1038: (nvl(p_ler_chg_dpnt_cvg_cd,hr_api.g_varchar2)
1039: <> nvl(ben_ldc_shd.g_old_rec.ler_chg_dpnt_cvg_cd,hr_api.g_varchar2) or
1040: nvl(p_ler_chg_dpnt_cvg_rl,hr_api.g_number)
1041: <> nvl(ben_ldc_shd.g_old_rec.ler_chg_dpnt_cvg_rl,hr_api.g_number))
1042: or not l_api_updating) then

Line 1039: <> nvl(ben_ldc_shd.g_old_rec.ler_chg_dpnt_cvg_cd,hr_api.g_varchar2) or

1035: --
1036: if (l_api_updating
1037: and
1038: (nvl(p_ler_chg_dpnt_cvg_cd,hr_api.g_varchar2)
1039: <> nvl(ben_ldc_shd.g_old_rec.ler_chg_dpnt_cvg_cd,hr_api.g_varchar2) or
1040: nvl(p_ler_chg_dpnt_cvg_rl,hr_api.g_number)
1041: <> nvl(ben_ldc_shd.g_old_rec.ler_chg_dpnt_cvg_rl,hr_api.g_number))
1042: or not l_api_updating) then
1043: --

Line 1040: nvl(p_ler_chg_dpnt_cvg_rl,hr_api.g_number)

1036: if (l_api_updating
1037: and
1038: (nvl(p_ler_chg_dpnt_cvg_cd,hr_api.g_varchar2)
1039: <> nvl(ben_ldc_shd.g_old_rec.ler_chg_dpnt_cvg_cd,hr_api.g_varchar2) or
1040: nvl(p_ler_chg_dpnt_cvg_rl,hr_api.g_number)
1041: <> nvl(ben_ldc_shd.g_old_rec.ler_chg_dpnt_cvg_rl,hr_api.g_number))
1042: or not l_api_updating) then
1043: --
1044: if (p_ler_chg_dpnt_cvg_cd = 'RL' and p_ler_chg_dpnt_cvg_rl is null) then

Line 1041: <> nvl(ben_ldc_shd.g_old_rec.ler_chg_dpnt_cvg_rl,hr_api.g_number))

1037: and
1038: (nvl(p_ler_chg_dpnt_cvg_cd,hr_api.g_varchar2)
1039: <> nvl(ben_ldc_shd.g_old_rec.ler_chg_dpnt_cvg_cd,hr_api.g_varchar2) or
1040: nvl(p_ler_chg_dpnt_cvg_rl,hr_api.g_number)
1041: <> nvl(ben_ldc_shd.g_old_rec.ler_chg_dpnt_cvg_rl,hr_api.g_number))
1042: or not l_api_updating) then
1043: --
1044: if (p_ler_chg_dpnt_cvg_cd = 'RL' and p_ler_chg_dpnt_cvg_rl is null) then
1045: --

Line 1052: if nvl(p_ler_chg_dpnt_cvg_cd,hr_api.g_varchar2) <> 'RL' and p_ler_chg_dpnt_cvg_rl is not null then

1048: -- please word this message like 'If you choose a Coverage Start Code of "Rule",
1049: -- you must choose a Coverage Start Rule.'
1050: end if;
1051: --
1052: if nvl(p_ler_chg_dpnt_cvg_cd,hr_api.g_varchar2) <> 'RL' and p_ler_chg_dpnt_cvg_rl is not null then
1053: --
1054: fnd_message.set_name('BEN','BEN_91624_CD_RL_2');
1055: fnd_message.raise_error;
1056: -- please word this message like 'If you choose a Coverage Start Rule,

Line 1096: (p_ler_chg_dpnt_cvg_rl in number default hr_api.g_number,

1092: --
1093: -- {End Of Comments}
1094: -- ----------------------------------------------------------------------------
1095: Procedure dt_update_validate
1096: (p_ler_chg_dpnt_cvg_rl in number default hr_api.g_number,
1097: p_cvg_eff_strt_rl in number default hr_api.g_number,
1098: p_cvg_eff_end_rl in number default hr_api.g_number,
1099: p_ptip_id in number default hr_api.g_number,
1100: p_ler_id in number default hr_api.g_number,

Line 1097: p_cvg_eff_strt_rl in number default hr_api.g_number,

1093: -- {End Of Comments}
1094: -- ----------------------------------------------------------------------------
1095: Procedure dt_update_validate
1096: (p_ler_chg_dpnt_cvg_rl in number default hr_api.g_number,
1097: p_cvg_eff_strt_rl in number default hr_api.g_number,
1098: p_cvg_eff_end_rl in number default hr_api.g_number,
1099: p_ptip_id in number default hr_api.g_number,
1100: p_ler_id in number default hr_api.g_number,
1101: p_pl_id in number default hr_api.g_number,

Line 1098: p_cvg_eff_end_rl in number default hr_api.g_number,

1094: -- ----------------------------------------------------------------------------
1095: Procedure dt_update_validate
1096: (p_ler_chg_dpnt_cvg_rl in number default hr_api.g_number,
1097: p_cvg_eff_strt_rl in number default hr_api.g_number,
1098: p_cvg_eff_end_rl in number default hr_api.g_number,
1099: p_ptip_id in number default hr_api.g_number,
1100: p_ler_id in number default hr_api.g_number,
1101: p_pl_id in number default hr_api.g_number,
1102: p_pgm_id in number default hr_api.g_number,

Line 1099: p_ptip_id in number default hr_api.g_number,

1095: Procedure dt_update_validate
1096: (p_ler_chg_dpnt_cvg_rl in number default hr_api.g_number,
1097: p_cvg_eff_strt_rl in number default hr_api.g_number,
1098: p_cvg_eff_end_rl in number default hr_api.g_number,
1099: p_ptip_id in number default hr_api.g_number,
1100: p_ler_id in number default hr_api.g_number,
1101: p_pl_id in number default hr_api.g_number,
1102: p_pgm_id in number default hr_api.g_number,
1103: p_datetrack_mode in varchar2,

Line 1100: p_ler_id in number default hr_api.g_number,

1096: (p_ler_chg_dpnt_cvg_rl in number default hr_api.g_number,
1097: p_cvg_eff_strt_rl in number default hr_api.g_number,
1098: p_cvg_eff_end_rl in number default hr_api.g_number,
1099: p_ptip_id in number default hr_api.g_number,
1100: p_ler_id in number default hr_api.g_number,
1101: p_pl_id in number default hr_api.g_number,
1102: p_pgm_id in number default hr_api.g_number,
1103: p_datetrack_mode in varchar2,
1104: p_validation_start_date in date,

Line 1101: p_pl_id in number default hr_api.g_number,

1097: p_cvg_eff_strt_rl in number default hr_api.g_number,
1098: p_cvg_eff_end_rl in number default hr_api.g_number,
1099: p_ptip_id in number default hr_api.g_number,
1100: p_ler_id in number default hr_api.g_number,
1101: p_pl_id in number default hr_api.g_number,
1102: p_pgm_id in number default hr_api.g_number,
1103: p_datetrack_mode in varchar2,
1104: p_validation_start_date in date,
1105: p_validation_end_date in date) Is

Line 1102: p_pgm_id in number default hr_api.g_number,

1098: p_cvg_eff_end_rl in number default hr_api.g_number,
1099: p_ptip_id in number default hr_api.g_number,
1100: p_ler_id in number default hr_api.g_number,
1101: p_pl_id in number default hr_api.g_number,
1102: p_pgm_id in number default hr_api.g_number,
1103: p_datetrack_mode in varchar2,
1104: p_validation_start_date in date,
1105: p_validation_end_date in date) Is
1106: --

Line 1116: hr_api.mandatory_arg_error

1112: hr_utility.set_location('Entering:'||l_proc, 5);
1113: --
1114: -- Ensure that the p_datetrack_mode argument is not null
1115: --
1116: hr_api.mandatory_arg_error
1117: (p_api_name => l_proc,
1118: p_argument => 'datetrack_mode',
1119: p_argument_value => p_datetrack_mode);
1120: --

Line 1128: hr_api.mandatory_arg_error

1124: --
1125: --
1126: -- Ensure the arguments are not null
1127: --
1128: hr_api.mandatory_arg_error
1129: (p_api_name => l_proc,
1130: p_argument => 'validation_start_date',
1131: p_argument_value => p_validation_start_date);
1132: --

Line 1133: hr_api.mandatory_arg_error

1129: (p_api_name => l_proc,
1130: p_argument => 'validation_start_date',
1131: p_argument_value => p_validation_start_date);
1132: --
1133: hr_api.mandatory_arg_error
1134: (p_api_name => l_proc,
1135: p_argument => 'validation_end_date',
1136: p_argument_value => p_validation_end_date);
1137: --

Line 1138: If ((nvl(p_ler_chg_dpnt_cvg_rl, hr_api.g_number) <> hr_api.g_number) and

1134: (p_api_name => l_proc,
1135: p_argument => 'validation_end_date',
1136: p_argument_value => p_validation_end_date);
1137: --
1138: If ((nvl(p_ler_chg_dpnt_cvg_rl, hr_api.g_number) <> hr_api.g_number) and
1139: NOT (dt_api.check_min_max_dates
1140: (p_base_table_name => 'ff_formulas_f',
1141: p_base_key_column => 'formula_id',
1142: p_base_key_value => p_ler_chg_dpnt_cvg_rl,

Line 1148: If ((nvl(p_cvg_eff_strt_rl, hr_api.g_number) <> hr_api.g_number) and

1144: p_to_date => p_validation_end_date))) Then
1145: l_table_name := 'ff_formulas_f';
1146: Raise l_integrity_error;
1147: End If;
1148: If ((nvl(p_cvg_eff_strt_rl, hr_api.g_number) <> hr_api.g_number) and
1149: NOT (dt_api.check_min_max_dates
1150: (p_base_table_name => 'ff_formulas_f',
1151: p_base_key_column => 'formula_id',
1152: p_base_key_value => p_cvg_eff_strt_rl,

Line 1158: If ((nvl(p_cvg_eff_end_rl, hr_api.g_number) <> hr_api.g_number) and

1154: p_to_date => p_validation_end_date))) Then
1155: l_table_name := 'ff_formulas_f';
1156: Raise l_integrity_error;
1157: End If;
1158: If ((nvl(p_cvg_eff_end_rl, hr_api.g_number) <> hr_api.g_number) and
1159: NOT (dt_api.check_min_max_dates
1160: (p_base_table_name => 'ff_formulas_f',
1161: p_base_key_column => 'formula_id',
1162: p_base_key_value => p_cvg_eff_end_rl,

Line 1168: If ((nvl(p_ptip_id, hr_api.g_number) <> hr_api.g_number) and

1164: p_to_date => p_validation_end_date))) Then
1165: l_table_name := 'ff_formulas_f';
1166: Raise l_integrity_error;
1167: End If;
1168: If ((nvl(p_ptip_id, hr_api.g_number) <> hr_api.g_number) and
1169: NOT (dt_api.check_min_max_dates
1170: (p_base_table_name => 'ben_ptip_f',
1171: p_base_key_column => 'ptip_id',
1172: p_base_key_value => p_ptip_id,

Line 1178: If ((nvl(p_ler_id, hr_api.g_number) <> hr_api.g_number) and

1174: p_to_date => p_validation_end_date))) Then
1175: l_table_name := 'ben_ptip_f';
1176: Raise l_integrity_error;
1177: End If;
1178: If ((nvl(p_ler_id, hr_api.g_number) <> hr_api.g_number) and
1179: NOT (dt_api.check_min_max_dates
1180: (p_base_table_name => 'ben_ler_f',
1181: p_base_key_column => 'ler_id',
1182: p_base_key_value => p_ler_id,

Line 1188: If ((nvl(p_pl_id, hr_api.g_number) <> hr_api.g_number) and

1184: p_to_date => p_validation_end_date))) Then
1185: l_table_name := 'ben_ler_f';
1186: Raise l_integrity_error;
1187: End If;
1188: If ((nvl(p_pl_id, hr_api.g_number) <> hr_api.g_number) and
1189: NOT (dt_api.check_min_max_dates
1190: (p_base_table_name => 'ben_pl_f',
1191: p_base_key_column => 'pl_id',
1192: p_base_key_value => p_pl_id,

Line 1198: If ((nvl(p_pgm_id, hr_api.g_number) <> hr_api.g_number) and

1194: p_to_date => p_validation_end_date))) Then
1195: l_table_name := 'ben_pl_f';
1196: Raise l_integrity_error;
1197: End If;
1198: If ((nvl(p_pgm_id, hr_api.g_number) <> hr_api.g_number) and
1199: NOT (dt_api.check_min_max_dates
1200: (p_base_table_name => 'ben_pgm_f',
1201: p_base_key_column => 'pgm_id',
1202: p_base_key_value => p_pgm_id,

Line 1280: hr_api.mandatory_arg_error

1276: hr_utility.set_location('Entering:'||l_proc, 5);
1277: --
1278: -- Ensure that the p_datetrack_mode argument is not null
1279: --
1280: hr_api.mandatory_arg_error
1281: (p_api_name => l_proc,
1282: p_argument => 'datetrack_mode',
1283: p_argument_value => p_datetrack_mode);
1284: --

Line 1294: hr_api.mandatory_arg_error

1290: --
1291: --
1292: -- Ensure the arguments are not null
1293: --
1294: hr_api.mandatory_arg_error
1295: (p_api_name => l_proc,
1296: p_argument => 'validation_start_date',
1297: p_argument_value => p_validation_start_date);
1298: --

Line 1299: hr_api.mandatory_arg_error

1295: (p_api_name => l_proc,
1296: p_argument => 'validation_start_date',
1297: p_argument_value => p_validation_start_date);
1298: --
1299: hr_api.mandatory_arg_error
1300: (p_api_name => l_proc,
1301: p_argument => 'validation_end_date',
1302: p_argument_value => p_validation_end_date);
1303: --

Line 1304: hr_api.mandatory_arg_error

1300: (p_api_name => l_proc,
1301: p_argument => 'validation_end_date',
1302: p_argument_value => p_validation_end_date);
1303: --
1304: hr_api.mandatory_arg_error
1305: (p_api_name => l_proc,
1306: p_argument => 'ler_chg_dpnt_cvg_id',
1307: p_argument_value => p_ler_chg_dpnt_cvg_id);
1308: --

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

1353: hr_utility.set_location('Entering:'||l_proc, 5);
1354: --
1355: -- Call all supporting business operations
1356: --
1357: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1358: --
1359: chk_ler_chg_dpnt_cvg_id
1360: (p_ler_chg_dpnt_cvg_id => p_rec.ler_chg_dpnt_cvg_id,
1361: p_effective_date => p_effective_date,

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

1469: --
1470: Begin
1471: hr_utility.set_location('Entering:'||l_proc, 5);
1472: --
1473: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1474: --
1475: -- Call all supporting business operations
1476: --
1477: chk_ler_chg_dpnt_cvg_id

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

1640: hr_utility.set_location('Entering:'|| l_proc, 10);
1641: --
1642: -- Ensure that all the mandatory parameter are not null
1643: --
1644: hr_api.mandatory_arg_error(p_api_name => l_proc,
1645: p_argument => 'ler_chg_dpnt_cvg_id',
1646: p_argument_value => p_ler_chg_dpnt_cvg_id);
1647: --
1648: open csr_leg_code;