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

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

100: l_prov_lsp_amount number;
101: --
102: begin
103: --
104: hr_utility.set_location('Entering:'|| l_proc, 10);
105: --
106: -- Issue a savepoint if operating in validation only mode
107: --
108: savepoint create_ca_emp_prvtax_inf;

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

106: -- Issue a savepoint if operating in validation only mode
107: --
108: savepoint create_ca_emp_prvtax_inf;
109: --
110: hr_utility.set_location(l_proc, 20);
111: --
112: -- Process Logic
113: --
114:

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

371: --
372: end;
373: */
374: --
375: hr_utility.set_location(l_proc, 60);
376: --
377: -- When in validation only mode raise the Validate_Enabled exception
378: --
379: if p_validate then

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

386: p_effective_start_date := l_effective_start_date;
387: p_effective_end_date := l_effective_end_date;
388: p_object_version_number := l_object_version_number;
389: --
390: hr_utility.set_location(' Leaving:'||l_proc, 70);
391: --
392: end if;
393: exception
394: --

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

406: p_emp_province_tax_inf_id := null;
407: p_effective_start_date := null;
408: p_effective_end_date := null;
409: p_object_version_number := null;
410: hr_utility.set_location(' Leaving:'||l_proc, 80);
411: --
412: when others then
413: --
414: -- A validation or unexpected error has occured

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

507: l_effective_end_date pay_ca_emp_prov_tax_info_f.effective_end_date%TYPE;
508: --
509: begin
510: --
511: hr_utility.set_location('Entering:'|| l_proc, 10);
512: --
513: -- Issue a savepoint if operating in validation only mode
514: --
515: savepoint update_ca_emp_prvtax_inf;

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

513: -- Issue a savepoint if operating in validation only mode
514: --
515: savepoint update_ca_emp_prvtax_inf;
516: --
517: hr_utility.set_location(l_proc, 20);
518: --
519: -- Process Logic
520: --
521: l_object_version_number := p_object_version_number;

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

758: --
759: end;
760: */
761: --
762: hr_utility.set_location(l_proc, 60);
763: --
764: -- When in validation only mode raise the Validate_Enabled exception
765: --
766: if p_validate then

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

772: p_object_version_number := l_object_version_number;
773: p_effective_start_date := l_effective_start_date;
774: p_effective_end_date := l_effective_end_date;
775: --
776: hr_utility.set_location(' Leaving:'||l_proc, 70);
777: --
778: exception
779: --
780: when hr_api.validate_enabled then

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

787: -- Only set output warning arguments
788: -- (Any key or derived arguments must be set to null
789: -- when validation only mode is being used.)
790: --
791: hr_utility.set_location(' Leaving:'||l_proc, 80);
792: --
793: when others then
794: --
795: -- A validation or unexpected error has occured

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

827: l_effective_end_date pay_ca_emp_prov_tax_info_f.effective_end_date%TYPE;
828: --
829: begin
830: --
831: hr_utility.set_location('Entering:'|| l_proc, 10);
832: --
833: -- Issue a savepoint if operating in validation only mode
834: --
835: savepoint delete_ca_emp_prvtax_inf;

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

833: -- Issue a savepoint if operating in validation only mode
834: --
835: savepoint delete_ca_emp_prvtax_inf;
836: --
837: hr_utility.set_location(l_proc, 20);
838: --
839: -- Process Logic
840: --
841: l_object_version_number := p_object_version_number;

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

900: --
901: end;
902: --
903: */
904: hr_utility.set_location(l_proc, 60);
905: --
906: -- When in validation only mode raise the Validate_Enabled exception
907: --
908: if p_validate then

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

908: if p_validate then
909: raise hr_api.validate_enabled;
910: end if;
911: --
912: hr_utility.set_location(' Leaving:'||l_proc, 70);
913: --
914: exception
915: --
916: when hr_api.validate_enabled then

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

965: l_validation_end_date date;
966: --
967: begin
968: --
969: hr_utility.set_location('Entering:'|| l_proc, 10);
970: --
971: pay_cpt_shd.lck
972: (
973: p_emp_province_tax_inf_id => p_emp_province_tax_inf_id

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

977: ,p_effective_date => p_effective_date
978: ,p_datetrack_mode => p_datetrack_mode
979: );
980: --
981: hr_utility.set_location(' Leaving:'||l_proc, 70);
982: --
983: end lck;
984: --
985:

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

991: l_ef_date DATE;
992: l_proc VARCHAR2(50) := 'pay_ca_emp_provtax_inf_api.pull_tax_records';
993:
994: begin
995: hr_utility.set_location('Entering: ' || l_proc, 5);
996:
997: if p_new_start_date < p_default_date then
998: l_ef_date := p_default_date;
999: elsif p_new_start_date > p_default_date then

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

1010: and l_ef_date between effective_start_date and effective_end_date
1011: and province_code = p_province_code;
1012:
1013: if sql%notfound then
1014: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1015: hr_utility.set_message_token('PROCEDURE',l_proc);
1016: hr_utility.set_message_token('STEP','2');
1017: hr_utility.raise_error;
1018: end if;

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

1011: and province_code = p_province_code;
1012:
1013: if sql%notfound then
1014: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1015: hr_utility.set_message_token('PROCEDURE',l_proc);
1016: hr_utility.set_message_token('STEP','2');
1017: hr_utility.raise_error;
1018: end if;
1019:

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

1012:
1013: if sql%notfound then
1014: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1015: hr_utility.set_message_token('PROCEDURE',l_proc);
1016: hr_utility.set_message_token('STEP','2');
1017: hr_utility.raise_error;
1018: end if;
1019:
1020: /* Next delete any orphaned rows */

Line 1017: hr_utility.raise_error;

1013: if sql%notfound then
1014: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1015: hr_utility.set_message_token('PROCEDURE',l_proc);
1016: hr_utility.set_message_token('STEP','2');
1017: hr_utility.raise_error;
1018: end if;
1019:
1020: /* Next delete any orphaned rows */
1021: if p_new_start_date > p_default_date then

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

1018: end if;
1019:
1020: /* Next delete any orphaned rows */
1021: if p_new_start_date > p_default_date then
1022: hr_utility.set_location(l_proc, 10);
1023: delete PAY_CA_EMP_PROV_TAX_INFO_F
1024: where assignment_id = p_assignment_id
1025: and p_new_start_date > effective_start_date
1026: and province_code = p_province_code;

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

1026: and province_code = p_province_code;
1027:
1028: end if;
1029:
1030: hr_utility.set_location('Leaving: ' || l_proc, 20);
1031:
1032: end pull_tax_records;
1033:
1034: procedure check_hiring_date( p_assignment_id in number,

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

1099:
1100: if l_default_date is null then
1101:
1102: close csr_get_default_date;
1103: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1104: hr_utility.set_message_token('PROCEDURE',
1105: 'pay_ca_emp_fedtax_inf_api.tax_record_already_present');
1106: hr_utility.set_message_token('STEP','1');
1107: hr_utility.raise_error;

Line 1104: hr_utility.set_message_token('PROCEDURE',

1100: if l_default_date is null then
1101:
1102: close csr_get_default_date;
1103: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1104: hr_utility.set_message_token('PROCEDURE',
1105: 'pay_ca_emp_fedtax_inf_api.tax_record_already_present');
1106: hr_utility.set_message_token('STEP','1');
1107: hr_utility.raise_error;
1108:

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

1102: close csr_get_default_date;
1103: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1104: hr_utility.set_message_token('PROCEDURE',
1105: 'pay_ca_emp_fedtax_inf_api.tax_record_already_present');
1106: hr_utility.set_message_token('STEP','1');
1107: hr_utility.raise_error;
1108:
1109: end if;
1110:

Line 1107: hr_utility.raise_error;

1103: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1104: hr_utility.set_message_token('PROCEDURE',
1105: 'pay_ca_emp_fedtax_inf_api.tax_record_already_present');
1106: hr_utility.set_message_token('STEP','1');
1107: hr_utility.raise_error;
1108:
1109: end if;
1110:
1111: close csr_get_default_date;

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

1140: open csr_chk_assignment;
1141: fetch csr_chk_assignment into l_location_id;
1142:
1143: if csr_chk_assignment%NOTFOUND then
1144: hr_utility.set_message(800, 'HR_74004_ASSIGNMENT_ABSENT');
1145: hr_utility.raise_error;
1146: else
1147: if l_location_id is NULL then
1148: hr_utility.set_message(800, 'HR_74005_LOCATION_ABSENT');

Line 1145: hr_utility.raise_error;

1141: fetch csr_chk_assignment into l_location_id;
1142:
1143: if csr_chk_assignment%NOTFOUND then
1144: hr_utility.set_message(800, 'HR_74004_ASSIGNMENT_ABSENT');
1145: hr_utility.raise_error;
1146: else
1147: if l_location_id is NULL then
1148: hr_utility.set_message(800, 'HR_74005_LOCATION_ABSENT');
1149: hr_utility.raise_error;

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

1144: hr_utility.set_message(800, 'HR_74004_ASSIGNMENT_ABSENT');
1145: hr_utility.raise_error;
1146: else
1147: if l_location_id is NULL then
1148: hr_utility.set_message(800, 'HR_74005_LOCATION_ABSENT');
1149: hr_utility.raise_error;
1150: else
1151: open csr_get_location(l_location_id);
1152: fetch csr_get_location into l_country;

Line 1149: hr_utility.raise_error;

1145: hr_utility.raise_error;
1146: else
1147: if l_location_id is NULL then
1148: hr_utility.set_message(800, 'HR_74005_LOCATION_ABSENT');
1149: hr_utility.raise_error;
1150: else
1151: open csr_get_location(l_location_id);
1152: fetch csr_get_location into l_country;
1153: if l_country is null or l_country <> 'CA' then

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

1150: else
1151: open csr_get_location(l_location_id);
1152: fetch csr_get_location into l_country;
1153: if l_country is null or l_country <> 'CA' then
1154: hr_utility.set_message(800, 'HR_74006_LOCATION_WRONG');
1155: hr_utility.raise_error;
1156: end if;
1157: end if;
1158: end if;

Line 1155: hr_utility.raise_error;

1151: open csr_get_location(l_location_id);
1152: fetch csr_get_location into l_country;
1153: if l_country is null or l_country <> 'CA' then
1154: hr_utility.set_message(800, 'HR_74006_LOCATION_WRONG');
1155: hr_utility.raise_error;
1156: end if;
1157: end if;
1158: end if;
1159: end perform_assignment_validation;

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

1163: p_tax_credit_amount in number) is
1164: begin
1165: if p_basic_exemption_flag = 'Y' then
1166: if p_tax_credit_amount is not null then
1167: hr_utility.set_message(800, 'HR_74007_BOTH_NOT_NULL');
1168: hr_utility.raise_error;
1169: end if;
1170: elsif p_basic_exemption_flag = 'N' then
1171: if p_tax_credit_amount is NULL then

Line 1168: hr_utility.raise_error;

1164: begin
1165: if p_basic_exemption_flag = 'Y' then
1166: if p_tax_credit_amount is not null then
1167: hr_utility.set_message(800, 'HR_74007_BOTH_NOT_NULL');
1168: hr_utility.raise_error;
1169: end if;
1170: elsif p_basic_exemption_flag = 'N' then
1171: if p_tax_credit_amount is NULL then
1172: hr_utility.set_message(800, 'HR_74008_BOTH_NULL');

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

1168: hr_utility.raise_error;
1169: end if;
1170: elsif p_basic_exemption_flag = 'N' then
1171: if p_tax_credit_amount is NULL then
1172: hr_utility.set_message(800, 'HR_74008_BOTH_NULL');
1173: hr_utility.raise_error;
1174: end if;
1175: elsif p_basic_exemption_flag is NULL then
1176: if p_tax_credit_amount is NULL then

Line 1173: hr_utility.raise_error;

1169: end if;
1170: elsif p_basic_exemption_flag = 'N' then
1171: if p_tax_credit_amount is NULL then
1172: hr_utility.set_message(800, 'HR_74008_BOTH_NULL');
1173: hr_utility.raise_error;
1174: end if;
1175: elsif p_basic_exemption_flag is NULL then
1176: if p_tax_credit_amount is NULL then
1177: hr_utility.set_message(800, 'HR_74008_BOTH_NULL');

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

1173: hr_utility.raise_error;
1174: end if;
1175: elsif p_basic_exemption_flag is NULL then
1176: if p_tax_credit_amount is NULL then
1177: hr_utility.set_message(800, 'HR_74008_BOTH_NULL');
1178: hr_utility.raise_error;
1179: end if;
1180: end if;
1181: end check_basic_exemption;

Line 1178: hr_utility.raise_error;

1174: end if;
1175: elsif p_basic_exemption_flag is NULL then
1176: if p_tax_credit_amount is NULL then
1177: hr_utility.set_message(800, 'HR_74008_BOTH_NULL');
1178: hr_utility.raise_error;
1179: end if;
1180: end if;
1181: end check_basic_exemption;
1182:

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

1192: begin
1193: open csr_province_code;
1194: fetch csr_province_code into l_province_code;
1195: if csr_province_code%NOTFOUND then
1196: hr_utility.set_message(800, 'HR_74009_EMPL_PROV_WRONG');
1197: hr_utility.raise_error;
1198: end if;
1199: end check_province_code;
1200: --

Line 1197: hr_utility.raise_error;

1193: open csr_province_code;
1194: fetch csr_province_code into l_province_code;
1195: if csr_province_code%NOTFOUND then
1196: hr_utility.set_message(800, 'HR_74009_EMPL_PROV_WRONG');
1197: hr_utility.raise_error;
1198: end if;
1199: end check_province_code;
1200: --
1201: function convert_null_to_zero(p_value in number) return number is