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.PAY_CPT_BUS dependencies on HR_UTILITY

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

40: and fed.effective_end_date;
41: --
42: Begin
43: --
44: hr_utility.set_location('Entering:'||l_proc,5);
45: --
46: -- Check that the mandatory parameters have been set
47: --
48: if p_assignment_id is null then

Line 49: hr_utility.set_message(800, 'HR_74023_ASSIGNMENT_ID_NULL');

45: --
46: -- Check that the mandatory parameters have been set
47: --
48: if p_assignment_id is null then
49: hr_utility.set_message(800, 'HR_74023_ASSIGNMENT_ID_NULL');
50: hr_utility.raise_error;
51: end if;
52: --
53: if p_business_group_id is null then

Line 50: hr_utility.raise_error;

46: -- Check that the mandatory parameters have been set
47: --
48: if p_assignment_id is null then
49: hr_utility.set_message(800, 'HR_74023_ASSIGNMENT_ID_NULL');
50: hr_utility.raise_error;
51: end if;
52: --
53: if p_business_group_id is null then
54: hr_utility.set_message(800, 'HR_74024_BUSINESS_GROUP_ID_NULL');

Line 54: hr_utility.set_message(800, 'HR_74024_BUSINESS_GROUP_ID_NULL');

50: hr_utility.raise_error;
51: end if;
52: --
53: if p_business_group_id is null then
54: hr_utility.set_message(800, 'HR_74024_BUSINESS_GROUP_ID_NULL');
55: hr_utility.raise_error;
56: end if;
57: --
58: hr_api.mandatory_arg_error

Line 55: hr_utility.raise_error;

51: end if;
52: --
53: if p_business_group_id is null then
54: hr_utility.set_message(800, 'HR_74024_BUSINESS_GROUP_ID_NULL');
55: hr_utility.raise_error;
56: end if;
57: --
58: hr_api.mandatory_arg_error
59: (p_api_name => l_proc

Line 75: hr_utility.set_message(800, 'HR_74027_ASSIGNMENT_ID_CHANGED');

71: --
72: if (l_api_updating ) then
73: if p_assignment_id <> pay_cpt_shd.g_old_rec.assignment_id then
74: -- dbms_output.put_line('cannot change assignment_id');
75: hr_utility.set_message(800, 'HR_74027_ASSIGNMENT_ID_CHANGED');
76: hr_utility.raise_error;
77: end if;
78: end if;
79: --

Line 76: hr_utility.raise_error;

72: if (l_api_updating ) then
73: if p_assignment_id <> pay_cpt_shd.g_old_rec.assignment_id then
74: -- dbms_output.put_line('cannot change assignment_id');
75: hr_utility.set_message(800, 'HR_74027_ASSIGNMENT_ID_CHANGED');
76: hr_utility.raise_error;
77: end if;
78: end if;
79: --
80: -- if (not l_api_updating) then

Line 92: hr_utility.set_message(800, 'HR_74025_INVALID_ASSIGNMENT_ID');

88: --
89: -- raise error as assignment_id not found in per_assignments_f
90: -- table.
91: --
92: hr_utility.set_message(800, 'HR_74025_INVALID_ASSIGNMENT_ID');
93: hr_utility.raise_error;
94: --
95: else
96: --

Line 93: hr_utility.raise_error;

89: -- raise error as assignment_id not found in per_assignments_f
90: -- table.
91: --
92: hr_utility.set_message(800, 'HR_74025_INVALID_ASSIGNMENT_ID');
93: hr_utility.raise_error;
94: --
95: else
96: --
97: close c1;

Line 101: hr_utility.set_message(800, 'HR_74026_INVALID_BG_ID');

97: close c1;
98: --
99: if p_business_group_id <> l_business_group_id then
100: --
101: hr_utility.set_message(800, 'HR_74026_INVALID_BG_ID');
102: hr_utility.raise_error;
103: --
104: else
105: --

Line 102: hr_utility.raise_error;

98: --
99: if p_business_group_id <> l_business_group_id then
100: --
101: hr_utility.set_message(800, 'HR_74026_INVALID_BG_ID');
102: hr_utility.raise_error;
103: --
104: else
105: --
106: open c2;

Line 110: hr_utility.set_message(800, 'PAY_74029_NO_FED_TAX_INFO');

106: open c2;
107: fetch c2 into l_dummy;
108: if c2%notfound then
109: close c2;
110: hr_utility.set_message(800, 'PAY_74029_NO_FED_TAX_INFO');
111: hr_utility.raise_error;
112: end if;
113: close c2;
114: --

Line 111: hr_utility.raise_error;

107: fetch c2 into l_dummy;
108: if c2%notfound then
109: close c2;
110: hr_utility.set_message(800, 'PAY_74029_NO_FED_TAX_INFO');
111: hr_utility.raise_error;
112: end if;
113: close c2;
114: --
115: end if;

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

117: end if;
118: --
119: -- end if;
120: --
121: hr_utility.set_location('Leaving:'||l_proc,10);
122: --
123: End chk_assignment_id;
124: -- ----------------------------------------------------------------------------
125: -- |------< chk_emp_province_tax_inf_id >------|

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

156: l_api_updating boolean;
157: --
158: Begin
159: --
160: hr_utility.set_location('Entering:'||l_proc, 5);
161: --
162: l_api_updating := pay_cpt_shd.api_updating
163: (p_effective_date => p_effective_date,
164: p_emp_province_tax_inf_id => p_emp_province_tax_inf_id,

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

185: end if;
186: --
187: end if;
188: --
189: hr_utility.set_location('Leaving:'||l_proc, 10);
190: --
191: End chk_emp_province_tax_inf_id;
192: --
193: -- ----------------------------------------------------------------------------

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

225: l_api_updating boolean;
226: --
227: Begin
228: --
229: hr_utility.set_location('Entering:'||l_proc, 5);
230: --
231: l_api_updating := pay_cpt_shd.api_updating
232: (p_emp_province_tax_inf_id => p_emp_province_tax_inf_id,
233: p_effective_date => p_effective_date,

Line 251: hr_utility.set_message(800,'HR_WC_EXEMPT_FLAG_IS_WRONG');

247: p_effective_date => p_effective_date) then
248: --
249: -- raise error as does not exist as lookup
250: --
251: hr_utility.set_message(800,'HR_WC_EXEMPT_FLAG_IS_WRONG');
252: hr_utility.raise_error;
253: --
254: end if;
255: --

Line 252: hr_utility.raise_error;

248: --
249: -- raise error as does not exist as lookup
250: --
251: hr_utility.set_message(800,'HR_WC_EXEMPT_FLAG_IS_WRONG');
252: hr_utility.raise_error;
253: --
254: end if;
255: --
256: end if;

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

254: end if;
255: --
256: end if;
257: --
258: hr_utility.set_location('Leaving:'||l_proc,10);
259: --
260: end chk_wc_exempt_flag;
261: --
262: -- ----------------------------------------------------------------------------

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

294: l_api_updating boolean;
295: --
296: Begin
297: --
298: hr_utility.set_location('Entering:'||l_proc, 5);
299: --
300: l_api_updating := pay_cpt_shd.api_updating
301: (p_emp_province_tax_inf_id => p_emp_province_tax_inf_id,
302: p_effective_date => p_effective_date,

Line 320: hr_utility.set_message(800,'HR_PMED_EXEMPT_FLAG_IS_WRONG');

316: p_effective_date => p_effective_date) then
317: --
318: -- raise error as does not exist as lookup
319: --
320: hr_utility.set_message(800,'HR_PMED_EXEMPT_FLAG_IS_WRONG');
321: hr_utility.raise_error;
322: --
323: end if;
324: --

Line 321: hr_utility.raise_error;

317: --
318: -- raise error as does not exist as lookup
319: --
320: hr_utility.set_message(800,'HR_PMED_EXEMPT_FLAG_IS_WRONG');
321: hr_utility.raise_error;
322: --
323: end if;
324: --
325: end if;

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

323: end if;
324: --
325: end if;
326: --
327: hr_utility.set_location('Leaving:'||l_proc,10);
328: --
329: end chk_pmed_exempt_flag;
330: --
331: -- ----------------------------------------------------------------------------

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

363: l_api_updating boolean;
364: --
365: Begin
366: --
367: hr_utility.set_location('Entering:'||l_proc, 5);
368: --
369: l_api_updating := pay_cpt_shd.api_updating
370: (p_emp_province_tax_inf_id => p_emp_province_tax_inf_id,
371: p_effective_date => p_effective_date,

Line 389: hr_utility.set_message(800,'HR_PROV_EXEMPT_FLAG_IS_WRONG');

385: p_effective_date => p_effective_date) then
386: --
387: -- raise error as does not exist as lookup
388: --
389: hr_utility.set_message(800,'HR_PROV_EXEMPT_FLAG_IS_WRONG');
390: hr_utility.raise_error;
391: --
392: end if;
393: --

Line 390: hr_utility.raise_error;

386: --
387: -- raise error as does not exist as lookup
388: --
389: hr_utility.set_message(800,'HR_PROV_EXEMPT_FLAG_IS_WRONG');
390: hr_utility.raise_error;
391: --
392: end if;
393: --
394: end if;

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

392: end if;
393: --
394: end if;
395: --
396: hr_utility.set_location('Leaving:'||l_proc,10);
397: --
398: end chk_prov_exempt_flag;
399: --
400: -- ----------------------------------------------------------------------------

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

434: l_api_updating boolean;
435: --
436: Begin
437: --
438: hr_utility.set_location('Entering:'||l_proc, 5);
439: --
440: l_api_updating := pay_cpt_shd.api_updating
441: (p_emp_province_tax_inf_id => p_emp_province_tax_inf_id,
442: p_effective_date => p_effective_date,

Line 460: hr_utility.set_message(800,'HR_BASIC_EXEMPT_IS_WRONG');

456: p_effective_date => p_effective_date) then
457: --
458: -- raise error as does not exist as lookup
459: --
460: hr_utility.set_message(800,'HR_BASIC_EXEMPT_IS_WRONG');
461: hr_utility.raise_error;
462: --
463: end if;
464:

Line 461: hr_utility.raise_error;

457: --
458: -- raise error as does not exist as lookup
459: --
460: hr_utility.set_message(800,'HR_BASIC_EXEMPT_IS_WRONG');
461: hr_utility.raise_error;
462: --
463: end if;
464:
465: --

Line 470: hr_utility.set_message(800,'HR_74008_BOTH_NULL');

466: end if;
467: if nvl(p_basic_exemption_flag,'N') = 'N'
468: and p_tax_credit_amount is null
469: then
470: hr_utility.set_message(800,'HR_74008_BOTH_NULL');
471: hr_utility.raise_error;
472: --
473: end if;
474:

Line 471: hr_utility.raise_error;

467: if nvl(p_basic_exemption_flag,'N') = 'N'
468: and p_tax_credit_amount is null
469: then
470: hr_utility.set_message(800,'HR_74008_BOTH_NULL');
471: hr_utility.raise_error;
472: --
473: end if;
474:
475: if nvl(p_basic_exemption_flag,'N') = 'Y'

Line 478: hr_utility.set_message(800,'HR_74007_BOTH_NOT_NULL');

474:
475: if nvl(p_basic_exemption_flag,'N') = 'Y'
476: and p_tax_credit_amount is not null
477: then
478: hr_utility.set_message(800,'HR_74007_BOTH_NOT_NULL');
479: hr_utility.raise_error;
480: --
481: end if;
482: --

Line 479: hr_utility.raise_error;

475: if nvl(p_basic_exemption_flag,'N') = 'Y'
476: and p_tax_credit_amount is not null
477: then
478: hr_utility.set_message(800,'HR_74007_BOTH_NOT_NULL');
479: hr_utility.raise_error;
480: --
481: end if;
482: --
483: hr_utility.set_location('Leaving:'||l_proc,10);

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

479: hr_utility.raise_error;
480: --
481: end if;
482: --
483: hr_utility.set_location('Leaving:'||l_proc,10);
484: --
485: end chk_basic_exemption_flag;
486: --
487: -- ----------------------------------------------------------------------------

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

519: l_api_updating boolean;
520: --
521: Begin
522: --
523: hr_utility.set_location('Entering:'||l_proc, 5);
524: --
525: l_api_updating := pay_cpt_shd.api_updating
526: (p_emp_province_tax_inf_id => p_emp_province_tax_inf_id,
527: p_effective_date => p_effective_date,

Line 545: hr_utility.set_message(800,'HR_MARRIAGE_STATUS_IS_WRONG');

541: p_effective_date => p_effective_date) then
542: --
543: -- raise error as does not exist as lookup
544: --
545: hr_utility.set_message(800,'HR_MARRIAGE_STATUS_IS_WRONG');
546: hr_utility.raise_error;
547: --
548: end if;
549: --

Line 546: hr_utility.raise_error;

542: --
543: -- raise error as does not exist as lookup
544: --
545: hr_utility.set_message(800,'HR_MARRIAGE_STATUS_IS_WRONG');
546: hr_utility.raise_error;
547: --
548: end if;
549: --
550: end if;

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

548: end if;
549: --
550: end if;
551: --
552: hr_utility.set_location('Leaving:'||l_proc,10);
553: --
554: end chk_marriage_status;
555: -- ----------------------------------------------------------------------------
556: -- |------< chk_disability_status >------|

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

587: l_api_updating boolean;
588: --
589: Begin
590: --
591: hr_utility.set_location('Entering:'||l_proc, 5);
592: --
593: l_api_updating := pay_cpt_shd.api_updating
594: (p_emp_province_tax_inf_id => p_emp_province_tax_inf_id,
595: p_effective_date => p_effective_date,

Line 613: hr_utility.set_message(800,'HR_DISABILITY_STATUS_IS_WRONG');

609: p_effective_date => p_effective_date) then
610: --
611: -- raise error as does not exist as lookup
612: --
613: hr_utility.set_message(800,'HR_DISABILITY_STATUS_IS_WRONG');
614: hr_utility.raise_error;
615: --
616: end if;
617: --

Line 614: hr_utility.raise_error;

610: --
611: -- raise error as does not exist as lookup
612: --
613: hr_utility.set_message(800,'HR_DISABILITY_STATUS_IS_WRONG');
614: hr_utility.raise_error;
615: --
616: end if;
617: --
618: end if;

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

616: end if;
617: --
618: end if;
619: --
620: hr_utility.set_location('Leaving:'||l_proc,10);
621: --
622: end chk_disability_status;
623: -- ----------------------------------------------------------------------------
624: -- |------< chk_non_resident_status >------|

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

655: l_api_updating boolean;
656: --
657: Begin
658: --
659: hr_utility.set_location('Entering:'||l_proc, 5);
660: --
661: l_api_updating := pay_cpt_shd.api_updating
662: (p_emp_province_tax_inf_id => p_emp_province_tax_inf_id,
663: p_effective_date => p_effective_date,

Line 681: hr_utility.set_message(800,'HR_NON_RESIDENT_STATUS_WRONG');

677: p_effective_date => p_effective_date) then
678: --
679: -- raise error as does not exist as lookup
680: --
681: hr_utility.set_message(800,'HR_NON_RESIDENT_STATUS_WRONG');
682: hr_utility.raise_error;
683: --
684: end if;
685: --

Line 682: hr_utility.raise_error;

678: --
679: -- raise error as does not exist as lookup
680: --
681: hr_utility.set_message(800,'HR_NON_RESIDENT_STATUS_WRONG');
682: hr_utility.raise_error;
683: --
684: end if;
685: --
686: end if;

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

684: end if;
685: --
686: end if;
687: --
688: hr_utility.set_location('Leaving:'||l_proc,10);
689: --
690: end chk_non_resident_status;
691: -- ----------------------------------------------------------------------------
692: -- |------< chk_tax_calc_method >------|

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

723: l_api_updating boolean;
724: --
725: Begin
726: --
727: hr_utility.set_location('Entering:'||l_proc, 5);
728: --
729: l_api_updating := pay_cpt_shd.api_updating
730: (p_emp_province_tax_inf_id => p_emp_province_tax_inf_id,
731: p_effective_date => p_effective_date,

Line 749: hr_utility.set_message(800,'HR_QC_TAX_CALC_METHOD');

745: p_effective_date => p_effective_date) then
746: --
747: -- raise error as does not exist as lookup
748: --
749: hr_utility.set_message(800,'HR_QC_TAX_CALC_METHOD');
750: hr_utility.raise_error;
751: --
752: end if;
753: --

Line 750: hr_utility.raise_error;

746: --
747: -- raise error as does not exist as lookup
748: --
749: hr_utility.set_message(800,'HR_QC_TAX_CALC_METHOD');
750: hr_utility.raise_error;
751: --
752: end if;
753: --
754: end if;

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

752: end if;
753: --
754: end if;
755: --
756: hr_utility.set_location('Leaving:'||l_proc,10);
757: --
758: end chk_tax_calc_method;
759: -- ----------------------------------------------------------------------------
760: -- |------< chk_province_code >------|

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

791: l_api_updating boolean;
792: --
793: Begin
794: --
795: hr_utility.set_location('Entering:'||l_proc, 5);
796: --
797: l_api_updating := pay_cpt_shd.api_updating
798: (p_emp_province_tax_inf_id => p_emp_province_tax_inf_id,
799: p_effective_date => p_effective_date,

Line 805: hr_utility.set_message(800, 'HR_74030_PROVINCE_CODE_CHANGED');

801: --
802: if (l_api_updating ) then
803: if p_province_code <>
804: nvl(pay_cpt_shd.g_old_rec.province_code,hr_api.g_varchar2) then
805: hr_utility.set_message(800, 'HR_74030_PROVINCE_CODE_CHANGED');
806: hr_utility.raise_error;
807: end if;
808: end if;
809:

Line 806: hr_utility.raise_error;

802: if (l_api_updating ) then
803: if p_province_code <>
804: nvl(pay_cpt_shd.g_old_rec.province_code,hr_api.g_varchar2) then
805: hr_utility.set_message(800, 'HR_74030_PROVINCE_CODE_CHANGED');
806: hr_utility.raise_error;
807: end if;
808: end if;
809:
810: if (l_api_updating

Line 825: hr_utility.set_message(800,'HR_PROVINCE_CODE_WRONG');

821: p_effective_date => p_effective_date) then
822: --
823: -- raise error as does not exist as lookup
824: --
825: hr_utility.set_message(800,'HR_PROVINCE_CODE_WRONG');
826: hr_utility.raise_error;
827: --
828: end if;
829: --

Line 826: hr_utility.raise_error;

822: --
823: -- raise error as does not exist as lookup
824: --
825: hr_utility.set_message(800,'HR_PROVINCE_CODE_WRONG');
826: hr_utility.raise_error;
827: --
828: end if;
829: --
830: end if;

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

828: end if;
829: --
830: end if;
831: --
832: hr_utility.set_location('Leaving:'||l_proc,10);
833: --
834: end chk_province_code;
835: -- ----------------------------------------------------------------------------
836: -- |------< chk_legislation_code >------|

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

867: l_api_updating boolean;
868: --
869: Begin
870: --
871: hr_utility.set_location('Entering:'||l_proc, 5);
872: --
873: l_api_updating := pay_cpt_shd.api_updating
874: (p_emp_province_tax_inf_id => p_emp_province_tax_inf_id,
875: p_effective_date => p_effective_date,

Line 886: hr_utility.set_message(800,'HR_74028_WRONG_LEGIS_CODE');

882: ---
883: if p_legislation_code is null then
884: -- raise error as legislation_code is NULL
885: --
886: hr_utility.set_message(800,'HR_74028_WRONG_LEGIS_CODE');
887: hr_utility.raise_error;
888: --
889: end if;
890: --

Line 887: hr_utility.raise_error;

883: if p_legislation_code is null then
884: -- raise error as legislation_code is NULL
885: --
886: hr_utility.set_message(800,'HR_74028_WRONG_LEGIS_CODE');
887: hr_utility.raise_error;
888: --
889: end if;
890: --
891: -- check if value of lookup falls within lookup type.

Line 896: hr_utility.set_message(800,'HR_74028_WRONG_LEGIS_CODE');

892: --
893: if p_legislation_code <> 'CA' then
894: -- raise error as legislation_code is not CA
895: --
896: hr_utility.set_message(800,'HR_74028_WRONG_LEGIS_CODE');
897: hr_utility.raise_error;
898: --
899: end if;
900: --

Line 897: hr_utility.raise_error;

893: if p_legislation_code <> 'CA' then
894: -- raise error as legislation_code is not CA
895: --
896: hr_utility.set_message(800,'HR_74028_WRONG_LEGIS_CODE');
897: hr_utility.raise_error;
898: --
899: end if;
900: --
901: end if;

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

899: end if;
900: --
901: end if;
902: --
903: hr_utility.set_location('Leaving:'||l_proc,10);
904: --
905: end chk_legislation_code;
906: -- ----------------------------------------------------------------------------
907: -- |--------------------------< dt_update_validate >--------------------------|

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

942: l_integrity_error Exception;
943: l_table_name all_tables.table_name%TYPE;
944: --
945: Begin
946: hr_utility.set_location('Entering:'||l_proc, 5);
947: --
948: -- Ensure that the p_datetrack_mode argument is not null
949: --
950: hr_api.mandatory_arg_error

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

981: End If;
982: --
983: End If;
984: --
985: hr_utility.set_location(' Leaving:'||l_proc, 10);
986: Exception
987: When l_integrity_error Then
988: --
989: -- A referential integrity check was violated therefore

Line 992: hr_utility.set_message(800, 'HR_7216_DT_UPD_INTEGRITY_ERR');

988: --
989: -- A referential integrity check was violated therefore
990: -- we must error
991: --
992: hr_utility.set_message(800, 'HR_7216_DT_UPD_INTEGRITY_ERR');
993: hr_utility.set_message_token('TABLE_NAME', l_table_name);
994: hr_utility.raise_error;
995: When Others Then
996: --

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

989: -- A referential integrity check was violated therefore
990: -- we must error
991: --
992: hr_utility.set_message(800, 'HR_7216_DT_UPD_INTEGRITY_ERR');
993: hr_utility.set_message_token('TABLE_NAME', l_table_name);
994: hr_utility.raise_error;
995: When Others Then
996: --
997: -- An unhandled or unexpected error has occurred which

Line 994: hr_utility.raise_error;

990: -- we must error
991: --
992: hr_utility.set_message(800, 'HR_7216_DT_UPD_INTEGRITY_ERR');
993: hr_utility.set_message_token('TABLE_NAME', l_table_name);
994: hr_utility.raise_error;
995: When Others Then
996: --
997: -- An unhandled or unexpected error has occurred which
998: -- we must report

Line 1000: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');

996: --
997: -- An unhandled or unexpected error has occurred which
998: -- we must report
999: --
1000: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
1001: hr_utility.set_message_token('PROCEDURE', l_proc);
1002: hr_utility.set_message_token('STEP','15');
1003: hr_utility.raise_error;
1004: End dt_update_validate;

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

997: -- An unhandled or unexpected error has occurred which
998: -- we must report
999: --
1000: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
1001: hr_utility.set_message_token('PROCEDURE', l_proc);
1002: hr_utility.set_message_token('STEP','15');
1003: hr_utility.raise_error;
1004: End dt_update_validate;
1005: --

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

998: -- we must report
999: --
1000: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
1001: hr_utility.set_message_token('PROCEDURE', l_proc);
1002: hr_utility.set_message_token('STEP','15');
1003: hr_utility.raise_error;
1004: End dt_update_validate;
1005: --
1006: -- ----------------------------------------------------------------------------

Line 1003: hr_utility.raise_error;

999: --
1000: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
1001: hr_utility.set_message_token('PROCEDURE', l_proc);
1002: hr_utility.set_message_token('STEP','15');
1003: hr_utility.raise_error;
1004: End dt_update_validate;
1005: --
1006: -- ----------------------------------------------------------------------------
1007: -- |--------------------------< dt_delete_validate >--------------------------|

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

1048: l_rows_exist Exception;
1049: l_table_name all_tables.table_name%TYPE;
1050: --
1051: Begin
1052: hr_utility.set_location('Entering:'||l_proc, 5);
1053: --
1054: -- Ensure that the p_datetrack_mode argument is not null
1055: --
1056: hr_api.mandatory_arg_error

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

1085: --
1086: --
1087: End If;
1088: --
1089: hr_utility.set_location(' Leaving:'||l_proc, 10);
1090: Exception
1091: When l_rows_exist Then
1092: --
1093: -- A referential integrity check was violated therefore

Line 1096: hr_utility.set_message(800, 'HR_7215_DT_CHILD_EXISTS');

1092: --
1093: -- A referential integrity check was violated therefore
1094: -- we must error
1095: --
1096: hr_utility.set_message(800, 'HR_7215_DT_CHILD_EXISTS');
1097: hr_utility.set_message_token('TABLE_NAME', l_table_name);
1098: hr_utility.raise_error;
1099: When Others Then
1100: --

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

1093: -- A referential integrity check was violated therefore
1094: -- we must error
1095: --
1096: hr_utility.set_message(800, 'HR_7215_DT_CHILD_EXISTS');
1097: hr_utility.set_message_token('TABLE_NAME', l_table_name);
1098: hr_utility.raise_error;
1099: When Others Then
1100: --
1101: -- An unhandled or unexpected error has occurred which

Line 1098: hr_utility.raise_error;

1094: -- we must error
1095: --
1096: hr_utility.set_message(800, 'HR_7215_DT_CHILD_EXISTS');
1097: hr_utility.set_message_token('TABLE_NAME', l_table_name);
1098: hr_utility.raise_error;
1099: When Others Then
1100: --
1101: -- An unhandled or unexpected error has occurred which
1102: -- we must report

Line 1104: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');

1100: --
1101: -- An unhandled or unexpected error has occurred which
1102: -- we must report
1103: --
1104: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
1105: hr_utility.set_message_token('PROCEDURE', l_proc);
1106: hr_utility.set_message_token('STEP','15');
1107: hr_utility.raise_error;
1108: End dt_delete_validate;

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

1101: -- An unhandled or unexpected error has occurred which
1102: -- we must report
1103: --
1104: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
1105: hr_utility.set_message_token('PROCEDURE', l_proc);
1106: hr_utility.set_message_token('STEP','15');
1107: hr_utility.raise_error;
1108: End dt_delete_validate;
1109: --

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

1102: -- we must report
1103: --
1104: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
1105: hr_utility.set_message_token('PROCEDURE', l_proc);
1106: hr_utility.set_message_token('STEP','15');
1107: hr_utility.raise_error;
1108: End dt_delete_validate;
1109: --
1110: -- ----------------------------------------------------------------------------

Line 1107: hr_utility.raise_error;

1103: --
1104: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
1105: hr_utility.set_message_token('PROCEDURE', l_proc);
1106: hr_utility.set_message_token('STEP','15');
1107: hr_utility.raise_error;
1108: End dt_delete_validate;
1109: --
1110: -- ----------------------------------------------------------------------------
1111: -- |---------------------------< insert_validate >----------------------------|

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

1119: --
1120: l_proc varchar2(72) := g_package||'insert_validate';
1121: --
1122: Begin
1123: hr_utility.set_location('Entering:'||l_proc, 5);
1124: --
1125: -- Call all supporting business operations
1126: --
1127: chk_emp_province_tax_inf_id

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

1200: p_object_version_number => p_rec.object_version_number);
1201: --
1202: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1203: --
1204: hr_utility.set_location(' Leaving:'||l_proc, 10);
1205: End insert_validate;
1206: --
1207: -- ----------------------------------------------------------------------------
1208: -- |---------------------------< update_validate >----------------------------|

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

1216: --
1217: l_proc varchar2(72) := g_package||'update_validate';
1218: --
1219: Begin
1220: hr_utility.set_location('Entering:'||l_proc, 5);
1221: --
1222: -- Call all supporting business operations
1223: --
1224: chk_emp_province_tax_inf_id

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

1305: p_datetrack_mode => p_datetrack_mode,
1306: p_validation_start_date => p_validation_start_date,
1307: p_validation_end_date => p_validation_end_date);
1308: --
1309: hr_utility.set_location(' Leaving:'||l_proc, 10);
1310: End update_validate;
1311: --
1312: -- ----------------------------------------------------------------------------
1313: -- |---------------------------< delete_validate >----------------------------|

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

1370: l_effective_date date;
1371:
1372: --
1373: Begin
1374: hr_utility.set_location('Entering:'||l_proc, 5);
1375: --
1376: -- Call all supporting business operations
1377: --
1378: l_effective_date := trunc(p_effective_date);

Line 1384: hr_utility.set_location(l_proc, 6);

1380: open csr_assigned(l_effective_date);
1381: fetch csr_assigned into l_prov;
1382:
1383: if csr_assigned%NOTFOUND then
1384: hr_utility.set_location(l_proc, 6);
1385: dt_delete_validate
1386: (p_datetrack_mode => p_datetrack_mode,
1387: p_validation_start_date => p_validation_start_date,
1388: p_validation_end_date => p_validation_end_date,

Line 1390: hr_utility.set_location(l_proc, 7);

1386: (p_datetrack_mode => p_datetrack_mode,
1387: p_validation_start_date => p_validation_start_date,
1388: p_validation_end_date => p_validation_end_date,
1389: p_emp_province_tax_inf_id => p_rec.emp_province_tax_inf_id);
1390: hr_utility.set_location(l_proc, 7);
1391: else
1392: hr_utility.set_location(l_proc, 9);
1393: hr_utility.set_message(800,'HR_74039_CANNOT_PURGE_PROV');
1394: hr_utility.set_message_token('PROVINCECODE', l_prov);

Line 1392: hr_utility.set_location(l_proc, 9);

1388: p_validation_end_date => p_validation_end_date,
1389: p_emp_province_tax_inf_id => p_rec.emp_province_tax_inf_id);
1390: hr_utility.set_location(l_proc, 7);
1391: else
1392: hr_utility.set_location(l_proc, 9);
1393: hr_utility.set_message(800,'HR_74039_CANNOT_PURGE_PROV');
1394: hr_utility.set_message_token('PROVINCECODE', l_prov);
1395: hr_utility.raise_error;
1396: end if;

Line 1393: hr_utility.set_message(800,'HR_74039_CANNOT_PURGE_PROV');

1389: p_emp_province_tax_inf_id => p_rec.emp_province_tax_inf_id);
1390: hr_utility.set_location(l_proc, 7);
1391: else
1392: hr_utility.set_location(l_proc, 9);
1393: hr_utility.set_message(800,'HR_74039_CANNOT_PURGE_PROV');
1394: hr_utility.set_message_token('PROVINCECODE', l_prov);
1395: hr_utility.raise_error;
1396: end if;
1397:

Line 1394: hr_utility.set_message_token('PROVINCECODE', l_prov);

1390: hr_utility.set_location(l_proc, 7);
1391: else
1392: hr_utility.set_location(l_proc, 9);
1393: hr_utility.set_message(800,'HR_74039_CANNOT_PURGE_PROV');
1394: hr_utility.set_message_token('PROVINCECODE', l_prov);
1395: hr_utility.raise_error;
1396: end if;
1397:
1398: close csr_assigned;

Line 1395: hr_utility.raise_error;

1391: else
1392: hr_utility.set_location(l_proc, 9);
1393: hr_utility.set_message(800,'HR_74039_CANNOT_PURGE_PROV');
1394: hr_utility.set_message_token('PROVINCECODE', l_prov);
1395: hr_utility.raise_error;
1396: end if;
1397:
1398: close csr_assigned;
1399:

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

1396: end if;
1397:
1398: close csr_assigned;
1399:
1400: hr_utility.set_location(' Leaving:'||l_proc, 10);
1401:
1402: End delete_validate;
1403: --
1404: --

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

1424: l_proc varchar2(72) := g_package||'return_legislation_code';
1425: --
1426: begin
1427: --
1428: hr_utility.set_location('Entering:'|| l_proc, 10);
1429: --
1430: -- Ensure that all the mandatory parameter are not null
1431: --
1432: hr_api.mandatory_arg_error(p_api_name => l_proc,

Line 1446: hr_utility.set_message(800,'HR_7220_INVALID_PRIMARY_KEY');

1442: close csr_leg_code;
1443: --
1444: -- The primary key is invalid therefore we must error
1445: --
1446: hr_utility.set_message(800,'HR_7220_INVALID_PRIMARY_KEY');
1447: hr_utility.raise_error;
1448: --
1449: end if;
1450: --

Line 1447: hr_utility.raise_error;

1443: --
1444: -- The primary key is invalid therefore we must error
1445: --
1446: hr_utility.set_message(800,'HR_7220_INVALID_PRIMARY_KEY');
1447: hr_utility.raise_error;
1448: --
1449: end if;
1450: --
1451: close csr_leg_code;

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

1449: end if;
1450: --
1451: close csr_leg_code;
1452: --
1453: hr_utility.set_location(' Leaving:'|| l_proc, 20);
1454: --
1455: return l_legislation_code;
1456: --
1457: end return_legislation_code;