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_TTP_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_ttp_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_ttl_prtt_rt_id => p_ttl_prtt_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_prtt_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: -- Added For bug 2529689
137: --

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

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

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

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

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

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

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

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

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

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

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_ttp_shd.api_updating
261: (p_ttl_prtt_rt_id => p_ttl_prtt_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_prtt_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_ttp_shd.api_updating
337: (p_ttl_prtt_rt_id => p_ttl_prtt_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_prtt_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_ttp_shd.api_updating
408: (p_ttl_prtt_rt_id => p_ttl_prtt_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_prtt_num_apls_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_ttp_shd.api_updating
479: (p_ttl_prtt_rt_id => p_ttl_prtt_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_prtt_num_apls_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_ttp_shd.api_updating
550: (p_ttl_prtt_rt_id => p_ttl_prtt_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 630: hr_utility.set_location('Entering:'||l_proc, 5);

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

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

651: close c1;
652: --
653: end if;
654: --
655: hr_utility.set_location('Leaving:'||l_proc, 10);
656: --
657: End chk_prtt_cvg_vol_mutexcl;
658: -- ----------------------------------------------------------------------------
659: -- |------< chk_flag_and_val >------|

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

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

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

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

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

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

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

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

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

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

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

841: fnd_message.raise_error;
842: --
843: end if;
844: --
845: hr_utility.set_location('Leaving:'||l_proc,10);
846: --
847: end chk_mn_mx_prtt_num;
848: -- ----------------------------------------------------------------------------
849: -- |--------------------------< 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 1146: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

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

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

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

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

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

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

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

1276: p_validation_start_date => p_validation_start_date,
1277: p_validation_end_date => p_validation_end_date,
1278: p_ttl_prtt_rt_id => p_rec.ttl_prtt_rt_id);
1279: --
1280: hr_utility.set_location(' Leaving:'||l_proc, 10);
1281: End delete_validate;
1282: --
1283: --
1284: -- ---------------------------------------------------------------------------

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

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

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

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