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_DDR_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_ddr_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_dsgn_rqmt_id => p_dsgn_rqmt_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_dsgn_rqmt_id;
78: --
79: -- ----------------------------------------------------------------------------

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

111: l_api_updating boolean;
112: --
113: Begin
114: --
115: hr_utility.set_location('Entering:'||l_proc, 5);
116: --
117: l_api_updating := ben_ddr_shd.api_updating
118: (p_dsgn_rqmt_id => p_dsgn_rqmt_id,
119: p_effective_date => p_effective_date,

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

133: p_effective_date => p_effective_date) then
134: --
135: -- raise error as does not exist as lookup
136: --
137: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
138: hr_utility.raise_error;
139: --
140: end if;
141: --

Line 138: hr_utility.raise_error;

134: --
135: -- raise error as does not exist as lookup
136: --
137: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
138: hr_utility.raise_error;
139: --
140: end if;
141: --
142: end if;

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

140: end if;
141: --
142: end if;
143: --
144: hr_utility.set_location('Leaving:'||l_proc,10);
145: --
146: end chk_dsgn_typ_cd;
147: --
148: -- ----------------------------------------------------------------------------

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

187: l_api_updating boolean;
188: --
189: Begin
190: --
191: hr_utility.set_location('Entering:'||l_proc, 5);
192: --
193: --
194:
195: l_api_updating := ben_ddr_shd.api_updating

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

208: fnd_message.raise_error;
209: end if;
210: --
211: --
212: hr_utility.set_location('Leaving:'||l_proc,10);
213: --
214: end chk_no_mn_dpnts_rqd_or_mn_num;
215: --
216: -- ----------------------------------------------------------------------------

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

255: l_api_updating boolean;
256: --
257: Begin
258: --
259: hr_utility.set_location('Entering:'||l_proc, 5);
260: --
261: --
262:
263: l_api_updating := ben_ddr_shd.api_updating

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

277: end if;
278:
279: --
280: --
281: hr_utility.set_location('Leaving:'||l_proc,10);
282: --
283: end chk_no_mx_dpnts_or_mx_num_alwd;
284: --
285: -- ----------------------------------------------------------------------------

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

317: l_api_updating boolean;
318: --
319: Begin
320: --
321: hr_utility.set_location('Entering:'||l_proc, 5);
322: --
323: l_api_updating := ben_ddr_shd.api_updating
324: (p_dsgn_rqmt_id => p_dsgn_rqmt_id,
325: p_effective_date => p_effective_date,

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

339: p_effective_date => p_effective_date) then
340: --
341: -- raise error as does not exist as lookup
342: --
343: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
344: hr_utility.raise_error;
345: --
346: end if;
347: --

Line 344: hr_utility.raise_error;

340: --
341: -- raise error as does not exist as lookup
342: --
343: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
344: hr_utility.raise_error;
345: --
346: end if;
347: --
348: end if;

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

346: end if;
347: --
348: end if;
349: --
350: hr_utility.set_location('Leaving:'||l_proc,10);
351: --
352: end chk_cvr_all_elig_flag;
353: --
354: -- ----------------------------------------------------------------------------

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

386: l_api_updating boolean;
387: --
388: Begin
389: --
390: hr_utility.set_location('Entering:'||l_proc, 5);
391: --
392: l_api_updating := ben_ddr_shd.api_updating
393: (p_dsgn_rqmt_id => p_dsgn_rqmt_id,
394: p_effective_date => p_effective_date,

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

408: p_effective_date => p_effective_date) then
409: --
410: -- raise error as does not exist as lookup
411: --
412: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
413: hr_utility.raise_error;
414: --
415: end if;
416: --

Line 413: hr_utility.raise_error;

409: --
410: -- raise error as does not exist as lookup
411: --
412: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
413: hr_utility.raise_error;
414: --
415: end if;
416: --
417: end if;

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

415: end if;
416: --
417: end if;
418: --
419: hr_utility.set_location('Leaving:'||l_proc,10);
420: --
421: end chk_no_mx_num_dfnd_flag;
422: --
423: -- ----------------------------------------------------------------------------

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

455: l_api_updating boolean;
456: --
457: Begin
458: --
459: hr_utility.set_location('Entering:'||l_proc, 5);
460: --
461: l_api_updating := ben_ddr_shd.api_updating
462: (p_dsgn_rqmt_id => p_dsgn_rqmt_id,
463: p_effective_date => p_effective_date,

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

477: p_effective_date => p_effective_date) then
478: --
479: -- raise error as does not exist as lookup
480: --
481: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
482: hr_utility.raise_error;
483: --
484: end if;
485: --

Line 482: hr_utility.raise_error;

478: --
479: -- raise error as does not exist as lookup
480: --
481: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
482: hr_utility.raise_error;
483: --
484: end if;
485: --
486: end if;

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

484: end if;
485: --
486: end if;
487: --
488: hr_utility.set_location('Leaving:'||l_proc,10);
489: --
490: end chk_no_mn_num_dfnd_flag;
491: --
492: -- ----------------------------------------------------------------------------

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

524: l_api_updating boolean;
525: --
526: Begin
527: --
528: hr_utility.set_location('Entering:'||l_proc, 5);
529: --
530: l_api_updating := ben_ddr_shd.api_updating
531: (p_dsgn_rqmt_id => p_dsgn_rqmt_id,
532: p_effective_date => p_effective_date,

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

546: p_effective_date => p_effective_date) then
547: --
548: -- raise error as does not exist as lookup
549: --
550: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
551: hr_utility.raise_error;
552: --
553: end if;
554: --

Line 551: hr_utility.raise_error;

547: --
548: -- raise error as does not exist as lookup
549: --
550: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
551: hr_utility.raise_error;
552: --
553: end if;
554: --
555: end if;

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

553: end if;
554: --
555: end if;
556: --
557: hr_utility.set_location('Leaving:'||l_proc,10);
558: --
559: end chk_grp_rlshp_cd;
560: -- ----------------------------------------------------------------------------
561: -- |------------------------< chk_pln_oipl_opt_mutexcl >----------------------|

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

614: and a.effective_end_date;
615: --
616: Begin
617: --
618: hr_utility.set_location('Entering:'||l_proc, 5);
619: --
620: l_api_updating := ben_ddr_shd.api_updating
621: (p_dsgn_rqmt_id => p_dsgn_rqmt_id,
622: p_effective_date => p_effective_date,

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

653: close c1;
654: --
655: end if;
656: --
657: hr_utility.set_location('Leaving:'||l_proc, 10);
658: --
659: End chk_pln_oipl_opt_mutexcl;
660: --
661: -- bug 2837189

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

720: --
721: --
722: Begin
723: --
724: hr_utility.set_location('Entering:'||l_proc, 5);
725: --
726: --
727: -- Check if the record already exists
728: --

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

740:
741: --
742:
743: --
744: hr_utility.set_location('Leaving:'||l_proc, 10);
745: --
746: End chk_dsgn_rqmt_uniq;
747:
748: -- end bug 2837189

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

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

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

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

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 968: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

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

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

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

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

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

Line 971: hr_utility.raise_error;

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

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

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

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

1061: p_pl_id => p_rec.pl_id,
1062: p_oipl_id => p_rec.oipl_id,
1063: p_object_version_number => p_rec.object_version_number ) ;
1064: --
1065: hr_utility.set_location(' Leaving:'||l_proc, 10);
1066: End insert_validate;
1067: --
1068: -- ----------------------------------------------------------------------------
1069: -- |---------------------------< update_validate >----------------------------|

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

1077: --
1078: l_proc varchar2(72) := g_package||'update_validate';
1079: --
1080: Begin
1081: hr_utility.set_location('Entering:'||l_proc, 5);
1082: --
1083: -- Call all supporting business operations
1084: --
1085: --

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

1164: p_datetrack_mode => p_datetrack_mode,
1165: p_validation_start_date => p_validation_start_date,
1166: p_validation_end_date => p_validation_end_date);
1167: --
1168: hr_utility.set_location(' Leaving:'||l_proc, 10);
1169: End update_validate;
1170: --
1171: -- ----------------------------------------------------------------------------
1172: -- |---------------------------< delete_validate >----------------------------|

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

1186: from ben_dsgn_rqmt_rlshp_typ
1187: where dsgn_rqmt_id = p_rec.dsgn_rqmt_id;
1188: --
1189: Begin
1190: hr_utility.set_location('Entering:'||l_proc, 5);
1191: --
1192: --
1193: -- Check for existence of child records in BEN_DSGN_RQMT_RLSHP_TYP
1194: -- table when PURGING.

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

1215: p_validation_start_date => p_validation_start_date,
1216: p_validation_end_date => p_validation_end_date,
1217: p_dsgn_rqmt_id => p_rec.dsgn_rqmt_id);
1218: --
1219: hr_utility.set_location(' Leaving:'||l_proc, 10);
1220: End delete_validate;
1221: --
1222: --
1223: -- ---------------------------------------------------------------------------

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

1242: l_proc varchar2(72) := g_package||'return_legislation_code';
1243: --
1244: begin
1245: --
1246: hr_utility.set_location('Entering:'|| l_proc, 10);
1247: --
1248: -- Ensure that all the mandatory parameter are not null
1249: --
1250: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

1260: close csr_leg_code;
1261: --
1262: -- The primary key is invalid therefore we must error
1263: --
1264: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
1265: hr_utility.raise_error;
1266: --
1267: end if;
1268: --

Line 1265: hr_utility.raise_error;

1261: --
1262: -- The primary key is invalid therefore we must error
1263: --
1264: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
1265: hr_utility.raise_error;
1266: --
1267: end if;
1268: --
1269: close csr_leg_code;

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

1267: end if;
1268: --
1269: close csr_leg_code;
1270: --
1271: hr_utility.set_location(' Leaving:'|| l_proc, 20);
1272: --
1273: return l_legislation_code;
1274: --
1275: end return_legislation_code;