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_SHR_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_shr_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_schedd_hrs_rt_id => p_schedd_hrs_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_schedd_hrs_rt_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_shr_shd.api_updating
118: (p_schedd_hrs_rt_id => p_schedd_hrs_rt_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_freq_cd;
147:
148:

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

191: and ordr_num = p_ordr_num
192: and business_group_id = p_business_group_id;
193: --
194: Begin
195: hr_utility.set_location('Entering:'||l_proc, 5);
196: --
197: open c1;
198: fetch c1 into l_dummy;
199: if c1%found then

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

202: fnd_message.raise_error;
203: end if;
204: close c1;
205: --
206: hr_utility.set_location('Leaving:'||l_proc, 15);
207: End chk_duplicate_ordr_num;
208: --
209:
210: --

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

270: and p_validation_end_date >= effective_start_date;
271: --
272: BEGIN
273: --
274: hr_utility.set_location('Entering:'||l_proc, 5);
275: --
276: l_api_updating := ben_shr_shd.api_updating
277: (p_schedd_hrs_rt_id => p_schedd_hrs_rt_id,
278: p_effective_date => p_effective_date,

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

300: end if;
301: close c_dup;
302: --
303: end if;
304: hr_utility.set_location('Leaving:'||l_proc,10);
305: --
306: END chk_dup_record;
307: --
308:

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

341: l_api_updating boolean;
342: --
343: Begin
344: --
345: hr_utility.set_location('Entering:'||l_proc, 5);
346: --
347: l_api_updating := ben_shr_shd.api_updating
348: (p_schedd_hrs_rt_id => p_schedd_hrs_rt_id,
349: p_effective_date => p_effective_date,

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

363: p_effective_date => p_effective_date) then
364: --
365: -- raise error as does not exist as lookup
366: --
367: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
368: hr_utility.raise_error;
369: --
370: end if;
371: --

Line 368: hr_utility.raise_error;

364: --
365: -- raise error as does not exist as lookup
366: --
367: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
368: hr_utility.raise_error;
369: --
370: end if;
371: --
372: end if;

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

370: end if;
371: --
372: end if;
373: --
374: hr_utility.set_location('Leaving:'||l_proc,10);
375: --
376: end chk_excld_flag;
377: --
378: -- ----------------------------------------------------------------------------

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

414: l_integrity_error Exception;
415: l_table_name all_tables.table_name%TYPE;
416: --
417: Begin
418: hr_utility.set_location('Entering:'||l_proc, 5);
419: --
420: -- Ensure that the p_datetrack_mode argument is not null
421: --
422: hr_api.mandatory_arg_error

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

453: End If;
454: --
455: End If;
456: --
457: hr_utility.set_location(' Leaving:'||l_proc, 10);
458: Exception
459: When l_integrity_error Then
460: --
461: -- A referential integrity check was violated therefore

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

460: --
461: -- A referential integrity check was violated therefore
462: -- we must error
463: --
464: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
465: hr_utility.set_message_token('TABLE_NAME', l_table_name);
466: hr_utility.raise_error;
467: When Others Then
468: --

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

461: -- A referential integrity check was violated therefore
462: -- we must error
463: --
464: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
465: hr_utility.set_message_token('TABLE_NAME', l_table_name);
466: hr_utility.raise_error;
467: When Others Then
468: --
469: -- An unhandled or unexpected error has occurred which

Line 466: hr_utility.raise_error;

462: -- we must error
463: --
464: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
465: hr_utility.set_message_token('TABLE_NAME', l_table_name);
466: hr_utility.raise_error;
467: When Others Then
468: --
469: -- An unhandled or unexpected error has occurred which
470: -- we must report

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

468: --
469: -- An unhandled or unexpected error has occurred which
470: -- we must report
471: --
472: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
473: hr_utility.set_message_token('PROCEDURE', l_proc);
474: hr_utility.set_message_token('STEP','15');
475: hr_utility.raise_error;
476: End dt_update_validate;

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

469: -- An unhandled or unexpected error has occurred which
470: -- we must report
471: --
472: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
473: hr_utility.set_message_token('PROCEDURE', l_proc);
474: hr_utility.set_message_token('STEP','15');
475: hr_utility.raise_error;
476: End dt_update_validate;
477: --

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

470: -- we must report
471: --
472: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
473: hr_utility.set_message_token('PROCEDURE', l_proc);
474: hr_utility.set_message_token('STEP','15');
475: hr_utility.raise_error;
476: End dt_update_validate;
477: --
478: -- ----------------------------------------------------------------------------

Line 475: hr_utility.raise_error;

471: --
472: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
473: hr_utility.set_message_token('PROCEDURE', l_proc);
474: hr_utility.set_message_token('STEP','15');
475: hr_utility.raise_error;
476: End dt_update_validate;
477: --
478: -- ----------------------------------------------------------------------------
479: -- |--------------------------< dt_delete_validate >--------------------------|

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

520: l_rows_exist Exception;
521: l_table_name all_tables.table_name%TYPE;
522: --
523: Begin
524: hr_utility.set_location('Entering:'||l_proc, 5);
525: --
526: -- Ensure that the p_datetrack_mode argument is not null
527: --
528: hr_api.mandatory_arg_error

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

557: --
558: --
559: End If;
560: --
561: hr_utility.set_location(' Leaving:'||l_proc, 10);
562: Exception
563: When l_rows_exist Then
564: --
565: -- A referential integrity check was violated therefore

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

564: --
565: -- A referential integrity check was violated therefore
566: -- we must error
567: --
568: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
569: hr_utility.set_message_token('TABLE_NAME', l_table_name);
570: hr_utility.raise_error;
571: When Others Then
572: --

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

565: -- A referential integrity check was violated therefore
566: -- we must error
567: --
568: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
569: hr_utility.set_message_token('TABLE_NAME', l_table_name);
570: hr_utility.raise_error;
571: When Others Then
572: --
573: -- An unhandled or unexpected error has occurred which

Line 570: hr_utility.raise_error;

566: -- we must error
567: --
568: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
569: hr_utility.set_message_token('TABLE_NAME', l_table_name);
570: hr_utility.raise_error;
571: When Others Then
572: --
573: -- An unhandled or unexpected error has occurred which
574: -- we must report

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

572: --
573: -- An unhandled or unexpected error has occurred which
574: -- we must report
575: --
576: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
577: hr_utility.set_message_token('PROCEDURE', l_proc);
578: hr_utility.set_message_token('STEP','15');
579: hr_utility.raise_error;
580: End dt_delete_validate;

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

573: -- An unhandled or unexpected error has occurred which
574: -- we must report
575: --
576: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
577: hr_utility.set_message_token('PROCEDURE', l_proc);
578: hr_utility.set_message_token('STEP','15');
579: hr_utility.raise_error;
580: End dt_delete_validate;
581:

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

574: -- we must report
575: --
576: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
577: hr_utility.set_message_token('PROCEDURE', l_proc);
578: hr_utility.set_message_token('STEP','15');
579: hr_utility.raise_error;
580: End dt_delete_validate;
581:
582: -- Enhancements done to include new fields

Line 579: hr_utility.raise_error;

575: --
576: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
577: hr_utility.set_message_token('PROCEDURE', l_proc);
578: hr_utility.set_message_token('STEP','15');
579: hr_utility.raise_error;
580: End dt_delete_validate;
581:
582: -- Enhancements done to include new fields
583: -- ----------------------------------------------------------------------------

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

618: l_proc varchar2(72) := g_package||'check_min_or_max';
619: l_api_updating boolean;
620: --
621: Begin
622: hr_utility.set_location('Entering:'||l_proc, 5);
623:
624: l_api_updating := ben_shr_shd.api_updating
625: (p_schedd_hrs_rt_id => p_schedd_hrs_rt_id,
626: p_effective_date => p_effective_date,

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

653: end if;
654: end if;
655: end if;
656: --
657: hr_utility.set_location(' Leaving:'||l_proc, 10);
658: End check_min_or_max;
659:
660: -- ----------------------------------------------------------------------------
661: -- |---------------------------< match_formula_type >-------------------------|

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

703: and ff.business_group_id = p_business_group_id
704: and ff.formula_type_id = p_formula_type_id;
705: --
706: Begin
707: hr_utility.set_location(' Entering:'||l_proc, 10);
708: --
709: If (p_rl is null) then
710: return false;
711: End if;

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

717: return false;
718: End If;
719: Close c_rule;
720: --
721: hr_utility.set_location(' Leaving:'||l_proc, 10);
722: return true;
723: End match_formula_type;
724: --
725: -- ----------------------------------------------------------------------------

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

758: l_api_updating boolean;
759:
760: --
761: Begin
762: hr_utility.set_location('Entering:'||l_proc, 5);
763: --
764: l_api_updating := ben_shr_shd.api_updating
765: (p_schedd_hrs_rt_id => p_schedd_hrs_rt_id,
766: p_effective_date => p_effective_date,

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

782: End If;
783: --
784: End If;
785: --
786: hr_utility.set_location(' Leaving:'||l_proc, 10);
787: End check_schedd_hrs_rl;
788: --
789: -- ----------------------------------------------------------------------------
790: -- |---------------------------< check_determination_cd >-------------------------|

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

819: l_api_updating boolean;
820:
821: --
822: Begin
823: hr_utility.set_location('Entering:'||l_proc, 5);
824: --
825: l_api_updating := ben_shr_shd.api_updating
826: (p_schedd_hrs_rt_id => p_schedd_hrs_rt_id,
827: p_effective_date => p_effective_date,

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

844: end if;
845: end if;
846: end if;
847:
848: hr_utility.set_location(' Leaving:'||l_proc, 10);
849: End check_determination_cd;
850: --
851: -- ----------------------------------------------------------------------------
852: -- |---------------------------< check_determination_rl >-------------------------|

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

885: l_api_updating boolean;
886:
887: --
888: Begin
889: hr_utility.set_location('Entering:'||l_proc, 5);
890:
891: l_api_updating := ben_shr_shd.api_updating
892: (p_schedd_hrs_rt_id => p_schedd_hrs_rt_id,
893: p_effective_date => p_effective_date,

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

916: fnd_message.raise_error;
917: end if;
918: End if;
919: End if;
920: hr_utility.set_location(' Leaving:'||l_proc, 10);
921: End check_determination_rl;
922: --
923: -- ----------------------------------------------------------------------------
924: -- |---------------------------< check_rounding_cd >-------------------------|

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

953: l_api_updating boolean;
954:
955: --
956: Begin
957: hr_utility.set_location('Entering:'||l_proc, 5);
958: --
959: l_api_updating := ben_shr_shd.api_updating
960: (p_schedd_hrs_rt_id => p_schedd_hrs_rt_id,
961: p_effective_date => p_effective_date,

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

978: end if;
979: end if;
980: End if;
981:
982: hr_utility.set_location(' Leaving:'||l_proc, 10);
983:
984: End check_rounding_cd;
985: --
986: -- ----------------------------------------------------------------------------

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

1018: l_proc varchar2(72) := g_package||'check_rounding_rl';
1019: l_api_updating boolean;
1020:
1021: Begin
1022: hr_utility.set_location('Entering:'||l_proc, 5);
1023: --
1024: l_api_updating := ben_shr_shd.api_updating
1025: (p_schedd_hrs_rt_id => p_schedd_hrs_rt_id,
1026: p_effective_date => p_effective_date,

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

1050: end if;
1051: End if;
1052: End if;
1053: --
1054: hr_utility.set_location(' Leaving:'||l_proc, 10);
1055: End check_rounding_rl;
1056: --
1057: -- Enhancements done to include new fields
1058: --

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

1070: l_api_updating boolean;
1071:
1072: --
1073: Begin
1074: hr_utility.set_location('Entering:'||l_proc, 5);
1075: --
1076: -- Call all supporting business operations
1077: --
1078: --

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

1165: p_object_version_number => p_rec.object_version_number);
1166:
1167:
1168: --
1169: hr_utility.set_location(' Leaving:'||l_proc, 10);
1170:
1171: End insert_validate;
1172: --
1173: -- ----------------------------------------------------------------------------

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

1182: --
1183: l_proc varchar2(72) := g_package||'update_validate';
1184: --
1185: Begin
1186: hr_utility.set_location('Entering:'||l_proc, 5);
1187: --
1188: -- Call all supporting business operations
1189: --
1190: --

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

1282: p_validation_start_date => p_validation_start_date,
1283: p_validation_end_date => p_validation_end_date);
1284: --
1285:
1286: hr_utility.set_location(' Leaving:'||l_proc, 10);
1287: End update_validate;
1288: --
1289: -- ----------------------------------------------------------------------------
1290: -- |---------------------------< delete_validate >----------------------------|

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

1298: --
1299: l_proc varchar2(72) := g_package||'delete_validate';
1300: --
1301: Begin
1302: hr_utility.set_location('Entering:'||l_proc, 5);
1303: --
1304: -- Call all supporting business operations
1305: --
1306: dt_delete_validate

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

1308: p_validation_start_date => p_validation_start_date,
1309: p_validation_end_date => p_validation_end_date,
1310: p_schedd_hrs_rt_id => p_rec.schedd_hrs_rt_id);
1311: --
1312: hr_utility.set_location(' Leaving:'||l_proc, 10);
1313: End delete_validate;
1314: --
1315: --
1316: -- ---------------------------------------------------------------------------

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

1335: l_proc varchar2(72) := g_package||'return_legislation_code';
1336: --
1337: begin
1338: --
1339: hr_utility.set_location('Entering:'|| l_proc, 10);
1340: --
1341: -- Ensure that all the mandatory parameter are not null
1342: --
1343: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

1353: close csr_leg_code;
1354: --
1355: -- The primary key is invalid therefore we must error
1356: --
1357: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
1358: hr_utility.raise_error;
1359: --
1360: end if;
1361: --

Line 1358: hr_utility.raise_error;

1354: --
1355: -- The primary key is invalid therefore we must error
1356: --
1357: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
1358: hr_utility.raise_error;
1359: --
1360: end if;
1361: --
1362: close csr_leg_code;

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

1360: end if;
1361: --
1362: close csr_leg_code;
1363: --
1364: hr_utility.set_location(' Leaving:'|| l_proc, 20);
1365: --
1366: return l_legislation_code;
1367: --
1368: end return_legislation_code;