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.

[Home] [Help]

APPS.PAY_CA_EMP_FEDTAX_INF_API dependencies on HR_UTILITY

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

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

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

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

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

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

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

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

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

196: end;
197: */
198: --
199:
200: hr_utility.trace('call rowhandler');
201: pay_cft_ins.ins
202: (
203: p_emp_fed_tax_inf_id => l_emp_fed_tax_inf_id
204: ,p_effective_start_date => l_effective_start_date

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

333: --
334: end;
335: */
336: --
337: hr_utility.set_location(l_proc, 60);
338: --
339: -- When in validation only mode raise the Validate_Enabled exception
340: --
341: if p_validate then

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

348: p_effective_start_date := l_effective_start_date;
349: p_effective_end_date := l_effective_end_date;
350: p_object_version_number := l_object_version_number;
351: --
352: hr_utility.set_location(' Leaving:'||l_proc, 70);
353: --
354: end if;
355: exception
356: --

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

368: p_emp_fed_tax_inf_id := null;
369: p_effective_start_date := null;
370: p_effective_end_date := null;
371: p_object_version_number := null;
372: hr_utility.set_location(' Leaving:'||l_proc, 80);
373: --
374: when others then
375: --
376: -- A validation or unexpected error has occured

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

374: when others then
375: --
376: -- A validation or unexpected error has occured
377: --
378: hr_utility.trace('In exeception');
379: ROLLBACK TO create_ca_emp_fedtax_inf;
380: raise;
381: --
382: end create_ca_emp_fedtax_inf;

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

453: l_effective_end_date pay_ca_emp_fed_tax_info_f.effective_end_date%TYPE;
454: --
455: begin
456: --
457: hr_utility.set_location('Entering:'|| l_proc, 10);
458: --
459: -- Issue a savepoint if operating in validation only mode
460: --
461: savepoint update_ca_emp_fedtax_inf;

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

459: -- Issue a savepoint if operating in validation only mode
460: --
461: savepoint update_ca_emp_fedtax_inf;
462: --
463: hr_utility.set_location(l_proc, 20);
464: --
465: -- Process Logic
466: --
467: l_object_version_number := p_object_version_number;

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

678: --
679: end;
680: */
681: --
682: hr_utility.set_location(l_proc, 60);
683: --
684: -- When in validation only mode raise the Validate_Enabled exception
685: --
686: if p_validate then

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

692: p_object_version_number := l_object_version_number;
693: p_effective_start_date := l_effective_start_date;
694: p_effective_end_date := l_effective_end_date;
695: --
696: hr_utility.set_location(' Leaving:'||l_proc, 70);
697: --
698: exception
699: --
700: when hr_api.validate_enabled then

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

707: -- Only set output warning arguments
708: -- (Any key or derived arguments must be set to null
709: -- when validation only mode is being used.)
710: --
711: hr_utility.set_location(' Leaving:'||l_proc, 80);
712: --
713: when others then
714: --
715: -- A validation or unexpected error has occured

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

740: l_effective_end_date pay_ca_emp_fed_tax_info_f.effective_end_date%TYPE;
741: --
742: begin
743: --
744: hr_utility.set_location('Entering:'|| l_proc, 10);
745: --
746: -- Issue a savepoint if operating in validation only mode
747: --
748: savepoint delete_ca_emp_fedtax_inf;

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

746: -- Issue a savepoint if operating in validation only mode
747: --
748: savepoint delete_ca_emp_fedtax_inf;
749: --
750: hr_utility.set_location(l_proc, 20);
751: --
752: -- Process Logic
753: --
754: l_object_version_number := p_object_version_number;

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

813: --
814: end;
815: */
816: --
817: hr_utility.set_location(l_proc, 60);
818: --
819: -- When in validation only mode raise the Validate_Enabled exception
820: --
821: if p_validate then

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

821: if p_validate then
822: raise hr_api.validate_enabled;
823: end if;
824: --
825: hr_utility.set_location(' Leaving:'||l_proc, 70);
826: --
827: exception
828: --
829: when hr_api.validate_enabled then

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

871: l_validation_end_date date;
872: --
873: begin
874: --
875: hr_utility.set_location('Entering:'|| l_proc, 10);
876: --
877: pay_cft_shd.lck
878: (
879: p_emp_fed_tax_inf_id => p_emp_fed_tax_inf_id

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

883: ,p_effective_date => p_effective_date
884: ,p_datetrack_mode => p_datetrack_mode
885: );
886: --
887: hr_utility.set_location(' Leaving:'||l_proc, 70);
888: --
889: end lck;
890: --
891: /** Business Processes added manually */

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

896: l_ef_date DATE;
897: l_proc VARCHAR2(50) := 'pay_ca_emp_fedtax_inf_api.pull_tax_records';
898:
899: begin
900: hr_utility.set_location('Entering: ' || l_proc, 5);
901:
902: if p_new_start_date < p_default_date then
903: l_ef_date := p_default_date;
904: elsif p_new_start_date > p_default_date then

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

914: where assignment_id = p_assignment_id
915: and l_ef_date between effective_start_date and effective_end_date;
916:
917: if sql%notfound then
918: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
919: hr_utility.set_message_token('PROCEDURE',l_proc);
920: hr_utility.set_message_token('STEP','2');
921: hr_utility.raise_error;
922: end if;

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

915: and l_ef_date between effective_start_date and effective_end_date;
916:
917: if sql%notfound then
918: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
919: hr_utility.set_message_token('PROCEDURE',l_proc);
920: hr_utility.set_message_token('STEP','2');
921: hr_utility.raise_error;
922: end if;
923:

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

916:
917: if sql%notfound then
918: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
919: hr_utility.set_message_token('PROCEDURE',l_proc);
920: hr_utility.set_message_token('STEP','2');
921: hr_utility.raise_error;
922: end if;
923:
924: /* Next delete any orphaned rows */

Line 921: hr_utility.raise_error;

917: if sql%notfound then
918: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
919: hr_utility.set_message_token('PROCEDURE',l_proc);
920: hr_utility.set_message_token('STEP','2');
921: hr_utility.raise_error;
922: end if;
923:
924: /* Next delete any orphaned rows */
925: if p_new_start_date > p_default_date then

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

922: end if;
923:
924: /* Next delete any orphaned rows */
925: if p_new_start_date > p_default_date then
926: hr_utility.set_location(l_proc, 10);
927: delete PAY_CA_EMP_FED_TAX_INFO_F
928: where assignment_id = p_assignment_id
929: and p_new_start_date > effective_start_date;
930:

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

930:
931:
932: end if;
933:
934: hr_utility.set_location('Leaving: ' || l_proc, 20);
935:
936: end pull_tax_records;
937:
938: procedure check_hiring_date( p_assignment_id in number,

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

995:
996: if l_default_date is null then
997:
998: close csr_get_default_date;
999: hr_utility.set_message(801 , 'HR_6153_ALL_PROCEDURE_FAIL');
1000: hr_utility.set_message_token('PROCEDURE',
1001: 'pay_ca_emp_fedtax_inf_api.tax_record_already_present');
1002: hr_utility.set_message_token('STEP','1');
1003: hr_utility.raise_error;

Line 1000: hr_utility.set_message_token('PROCEDURE',

996: if l_default_date is null then
997:
998: close csr_get_default_date;
999: hr_utility.set_message(801 , 'HR_6153_ALL_PROCEDURE_FAIL');
1000: hr_utility.set_message_token('PROCEDURE',
1001: 'pay_ca_emp_fedtax_inf_api.tax_record_already_present');
1002: hr_utility.set_message_token('STEP','1');
1003: hr_utility.raise_error;
1004:

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

998: close csr_get_default_date;
999: hr_utility.set_message(801 , 'HR_6153_ALL_PROCEDURE_FAIL');
1000: hr_utility.set_message_token('PROCEDURE',
1001: 'pay_ca_emp_fedtax_inf_api.tax_record_already_present');
1002: hr_utility.set_message_token('STEP','1');
1003: hr_utility.raise_error;
1004:
1005: end if;
1006:

Line 1003: hr_utility.raise_error;

999: hr_utility.set_message(801 , 'HR_6153_ALL_PROCEDURE_FAIL');
1000: hr_utility.set_message_token('PROCEDURE',
1001: 'pay_ca_emp_fedtax_inf_api.tax_record_already_present');
1002: hr_utility.set_message_token('STEP','1');
1003: hr_utility.raise_error;
1004:
1005: end if;
1006:
1007: close csr_get_default_date;

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

1040: open csr_chk_assignment;
1041: fetch csr_chk_assignment into l_location_id;
1042:
1043: if csr_chk_assignment%NOTFOUND then
1044: hr_utility.set_message(800 , 'HR_74004_ASSIGNMENT_ABSENT');
1045: hr_utility.raise_error;
1046: else
1047: if l_location_id is NULL then
1048: hr_utility.set_message(800, 'HR_74005_LOCATION_ABSENT');

Line 1045: hr_utility.raise_error;

1041: fetch csr_chk_assignment into l_location_id;
1042:
1043: if csr_chk_assignment%NOTFOUND then
1044: hr_utility.set_message(800 , 'HR_74004_ASSIGNMENT_ABSENT');
1045: hr_utility.raise_error;
1046: else
1047: if l_location_id is NULL then
1048: hr_utility.set_message(800, 'HR_74005_LOCATION_ABSENT');
1049: hr_utility.raise_error;

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

1044: hr_utility.set_message(800 , 'HR_74004_ASSIGNMENT_ABSENT');
1045: hr_utility.raise_error;
1046: else
1047: if l_location_id is NULL then
1048: hr_utility.set_message(800, 'HR_74005_LOCATION_ABSENT');
1049: hr_utility.raise_error;
1050: else
1051: open csr_get_location(l_location_id);
1052: fetch csr_get_location into l_country;

Line 1049: hr_utility.raise_error;

1045: hr_utility.raise_error;
1046: else
1047: if l_location_id is NULL then
1048: hr_utility.set_message(800, 'HR_74005_LOCATION_ABSENT');
1049: hr_utility.raise_error;
1050: else
1051: open csr_get_location(l_location_id);
1052: fetch csr_get_location into l_country;
1053: if l_country is null or l_country <> 'CA' then

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

1050: else
1051: open csr_get_location(l_location_id);
1052: fetch csr_get_location into l_country;
1053: if l_country is null or l_country <> 'CA' then
1054: hr_utility.set_message(800, 'HR_74006_LOCATION_WRONG');
1055: hr_utility.raise_error;
1056: end if;
1057: end if;
1058: end if;

Line 1055: hr_utility.raise_error;

1051: open csr_get_location(l_location_id);
1052: fetch csr_get_location into l_country;
1053: if l_country is null or l_country <> 'CA' then
1054: hr_utility.set_message(800, 'HR_74006_LOCATION_WRONG');
1055: hr_utility.raise_error;
1056: end if;
1057: end if;
1058: end if;
1059: end perform_assignment_validation;

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

1064: p_tax_credit_amount in number) is
1065: begin
1066: if p_basic_exemption_flag = 'Y' then
1067: if p_tax_credit_amount is not null then
1068: hr_utility.set_message(800, 'HR_74007_BOTH_NOT_NULL');
1069: hr_utility.raise_error;
1070: end if;
1071: elsif p_basic_exemption_flag = 'N' then
1072: if p_tax_credit_amount is NULL then

Line 1069: hr_utility.raise_error;

1065: begin
1066: if p_basic_exemption_flag = 'Y' then
1067: if p_tax_credit_amount is not null then
1068: hr_utility.set_message(800, 'HR_74007_BOTH_NOT_NULL');
1069: hr_utility.raise_error;
1070: end if;
1071: elsif p_basic_exemption_flag = 'N' then
1072: if p_tax_credit_amount is NULL then
1073: hr_utility.set_message(800, 'HR_74008_BOTH_NULL');

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

1069: hr_utility.raise_error;
1070: end if;
1071: elsif p_basic_exemption_flag = 'N' then
1072: if p_tax_credit_amount is NULL then
1073: hr_utility.set_message(800, 'HR_74008_BOTH_NULL');
1074: hr_utility.raise_error;
1075: end if;
1076: elsif p_basic_exemption_flag is NULL then
1077: if p_tax_credit_amount is NULL then

Line 1074: hr_utility.raise_error;

1070: end if;
1071: elsif p_basic_exemption_flag = 'N' then
1072: if p_tax_credit_amount is NULL then
1073: hr_utility.set_message(800, 'HR_74008_BOTH_NULL');
1074: hr_utility.raise_error;
1075: end if;
1076: elsif p_basic_exemption_flag is NULL then
1077: if p_tax_credit_amount is NULL then
1078: hr_utility.set_message(800, 'HR_74008_BOTH_NULL');

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

1074: hr_utility.raise_error;
1075: end if;
1076: elsif p_basic_exemption_flag is NULL then
1077: if p_tax_credit_amount is NULL then
1078: hr_utility.set_message(800, 'HR_74008_BOTH_NULL');
1079: hr_utility.raise_error;
1080: end if;
1081: end if;
1082: end check_basic_exemption;

Line 1079: hr_utility.raise_error;

1075: end if;
1076: elsif p_basic_exemption_flag is NULL then
1077: if p_tax_credit_amount is NULL then
1078: hr_utility.set_message(800, 'HR_74008_BOTH_NULL');
1079: hr_utility.raise_error;
1080: end if;
1081: end if;
1082: end check_basic_exemption;
1083:

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

1094: begin
1095: open csr_employment_province;
1096: fetch csr_employment_province into l_employment_province;
1097: if csr_employment_province%NOTFOUND then
1098: hr_utility.set_message(800, 'HR_74009_EMPL_PROV_WRONG');
1099: hr_utility.raise_error;
1100: end if;
1101: end check_employment_province;
1102:

Line 1099: hr_utility.raise_error;

1095: open csr_employment_province;
1096: fetch csr_employment_province into l_employment_province;
1097: if csr_employment_province%NOTFOUND then
1098: hr_utility.set_message(800, 'HR_74009_EMPL_PROV_WRONG');
1099: hr_utility.raise_error;
1100: end if;
1101: end check_employment_province;
1102:
1103: function convert_null_to_zero(p_value in number) return number is