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

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

42: l_api_updating boolean;
43: --
44: Begin
45: --
46: hr_utility.set_location('Entering:'||l_proc, 5);
47: --
48: l_api_updating := ben_etc_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_elig_ttl_cvg_vol_prte_id => p_elig_ttl_cvg_vol_prte_id,

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

71: end if;
72: --
73: end if;
74: --
75: hr_utility.set_location('Leaving:'||l_proc, 10);
76: --
77: End chk_elig_ttl_cvg_vol_prte_id;
78: --
79: -- ---------------------------------------------------------------------------

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

119: and ordr_num = p_ordr_num
120: and business_group_id = p_business_group_id;
121: --
122: Begin
123: hr_utility.set_location('Entering:'||l_proc, 5);
124: --
125: open c1;
126: fetch c1 into l_dummy;
127: if c1%found then

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

130: fnd_message.raise_error;
131: end if;
132: close c1;
133: --
134: hr_utility.set_location('Leaving:'||l_proc, 15);
135: End chk_duplicate_ordr_num;
136: --
137: -- ----------------------------------------------------------------------------
138: -- |------< chk_cvg_vol_det_rl >------|

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

178: and ff.effective_end_date;
179: --
180: Begin
181: --
182: hr_utility.set_location('Entering:'||l_proc, 5);
183: --
184: l_api_updating := ben_etc_shd.api_updating
185: (p_elig_ttl_cvg_vol_prte_id => p_elig_ttl_cvg_vol_prte_id,
186: p_effective_date => p_effective_date,

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

214: close c1;
215: --
216: end if;
217: --
218: hr_utility.set_location('Leaving:'||l_proc,10);
219: --
220: end chk_cvg_vol_det_rl;
221: --
222: -- ----------------------------------------------------------------------------

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

254: l_api_updating boolean;
255: --
256: Begin
257: --
258: hr_utility.set_location('Entering:'||l_proc, 5);
259: --
260: l_api_updating := ben_etc_shd.api_updating
261: (p_elig_ttl_cvg_vol_prte_id => p_elig_ttl_cvg_vol_prte_id,
262: p_effective_date => p_effective_date,

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

285: end if;
286: --
287: end if;
288: --
289: hr_utility.set_location('Leaving:'||l_proc,10);
290: --
291: end chk_cvg_vol_det_cd;
292: --
293: -- ----------------------------------------------------------------------------

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

325: l_api_updating boolean;
326: --
327: Begin
328: --
329: hr_utility.set_location('Entering:'||l_proc, 5);
330: --
331: l_api_updating := ben_etc_shd.api_updating
332: (p_elig_ttl_cvg_vol_prte_id => p_elig_ttl_cvg_vol_prte_id,
333: p_effective_date => p_effective_date,

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

356: end if;
357: --
358: end if;
359: --
360: hr_utility.set_location('Leaving:'||l_proc,10);
361: --
362: end chk_no_mx_cvg_vol_amt_flag;
363: --
364: -- ----------------------------------------------------------------------------

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

396: l_api_updating boolean;
397: --
398: Begin
399: --
400: hr_utility.set_location('Entering:'||l_proc, 5);
401: --
402: l_api_updating := ben_etc_shd.api_updating
403: (p_elig_ttl_cvg_vol_prte_id => p_elig_ttl_cvg_vol_prte_id,
404: p_effective_date => p_effective_date,

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

427: end if;
428: --
429: end if;
430: --
431: hr_utility.set_location('Leaving:'||l_proc,10);
432: --
433: end chk_no_mn_cvg_vol_amt_flag;
434: --
435: -- ----------------------------------------------------------------------------

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

467: l_api_updating boolean;
468: --
469: Begin
470: --
471: hr_utility.set_location('Entering:'||l_proc, 5);
472: --
473: l_api_updating := ben_etc_shd.api_updating
474: (p_elig_ttl_cvg_vol_prte_id => p_elig_ttl_cvg_vol_prte_id,
475: p_effective_date => p_effective_date,

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

498: end if;
499: --
500: end if;
501: --
502: hr_utility.set_location('Leaving:'||l_proc,10);
503: --
504: end chk_excld_flag;
505: --
506: -- ----------------------------------------------------------------------------

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

535: l_proc varchar2(72) := g_package||'chk_flag_and_val';
536: --
537: Begin
538: --
539: hr_utility.set_location('Entering:'||l_proc, 5);
540: --
541: if p_flag = 'Y' and p_val is not null then
542: fnd_message.set_name('BEN', p_msg);
543: fnd_message.raise_error;

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

542: fnd_message.set_name('BEN', p_msg);
543: fnd_message.raise_error;
544: end if;
545: --
546: hr_utility.set_location('Leaving:'||l_proc,10);
547: --
548: end chk_flag_and_val;
549: --
550: ----------------------------------------------------------------------------

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

589: l_dummy varchar2(1);
590: --
591: Begin
592: --
593: hr_utility.set_location('Entering:'||l_proc, 5);
594: --
595: -- Minimum Vol Number must be < Maximum Vol Number,
596: -- if both are used.
597: --

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

641: fnd_message.raise_error;
642: --
643: end if;
644: --
645: hr_utility.set_location('Leaving:'||l_proc,10);
646: --
647: end chk_mn_mx_vol_amt;
648: -- ----------------------------------------------------------------------------
649: -- |--------------------------< dt_update_validate >--------------------------|

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

684: l_integrity_error Exception;
685: l_table_name all_tables.table_name%TYPE;
686: --
687: Begin
688: hr_utility.set_location('Entering:'||l_proc, 5);
689: --
690: -- Ensure that the p_datetrack_mode argument is not null
691: --
692: hr_api.mandatory_arg_error

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

723: End If;
724: --
725: End If;
726: --
727: hr_utility.set_location(' Leaving:'||l_proc, 10);
728: Exception
729: When l_integrity_error Then
730: --
731: -- A referential integrity check was violated therefore

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

788: l_rows_exist Exception;
789: l_table_name all_tables.table_name%TYPE;
790: --
791: Begin
792: hr_utility.set_location('Entering:'||l_proc, 5);
793: --
794: -- Ensure that the p_datetrack_mode argument is not null
795: --
796: hr_api.mandatory_arg_error

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

825: --
826: --
827: End If;
828: --
829: hr_utility.set_location(' Leaving:'||l_proc, 10);
830: Exception
831: When l_rows_exist Then
832: --
833: -- A referential integrity check was violated therefore

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

859: --
860: l_proc varchar2(72) := g_package||'insert_validate';
861: --
862: Begin
863: hr_utility.set_location('Entering:'||l_proc, 5);
864: --
865: -- Call all supporting business operations
866: --
867: --

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

925: p_eligy_prfl_id => p_rec.eligy_prfl_id,
926: p_ordr_num => p_rec.ordr_num,
927: p_business_group_id => p_rec.business_group_id);
928: --
929: hr_utility.set_location(' Leaving:'||l_proc, 10);
930: End insert_validate;
931: --
932: -- ----------------------------------------------------------------------------
933: -- |---------------------------< update_validate >----------------------------|

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

941: --
942: l_proc varchar2(72) := g_package||'update_validate';
943: --
944: Begin
945: hr_utility.set_location('Entering:'||l_proc, 5);
946: --
947: -- Call all supporting business operations
948: --
949: --

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

1015: p_datetrack_mode => p_datetrack_mode,
1016: p_validation_start_date => p_validation_start_date,
1017: p_validation_end_date => p_validation_end_date);
1018: --
1019: hr_utility.set_location(' Leaving:'||l_proc, 10);
1020: End update_validate;
1021: --
1022: -- ----------------------------------------------------------------------------
1023: -- |---------------------------< delete_validate >----------------------------|

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

1031: --
1032: l_proc varchar2(72) := g_package||'delete_validate';
1033: --
1034: Begin
1035: hr_utility.set_location('Entering:'||l_proc, 5);
1036: --
1037: -- Call all supporting business operations
1038: --
1039: dt_delete_validate

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

1041: p_validation_start_date => p_validation_start_date,
1042: p_validation_end_date => p_validation_end_date,
1043: p_elig_ttl_cvg_vol_prte_id => p_rec.elig_ttl_cvg_vol_prte_id);
1044: --
1045: hr_utility.set_location(' Leaving:'||l_proc, 10);
1046: End delete_validate;
1047: --
1048: --
1049: -- ---------------------------------------------------------------------------

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

1068: l_proc varchar2(72) := g_package||'return_legislation_code';
1069: --
1070: begin
1071: --
1072: hr_utility.set_location('Entering:'|| l_proc, 10);
1073: --
1074: -- Ensure that all the mandatory parameter are not null
1075: --
1076: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

1093: end if;
1094: --
1095: close csr_leg_code;
1096: --
1097: hr_utility.set_location(' Leaving:'|| l_proc, 20);
1098: --
1099: return l_legislation_code;
1100: --
1101: end return_legislation_code;