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_MTR_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_mtr_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_mtchg_rt_id => p_mtchg_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_mtchg_rt_id;
78: --
79: -- ----------------------------------------------------------------------------

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

117: where a.comp_lvl_fctr_id = p_comp_lvl_fctr_id;
118: --
119: Begin
120: --
121: hr_utility.set_location('Entering:'||l_proc,5);
122: --
123: l_api_updating := ben_mtr_shd.api_updating
124: (p_mtchg_rt_id => p_mtchg_rt_id,
125: p_effective_date => p_effective_date,

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

149: close c1;
150: --
151: end if;
152: --
153: hr_utility.set_location('Leaving:'||l_proc,10);
154: --
155: End chk_comp_lvl_fctr_id;
156: --
157: -- ----------------------------------------------------------------------------

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

189: l_api_updating boolean;
190: --
191: Begin
192: --
193: hr_utility.set_location('Entering:'||l_proc, 5);
194: --
195: l_api_updating := ben_mtr_shd.api_updating
196: (p_mtchg_rt_id => p_mtchg_rt_id,
197: p_effective_date => p_effective_date,

Line 215: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');

211: p_effective_date => p_effective_date) then
212: --
213: -- raise error as does not exist as lookup
214: --
215: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
216: hr_utility.raise_error;
217: --
218: end if;
219: --

Line 216: hr_utility.raise_error;

212: --
213: -- raise error as does not exist as lookup
214: --
215: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
216: hr_utility.raise_error;
217: --
218: end if;
219: --
220: end if;

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

218: end if;
219: --
220: end if;
221: --
222: hr_utility.set_location('Leaving:'||l_proc,10);
223: --
224: end chk_no_mx_pct_of_py_num_flag;
225: --
226: -- ----------------------------------------------------------------------------

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

258: l_api_updating boolean;
259: --
260: Begin
261: --
262: hr_utility.set_location('Entering:'||l_proc, 5);
263: --
264: l_api_updating := ben_mtr_shd.api_updating
265: (p_mtchg_rt_id => p_mtchg_rt_id,
266: p_effective_date => p_effective_date,

Line 284: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');

280: p_effective_date => p_effective_date) then
281: --
282: -- raise error as does not exist as lookup
283: --
284: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
285: hr_utility.raise_error;
286: --
287: end if;
288: --

Line 285: hr_utility.raise_error;

281: --
282: -- raise error as does not exist as lookup
283: --
284: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
285: hr_utility.raise_error;
286: --
287: end if;
288: --
289: end if;

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

287: end if;
288: --
289: end if;
290: --
291: hr_utility.set_location('Leaving:'||l_proc,10);
292: --
293: end chk_no_mx_mtch_amt_flag;
294: --
295: -- ----------------------------------------------------------------------------

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

344: and ff.effective_end_date;
345: --
346: Begin
347: --
348: hr_utility.set_location('Entering:'||l_proc, 5);
349: --
350: l_api_updating := ben_mtr_shd.api_updating
351: (p_mtchg_rt_id => p_mtchg_rt_id,
352: p_effective_date => p_effective_date,

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

382: close c1;
383: --
384: end if;
385: --
386: hr_utility.set_location('Leaving:'||l_proc,10);
387: --
388: end chk_mtchg_rt_calc_rl;
389: --
390: -- ----------------------------------------------------------------------------

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

422: l_api_updating boolean;
423: --
424: Begin
425: --
426: hr_utility.set_location('Entering:'||l_proc, 5);
427: --
428: l_api_updating := ben_mtr_shd.api_updating
429: (p_mtchg_rt_id => p_mtchg_rt_id,
430: p_effective_date => p_effective_date,

Line 448: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');

444: p_effective_date => p_effective_date) then
445: --
446: -- raise error as does not exist as lookup
447: --
448: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
449: hr_utility.raise_error;
450: --
451: end if;
452: --

Line 449: hr_utility.raise_error;

445: --
446: -- raise error as does not exist as lookup
447: --
448: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
449: hr_utility.raise_error;
450: --
451: end if;
452: --
453: end if;

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

451: end if;
452: --
453: end if;
454: --
455: hr_utility.set_location('Leaving:'||l_proc,10);
456: --
457: end chk_no_mx_amt_of_py_num_flag;
458: --
459: -- ----------------------------------------------------------------------------

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

491: l_api_updating boolean;
492: --
493: Begin
494: --
495: hr_utility.set_location('Entering:'||l_proc, 5);
496: --
497: l_api_updating := ben_mtr_shd.api_updating
498: (p_mtchg_rt_id => p_mtchg_rt_id,
499: p_effective_date => p_effective_date,

Line 517: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');

513: p_effective_date => p_effective_date) then
514: --
515: -- raise error as does not exist as lookup
516: --
517: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
518: hr_utility.raise_error;
519: --
520: end if;
521: --

Line 518: hr_utility.raise_error;

514: --
515: -- raise error as does not exist as lookup
516: --
517: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
518: hr_utility.raise_error;
519: --
520: end if;
521: --
522: end if;

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

520: end if;
521: --
522: end if;
523: --
524: hr_utility.set_location('Leaving:'||l_proc,10);
525: --
526: end chk_cntnu_mtch_aftr_mx_rl_flag;
527: --
528: -- ----------------------------------------------------------------------------

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

566: l_api_updating boolean;
567: --
568: Begin
569: --
570: hr_utility.set_location('Entering:'||l_proc, 5);
571: --
572: l_api_updating := ben_mtr_shd.api_updating
573: (p_mtchg_rt_id => p_mtchg_rt_id,
574: p_effective_date => p_effective_date,

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

586: end if;
587:
588: --
589: --
590: hr_utility.set_location('Leaving:'||l_proc,10);
591: --
592: end chk_no_mx_pct_flag_mx_pct_py;
593: --
594: -- ----------------------------------------------------------------------------

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

633: l_api_updating boolean;
634: --
635: Begin
636: --
637: hr_utility.set_location('Entering:'||l_proc, 5);
638: --
639:
640: l_api_updating := ben_mtr_shd.api_updating
641: (p_mtchg_rt_id => p_mtchg_rt_id,

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

654: end if;
655:
656: --
657: --
658: hr_utility.set_location('Leaving:'||l_proc,10);
659: --
660: end chk_no_mx_amt_flag_mx_amt_py;
661: --
662: -- ----------------------------------------------------------------------------

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

692: l_proc varchar2(72) := g_package||'chk_mx_mtch_amt_and_flag';
693: --
694: Begin
695: --
696: hr_utility.set_location('Entering:'||l_proc, 5);
697: --
698: If (p_mx_mtch_amt is not null and p_no_mx_mtch_amt_flag = 'Y') then
699: --
700: -- raise error if maximum amount is not null and the No Maximum Amount

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

714: fnd_message.raise_error;
715: --
716: end if;
717: --
718: hr_utility.set_location('Leaving:'||l_proc, 10);
719: --
720: End chk_mx_mtch_amt_and_flag;
721: --
722: -- ----------------------------------------------------------------------------

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

751: l_proc varchar2(72) := g_package||'chk_mx_mn_mtch_amt';
752: --
753: Begin
754: --
755: hr_utility.set_location('Entering:'||l_proc, 5);
756: --
757: If (p_mx_mtch_amt is not null and p_mn_mtch_amt is not null) and
758: (p_mx_mtch_amt < p_mn_mtch_amt) then
759:

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

760: fnd_message.set_name('BEN','BEN_92506_MAX_MIN_AMT_CHK');
761: fnd_message.raise_error;
762: end if;
763: --
764: hr_utility.set_location('Leaving:'||l_proc, 10);
765: --
766: End chk_mx_mn_mtch_amt;
767: --
768:

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

807: l_integrity_error Exception;
808: l_table_name all_tables.table_name%TYPE;
809: --
810: Begin
811: hr_utility.set_location('Entering:'||l_proc, 5);
812: --
813: -- Ensure that the p_datetrack_mode argument is not null
814: --
815: hr_api.mandatory_arg_error

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

846: End If;
847: --
848: End If;
849: --
850: hr_utility.set_location(' Leaving:'||l_proc, 10);
851: Exception
852: When l_integrity_error Then
853: --
854: -- A referential integrity check was violated therefore

Line 857: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');

853: --
854: -- A referential integrity check was violated therefore
855: -- we must error
856: --
857: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
858: hr_utility.set_message_token('TABLE_NAME', l_table_name);
859: hr_utility.raise_error;
860: When Others Then
861: --

Line 858: hr_utility.set_message_token('TABLE_NAME', l_table_name);

854: -- A referential integrity check was violated therefore
855: -- we must error
856: --
857: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
858: hr_utility.set_message_token('TABLE_NAME', l_table_name);
859: hr_utility.raise_error;
860: When Others Then
861: --
862: -- An unhandled or unexpected error has occurred which

Line 859: hr_utility.raise_error;

855: -- we must error
856: --
857: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
858: hr_utility.set_message_token('TABLE_NAME', l_table_name);
859: hr_utility.raise_error;
860: When Others Then
861: --
862: -- An unhandled or unexpected error has occurred which
863: -- we must report

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

861: --
862: -- An unhandled or unexpected error has occurred which
863: -- we must report
864: --
865: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
866: hr_utility.set_message_token('PROCEDURE', l_proc);
867: hr_utility.set_message_token('STEP','15');
868: hr_utility.raise_error;
869: End dt_update_validate;

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

862: -- An unhandled or unexpected error has occurred which
863: -- we must report
864: --
865: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
866: hr_utility.set_message_token('PROCEDURE', l_proc);
867: hr_utility.set_message_token('STEP','15');
868: hr_utility.raise_error;
869: End dt_update_validate;
870: --

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

863: -- we must report
864: --
865: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
866: hr_utility.set_message_token('PROCEDURE', l_proc);
867: hr_utility.set_message_token('STEP','15');
868: hr_utility.raise_error;
869: End dt_update_validate;
870: --
871: -- ----------------------------------------------------------------------------

Line 868: hr_utility.raise_error;

864: --
865: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
866: hr_utility.set_message_token('PROCEDURE', l_proc);
867: hr_utility.set_message_token('STEP','15');
868: hr_utility.raise_error;
869: End dt_update_validate;
870: --
871: -- ----------------------------------------------------------------------------
872: -- |--------------------------< dt_delete_validate >--------------------------|

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

913: l_rows_exist Exception;
914: l_table_name all_tables.table_name%TYPE;
915: --
916: Begin
917: hr_utility.set_location('Entering:'||l_proc, 5);
918: --
919: -- Ensure that the p_datetrack_mode argument is not null
920: --
921: hr_api.mandatory_arg_error

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

950: --
951: --
952: End If;
953: --
954: hr_utility.set_location(' Leaving:'||l_proc, 10);
955: Exception
956: When l_rows_exist Then
957: --
958: -- A referential integrity check was violated therefore

Line 961: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');

957: --
958: -- A referential integrity check was violated therefore
959: -- we must error
960: --
961: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
962: hr_utility.set_message_token('TABLE_NAME', l_table_name);
963: hr_utility.raise_error;
964: When Others Then
965: --

Line 962: hr_utility.set_message_token('TABLE_NAME', l_table_name);

958: -- A referential integrity check was violated therefore
959: -- we must error
960: --
961: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
962: hr_utility.set_message_token('TABLE_NAME', l_table_name);
963: hr_utility.raise_error;
964: When Others Then
965: --
966: -- An unhandled or unexpected error has occurred which

Line 963: hr_utility.raise_error;

959: -- we must error
960: --
961: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
962: hr_utility.set_message_token('TABLE_NAME', l_table_name);
963: hr_utility.raise_error;
964: When Others Then
965: --
966: -- An unhandled or unexpected error has occurred which
967: -- we must report

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

965: --
966: -- An unhandled or unexpected error has occurred which
967: -- we must report
968: --
969: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
970: hr_utility.set_message_token('PROCEDURE', l_proc);
971: hr_utility.set_message_token('STEP','15');
972: hr_utility.raise_error;
973: End dt_delete_validate;

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

966: -- An unhandled or unexpected error has occurred which
967: -- we must report
968: --
969: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
970: hr_utility.set_message_token('PROCEDURE', l_proc);
971: hr_utility.set_message_token('STEP','15');
972: hr_utility.raise_error;
973: End dt_delete_validate;
974: --

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

967: -- we must report
968: --
969: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
970: hr_utility.set_message_token('PROCEDURE', l_proc);
971: hr_utility.set_message_token('STEP','15');
972: hr_utility.raise_error;
973: End dt_delete_validate;
974: --
975: -- ----------------------------------------------------------------------------

Line 972: hr_utility.raise_error;

968: --
969: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
970: hr_utility.set_message_token('PROCEDURE', l_proc);
971: hr_utility.set_message_token('STEP','15');
972: hr_utility.raise_error;
973: End dt_delete_validate;
974: --
975: -- ----------------------------------------------------------------------------
976: -- |---------------------------< insert_validate >----------------------------|

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

984: --
985: l_proc varchar2(72) := g_package||'insert_validate';
986: --
987: Begin
988: hr_utility.set_location('Entering:'||l_proc, 5);
989: --
990: -- Call all supporting business operations
991: --
992: --

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

1055: chk_mx_mtch_amt_and_flag
1056: (p_mx_mtch_amt => p_rec.mx_mtch_amt,
1057: p_no_mx_mtch_amt_flag => p_rec.no_mx_mtch_amt_flag);
1058: --
1059: hr_utility.set_location(' Leaving:'||l_proc, 10);
1060: End insert_validate;
1061: --
1062: -- ----------------------------------------------------------------------------
1063: -- |---------------------------< update_validate >----------------------------|

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

1071: --
1072: l_proc varchar2(72) := g_package||'update_validate';
1073: --
1074: Begin
1075: hr_utility.set_location('Entering:'||l_proc, 5);
1076: --
1077: -- Call all supporting business operations
1078: --
1079: --

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

1151: p_datetrack_mode => p_datetrack_mode,
1152: p_validation_start_date => p_validation_start_date,
1153: p_validation_end_date => p_validation_end_date);
1154: --
1155: hr_utility.set_location(' Leaving:'||l_proc, 10);
1156: End update_validate;
1157: --
1158: -- ----------------------------------------------------------------------------
1159: -- |---------------------------< delete_validate >----------------------------|

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

1167: --
1168: l_proc varchar2(72) := g_package||'delete_validate';
1169: --
1170: Begin
1171: hr_utility.set_location('Entering:'||l_proc, 5);
1172: --
1173: -- Call all supporting business operations
1174: --
1175: dt_delete_validate

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

1177: p_validation_start_date => p_validation_start_date,
1178: p_validation_end_date => p_validation_end_date,
1179: p_mtchg_rt_id => p_rec.mtchg_rt_id);
1180: --
1181: hr_utility.set_location(' Leaving:'||l_proc, 10);
1182: End delete_validate;
1183: --
1184: --
1185: -- ---------------------------------------------------------------------------

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

1204: l_proc varchar2(72) := g_package||'return_legislation_code';
1205: --
1206: begin
1207: --
1208: hr_utility.set_location('Entering:'|| l_proc, 10);
1209: --
1210: -- Ensure that all the mandatory parameter are not null
1211: --
1212: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

1222: close csr_leg_code;
1223: --
1224: -- The primary key is invalid therefore we must error
1225: --
1226: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
1227: hr_utility.raise_error;
1228: --
1229: end if;
1230: --

Line 1227: hr_utility.raise_error;

1223: --
1224: -- The primary key is invalid therefore we must error
1225: --
1226: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
1227: hr_utility.raise_error;
1228: --
1229: end if;
1230: --
1231: close csr_leg_code;

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

1229: end if;
1230: --
1231: close csr_leg_code;
1232: --
1233: hr_utility.set_location(' Leaving:'|| l_proc, 20);
1234: --
1235: return l_legislation_code;
1236: --
1237: end return_legislation_code;