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_CFT_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 := pay_cft_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_emp_fed_tax_inf_id => p_emp_fed_tax_inf_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_emp_fed_tax_inf_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 := pay_cft_shd.api_updating
118: (p_emp_fed_tax_inf_id => p_emp_fed_tax_inf_id,
119: p_effective_date => p_effective_date,

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

126: ---
127: if p_legislation_code is null then
128: -- raise error as legislation_code is NULL
129: --
130: hr_utility.set_message(800, 'HR_74028_WRONG_LEGIS_CODE');
131: hr_utility.raise_error;
132: --
133: end if;
134: --

Line 131: hr_utility.raise_error;

127: if p_legislation_code is null then
128: -- raise error as legislation_code is NULL
129: --
130: hr_utility.set_message(800, 'HR_74028_WRONG_LEGIS_CODE');
131: hr_utility.raise_error;
132: --
133: end if;
134: --
135: -- check if value of lookup falls within lookup type.

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

136: --
137: if p_legislation_code <> 'CA' then
138: -- raise error as legislation_code is not CA
139: --
140: hr_utility.set_message(800, 'HR_74028_WRONG_LEGIS_CODE');
141: hr_utility.raise_error;
142: --
143: end if;
144: --

Line 141: hr_utility.raise_error;

137: if p_legislation_code <> 'CA' then
138: -- raise error as legislation_code is not CA
139: --
140: hr_utility.set_message(800, 'HR_74028_WRONG_LEGIS_CODE');
141: hr_utility.raise_error;
142: --
143: end if;
144: --
145: end if;

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

143: end if;
144: --
145: end if;
146: --
147: hr_utility.set_location('Leaving:'||l_proc,10);
148: --
149: end chk_legislation_code;
150: --
151: -- ----------------------------------------------------------------------------

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

180: where hrl.location_id = p_location_id;
181: --
182: Begin
183: --
184: hr_utility.set_location('Entering:'||l_proc,5);
185: --
186: -- Check that the mandatory parameters have been set
187: --
188: --dbms_output.put_line('in assignment_id ');

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

186: -- Check that the mandatory parameters have been set
187: --
188: --dbms_output.put_line('in assignment_id ');
189: if p_assignment_id is null then
190: hr_utility.set_message(800, 'HR_74023_ASSIGNMENT_ID_NULL');
191: hr_utility.raise_error;
192: end if;
193: --
194: --dbms_output.put_line('in assignment_id 2');

Line 191: hr_utility.raise_error;

187: --
188: --dbms_output.put_line('in assignment_id ');
189: if p_assignment_id is null then
190: hr_utility.set_message(800, 'HR_74023_ASSIGNMENT_ID_NULL');
191: hr_utility.raise_error;
192: end if;
193: --
194: --dbms_output.put_line('in assignment_id 2');
195: if p_business_group_id is null then

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

192: end if;
193: --
194: --dbms_output.put_line('in assignment_id 2');
195: if p_business_group_id is null then
196: hr_utility.set_message(800, 'HR_74024_BUSINESS_GROUP_ID_NULL');
197: hr_utility.raise_error;
198: end if;
199: --
200: --dbms_output.put_line('in assignment_id 3');

Line 197: hr_utility.raise_error;

193: --
194: --dbms_output.put_line('in assignment_id 2');
195: if p_business_group_id is null then
196: hr_utility.set_message(800, 'HR_74024_BUSINESS_GROUP_ID_NULL');
197: hr_utility.raise_error;
198: end if;
199: --
200: --dbms_output.put_line('in assignment_id 3');
201: hr_api.mandatory_arg_error

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

215: --
216: if (l_api_updating ) then
217: if p_assignment_id <> pay_cft_shd.g_old_rec.assignment_id then
218: --dbms_output.put_line('cannot change assignment_id');
219: hr_utility.set_message(800, 'HR_74027_ASSIGNMENT_ID_CHANGED');
220: hr_utility.raise_error;
221: end if;
222: end if;
223:

Line 220: hr_utility.raise_error;

216: if (l_api_updating ) then
217: if p_assignment_id <> pay_cft_shd.g_old_rec.assignment_id then
218: --dbms_output.put_line('cannot change assignment_id');
219: hr_utility.set_message(800, 'HR_74027_ASSIGNMENT_ID_CHANGED');
220: hr_utility.raise_error;
221: end if;
222: end if;
223:
224: -- if (not l_api_updating) then

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

234: -- raise error as assignment_id not found in per_assignments_f
235: -- table.
236: --
237: --dbms_output.put_line('in assignment_id 6');
238: hr_utility.set_message(800, 'HR_74025_INVALID_ASSIGNMENT_ID');
239: hr_utility.raise_error;
240: --
241: else
242: --

Line 239: hr_utility.raise_error;

235: -- table.
236: --
237: --dbms_output.put_line('in assignment_id 6');
238: hr_utility.set_message(800, 'HR_74025_INVALID_ASSIGNMENT_ID');
239: hr_utility.raise_error;
240: --
241: else
242: --
243: close c1;

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

244: --
245: --dbms_output.put_line('in assignment_id 7');
246: if p_business_group_id <> l_business_group_id then
247: --
248: hr_utility.set_message(800, 'HR_74026_INVALID_BG_ID');
249: hr_utility.set_message_token('BG_ID' , l_business_group_id);
250: hr_utility.raise_error;
251: --
252: else

Line 249: hr_utility.set_message_token('BG_ID' , l_business_group_id);

245: --dbms_output.put_line('in assignment_id 7');
246: if p_business_group_id <> l_business_group_id then
247: --
248: hr_utility.set_message(800, 'HR_74026_INVALID_BG_ID');
249: hr_utility.set_message_token('BG_ID' , l_business_group_id);
250: hr_utility.raise_error;
251: --
252: else
253:

Line 250: hr_utility.raise_error;

246: if p_business_group_id <> l_business_group_id then
247: --
248: hr_utility.set_message(800, 'HR_74026_INVALID_BG_ID');
249: hr_utility.set_message_token('BG_ID' , l_business_group_id);
250: hr_utility.raise_error;
251: --
252: else
253:
254: if l_location_id is NULL then

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

270: --
271: -- end if;
272: --
273: --dbms_output.put_line('in assignment_id 6');
274: hr_utility.set_location('Leaving:'||l_proc,10);
275: --
276: End chk_assignment_id;
277: -- ----------------------------------------------------------------------------
278: -- |------< chk_employment_province >------|

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

309: l_api_updating boolean;
310: --
311: Begin
312: --
313: hr_utility.set_location('Entering:'||l_proc, 5);
314: --
315: l_api_updating := pay_cft_shd.api_updating
316: (p_emp_fed_tax_inf_id => p_emp_fed_tax_inf_id,
317: p_effective_date => p_effective_date,

Line 335: hr_utility.set_message(800,'HR_EMPLOYMENT_PROVINCE_WRONG');

331: p_effective_date => p_effective_date) then
332: --
333: -- raise error as does not exist as lookup
334: --
335: hr_utility.set_message(800,'HR_EMPLOYMENT_PROVINCE_WRONG');
336: hr_utility.raise_error;
337: --
338: end if;
339: --

Line 336: hr_utility.raise_error;

332: --
333: -- raise error as does not exist as lookup
334: --
335: hr_utility.set_message(800,'HR_EMPLOYMENT_PROVINCE_WRONG');
336: hr_utility.raise_error;
337: --
338: end if;
339: --
340: end if;

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

338: end if;
339: --
340: end if;
341: --
342: hr_utility.set_location('Leaving:'||l_proc,10);
343: --
344: end chk_employment_province;
345: -- ----------------------------------------------------------------------------
346: -- |------< chk_ei_exempt_flag >------|

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

377: l_api_updating boolean;
378: --
379: Begin
380: --
381: hr_utility.set_location('Entering:'||l_proc, 5);
382: --
383: l_api_updating := pay_cft_shd.api_updating
384: (p_emp_fed_tax_inf_id => p_emp_fed_tax_inf_id,
385: p_effective_date => p_effective_date,

Line 403: hr_utility.set_message(800,'HR_EI_EXEMPT_FLAG_IS WRONG');

399: p_effective_date => p_effective_date) then
400: --
401: -- raise error as does not exist as lookup
402: --
403: hr_utility.set_message(800,'HR_EI_EXEMPT_FLAG_IS WRONG');
404: hr_utility.raise_error;
405: --
406: end if;
407: --

Line 404: hr_utility.raise_error;

400: --
401: -- raise error as does not exist as lookup
402: --
403: hr_utility.set_message(800,'HR_EI_EXEMPT_FLAG_IS WRONG');
404: hr_utility.raise_error;
405: --
406: end if;
407: --
408: end if;

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

406: end if;
407: --
408: end if;
409: --
410: hr_utility.set_location('Leaving:'||l_proc,10);
411: --
412: end chk_ei_exempt_flag;
413: --
414: -- ----------------------------------------------------------------------------

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

446: l_api_updating boolean;
447: --
448: Begin
449: --
450: hr_utility.set_location('Entering:'||l_proc, 5);
451: --
452: l_api_updating := pay_cft_shd.api_updating
453: (p_emp_fed_tax_inf_id => p_emp_fed_tax_inf_id,
454: p_effective_date => p_effective_date,

Line 472: hr_utility.set_message(800,'HR_FED_EXEMPT_FLAG_IS_WRONG');

468: p_effective_date => p_effective_date) then
469: --
470: -- raise error as does not exist as lookup
471: --
472: hr_utility.set_message(800,'HR_FED_EXEMPT_FLAG_IS_WRONG');
473: hr_utility.raise_error;
474: --
475: end if;
476: --

Line 473: hr_utility.raise_error;

469: --
470: -- raise error as does not exist as lookup
471: --
472: hr_utility.set_message(800,'HR_FED_EXEMPT_FLAG_IS_WRONG');
473: hr_utility.raise_error;
474: --
475: end if;
476: --
477: end if;

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

475: end if;
476: --
477: end if;
478: --
479: hr_utility.set_location('Leaving:'||l_proc,10);
480: --
481: end chk_fed_exempt_flag;
482: --
483: -- ----------------------------------------------------------------------------

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

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

Line 546: hr_utility.set_message(800,'HR_CPP_QPP_EXEMPT_FLAG_WRONG');

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

Line 547: hr_utility.raise_error;

543: --
544: -- raise error as does not exist as lookup
545: --
546: hr_utility.set_message(800,'HR_CPP_QPP_EXEMPT_FLAG_WRONG');
547: hr_utility.raise_error;
548: --
549: end if;
550:
551: /*Changes for bug 13542083 - Start*/

Line 557: hr_utility.set_message(801, 'PAY_74180_CPT30_DATE_ENTERED');

553: /* Checking if CPP Election/Revocation date is already entered*/
554: if (p_cpp_election_date is not null or p_cpp_revocation_date is not null)
555: and (p_cpp_qpp_exempt_flag='Y') then
556: -- Error: The CPP Election or Revocation Date is already entered
557: hr_utility.set_message(801, 'PAY_74180_CPT30_DATE_ENTERED');
558: hr_utility.raise_error;
559: end if;
560:
561: /*Changes for bug 13542083 - End*/

Line 558: hr_utility.raise_error;

554: if (p_cpp_election_date is not null or p_cpp_revocation_date is not null)
555: and (p_cpp_qpp_exempt_flag='Y') then
556: -- Error: The CPP Election or Revocation Date is already entered
557: hr_utility.set_message(801, 'PAY_74180_CPT30_DATE_ENTERED');
558: hr_utility.raise_error;
559: end if;
560:
561: /*Changes for bug 13542083 - End*/
562: --

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

561: /*Changes for bug 13542083 - End*/
562: --
563: end if;
564: --
565: hr_utility.set_location('Leaving:'||l_proc,10);
566: --
567: end chk_cpp_qpp_exempt_flag;
568: --
569: -- ----------------------------------------------------------------------------

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

602: l_api_updating boolean;
603: --
604: Begin
605: --
606: hr_utility.set_location('Entering:'||l_proc, 5);
607: --
608: l_api_updating := pay_cft_shd.api_updating
609: (p_emp_fed_tax_inf_id => p_emp_fed_tax_inf_id,
610: p_effective_date => p_effective_date,

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

624: p_effective_date => p_effective_date) then
625: --
626: -- raise error as does not exist as lookup
627: --
628: hr_utility.set_message(800,'HR_BASIC_EXEMPT_IS_WRONG');
629: hr_utility.raise_error;
630: --
631: end if;
632: --

Line 629: hr_utility.raise_error;

625: --
626: -- raise error as does not exist as lookup
627: --
628: hr_utility.set_message(800,'HR_BASIC_EXEMPT_IS_WRONG');
629: hr_utility.raise_error;
630: --
631: end if;
632: --
633: end if;

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

634: --
635: if nvl(p_basic_exemption_flag,'N') = 'N'
636: and p_tax_credit_amount is null
637: then
638: hr_utility.set_message(800,'HR_74008_BOTH_NULL');
639: hr_utility.raise_error;
640: --
641: end if;
642:

Line 639: hr_utility.raise_error;

635: if nvl(p_basic_exemption_flag,'N') = 'N'
636: and p_tax_credit_amount is null
637: then
638: hr_utility.set_message(800,'HR_74008_BOTH_NULL');
639: hr_utility.raise_error;
640: --
641: end if;
642:
643: if nvl(p_basic_exemption_flag,'N') = 'Y'

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

642:
643: if nvl(p_basic_exemption_flag,'N') = 'Y'
644: and p_tax_credit_amount is not null
645: then
646: hr_utility.set_message(800,'HR_74007_BOTH_NOT_NULL');
647: hr_utility.raise_error;
648: --
649: end if;
650: hr_utility.set_location('Leaving:'||l_proc,10);

Line 647: hr_utility.raise_error;

643: if nvl(p_basic_exemption_flag,'N') = 'Y'
644: and p_tax_credit_amount is not null
645: then
646: hr_utility.set_message(800,'HR_74007_BOTH_NOT_NULL');
647: hr_utility.raise_error;
648: --
649: end if;
650: hr_utility.set_location('Leaving:'||l_proc,10);
651: --

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

646: hr_utility.set_message(800,'HR_74007_BOTH_NOT_NULL');
647: hr_utility.raise_error;
648: --
649: end if;
650: hr_utility.set_location('Leaving:'||l_proc,10);
651: --
652: end chk_basic_exemption_flag;
653: --
654: -- ----------------------------------------------------------------------------

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

686: l_api_updating boolean;
687: --
688: Begin
689: --
690: hr_utility.set_location('Entering:'||l_proc, 5);
691: --
692: l_api_updating := pay_cft_shd.api_updating
693: (p_emp_fed_tax_inf_id => p_emp_fed_tax_inf_id,
694: p_effective_date => p_effective_date,

Line 712: hr_utility.set_message(800,'HR_CA_TAX_CALC_METHOD');

708: p_effective_date => p_effective_date) then
709: --
710: -- raise error as does not exist as lookup
711: --
712: hr_utility.set_message(800,'HR_CA_TAX_CALC_METHOD');
713: hr_utility.raise_error;
714: --
715: end if;
716: --

Line 713: hr_utility.raise_error;

709: --
710: -- raise error as does not exist as lookup
711: --
712: hr_utility.set_message(800,'HR_CA_TAX_CALC_METHOD');
713: hr_utility.raise_error;
714: --
715: end if;
716: --
717: end if;

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

715: end if;
716: --
717: end if;
718: --
719: hr_utility.set_location('Leaving:'||l_proc,10);
720: --
721: end chk_tax_calc_method;
722:
723: --

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

765: l_api_updating boolean;
766: --
767: Begin
768: --
769: hr_utility.set_location('Entering:'||l_proc, 5);
770: p_cpp_election_warning:=FALSE;
771: --
772: l_api_updating := pay_cft_shd.api_updating
773: (p_emp_fed_tax_inf_id => p_emp_fed_tax_inf_id,

Line 782: hr_utility.set_location(l_proc, 2);

778: hr_api.g_date)
779: <> nvl(p_cpp_election_date,hr_api.g_date))
780: or (not l_api_updating))
781: then
782: hr_utility.set_location(l_proc, 2);
783:
784: /* Checking if revocation date is already entered*/
785: if (p_cpp_revocation_date is not null
786: and p_cpp_election_date is not null) then

Line 788: hr_utility.set_message(801, 'PAY_74164_CPP_DATES_EXCLUSIVE');

784: /* Checking if revocation date is already entered*/
785: if (p_cpp_revocation_date is not null
786: and p_cpp_election_date is not null) then
787: -- Error: The CPP Election and Revocation Dates both have been entered
788: hr_utility.set_message(801, 'PAY_74164_CPP_DATES_EXCLUSIVE');
789: hr_utility.raise_error;
790: end if;
791:
792: /* Checking if election date is the first of the month*/

Line 789: hr_utility.raise_error;

785: if (p_cpp_revocation_date is not null
786: and p_cpp_election_date is not null) then
787: -- Error: The CPP Election and Revocation Dates both have been entered
788: hr_utility.set_message(801, 'PAY_74164_CPP_DATES_EXCLUSIVE');
789: hr_utility.raise_error;
790: end if;
791:
792: /* Checking if election date is the first of the month*/
793: if(p_cpp_election_date is not null) then

Line 804: hr_utility.set_message(801, 'PAY_74179_CPP_FLAG_CHECKED');

800:
801: /* Checking if CPP Exempt Flag is checked*/
802: if (p_cpp_qpp_exempt_flag ='Y' and p_cpp_election_date is not null) then
803: -- Error: The CPP Election Date cannot be entered while CPP Exempt flag is checked.
804: hr_utility.set_message(801, 'PAY_74179_CPP_FLAG_CHECKED');
805: hr_utility.raise_error;
806: end if;
807:
808: /*Changes for bug 13542083 - End*/

Line 805: hr_utility.raise_error;

801: /* Checking if CPP Exempt Flag is checked*/
802: if (p_cpp_qpp_exempt_flag ='Y' and p_cpp_election_date is not null) then
803: -- Error: The CPP Election Date cannot be entered while CPP Exempt flag is checked.
804: hr_utility.set_message(801, 'PAY_74179_CPP_FLAG_CHECKED');
805: hr_utility.raise_error;
806: end if;
807:
808: /*Changes for bug 13542083 - End*/
809:

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

809:
810: end if;
811:
812: --
813: hr_utility.set_location('Leaving:'||l_proc,10);
814: --
815: end chk_cpp_election_date;
816: --For Bug Number 13258136
817: -- ----------------------------------------------------------------------------

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

859: --
860: Begin
861: --
862:
863: hr_utility.set_location('Entering:'||l_proc, 5);
864: p_cpp_revocation_warning:=FALSE;
865: --
866: l_api_updating := pay_cft_shd.api_updating
867: (p_emp_fed_tax_inf_id => p_emp_fed_tax_inf_id,

Line 877: hr_utility.set_location(l_proc, 2);

873: hr_api.g_date)
874: <> nvl(p_cpp_revocation_date,hr_api.g_date))
875: or (not l_api_updating)) then
876:
877: hr_utility.set_location(l_proc, 2);
878:
879: /* Checking if election date is already entered*/
880: if (p_cpp_election_date is not null
881: and p_cpp_revocation_date is not null) then

Line 883: hr_utility.set_message(801, 'PAY_74164_CPP_DATES_EXCLUSIVE');

879: /* Checking if election date is already entered*/
880: if (p_cpp_election_date is not null
881: and p_cpp_revocation_date is not null) then
882: -- Error: The CPP Election and Revocation Dates both have been entered
883: hr_utility.set_message(801, 'PAY_74164_CPP_DATES_EXCLUSIVE');
884: hr_utility.raise_error;
885: end if;
886:
887: /* Checking if revocation date is the first of the month*/

Line 884: hr_utility.raise_error;

880: if (p_cpp_election_date is not null
881: and p_cpp_revocation_date is not null) then
882: -- Error: The CPP Election and Revocation Dates both have been entered
883: hr_utility.set_message(801, 'PAY_74164_CPP_DATES_EXCLUSIVE');
884: hr_utility.raise_error;
885: end if;
886:
887: /* Checking if revocation date is the first of the month*/
888: if(p_cpp_revocation_date is not null) then

Line 898: hr_utility.set_message(801, 'PAY_74179_CPP_FLAG_CHECKED');

894: /*Changes for bug 13542083 - Start*/
895: /* Checking if CPP Exempt Flag is checked*/
896: if (p_cpp_qpp_exempt_flag ='Y' and p_cpp_revocation_date is not null) then
897: -- Error: The CPP Revocation Date cannot be entered while CPP Exempt flag is checked.
898: hr_utility.set_message(801, 'PAY_74179_CPP_FLAG_CHECKED');
899: hr_utility.raise_error;
900: end if;
901: /*Changes for bug 13542083 - End*/
902:

Line 899: hr_utility.raise_error;

895: /* Checking if CPP Exempt Flag is checked*/
896: if (p_cpp_qpp_exempt_flag ='Y' and p_cpp_revocation_date is not null) then
897: -- Error: The CPP Revocation Date cannot be entered while CPP Exempt flag is checked.
898: hr_utility.set_message(801, 'PAY_74179_CPP_FLAG_CHECKED');
899: hr_utility.raise_error;
900: end if;
901: /*Changes for bug 13542083 - End*/
902:
903: --

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

901: /*Changes for bug 13542083 - End*/
902:
903: --
904:
905: hr_utility.set_location('Leaving:'||l_proc,10);
906: --
907: end if;
908:
909:

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

948: l_integrity_error Exception;
949: l_table_name all_tables.table_name%TYPE;
950: --
951: Begin
952: hr_utility.set_location('Entering:'||l_proc, 5);
953: --
954: -- Ensure that the p_datetrack_mode argument is not null
955: --
956: hr_api.mandatory_arg_error

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

987: End If;
988: --
989: End If;
990: --
991: hr_utility.set_location(' Leaving:'||l_proc, 10);
992: Exception
993: When l_integrity_error Then
994: --
995: -- A referential integrity check was violated therefore

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

994: --
995: -- A referential integrity check was violated therefore
996: -- we must error
997: --
998: hr_utility.set_message(800, 'HR_7216_DT_UPD_INTEGRITY_ERR');
999: hr_utility.set_message_token('TABLE_NAME', l_table_name);
1000: hr_utility.raise_error;
1001: When Others Then
1002: --

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

995: -- A referential integrity check was violated therefore
996: -- we must error
997: --
998: hr_utility.set_message(800, 'HR_7216_DT_UPD_INTEGRITY_ERR');
999: hr_utility.set_message_token('TABLE_NAME', l_table_name);
1000: hr_utility.raise_error;
1001: When Others Then
1002: --
1003: -- An unhandled or unexpected error has occurred which

Line 1000: hr_utility.raise_error;

996: -- we must error
997: --
998: hr_utility.set_message(800, 'HR_7216_DT_UPD_INTEGRITY_ERR');
999: hr_utility.set_message_token('TABLE_NAME', l_table_name);
1000: hr_utility.raise_error;
1001: When Others Then
1002: --
1003: -- An unhandled or unexpected error has occurred which
1004: -- we must report

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

1002: --
1003: -- An unhandled or unexpected error has occurred which
1004: -- we must report
1005: --
1006: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
1007: hr_utility.set_message_token('PROCEDURE', l_proc);
1008: hr_utility.set_message_token('STEP','15');
1009: hr_utility.raise_error;
1010: End dt_update_validate;

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

1003: -- An unhandled or unexpected error has occurred which
1004: -- we must report
1005: --
1006: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
1007: hr_utility.set_message_token('PROCEDURE', l_proc);
1008: hr_utility.set_message_token('STEP','15');
1009: hr_utility.raise_error;
1010: End dt_update_validate;
1011: --

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

1004: -- we must report
1005: --
1006: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
1007: hr_utility.set_message_token('PROCEDURE', l_proc);
1008: hr_utility.set_message_token('STEP','15');
1009: hr_utility.raise_error;
1010: End dt_update_validate;
1011: --
1012: -- ----------------------------------------------------------------------------

Line 1009: hr_utility.raise_error;

1005: --
1006: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
1007: hr_utility.set_message_token('PROCEDURE', l_proc);
1008: hr_utility.set_message_token('STEP','15');
1009: hr_utility.raise_error;
1010: End dt_update_validate;
1011: --
1012: -- ----------------------------------------------------------------------------
1013: -- |--------------------------< dt_delete_validate >--------------------------|

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

1054: l_rows_exist Exception;
1055: l_table_name all_tables.table_name%TYPE;
1056: --
1057: Begin
1058: hr_utility.set_location('Entering:'||l_proc, 5);
1059: --
1060: -- Ensure that the p_datetrack_mode argument is not null
1061: --
1062: hr_api.mandatory_arg_error

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

1091: --
1092: --
1093: End If;
1094: --
1095: hr_utility.set_location(' Leaving:'||l_proc, 10);
1096: Exception
1097: When l_rows_exist Then
1098: --
1099: -- A referential integrity check was violated therefore

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

1098: --
1099: -- A referential integrity check was violated therefore
1100: -- we must error
1101: --
1102: hr_utility.set_message(800, 'HR_7215_DT_CHILD_EXISTS');
1103: hr_utility.set_message_token('TABLE_NAME', l_table_name);
1104: hr_utility.raise_error;
1105: When Others Then
1106: --

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

1099: -- A referential integrity check was violated therefore
1100: -- we must error
1101: --
1102: hr_utility.set_message(800, 'HR_7215_DT_CHILD_EXISTS');
1103: hr_utility.set_message_token('TABLE_NAME', l_table_name);
1104: hr_utility.raise_error;
1105: When Others Then
1106: --
1107: -- An unhandled or unexpected error has occurred which

Line 1104: hr_utility.raise_error;

1100: -- we must error
1101: --
1102: hr_utility.set_message(800, 'HR_7215_DT_CHILD_EXISTS');
1103: hr_utility.set_message_token('TABLE_NAME', l_table_name);
1104: hr_utility.raise_error;
1105: When Others Then
1106: --
1107: -- An unhandled or unexpected error has occurred which
1108: -- we must report

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

1106: --
1107: -- An unhandled or unexpected error has occurred which
1108: -- we must report
1109: --
1110: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
1111: hr_utility.set_message_token('PROCEDURE', l_proc);
1112: hr_utility.set_message_token('STEP','15');
1113: hr_utility.raise_error;
1114: End dt_delete_validate;

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

1107: -- An unhandled or unexpected error has occurred which
1108: -- we must report
1109: --
1110: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
1111: hr_utility.set_message_token('PROCEDURE', l_proc);
1112: hr_utility.set_message_token('STEP','15');
1113: hr_utility.raise_error;
1114: End dt_delete_validate;
1115: --

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

1108: -- we must report
1109: --
1110: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
1111: hr_utility.set_message_token('PROCEDURE', l_proc);
1112: hr_utility.set_message_token('STEP','15');
1113: hr_utility.raise_error;
1114: End dt_delete_validate;
1115: --
1116: -- ----------------------------------------------------------------------------

Line 1113: hr_utility.raise_error;

1109: --
1110: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
1111: hr_utility.set_message_token('PROCEDURE', l_proc);
1112: hr_utility.set_message_token('STEP','15');
1113: hr_utility.raise_error;
1114: End dt_delete_validate;
1115: --
1116: -- ----------------------------------------------------------------------------
1117: -- |---------------------------< insert_validate >----------------------------|

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

1125: --
1126: l_proc varchar2(72) := g_package||'insert_validate';
1127: --
1128: Begin
1129: hr_utility.set_location('Entering:'||l_proc, 5);
1130: --
1131: -- Call all supporting business operations
1132: --
1133: --dbms_output.put_line('before fed_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 1222: hr_utility.set_location('Entering:'||l_proc, 5);

1218: l_cpp_election_warning boolean; --For Bug Number 13258136
1219: l_cpp_revocation_warning boolean; --For Bug Number 13258136
1220: --
1221: Begin
1222: hr_utility.set_location('Entering:'||l_proc, 5);
1223: --
1224: -- Call all supporting business operations
1225: --
1226: chk_emp_fed_tax_inf_id

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

1309: p_datetrack_mode => p_datetrack_mode,
1310: p_validation_start_date => p_validation_start_date,
1311: p_validation_end_date => p_validation_end_date);
1312: --
1313: hr_utility.set_location(' Leaving:'||l_proc, 10);
1314: End update_validate;
1315: --
1316: -- ----------------------------------------------------------------------------
1317: -- |---------------------------< delete_validate >----------------------------|

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

1325: --
1326: l_proc varchar2(72) := g_package||'delete_validate';
1327: --
1328: Begin
1329: hr_utility.set_location('Entering:'||l_proc, 5);
1330: --
1331: -- Call all supporting business operations
1332: --
1333: dt_delete_validate

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

1335: p_validation_start_date => p_validation_start_date,
1336: p_validation_end_date => p_validation_end_date,
1337: p_emp_fed_tax_inf_id => p_rec.emp_fed_tax_inf_id);
1338: --
1339: hr_utility.set_location(' Leaving:'||l_proc, 10);
1340: End delete_validate;
1341: --
1342: --
1343: -- ---------------------------------------------------------------------------

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

1362: l_proc varchar2(72) := g_package||'return_legislation_code';
1363: --
1364: begin
1365: --
1366: hr_utility.set_location('Entering:'|| l_proc, 10);
1367: --
1368: -- Ensure that all the mandatory parameter are not null
1369: --
1370: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

1380: close csr_leg_code;
1381: --
1382: -- The primary key is invalid therefore we must error
1383: --
1384: hr_utility.set_message(800,'HR_7220_INVALID_PRIMARY_KEY');
1385: hr_utility.raise_error;
1386: --
1387: end if;
1388: --

Line 1385: hr_utility.raise_error;

1381: --
1382: -- The primary key is invalid therefore we must error
1383: --
1384: hr_utility.set_message(800,'HR_7220_INVALID_PRIMARY_KEY');
1385: hr_utility.raise_error;
1386: --
1387: end if;
1388: --
1389: close csr_leg_code;

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

1387: end if;
1388: --
1389: close csr_leg_code;
1390: --
1391: hr_utility.set_location(' Leaving:'|| l_proc, 20);
1392: --
1393: return l_legislation_code;
1394: --
1395: end return_legislation_code;