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

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

91: l_fed_lsf_amount number := 0;
92: --
93: begin
94: --
95: hr_utility.set_location('Entering:'|| l_proc, 10);
96: --
97: -- Issue a savepoint if operating in validation only mode
98: --
99: savepoint create_ca_emp_fedtax_inf;

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

97: -- Issue a savepoint if operating in validation only mode
98: --
99: savepoint create_ca_emp_fedtax_inf;
100: --
101: hr_utility.set_location(l_proc, 20);
102: --
103: -- Process Logic
104: --
105:

Line 116: hr_utility.trace('call rowhandler');

112: p_rec_present => l_rec_present); /* added*/
113:
114: if l_rec_present <> 'Y' then
115: /* Defaulting all the number fields which are null */
116: hr_utility.trace('call rowhandler');
117: l_tax_credit_amount := convert_null_to_zero(p_tax_credit_amount);
118: l_additional_tax := convert_null_to_zero(p_additional_tax);
119: l_annual_dedn := convert_null_to_zero(p_annual_dedn);
120: l_total_expense_by_commission := convert_null_to_zero(p_total_expense_by_commission);

Line 127: hr_utility.trace('call rowhandler');

123: l_other_fedtax_credits := convert_null_to_zero(p_other_fedtax_credits);
124: l_fed_override_amount := convert_null_to_zero(p_fed_override_amount);
125: l_fed_override_rate := convert_null_to_zero(p_fed_override_rate);
126: l_fed_lsf_amount := convert_null_to_zero(p_fed_lsf_amount);
127: hr_utility.trace('call rowhandler');
128: /*
129: begin
130: --
131: -- Start of API User Hook for the before hook of create_ca_emp_fedtax_inf

Line 204: hr_utility.trace('call rowhandler');

200: end;
201: */
202: --
203:
204: hr_utility.trace('call rowhandler');
205: pay_cft_ins.ins
206: (
207: p_emp_fed_tax_inf_id => l_emp_fed_tax_inf_id
208: ,p_effective_start_date => l_effective_start_date

Line 345: hr_utility.set_location(l_proc, 60);

341: --
342: end;
343: */
344: --
345: hr_utility.set_location(l_proc, 60);
346: --
347: -- When in validation only mode raise the Validate_Enabled exception
348: --
349: if p_validate then

Line 360: hr_utility.set_location(' Leaving:'||l_proc, 70);

356: p_effective_start_date := l_effective_start_date;
357: p_effective_end_date := l_effective_end_date;
358: p_object_version_number := l_object_version_number;
359: --
360: hr_utility.set_location(' Leaving:'||l_proc, 70);
361: --
362: end if;
363: exception
364: --

Line 380: hr_utility.set_location(' Leaving:'||l_proc, 80);

376: p_emp_fed_tax_inf_id := null;
377: p_effective_start_date := null;
378: p_effective_end_date := null;
379: p_object_version_number := null;
380: hr_utility.set_location(' Leaving:'||l_proc, 80);
381: --
382: when others then
383: --
384: -- A validation or unexpected error has occured

Line 386: hr_utility.trace('In exeception');

382: when others then
383: --
384: -- A validation or unexpected error has occured
385: --
386: hr_utility.trace('In exeception');
387: ROLLBACK TO create_ca_emp_fedtax_inf;
388: raise;
389: --
390: end create_ca_emp_fedtax_inf;

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

463: l_effective_end_date pay_ca_emp_fed_tax_info_f.effective_end_date%TYPE;
464: --
465: begin
466: --
467: hr_utility.set_location('Entering:'|| l_proc, 10);
468: --
469: -- Issue a savepoint if operating in validation only mode
470: --
471: savepoint update_ca_emp_fedtax_inf;

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

469: -- Issue a savepoint if operating in validation only mode
470: --
471: savepoint update_ca_emp_fedtax_inf;
472: --
473: hr_utility.set_location(l_proc, 20);
474: --
475: -- Process Logic
476: --
477: l_object_version_number := p_object_version_number;

Line 698: hr_utility.set_location(l_proc, 60);

694: --
695: end;
696: */
697: --
698: hr_utility.set_location(l_proc, 60);
699: --
700: -- When in validation only mode raise the Validate_Enabled exception
701: --
702: if p_validate then

Line 712: hr_utility.set_location(' Leaving:'||l_proc, 70);

708: p_object_version_number := l_object_version_number;
709: p_effective_start_date := l_effective_start_date;
710: p_effective_end_date := l_effective_end_date;
711: --
712: hr_utility.set_location(' Leaving:'||l_proc, 70);
713: --
714: exception
715: --
716: when hr_api.validate_enabled then

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

723: -- Only set output warning arguments
724: -- (Any key or derived arguments must be set to null
725: -- when validation only mode is being used.)
726: --
727: hr_utility.set_location(' Leaving:'||l_proc, 80);
728: --
729: when others then
730: --
731: -- A validation or unexpected error has occured

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

756: l_effective_end_date pay_ca_emp_fed_tax_info_f.effective_end_date%TYPE;
757: --
758: begin
759: --
760: hr_utility.set_location('Entering:'|| l_proc, 10);
761: --
762: -- Issue a savepoint if operating in validation only mode
763: --
764: savepoint delete_ca_emp_fedtax_inf;

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

762: -- Issue a savepoint if operating in validation only mode
763: --
764: savepoint delete_ca_emp_fedtax_inf;
765: --
766: hr_utility.set_location(l_proc, 20);
767: --
768: -- Process Logic
769: --
770: l_object_version_number := p_object_version_number;

Line 833: hr_utility.set_location(l_proc, 60);

829: --
830: end;
831: */
832: --
833: hr_utility.set_location(l_proc, 60);
834: --
835: -- When in validation only mode raise the Validate_Enabled exception
836: --
837: if p_validate then

Line 841: hr_utility.set_location(' Leaving:'||l_proc, 70);

837: if p_validate then
838: raise hr_api.validate_enabled;
839: end if;
840: --
841: hr_utility.set_location(' Leaving:'||l_proc, 70);
842: --
843: exception
844: --
845: when hr_api.validate_enabled then

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

887: l_validation_end_date date;
888: --
889: begin
890: --
891: hr_utility.set_location('Entering:'|| l_proc, 10);
892: --
893: pay_cft_shd.lck
894: (
895: p_emp_fed_tax_inf_id => p_emp_fed_tax_inf_id

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

899: ,p_effective_date => p_effective_date
900: ,p_datetrack_mode => p_datetrack_mode
901: );
902: --
903: hr_utility.set_location(' Leaving:'||l_proc, 70);
904: --
905: end lck;
906: --
907: /** Business Processes added manually */

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

912: l_ef_date DATE;
913: l_proc VARCHAR2(50) := 'pay_ca_emp_fedtax_inf_api.pull_tax_records';
914:
915: begin
916: hr_utility.set_location('Entering: ' || l_proc, 5);
917:
918: if p_new_start_date < p_default_date then
919: l_ef_date := p_default_date;
920: elsif p_new_start_date > p_default_date then

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

930: where assignment_id = p_assignment_id
931: and l_ef_date between effective_start_date and effective_end_date;
932:
933: if sql%notfound then
934: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
935: hr_utility.set_message_token('PROCEDURE',l_proc);
936: hr_utility.set_message_token('STEP','2');
937: hr_utility.raise_error;
938: end if;

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

931: and l_ef_date between effective_start_date and effective_end_date;
932:
933: if sql%notfound then
934: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
935: hr_utility.set_message_token('PROCEDURE',l_proc);
936: hr_utility.set_message_token('STEP','2');
937: hr_utility.raise_error;
938: end if;
939:

Line 936: hr_utility.set_message_token('STEP','2');

932:
933: if sql%notfound then
934: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
935: hr_utility.set_message_token('PROCEDURE',l_proc);
936: hr_utility.set_message_token('STEP','2');
937: hr_utility.raise_error;
938: end if;
939:
940: /* Next delete any orphaned rows */

Line 937: hr_utility.raise_error;

933: if sql%notfound then
934: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
935: hr_utility.set_message_token('PROCEDURE',l_proc);
936: hr_utility.set_message_token('STEP','2');
937: hr_utility.raise_error;
938: end if;
939:
940: /* Next delete any orphaned rows */
941: if p_new_start_date > p_default_date then

Line 942: hr_utility.set_location(l_proc, 10);

938: end if;
939:
940: /* Next delete any orphaned rows */
941: if p_new_start_date > p_default_date then
942: hr_utility.set_location(l_proc, 10);
943: delete PAY_CA_EMP_FED_TAX_INFO_F
944: where assignment_id = p_assignment_id
945: and p_new_start_date > effective_start_date;
946:

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

946:
947:
948: end if;
949:
950: hr_utility.set_location('Leaving: ' || l_proc, 20);
951:
952: end pull_tax_records;
953:
954: procedure check_hiring_date( p_assignment_id in number,

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

1011:
1012: if l_default_date is null then
1013:
1014: close csr_get_default_date;
1015: hr_utility.set_message(801 , 'HR_6153_ALL_PROCEDURE_FAIL');
1016: hr_utility.set_message_token('PROCEDURE',
1017: 'pay_ca_emp_fedtax_inf_api.tax_record_already_present');
1018: hr_utility.set_message_token('STEP','1');
1019: hr_utility.raise_error;

Line 1016: hr_utility.set_message_token('PROCEDURE',

1012: if l_default_date is null then
1013:
1014: close csr_get_default_date;
1015: hr_utility.set_message(801 , 'HR_6153_ALL_PROCEDURE_FAIL');
1016: hr_utility.set_message_token('PROCEDURE',
1017: 'pay_ca_emp_fedtax_inf_api.tax_record_already_present');
1018: hr_utility.set_message_token('STEP','1');
1019: hr_utility.raise_error;
1020:

Line 1018: hr_utility.set_message_token('STEP','1');

1014: close csr_get_default_date;
1015: hr_utility.set_message(801 , 'HR_6153_ALL_PROCEDURE_FAIL');
1016: hr_utility.set_message_token('PROCEDURE',
1017: 'pay_ca_emp_fedtax_inf_api.tax_record_already_present');
1018: hr_utility.set_message_token('STEP','1');
1019: hr_utility.raise_error;
1020:
1021: end if;
1022:

Line 1019: hr_utility.raise_error;

1015: hr_utility.set_message(801 , 'HR_6153_ALL_PROCEDURE_FAIL');
1016: hr_utility.set_message_token('PROCEDURE',
1017: 'pay_ca_emp_fedtax_inf_api.tax_record_already_present');
1018: hr_utility.set_message_token('STEP','1');
1019: hr_utility.raise_error;
1020:
1021: end if;
1022:
1023: close csr_get_default_date;

Line 1060: hr_utility.set_message(800 , 'HR_74004_ASSIGNMENT_ABSENT');

1056: open csr_chk_assignment;
1057: fetch csr_chk_assignment into l_location_id;
1058:
1059: if csr_chk_assignment%NOTFOUND then
1060: hr_utility.set_message(800 , 'HR_74004_ASSIGNMENT_ABSENT');
1061: hr_utility.raise_error;
1062: else
1063: if l_location_id is NULL then
1064: hr_utility.set_message(800, 'HR_74005_LOCATION_ABSENT');

Line 1061: hr_utility.raise_error;

1057: fetch csr_chk_assignment into l_location_id;
1058:
1059: if csr_chk_assignment%NOTFOUND then
1060: hr_utility.set_message(800 , 'HR_74004_ASSIGNMENT_ABSENT');
1061: hr_utility.raise_error;
1062: else
1063: if l_location_id is NULL then
1064: hr_utility.set_message(800, 'HR_74005_LOCATION_ABSENT');
1065: hr_utility.raise_error;

Line 1064: hr_utility.set_message(800, 'HR_74005_LOCATION_ABSENT');

1060: hr_utility.set_message(800 , 'HR_74004_ASSIGNMENT_ABSENT');
1061: hr_utility.raise_error;
1062: else
1063: if l_location_id is NULL then
1064: hr_utility.set_message(800, 'HR_74005_LOCATION_ABSENT');
1065: hr_utility.raise_error;
1066: else
1067: open csr_get_location(l_location_id);
1068: fetch csr_get_location into l_country;

Line 1065: hr_utility.raise_error;

1061: hr_utility.raise_error;
1062: else
1063: if l_location_id is NULL then
1064: hr_utility.set_message(800, 'HR_74005_LOCATION_ABSENT');
1065: hr_utility.raise_error;
1066: else
1067: open csr_get_location(l_location_id);
1068: fetch csr_get_location into l_country;
1069: if l_country is null or l_country <> 'CA' then

Line 1070: hr_utility.set_message(800, 'HR_74006_LOCATION_WRONG');

1066: else
1067: open csr_get_location(l_location_id);
1068: fetch csr_get_location into l_country;
1069: if l_country is null or l_country <> 'CA' then
1070: hr_utility.set_message(800, 'HR_74006_LOCATION_WRONG');
1071: hr_utility.raise_error;
1072: end if;
1073: end if;
1074: end if;

Line 1071: hr_utility.raise_error;

1067: open csr_get_location(l_location_id);
1068: fetch csr_get_location into l_country;
1069: if l_country is null or l_country <> 'CA' then
1070: hr_utility.set_message(800, 'HR_74006_LOCATION_WRONG');
1071: hr_utility.raise_error;
1072: end if;
1073: end if;
1074: end if;
1075: end perform_assignment_validation;

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

1080: p_tax_credit_amount in number) is
1081: begin
1082: if p_basic_exemption_flag = 'Y' then
1083: if p_tax_credit_amount is not null then
1084: hr_utility.set_message(800, 'HR_74007_BOTH_NOT_NULL');
1085: hr_utility.raise_error;
1086: end if;
1087: elsif p_basic_exemption_flag = 'N' then
1088: if p_tax_credit_amount is NULL then

Line 1085: hr_utility.raise_error;

1081: begin
1082: if p_basic_exemption_flag = 'Y' then
1083: if p_tax_credit_amount is not null then
1084: hr_utility.set_message(800, 'HR_74007_BOTH_NOT_NULL');
1085: hr_utility.raise_error;
1086: end if;
1087: elsif p_basic_exemption_flag = 'N' then
1088: if p_tax_credit_amount is NULL then
1089: hr_utility.set_message(800, 'HR_74008_BOTH_NULL');

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

1085: hr_utility.raise_error;
1086: end if;
1087: elsif p_basic_exemption_flag = 'N' then
1088: if p_tax_credit_amount is NULL then
1089: hr_utility.set_message(800, 'HR_74008_BOTH_NULL');
1090: hr_utility.raise_error;
1091: end if;
1092: elsif p_basic_exemption_flag is NULL then
1093: if p_tax_credit_amount is NULL then

Line 1090: hr_utility.raise_error;

1086: end if;
1087: elsif p_basic_exemption_flag = 'N' then
1088: if p_tax_credit_amount is NULL then
1089: hr_utility.set_message(800, 'HR_74008_BOTH_NULL');
1090: hr_utility.raise_error;
1091: end if;
1092: elsif p_basic_exemption_flag is NULL then
1093: if p_tax_credit_amount is NULL then
1094: hr_utility.set_message(800, 'HR_74008_BOTH_NULL');

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

1090: hr_utility.raise_error;
1091: end if;
1092: elsif p_basic_exemption_flag is NULL then
1093: if p_tax_credit_amount is NULL then
1094: hr_utility.set_message(800, 'HR_74008_BOTH_NULL');
1095: hr_utility.raise_error;
1096: end if;
1097: end if;
1098: end check_basic_exemption;

Line 1095: hr_utility.raise_error;

1091: end if;
1092: elsif p_basic_exemption_flag is NULL then
1093: if p_tax_credit_amount is NULL then
1094: hr_utility.set_message(800, 'HR_74008_BOTH_NULL');
1095: hr_utility.raise_error;
1096: end if;
1097: end if;
1098: end check_basic_exemption;
1099:

Line 1114: hr_utility.set_message(800, 'HR_74009_EMPL_PROV_WRONG');

1110: begin
1111: open csr_employment_province;
1112: fetch csr_employment_province into l_employment_province;
1113: if csr_employment_province%NOTFOUND then
1114: hr_utility.set_message(800, 'HR_74009_EMPL_PROV_WRONG');
1115: hr_utility.raise_error;
1116: end if;
1117: end check_employment_province;
1118:

Line 1115: hr_utility.raise_error;

1111: open csr_employment_province;
1112: fetch csr_employment_province into l_employment_province;
1113: if csr_employment_province%NOTFOUND then
1114: hr_utility.set_message(800, 'HR_74009_EMPL_PROV_WRONG');
1115: hr_utility.raise_error;
1116: end if;
1117: end check_employment_province;
1118:
1119: function convert_null_to_zero(p_value in number) return number is