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_PSD_BUS dependencies on HR_UTILITY

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

39: l_legislation_code varchar2(150);
40: --
41: begin
42: --
43: hr_utility.set_location('Entering:'|| l_proc, 10);
44: --
45: -- Ensure that all the mandatory parameter are not null
46: --
47: hr_api.mandatory_arg_error

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

79: --
80: hr_api.set_legislation_context(l_legislation_code);
81: end if;
82: --
83: hr_utility.set_location(' Leaving:'|| l_proc, 20);
84: --
85: end set_security_group_id;
86: --
87: -- ---------------------------------------------------------------------------

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

108: l_proc varchar2(72) := g_package||'return_legislation_code';
109: --
110: Begin
111: --
112: hr_utility.set_location('Entering:'|| l_proc, 10);
113: --
114: -- Ensure that all the mandatory parameter are not null
115: --
116: hr_api.mandatory_arg_error

Line 130: hr_utility.set_location(l_proc, 20);

126: -- call to this function. Just return the value in the global
127: -- variable.
128: --
129: l_legislation_code := pay_psd_bus.g_legislation_code;
130: hr_utility.set_location(l_proc, 20);
131: else
132: --
133: -- The ID is different to the last call to this function
134: -- or this is the first call to this function.

Line 147: hr_utility.set_location(l_proc,30);

143: close csr_leg_code;
144: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
145: fnd_message.raise_error;
146: end if;
147: hr_utility.set_location(l_proc,30);
148: --
149: -- Set the global variables so the values are
150: -- available for the next call to this function.
151: --

Line 156: hr_utility.set_location(' Leaving:'|| l_proc, 40);

152: close csr_leg_code;
153: pay_psd_bus.g_sii_details_id := p_sii_details_id;
154: pay_psd_bus.g_legislation_code := l_legislation_code;
155: end if;
156: hr_utility.set_location(' Leaving:'|| l_proc, 40);
157: return l_legislation_code;
158: end return_legislation_code;
159: --
160:

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

200:
201: l_proc varchar2(72);
202:
203: Begin
204: hr_utility.set_location('Entering:'|| l_proc, 10);
205: l_proc := g_package ||'chk_contract_category';
206:
207: --
208: -- Check mandatory parameters have been set

Line 235: hr_utility.set_message(801,'PAY_375841_CONTRACT_PL_LOOKUP');

231: ,p_lookup_type => 'PL_CONTRACT_CATEGORY'
232: ,p_lookup_code => p_contract_category
233: ) then
234: -- Error: Invalid Contract Category
235: hr_utility.set_message(801,'PAY_375841_CONTRACT_PL_LOOKUP');
236: -- This message will be 'The Contract Category does not exist in the system'
237: hr_utility.raise_error;
238: end if;
239: end if;

Line 237: hr_utility.raise_error;

233: ) then
234: -- Error: Invalid Contract Category
235: hr_utility.set_message(801,'PAY_375841_CONTRACT_PL_LOOKUP');
236: -- This message will be 'The Contract Category does not exist in the system'
237: hr_utility.raise_error;
238: end if;
239: end if;
240: hr_utility.set_location(' Leaving:'|| l_proc, 20);
241: exception

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

236: -- This message will be 'The Contract Category does not exist in the system'
237: hr_utility.raise_error;
238: end if;
239: end if;
240: hr_utility.set_location(' Leaving:'|| l_proc, 20);
241: exception
242: when app_exception.application_exception then
243: if hr_multi_message.exception_add
244: (p_associated_column1 => 'PAY_PL_SII_DETAILS_F.CONTRACT_CATEGORY'

Line 246: hr_utility.set_location(' Leaving:'|| l_proc, 30);

242: when app_exception.application_exception then
243: if hr_multi_message.exception_add
244: (p_associated_column1 => 'PAY_PL_SII_DETAILS_F.CONTRACT_CATEGORY'
245: ) then
246: hr_utility.set_location(' Leaving:'|| l_proc, 30);
247: raise;
248: end if;
249: hr_utility.set_location(' Leaving:'|| l_proc, 40);
250:

Line 249: hr_utility.set_location(' Leaving:'|| l_proc, 40);

245: ) then
246: hr_utility.set_location(' Leaving:'|| l_proc, 30);
247: raise;
248: end if;
249: hr_utility.set_location(' Leaving:'|| l_proc, 40);
250:
251: End chk_contract_category;
252:
253: --

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

293:
294: l_proc varchar2(72);
295:
296: Begin
297: hr_utility.set_location('Entering:'|| l_proc, 10);
298: l_proc := g_package ||'chk_business_group_id';
299:
300: --
301: -- Check mandatory parameters have been set

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

317: ,p_associated_column1 => pay_psd_shd.g_tab_nam||'.BUSINESS_GROUP_ID');
318:
319: hr_multi_message.end_validation_set;
320:
321: hr_utility.set_location(' Leaving:'|| l_proc, 20);
322: exception
323: when app_exception.application_exception then
324: if hr_multi_message.exception_add
325: (p_associated_column1 => 'PAY_PL_SII_DETAILS_F.BUSINESS_GROUP_ID'

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

323: when app_exception.application_exception then
324: if hr_multi_message.exception_add
325: (p_associated_column1 => 'PAY_PL_SII_DETAILS_F.BUSINESS_GROUP_ID'
326: ) then
327: hr_utility.set_location(' Leaving:'|| l_proc, 30);
328: raise;
329: end if;
330: hr_utility.set_location(' Leaving:'|| l_proc, 40);
331:

Line 330: hr_utility.set_location(' Leaving:'|| l_proc, 40);

326: ) then
327: hr_utility.set_location(' Leaving:'|| l_proc, 30);
328: raise;
329: end if;
330: hr_utility.set_location(' Leaving:'|| l_proc, 40);
331:
332: End chk_business_group_id;
333: --
334: --

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

417: and paaf.soft_coding_keyflex_id = hrsoft.soft_coding_keyflex_id and
418: hrsoft.segment3 = l_term_catg;
419:
420: Begin
421: hr_utility.set_location('Entering:'|| l_proc, 10);
422: l_proc := g_package ||'chk_per_asg_id';
423: l_exists := NULL;
424:
425: l_civil_catg := 'CIVIL';

Line 461: hr_utility.set_message(801,'PAY_375840_INVALID_PL_ASG_ID');

457: open csr_asg_id;
458: fetch csr_asg_id into l_exists;
459: if csr_asg_id%NOTFOUND then
460: -- Raise an error message that the record is not in the business group for the date range specified.
461: hr_utility.set_message(801,'PAY_375840_INVALID_PL_ASG_ID');
462: hr_utility.raise_error;
463: end if;
464: close csr_asg_id;
465:

Line 462: hr_utility.raise_error;

458: fetch csr_asg_id into l_exists;
459: if csr_asg_id%NOTFOUND then
460: -- Raise an error message that the record is not in the business group for the date range specified.
461: hr_utility.set_message(801,'PAY_375840_INVALID_PL_ASG_ID');
462: hr_utility.raise_error;
463: end if;
464: close csr_asg_id;
465:
466: elsif p_contract_category = 'NORMAL' then

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

468: open csr_per_id;
469: fetch csr_per_id into l_exists;
470: if csr_per_id%NOTFOUND then
471: -- Raise an error message that the records isnot in the business group for the date range specified
472: hr_utility.set_message(801,'PAY_375839_INVALID_PL_PER_ID');
473: hr_utility.raise_error;
474: end if;
475: close csr_per_id;
476:

Line 473: hr_utility.raise_error;

469: fetch csr_per_id into l_exists;
470: if csr_per_id%NOTFOUND then
471: -- Raise an error message that the records isnot in the business group for the date range specified
472: hr_utility.set_message(801,'PAY_375839_INVALID_PL_PER_ID');
473: hr_utility.raise_error;
474: end if;
475: close csr_per_id;
476:
477: elsif p_contract_category = 'TERM_NORMAL' then

Line 483: hr_utility.set_message(801,'PAY_375840_INVALID_PL_ASG_ID');

479: open csr_normal_term_id;
480: fetch csr_normal_term_id into l_exists;
481: if csr_normal_term_id%NOTFOUND then
482: -- Raise an error message that the record is not in the business group for the date range
483: hr_utility.set_message(801,'PAY_375840_INVALID_PL_ASG_ID');
484: hr_utility.raise_error;
485: end if;
486: close csr_normal_term_id;
487:

Line 484: hr_utility.raise_error;

480: fetch csr_normal_term_id into l_exists;
481: if csr_normal_term_id%NOTFOUND then
482: -- Raise an error message that the record is not in the business group for the date range
483: hr_utility.set_message(801,'PAY_375840_INVALID_PL_ASG_ID');
484: hr_utility.raise_error;
485: end if;
486: close csr_normal_term_id;
487:
488: end if;

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

487:
488: end if;
489: end if;
490:
491: hr_utility.set_location(' Leaving:'|| l_proc, 20);
492: exception
493: when app_exception.application_exception then
494: if hr_multi_message.exception_add
495: (p_associated_column1 => 'PAY_PL_SII_DETAILS_F.PER_OR_ASG_ID'

Line 497: hr_utility.set_location(' Leaving:'|| l_proc, 30);

493: when app_exception.application_exception then
494: if hr_multi_message.exception_add
495: (p_associated_column1 => 'PAY_PL_SII_DETAILS_F.PER_OR_ASG_ID'
496: ) then
497: hr_utility.set_location(' Leaving:'|| l_proc, 30);
498: raise;
499: end if;
500: hr_utility.set_location(' Leaving:'|| l_proc, 40);
501:

Line 500: hr_utility.set_location(' Leaving:'|| l_proc, 40);

496: ) then
497: hr_utility.set_location(' Leaving:'|| l_proc, 30);
498: raise;
499: end if;
500: hr_utility.set_location(' Leaving:'|| l_proc, 40);
501:
502: End chk_per_asg_id;
503:
504: --

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

554: and put.legislation_code = l_legislation_code
555: and puc.user_column_name = p_emp_social_security_info;
556:
557: Begin
558: hr_utility.set_location('Entering:'|| l_proc, 10);
559: l_proc := g_package ||'chk_emp_social_security_info';
560:
561: -- Assigning values to local variables
562: l_user_table_name := 'PL_EMPLOYEE_SOCIAL_SECURITY_INFORMATION';

Line 605: hr_utility.set_message(801,'PAY_375842_INVALID_SOCIAL_INFO');

601: if p_emp_social_security_info is not null then
602: open csr_emp_social_security_info;
603: fetch csr_emp_social_security_info into l_exists;
604: if csr_emp_social_security_info%NOTFOUND then
605: hr_utility.set_message(801,'PAY_375842_INVALID_SOCIAL_INFO');
606: hr_utility.raise_error;
607: end if;
608: close csr_emp_social_security_info;
609: end if;

Line 606: hr_utility.raise_error;

602: open csr_emp_social_security_info;
603: fetch csr_emp_social_security_info into l_exists;
604: if csr_emp_social_security_info%NOTFOUND then
605: hr_utility.set_message(801,'PAY_375842_INVALID_SOCIAL_INFO');
606: hr_utility.raise_error;
607: end if;
608: close csr_emp_social_security_info;
609: end if;
610: end if;

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

607: end if;
608: close csr_emp_social_security_info;
609: end if;
610: end if;
611: hr_utility.set_location(' Leaving:'|| l_proc, 20);
612: exception
613: when app_exception.application_exception then
614: if hr_multi_message.exception_add
615: (p_associated_column1 => 'PAY_PL_SII_DETAILS_F.EMP_SOCIAL_SECURITY_INFO'

Line 617: hr_utility.set_location(' Leaving:'|| l_proc, 30);

613: when app_exception.application_exception then
614: if hr_multi_message.exception_add
615: (p_associated_column1 => 'PAY_PL_SII_DETAILS_F.EMP_SOCIAL_SECURITY_INFO'
616: ) then
617: hr_utility.set_location(' Leaving:'|| l_proc, 30);
618: raise;
619: end if;
620: hr_utility.set_location(' Leaving:'|| l_proc, 40);
621:

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

616: ) then
617: hr_utility.set_location(' Leaving:'|| l_proc, 30);
618: raise;
619: end if;
620: hr_utility.set_location(' Leaving:'|| l_proc, 40);
621:
622: End chk_emp_social_security_info;
623: --
624: --

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

667: l_proc varchar2(72);
668: l_api_updating boolean;
669:
670: Begin
671: hr_utility.set_location('Entering:'|| l_proc, 10);
672: l_proc := g_package ||'chk_old_age_contribution';
673:
674: --
675: -- Check mandatory parameters have been set

Line 719: hr_utility.set_message(801,'PAY_375843_INVALID_CONTRI_TYPE');

715: ,p_lookup_type => 'PL_CONTRIBUTION_TYPE'
716: ,p_lookup_code => p_old_age_contribution
717: ) then
718: -- Error: Invalid Contract Category
719: hr_utility.set_message(801,'PAY_375843_INVALID_CONTRI_TYPE');
720: -- This message will be 'The Contribution type does not exist in the system'
721: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','OLD_AGE_CONTRIBUTION'));
722: hr_utility.raise_error;
723: end if;

Line 721: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','OLD_AGE_CONTRIBUTION'));

717: ) then
718: -- Error: Invalid Contract Category
719: hr_utility.set_message(801,'PAY_375843_INVALID_CONTRI_TYPE');
720: -- This message will be 'The Contribution type does not exist in the system'
721: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','OLD_AGE_CONTRIBUTION'));
722: hr_utility.raise_error;
723: end if;
724: -- Raise an error if 'Voluntary' is specified for a 'NORMAL' or 'TERM_NORMAL' category
725: if (p_contract_category in ('NORMAL','TERM_NORMAL') and p_old_age_contribution = 'D') then

Line 722: hr_utility.raise_error;

718: -- Error: Invalid Contract Category
719: hr_utility.set_message(801,'PAY_375843_INVALID_CONTRI_TYPE');
720: -- This message will be 'The Contribution type does not exist in the system'
721: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','OLD_AGE_CONTRIBUTION'));
722: hr_utility.raise_error;
723: end if;
724: -- Raise an error if 'Voluntary' is specified for a 'NORMAL' or 'TERM_NORMAL' category
725: if (p_contract_category in ('NORMAL','TERM_NORMAL') and p_old_age_contribution = 'D') then
726: -- Error: Invalid Contract Category

Line 727: hr_utility.set_message(801,'PAY_375871_INVALID_NORMAL_CONT');

723: end if;
724: -- Raise an error if 'Voluntary' is specified for a 'NORMAL' or 'TERM_NORMAL' category
725: if (p_contract_category in ('NORMAL','TERM_NORMAL') and p_old_age_contribution = 'D') then
726: -- Error: Invalid Contract Category
727: hr_utility.set_message(801,'PAY_375871_INVALID_NORMAL_CONT');
728: -- This message will be 'The Contribution type does not exist in the system'
729: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','OLD_AGE_CONTRIBUTION'));
730: hr_utility.raise_error;
731: end if;

Line 729: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','OLD_AGE_CONTRIBUTION'));

725: if (p_contract_category in ('NORMAL','TERM_NORMAL') and p_old_age_contribution = 'D') then
726: -- Error: Invalid Contract Category
727: hr_utility.set_message(801,'PAY_375871_INVALID_NORMAL_CONT');
728: -- This message will be 'The Contribution type does not exist in the system'
729: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','OLD_AGE_CONTRIBUTION'));
730: hr_utility.raise_error;
731: end if;
732: end if;
733: end if;

Line 730: hr_utility.raise_error;

726: -- Error: Invalid Contract Category
727: hr_utility.set_message(801,'PAY_375871_INVALID_NORMAL_CONT');
728: -- This message will be 'The Contribution type does not exist in the system'
729: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','OLD_AGE_CONTRIBUTION'));
730: hr_utility.raise_error;
731: end if;
732: end if;
733: end if;
734: hr_utility.set_location(' Leaving:'|| l_proc, 20);

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

730: hr_utility.raise_error;
731: end if;
732: end if;
733: end if;
734: hr_utility.set_location(' Leaving:'|| l_proc, 20);
735: exception
736: when app_exception.application_exception then
737: if hr_multi_message.exception_add
738: (p_associated_column1 => 'PAY_PL_SII_DETAILS_F.OLD_AGE_CONTRIBUTION'

Line 740: hr_utility.set_location(' Leaving:'|| l_proc, 30);

736: when app_exception.application_exception then
737: if hr_multi_message.exception_add
738: (p_associated_column1 => 'PAY_PL_SII_DETAILS_F.OLD_AGE_CONTRIBUTION'
739: ) then
740: hr_utility.set_location(' Leaving:'|| l_proc, 30);
741: raise;
742: end if;
743: hr_utility.set_location(' Leaving:'|| l_proc, 40);
744:

Line 743: hr_utility.set_location(' Leaving:'|| l_proc, 40);

739: ) then
740: hr_utility.set_location(' Leaving:'|| l_proc, 30);
741: raise;
742: end if;
743: hr_utility.set_location(' Leaving:'|| l_proc, 40);
744:
745: End chk_old_age_contribution;
746: --
747: --

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

790: l_proc varchar2(72);
791: l_api_updating boolean;
792:
793: Begin
794: hr_utility.set_location('Entering:'|| l_proc, 10);
795: l_proc := g_package ||'chk_pension_contribution';
796:
797: --
798: -- Check mandatory parameters have been set

Line 842: hr_utility.set_message(801,'PAY_375843_INVALID_CONTRI_TYPE');

838: ,p_lookup_type => 'PL_CONTRIBUTION_TYPE'
839: ,p_lookup_code => p_pension_contribution
840: ) then
841: -- Error: Invalid Contract Category
842: hr_utility.set_message(801,'PAY_375843_INVALID_CONTRI_TYPE');
843: -- This message will be 'The Contribution type does not exist in the system'
844: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','PENSION_CONTRIBUTION'));
845: hr_utility.raise_error;
846: end if;

Line 844: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','PENSION_CONTRIBUTION'));

840: ) then
841: -- Error: Invalid Contract Category
842: hr_utility.set_message(801,'PAY_375843_INVALID_CONTRI_TYPE');
843: -- This message will be 'The Contribution type does not exist in the system'
844: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','PENSION_CONTRIBUTION'));
845: hr_utility.raise_error;
846: end if;
847:
848: -- Raise an error if 'Voluntary' is specified for a 'NORMAL' or 'TERM_NORMAL' category

Line 845: hr_utility.raise_error;

841: -- Error: Invalid Contract Category
842: hr_utility.set_message(801,'PAY_375843_INVALID_CONTRI_TYPE');
843: -- This message will be 'The Contribution type does not exist in the system'
844: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','PENSION_CONTRIBUTION'));
845: hr_utility.raise_error;
846: end if;
847:
848: -- Raise an error if 'Voluntary' is specified for a 'NORMAL' or 'TERM_NORMAL' category
849: if (p_contract_category in ('NORMAL','TERM_NORMAL') and p_pension_contribution = 'D') then

Line 851: hr_utility.set_message(801,'PAY_375871_INVALID_NORMAL_CONT');

847:
848: -- Raise an error if 'Voluntary' is specified for a 'NORMAL' or 'TERM_NORMAL' category
849: if (p_contract_category in ('NORMAL','TERM_NORMAL') and p_pension_contribution = 'D') then
850: -- Error: Invalid Contract Category
851: hr_utility.set_message(801,'PAY_375871_INVALID_NORMAL_CONT');
852: -- This message will be 'The Contribution type does not exist in the system'
853: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','PENSION_CONTRIBUTION'));
854: hr_utility.raise_error;
855: end if;

Line 853: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','PENSION_CONTRIBUTION'));

849: if (p_contract_category in ('NORMAL','TERM_NORMAL') and p_pension_contribution = 'D') then
850: -- Error: Invalid Contract Category
851: hr_utility.set_message(801,'PAY_375871_INVALID_NORMAL_CONT');
852: -- This message will be 'The Contribution type does not exist in the system'
853: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','PENSION_CONTRIBUTION'));
854: hr_utility.raise_error;
855: end if;
856: end if;
857: end if;

Line 854: hr_utility.raise_error;

850: -- Error: Invalid Contract Category
851: hr_utility.set_message(801,'PAY_375871_INVALID_NORMAL_CONT');
852: -- This message will be 'The Contribution type does not exist in the system'
853: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','PENSION_CONTRIBUTION'));
854: hr_utility.raise_error;
855: end if;
856: end if;
857: end if;
858: hr_utility.set_location(' Leaving:'|| l_proc, 20);

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

854: hr_utility.raise_error;
855: end if;
856: end if;
857: end if;
858: hr_utility.set_location(' Leaving:'|| l_proc, 20);
859: exception
860: when app_exception.application_exception then
861: if hr_multi_message.exception_add
862: (p_associated_column1 => 'PAY_PL_SII_DETAILS_F.PENSION_CONTRIBUTION'

Line 864: hr_utility.set_location(' Leaving:'|| l_proc, 30);

860: when app_exception.application_exception then
861: if hr_multi_message.exception_add
862: (p_associated_column1 => 'PAY_PL_SII_DETAILS_F.PENSION_CONTRIBUTION'
863: ) then
864: hr_utility.set_location(' Leaving:'|| l_proc, 30);
865: raise;
866: end if;
867: hr_utility.set_location(' Leaving:'|| l_proc, 40);
868:

Line 867: hr_utility.set_location(' Leaving:'|| l_proc, 40);

863: ) then
864: hr_utility.set_location(' Leaving:'|| l_proc, 30);
865: raise;
866: end if;
867: hr_utility.set_location(' Leaving:'|| l_proc, 40);
868:
869: End chk_pension_contribution;
870: --
871: --

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

914: l_proc varchar2(72);
915: l_api_updating boolean;
916:
917: Begin
918: hr_utility.set_location('Entering:'|| l_proc, 10);
919: l_proc := g_package ||'chk_sickness_contribution';
920:
921: --
922: -- Check mandatory parameters have been set

Line 966: hr_utility.set_message(801,'PAY_375843_INVALID_CONTRI_TYPE');

962: ,p_lookup_type => 'PL_CONTRIBUTION_TYPE'
963: ,p_lookup_code => p_sickness_contribution
964: ) then
965: -- Error: Invalid Contract Category
966: hr_utility.set_message(801,'PAY_375843_INVALID_CONTRI_TYPE');
967: -- This message will be 'The Contribution type does not exist in the system'
968: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','SICKNESS_CONTRIBUTION'));
969: hr_utility.raise_error;
970: end if;

Line 968: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','SICKNESS_CONTRIBUTION'));

964: ) then
965: -- Error: Invalid Contract Category
966: hr_utility.set_message(801,'PAY_375843_INVALID_CONTRI_TYPE');
967: -- This message will be 'The Contribution type does not exist in the system'
968: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','SICKNESS_CONTRIBUTION'));
969: hr_utility.raise_error;
970: end if;
971:
972: -- Raise an error if 'Voluntary' is specified for a 'NORMAL' or 'TERM_NORMAL' category

Line 969: hr_utility.raise_error;

965: -- Error: Invalid Contract Category
966: hr_utility.set_message(801,'PAY_375843_INVALID_CONTRI_TYPE');
967: -- This message will be 'The Contribution type does not exist in the system'
968: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','SICKNESS_CONTRIBUTION'));
969: hr_utility.raise_error;
970: end if;
971:
972: -- Raise an error if 'Voluntary' is specified for a 'NORMAL' or 'TERM_NORMAL' category
973: if (p_contract_category in ('NORMAL','TERM_NORMAL') and p_sickness_contribution = 'D') then

Line 975: hr_utility.set_message(801,'PAY_375871_INVALID_NORMAL_CONT');

971:
972: -- Raise an error if 'Voluntary' is specified for a 'NORMAL' or 'TERM_NORMAL' category
973: if (p_contract_category in ('NORMAL','TERM_NORMAL') and p_sickness_contribution = 'D') then
974: -- Error: Invalid Contract Category
975: hr_utility.set_message(801,'PAY_375871_INVALID_NORMAL_CONT');
976: -- This message will be 'The Contribution type does not exist in the system'
977: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','SICKNESS_CONTRIBUTION'));
978: hr_utility.raise_error;
979: end if;

Line 977: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','SICKNESS_CONTRIBUTION'));

973: if (p_contract_category in ('NORMAL','TERM_NORMAL') and p_sickness_contribution = 'D') then
974: -- Error: Invalid Contract Category
975: hr_utility.set_message(801,'PAY_375871_INVALID_NORMAL_CONT');
976: -- This message will be 'The Contribution type does not exist in the system'
977: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','SICKNESS_CONTRIBUTION'));
978: hr_utility.raise_error;
979: end if;
980: end if;
981: end if;

Line 978: hr_utility.raise_error;

974: -- Error: Invalid Contract Category
975: hr_utility.set_message(801,'PAY_375871_INVALID_NORMAL_CONT');
976: -- This message will be 'The Contribution type does not exist in the system'
977: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','SICKNESS_CONTRIBUTION'));
978: hr_utility.raise_error;
979: end if;
980: end if;
981: end if;
982: hr_utility.set_location(' Leaving:'|| l_proc, 20);

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

978: hr_utility.raise_error;
979: end if;
980: end if;
981: end if;
982: hr_utility.set_location(' Leaving:'|| l_proc, 20);
983: exception
984: when app_exception.application_exception then
985: if hr_multi_message.exception_add
986: (p_associated_column1 => 'PAY_PL_SII_DETAILS_F.SICKNESS_CONTRIBUTION'

Line 988: hr_utility.set_location(' Leaving:'|| l_proc, 30);

984: when app_exception.application_exception then
985: if hr_multi_message.exception_add
986: (p_associated_column1 => 'PAY_PL_SII_DETAILS_F.SICKNESS_CONTRIBUTION'
987: ) then
988: hr_utility.set_location(' Leaving:'|| l_proc, 30);
989: raise;
990: end if;
991: hr_utility.set_location(' Leaving:'|| l_proc, 40);
992:

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

987: ) then
988: hr_utility.set_location(' Leaving:'|| l_proc, 30);
989: raise;
990: end if;
991: hr_utility.set_location(' Leaving:'|| l_proc, 40);
992:
993: End chk_sickness_contribution;
994: --
995: --

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

1038: l_proc varchar2(72);
1039: l_api_updating boolean;
1040:
1041: Begin
1042: hr_utility.set_location('Entering:'|| l_proc, 10);
1043: l_proc := g_package ||'chk_work_injury_contribution';
1044:
1045: --
1046: -- Check mandatory parameters have been set

Line 1090: hr_utility.set_message(801,'PAY_375843_INVALID_CONTRI_TYPE');

1086: ,p_lookup_type => 'PL_CONTRIBUTION_TYPE'
1087: ,p_lookup_code => p_work_injury_contribution
1088: ) then
1089: -- Error: Invalid Contract Category
1090: hr_utility.set_message(801,'PAY_375843_INVALID_CONTRI_TYPE');
1091: -- This message will be 'The Contribution type does not exist in the system'
1092: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','WORK_INJURY_CONTRIBUTION'));
1093: hr_utility.raise_error;
1094: end if;

Line 1092: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','WORK_INJURY_CONTRIBUTION'));

1088: ) then
1089: -- Error: Invalid Contract Category
1090: hr_utility.set_message(801,'PAY_375843_INVALID_CONTRI_TYPE');
1091: -- This message will be 'The Contribution type does not exist in the system'
1092: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','WORK_INJURY_CONTRIBUTION'));
1093: hr_utility.raise_error;
1094: end if;
1095:
1096: -- Raise an error if 'Voluntary' is specified for a 'NORMAL' or 'TERM_NORMAL' category

Line 1093: hr_utility.raise_error;

1089: -- Error: Invalid Contract Category
1090: hr_utility.set_message(801,'PAY_375843_INVALID_CONTRI_TYPE');
1091: -- This message will be 'The Contribution type does not exist in the system'
1092: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','WORK_INJURY_CONTRIBUTION'));
1093: hr_utility.raise_error;
1094: end if;
1095:
1096: -- Raise an error if 'Voluntary' is specified for a 'NORMAL' or 'TERM_NORMAL' category
1097: if (p_contract_category in ('NORMAL','TERM_NORMAL') and p_work_injury_contribution = 'D') then

Line 1099: hr_utility.set_message(801,'PAY_375871_INVALID_NORMAL_CONT');

1095:
1096: -- Raise an error if 'Voluntary' is specified for a 'NORMAL' or 'TERM_NORMAL' category
1097: if (p_contract_category in ('NORMAL','TERM_NORMAL') and p_work_injury_contribution = 'D') then
1098: -- Error: Invalid Contract Category
1099: hr_utility.set_message(801,'PAY_375871_INVALID_NORMAL_CONT');
1100: -- This message will be 'The Contribution type does not exist in the system'
1101: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','WORK_INJURY_CONTRIBUTION'));
1102: hr_utility.raise_error;
1103: end if;

Line 1101: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','WORK_INJURY_CONTRIBUTION'));

1097: if (p_contract_category in ('NORMAL','TERM_NORMAL') and p_work_injury_contribution = 'D') then
1098: -- Error: Invalid Contract Category
1099: hr_utility.set_message(801,'PAY_375871_INVALID_NORMAL_CONT');
1100: -- This message will be 'The Contribution type does not exist in the system'
1101: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','WORK_INJURY_CONTRIBUTION'));
1102: hr_utility.raise_error;
1103: end if;
1104: end if;
1105: end if;

Line 1102: hr_utility.raise_error;

1098: -- Error: Invalid Contract Category
1099: hr_utility.set_message(801,'PAY_375871_INVALID_NORMAL_CONT');
1100: -- This message will be 'The Contribution type does not exist in the system'
1101: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','WORK_INJURY_CONTRIBUTION'));
1102: hr_utility.raise_error;
1103: end if;
1104: end if;
1105: end if;
1106: hr_utility.set_location(' Leaving:'|| l_proc, 20);

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

1102: hr_utility.raise_error;
1103: end if;
1104: end if;
1105: end if;
1106: hr_utility.set_location(' Leaving:'|| l_proc, 20);
1107: exception
1108: when app_exception.application_exception then
1109: if hr_multi_message.exception_add
1110: (p_associated_column1 => 'PAY_PL_SII_DETAILS_F.WORK_INJURY_CONTRIBUTION'

Line 1112: hr_utility.set_location(' Leaving:'|| l_proc, 30);

1108: when app_exception.application_exception then
1109: if hr_multi_message.exception_add
1110: (p_associated_column1 => 'PAY_PL_SII_DETAILS_F.WORK_INJURY_CONTRIBUTION'
1111: ) then
1112: hr_utility.set_location(' Leaving:'|| l_proc, 30);
1113: raise;
1114: end if;
1115: hr_utility.set_location(' Leaving:'|| l_proc, 40);
1116:

Line 1115: hr_utility.set_location(' Leaving:'|| l_proc, 40);

1111: ) then
1112: hr_utility.set_location(' Leaving:'|| l_proc, 30);
1113: raise;
1114: end if;
1115: hr_utility.set_location(' Leaving:'|| l_proc, 40);
1116:
1117: End chk_work_injury_contribution;
1118: --
1119: --

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

1162: l_proc varchar2(72);
1163: l_api_updating boolean;
1164:
1165: Begin
1166: hr_utility.set_location('Entering:'|| l_proc, 10);
1167: l_proc := g_package ||'chk_labor_contribution';
1168:
1169: --
1170: -- Check mandatory parameters have been set

Line 1214: hr_utility.set_message(801,'PAY_375843_INVALID_CONTRI_TYPE');

1210: ,p_lookup_type => 'PL_CONTRIBUTION_TYPE'
1211: ,p_lookup_code => p_labor_contribution
1212: ) then
1213: -- Error: Invalid Contract Category
1214: hr_utility.set_message(801,'PAY_375843_INVALID_CONTRI_TYPE');
1215: -- This message will be 'The Contribution type does not exist in the system'
1216: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','LABOR_CONTRIBUTION'));
1217: hr_utility.raise_error;
1218: end if;

Line 1216: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','LABOR_CONTRIBUTION'));

1212: ) then
1213: -- Error: Invalid Contract Category
1214: hr_utility.set_message(801,'PAY_375843_INVALID_CONTRI_TYPE');
1215: -- This message will be 'The Contribution type does not exist in the system'
1216: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','LABOR_CONTRIBUTION'));
1217: hr_utility.raise_error;
1218: end if;
1219: -- Raise an error if 'Voluntary' is specified for a 'NORMAL' or 'TERM_NORMAL' category
1220: if (p_contract_category in ('NORMAL','TERM_NORMAL') and p_labor_contribution = 'D') then

Line 1217: hr_utility.raise_error;

1213: -- Error: Invalid Contract Category
1214: hr_utility.set_message(801,'PAY_375843_INVALID_CONTRI_TYPE');
1215: -- This message will be 'The Contribution type does not exist in the system'
1216: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','LABOR_CONTRIBUTION'));
1217: hr_utility.raise_error;
1218: end if;
1219: -- Raise an error if 'Voluntary' is specified for a 'NORMAL' or 'TERM_NORMAL' category
1220: if (p_contract_category in ('NORMAL','TERM_NORMAL') and p_labor_contribution = 'D') then
1221: -- Error: Invalid Contract Category

Line 1222: hr_utility.set_message(801,'PAY_375871_INVALID_NORMAL_CONT');

1218: end if;
1219: -- Raise an error if 'Voluntary' is specified for a 'NORMAL' or 'TERM_NORMAL' category
1220: if (p_contract_category in ('NORMAL','TERM_NORMAL') and p_labor_contribution = 'D') then
1221: -- Error: Invalid Contract Category
1222: hr_utility.set_message(801,'PAY_375871_INVALID_NORMAL_CONT');
1223: -- This message will be 'The Contribution type does not exist in the system'
1224: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','LABOR_CONTRIBUTION'));
1225: hr_utility.raise_error;
1226: end if;

Line 1224: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','LABOR_CONTRIBUTION'));

1220: if (p_contract_category in ('NORMAL','TERM_NORMAL') and p_labor_contribution = 'D') then
1221: -- Error: Invalid Contract Category
1222: hr_utility.set_message(801,'PAY_375871_INVALID_NORMAL_CONT');
1223: -- This message will be 'The Contribution type does not exist in the system'
1224: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','LABOR_CONTRIBUTION'));
1225: hr_utility.raise_error;
1226: end if;
1227: end if;
1228: end if;

Line 1225: hr_utility.raise_error;

1221: -- Error: Invalid Contract Category
1222: hr_utility.set_message(801,'PAY_375871_INVALID_NORMAL_CONT');
1223: -- This message will be 'The Contribution type does not exist in the system'
1224: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','LABOR_CONTRIBUTION'));
1225: hr_utility.raise_error;
1226: end if;
1227: end if;
1228: end if;
1229: hr_utility.set_location(' Leaving:'|| l_proc, 20);

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

1225: hr_utility.raise_error;
1226: end if;
1227: end if;
1228: end if;
1229: hr_utility.set_location(' Leaving:'|| l_proc, 20);
1230: exception
1231: when app_exception.application_exception then
1232: if hr_multi_message.exception_add
1233: (p_associated_column1 => 'PAY_PL_SII_DETAILS_F.LABOR_CONTRIBUTION'

Line 1235: hr_utility.set_location(' Leaving:'|| l_proc, 30);

1231: when app_exception.application_exception then
1232: if hr_multi_message.exception_add
1233: (p_associated_column1 => 'PAY_PL_SII_DETAILS_F.LABOR_CONTRIBUTION'
1234: ) then
1235: hr_utility.set_location(' Leaving:'|| l_proc, 30);
1236: raise;
1237: end if;
1238: hr_utility.set_location(' Leaving:'|| l_proc, 40);
1239:

Line 1238: hr_utility.set_location(' Leaving:'|| l_proc, 40);

1234: ) then
1235: hr_utility.set_location(' Leaving:'|| l_proc, 30);
1236: raise;
1237: end if;
1238: hr_utility.set_location(' Leaving:'|| l_proc, 40);
1239:
1240: End chk_labor_contribution;
1241: --
1242: --

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

1285: l_proc varchar2(72);
1286: l_api_updating boolean;
1287:
1288: Begin
1289: hr_utility.set_location('Entering:'|| l_proc, 10);
1290: l_proc := g_package ||'chk_health_contribution';
1291:
1292: --
1293: -- Check mandatory parameters have been set

Line 1337: hr_utility.set_message(801,'PAY_375843_INVALID_CONTRI_TYPE');

1333: ,p_lookup_type => 'PL_CONTRIBUTION_TYPE'
1334: ,p_lookup_code => p_health_contribution
1335: ) then
1336: -- Error: Invalid Contract Category
1337: hr_utility.set_message(801,'PAY_375843_INVALID_CONTRI_TYPE');
1338: -- This message will be 'The Contribution type does not exist in the system'
1339: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','HEALTH_CONTRIBUTION'));
1340: hr_utility.raise_error;
1341: end if;

Line 1339: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','HEALTH_CONTRIBUTION'));

1335: ) then
1336: -- Error: Invalid Contract Category
1337: hr_utility.set_message(801,'PAY_375843_INVALID_CONTRI_TYPE');
1338: -- This message will be 'The Contribution type does not exist in the system'
1339: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','HEALTH_CONTRIBUTION'));
1340: hr_utility.raise_error;
1341: end if;
1342:
1343: -- Raise an error if 'Voluntary' is specified for a 'NORMAL' or 'TERM_NORMAL' category

Line 1340: hr_utility.raise_error;

1336: -- Error: Invalid Contract Category
1337: hr_utility.set_message(801,'PAY_375843_INVALID_CONTRI_TYPE');
1338: -- This message will be 'The Contribution type does not exist in the system'
1339: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','HEALTH_CONTRIBUTION'));
1340: hr_utility.raise_error;
1341: end if;
1342:
1343: -- Raise an error if 'Voluntary' is specified for a 'NORMAL' or 'TERM_NORMAL' category
1344: if (p_contract_category in ('NORMAL','TERM_NORMAL') and p_health_contribution = 'D') then

Line 1346: hr_utility.set_message(801,'PAY_375871_INVALID_NORMAL_CONT');

1342:
1343: -- Raise an error if 'Voluntary' is specified for a 'NORMAL' or 'TERM_NORMAL' category
1344: if (p_contract_category in ('NORMAL','TERM_NORMAL') and p_health_contribution = 'D') then
1345: -- Error: Invalid Contract Category
1346: hr_utility.set_message(801,'PAY_375871_INVALID_NORMAL_CONT');
1347: -- This message will be 'The Contribution type does not exist in the system'
1348: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','HEALTH_CONTRIBUTION'));
1349: hr_utility.raise_error;
1350: end if;

Line 1348: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','HEALTH_CONTRIBUTION'));

1344: if (p_contract_category in ('NORMAL','TERM_NORMAL') and p_health_contribution = 'D') then
1345: -- Error: Invalid Contract Category
1346: hr_utility.set_message(801,'PAY_375871_INVALID_NORMAL_CONT');
1347: -- This message will be 'The Contribution type does not exist in the system'
1348: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','HEALTH_CONTRIBUTION'));
1349: hr_utility.raise_error;
1350: end if;
1351: end if;
1352: end if;

Line 1349: hr_utility.raise_error;

1345: -- Error: Invalid Contract Category
1346: hr_utility.set_message(801,'PAY_375871_INVALID_NORMAL_CONT');
1347: -- This message will be 'The Contribution type does not exist in the system'
1348: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','HEALTH_CONTRIBUTION'));
1349: hr_utility.raise_error;
1350: end if;
1351: end if;
1352: end if;
1353: hr_utility.set_location(' Leaving:'|| l_proc, 20);

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

1349: hr_utility.raise_error;
1350: end if;
1351: end if;
1352: end if;
1353: hr_utility.set_location(' Leaving:'|| l_proc, 20);
1354: exception
1355: when app_exception.application_exception then
1356: if hr_multi_message.exception_add
1357: (p_associated_column1 => 'PAY_PL_SII_DETAILS_F.HEALTH_CONTRIBUTION'

Line 1359: hr_utility.set_location(' Leaving:'|| l_proc, 30);

1355: when app_exception.application_exception then
1356: if hr_multi_message.exception_add
1357: (p_associated_column1 => 'PAY_PL_SII_DETAILS_F.HEALTH_CONTRIBUTION'
1358: ) then
1359: hr_utility.set_location(' Leaving:'|| l_proc, 30);
1360: raise;
1361: end if;
1362: hr_utility.set_location(' Leaving:'|| l_proc, 40);
1363:

Line 1362: hr_utility.set_location(' Leaving:'|| l_proc, 40);

1358: ) then
1359: hr_utility.set_location(' Leaving:'|| l_proc, 30);
1360: raise;
1361: end if;
1362: hr_utility.set_location(' Leaving:'|| l_proc, 40);
1363:
1364: End chk_health_contribution;
1365: --
1366:

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

1410: l_proc varchar2(72);
1411: l_api_updating boolean;
1412:
1413: Begin
1414: hr_utility.set_location('Entering:'|| l_proc, 10);
1415: l_proc := g_package ||'chk_unemployment_contribution';
1416:
1417: --
1418: -- Check mandatory parameters have been set

Line 1462: hr_utility.set_message(801,'PAY_375843_INVALID_CONTRI_TYPE');

1458: ,p_lookup_type => 'PL_CONTRIBUTION_TYPE'
1459: ,p_lookup_code => p_unemployment_contribution
1460: ) then
1461: -- Error: Invalid Contract Category
1462: hr_utility.set_message(801,'PAY_375843_INVALID_CONTRI_TYPE');
1463: -- This message will be 'The Contribution type does not exist in the system'
1464: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','UNEMPLOYMENT_CONTRIBUTION'));
1465: hr_utility.raise_error;
1466: end if;

Line 1464: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','UNEMPLOYMENT_CONTRIBUTION'));

1460: ) then
1461: -- Error: Invalid Contract Category
1462: hr_utility.set_message(801,'PAY_375843_INVALID_CONTRI_TYPE');
1463: -- This message will be 'The Contribution type does not exist in the system'
1464: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','UNEMPLOYMENT_CONTRIBUTION'));
1465: hr_utility.raise_error;
1466: end if;
1467:
1468: -- Raise an error if 'Voluntary' is specified for a 'NORMAL' or 'TERM_NORMAL' category

Line 1465: hr_utility.raise_error;

1461: -- Error: Invalid Contract Category
1462: hr_utility.set_message(801,'PAY_375843_INVALID_CONTRI_TYPE');
1463: -- This message will be 'The Contribution type does not exist in the system'
1464: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','UNEMPLOYMENT_CONTRIBUTION'));
1465: hr_utility.raise_error;
1466: end if;
1467:
1468: -- Raise an error if 'Voluntary' is specified for a 'NORMAL' or 'TERM_NORMAL' category
1469: if (p_contract_category in ('NORMAL','TERM_NORMAL') and p_unemployment_contribution = 'D') then

Line 1471: hr_utility.set_message(801,'PAY_375871_INVALID_NORMAL_CONT');

1467:
1468: -- Raise an error if 'Voluntary' is specified for a 'NORMAL' or 'TERM_NORMAL' category
1469: if (p_contract_category in ('NORMAL','TERM_NORMAL') and p_unemployment_contribution = 'D') then
1470: -- Error: Invalid Contract Category
1471: hr_utility.set_message(801,'PAY_375871_INVALID_NORMAL_CONT');
1472: -- This message will be 'The Contribution type does not exist in the system'
1473: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','UNEMPLOYMENT_CONTRIBUTION'));
1474: hr_utility.raise_error;
1475: end if;

Line 1473: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','UNEMPLOYMENT_CONTRIBUTION'));

1469: if (p_contract_category in ('NORMAL','TERM_NORMAL') and p_unemployment_contribution = 'D') then
1470: -- Error: Invalid Contract Category
1471: hr_utility.set_message(801,'PAY_375871_INVALID_NORMAL_CONT');
1472: -- This message will be 'The Contribution type does not exist in the system'
1473: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','UNEMPLOYMENT_CONTRIBUTION'));
1474: hr_utility.raise_error;
1475: end if;
1476: end if;
1477: end if;

Line 1474: hr_utility.raise_error;

1470: -- Error: Invalid Contract Category
1471: hr_utility.set_message(801,'PAY_375871_INVALID_NORMAL_CONT');
1472: -- This message will be 'The Contribution type does not exist in the system'
1473: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','UNEMPLOYMENT_CONTRIBUTION'));
1474: hr_utility.raise_error;
1475: end if;
1476: end if;
1477: end if;
1478: hr_utility.set_location(' Leaving:'|| l_proc, 20);

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

1474: hr_utility.raise_error;
1475: end if;
1476: end if;
1477: end if;
1478: hr_utility.set_location(' Leaving:'|| l_proc, 20);
1479: exception
1480: when app_exception.application_exception then
1481: if hr_multi_message.exception_add
1482: (p_associated_column1 => 'PAY_PL_SII_DETAILS_F.UNEMPLOYMENT_CONTRIBUTION'

Line 1484: hr_utility.set_location(' Leaving:'|| l_proc, 30);

1480: when app_exception.application_exception then
1481: if hr_multi_message.exception_add
1482: (p_associated_column1 => 'PAY_PL_SII_DETAILS_F.UNEMPLOYMENT_CONTRIBUTION'
1483: ) then
1484: hr_utility.set_location(' Leaving:'|| l_proc, 30);
1485: raise;
1486: end if;
1487: hr_utility.set_location(' Leaving:'|| l_proc, 40);
1488:

Line 1487: hr_utility.set_location(' Leaving:'|| l_proc, 40);

1483: ) then
1484: hr_utility.set_location(' Leaving:'|| l_proc, 30);
1485: raise;
1486: end if;
1487: hr_utility.set_location(' Leaving:'|| l_proc, 40);
1488:
1489: End chk_unemployment_contribution;
1490: --
1491: --

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

1536:
1537:
1538:
1539: Begin
1540: hr_utility.set_location('Entering:'|| l_proc, 10);
1541: l_proc := g_package ||'chk_old_age_cont_end_reason';
1542:
1543: --
1544: -- Check mandatory parameters have been set

Line 1574: hr_utility.set_message(801,'PAY_375844_CONT_END_REQD');

1570:
1571: if p_old_age_contribution = 'N' and
1572: nvl(pay_psd_shd.g_old_rec.old_age_contribution,'N') <> 'N' then
1573: if p_old_age_cont_end_reason is null then
1574: hr_utility.set_message(801,'PAY_375844_CONT_END_REQD');
1575: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','OLD_AGE_CONTRIBUTION'));
1576: hr_utility.raise_error;
1577: end if;
1578: end if;

Line 1575: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','OLD_AGE_CONTRIBUTION'));

1571: if p_old_age_contribution = 'N' and
1572: nvl(pay_psd_shd.g_old_rec.old_age_contribution,'N') <> 'N' then
1573: if p_old_age_cont_end_reason is null then
1574: hr_utility.set_message(801,'PAY_375844_CONT_END_REQD');
1575: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','OLD_AGE_CONTRIBUTION'));
1576: hr_utility.raise_error;
1577: end if;
1578: end if;
1579:

Line 1576: hr_utility.raise_error;

1572: nvl(pay_psd_shd.g_old_rec.old_age_contribution,'N') <> 'N' then
1573: if p_old_age_cont_end_reason is null then
1574: hr_utility.set_message(801,'PAY_375844_CONT_END_REQD');
1575: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','OLD_AGE_CONTRIBUTION'));
1576: hr_utility.raise_error;
1577: end if;
1578: end if;
1579:
1580: if (l_api_updating and nvl(pay_psd_shd.g_old_rec.old_age_cont_end_reason,

Line 1597: hr_utility.set_message(801,'PAY_375845_INVALID_END_REASON');

1593: ,p_lookup_type => 'PL_CONTRIBUTION_END_REASON'
1594: ,p_lookup_code => p_old_age_cont_end_reason
1595: ) then
1596: -- Error: Invalid Contract Category
1597: hr_utility.set_message(801,'PAY_375845_INVALID_END_REASON');
1598: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','OLD_AGE_CONTRIBUTION'));
1599: -- This message will be 'The Old Age Contribution End Reason type
1600: -- does not exist in the system'
1601: hr_utility.raise_error;

Line 1598: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','OLD_AGE_CONTRIBUTION'));

1594: ,p_lookup_code => p_old_age_cont_end_reason
1595: ) then
1596: -- Error: Invalid Contract Category
1597: hr_utility.set_message(801,'PAY_375845_INVALID_END_REASON');
1598: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','OLD_AGE_CONTRIBUTION'));
1599: -- This message will be 'The Old Age Contribution End Reason type
1600: -- does not exist in the system'
1601: hr_utility.raise_error;
1602: end if;

Line 1601: hr_utility.raise_error;

1597: hr_utility.set_message(801,'PAY_375845_INVALID_END_REASON');
1598: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','OLD_AGE_CONTRIBUTION'));
1599: -- This message will be 'The Old Age Contribution End Reason type
1600: -- does not exist in the system'
1601: hr_utility.raise_error;
1602: end if;
1603:
1604: -- If the Old Age Contribution End Reason is not null then the value of Old Age
1605: -- Contribution shud be 'No Contribution'.

Line 1610: hr_utility.set_message(801,'PAY_375846_CONTRI_TYPE_REQD');

1606:
1607: if p_old_age_contribution <> 'N' then
1608: -- Raise an error that Old Age Contribution should be 'No Contribution'
1609: -- when Old Age Contribution End Reason has been specified
1610: hr_utility.set_message(801,'PAY_375846_CONTRI_TYPE_REQD');
1611: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','OLD_AGE_CONTRIBUTION'));
1612: hr_utility.raise_error;
1613: end if;
1614:

Line 1611: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','OLD_AGE_CONTRIBUTION'));

1607: if p_old_age_contribution <> 'N' then
1608: -- Raise an error that Old Age Contribution should be 'No Contribution'
1609: -- when Old Age Contribution End Reason has been specified
1610: hr_utility.set_message(801,'PAY_375846_CONTRI_TYPE_REQD');
1611: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','OLD_AGE_CONTRIBUTION'));
1612: hr_utility.raise_error;
1613: end if;
1614:
1615:

Line 1612: hr_utility.raise_error;

1608: -- Raise an error that Old Age Contribution should be 'No Contribution'
1609: -- when Old Age Contribution End Reason has been specified
1610: hr_utility.set_message(801,'PAY_375846_CONTRI_TYPE_REQD');
1611: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','OLD_AGE_CONTRIBUTION'));
1612: hr_utility.raise_error;
1613: end if;
1614:
1615:
1616: -- If the value of the OLD_AGE_CONTRIBUTION has remained unchanged (and its

Line 1623: hr_utility.set_message(801,'PAY_375847_INCORREC_END_REASON');

1619: -- been changed from NULL to a not NULL value, then an error should be raised
1620:
1621: if p_old_age_contribution = 'N' and
1622: pay_psd_shd.g_old_rec.old_age_contribution = 'N' then
1623: hr_utility.set_message(801,'PAY_375847_INCORREC_END_REASON');
1624: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','OLD_AGE_CONTRIBUTION'));
1625: hr_utility.raise_error;
1626: end if;
1627:

Line 1624: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','OLD_AGE_CONTRIBUTION'));

1620:
1621: if p_old_age_contribution = 'N' and
1622: pay_psd_shd.g_old_rec.old_age_contribution = 'N' then
1623: hr_utility.set_message(801,'PAY_375847_INCORREC_END_REASON');
1624: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','OLD_AGE_CONTRIBUTION'));
1625: hr_utility.raise_error;
1626: end if;
1627:
1628:

Line 1625: hr_utility.raise_error;

1621: if p_old_age_contribution = 'N' and
1622: pay_psd_shd.g_old_rec.old_age_contribution = 'N' then
1623: hr_utility.set_message(801,'PAY_375847_INCORREC_END_REASON');
1624: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','OLD_AGE_CONTRIBUTION'));
1625: hr_utility.raise_error;
1626: end if;
1627:
1628:
1629: end if;

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

1628:
1629: end if;
1630: end if;
1631: end if;
1632: hr_utility.set_location(' Leaving:'|| l_proc, 20);
1633: exception
1634: when app_exception.application_exception then
1635: if hr_multi_message.exception_add
1636: (p_associated_column1 => 'PAY_PL_SII_DETAILS_F.OLD_AGE_CONT_END_REASON'

Line 1638: hr_utility.set_location(' Leaving:'|| l_proc, 30);

1634: when app_exception.application_exception then
1635: if hr_multi_message.exception_add
1636: (p_associated_column1 => 'PAY_PL_SII_DETAILS_F.OLD_AGE_CONT_END_REASON'
1637: ) then
1638: hr_utility.set_location(' Leaving:'|| l_proc, 30);
1639: raise;
1640: end if;
1641: hr_utility.set_location(' Leaving:'|| l_proc, 40);
1642:

Line 1641: hr_utility.set_location(' Leaving:'|| l_proc, 40);

1637: ) then
1638: hr_utility.set_location(' Leaving:'|| l_proc, 30);
1639: raise;
1640: end if;
1641: hr_utility.set_location(' Leaving:'|| l_proc, 40);
1642:
1643: End chk_old_age_cont_end_reason;
1644: --
1645: --

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

1691:
1692:
1693:
1694: Begin
1695: hr_utility.set_location('Entering:'|| l_proc, 10);
1696: l_proc := g_package ||'chk_pension_cont_end_reason';
1697:
1698: --
1699: -- Check mandatory parameters have been set

Line 1729: hr_utility.set_message(801,'PAY_375844_CONT_END_REQD');

1725:
1726: if p_pension_contribution = 'N' and
1727: nvl(pay_psd_shd.g_old_rec.pension_contribution,'N') <> 'N' then
1728: if p_pension_cont_end_reason is null then
1729: hr_utility.set_message(801,'PAY_375844_CONT_END_REQD');
1730: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','PENSION_CONTRIBUTION'));
1731: hr_utility.raise_error;
1732: end if;
1733: end if;

Line 1730: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','PENSION_CONTRIBUTION'));

1726: if p_pension_contribution = 'N' and
1727: nvl(pay_psd_shd.g_old_rec.pension_contribution,'N') <> 'N' then
1728: if p_pension_cont_end_reason is null then
1729: hr_utility.set_message(801,'PAY_375844_CONT_END_REQD');
1730: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','PENSION_CONTRIBUTION'));
1731: hr_utility.raise_error;
1732: end if;
1733: end if;
1734:

Line 1731: hr_utility.raise_error;

1727: nvl(pay_psd_shd.g_old_rec.pension_contribution,'N') <> 'N' then
1728: if p_pension_cont_end_reason is null then
1729: hr_utility.set_message(801,'PAY_375844_CONT_END_REQD');
1730: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','PENSION_CONTRIBUTION'));
1731: hr_utility.raise_error;
1732: end if;
1733: end if;
1734:
1735: if (l_api_updating and nvl(pay_psd_shd.g_old_rec.pension_cont_end_reason,

Line 1752: hr_utility.set_message(801,'PAY_375845_INVALID_END_REASON');

1748: ,p_lookup_type => 'PL_CONTRIBUTION_END_REASON'
1749: ,p_lookup_code => p_pension_cont_end_reason
1750: ) then
1751: -- Error: Invalid Contract Category
1752: hr_utility.set_message(801,'PAY_375845_INVALID_END_REASON');
1753: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','PENSION_CONTRIBUTION'));
1754: -- This message will be 'The Pension Contribution End Reason type
1755: -- does not exist in the system'
1756: hr_utility.raise_error;

Line 1753: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','PENSION_CONTRIBUTION'));

1749: ,p_lookup_code => p_pension_cont_end_reason
1750: ) then
1751: -- Error: Invalid Contract Category
1752: hr_utility.set_message(801,'PAY_375845_INVALID_END_REASON');
1753: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','PENSION_CONTRIBUTION'));
1754: -- This message will be 'The Pension Contribution End Reason type
1755: -- does not exist in the system'
1756: hr_utility.raise_error;
1757: end if;

Line 1756: hr_utility.raise_error;

1752: hr_utility.set_message(801,'PAY_375845_INVALID_END_REASON');
1753: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','PENSION_CONTRIBUTION'));
1754: -- This message will be 'The Pension Contribution End Reason type
1755: -- does not exist in the system'
1756: hr_utility.raise_error;
1757: end if;
1758:
1759: -- If the Pension Contribution End Reason is not null then the value of Pension
1760: -- Contribution shud be 'No Contribution'.

Line 1765: hr_utility.set_message(801,'PAY_375846_CONTRI_TYPE_REQD');

1761:
1762: if p_pension_contribution <> 'N' then
1763: -- Raise an error that Pension Contribution should be 'No Contribution'
1764: -- when Pension Contribution End Reason has been specified
1765: hr_utility.set_message(801,'PAY_375846_CONTRI_TYPE_REQD');
1766: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','PENSION_CONTRIBUTION'));
1767: hr_utility.raise_error;
1768: end if;
1769:

Line 1766: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','PENSION_CONTRIBUTION'));

1762: if p_pension_contribution <> 'N' then
1763: -- Raise an error that Pension Contribution should be 'No Contribution'
1764: -- when Pension Contribution End Reason has been specified
1765: hr_utility.set_message(801,'PAY_375846_CONTRI_TYPE_REQD');
1766: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','PENSION_CONTRIBUTION'));
1767: hr_utility.raise_error;
1768: end if;
1769:
1770:

Line 1767: hr_utility.raise_error;

1763: -- Raise an error that Pension Contribution should be 'No Contribution'
1764: -- when Pension Contribution End Reason has been specified
1765: hr_utility.set_message(801,'PAY_375846_CONTRI_TYPE_REQD');
1766: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','PENSION_CONTRIBUTION'));
1767: hr_utility.raise_error;
1768: end if;
1769:
1770:
1771: -- If the value of the PENSION_CONTRIBUTION has remained unchanged (and its

Line 1778: hr_utility.set_message(801,'PAY_375847_INCORREC_END_REASON');

1774: -- been changed from NULL to a not NULL value, then an error should be raised
1775:
1776: if p_pension_contribution = 'N' and
1777: pay_psd_shd.g_old_rec.pension_contribution = 'N' then
1778: hr_utility.set_message(801,'PAY_375847_INCORREC_END_REASON');
1779: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','PENSION_CONTRIBUTION'));
1780: end if;
1781:
1782:

Line 1779: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','PENSION_CONTRIBUTION'));

1775:
1776: if p_pension_contribution = 'N' and
1777: pay_psd_shd.g_old_rec.pension_contribution = 'N' then
1778: hr_utility.set_message(801,'PAY_375847_INCORREC_END_REASON');
1779: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','PENSION_CONTRIBUTION'));
1780: end if;
1781:
1782:
1783: end if;

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

1782:
1783: end if;
1784: end if;
1785: end if;
1786: hr_utility.set_location(' Leaving:'|| l_proc, 20);
1787: exception
1788: when app_exception.application_exception then
1789: if hr_multi_message.exception_add
1790: (p_associated_column1 => 'PAY_PL_SII_DETAILS_F.PENSION_CONT_END_REASON'

Line 1792: hr_utility.set_location(' Leaving:'|| l_proc, 30);

1788: when app_exception.application_exception then
1789: if hr_multi_message.exception_add
1790: (p_associated_column1 => 'PAY_PL_SII_DETAILS_F.PENSION_CONT_END_REASON'
1791: ) then
1792: hr_utility.set_location(' Leaving:'|| l_proc, 30);
1793: raise;
1794: end if;
1795: hr_utility.set_location(' Leaving:'|| l_proc, 40);
1796:

Line 1795: hr_utility.set_location(' Leaving:'|| l_proc, 40);

1791: ) then
1792: hr_utility.set_location(' Leaving:'|| l_proc, 30);
1793: raise;
1794: end if;
1795: hr_utility.set_location(' Leaving:'|| l_proc, 40);
1796:
1797: End chk_pension_cont_end_reason;
1798: --
1799: --

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

1844:
1845:
1846:
1847: Begin
1848: hr_utility.set_location('Entering:'|| l_proc, 10);
1849: l_proc := g_package ||'chk_sickness_cont_end_reason';
1850:
1851: --
1852: -- Check mandatory parameters have been set

Line 1882: hr_utility.set_message(801,'PAY_375844_CONT_END_REQD');

1878:
1879: if p_sickness_contribution = 'N' and
1880: nvl(pay_psd_shd.g_old_rec.sickness_contribution,'N') <> 'N' then
1881: if p_sickness_cont_end_reason is null then
1882: hr_utility.set_message(801,'PAY_375844_CONT_END_REQD');
1883: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','SICKNESS_CONTRIBUTION'));
1884: hr_utility.raise_error;
1885: end if;
1886: end if;

Line 1883: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','SICKNESS_CONTRIBUTION'));

1879: if p_sickness_contribution = 'N' and
1880: nvl(pay_psd_shd.g_old_rec.sickness_contribution,'N') <> 'N' then
1881: if p_sickness_cont_end_reason is null then
1882: hr_utility.set_message(801,'PAY_375844_CONT_END_REQD');
1883: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','SICKNESS_CONTRIBUTION'));
1884: hr_utility.raise_error;
1885: end if;
1886: end if;
1887:

Line 1884: hr_utility.raise_error;

1880: nvl(pay_psd_shd.g_old_rec.sickness_contribution,'N') <> 'N' then
1881: if p_sickness_cont_end_reason is null then
1882: hr_utility.set_message(801,'PAY_375844_CONT_END_REQD');
1883: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','SICKNESS_CONTRIBUTION'));
1884: hr_utility.raise_error;
1885: end if;
1886: end if;
1887:
1888: if (l_api_updating and nvl(pay_psd_shd.g_old_rec.sickness_cont_end_reason,

Line 1905: hr_utility.set_message(801,'PAY_375845_INVALID_END_REASON');

1901: ,p_lookup_type => 'PL_CONTRIBUTION_END_REASON'
1902: ,p_lookup_code => p_sickness_cont_end_reason
1903: ) then
1904: -- Error: Invalid Contract Category
1905: hr_utility.set_message(801,'PAY_375845_INVALID_END_REASON');
1906: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','SICKNESS_CONTRIBUTION'));
1907: -- This message will be 'The Sickness Contribution End Reason type
1908: -- does not exist in the system'
1909: hr_utility.raise_error;

Line 1906: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','SICKNESS_CONTRIBUTION'));

1902: ,p_lookup_code => p_sickness_cont_end_reason
1903: ) then
1904: -- Error: Invalid Contract Category
1905: hr_utility.set_message(801,'PAY_375845_INVALID_END_REASON');
1906: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','SICKNESS_CONTRIBUTION'));
1907: -- This message will be 'The Sickness Contribution End Reason type
1908: -- does not exist in the system'
1909: hr_utility.raise_error;
1910: end if;

Line 1909: hr_utility.raise_error;

1905: hr_utility.set_message(801,'PAY_375845_INVALID_END_REASON');
1906: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','SICKNESS_CONTRIBUTION'));
1907: -- This message will be 'The Sickness Contribution End Reason type
1908: -- does not exist in the system'
1909: hr_utility.raise_error;
1910: end if;
1911:
1912: -- If the Sickness Contribution End Reason is not null then the value of Sickness
1913: -- Contribution shud be 'No Contribution'.

Line 1918: hr_utility.set_message(801,'PAY_375846_CONTRI_TYPE_REQD');

1914:
1915: if p_sickness_contribution <> 'N' then
1916: -- Raise an error that Sickness Contribution should be 'No Contribution'
1917: -- when Sickness Contribution End Reason has been specified
1918: hr_utility.set_message(801,'PAY_375846_CONTRI_TYPE_REQD');
1919: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','SICKNESS_CONTRIBUTION'));
1920: hr_utility.raise_error;
1921: end if;
1922:

Line 1919: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','SICKNESS_CONTRIBUTION'));

1915: if p_sickness_contribution <> 'N' then
1916: -- Raise an error that Sickness Contribution should be 'No Contribution'
1917: -- when Sickness Contribution End Reason has been specified
1918: hr_utility.set_message(801,'PAY_375846_CONTRI_TYPE_REQD');
1919: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','SICKNESS_CONTRIBUTION'));
1920: hr_utility.raise_error;
1921: end if;
1922:
1923:

Line 1920: hr_utility.raise_error;

1916: -- Raise an error that Sickness Contribution should be 'No Contribution'
1917: -- when Sickness Contribution End Reason has been specified
1918: hr_utility.set_message(801,'PAY_375846_CONTRI_TYPE_REQD');
1919: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','SICKNESS_CONTRIBUTION'));
1920: hr_utility.raise_error;
1921: end if;
1922:
1923:
1924: -- If the value of the SICKNESS_CONTRIBUTION has remained unchanged (and its

Line 1931: hr_utility.set_message(801,'PAY_375847_INCORREC_END_REASON');

1927: -- been changed from NULL to a not NULL value, then an error should be raised
1928:
1929: if p_sickness_contribution = 'N' and
1930: pay_psd_shd.g_old_rec.sickness_contribution = 'N' then
1931: hr_utility.set_message(801,'PAY_375847_INCORREC_END_REASON');
1932: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','SICKNESS_CONTRIBUTION'));
1933: end if;
1934:
1935:

Line 1932: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','SICKNESS_CONTRIBUTION'));

1928:
1929: if p_sickness_contribution = 'N' and
1930: pay_psd_shd.g_old_rec.sickness_contribution = 'N' then
1931: hr_utility.set_message(801,'PAY_375847_INCORREC_END_REASON');
1932: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','SICKNESS_CONTRIBUTION'));
1933: end if;
1934:
1935:
1936: end if;

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

1935:
1936: end if;
1937: end if;
1938: end if;
1939: hr_utility.set_location(' Leaving:'|| l_proc, 20);
1940: exception
1941: when app_exception.application_exception then
1942: if hr_multi_message.exception_add
1943: (p_associated_column1 => 'PAY_PL_SII_DETAILS_F.SICKNESS_CONT_END_REASON'

Line 1945: hr_utility.set_location(' Leaving:'|| l_proc, 30);

1941: when app_exception.application_exception then
1942: if hr_multi_message.exception_add
1943: (p_associated_column1 => 'PAY_PL_SII_DETAILS_F.SICKNESS_CONT_END_REASON'
1944: ) then
1945: hr_utility.set_location(' Leaving:'|| l_proc, 30);
1946: raise;
1947: end if;
1948: hr_utility.set_location(' Leaving:'|| l_proc, 40);
1949:

Line 1948: hr_utility.set_location(' Leaving:'|| l_proc, 40);

1944: ) then
1945: hr_utility.set_location(' Leaving:'|| l_proc, 30);
1946: raise;
1947: end if;
1948: hr_utility.set_location(' Leaving:'|| l_proc, 40);
1949:
1950: End chk_sickness_cont_end_reason;
1951: --
1952: --

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

1997:
1998:
1999:
2000: Begin
2001: hr_utility.set_location('Entering:'|| l_proc, 10);
2002: l_proc := g_package ||'chk_work_injury_cont_end';
2003:
2004: --
2005: -- Check mandatory parameters have been set

Line 2035: hr_utility.set_message(801,'PAY_375844_CONT_END_REQD');

2031:
2032: if p_work_injury_contribution = 'N' and
2033: nvl(pay_psd_shd.g_old_rec.work_injury_contribution,'N') <> 'N' then
2034: if p_work_injury_cont_end_reason is null then
2035: hr_utility.set_message(801,'PAY_375844_CONT_END_REQD');
2036: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','WORK_INJURY_CONTRIBUTION'));
2037: hr_utility.raise_error;
2038: end if;
2039: end if;

Line 2036: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','WORK_INJURY_CONTRIBUTION'));

2032: if p_work_injury_contribution = 'N' and
2033: nvl(pay_psd_shd.g_old_rec.work_injury_contribution,'N') <> 'N' then
2034: if p_work_injury_cont_end_reason is null then
2035: hr_utility.set_message(801,'PAY_375844_CONT_END_REQD');
2036: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','WORK_INJURY_CONTRIBUTION'));
2037: hr_utility.raise_error;
2038: end if;
2039: end if;
2040:

Line 2037: hr_utility.raise_error;

2033: nvl(pay_psd_shd.g_old_rec.work_injury_contribution,'N') <> 'N' then
2034: if p_work_injury_cont_end_reason is null then
2035: hr_utility.set_message(801,'PAY_375844_CONT_END_REQD');
2036: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','WORK_INJURY_CONTRIBUTION'));
2037: hr_utility.raise_error;
2038: end if;
2039: end if;
2040:
2041: if (l_api_updating and nvl(pay_psd_shd.g_old_rec.work_injury_cont_end_reason,

Line 2058: hr_utility.set_message(801,'PAY_375845_INVALID_END_REASON');

2054: ,p_lookup_type => 'PL_CONTRIBUTION_END_REASON'
2055: ,p_lookup_code => p_work_injury_cont_end_reason
2056: ) then
2057: -- Error: Invalid Contract Category
2058: hr_utility.set_message(801,'PAY_375845_INVALID_END_REASON');
2059: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','WORK_INJURY_CONTRIBUTION'));
2060: -- This message will be 'The Work Injury Contribution End Reason type
2061: -- does not exist in the system'
2062: hr_utility.raise_error;

Line 2059: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','WORK_INJURY_CONTRIBUTION'));

2055: ,p_lookup_code => p_work_injury_cont_end_reason
2056: ) then
2057: -- Error: Invalid Contract Category
2058: hr_utility.set_message(801,'PAY_375845_INVALID_END_REASON');
2059: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','WORK_INJURY_CONTRIBUTION'));
2060: -- This message will be 'The Work Injury Contribution End Reason type
2061: -- does not exist in the system'
2062: hr_utility.raise_error;
2063: end if;

Line 2062: hr_utility.raise_error;

2058: hr_utility.set_message(801,'PAY_375845_INVALID_END_REASON');
2059: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','WORK_INJURY_CONTRIBUTION'));
2060: -- This message will be 'The Work Injury Contribution End Reason type
2061: -- does not exist in the system'
2062: hr_utility.raise_error;
2063: end if;
2064:
2065: -- If the Work Injury Contribution End Reason is not null then the value of Work Injury
2066: -- Contribution shud be 'No Contribution'.

Line 2071: hr_utility.set_message(801,'PAY_375846_CONTRI_TYPE_REQD');

2067:
2068: if p_work_injury_contribution <> 'N' then
2069: -- Raise an error that Work Injury Contribution should be 'No Contribution'
2070: -- when Work Injury Contribution End Reason has been specified
2071: hr_utility.set_message(801,'PAY_375846_CONTRI_TYPE_REQD');
2072: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','WORK_INJURY_CONTRIBUTION'));
2073: hr_utility.raise_error;
2074: end if;
2075:

Line 2072: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','WORK_INJURY_CONTRIBUTION'));

2068: if p_work_injury_contribution <> 'N' then
2069: -- Raise an error that Work Injury Contribution should be 'No Contribution'
2070: -- when Work Injury Contribution End Reason has been specified
2071: hr_utility.set_message(801,'PAY_375846_CONTRI_TYPE_REQD');
2072: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','WORK_INJURY_CONTRIBUTION'));
2073: hr_utility.raise_error;
2074: end if;
2075:
2076:

Line 2073: hr_utility.raise_error;

2069: -- Raise an error that Work Injury Contribution should be 'No Contribution'
2070: -- when Work Injury Contribution End Reason has been specified
2071: hr_utility.set_message(801,'PAY_375846_CONTRI_TYPE_REQD');
2072: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','WORK_INJURY_CONTRIBUTION'));
2073: hr_utility.raise_error;
2074: end if;
2075:
2076:
2077: -- If the value of the WORK_INJURY_CONTRIBUTION has remained unchanged (and its

Line 2084: hr_utility.set_message(801,'PAY_375847_INCORREC_END_REASON');

2080: -- been changed from NULL to a not NULL value, then an error should be raised
2081:
2082: if p_work_injury_contribution = 'N' and
2083: pay_psd_shd.g_old_rec.work_injury_contribution = 'N' then
2084: hr_utility.set_message(801,'PAY_375847_INCORREC_END_REASON');
2085: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','WORK_INJURY_CONTRIBUTION'));
2086: end if;
2087:
2088:

Line 2085: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','WORK_INJURY_CONTRIBUTION'));

2081:
2082: if p_work_injury_contribution = 'N' and
2083: pay_psd_shd.g_old_rec.work_injury_contribution = 'N' then
2084: hr_utility.set_message(801,'PAY_375847_INCORREC_END_REASON');
2085: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','WORK_INJURY_CONTRIBUTION'));
2086: end if;
2087:
2088:
2089: end if;

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

2088:
2089: end if;
2090: end if;
2091: end if;
2092: hr_utility.set_location(' Leaving:'|| l_proc, 20);
2093: exception
2094: when app_exception.application_exception then
2095: if hr_multi_message.exception_add
2096: (p_associated_column1 => 'PAY_PL_SII_DETAILS_F.WORK_INJURY_CONT_END_REASON'

Line 2098: hr_utility.set_location(' Leaving:'|| l_proc, 30);

2094: when app_exception.application_exception then
2095: if hr_multi_message.exception_add
2096: (p_associated_column1 => 'PAY_PL_SII_DETAILS_F.WORK_INJURY_CONT_END_REASON'
2097: ) then
2098: hr_utility.set_location(' Leaving:'|| l_proc, 30);
2099: raise;
2100: end if;
2101: hr_utility.set_location(' Leaving:'|| l_proc, 40);
2102:

Line 2101: hr_utility.set_location(' Leaving:'|| l_proc, 40);

2097: ) then
2098: hr_utility.set_location(' Leaving:'|| l_proc, 30);
2099: raise;
2100: end if;
2101: hr_utility.set_location(' Leaving:'|| l_proc, 40);
2102:
2103: End chk_work_injury_cont_end;
2104: --
2105: --

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

2150:
2151:
2152:
2153: Begin
2154: hr_utility.set_location('Entering:'|| l_proc, 10);
2155: l_proc := g_package ||'chk_labor_fund_cont_end_reason';
2156:
2157: --
2158: -- Check mandatory parameters have been set

Line 2188: hr_utility.set_message(801,'PAY_375844_CONT_END_REQD');

2184:
2185: if p_labor_contribution = 'N' and
2186: nvl(pay_psd_shd.g_old_rec.labor_contribution,'N') <> 'N' then
2187: if p_labor_fund_cont_end_reason is null then
2188: hr_utility.set_message(801,'PAY_375844_CONT_END_REQD');
2189: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','LABOR_CONTRIBUTION'));
2190: hr_utility.raise_error;
2191: end if;
2192: end if;

Line 2189: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','LABOR_CONTRIBUTION'));

2185: if p_labor_contribution = 'N' and
2186: nvl(pay_psd_shd.g_old_rec.labor_contribution,'N') <> 'N' then
2187: if p_labor_fund_cont_end_reason is null then
2188: hr_utility.set_message(801,'PAY_375844_CONT_END_REQD');
2189: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','LABOR_CONTRIBUTION'));
2190: hr_utility.raise_error;
2191: end if;
2192: end if;
2193:

Line 2190: hr_utility.raise_error;

2186: nvl(pay_psd_shd.g_old_rec.labor_contribution,'N') <> 'N' then
2187: if p_labor_fund_cont_end_reason is null then
2188: hr_utility.set_message(801,'PAY_375844_CONT_END_REQD');
2189: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','LABOR_CONTRIBUTION'));
2190: hr_utility.raise_error;
2191: end if;
2192: end if;
2193:
2194: if (l_api_updating and nvl(pay_psd_shd.g_old_rec.labor_fund_cont_end_reason,

Line 2211: hr_utility.set_message(801,'PAY_375845_INVALID_END_REASON');

2207: ,p_lookup_type => 'PL_CONTRIBUTION_END_REASON'
2208: ,p_lookup_code => p_labor_fund_cont_end_reason
2209: ) then
2210: -- Error: Invalid Contract Category
2211: hr_utility.set_message(801,'PAY_375845_INVALID_END_REASON');
2212: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','LABOR_CONTRIBUTION'));
2213: -- This message will be 'The Labor fund Contribution End Reason type
2214: -- does not exist in the system'
2215: hr_utility.raise_error;

Line 2212: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','LABOR_CONTRIBUTION'));

2208: ,p_lookup_code => p_labor_fund_cont_end_reason
2209: ) then
2210: -- Error: Invalid Contract Category
2211: hr_utility.set_message(801,'PAY_375845_INVALID_END_REASON');
2212: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','LABOR_CONTRIBUTION'));
2213: -- This message will be 'The Labor fund Contribution End Reason type
2214: -- does not exist in the system'
2215: hr_utility.raise_error;
2216: end if;

Line 2215: hr_utility.raise_error;

2211: hr_utility.set_message(801,'PAY_375845_INVALID_END_REASON');
2212: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','LABOR_CONTRIBUTION'));
2213: -- This message will be 'The Labor fund Contribution End Reason type
2214: -- does not exist in the system'
2215: hr_utility.raise_error;
2216: end if;
2217:
2218: -- If the Labor fund Contribution End Reason is not null then the value of Labor fund
2219: -- Contribution shud be 'No Contribution'.

Line 2224: hr_utility.set_message(801,'PAY_375846_CONTRI_TYPE_REQD');

2220:
2221: if p_labor_contribution <> 'N' then
2222: -- Raise an error that Labor Contribution should be 'No Contribution'
2223: -- when Labor Contribution End Reason has been specified
2224: hr_utility.set_message(801,'PAY_375846_CONTRI_TYPE_REQD');
2225: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','LABOR_CONTRIBUTION'));
2226: hr_utility.raise_error;
2227: end if;
2228:

Line 2225: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','LABOR_CONTRIBUTION'));

2221: if p_labor_contribution <> 'N' then
2222: -- Raise an error that Labor Contribution should be 'No Contribution'
2223: -- when Labor Contribution End Reason has been specified
2224: hr_utility.set_message(801,'PAY_375846_CONTRI_TYPE_REQD');
2225: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','LABOR_CONTRIBUTION'));
2226: hr_utility.raise_error;
2227: end if;
2228:
2229:

Line 2226: hr_utility.raise_error;

2222: -- Raise an error that Labor Contribution should be 'No Contribution'
2223: -- when Labor Contribution End Reason has been specified
2224: hr_utility.set_message(801,'PAY_375846_CONTRI_TYPE_REQD');
2225: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','LABOR_CONTRIBUTION'));
2226: hr_utility.raise_error;
2227: end if;
2228:
2229:
2230: -- If the value of the LABOR_FUND_CONTRIBUTION has remained unchanged (and its

Line 2237: hr_utility.set_message(801,'PAY_375847_INCORREC_END_REASON');

2233: -- been changed from NULL to a not NULL value, then an error should be raised
2234:
2235: if p_labor_contribution = 'N' and
2236: pay_psd_shd.g_old_rec.labor_contribution = 'N' then
2237: hr_utility.set_message(801,'PAY_375847_INCORREC_END_REASON');
2238: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','LABOR_CONTRIBUTION'));
2239: end if;
2240:
2241:

Line 2238: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','LABOR_CONTRIBUTION'));

2234:
2235: if p_labor_contribution = 'N' and
2236: pay_psd_shd.g_old_rec.labor_contribution = 'N' then
2237: hr_utility.set_message(801,'PAY_375847_INCORREC_END_REASON');
2238: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','LABOR_CONTRIBUTION'));
2239: end if;
2240:
2241:
2242: end if;

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

2241:
2242: end if;
2243: end if;
2244: end if;
2245: hr_utility.set_location(' Leaving:'|| l_proc, 20);
2246: exception
2247: when app_exception.application_exception then
2248: if hr_multi_message.exception_add
2249: (p_associated_column1 => 'PAY_PL_SII_DETAILS_F.LABOR_FUND_CONT_END_REASON'

Line 2251: hr_utility.set_location(' Leaving:'|| l_proc, 30);

2247: when app_exception.application_exception then
2248: if hr_multi_message.exception_add
2249: (p_associated_column1 => 'PAY_PL_SII_DETAILS_F.LABOR_FUND_CONT_END_REASON'
2250: ) then
2251: hr_utility.set_location(' Leaving:'|| l_proc, 30);
2252: raise;
2253: end if;
2254: hr_utility.set_location(' Leaving:'|| l_proc, 40);
2255:

Line 2254: hr_utility.set_location(' Leaving:'|| l_proc, 40);

2250: ) then
2251: hr_utility.set_location(' Leaving:'|| l_proc, 30);
2252: raise;
2253: end if;
2254: hr_utility.set_location(' Leaving:'|| l_proc, 40);
2255:
2256: End chk_labor_fund_cont_end_reason;
2257: --
2258: --

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

2303:
2304:
2305:
2306: Begin
2307: hr_utility.set_location('Entering:'|| l_proc, 10);
2308: l_proc := g_package ||'chk_health_cont_end_reason';
2309:
2310: --
2311: -- Check mandatory parameters have been set

Line 2341: hr_utility.set_message(801,'PAY_375844_CONT_END_REQD');

2337:
2338: if p_health_contribution = 'N' and
2339: nvl(pay_psd_shd.g_old_rec.health_contribution,'N') <> 'N' then
2340: if p_health_cont_end_reason is null then
2341: hr_utility.set_message(801,'PAY_375844_CONT_END_REQD');
2342: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','HEALTH_CONTRIBUTION'));
2343: hr_utility.raise_error;
2344: end if;
2345: end if;

Line 2342: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','HEALTH_CONTRIBUTION'));

2338: if p_health_contribution = 'N' and
2339: nvl(pay_psd_shd.g_old_rec.health_contribution,'N') <> 'N' then
2340: if p_health_cont_end_reason is null then
2341: hr_utility.set_message(801,'PAY_375844_CONT_END_REQD');
2342: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','HEALTH_CONTRIBUTION'));
2343: hr_utility.raise_error;
2344: end if;
2345: end if;
2346:

Line 2343: hr_utility.raise_error;

2339: nvl(pay_psd_shd.g_old_rec.health_contribution,'N') <> 'N' then
2340: if p_health_cont_end_reason is null then
2341: hr_utility.set_message(801,'PAY_375844_CONT_END_REQD');
2342: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','HEALTH_CONTRIBUTION'));
2343: hr_utility.raise_error;
2344: end if;
2345: end if;
2346:
2347: if (l_api_updating and nvl(pay_psd_shd.g_old_rec.health_cont_end_reason,

Line 2364: hr_utility.set_message(801,'PAY_375845_INVALID_END_REASON');

2360: ,p_lookup_type => 'PL_CONTRIBUTION_END_REASON'
2361: ,p_lookup_code => p_health_cont_end_reason
2362: ) then
2363: -- Error: Invalid Contract Category
2364: hr_utility.set_message(801,'PAY_375845_INVALID_END_REASON');
2365: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','HEALTH_CONTRIBUTION'));
2366: -- This message will be 'The Health Contribution End Reason type
2367: -- does not exist in the system'
2368: hr_utility.raise_error;

Line 2365: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','HEALTH_CONTRIBUTION'));

2361: ,p_lookup_code => p_health_cont_end_reason
2362: ) then
2363: -- Error: Invalid Contract Category
2364: hr_utility.set_message(801,'PAY_375845_INVALID_END_REASON');
2365: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','HEALTH_CONTRIBUTION'));
2366: -- This message will be 'The Health Contribution End Reason type
2367: -- does not exist in the system'
2368: hr_utility.raise_error;
2369: end if;

Line 2368: hr_utility.raise_error;

2364: hr_utility.set_message(801,'PAY_375845_INVALID_END_REASON');
2365: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','HEALTH_CONTRIBUTION'));
2366: -- This message will be 'The Health Contribution End Reason type
2367: -- does not exist in the system'
2368: hr_utility.raise_error;
2369: end if;
2370:
2371: -- If the Health Contribution End Reason is not null then the value of Health
2372: -- Contribution shud be 'No Contribution'.

Line 2377: hr_utility.set_message(801,'PAY_375846_CONTRI_TYPE_REQD');

2373:
2374: if p_health_contribution <> 'N' then
2375: -- Raise an error that Health Contribution should be 'No Contribution'
2376: -- when Health Contribution End Reason has been specified
2377: hr_utility.set_message(801,'PAY_375846_CONTRI_TYPE_REQD');
2378: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','HEALTH_CONTRIBUTION'));
2379: hr_utility.raise_error;
2380: end if;
2381:

Line 2378: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','HEALTH_CONTRIBUTION'));

2374: if p_health_contribution <> 'N' then
2375: -- Raise an error that Health Contribution should be 'No Contribution'
2376: -- when Health Contribution End Reason has been specified
2377: hr_utility.set_message(801,'PAY_375846_CONTRI_TYPE_REQD');
2378: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','HEALTH_CONTRIBUTION'));
2379: hr_utility.raise_error;
2380: end if;
2381:
2382:

Line 2379: hr_utility.raise_error;

2375: -- Raise an error that Health Contribution should be 'No Contribution'
2376: -- when Health Contribution End Reason has been specified
2377: hr_utility.set_message(801,'PAY_375846_CONTRI_TYPE_REQD');
2378: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','HEALTH_CONTRIBUTION'));
2379: hr_utility.raise_error;
2380: end if;
2381:
2382:
2383: -- If the value of the HEALTH_CONTRIBUTION has remained unchanged (and its

Line 2390: hr_utility.set_message(801,'PAY_375847_INCORREC_END_REASON');

2386: -- been changed from NULL to a not NULL value, then an error should be raised
2387:
2388: if p_health_contribution = 'N' and
2389: pay_psd_shd.g_old_rec.health_contribution = 'N' then
2390: hr_utility.set_message(801,'PAY_375847_INCORREC_END_REASON');
2391: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','HEALTH_CONTRIBUTION'));
2392: end if;
2393:
2394:

Line 2391: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','HEALTH_CONTRIBUTION'));

2387:
2388: if p_health_contribution = 'N' and
2389: pay_psd_shd.g_old_rec.health_contribution = 'N' then
2390: hr_utility.set_message(801,'PAY_375847_INCORREC_END_REASON');
2391: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','HEALTH_CONTRIBUTION'));
2392: end if;
2393:
2394:
2395: end if;

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

2394:
2395: end if;
2396: end if;
2397: end if;
2398: hr_utility.set_location(' Leaving:'|| l_proc, 20);
2399: exception
2400: when app_exception.application_exception then
2401: if hr_multi_message.exception_add
2402: (p_associated_column1 => 'PAY_PL_SII_DETAILS_F.HEALTH_CONT_END_REASON'

Line 2404: hr_utility.set_location(' Leaving:'|| l_proc, 30);

2400: when app_exception.application_exception then
2401: if hr_multi_message.exception_add
2402: (p_associated_column1 => 'PAY_PL_SII_DETAILS_F.HEALTH_CONT_END_REASON'
2403: ) then
2404: hr_utility.set_location(' Leaving:'|| l_proc, 30);
2405: raise;
2406: end if;
2407: hr_utility.set_location(' Leaving:'|| l_proc, 40);
2408:

Line 2407: hr_utility.set_location(' Leaving:'|| l_proc, 40);

2403: ) then
2404: hr_utility.set_location(' Leaving:'|| l_proc, 30);
2405: raise;
2406: end if;
2407: hr_utility.set_location(' Leaving:'|| l_proc, 40);
2408:
2409: End chk_health_cont_end_reason;
2410: --
2411: --

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

2456:
2457:
2458:
2459: Begin
2460: hr_utility.set_location('Entering:'|| l_proc, 10);
2461: l_proc := g_package ||'chk_unemployment_cont_end';
2462:
2463: --
2464: -- Check mandatory parameters have been set

Line 2494: hr_utility.set_message(801,'PAY_375844_CONT_END_REQD');

2490:
2491: if p_unemployment_contribution = 'N' and
2492: nvl(pay_psd_shd.g_old_rec.unemployment_contribution,'N') <> 'N' then
2493: if p_unemployment_cont_end_reason is null then
2494: hr_utility.set_message(801,'PAY_375844_CONT_END_REQD');
2495: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','UNEMPLOYMENT_CONTRIBUTION'));
2496: hr_utility.raise_error;
2497: end if;
2498: end if;

Line 2495: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','UNEMPLOYMENT_CONTRIBUTION'));

2491: if p_unemployment_contribution = 'N' and
2492: nvl(pay_psd_shd.g_old_rec.unemployment_contribution,'N') <> 'N' then
2493: if p_unemployment_cont_end_reason is null then
2494: hr_utility.set_message(801,'PAY_375844_CONT_END_REQD');
2495: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','UNEMPLOYMENT_CONTRIBUTION'));
2496: hr_utility.raise_error;
2497: end if;
2498: end if;
2499:

Line 2496: hr_utility.raise_error;

2492: nvl(pay_psd_shd.g_old_rec.unemployment_contribution,'N') <> 'N' then
2493: if p_unemployment_cont_end_reason is null then
2494: hr_utility.set_message(801,'PAY_375844_CONT_END_REQD');
2495: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','UNEMPLOYMENT_CONTRIBUTION'));
2496: hr_utility.raise_error;
2497: end if;
2498: end if;
2499:
2500: if (l_api_updating and nvl(pay_psd_shd.g_old_rec.unemployment_cont_end_reason,

Line 2517: hr_utility.set_message(801,'PAY_375845_INVALID_END_REASON');

2513: ,p_lookup_type => 'PL_CONTRIBUTION_END_REASON'
2514: ,p_lookup_code => p_unemployment_cont_end_reason
2515: ) then
2516: -- Error: Invalid Contract Category
2517: hr_utility.set_message(801,'PAY_375845_INVALID_END_REASON');
2518: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','UNEMPLOYMENT_CONTRIBUTION'));
2519: -- This message will be 'The Unemployment Contribution End Reason type
2520: -- does not exist in the system'
2521: hr_utility.raise_error;

Line 2518: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','UNEMPLOYMENT_CONTRIBUTION'));

2514: ,p_lookup_code => p_unemployment_cont_end_reason
2515: ) then
2516: -- Error: Invalid Contract Category
2517: hr_utility.set_message(801,'PAY_375845_INVALID_END_REASON');
2518: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','UNEMPLOYMENT_CONTRIBUTION'));
2519: -- This message will be 'The Unemployment Contribution End Reason type
2520: -- does not exist in the system'
2521: hr_utility.raise_error;
2522: end if;

Line 2521: hr_utility.raise_error;

2517: hr_utility.set_message(801,'PAY_375845_INVALID_END_REASON');
2518: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','UNEMPLOYMENT_CONTRIBUTION'));
2519: -- This message will be 'The Unemployment Contribution End Reason type
2520: -- does not exist in the system'
2521: hr_utility.raise_error;
2522: end if;
2523:
2524: -- If the Unemployment Contribution End Reason is not null then the value of Unemployment
2525: -- Contribution shud be 'No Contribution'.

Line 2530: hr_utility.set_message(801,'PAY_375846_CONTRI_TYPE_REQD');

2526:
2527: if p_unemployment_contribution <> 'N' then
2528: -- Raise an error that Unemployment Contribution should be 'No Contribution'
2529: -- when Unemployment Contribution End Reason has been specified
2530: hr_utility.set_message(801,'PAY_375846_CONTRI_TYPE_REQD');
2531: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','UNEMPLOYMENT_CONTRIBUTION'));
2532: hr_utility.raise_error;
2533: end if;
2534:

Line 2531: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','UNEMPLOYMENT_CONTRIBUTION'));

2527: if p_unemployment_contribution <> 'N' then
2528: -- Raise an error that Unemployment Contribution should be 'No Contribution'
2529: -- when Unemployment Contribution End Reason has been specified
2530: hr_utility.set_message(801,'PAY_375846_CONTRI_TYPE_REQD');
2531: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','UNEMPLOYMENT_CONTRIBUTION'));
2532: hr_utility.raise_error;
2533: end if;
2534:
2535:

Line 2532: hr_utility.raise_error;

2528: -- Raise an error that Unemployment Contribution should be 'No Contribution'
2529: -- when Unemployment Contribution End Reason has been specified
2530: hr_utility.set_message(801,'PAY_375846_CONTRI_TYPE_REQD');
2531: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','UNEMPLOYMENT_CONTRIBUTION'));
2532: hr_utility.raise_error;
2533: end if;
2534:
2535:
2536: -- If the value of the UNEMPLOYMENT_CONTRIBUTION has remained unchanged (and its

Line 2543: hr_utility.set_message(801,'PAY_375847_INCORREC_END_REASON');

2539: -- been changed from NULL to a not NULL value, then an error should be raised
2540:
2541: if p_unemployment_contribution = 'N' and
2542: pay_psd_shd.g_old_rec.unemployment_contribution = 'N' then
2543: hr_utility.set_message(801,'PAY_375847_INCORREC_END_REASON');
2544: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','UNEMPLOYMENT_CONTRIBUTION'));
2545: end if;
2546:
2547:

Line 2544: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','UNEMPLOYMENT_CONTRIBUTION'));

2540:
2541: if p_unemployment_contribution = 'N' and
2542: pay_psd_shd.g_old_rec.unemployment_contribution = 'N' then
2543: hr_utility.set_message(801,'PAY_375847_INCORREC_END_REASON');
2544: hr_utility.set_message_token('TYPE',hr_general.decode_lookup('PL_FORM_LABELS','UNEMPLOYMENT_CONTRIBUTION'));
2545: end if;
2546:
2547:
2548: end if;

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

2547:
2548: end if;
2549: end if;
2550: end if;
2551: hr_utility.set_location(' Leaving:'|| l_proc, 20);
2552: exception
2553: when app_exception.application_exception then
2554: if hr_multi_message.exception_add
2555: (p_associated_column1 => 'PAY_PL_SII_DETAILS_F.UNEMPLOYMENT_CONT_END_REASON'

Line 2557: hr_utility.set_location(' Leaving:'|| l_proc, 30);

2553: when app_exception.application_exception then
2554: if hr_multi_message.exception_add
2555: (p_associated_column1 => 'PAY_PL_SII_DETAILS_F.UNEMPLOYMENT_CONT_END_REASON'
2556: ) then
2557: hr_utility.set_location(' Leaving:'|| l_proc, 30);
2558: raise;
2559: end if;
2560: hr_utility.set_location(' Leaving:'|| l_proc, 40);
2561:

Line 2560: hr_utility.set_location(' Leaving:'|| l_proc, 40);

2556: ) then
2557: hr_utility.set_location(' Leaving:'|| l_proc, 30);
2558: raise;
2559: end if;
2560: hr_utility.set_location(' Leaving:'|| l_proc, 40);
2561:
2562: End chk_unemployment_cont_end;
2563: --
2564: --

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

2837: --
2838: l_proc varchar2(72) := g_package||'insert_validate';
2839: --
2840: Begin
2841: hr_utility.set_location('Entering:'||l_proc, 5);
2842: --
2843: -- Call all supporting business operations
2844: --
2845: hr_api.validate_bus_grp_id

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

3035:
3036:
3037:
3038: --
3039: hr_utility.set_location(' Leaving:'||l_proc, 10);
3040: End insert_validate;
3041: --
3042: -- ----------------------------------------------------------------------------
3043: -- |---------------------------< update_validate >----------------------------|

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

3052: --
3053: l_proc varchar2(72) := g_package||'update_validate';
3054: --
3055: Begin
3056: hr_utility.set_location('Entering:'||l_proc, 5);
3057: --
3058: -- Call all supporting business operations
3059: --
3060: hr_api.validate_bus_grp_id

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

3240: p_object_version_number=> p_rec.object_version_number);
3241:
3242:
3243: --
3244: hr_utility.set_location(' Leaving:'||l_proc, 10);
3245: End update_validate;
3246: --
3247: -- ----------------------------------------------------------------------------
3248: -- |---------------------------< delete_validate >----------------------------|

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

3257: --
3258: l_proc varchar2(72) := g_package||'delete_validate';
3259: --
3260: Begin
3261: hr_utility.set_location('Entering:'||l_proc, 5);
3262: --
3263: -- Call all supporting business operations
3264: --
3265: dt_delete_validate

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

3268: ,p_validation_end_date => p_validation_end_date
3269: ,p_sii_details_id => p_rec.sii_details_id
3270: );
3271: --
3272: hr_utility.set_location(' Leaving:'||l_proc, 10);
3273: End delete_validate;
3274: --
3275: -- ----------------------------------------------------------------------------
3276: --|-----------------------< get_contribution_values >--------------------------|

Line 3484: hr_utility.set_message(801,'PAY_375858_NO_EMP_SOCIAL_INFO');

3480: end if;
3481:
3482: exception
3483: when no_data_found then
3484: hr_utility.set_message(801,'PAY_375858_NO_EMP_SOCIAL_INFO');
3485: hr_utility.raise_error;
3486:
3487:
3488: end get_contribution_values;

Line 3485: hr_utility.raise_error;

3481:
3482: exception
3483: when no_data_found then
3484: hr_utility.set_message(801,'PAY_375858_NO_EMP_SOCIAL_INFO');
3485: hr_utility.raise_error;
3486:
3487:
3488: end get_contribution_values;
3489: