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_DPNT_EDC_BUS dependencies on HR_UTILITY

Line 49: hr_utility.set_location('Entering:'||l_proc, 5);

45: l_api_updating boolean;
46: --
47: Begin
48: --
49: hr_utility.set_location('Entering:'||l_proc, 5);
50: --
51: l_api_updating := ben_dpnt_edc_shd.api_updating
52: (p_effective_date => p_effective_date,
53: p_dpnt_eligy_crit_values_id => p_dpnt_eligy_crit_values_id,

Line 79: hr_utility.set_location('Leaving:'||l_proc, 10);

75: end if;
76: --
77: end if;
78: --
79: hr_utility.set_location('Leaving:'||l_proc, 10);
80: --
81: End chk_dpnt_eligy_crit_values_id;
82: --
83: -- ----------------------------------------------------------------------------

Line 125: hr_utility.set_location('Entering:'||l_proc, 5);

121: from ben_eligy_criteria_dpnt
122: where eligy_criteria_dpnt_id = p_eligy_criteria_dpnt_id;
123: begin
124: --
125: hr_utility.set_location('Entering:'||l_proc, 5);
126: --
127: l_api_updating := ben_dpnt_edc_shd.api_updating(
128: p_dpnt_eligy_crit_values_id => p_dpnt_eligy_crit_values_id,
129: p_effective_date => p_effective_date,

Line 156: hr_utility.set_location('Leaving:'||l_proc, 10);

152: close csr_eligy_criteria_dpnt_id;
153: --
154: end if;
155: --
156: hr_utility.set_location('Leaving:'||l_proc, 10);
157: --
158: end chk_eligy_criteria_dpnt_id;
159: --
160: -- ----------------------------------------------------------------------------

Line 202: hr_utility.set_location('Entering:'||l_proc, 5);

198: from ben_dpnt_cvg_eligy_prfl_f
199: where dpnt_cvg_eligy_prfl_id = p_dpnt_cvg_eligy_prfl_id;
200: begin
201: --
202: hr_utility.set_location('Entering:'||l_proc, 5);
203: --
204: l_api_updating := ben_dpnt_edc_shd.api_updating(
205: p_dpnt_eligy_crit_values_id => p_dpnt_eligy_crit_values_id,
206: p_effective_date => p_effective_date,

Line 231: hr_utility.set_location('Leaving:'||l_proc, 10);

227: --
228: close csr_eligy_prfl_id;
229: end if;
230: --
231: hr_utility.set_location('Leaving:'||l_proc, 10);
232: --
233: end chk_eligy_prfl_id;
234: --
235: -- ----------------------------------------------------------------------------

Line 291: hr_utility.set_location('Entering:'||l_proc, 5);

287: and edc.business_group_id = p_business_group_id;
288: --
289: begin
290: --
291: hr_utility.set_location('Entering:'||l_proc, 5);
292:
293: --
294: open c_eligy_prfl;
295: --

Line 309: hr_utility.set_location('Leaving:'||l_proc, 10);

305: end if;
306: --
307: close c_eligy_prfl;
308: --
309: hr_utility.set_location('Leaving:'||l_proc, 10);
310: --
311: end chk_duplicate_eligy_criteria;
312: --
313: -- ---------------------------------------------------------------------------

Line 366: hr_utility.set_location('Entering:'||l_proc, 5);

362: and effective_end_date >= p_validation_start_date;
363: --
364: Begin
365: --
366: hr_utility.set_location('Entering:'||l_proc, 5);
367: --
368: open c1;
369: --
370: fetch c1 into l_dummy;

Line 383: hr_utility.set_location('Leaving:'||l_proc, 15);

379: end if;
380: --
381: close c1;
382: --
383: hr_utility.set_location('Leaving:'||l_proc, 15);
384: --
385: End chk_duplicate_ordr_num;
386: --
387: -- ----------------------------------------------------------------------------

Line 506: hr_utility.set_location('Entering:'||l_proc, 5);

502: );
503: --
504: begin
505: --
506: hr_utility.set_location('Entering:'||l_proc, 5);
507: --
508: open c_eligy_criteria;
509: --
510: fetch c_eligy_criteria into l_crit_col1_val_type_cd,

Line 660: hr_utility.set_location('Leaving:'||l_proc, 10);

656: end if;
657: --
658: close c_eligy_criteria;
659: --
660: hr_utility.set_location('Leaving:'||l_proc, 10);
661: --
662: end chk_required_fields;
663: --
664: -- ----------------------------------------------------------------------------

Line 706: hr_utility.set_location('Entering:'||l_proc, 5);

702: l_integrity_error Exception;
703: l_table_name all_tables.table_name%TYPE;
704: --
705: Begin
706: hr_utility.set_location('Entering:'||l_proc, 5);
707: --
708: -- Ensure that the p_datetrack_mode argument is not null
709: --
710: hr_api.mandatory_arg_error

Line 756: hr_utility.set_location(' Leaving:'||l_proc, 10);

752: End If;
753: --
754: end if;
755: --
756: hr_utility.set_location(' Leaving:'||l_proc, 10);
757: Exception
758: When l_integrity_error Then
759: --
760: -- A referential integrity check was violated therefore

Line 769: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

765: --
766: -- An unhandled or unexpected error has occurred which
767: -- we must report
768: --
769: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
770: hr_utility.set_message_token('PROCEDURE', l_proc);
771: hr_utility.set_message_token('STEP','15');
772: hr_utility.raise_error;
773: end dt_update_validate;

Line 770: hr_utility.set_message_token('PROCEDURE', l_proc);

766: -- An unhandled or unexpected error has occurred which
767: -- we must report
768: --
769: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
770: hr_utility.set_message_token('PROCEDURE', l_proc);
771: hr_utility.set_message_token('STEP','15');
772: hr_utility.raise_error;
773: end dt_update_validate;
774: -- ----------------------------------------------------------------------------

Line 771: hr_utility.set_message_token('STEP','15');

767: -- we must report
768: --
769: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
770: hr_utility.set_message_token('PROCEDURE', l_proc);
771: hr_utility.set_message_token('STEP','15');
772: hr_utility.raise_error;
773: end dt_update_validate;
774: -- ----------------------------------------------------------------------------
775: -- |--------------------------< dt_delete_validate >--------------------------|

Line 772: hr_utility.raise_error;

768: --
769: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
770: hr_utility.set_message_token('PROCEDURE', l_proc);
771: hr_utility.set_message_token('STEP','15');
772: hr_utility.raise_error;
773: end dt_update_validate;
774: -- ----------------------------------------------------------------------------
775: -- |--------------------------< dt_delete_validate >--------------------------|
776: -- ----------------------------------------------------------------------------

Line 820: hr_utility.set_location('Entering:'||l_proc, 5);

816: l_rows_exist Exception;
817: l_table_name all_tables.table_name%TYPE;
818: --
819: Begin
820: hr_utility.set_location('Entering:'||l_proc, 5);
821: --
822: -- Ensure that the p_datetrack_mode argument is not null
823: --
824: hr_api.mandatory_arg_error

Line 870: hr_utility.set_location('Entering:'||l_proc, 5);

866: --
867: l_proc varchar2(72) := g_package||'insert_validate';
868: --
869: begin
870: hr_utility.set_location('Entering:'||l_proc, 5);
871: --
872: -- Call all supporting business operations
873: --
874: --

Line 937: hr_utility.set_location(' Leaving:'||l_proc, 10);

933: p_date_Value4 => p_rec.date_Value4,
934: p_business_group_id => p_rec.business_group_id,
935: p_effective_date => p_effective_date) ;
936: --
937: hr_utility.set_location(' Leaving:'||l_proc, 10);
938: --
939: end insert_validate;
940: --
941: -- ----------------------------------------------------------------------------

Line 954: hr_utility.set_location('Entering:'||l_proc, 5);

950: --
951: l_proc varchar2(72) := g_package||'update_validate';
952: begin
953: --
954: hr_utility.set_location('Entering:'||l_proc, 5);
955: --
956: -- Call all supporting business operations
957: --
958: --

Line 1032: hr_utility.set_location(' Leaving:'||l_proc, 10);

1028: p_validation_start_date => p_validation_start_date,
1029: p_validation_end_date => p_validation_end_date );
1030: --
1031: --
1032: hr_utility.set_location(' Leaving:'||l_proc, 10);
1033: --
1034: end update_validate;
1035: --
1036: -- ----------------------------------------------------------------------------

Line 1048: hr_utility.set_location('Entering:'||l_proc, 5);

1044: p_validation_end_date in date) is
1045: --
1046: l_proc varchar2(72) := g_package||'delete_validate';
1047: Begin
1048: hr_utility.set_location('Entering:'||l_proc, 5);
1049: --
1050: -- Call all supporting business operations
1051: --
1052: chk_dpnt_eligy_crit_values_id

Line 1091: hr_utility.set_location('Entering:'|| l_proc, 10);

1087: l_proc varchar2(72) := g_package||'return_legislation_code';
1088: --
1089: begin
1090: --
1091: hr_utility.set_location('Entering:'|| l_proc, 10);
1092: --
1093: -- Ensure that all the mandatory parameter are not null
1094: --
1095: hr_api.mandatory_arg_error(p_api_name => l_proc,

Line 1110: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');

1106: close csr_leg_code;
1107: --
1108: -- The primary key is invalid therefore we must error
1109: --
1110: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
1111: hr_utility.raise_error;
1112: --
1113: end if;
1114: --

Line 1111: hr_utility.raise_error;

1107: --
1108: -- The primary key is invalid therefore we must error
1109: --
1110: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
1111: hr_utility.raise_error;
1112: --
1113: end if;
1114: --
1115: close csr_leg_code;

Line 1117: hr_utility.set_location(' Leaving:'|| l_proc, 20);

1113: end if;
1114: --
1115: close csr_leg_code;
1116: --
1117: hr_utility.set_location(' Leaving:'|| l_proc, 20);
1118: --
1119: return l_legislation_code;
1120:
1121: --