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_PRD_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_prd_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_paird_rt_id => p_paird_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_paird_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_prd_shd.api_updating
118: (p_paird_rt_id => p_paird_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_no_cmbnd_mn_amt_dfnd_flag;
147: --
148: -- ----------------------------------------------------------------------------

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

180: l_api_updating boolean;
181: --
182: Begin
183: --
184: hr_utility.set_location('Entering:'||l_proc, 5);
185: --
186: l_api_updating := ben_prd_shd.api_updating
187: (p_paird_rt_id => p_paird_rt_id,
188: p_effective_date => p_effective_date,

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

202: p_effective_date => p_effective_date) then
203: --
204: -- raise error as does not exist as lookup
205: --
206: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
207: hr_utility.raise_error;
208: --
209: end if;
210: --

Line 207: hr_utility.raise_error;

203: --
204: -- raise error as does not exist as lookup
205: --
206: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
207: hr_utility.raise_error;
208: --
209: end if;
210: --
211: end if;

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

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

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

249: l_api_updating boolean;
250: --
251: Begin
252: --
253: hr_utility.set_location('Entering:'||l_proc, 5);
254: --
255: l_api_updating := ben_prd_shd.api_updating
256: (p_paird_rt_id => p_paird_rt_id,
257: p_effective_date => p_effective_date,

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

271: p_effective_date => p_effective_date) then
272: --
273: -- raise error as does not exist as lookup
274: --
275: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
276: hr_utility.raise_error;
277: --
278: end if;
279: --

Line 276: hr_utility.raise_error;

272: --
273: -- raise error as does not exist as lookup
274: --
275: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
276: hr_utility.raise_error;
277: --
278: end if;
279: --
280: end if;

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

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

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

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

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

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

Line 345: hr_utility.raise_error;

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

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

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

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

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

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

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

Line 414: hr_utility.raise_error;

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

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

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

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

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

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

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

Line 483: hr_utility.raise_error;

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

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

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

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

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

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

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

Line 552: hr_utility.raise_error;

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

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

554: end if;
555: --
556: end if;
557: --
558: hr_utility.set_location('Leaving:'||l_proc,10);
559: --
560: end chk_use_parnt_ded_sched_flag;
561: --
562: -- ----------------------------------------------------------------------------

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

594: l_api_updating boolean;
595: --
596: Begin
597: --
598: hr_utility.set_location('Entering:'||l_proc, 5);
599: --
600: l_api_updating := ben_prd_shd.api_updating
601: (p_paird_rt_id => p_paird_rt_id,
602: p_effective_date => p_effective_date,

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

616: p_effective_date => p_effective_date) then
617: --
618: -- raise error as does not exist as lookup
619: --
620: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
621: hr_utility.raise_error;
622: --
623: end if;
624: --

Line 621: hr_utility.raise_error;

617: --
618: -- raise error as does not exist as lookup
619: --
620: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
621: hr_utility.raise_error;
622: --
623: end if;
624: --
625: end if;

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

623: end if;
624: --
625: end if;
626: --
627: hr_utility.set_location('Leaving:'||l_proc,10);
628: --
629: end chk_no_cmbnd_mx_pct_dfnd_flag;
630: --
631: -- ----------------------------------------------------------------------------

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

663: l_api_updating boolean;
664: --
665: Begin
666: --
667: hr_utility.set_location('Entering:'||l_proc, 5);
668: --
669: l_api_updating := ben_prd_shd.api_updating
670: (p_paird_rt_id => p_paird_rt_id,
671: p_effective_date => p_effective_date,

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

685: p_effective_date => p_effective_date) then
686: --
687: -- raise error as does not exist as lookup
688: --
689: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
690: hr_utility.raise_error;
691: --
692: end if;
693: --

Line 690: hr_utility.raise_error;

686: --
687: -- raise error as does not exist as lookup
688: --
689: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
690: hr_utility.raise_error;
691: --
692: end if;
693: --
694: end if;

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

692: end if;
693: --
694: end if;
695: --
696: hr_utility.set_location('Leaving:'||l_proc,10);
697: --
698: end chk_no_cmbnd_mn_pct_dfnd_flag;
699: --
700: -- ----------------------------------------------------------------------------

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

730: l_proc varchar2(72) := g_package||'chk_cmbnd_mx_amt_and_flag';
731: --
732: Begin
733: --
734: hr_utility.set_location('Entering:'||l_proc, 5);
735: --
736: If (p_cmbnd_mx_amt is not null and p_no_cmbnd_mx_amt_dfnd_flag = 'Y') then
737: --
738: -- raise error if maximum amount is not null and the No Maximum Amount

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

752: fnd_message.raise_error;
753: --
754: end if;
755: --
756: hr_utility.set_location('Leaving:'||l_proc, 10);
757: --
758: End chk_cmbnd_mx_amt_and_flag;
759: --
760: -- ----------------------------------------------------------------------------

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

790: l_proc varchar2(72) := g_package||'chk_cmbnd_mn_amt_and_flag';
791: --
792: Begin
793: --
794: hr_utility.set_location('Entering:'||l_proc, 5);
795: --
796: If (p_cmbnd_mn_amt is not null and p_no_cmbnd_mn_amt_dfnd_flag = 'Y') then
797: --
798: -- raise error if minimum amount is not null and the No Minimum Amount

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

812: fnd_message.raise_error;
813: --
814: end if;
815: --
816: hr_utility.set_location('Leaving:'||l_proc, 10);
817: --
818: End chk_cmbnd_mn_amt_and_flag;
819: --
820: -- ----------------------------------------------------------------------------

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

850: l_proc varchar2(72) := g_package||'chk_cmbnd_mx_pct_and_flag';
851: --
852: Begin
853: --
854: hr_utility.set_location('Entering:'||l_proc, 5);
855: --
856: If (p_cmbnd_mx_pct_num is not null and p_no_cmbnd_mx_pct_dfnd_flag = 'Y')
857: then
858: --

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

873: fnd_message.raise_error;
874: --
875: end if;
876: --
877: hr_utility.set_location('Leaving:'||l_proc, 10);
878: --
879: End chk_cmbnd_mx_pct_and_flag;
880: --
881: -- ----------------------------------------------------------------------------

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

911: l_proc varchar2(72) := g_package||'chk_cmbnd_mn_pct_and_flag';
912: --
913: Begin
914: --
915: hr_utility.set_location('Entering:'||l_proc, 5);
916: --
917: If (p_cmbnd_mn_pct_num is not null and p_no_cmbnd_mn_pct_dfnd_flag = 'Y')
918: then
919: --

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

934: fnd_message.raise_error;
935: --
936: end if;
937: --
938: hr_utility.set_location('Leaving:'||l_proc, 10);
939: --
940: End chk_cmbnd_mn_pct_and_flag;
941: --
942: -- ----------------------------------------------------------------------------

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

979: l_integrity_error Exception;
980: l_table_name all_tables.table_name%TYPE;
981: --
982: Begin
983: hr_utility.set_location('Entering:'||l_proc, 5);
984: --
985: -- Ensure that the p_datetrack_mode argument is not null
986: --
987: hr_api.mandatory_arg_error

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

1028: End If;
1029: --
1030: End If;
1031: --
1032: hr_utility.set_location(' Leaving:'||l_proc, 10);
1033: Exception
1034: When l_integrity_error Then
1035: --
1036: -- A referential integrity check was violated therefore

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

1035: --
1036: -- A referential integrity check was violated therefore
1037: -- we must error
1038: --
1039: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
1040: hr_utility.set_message_token('TABLE_NAME', l_table_name);
1041: hr_utility.raise_error;
1042: When Others Then
1043: --

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

1036: -- A referential integrity check was violated therefore
1037: -- we must error
1038: --
1039: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
1040: hr_utility.set_message_token('TABLE_NAME', l_table_name);
1041: hr_utility.raise_error;
1042: When Others Then
1043: --
1044: -- An unhandled or unexpected error has occurred which

Line 1041: hr_utility.raise_error;

1037: -- we must error
1038: --
1039: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
1040: hr_utility.set_message_token('TABLE_NAME', l_table_name);
1041: hr_utility.raise_error;
1042: When Others Then
1043: --
1044: -- An unhandled or unexpected error has occurred which
1045: -- we must report

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

1043: --
1044: -- An unhandled or unexpected error has occurred which
1045: -- we must report
1046: --
1047: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1048: hr_utility.set_message_token('PROCEDURE', l_proc);
1049: hr_utility.set_message_token('STEP','15');
1050: hr_utility.raise_error;
1051: End dt_update_validate;

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

1044: -- An unhandled or unexpected error has occurred which
1045: -- we must report
1046: --
1047: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1048: hr_utility.set_message_token('PROCEDURE', l_proc);
1049: hr_utility.set_message_token('STEP','15');
1050: hr_utility.raise_error;
1051: End dt_update_validate;
1052: --

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

1045: -- we must report
1046: --
1047: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1048: hr_utility.set_message_token('PROCEDURE', l_proc);
1049: hr_utility.set_message_token('STEP','15');
1050: hr_utility.raise_error;
1051: End dt_update_validate;
1052: --
1053: -- ----------------------------------------------------------------------------

Line 1050: hr_utility.raise_error;

1046: --
1047: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1048: hr_utility.set_message_token('PROCEDURE', l_proc);
1049: hr_utility.set_message_token('STEP','15');
1050: hr_utility.raise_error;
1051: End dt_update_validate;
1052: --
1053: -- ----------------------------------------------------------------------------
1054: -- |--------------------------< dt_delete_validate >--------------------------|

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

1095: l_rows_exist Exception;
1096: l_table_name all_tables.table_name%TYPE;
1097: --
1098: Begin
1099: hr_utility.set_location('Entering:'||l_proc, 5);
1100: --
1101: -- Ensure that the p_datetrack_mode argument is not null
1102: --
1103: hr_api.mandatory_arg_error

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

1130: p_argument_value => p_paird_rt_id);
1131: --
1132: End If;
1133: --
1134: hr_utility.set_location(' Leaving:'||l_proc, 10);
1135: Exception
1136: When l_rows_exist Then
1137: --
1138: -- A referential integrity check was violated therefore

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

1137: --
1138: -- A referential integrity check was violated therefore
1139: -- we must error
1140: --
1141: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
1142: hr_utility.set_message_token('TABLE_NAME', l_table_name);
1143: hr_utility.raise_error;
1144: When Others Then
1145: --

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

1138: -- A referential integrity check was violated therefore
1139: -- we must error
1140: --
1141: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
1142: hr_utility.set_message_token('TABLE_NAME', l_table_name);
1143: hr_utility.raise_error;
1144: When Others Then
1145: --
1146: -- An unhandled or unexpected error has occurred which

Line 1143: hr_utility.raise_error;

1139: -- we must error
1140: --
1141: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
1142: hr_utility.set_message_token('TABLE_NAME', l_table_name);
1143: hr_utility.raise_error;
1144: When Others Then
1145: --
1146: -- An unhandled or unexpected error has occurred which
1147: -- we must report

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

1145: --
1146: -- An unhandled or unexpected error has occurred which
1147: -- we must report
1148: --
1149: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1150: hr_utility.set_message_token('PROCEDURE', l_proc);
1151: hr_utility.set_message_token('STEP','15');
1152: hr_utility.raise_error;
1153: End dt_delete_validate;

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

1146: -- An unhandled or unexpected error has occurred which
1147: -- we must report
1148: --
1149: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1150: hr_utility.set_message_token('PROCEDURE', l_proc);
1151: hr_utility.set_message_token('STEP','15');
1152: hr_utility.raise_error;
1153: End dt_delete_validate;
1154: --

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

1147: -- we must report
1148: --
1149: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1150: hr_utility.set_message_token('PROCEDURE', l_proc);
1151: hr_utility.set_message_token('STEP','15');
1152: hr_utility.raise_error;
1153: End dt_delete_validate;
1154: --
1155: -- ----------------------------------------------------------------------------

Line 1152: hr_utility.raise_error;

1148: --
1149: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1150: hr_utility.set_message_token('PROCEDURE', l_proc);
1151: hr_utility.set_message_token('STEP','15');
1152: hr_utility.raise_error;
1153: End dt_delete_validate;
1154: --
1155: -- ----------------------------------------------------------------------------
1156: -- |---------------------------< insert_validate >----------------------------|

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

1164: --
1165: l_proc varchar2(72) := g_package||'insert_validate';
1166: --
1167: Begin
1168: hr_utility.set_location('Entering:'||l_proc, 5);
1169: --
1170: -- Call all supporting business operations
1171: --
1172: --

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

1246: chk_cmbnd_mn_pct_and_flag
1247: (p_cmbnd_mn_pct_num => p_rec.cmbnd_mn_pct_num,
1248: p_no_cmbnd_mn_pct_dfnd_flag => p_rec.no_cmbnd_mn_pct_dfnd_flag);
1249: --
1250: hr_utility.set_location(' Leaving:'||l_proc, 10);
1251: End insert_validate;
1252: --
1253: -- ----------------------------------------------------------------------------
1254: -- |---------------------------< update_validate >----------------------------|

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

1262: --
1263: l_proc varchar2(72) := g_package||'update_validate';
1264: --
1265: Begin
1266: hr_utility.set_location('Entering:'||l_proc, 5);
1267: --
1268: -- Call all supporting business operations
1269: --
1270: --

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

1353: p_datetrack_mode => p_datetrack_mode,
1354: p_validation_start_date => p_validation_start_date,
1355: p_validation_end_date => p_validation_end_date);
1356: --
1357: hr_utility.set_location(' Leaving:'||l_proc, 10);
1358: End update_validate;
1359: --
1360: -- ----------------------------------------------------------------------------
1361: -- |---------------------------< delete_validate >----------------------------|

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

1369: --
1370: l_proc varchar2(72) := g_package||'delete_validate';
1371: --
1372: Begin
1373: hr_utility.set_location('Entering:'||l_proc, 5);
1374: --
1375: -- Call all supporting business operations
1376: --
1377: dt_delete_validate

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

1379: p_validation_start_date => p_validation_start_date,
1380: p_validation_end_date => p_validation_end_date,
1381: p_paird_rt_id => p_rec.paird_rt_id);
1382: --
1383: hr_utility.set_location(' Leaving:'||l_proc, 10);
1384: End delete_validate;
1385: --
1386: --
1387: -- ---------------------------------------------------------------------------

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

1406: l_proc varchar2(72) := g_package||'return_legislation_code';
1407: --
1408: begin
1409: --
1410: hr_utility.set_location('Entering:'|| l_proc, 10);
1411: --
1412: -- Ensure that all the mandatory parameter are not null
1413: --
1414: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

1424: close csr_leg_code;
1425: --
1426: -- The primary key is invalid therefore we must error
1427: --
1428: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
1429: hr_utility.raise_error;
1430: --
1431: end if;
1432: --

Line 1429: hr_utility.raise_error;

1425: --
1426: -- The primary key is invalid therefore we must error
1427: --
1428: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
1429: hr_utility.raise_error;
1430: --
1431: end if;
1432: --
1433: close csr_leg_code;

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

1431: end if;
1432: --
1433: close csr_leg_code;
1434: --
1435: hr_utility.set_location(' Leaving:'|| l_proc, 20);
1436: --
1437: return l_legislation_code;
1438: --
1439: end return_legislation_code;