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_TCV_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_tcv_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_ttl_cvg_vol_rt_id => p_ttl_cvg_vol_rt_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_ttl_cvg_vol_rt_id;
78: --
79: -- |--------------------< chk_duplicate_ordr_num >----------------------------|

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

117: and business_group_id + 0 = p_business_group_id
118: and ordr_num = p_ordr_num;
119: --
120: Begin
121: hr_utility.set_location('Entering:'||l_proc, 5);
122:
123: --
124: open c1;
125: fetch c1 into l_dummy;

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

129: fnd_message.raise_error;
130: end if;
131: close c1;
132: --
133: hr_utility.set_location('Leaving:'||l_proc, 10);
134: End chk_duplicate_ordr_num;
135:
136: --
137: -- Added For bug 2529689

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

180:
181: l_c1 c1%ROWTYPE;
182: --
183: Begin
184: hr_utility.set_location('Entering:'||l_proc, 5);
185:
186: --
187: open c1;
188: fetch c1 into l_c1;

Line 190: hr_utility.set_location('vrbl rt prfl id is :'||p_vrbl_rt_prfl_id, 69);

186: --
187: open c1;
188: fetch c1 into l_c1;
189: --
190: hr_utility.set_location('vrbl rt prfl id is :'||p_vrbl_rt_prfl_id, 69);
191: hr_utility.set_location('vrbl_usg_cd is :'||l_c1.vrbl_usg_cd, 69);
192: hr_utility.set_location('mlt_cd id is :'||l_c1.mlt_cd, 69);
193:
194: IF l_c1.vrbl_usg_cd = 'ACP' THEN

Line 191: hr_utility.set_location('vrbl_usg_cd is :'||l_c1.vrbl_usg_cd, 69);

187: open c1;
188: fetch c1 into l_c1;
189: --
190: hr_utility.set_location('vrbl rt prfl id is :'||p_vrbl_rt_prfl_id, 69);
191: hr_utility.set_location('vrbl_usg_cd is :'||l_c1.vrbl_usg_cd, 69);
192: hr_utility.set_location('mlt_cd id is :'||l_c1.mlt_cd, 69);
193:
194: IF l_c1.vrbl_usg_cd = 'ACP' THEN
195: IF l_c1.mlt_cd <> 'TTLCVG' THEN

Line 192: hr_utility.set_location('mlt_cd id is :'||l_c1.mlt_cd, 69);

188: fetch c1 into l_c1;
189: --
190: hr_utility.set_location('vrbl rt prfl id is :'||p_vrbl_rt_prfl_id, 69);
191: hr_utility.set_location('vrbl_usg_cd is :'||l_c1.vrbl_usg_cd, 69);
192: hr_utility.set_location('mlt_cd id is :'||l_c1.mlt_cd, 69);
193:
194: IF l_c1.vrbl_usg_cd = 'ACP' THEN
195: IF l_c1.mlt_cd <> 'TTLCVG' THEN
196: close c1;

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

204: END IF;
205:
206: close c1;
207: --
208: hr_utility.set_location('Leaving:'||l_proc, 10);
209: End chk_ttlcov_mlt_cd;
210:
211: --
212:

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

254: and ff.effective_end_date;
255: --
256: Begin
257: --
258: hr_utility.set_location('Entering:'||l_proc, 5);
259: --
260: l_api_updating := ben_tcv_shd.api_updating
261: (p_ttl_cvg_vol_rt_id => p_ttl_cvg_vol_rt_id,
262: p_effective_date => p_effective_date,

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

290: close c1;
291: --
292: end if;
293: --
294: hr_utility.set_location('Leaving:'||l_proc,10);
295: --
296: end chk_cvg_vol_det_rl;
297: --
298: -- ----------------------------------------------------------------------------

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

330: l_api_updating boolean;
331: --
332: Begin
333: --
334: hr_utility.set_location('Entering:'||l_proc, 5);
335: --
336: l_api_updating := ben_tcv_shd.api_updating
337: (p_ttl_cvg_vol_rt_id => p_ttl_cvg_vol_rt_id,
338: p_effective_date => p_effective_date,

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

361: end if;
362: --
363: end if;
364: --
365: hr_utility.set_location('Leaving:'||l_proc,10);
366: --
367: end chk_cvg_vol_det_cd;
368: --
369: -- ----------------------------------------------------------------------------

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

401: l_api_updating boolean;
402: --
403: Begin
404: --
405: hr_utility.set_location('Entering:'||l_proc, 5);
406: --
407: l_api_updating := ben_tcv_shd.api_updating
408: (p_ttl_cvg_vol_rt_id => p_ttl_cvg_vol_rt_id,
409: p_effective_date => p_effective_date,

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

432: end if;
433: --
434: end if;
435: --
436: hr_utility.set_location('Leaving:'||l_proc,10);
437: --
438: end chk_no_mx_cvg_vol_amt_flag;
439: --
440: -- ----------------------------------------------------------------------------

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

472: l_api_updating boolean;
473: --
474: Begin
475: --
476: hr_utility.set_location('Entering:'||l_proc, 5);
477: --
478: l_api_updating := ben_tcv_shd.api_updating
479: (p_ttl_cvg_vol_rt_id => p_ttl_cvg_vol_rt_id,
480: p_effective_date => p_effective_date,

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

503: end if;
504: --
505: end if;
506: --
507: hr_utility.set_location('Leaving:'||l_proc,10);
508: --
509: end chk_no_mn_cvg_vol_amt_flag;
510: --
511: -- ----------------------------------------------------------------------------

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

543: l_api_updating boolean;
544: --
545: Begin
546: --
547: hr_utility.set_location('Entering:'||l_proc, 5);
548: --
549: l_api_updating := ben_tcv_shd.api_updating
550: (p_ttl_cvg_vol_rt_id => p_ttl_cvg_vol_rt_id,
551: p_effective_date => p_effective_date,

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

574: end if;
575: --
576: end if;
577: --
578: hr_utility.set_location('Leaving:'||l_proc,10);
579: --
580: end chk_excld_flag;
581: --
582: -- ----------------------------------------------------------------------------

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

625: and a.effective_end_date;
626: --
627: Begin
628: --
629: hr_utility.set_location('Entering:'||l_proc, 5);
630: --
631: if p_vrbl_rt_prfl_id is not null then
632: --
633: -- Check if vrbl_rt_prfl_id is mutually exclusive.

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

649: close c1;
650: --
651: end if;
652: --
653: hr_utility.set_location('Leaving:'||l_proc, 10);
654: --
655: End chk_cvg_vol_prtt_mutexcl;
656: --
657: -- ----------------------------------------------------------------------------

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

686: l_proc varchar2(72) := g_package||'chk_flag_and_val';
687: --
688: Begin
689: --
690: hr_utility.set_location('Entering:'||l_proc, 5);
691: --
692: if p_flag = 'Y' and p_val is not null then
693: fnd_message.set_name('BEN', p_msg);
694: fnd_message.raise_error;

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

693: fnd_message.set_name('BEN', p_msg);
694: fnd_message.raise_error;
695: end if;
696: --
697: hr_utility.set_location('Leaving:'||l_proc,10);
698: --
699: end chk_flag_and_val;
700: --
701: -- ----------------------------------------------------------------------------

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

728: l_proc varchar2(72) := g_package||'chk_mn_val_mx_val';
729: --
730: Begin
731: --
732: hr_utility.set_location('Entering:'||l_proc, 5);
733: --
734: -- check the values
735: -- note: Don't want an error if either one is null
736: --

Line 746: hr_utility.set_location('Leaving:'||l_proc, 5);

742: fnd_message.raise_error;
743: --
744: end if;
745: --
746: hr_utility.set_location('Leaving:'||l_proc, 5);
747: --
748: end chk_mn_val_mx_val;
749: ----------------------------------------------------------------------------
750: --|-------------------------< chk_mn_mx_vol_amt >--------------------------|

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

788: l_dummy varchar2(1);
789: --
790: Begin
791: --
792: hr_utility.set_location('Entering:'||l_proc, 5);
793: --
794: -- Minimum Vol Number must be < Maximum Vol Number,
795: -- if both are used.
796: --

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

840: fnd_message.raise_error;
841: --
842: end if;
843: --
844: hr_utility.set_location('Leaving:'||l_proc,10);
845: --
846: end chk_mn_mx_vol_amt;
847: -- ----------------------------------------------------------------------------
848: -- |--------------------------< dt_update_validate >--------------------------|

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

883: l_integrity_error Exception;
884: l_table_name all_tables.table_name%TYPE;
885: --
886: Begin
887: hr_utility.set_location('Entering:'||l_proc, 5);
888: --
889: -- Ensure that the p_datetrack_mode argument is not null
890: --
891: hr_api.mandatory_arg_error

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

922: End If;
923: --
924: End If;
925: --
926: hr_utility.set_location(' Leaving:'||l_proc, 10);
927: Exception
928: When l_integrity_error Then
929: --
930: -- A referential integrity check was violated therefore

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

987: l_rows_exist Exception;
988: l_table_name all_tables.table_name%TYPE;
989: --
990: Begin
991: hr_utility.set_location('Entering:'||l_proc, 5);
992: --
993: -- Ensure that the p_datetrack_mode argument is not null
994: --
995: hr_api.mandatory_arg_error

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

1024: --
1025: --
1026: End If;
1027: --
1028: hr_utility.set_location(' Leaving:'||l_proc, 10);
1029: Exception
1030: When l_rows_exist Then
1031: --
1032: -- A referential integrity check was violated therefore

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

1058: --
1059: l_proc varchar2(72) := g_package||'insert_validate';
1060: --
1061: Begin
1062: hr_utility.set_location('Entering:'||l_proc, 5);
1063: --
1064: -- Call all supporting business operations
1065: --
1066: --

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

1141: (p_vrbl_rt_prfl_id => p_rec.vrbl_rt_prfl_id,
1142: p_effective_date => p_effective_date,
1143: p_business_group_id => p_rec.business_group_id);
1144: --
1145: hr_utility.set_location(' Leaving:'||l_proc, 10);
1146: End insert_validate;
1147: --
1148: -- ----------------------------------------------------------------------------
1149: -- |---------------------------< update_validate >----------------------------|

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

1157: --
1158: l_proc varchar2(72) := g_package||'update_validate';
1159: --
1160: Begin
1161: hr_utility.set_location('Entering:'||l_proc, 5);
1162: --
1163: -- Call all supporting business operations
1164: --
1165: --

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

1248: (p_vrbl_rt_prfl_id => p_rec.vrbl_rt_prfl_id,
1249: p_effective_date => p_effective_date,
1250: p_business_group_id => p_rec.business_group_id);
1251: --
1252: hr_utility.set_location(' Leaving:'||l_proc, 10);
1253: End update_validate;
1254: --
1255: -- ----------------------------------------------------------------------------
1256: -- |---------------------------< delete_validate >----------------------------|

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

1264: --
1265: l_proc varchar2(72) := g_package||'delete_validate';
1266: --
1267: Begin
1268: hr_utility.set_location('Entering:'||l_proc, 5);
1269: --
1270: -- Call all supporting business operations
1271: --
1272: dt_delete_validate

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

1274: p_validation_start_date => p_validation_start_date,
1275: p_validation_end_date => p_validation_end_date,
1276: p_ttl_cvg_vol_rt_id => p_rec.ttl_cvg_vol_rt_id);
1277: --
1278: hr_utility.set_location(' Leaving:'||l_proc, 10);
1279: End delete_validate;
1280: --
1281: --
1282: -- ---------------------------------------------------------------------------

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

1301: l_proc varchar2(72) := g_package||'return_legislation_code';
1302: --
1303: begin
1304: --
1305: hr_utility.set_location('Entering:'|| l_proc, 10);
1306: --
1307: -- Ensure that all the mandatory parameter are not null
1308: --
1309: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

1326: end if;
1327: --
1328: close csr_leg_code;
1329: --
1330: hr_utility.set_location(' Leaving:'|| l_proc, 20);
1331: --
1332: return l_legislation_code;
1333: --
1334: end return_legislation_code;