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_PPD_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_ppd_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_ppd_bus.g_paye_details_id := p_paye_details_id;
154: pay_ppd_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 481: hr_utility.set_location('Entering:'||l_proc, 5);

477: --
478: l_proc varchar2(72) := g_package||'insert_validate';
479: --
480: Begin
481: hr_utility.set_location('Entering:'||l_proc, 5);
482: --
483: -- Call all supporting business operations
484: --
485: hr_api.validate_bus_grp_id

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

556: ,p_validation_end_date => p_validation_end_date
557: ,p_object_version_number => p_rec.object_version_number);
558: --
559: End if;
560: hr_utility.set_location(' Leaving:'||l_proc, 10);
561: End insert_validate;
562: --
563: -- ----------------------------------------------------------------------------
564: -- |---------------------------< update_validate >----------------------------|

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

573: --
574: l_proc varchar2(72) := g_package||'update_validate';
575: --
576: Begin
577: hr_utility.set_location('Entering:'||l_proc, 5);
578: --
579: -- Call all supporting business operations
580: --
581: hr_api.validate_bus_grp_id

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

641: ,p_object_version_number => p_rec.object_version_number);
642: --
643: End if;
644: --
645: hr_utility.set_location(' Leaving:'||l_proc, 10);
646: End update_validate;
647: --
648: -- ----------------------------------------------------------------------------
649: -- |---------------------------< delete_validate >----------------------------|

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

658: --
659: l_proc varchar2(72) := g_package||'delete_validate';
660: --
661: Begin
662: hr_utility.set_location('Entering:'||l_proc, 5);
663: --
664: -- Call all supporting business operations
665: --
666: dt_delete_validate

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

669: ,p_validation_end_date => p_validation_end_date
670: ,p_paye_details_id => p_rec.paye_details_id
671: );
672: --
673: hr_utility.set_location(' Leaving:'||l_proc, 10);
674: End delete_validate;
675: --
676: -- ----------------------------------------------------------------------------
677: --|-------------------------< chk_contract_category >--------------------------|

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

687:
688: l_proc varchar2(72);
689:
690: Begin
691: hr_utility.set_location('Entering:'|| l_proc, 10);
692: l_proc := g_package ||'chk_contract_category';
693:
694: --
695: -- Check mandatory parameters have been set

Line 722: hr_utility.set_message(801,'PAY_375843_CONTRACT_PL_LOOKUP');

718: ,p_lookup_type => 'PL_CONTRACT_CATEGORY'
719: ,p_lookup_code => p_contract_category
720: ) then
721: -- Error: Invalid Contract Category
722: hr_utility.set_message(801,'PAY_375843_CONTRACT_PL_LOOKUP');
723: -- This message will be 'The Contract Category does not exist in the system'
724: hr_utility.raise_error;
725: end if;
726: end if;

Line 724: hr_utility.raise_error;

720: ) then
721: -- Error: Invalid Contract Category
722: hr_utility.set_message(801,'PAY_375843_CONTRACT_PL_LOOKUP');
723: -- This message will be 'The Contract Category does not exist in the system'
724: hr_utility.raise_error;
725: end if;
726: end if;
727: hr_utility.set_location(' Leaving:'|| l_proc, 20);
728: exception

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

723: -- This message will be 'The Contract Category does not exist in the system'
724: hr_utility.raise_error;
725: end if;
726: end if;
727: hr_utility.set_location(' Leaving:'|| l_proc, 20);
728: exception
729: when app_exception.application_exception then
730: if hr_multi_message.exception_add
731: (p_associated_column1 => 'PAY_PL_PAYE_DETAILS_F.CONTRACT_CATEGORY'

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

729: when app_exception.application_exception then
730: if hr_multi_message.exception_add
731: (p_associated_column1 => 'PAY_PL_PAYE_DETAILS_F.CONTRACT_CATEGORY'
732: ) then
733: hr_utility.set_location(' Leaving:'|| l_proc, 30);
734: raise;
735: end if;
736: hr_utility.set_location(' Leaving:'|| l_proc, 40);
737:

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

732: ) then
733: hr_utility.set_location(' Leaving:'|| l_proc, 30);
734: raise;
735: end if;
736: hr_utility.set_location(' Leaving:'|| l_proc, 40);
737:
738: End chk_contract_category;
739: --
740: -- ----------------------------------------------------------------------------

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

794: and paaf.soft_coding_keyflex_id = hrsoft.soft_coding_keyflex_id;
795: -- and hrsoft.segment3 = l_term_catg;
796:
797: Begin
798: hr_utility.set_location('Entering:'|| l_proc, 10);
799: l_proc := g_package ||'chk_per_asg_id';
800: l_exists := NULL;
801:
802: l_civil_catg := 'CIVIL';

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

835: open csr_asg_id;
836: fetch csr_asg_id into l_exists;
837: if csr_asg_id%NOTFOUND then
838: -- Raise an error message that the record is not in the business group for the date range specified.
839: hr_utility.set_message(801,'PAY_375840_INVALID_PL_ASG_ID');
840: hr_utility.raise_error;
841: end if;
842: close csr_asg_id;
843:

Line 840: hr_utility.raise_error;

836: fetch csr_asg_id into l_exists;
837: if csr_asg_id%NOTFOUND then
838: -- Raise an error message that the record is not in the business group for the date range specified.
839: hr_utility.set_message(801,'PAY_375840_INVALID_PL_ASG_ID');
840: hr_utility.raise_error;
841: end if;
842: close csr_asg_id;
843:
844: elsif p_contract_category = 'NORMAL' then

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

846: open csr_per_id;
847: fetch csr_per_id into l_exists;
848: if csr_per_id%NOTFOUND then
849: -- Raise an error message that the records isnot in the business group for the date range specified
850: hr_utility.set_message(801,'PAY_375839_INVALID_PL_PER_ID');
851: hr_utility.raise_error;
852: end if;
853: close csr_per_id;
854:

Line 851: hr_utility.raise_error;

847: fetch csr_per_id into l_exists;
848: if csr_per_id%NOTFOUND then
849: -- Raise an error message that the records isnot in the business group for the date range specified
850: hr_utility.set_message(801,'PAY_375839_INVALID_PL_PER_ID');
851: hr_utility.raise_error;
852: end if;
853: close csr_per_id;
854:
855: elsif p_contract_category = 'TERM_NORMAL' then

Line 861: hr_utility.set_message(801,'PAY_375857_INVALID_TERM_ID');

857: open csr_normal_term_id;
858: fetch csr_normal_term_id into l_exists;
859: if csr_normal_term_id%NOTFOUND then
860: -- Raise an error message that the record is not in the business group for the date range
861: hr_utility.set_message(801,'PAY_375857_INVALID_TERM_ID');
862: hr_utility.raise_error;
863: end if;
864: close csr_normal_term_id;
865:

Line 862: hr_utility.raise_error;

858: fetch csr_normal_term_id into l_exists;
859: if csr_normal_term_id%NOTFOUND then
860: -- Raise an error message that the record is not in the business group for the date range
861: hr_utility.set_message(801,'PAY_375857_INVALID_TERM_ID');
862: hr_utility.raise_error;
863: end if;
864: close csr_normal_term_id;
865:
866: end if;

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

865:
866: end if;
867: end if;
868:
869: hr_utility.set_location(' Leaving:'|| l_proc, 20);
870: exception
871: when app_exception.application_exception then
872: if hr_multi_message.exception_add
873: (p_associated_column1 => 'PAY_PL_PAYE_DETAILS_F.PER_OR_ASG_ID'

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

871: when app_exception.application_exception then
872: if hr_multi_message.exception_add
873: (p_associated_column1 => 'PAY_PL_PAYE_DETAILS_F.PER_OR_ASG_ID'
874: ) then
875: hr_utility.set_location(' Leaving:'|| l_proc, 30);
876: raise;
877: end if;
878: hr_utility.set_location(' Leaving:'|| l_proc, 40);
879:

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

874: ) then
875: hr_utility.set_location(' Leaving:'|| l_proc, 30);
876: raise;
877: end if;
878: hr_utility.set_location(' Leaving:'|| l_proc, 40);
879:
880: End chk_per_asg_id;
881:
882: --

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

894:
895: l_proc varchar2(72);
896:
897: Begin
898: hr_utility.set_location('Entering:'|| l_proc, 10);
899: l_proc := g_package ||'chk_contract_category';
900:
901: --
902: -- Check mandatory parameters have been set

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

918: ,p_associated_column1 => pay_ppd_shd.g_tab_nam||'.BUSINESS_GROUP_ID');
919:
920: hr_multi_message.end_validation_set;
921:
922: hr_utility.set_location(' Leaving:'|| l_proc, 20);
923: exception
924: when app_exception.application_exception then
925: if hr_multi_message.exception_add
926: (p_associated_column1 => 'PAY_PL_PAYE_DETAILS_F.BUSINESS_GROUP_ID'

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

924: when app_exception.application_exception then
925: if hr_multi_message.exception_add
926: (p_associated_column1 => 'PAY_PL_PAYE_DETAILS_F.BUSINESS_GROUP_ID'
927: ) then
928: hr_utility.set_location(' Leaving:'|| l_proc, 30);
929: raise;
930: end if;
931: hr_utility.set_location(' Leaving:'|| l_proc, 40);
932:

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

927: ) then
928: hr_utility.set_location(' Leaving:'|| l_proc, 30);
929: raise;
930: end if;
931: hr_utility.set_location(' Leaving:'|| l_proc, 40);
932:
933: End chk_business_group_id;
934: --
935: -- ----------------------------------------------------------------------------

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

960: and p_effective_date between paaf.effective_start_date and paaf.effective_end_date;
961:
962:
963: Begin
964: hr_utility.set_location('Entering:'|| l_proc, 10);
965: l_proc := g_package ||'chk_rate_of_tax';
966:
967: if p_contract_category = 'LUMP' then
968: open csr_contract_type(p_per_or_asg_id,p_effective_date);

Line 1030: hr_utility.set_message(801,'PAY_375848_RATE_OF_TAX');

1026: ,p_lookup_type => 'PL_NORMAL_RATE_OF_TAX'
1027: ,p_lookup_code => p_rate_of_tax
1028: ) then
1029: -- Error: Invalid Value for Rate of Tax
1030: hr_utility.set_message(801,'PAY_375848_RATE_OF_TAX');
1031: -- This message will be 'Ensure that you enter a valid tax rate for this employee.'
1032: hr_utility.raise_error;
1033: end if;
1034: elsif p_contract_category = 'CIVIL' then

Line 1032: hr_utility.raise_error;

1028: ) then
1029: -- Error: Invalid Value for Rate of Tax
1030: hr_utility.set_message(801,'PAY_375848_RATE_OF_TAX');
1031: -- This message will be 'Ensure that you enter a valid tax rate for this employee.'
1032: hr_utility.raise_error;
1033: end if;
1034: elsif p_contract_category = 'CIVIL' then
1035: if hr_api.not_exists_in_dt_hr_lookups
1036: (p_effective_date => p_effective_date

Line 1043: hr_utility.set_message(801,'PAY_375848_RATE_OF_TAX');

1039: ,p_lookup_type => 'PL_CIVIL_RATE_OF_TAX'
1040: ,p_lookup_code => p_rate_of_tax
1041: ) then
1042: -- Error: Invalid Value for Rate of Tax
1043: hr_utility.set_message(801,'PAY_375848_RATE_OF_TAX');
1044: -- This message will be 'Ensure that you enter a valid tax rate for this employee.'
1045: hr_utility.raise_error;
1046: end if;
1047: elsif p_contract_category = 'F_LUMP' then

Line 1045: hr_utility.raise_error;

1041: ) then
1042: -- Error: Invalid Value for Rate of Tax
1043: hr_utility.set_message(801,'PAY_375848_RATE_OF_TAX');
1044: -- This message will be 'Ensure that you enter a valid tax rate for this employee.'
1045: hr_utility.raise_error;
1046: end if;
1047: elsif p_contract_category = 'F_LUMP' then
1048: if p_rate_of_tax > 100 or p_rate_of_tax < 0 then
1049: hr_utility.set_message(801,'PAY_375891_F_LUMP_RATE_OF_TAX');

Line 1049: hr_utility.set_message(801,'PAY_375891_F_LUMP_RATE_OF_TAX');

1045: hr_utility.raise_error;
1046: end if;
1047: elsif p_contract_category = 'F_LUMP' then
1048: if p_rate_of_tax > 100 or p_rate_of_tax < 0 then
1049: hr_utility.set_message(801,'PAY_375891_F_LUMP_RATE_OF_TAX');
1050: -- This message will be 'Ensure that you enter a valid tax rate for this employee.'
1051: hr_utility.raise_error;
1052: end if;
1053: elsif p_contract_category = 'LUMP' then

Line 1051: hr_utility.raise_error;

1047: elsif p_contract_category = 'F_LUMP' then
1048: if p_rate_of_tax > 100 or p_rate_of_tax < 0 then
1049: hr_utility.set_message(801,'PAY_375891_F_LUMP_RATE_OF_TAX');
1050: -- This message will be 'Ensure that you enter a valid tax rate for this employee.'
1051: hr_utility.raise_error;
1052: end if;
1053: elsif p_contract_category = 'LUMP' then
1054:
1055: -- For Contract types L01, L02, L03, L04, L09, L10, L11 we will not store the Rate of Tax

Line 1059: hr_utility.set_message(801,'PAY_375891_F_LUMP_RATE_OF_TAX');

1055: -- For Contract types L01, L02, L03, L04, L09, L10, L11 we will not store the Rate of Tax
1056: -- in the table pay_pl_paye_details_f
1057: if l_contract_type not in ('L01','L02','L03','L04','L09','L10','L11') then
1058: if p_rate_of_tax > 100 or p_rate_of_tax < 0 then
1059: hr_utility.set_message(801,'PAY_375891_F_LUMP_RATE_OF_TAX');
1060: -- This message will be 'Ensure that you enter a valid tax rate for this employee.'
1061: hr_utility.raise_error;
1062: end if;
1063: end if;

Line 1061: hr_utility.raise_error;

1057: if l_contract_type not in ('L01','L02','L03','L04','L09','L10','L11') then
1058: if p_rate_of_tax > 100 or p_rate_of_tax < 0 then
1059: hr_utility.set_message(801,'PAY_375891_F_LUMP_RATE_OF_TAX');
1060: -- This message will be 'Ensure that you enter a valid tax rate for this employee.'
1061: hr_utility.raise_error;
1062: end if;
1063: end if;
1064: End if;
1065: end if;

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

1064: End if;
1065: end if;
1066: end if;
1067: End if;
1068: hr_utility.set_location(' Leaving:'|| l_proc, 20);
1069: exception
1070: when app_exception.application_exception then
1071: if hr_multi_message.exception_add
1072: (p_associated_column1 => 'PAY_PL_PAYE_DETAILS_F.RATE_OF_TAX'

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

1070: when app_exception.application_exception then
1071: if hr_multi_message.exception_add
1072: (p_associated_column1 => 'PAY_PL_PAYE_DETAILS_F.RATE_OF_TAX'
1073: ) then
1074: hr_utility.set_location(' Leaving:'|| l_proc, 30);
1075: raise;
1076: end if;
1077: hr_utility.set_location(' Leaving:'|| l_proc, 40);
1078:

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

1073: ) then
1074: hr_utility.set_location(' Leaving:'|| l_proc, 30);
1075: raise;
1076: end if;
1077: hr_utility.set_location(' Leaving:'|| l_proc, 40);
1078:
1079: End chk_rate_of_tax;
1080: --
1081: -- ----------------------------------------------------------------------------

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

1095:
1096: Begin
1097:
1098:
1099: hr_utility.set_location('Entering:'|| l_proc, 10);
1100: l_proc := g_package ||'chk_tax_reduction';
1101:
1102:
1103: --

Line 1148: hr_utility.set_message(801,'PAY_375849_TAX_REDUCTION');

1144: ,p_lookup_type => 'PL_TAX_REDUCTION'
1145: ,p_lookup_code => p_tax_reduction
1146: ) then
1147: -- Error: Invalid value for Tax Reduction
1148: hr_utility.set_message(801,'PAY_375849_TAX_REDUCTION');
1149: -- This message will be 'Ensure that you enter a valid tax reduction percentage for this employee.'
1150: hr_utility.raise_error;
1151: end if;
1152: end if;

Line 1150: hr_utility.raise_error;

1146: ) then
1147: -- Error: Invalid value for Tax Reduction
1148: hr_utility.set_message(801,'PAY_375849_TAX_REDUCTION');
1149: -- This message will be 'Ensure that you enter a valid tax reduction percentage for this employee.'
1150: hr_utility.raise_error;
1151: end if;
1152: end if;
1153: end if;
1154:

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

1151: end if;
1152: end if;
1153: end if;
1154:
1155: hr_utility.set_location(' Leaving:'|| l_proc, 20);
1156:
1157: exception
1158: when app_exception.application_exception then
1159: if hr_multi_message.exception_add

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

1158: when app_exception.application_exception then
1159: if hr_multi_message.exception_add
1160: (p_associated_column1 => 'PAY_PL_PAYE_DETAILS_F.TAX_REDUCTION'
1161: ) then
1162: hr_utility.set_location(' Leaving:'|| l_proc, 30);
1163: raise;
1164: end if;
1165: hr_utility.set_location(' Leaving:'|| l_proc, 40);
1166:

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

1161: ) then
1162: hr_utility.set_location(' Leaving:'|| l_proc, 30);
1163: raise;
1164: end if;
1165: hr_utility.set_location(' Leaving:'|| l_proc, 40);
1166:
1167: End chk_tax_reduction;
1168: --
1169: -- ----------------------------------------------------------------------------

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

1181: l_proc varchar2(72);
1182: l_api_updating boolean;
1183:
1184: Begin
1185: hr_utility.set_location('Entering:'|| l_proc, 10);
1186: l_proc := g_package ||'chk_tax_calc_with_spouse_child';
1187:
1188: --
1189: -- Check mandatory parameters have been set

Line 1233: hr_utility.set_message(801,'PAY_375850_TAX_SPOUSE_CHILD');

1229: ,p_lookup_type => 'YES_NO'
1230: ,p_lookup_code => p_tax_calc_with_spouse_child
1231: ) then
1232: -- Error: Invalid value for Tax calculation with spouse or child
1233: hr_utility.set_message(801,'PAY_375850_TAX_SPOUSE_CHILD');
1234: -- Error Message is as follows
1235: -- 'Ensure that you specify Y or N to indicate whether or not the application should consider tax calculation with spouse or child.'
1236: hr_utility.raise_error;
1237: end if;

Line 1236: hr_utility.raise_error;

1232: -- Error: Invalid value for Tax calculation with spouse or child
1233: hr_utility.set_message(801,'PAY_375850_TAX_SPOUSE_CHILD');
1234: -- Error Message is as follows
1235: -- 'Ensure that you specify Y or N to indicate whether or not the application should consider tax calculation with spouse or child.'
1236: hr_utility.raise_error;
1237: end if;
1238: end if;
1239: end if;
1240:

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

1237: end if;
1238: end if;
1239: end if;
1240:
1241: hr_utility.set_location(' Leaving:'|| l_proc, 20);
1242: exception
1243: when app_exception.application_exception then
1244: if hr_multi_message.exception_add
1245: (p_associated_column1 => 'PAY_PL_PAYE_DETAILS_F.TAX_CALC_WITH_SPOUSE_CHILD'

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

1243: when app_exception.application_exception then
1244: if hr_multi_message.exception_add
1245: (p_associated_column1 => 'PAY_PL_PAYE_DETAILS_F.TAX_CALC_WITH_SPOUSE_CHILD'
1246: ) then
1247: hr_utility.set_location(' Leaving:'|| l_proc, 30);
1248: raise;
1249: end if;
1250: hr_utility.set_location(' Leaving:'|| l_proc, 40);
1251:

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

1246: ) then
1247: hr_utility.set_location(' Leaving:'|| l_proc, 30);
1248: raise;
1249: end if;
1250: hr_utility.set_location(' Leaving:'|| l_proc, 40);
1251:
1252: End chk_tax_calc_with_spouse_child;
1253: --
1254: -- ----------------------------------------------------------------------------

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

1266: l_proc varchar2(72);
1267: l_api_updating boolean;
1268:
1269: Begin
1270: hr_utility.set_location('Entering:'|| l_proc, 10);
1271: l_proc := g_package ||'chk_income_reduction';
1272:
1273: --
1274: -- Check mandatory parameters have been set

Line 1318: hr_utility.set_message(801,'PAY_375851_INCOME_REDUCTION');

1314: ,p_lookup_type => 'PL_INCOME_REDUCTION'
1315: ,p_lookup_code => p_income_reduction
1316: ) then
1317: -- Error: Invalid Income Reduction
1318: hr_utility.set_message(801,'PAY_375851_INCOME_REDUCTION');
1319: -- This message will be 'Ensure that you enter a valid income reduction percentage for this employee.'
1320: hr_utility.raise_error;
1321: end if;
1322: end if;

Line 1320: hr_utility.raise_error;

1316: ) then
1317: -- Error: Invalid Income Reduction
1318: hr_utility.set_message(801,'PAY_375851_INCOME_REDUCTION');
1319: -- This message will be 'Ensure that you enter a valid income reduction percentage for this employee.'
1320: hr_utility.raise_error;
1321: end if;
1322: end if;
1323: end if;
1324: hr_utility.set_location(' Leaving:'|| l_proc, 20);

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

1320: hr_utility.raise_error;
1321: end if;
1322: end if;
1323: end if;
1324: hr_utility.set_location(' Leaving:'|| l_proc, 20);
1325: exception
1326: when app_exception.application_exception then
1327: if hr_multi_message.exception_add
1328: (p_associated_column1 => 'PAY_PL_PAYE_DETAILS_F.INCOME_REDUCTION'

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

1326: when app_exception.application_exception then
1327: if hr_multi_message.exception_add
1328: (p_associated_column1 => 'PAY_PL_PAYE_DETAILS_F.INCOME_REDUCTION'
1329: ) then
1330: hr_utility.set_location(' Leaving:'|| l_proc, 30);
1331: raise;
1332: end if;
1333: hr_utility.set_location(' Leaving:'|| l_proc, 40);
1334:

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

1329: ) then
1330: hr_utility.set_location(' Leaving:'|| l_proc, 30);
1331: raise;
1332: end if;
1333: hr_utility.set_location(' Leaving:'|| l_proc, 40);
1334:
1335: End chk_income_reduction;
1336: --
1337: end pay_ppd_bus;