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_OPT_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_opt_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_opt_id => p_opt_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_opt_id;
78:
79:

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

109: l_proc varchar2(72) := g_package||'chk_opt_group_child';
110:
111: Begin
112:
113: hr_utility.set_location('Entering:'||l_proc, 5);
114:
115: l_opt_typ_cd := p_opt_typ_cd ;
116: if p_opt_typ_cd is null then
117: open c_opt_cwb ;

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

129: end if ;
130: close c_child_exist ;
131: end if ;
132: --
133: hr_utility.set_location('Leaving:'||l_proc, 10);
134: --
135:
136: end chk_opt_group_child ;
137:

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

175:
176: --
177: Begin
178: --
179: hr_utility.set_location('Entering:'||l_proc, 5);
180: hr_utility.set_location('p_group_opt_id:'||p_group_opt_id, 5);
181:
182: -- if the plan type is cwb and group_pl_id null throw the error
183: /* removed the validation as per ty

Line 180: hr_utility.set_location('p_group_opt_id:'||p_group_opt_id, 5);

176: --
177: Begin
178: --
179: hr_utility.set_location('Entering:'||l_proc, 5);
180: hr_utility.set_location('p_group_opt_id:'||p_group_opt_id, 5);
181:
182: -- if the plan type is cwb and group_pl_id null throw the error
183: /* removed the validation as per ty
184: open c_opt_cwb ;

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

232: p_opt_typ_cd => 'CWB' ,
233: p_effective_date => p_effective_date) ;
234: end if ;
235: --
236: hr_utility.set_location('Leaving:'||l_proc, 10);
237: --
238: End chk_opt_group_id;
239:
240:

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

274: l_api_updating boolean;
275: --
276: Begin
277: --
278: hr_utility.set_location('Entering:'||l_proc, 5);
279: --
280: l_api_updating := ben_opt_shd.api_updating
281: (p_opt_id => p_opt_id,
282: p_effective_date => p_effective_date,

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

296: p_effective_date => p_effective_date) then
297: --
298: -- raise error as does not exist as lookup
299: --
300: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
301: hr_utility.raise_error;
302: --
303: end if;
304: --

Line 301: hr_utility.raise_error;

297: --
298: -- raise error as does not exist as lookup
299: --
300: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
301: hr_utility.raise_error;
302: --
303: end if;
304: --
305: end if;

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

303: end if;
304: --
305: end if;
306: --
307: hr_utility.set_location('Leaving:'||l_proc,10);
308: --
309: end chk_invk_wv_opt_flag;
310: --
311: -- ----------------------------------------------------------------------------

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

360: and ff.effective_end_date;
361: --
362: Begin
363: --
364: hr_utility.set_location('Entering:'||l_proc, 5);
365: --
366: l_api_updating := ben_opt_shd.api_updating
367: (p_opt_id => p_opt_id,
368: p_effective_date => p_effective_date,

Line 391: hr_utility.set_message(801,'FORMULA_DOES_NOT_EXIST');

387: close c1;
388: --
389: -- raise error
390: --
391: hr_utility.set_message(801,'FORMULA_DOES_NOT_EXIST');
392: hr_utility.raise_error;
393: --
394: end if;
395: --

Line 392: hr_utility.raise_error;

388: --
389: -- raise error
390: --
391: hr_utility.set_message(801,'FORMULA_DOES_NOT_EXIST');
392: hr_utility.raise_error;
393: --
394: end if;
395: --
396: close c1;

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

396: close c1;
397: --
398: end if;
399: --
400: hr_utility.set_location('Leaving:'||l_proc,10);
401: --
402: end chk_rqd_perd_enrt_nenrt_rl;
403: --
404: -- ----------------------------------------------------------------------------

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

436: l_api_updating boolean;
437: --
438: Begin
439: --
440: hr_utility.set_location('Entering:'||l_proc, 5);
441: --
442: l_api_updating := ben_opt_shd.api_updating
443: (p_opt_id => p_opt_id,
444: p_effective_date => p_effective_date,

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

465: end if;
466: --
467: end if;
468: --
469: hr_utility.set_location('Leaving:'||l_proc,10);
470: --
471: end chk_rqd_perd_enrt_nenrt_uom;
472: --
473: -- ----------------------------------------------------------------------------

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

521: and p_validation_end_date >= effective_start_date;
522: --
523: Begin
524: --
525: hr_utility.set_location('Entering:'||l_proc, 5);
526: --
527: -- check if this name already exist
528: --
529: open csr_name;

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

540: --
541: close csr_name;
542: --
543: --
544: hr_utility.set_location('Leaving:'||l_proc, 20);
545: --
546: End chk_name;
547: --
548:

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

581: l_api_updating boolean;
582: --
583: Begin
584: --
585: hr_utility.set_location('Entering:'||l_proc, 5);
586: --
587: l_api_updating := ben_opt_shd.api_updating
588: (p_opt_id => p_opt_id,
589: p_effective_date => p_effective_date,

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

610: end if;
611: --
612: end if;
613: --
614: hr_utility.set_location('Leaving:'||l_proc,10);
615: --
616: end chk_comp_reason;
617: --
618: -- ----------------------------------------------------------------------------

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

650: l_api_updating boolean;
651: --
652: Begin
653: --
654: hr_utility.set_location('Entering:'||l_proc, 5);
655: --
656: l_api_updating := ben_opt_shd.api_updating
657: (p_opt_id => p_opt_id,
658: p_effective_date => p_effective_date,

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

682: end if;
683: --
684: end if;
685: --
686: hr_utility.set_location('Leaving:'||l_proc,10);
687: --
688: end chk_mapping_table_name;
689: --
690: -- ----------------------------------------------------------------------------

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

731: and spt.business_group_id = p_business_group_id;
732: --
733: Begin
734: --
735: hr_utility.set_location('Entering:'||l_proc, 5);
736: --
737: l_api_updating := ben_opt_shd.api_updating
738: (p_opt_id => p_opt_id,
739: p_effective_date => p_effective_date,

Line 764: hr_utility.set_message(805,'BEN_93322_INV_SPINAL_POINT_ID');

760: close c_per_spinal_points;
761: --
762: -- raise error
763: --
764: hr_utility.set_message(805,'BEN_93322_INV_SPINAL_POINT_ID');
765: hr_utility.raise_error;
766: --
767: end if;
768: --

Line 765: hr_utility.raise_error;

761: --
762: -- raise error
763: --
764: hr_utility.set_message(805,'BEN_93322_INV_SPINAL_POINT_ID');
765: hr_utility.raise_error;
766: --
767: end if;
768: --
769: close c_per_spinal_points;

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

770: --
771: end if;
772: end if;
773: --
774: hr_utility.set_location('Leaving:'||l_proc,10);
775: --
776: end chk_mapping_table_pk_id;
777: --
778: --

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

830: and p_validation_end_date >= effective_start_date;
831: --
832: Begin
833: --
834: hr_utility.set_location('Entering:'||l_proc, 5);
835: --
836: -- check if this mapping already exists
837: --
838: open csr_mapping;

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

848: --
849: close csr_mapping;
850: --
851: --
852: hr_utility.set_location('Leaving:'||l_proc, 20);
853: --
854: End chk_mapping_unique;
855: --
856: -- ----------------------------------------------------------------------------

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

892: l_integrity_error Exception;
893: l_table_name all_tables.table_name%TYPE;
894: --
895: Begin
896: hr_utility.set_location('Entering:'||l_proc, 5);
897: --
898: -- Ensure that the p_datetrack_mode argument is not null
899: --
900: hr_api.mandatory_arg_error

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

931: End If;*/
932: --
933: End If;
934: --
935: hr_utility.set_location(' Leaving:'||l_proc, 10);
936: Exception
937: When l_integrity_error Then
938: --
939: -- A referential integrity check was violated therefore

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

944: --
945: -- An unhandled or unexpected error has occurred which
946: -- we must report
947: --
948: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
949: hr_utility.set_message_token('PROCEDURE', l_proc);
950: hr_utility.set_message_token('STEP','15');
951: hr_utility.raise_error;
952: End dt_update_validate;

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

945: -- An unhandled or unexpected error has occurred which
946: -- we must report
947: --
948: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
949: hr_utility.set_message_token('PROCEDURE', l_proc);
950: hr_utility.set_message_token('STEP','15');
951: hr_utility.raise_error;
952: End dt_update_validate;
953: --

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

946: -- we must report
947: --
948: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
949: hr_utility.set_message_token('PROCEDURE', l_proc);
950: hr_utility.set_message_token('STEP','15');
951: hr_utility.raise_error;
952: End dt_update_validate;
953: --
954: -- ----------------------------------------------------------------------------

Line 951: hr_utility.raise_error;

947: --
948: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
949: hr_utility.set_message_token('PROCEDURE', l_proc);
950: hr_utility.set_message_token('STEP','15');
951: hr_utility.raise_error;
952: End dt_update_validate;
953: --
954: -- ----------------------------------------------------------------------------
955: -- |--------------------------< dt_delete_validate >--------------------------|

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

997: l_rows_exist Exception;
998: l_table_name all_tables.table_name%TYPE;
999: --
1000: Begin
1001: hr_utility.set_location('Entering:'||l_proc, 5);
1002: --
1003: -- Ensure that the p_datetrack_mode argument is not null
1004: --
1005: hr_api.mandatory_arg_error

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

1069: End If;
1070: --
1071: End If;
1072: --
1073: hr_utility.set_location(' Leaving:'||l_proc, 10);
1074: Exception
1075: When l_rows_exist Then
1076: --
1077: -- A referential integrity check was violated therefore

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

1085: --
1086: -- An unhandled or unexpected error has occurred which
1087: -- we must report
1088: --
1089: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1090: hr_utility.set_message_token('PROCEDURE', l_proc);
1091: hr_utility.set_message_token('STEP','15');
1092: hr_utility.raise_error;
1093: End dt_delete_validate;

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

1086: -- An unhandled or unexpected error has occurred which
1087: -- we must report
1088: --
1089: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1090: hr_utility.set_message_token('PROCEDURE', l_proc);
1091: hr_utility.set_message_token('STEP','15');
1092: hr_utility.raise_error;
1093: End dt_delete_validate;
1094: --

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

1087: -- we must report
1088: --
1089: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1090: hr_utility.set_message_token('PROCEDURE', l_proc);
1091: hr_utility.set_message_token('STEP','15');
1092: hr_utility.raise_error;
1093: End dt_delete_validate;
1094: --
1095: -- ----------------------------------------------------------------------------

Line 1092: hr_utility.raise_error;

1088: --
1089: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1090: hr_utility.set_message_token('PROCEDURE', l_proc);
1091: hr_utility.set_message_token('STEP','15');
1092: hr_utility.raise_error;
1093: End dt_delete_validate;
1094: --
1095: -- ----------------------------------------------------------------------------
1096: -- |---------------------------< insert_validate >----------------------------|

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

1104: --
1105: l_proc varchar2(72) := g_package||'insert_validate';
1106: --
1107: Begin
1108: hr_utility.set_location('Entering:'||l_proc, 5);
1109: --
1110: -- Call all supporting business operations
1111: --
1112: --

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

1176: p_effective_date => p_effective_date,
1177: p_name => p_rec.name
1178: );
1179: --
1180: hr_utility.set_location(' Leaving:'||l_proc, 10);
1181: End insert_validate;
1182: --
1183: -- ----------------------------------------------------------------------------
1184: -- |---------------------------< update_validate >----------------------------|

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

1192: --
1193: l_proc varchar2(72) := g_package||'update_validate';
1194: --
1195: Begin
1196: hr_utility.set_location('Entering:'||l_proc, 5);
1197: --
1198: -- Call all supporting business operations
1199: --
1200: --

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

1273: p_datetrack_mode => p_datetrack_mode,
1274: p_validation_start_date => p_validation_start_date,
1275: p_validation_end_date => p_validation_end_date);
1276: --
1277: hr_utility.set_location(' Leaving:'||l_proc, 10);
1278: End update_validate;
1279: --
1280: -- ----------------------------------------------------------------------------
1281: -- |---------------------------< delete_validate >----------------------------|

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

1300: AND p_effective_date BETWEEN opt.effective_start_date
1301: AND opt.effective_end_date;
1302: --
1303: Begin
1304: hr_utility.set_location('Entering:'||l_proc, 5);
1305: --
1306: -- Bug 4057566
1307: --
1308: open c_opt_name ;

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

1329: p_opt_id => p_rec.opt_id);
1330:
1331:
1332: --
1333: hr_utility.set_location(' Leaving:'||l_proc, 10);
1334: End delete_validate;
1335: --
1336: --
1337: -- ---------------------------------------------------------------------------

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

1357: l_proc varchar2(72) := g_package||'return_legislation_code';
1358: --
1359: begin
1360: --
1361: hr_utility.set_location('Entering:'|| l_proc, 10);
1362: --
1363: -- Ensure that all the mandatory parameter are not null
1364: --
1365: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

1376: close csr_leg_code;
1377: --
1378: -- The primary key is invalid therefore we must error
1379: --
1380: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
1381: hr_utility.raise_error;
1382: --
1383: end if;
1384: --

Line 1381: hr_utility.raise_error;

1377: --
1378: -- The primary key is invalid therefore we must error
1379: --
1380: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
1381: hr_utility.raise_error;
1382: --
1383: end if;
1384: --
1385: close csr_leg_code;

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

1383: end if;
1384: --
1385: close csr_leg_code;
1386: --
1387: hr_utility.set_location(' Leaving:'|| l_proc, 20);
1388: --
1389: return l_legislation_code;
1390:
1391: --