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_PPV_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_ppv_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_prtl_mo_rt_prtn_val_id => p_prtl_mo_rt_prtn_val_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_prtl_mo_rt_prtn_val_id;
78: --
79: procedure chk_dup_prorate_by_day_row(p_effective_date in date,

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

174: l_api_updating boolean;
175: --
176: Begin
177: --
178: hr_utility.set_location('Entering:'||l_proc, 5);
179: --
180: l_api_updating := ben_ppv_shd.api_updating
181: (p_prtl_mo_rt_prtn_val_id => p_prtl_mo_rt_prtn_val_id,
182: p_effective_date => p_effective_date,

Line 200: hr_utility.set_message('BEN','BEN_91041_INVALID_RNDG_CD');

196: p_effective_date => p_effective_date) then
197: --
198: -- raise error as does not exist as lookup
199: --
200: hr_utility.set_message('BEN','BEN_91041_INVALID_RNDG_CD');
201: hr_utility.raise_error;
202: --
203: end if;
204: --

Line 201: hr_utility.raise_error;

197: --
198: -- raise error as does not exist as lookup
199: --
200: hr_utility.set_message('BEN','BEN_91041_INVALID_RNDG_CD');
201: hr_utility.raise_error;
202: --
203: end if;
204: --
205: end if;

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

203: end if;
204: --
205: end if;
206: --
207: hr_utility.set_location('Leaving:'||l_proc,10);
208: --
209: end chk_rndg_cd;
210: --
211: -- ----------------------------------------------------------------------------

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

260: and ff.effective_end_date;
261: --
262: Begin
263: --
264: hr_utility.set_location('Entering:'||l_proc, 5);
265: --
266: l_api_updating := ben_ppv_shd.api_updating
267: (p_prtl_mo_rt_prtn_val_id => p_prtl_mo_rt_prtn_val_id,
268: p_effective_date => p_effective_date,

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

299: close c1;
300: --
301: end if;
302: --
303: hr_utility.set_location('Leaving:'||l_proc,10);
304: --
305: end chk_prtl_mo_prortn_rl;
306: --
307: -- ----------------------------------------------------------------------------

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

348: and ff.effective_end_date;
349: --
350: Begin
351: --
352: hr_utility.set_location('Entering:'||l_proc, 5);
353: --
354: l_api_updating := ben_ppv_shd.api_updating
355: (p_prtl_mo_rt_prtn_val_id => p_prtl_mo_rt_prtn_val_id,
356: p_effective_date => p_effective_date,

Line 379: hr_utility.set_message('BEN','BEN_91042_INVALID_RNDG_RL');

375: close c1;
376: --
377: -- raise error
378: --
379: hr_utility.set_message('BEN','BEN_91042_INVALID_RNDG_RL');
380: hr_utility.raise_error;
381: --
382: end if;
383: --

Line 380: hr_utility.raise_error;

376: --
377: -- raise error
378: --
379: hr_utility.set_message('BEN','BEN_91042_INVALID_RNDG_RL');
380: hr_utility.raise_error;
381: --
382: end if;
383: --
384: close c1;

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

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

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

436: l_proc varchar2(72) := g_package||'chk_rndg_cd_rl';
437: --
438: Begin
439: --
440: hr_utility.set_location('Entering:'||l_proc, 5);
441: --
442: if (p_rndg_cd <> 'RL' and p_rndg_rl is not null)
443: then
444: fnd_message.set_name('BEN', 'BEN_91043_RNDG_RL_NOT_NULL');

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

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

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

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

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

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

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

584: --Bug 6242951
585: and business_group_id = p_business_group_id;
586: Begin
587: --
588: hr_utility.set_location('Entering:'||l_proc, 5);
589: --
590: -- Bug No 4419185
591: --
592: if (p_pct_val <0 or p_pct_val > 100) then

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

620: end if;
621: --
622: -- Leaving Procedure.
623: --
624: hr_utility.set_location('Leaving:'||l_proc,10);
625: --
626: end chk_prortn_rl_pct_val ;
627: --
628: -- ----------------------------------------------------------------------------

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

655: l_proc varchar2(72) := g_package||'chk_from_dt_to_dy';
656: --
657: Begin
658: --
659: hr_utility.set_location('Entering:'||l_proc, 5);
660: --
661: -- check the values
662: -- note: Don't want an error if either one is null
663: --

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

670: fnd_message.raise_error;
671: --
672: end if;
673: --
674: hr_utility.set_location('Leaving:'||l_proc, 5);
675: --
676: end chk_from_dt_to_dy;
677: --
678: -- ---------------------------------------------------------------------------

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

746: and p_validation_end_date >= effective_start_date
747: and business_group_id = p_business_group_id;
748: --
749: Begin
750: hr_utility.set_location('Entering:'||l_proc, 5);
751: --
752: -- Bug 4366086 Added if condition to check that to_dy_mo_num
753: -- field is not greater than num_day_month
754: --

Line 796: hr_utility.set_location('Leaving:'||l_proc, 15);

792: end if;
793: end if;
794: end if;
795: --
796: hr_utility.set_location('Leaving:'||l_proc, 15);
797: End chk_unique_and_not_overlapping;
798: --
799: -- ----------------------------------------------------------------------------
800: -- |--------------------------< dt_update_validate >--------------------------|

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

837: l_integrity_error Exception;
838: l_table_name all_tables.table_name%TYPE;
839: --
840: Begin
841: hr_utility.set_location('Entering:'||l_proc, 5);
842: --
843: -- Ensure that the p_datetrack_mode argument is not null
844: --
845: hr_api.mandatory_arg_error

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

896: End If;
897: --
898: End If;
899: --
900: hr_utility.set_location(' Leaving:'||l_proc, 10);
901: Exception
902: When l_integrity_error Then
903: --
904: -- A referential integrity check was violated therefore

Line 907: hr_utility.set_message('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');

903: --
904: -- A referential integrity check was violated therefore
905: -- we must error
906: --
907: hr_utility.set_message('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
908: hr_utility.set_message_token('TABLE_NAME', l_table_name);
909: hr_utility.raise_error;
910: When Others Then
911: --

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

904: -- A referential integrity check was violated therefore
905: -- we must error
906: --
907: hr_utility.set_message('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
908: hr_utility.set_message_token('TABLE_NAME', l_table_name);
909: hr_utility.raise_error;
910: When Others Then
911: --
912: -- An unhandled or unexpected error has occurred which

Line 909: hr_utility.raise_error;

905: -- we must error
906: --
907: hr_utility.set_message('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
908: hr_utility.set_message_token('TABLE_NAME', l_table_name);
909: hr_utility.raise_error;
910: When Others Then
911: --
912: -- An unhandled or unexpected error has occurred which
913: -- we must report

Line 915: hr_utility.set_message('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

911: --
912: -- An unhandled or unexpected error has occurred which
913: -- we must report
914: --
915: hr_utility.set_message('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
916: hr_utility.set_message_token('PROCEDURE', l_proc);
917: hr_utility.set_message_token('STEP','15');
918: hr_utility.raise_error;
919: End dt_update_validate;

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

912: -- An unhandled or unexpected error has occurred which
913: -- we must report
914: --
915: hr_utility.set_message('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
916: hr_utility.set_message_token('PROCEDURE', l_proc);
917: hr_utility.set_message_token('STEP','15');
918: hr_utility.raise_error;
919: End dt_update_validate;
920: --

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

913: -- we must report
914: --
915: hr_utility.set_message('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
916: hr_utility.set_message_token('PROCEDURE', l_proc);
917: hr_utility.set_message_token('STEP','15');
918: hr_utility.raise_error;
919: End dt_update_validate;
920: --
921: -- ----------------------------------------------------------------------------

Line 918: hr_utility.raise_error;

914: --
915: hr_utility.set_message('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
916: hr_utility.set_message_token('PROCEDURE', l_proc);
917: hr_utility.set_message_token('STEP','15');
918: hr_utility.raise_error;
919: End dt_update_validate;
920: --
921: -- ----------------------------------------------------------------------------
922: -- |--------------------------< dt_delete_validate >--------------------------|

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

963: l_rows_exist Exception;
964: l_table_name all_tables.table_name%TYPE;
965: --
966: Begin
967: hr_utility.set_location('Entering:'||l_proc, 5);
968: --
969: -- Ensure that the p_datetrack_mode argument is not null
970: --
971: hr_api.mandatory_arg_error

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

1000: --
1001: --
1002: End If;
1003: --
1004: hr_utility.set_location(' Leaving:'||l_proc, 10);
1005: Exception
1006: When l_rows_exist Then
1007: --
1008: -- A referential integrity check was violated therefore

Line 1011: hr_utility.set_message('PAY', 'HR_7215_DT_CHILD_EXISTS');

1007: --
1008: -- A referential integrity check was violated therefore
1009: -- we must error
1010: --
1011: hr_utility.set_message('PAY', 'HR_7215_DT_CHILD_EXISTS');
1012: hr_utility.set_message_token('TABLE_NAME', l_table_name);
1013: hr_utility.raise_error;
1014: When Others Then
1015: --

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

1008: -- A referential integrity check was violated therefore
1009: -- we must error
1010: --
1011: hr_utility.set_message('PAY', 'HR_7215_DT_CHILD_EXISTS');
1012: hr_utility.set_message_token('TABLE_NAME', l_table_name);
1013: hr_utility.raise_error;
1014: When Others Then
1015: --
1016: -- An unhandled or unexpected error has occurred which

Line 1013: hr_utility.raise_error;

1009: -- we must error
1010: --
1011: hr_utility.set_message('PAY', 'HR_7215_DT_CHILD_EXISTS');
1012: hr_utility.set_message_token('TABLE_NAME', l_table_name);
1013: hr_utility.raise_error;
1014: When Others Then
1015: --
1016: -- An unhandled or unexpected error has occurred which
1017: -- we must report

Line 1019: hr_utility.set_message('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

1015: --
1016: -- An unhandled or unexpected error has occurred which
1017: -- we must report
1018: --
1019: hr_utility.set_message('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1020: hr_utility.set_message_token('PROCEDURE', l_proc);
1021: hr_utility.set_message_token('STEP','15');
1022: hr_utility.raise_error;
1023: End dt_delete_validate;

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

1016: -- An unhandled or unexpected error has occurred which
1017: -- we must report
1018: --
1019: hr_utility.set_message('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1020: hr_utility.set_message_token('PROCEDURE', l_proc);
1021: hr_utility.set_message_token('STEP','15');
1022: hr_utility.raise_error;
1023: End dt_delete_validate;
1024: --

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

1017: -- we must report
1018: --
1019: hr_utility.set_message('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1020: hr_utility.set_message_token('PROCEDURE', l_proc);
1021: hr_utility.set_message_token('STEP','15');
1022: hr_utility.raise_error;
1023: End dt_delete_validate;
1024: --
1025: -- ----------------------------------------------------------------------------

Line 1022: hr_utility.raise_error;

1018: --
1019: hr_utility.set_message('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1020: hr_utility.set_message_token('PROCEDURE', l_proc);
1021: hr_utility.set_message_token('STEP','15');
1022: hr_utility.raise_error;
1023: End dt_delete_validate;
1024: --
1025: -- ----------------------------------------------------------------------------
1026: -- |---------------------------< insert_validate >----------------------------|

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

1034: --
1035: l_proc varchar2(72) := g_package||'insert_validate';
1036: --
1037: Begin
1038: hr_utility.set_location('Entering:'||l_proc, 5);
1039: --
1040: -- Call all supporting business operations
1041: --
1042: --

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

1110: p_effective_date => p_effective_date,
1111: p_validation_start_date => p_validation_start_date, -- Bug No 4366086
1112: p_validation_end_date => p_validation_end_date); -- Bug No 4366086
1113: --
1114: hr_utility.set_location(' Leaving:'||l_proc, 10);
1115: End insert_validate;
1116: --
1117: -- ----------------------------------------------------------------------------
1118: -- |---------------------------< update_validate >----------------------------|

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

1126: --
1127: l_proc varchar2(72) := g_package||'update_validate';
1128: --
1129: Begin
1130: hr_utility.set_location('Entering:'||l_proc, 5);
1131: --
1132: -- Call all supporting business operations
1133: --
1134: --

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

1213: p_datetrack_mode => p_datetrack_mode,
1214: p_validation_start_date => p_validation_start_date,
1215: p_validation_end_date => p_validation_end_date);
1216: --
1217: hr_utility.set_location(' Leaving:'||l_proc, 10);
1218: End update_validate;
1219: --
1220: -- ----------------------------------------------------------------------------
1221: -- |---------------------------< delete_validate >----------------------------|

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

1229: --
1230: l_proc varchar2(72) := g_package||'delete_validate';
1231: --
1232: Begin
1233: hr_utility.set_location('Entering:'||l_proc, 5);
1234: --
1235: -- Call all supporting business operations
1236: --
1237: dt_delete_validate

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

1239: p_validation_start_date => p_validation_start_date,
1240: p_validation_end_date => p_validation_end_date,
1241: p_prtl_mo_rt_prtn_val_id => p_rec.prtl_mo_rt_prtn_val_id);
1242: --
1243: hr_utility.set_location(' Leaving:'||l_proc, 10);
1244: End delete_validate;
1245: --
1246: --
1247: -- ---------------------------------------------------------------------------

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

1266: l_proc varchar2(72) := g_package||'return_legislation_code';
1267: --
1268: begin
1269: --
1270: hr_utility.set_location('Entering:'|| l_proc, 10);
1271: --
1272: -- Ensure that all the mandatory parameter are not null
1273: --
1274: hr_api.mandatory_arg_error(p_api_name => l_proc,

Line 1288: hr_utility.set_message('PAY','HR_7220_INVALID_PRIMARY_KEY');

1284: close csr_leg_code;
1285: --
1286: -- The primary key is invalid therefore we must error
1287: --
1288: hr_utility.set_message('PAY','HR_7220_INVALID_PRIMARY_KEY');
1289: hr_utility.raise_error;
1290: --
1291: end if;
1292: --

Line 1289: hr_utility.raise_error;

1285: --
1286: -- The primary key is invalid therefore we must error
1287: --
1288: hr_utility.set_message('PAY','HR_7220_INVALID_PRIMARY_KEY');
1289: hr_utility.raise_error;
1290: --
1291: end if;
1292: --
1293: close csr_leg_code;

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

1291: end if;
1292: --
1293: close csr_leg_code;
1294: --
1295: hr_utility.set_location(' Leaving:'|| l_proc, 20);
1296: --
1297: return l_legislation_code;
1298: --
1299: end return_legislation_code;