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

Line 186: hr_utility.set_location('Entering: '||l_proc,1);

182: p_name in varchar2,
183: p_mode in varchar2) return boolean IS
184: l_proc CONSTANT VARCHAR2(50):= g_package||'validate_data';
185: BEGIN
186: hr_utility.set_location('Entering: '||l_proc,1);
187: if pay_gb_eoy_magtape.validate_input(UPPER(p_value),p_mode) > 0 then
188: hr_utility.set_location('Name/Value : ' || p_name || '/' || p_value ,10);
189: pay_core_utils.push_message(800, 'HR_78057_GB_MAGTAPE_VAILDATION', 'F');
190: pay_core_utils.push_token('INPUT_NAME', p_name);

Line 188: hr_utility.set_location('Name/Value : ' || p_name || '/' || p_value ,10);

184: l_proc CONSTANT VARCHAR2(50):= g_package||'validate_data';
185: BEGIN
186: hr_utility.set_location('Entering: '||l_proc,1);
187: if pay_gb_eoy_magtape.validate_input(UPPER(p_value),p_mode) > 0 then
188: hr_utility.set_location('Name/Value : ' || p_name || '/' || p_value ,10);
189: pay_core_utils.push_message(800, 'HR_78057_GB_MAGTAPE_VAILDATION', 'F');
190: pay_core_utils.push_token('INPUT_NAME', p_name);
191: pay_core_utils.push_token('INPUT_VALUE', p_value);
192: return false;

Line 194: hr_utility.set_location('Leaving: '||l_proc,999);

190: pay_core_utils.push_token('INPUT_NAME', p_name);
191: pay_core_utils.push_token('INPUT_VALUE', p_value);
192: return false;
193: end if;
194: hr_utility.set_location('Leaving: '||l_proc,999);
195: return true;
196: END validate_data;
197: --
198: --

Line 231: hr_utility.set_location('Entering: '||l_proc,1);

227: l_mode4 varchar2 (15) :='NO_VALUE' ; --For bug 9255173
228:
229: BEGIN
230: l_ret := true;
231: hr_utility.set_location('Entering: '||l_proc,1);
232:
233: -- Bug 6770200
234: -- Additional modes added. Like while checking for P45PT3,
235: -- also check if the employee has been picked by a P45PT3(new) or

Line 275: hr_utility.set_location('p_mode: '||p_mode,1);

271: l_mode2 := p_mode ;
272: l_mode3 := p_mode ;
273: end if ;
274:
275: hr_utility.set_location('p_mode: '||p_mode,1);
276: hr_utility.set_location('l_mode1: '||l_mode1,1);
277: hr_utility.set_location('l_mode2: '||l_mode2,1);
278: hr_utility.set_location('l_mode3: '||l_mode3,1);
279: hr_utility.set_location('l_mode4: '||l_mode4,1);

Line 276: hr_utility.set_location('l_mode1: '||l_mode1,1);

272: l_mode3 := p_mode ;
273: end if ;
274:
275: hr_utility.set_location('p_mode: '||p_mode,1);
276: hr_utility.set_location('l_mode1: '||l_mode1,1);
277: hr_utility.set_location('l_mode2: '||l_mode2,1);
278: hr_utility.set_location('l_mode3: '||l_mode3,1);
279: hr_utility.set_location('l_mode4: '||l_mode4,1);
280:

Line 277: hr_utility.set_location('l_mode2: '||l_mode2,1);

273: end if ;
274:
275: hr_utility.set_location('p_mode: '||p_mode,1);
276: hr_utility.set_location('l_mode1: '||l_mode1,1);
277: hr_utility.set_location('l_mode2: '||l_mode2,1);
278: hr_utility.set_location('l_mode3: '||l_mode3,1);
279: hr_utility.set_location('l_mode4: '||l_mode4,1);
280:
281: open csr_check_action(l_mode1, l_mode2 , l_mode3, l_mode4);

Line 278: hr_utility.set_location('l_mode3: '||l_mode3,1);

274:
275: hr_utility.set_location('p_mode: '||p_mode,1);
276: hr_utility.set_location('l_mode1: '||l_mode1,1);
277: hr_utility.set_location('l_mode2: '||l_mode2,1);
278: hr_utility.set_location('l_mode3: '||l_mode3,1);
279: hr_utility.set_location('l_mode4: '||l_mode4,1);
280:
281: open csr_check_action(l_mode1, l_mode2 , l_mode3, l_mode4);
282: fetch csr_check_action into l_action;

Line 279: hr_utility.set_location('l_mode4: '||l_mode4,1);

275: hr_utility.set_location('p_mode: '||p_mode,1);
276: hr_utility.set_location('l_mode1: '||l_mode1,1);
277: hr_utility.set_location('l_mode2: '||l_mode2,1);
278: hr_utility.set_location('l_mode3: '||l_mode3,1);
279: hr_utility.set_location('l_mode4: '||l_mode4,1);
280:
281: open csr_check_action(l_mode1, l_mode2 , l_mode3, l_mode4);
282: fetch csr_check_action into l_action;
283: if csr_check_action%FOUND then

Line 284: hr_utility.set_location('Assignment action complete',5);

280:
281: open csr_check_action(l_mode1, l_mode2 , l_mode3, l_mode4);
282: fetch csr_check_action into l_action;
283: if csr_check_action%FOUND then
284: hr_utility.set_location('Assignment action complete',5);
285: l_ret := false;
286: end if;
287: close csr_check_action;
288: hr_utility.set_location('Leaving: '||l_proc,999);

Line 288: hr_utility.set_location('Leaving: '||l_proc,999);

284: hr_utility.set_location('Assignment action complete',5);
285: l_ret := false;
286: end if;
287: close csr_check_action;
288: hr_utility.set_location('Leaving: '||l_proc,999);
289: return l_ret;
290: END;
291: --
292: --

Line 427: hr_utility.set_location('Entering: '||l_proc,1);

423: and act.action_status = 'C'
424: and act.assignment_id = p_assignment_id;
425:
426: BEGIN
427: hr_utility.set_location('Entering: '||l_proc,1);
428: open csr_parameter_info;
429: fetch csr_parameter_info into l_payroll_id,
430: l_tax_ref,
431: l_effective_date,

Line 435: hr_utility.set_location('Before CSR_ASG cursor effective_date '|| to_char(l_effective_date),10);

431: l_effective_date,
432: l_business_group_id;
433: close csr_parameter_info;
434:
435: hr_utility.set_location('Before CSR_ASG cursor effective_date '|| to_char(l_effective_date),10);
436: for asg_rec in csr_asg loop
437: hr_utility.set_location('Assignment ID :' || asg_rec.assignment_id,15);
438: l_arch := false;
439: l_p46_5_def := 0;

Line 437: hr_utility.set_location('Assignment ID :' || asg_rec.assignment_id,15);

433: close csr_parameter_info;
434:
435: hr_utility.set_location('Before CSR_ASG cursor effective_date '|| to_char(l_effective_date),10);
436: for asg_rec in csr_asg loop
437: hr_utility.set_location('Assignment ID :' || asg_rec.assignment_id,15);
438: l_arch := false;
439: l_p46_5_def := 0;
440: open csr_aei_flag(asg_rec.assignment_id);
441: fetch csr_aei_flag into l_send_flag, l_static_flag;

Line 445: hr_utility.set_location('\n l_send_flag = ' || l_send_flag || ' l_static_flag = ' || l_static_flag,20);

441: fetch csr_aei_flag into l_send_flag, l_static_flag;
442:
443: -- only create asg action if rows is found
444: if csr_aei_flag%FOUND then
445: hr_utility.set_location('\n l_send_flag = ' || l_send_flag || ' l_static_flag = ' || l_static_flag,20);
446:
447: if p_rep_type = 'P46_5' then
448: l_p45_not_run := check_action('P45%3', asg_rec.assignment_id);
449: if l_p45_not_run then

Line 621: hr_utility.set_location('Creating assignment action for ' || asg_rec.assignment_id,30);

617: end if;
618: /*Changes for P46_Ver6 eText End*/
619:
620: if l_arch then
621: hr_utility.set_location('Creating assignment action for ' || asg_rec.assignment_id,30);
622: select pay_assignment_actions_s.nextval
623: into l_ass_act_id
624: from dual;
625: --

Line 654: hr_utility.set_location('Leaving: '||l_proc,999);

650: close csr_aei_flag;
651:
652: end loop;
653:
654: hr_utility.set_location('Leaving: '||l_proc,999);
655: END internal_action_creation;
656: --
657: --
658: --

Line 695: hr_utility.set_location('Entering: '||l_proc,1);

691:
692:
693: l_45_46_pennot_rec csr_45_46_pennot_details%rowtype;
694: BEGIN
695: hr_utility.set_location('Entering: '||l_proc,1);
696: l_arch := true;
697:
698: fnd_file.put_line(fnd_file.LOG,'Entering: '||l_proc);
699: open csr_45_46_pennot_details;

Line 709: hr_utility.set_location('Tax Code error',20);

705: --l_arch := false;
706: pay_core_utils.push_message(801, 'PAY_78034_VALUE_EXCEEDS_MAX', 'F');
707: pay_core_utils.push_token('ITEM_NAME', 'Tax Code');
708: pay_core_utils.push_token('MAX_VALUE', '6 characters');
709: hr_utility.set_location('Tax Code error',20);
710: fnd_file.put_line(fnd_file.LOG,'l_arch3: ');
711:
712: end if;
713: if length(ltrim(l_45_46_pennot_rec.prev_tax_code,'S')) > 6 then

Line 718: hr_utility.set_location('Prev Tax Code',40);

714: --l_arch := false;
715: pay_core_utils.push_message(801, 'PAY_78034_VALUE_EXCEEDS_MAX', 'F');
716: pay_core_utils.push_token('ITEM_NAME', 'Previous Tax Code');
717: pay_core_utils.push_token('MAX_VALUE', '6 characters');
718: hr_utility.set_location('Prev Tax Code',40);
719: fnd_file.put_line(fnd_file.LOG,'l_arch4: ');
720: end if;
721:
722: if not validate_data(substr(ltrim(substr(l_45_46_pennot_rec.prev_emp_paye_ref,4,8),'/'),1,7),'Previous Tax Reference','FULL_EDI') then

Line 724: hr_utility.set_location('Previous Tax Reference error',50);

720: end if;
721:
722: if not validate_data(substr(ltrim(substr(l_45_46_pennot_rec.prev_emp_paye_ref,4,8),'/'),1,7),'Previous Tax Reference','FULL_EDI') then
723: --l_arch := false;
724: hr_utility.set_location('Previous Tax Reference error',50);
725: fnd_file.put_line(fnd_file.LOG,'l_arch5: ');
726: end if;
727:
728: if not validate_data(substr(l_45_46_pennot_rec.prev_emp_paye_ref,1,3),'Previous Tax District','FULL_EDI') then

Line 730: hr_utility.set_location('Previous Tax District error',60);

726: end if;
727:
728: if not validate_data(substr(l_45_46_pennot_rec.prev_emp_paye_ref,1,3),'Previous Tax District','FULL_EDI') then
729: --l_arch := false;
730: hr_utility.set_location('Previous Tax District error',60);
731: fnd_file.put_line(fnd_file.LOG,'l_arch6: ');
732: end if;
733:
734: if not validate_data(p_tax_rec.prev_paid,'Previous Pay','FULL_EDI') then

Line 736: hr_utility.set_location('Prev Pay Valiation',70);

732: end if;
733:
734: if not validate_data(p_tax_rec.prev_paid,'Previous Pay','FULL_EDI') then
735: -- l_arch := false;
736: hr_utility.set_location('Prev Pay Valiation',70);
737: fnd_file.put_line(fnd_file.LOG,'l_arch7: ');
738: end if;
739:
740: if not validate_data(p_tax_rec.prev_tax,'Previous Tax','FULL_EDI') then

Line 742: hr_utility.set_location('Prev Tax Validation',80);

738: end if;
739:
740: if not validate_data(p_tax_rec.prev_tax,'Previous Tax','FULL_EDI') then
741: --l_arch := false;
742: hr_utility.set_location('Prev Tax Validation',80);
743: fnd_file.put_line(fnd_file.LOG,'l_arch8: ');
744: end if;
745:
746: if not validate_data(l_45_46_pennot_rec.prev_last_pay_period,'Previous Last Payment Period','FULL_EDI') then

Line 748: hr_utility.set_location('Previous period error',90);

744: end if;
745:
746: if not validate_data(l_45_46_pennot_rec.prev_last_pay_period,'Previous Last Payment Period','FULL_EDI') then
747: --l_arch := false;
748: hr_utility.set_location('Previous period error',90);
749: fnd_file.put_line(fnd_file.LOG,'l_arch9: ');
750: end if;
751:
752: l_ovn := l_45_46_pennot_rec.object_version_number;

Line 754: hr_utility.set_location('Clear Flag',20);

750: end if;
751:
752: l_ovn := l_45_46_pennot_rec.object_version_number;
753: if l_arch then
754: hr_utility.set_location('Clear Flag',20);
755: hr_assignment_extra_info_api.update_assignment_extra_info
756: (p_validate => false,
757: p_object_version_number => l_ovn,
758: p_assignment_extra_info_id => l_45_46_pennot_rec.assignment_extra_info_id,

Line 782: hr_utility.set_location('Leaving: '||l_proc,999);

778: p_45_46_pennot_rec.act_info10 := l_45_46_pennot_rec.recently_bereaved;
779: p_45_46_pennot_rec.act_info11 := p_tax_rec.prev_paid;
780: p_45_46_pennot_rec.act_info12 := p_tax_rec.prev_tax;
781:
782: hr_utility.set_location('Leaving: '||l_proc,999);
783: return l_arch;
784:
785:
786:

Line 902: hr_utility.set_location('Entering: '||l_proc,1);

898: and e1.element_link_id = link1.element_link_id);
899: */
900:
901: BEGIN
902: hr_utility.set_location('Entering: '||l_proc,1);
903:
904:
905:
906: open csr_element_id('PAYE');

Line 964: hr_utility.trace('Fetching run result 3');

960: close csr_run_result;
961:
962: -- 3. Still not found, fetch the value from the PAYE
963: if p_tax_rec.tax_code is null then
964: hr_utility.trace('Fetching run result 3');
965: open csr_paye_details;
966: fetch csr_paye_details into p_tax_rec.tax_code,
967: p_tax_rec.tax_basis,
968: p_tax_rec.prev_paid,

Line 974: hr_utility.set_location('Leaving: '||l_proc,999);

970: close csr_paye_details;
971: end if;
972: end if;
973: */
974: hr_utility.set_location('Leaving: '||l_proc,999);
975: END fetch_tax_rec;
976: --
977: --
978: FUNCTION fetch_address_rec(p_person_id IN NUMBER,

Line 1001: hr_utility.set_location('Entering: '||l_proc,1);

997: and p_effective_date between nvl(addr.date_from,fnd_date.canonical_to_date('0001/01/01 00:00:00'))
998: and nvl(addr.date_to, fnd_date.canonical_to_date('4712/12/31 00:00:00'));
999: l_addr_rec csr_address%rowtype;
1000: BEGIN
1001: hr_utility.set_location('Entering: '||l_proc,1);
1002: l_arch := true;
1003:
1004: open csr_address;
1005: fetch csr_address into l_addr_rec;

Line 1020: hr_utility.set_location('Address missing',10);

1016: if l_addr_rec.addr1 is null then
1017: pay_core_utils.push_message(800, 'HR_78088_MISSING_DATA_ERR', 'F');
1018: pay_core_utils.push_token('TOKEN', 'Address');
1019: l_arch := false;
1020: hr_utility.set_location('Address missing',10);
1021: end if;
1022:
1023: if not validate_data(l_temp,'Address','P14_FULL_EDI') then
1024: l_arch := false;

Line 1025: hr_utility.set_location('Address Validation',20);

1021: end if;
1022:
1023: if not validate_data(l_temp,'Address','P14_FULL_EDI') then
1024: l_arch := false;
1025: hr_utility.set_location('Address Validation',20);
1026: end if;
1027:
1028: if not validate_data(l_addr_rec.post_code,'Post Code','FULL_EDI') then
1029: l_arch := false;

Line 1030: hr_utility.set_location('Post Code error',20);

1026: end if;
1027:
1028: if not validate_data(l_addr_rec.post_code,'Post Code','FULL_EDI') then
1029: l_arch := false;
1030: hr_utility.set_location('Post Code error',20);
1031: end if;
1032: END IF;
1033:
1034: p_addr_rec.assignment_id := p_assignment_id;

Line 1045: hr_utility.set_location('Leaving: '||l_proc,999);

1041: p_addr_rec.act_info9 := l_addr_rec.county;
1042: p_addr_rec.act_info12 := l_addr_rec.post_code;
1043: p_addr_rec.act_info13 := l_addr_rec.country;
1044:
1045: hr_utility.set_location('Leaving: '||l_proc,999);
1046: return l_arch;
1047: END fetch_address_rec;
1048: --
1049: --

Line 1125: hr_utility.set_location('Entering: '||l_proc,1);

1121: and p_effective_date between paa.effective_start_date and paa.effective_end_date;
1122:
1123: l_person_rec csr_person_details%rowtype;
1124: BEGIN
1125: hr_utility.set_location('Entering: '||l_proc,1);
1126: l_arch := true;
1127:
1128: open csr_person_details;
1129: fetch csr_person_details into l_person_rec;

Line 1143: hr_utility.set_location('First Name error',10);

1139: IF g_archive_type <> 'P46_VER6ET' AND g_archive_type <> 'P46EXP_VER6ET' THEN
1140:
1141: if not validate_data(l_person_rec.first_name,'First Name','EDI_SURNAME') then
1142: l_arch := false;
1143: hr_utility.set_location('First Name error',10);
1144: end if;
1145:
1146: if not validate_data(l_person_rec.last_name,'Last Name','EDI_SURNAME') then
1147: l_arch := false;

Line 1148: hr_utility.set_location('Last Name error',20);

1144: end if;
1145:
1146: if not validate_data(l_person_rec.last_name,'Last Name','EDI_SURNAME') then
1147: l_arch := false;
1148: hr_utility.set_location('Last Name error',20);
1149: end if;
1150:
1151: if not validate_data(l_person_rec.assignment_number,'Assignment Number','FULL_EDI') then
1152: l_arch := false;

Line 1153: hr_utility.set_location('Assignment Number error',30);

1149: end if;
1150:
1151: if not validate_data(l_person_rec.assignment_number,'Assignment Number','FULL_EDI') then
1152: l_arch := false;
1153: hr_utility.set_location('Assignment Number error',30);
1154: end if;
1155:
1156: if not validate_data(l_person_rec.sex,'Sex','FULL_EDI') then
1157: l_arch := false;

Line 1158: hr_utility.set_location('Sex error',40);

1154: end if;
1155:
1156: if not validate_data(l_person_rec.sex,'Sex','FULL_EDI') then
1157: l_arch := false;
1158: hr_utility.set_location('Sex error',40);
1159: end if;
1160:
1161: if not validate_data(l_job,'Job Title','P14_FULL_EDI') then -- Bug 8315067
1162: l_arch := false;

Line 1163: hr_utility.set_location('Job Title error',50);

1159: end if;
1160:
1161: if not validate_data(l_job,'Job Title','P14_FULL_EDI') then -- Bug 8315067
1162: l_arch := false;
1163: hr_utility.set_location('Job Title error',50);
1164: end if;
1165:
1166: if l_person_rec.national_identifier is not null and
1167: hr_gb_utility.ni_validate(l_person_rec.national_identifier,sysdate) <> 0 then

Line 1172: hr_utility.set_location('NI error',60);

1168: pay_core_utils.push_message(800, 'HR_78057_GB_MAGTAPE_VAILDATION', 'F');
1169: pay_core_utils.push_token('INPUT_NAME', 'NI Number');
1170: pay_core_utils.push_token('INPUT_VALUE', l_person_rec.national_identifier);
1171: l_arch := false;
1172: hr_utility.set_location('NI error',60);
1173: end if;
1174: END IF;
1175:
1176: /** -- NO Tax code validation yet as it is different between P45(3),P46 and P46P --**

Line 1183: hr_utility.set_location('Tax Code error',30);

1179: pay_core_utils.push_message(800, 'HR_78057_GB_MAGTAPE_VAILDATION', 'F');
1180: pay_core_utils.push_token('INPUT_NAME', 'Tax Code');
1181: pay_core_utils.push_token('INPUT_VALUE', p_tax_rec.tax_code);
1182: l_arch := false;
1183: hr_utility.set_location('Tax Code error',30);
1184: end if;
1185: */
1186: p_person_rec.person_id := l_person_rec.person_id;
1187: p_person_rec.assignment_id := l_person_rec.assignment_id;

Line 1202: hr_utility.set_location('Leaving: '||l_proc,999);

1198: p_person_rec.act_info17 := l_person_rec.sex;
1199: p_person_rec.act_info18 := l_job;
1200: p_person_rec.act_info21 := p_tax_rec.tax_code;
1201: p_person_rec.act_info22 := p_tax_rec.tax_basis;
1202: hr_utility.set_location('Leaving: '||l_proc,999);
1203: return l_arch;
1204: END fetch_person_rec;
1205: --
1206: --

Line 1261: hr_utility.set_location('Entering: '||l_proc,1);

1257:
1258: l_p45_3_rec csr_p45_3_details%rowtype;
1259: l_student_rec csr_student_loan%rowtype;
1260: BEGIN
1261: hr_utility.set_location('Entering: '||l_proc,1);
1262: l_arch := true;
1263:
1264: open csr_p45_3_details;
1265: fetch csr_p45_3_details into l_p45_3_rec;

Line 1276: hr_utility.set_location('Date Left null',30);

1272: if l_p45_3_rec.date_left is null then
1273: pay_core_utils.push_message(800, 'HR_78088_MISSING_DATA_ERR', 'F');
1274: pay_core_utils.push_token('TOKEN', 'Date Left Previous Employer');
1275: l_arch := false;
1276: hr_utility.set_location('Date Left null',30);
1277: end if;
1278:
1279: if to_number(p_tax_rec.prev_paid) > 999999.99 then
1280: l_arch := false;

Line 1284: hr_utility.set_location('Prev Paid > 999999.99',10);

1280: l_arch := false;
1281: pay_core_utils.push_message(801, 'PAY_78034_VALUE_EXCEEDS_MAX', 'F');
1282: pay_core_utils.push_token('ITEM_NAME', 'Previous Pay');
1283: pay_core_utils.push_token('MAX_VALUE', '999999.99');
1284: hr_utility.set_location('Prev Paid > 999999.99',10);
1285: end if;
1286:
1287: if to_number(p_tax_rec.prev_tax) > 999999.99 then
1288: l_arch := false;

Line 1292: hr_utility.set_location('Prev Tax > 999999.99',20);

1288: l_arch := false;
1289: pay_core_utils.push_message(801, 'PAY_78034_VALUE_EXCEEDS_MAX', 'F');
1290: pay_core_utils.push_token('ITEM_NAME', 'Previous Tax');
1291: pay_core_utils.push_token('MAX_VALUE', '999999.99');
1292: hr_utility.set_location('Prev Tax > 999999.99',20);
1293: end if;
1294:
1295: /** -- Validate using the orignal, will use new one when requirement comes out --
1296: l_temp := hr_gb_utility.tax_code_validate(l_p45_3_rec.prev_tax_code,sysdate,p_person_rec.assignment_id);

Line 1302: hr_utility.set_location('Tax Code error',30);

1298: pay_core_utils.push_message(800, 'HR_78057_GB_MAGTAPE_VAILDATION', 'F');
1299: pay_core_utils.push_token('INPUT_NAME', 'Previous Tax Code');
1300: pay_core_utils.push_token('INPUT_VALUE', p_tax_rec.tax_code);
1301: l_arch := false;
1302: hr_utility.set_location('Tax Code error',30);
1303: end if;
1304: */
1305: if length(ltrim(p_tax_rec.tax_code,'S')) > 6 then
1306: l_arch := false;

Line 1310: hr_utility.set_location('Tax Code error',30);

1306: l_arch := false;
1307: pay_core_utils.push_message(801, 'PAY_78034_VALUE_EXCEEDS_MAX', 'F');
1308: pay_core_utils.push_token('ITEM_NAME', 'Tax Code');
1309: pay_core_utils.push_token('MAX_VALUE', '6 characters');
1310: hr_utility.set_location('Tax Code error',30);
1311: end if;
1312:
1313: if length(ltrim(l_p45_3_rec.prev_tax_code,'S')) > 6 then
1314: l_arch := false;

Line 1318: hr_utility.set_location('Prev Tax Code',40);

1314: l_arch := false;
1315: pay_core_utils.push_message(801, 'PAY_78034_VALUE_EXCEEDS_MAX', 'F');
1316: pay_core_utils.push_token('ITEM_NAME', 'Previous Tax Code');
1317: pay_core_utils.push_token('MAX_VALUE', '6 characters');
1318: hr_utility.set_location('Prev Tax Code',40);
1319: end if;
1320:
1321: if not validate_data(substr(ltrim(substr(l_p45_3_rec.prev_tax_district,4,8),'/'),1,7),'Previous Tax Reference','FULL_EDI') then
1322: l_arch := false;

Line 1323: hr_utility.set_location('Previous Tax Reference error',50);

1319: end if;
1320:
1321: if not validate_data(substr(ltrim(substr(l_p45_3_rec.prev_tax_district,4,8),'/'),1,7),'Previous Tax Reference','FULL_EDI') then
1322: l_arch := false;
1323: hr_utility.set_location('Previous Tax Reference error',50);
1324: end if;
1325:
1326: if not validate_data(substr(l_p45_3_rec.prev_tax_district,1,3),'Previous Tax District','FULL_EDI') then
1327: l_arch := false;

Line 1328: hr_utility.set_location('Previous Tax District error',60);

1324: end if;
1325:
1326: if not validate_data(substr(l_p45_3_rec.prev_tax_district,1,3),'Previous Tax District','FULL_EDI') then
1327: l_arch := false;
1328: hr_utility.set_location('Previous Tax District error',60);
1329: end if;
1330:
1331: if not validate_data(p_tax_rec.prev_paid,'Previous Pay','FULL_EDI') then
1332: l_arch := false;

Line 1333: hr_utility.set_location('Prev Pay Valiation',70);

1329: end if;
1330:
1331: if not validate_data(p_tax_rec.prev_paid,'Previous Pay','FULL_EDI') then
1332: l_arch := false;
1333: hr_utility.set_location('Prev Pay Valiation',70);
1334: end if;
1335:
1336: if not validate_data(p_tax_rec.prev_tax,'Previous Tax','FULL_EDI') then
1337: l_arch := false;

Line 1338: hr_utility.set_location('Prev Tax Validation',80);

1334: end if;
1335:
1336: if not validate_data(p_tax_rec.prev_tax,'Previous Tax','FULL_EDI') then
1337: l_arch := false;
1338: hr_utility.set_location('Prev Tax Validation',80);
1339: end if;
1340:
1341: if not validate_data(l_p45_3_rec.prev_period,'Previous Last Payment Period','FULL_EDI') then
1342: l_arch := false;

Line 1343: hr_utility.set_location('Previous period error',90);

1339: end if;
1340:
1341: if not validate_data(l_p45_3_rec.prev_period,'Previous Last Payment Period','FULL_EDI') then
1342: l_arch := false;
1343: hr_utility.set_location('Previous period error',90);
1344: end if;
1345:
1346: l_ovn := l_p45_3_rec.object_version_number;
1347: if l_arch then

Line 1348: hr_utility.set_location('Clear Flag',100);

1344: end if;
1345:
1346: l_ovn := l_p45_3_rec.object_version_number;
1347: if l_arch then
1348: hr_utility.set_location('Clear Flag',100);
1349: hr_assignment_extra_info_api.update_assignment_extra_info
1350: (p_validate => false,
1351: p_object_version_number => l_ovn,
1352: p_assignment_extra_info_id => l_p45_3_rec.assignment_extra_info_id,

Line 1380: hr_utility.set_location('Leaving: '||l_proc,999);

1376: /*changes for P45PT_3 end*/
1377: -- Bug 6994632 passing Prev Tax Pay Notified value to archive function
1378: p_p45_3_rec.act_info16:= l_p45_3_rec.prev_tax_pay_notified;
1379:
1380: hr_utility.set_location('Leaving: '||l_proc,999);
1381: return l_arch;
1382: END fetch_p45_3_rec;
1383: --
1384: --

Line 1408: hr_utility.set_location('Entering: '||l_proc,1);

1404: and aei.information_type = 'GB_P46';
1405:
1406: l_p46_rec csr_p46_details%rowtype;
1407: BEGIN
1408: hr_utility.set_location('Entering: '||l_proc,1);
1409: l_arch := true;
1410:
1411: open csr_p46_details;
1412: fetch csr_p46_details into l_p46_rec;

Line 1417: hr_utility.set_location('P46 Statement validation',10);

1413: close csr_p46_details;
1414:
1415: if not validate_data(l_p46_rec.p46_statement,'P46 Statement','FULL_EDI') then
1416: l_arch := false;
1417: hr_utility.set_location('P46 Statement validation',10);
1418: end if;
1419:
1420: l_temp := hr_gb_utility.tax_code_validate(p_tax_rec.tax_code,sysdate,p_person_rec.assignment_id);
1421: if l_temp <> ' ' then

Line 1426: hr_utility.set_location('Tax Code error',20);

1422: pay_core_utils.push_message(800, 'HR_78057_GB_MAGTAPE_VAILDATION', 'F');
1423: pay_core_utils.push_token('INPUT_NAME', 'Tax Code');
1424: pay_core_utils.push_token('INPUT_VALUE', p_tax_rec.tax_code);
1425: l_arch := false;
1426: hr_utility.set_location('Tax Code error',20);
1427: end if;
1428:
1429: l_ovn := l_p46_rec.object_version_number;
1430: if l_arch then

Line 1431: hr_utility.set_location('Clear Flag',30);

1427: end if;
1428:
1429: l_ovn := l_p46_rec.object_version_number;
1430: if l_arch then
1431: hr_utility.set_location('Clear Flag',30);
1432: hr_assignment_extra_info_api.update_assignment_extra_info
1433: (p_validate => false,
1434: p_object_version_number => l_ovn,
1435: p_assignment_extra_info_id => l_p46_rec.assignment_extra_info_id,

Line 1447: hr_utility.set_location('Leaving: '||l_proc,999);

1443: p_p46_rec.act_info1 := l_ovn;
1444: p_p46_rec.act_info2 := l_p46_rec.p46_statement;
1445: p_p46_rec.act_info3 := l_p46_rec.student_loan;
1446:
1447: hr_utility.set_location('Leaving: '||l_proc,999);
1448: return l_arch;
1449: END fetch_p46_rec;
1450: --
1451:

Line 1479: hr_utility.set_location('Entering: '||l_proc,1);

1475: and aei.information_type = 'GB_P46EXP';
1476:
1477: l_p46_rec csr_p46_details%rowtype;
1478: BEGIN
1479: hr_utility.set_location('Entering: '||l_proc,1);
1480: l_arch := true;
1481:
1482: open csr_p46_details;
1483: fetch csr_p46_details into l_p46_rec;

Line 1488: hr_utility.set_location('P46(Expat) Statement validation',10);

1484: close csr_p46_details;
1485:
1486: if not validate_data(l_p46_rec.p46_statement,'P46(Expat) Statement','FULL_EDI') then
1487: l_arch := false;
1488: hr_utility.set_location('P46(Expat) Statement validation',10);
1489: end if;
1490:
1491: l_temp := hr_gb_utility.tax_code_validate(p_tax_rec.tax_code,sysdate,p_person_rec.assignment_id);
1492: /* if l_temp <> ' ' then

Line 1497: hr_utility.set_location('Tax Code error',20);

1493: pay_core_utils.push_message(800, 'HR_78057_GB_MAGTAPE_VAILDATION', 'F');
1494: pay_core_utils.push_token('INPUT_NAME', 'Tax Code');
1495: pay_core_utils.push_token('INPUT_VALUE', p_tax_rec.tax_code);
1496: l_arch := false;
1497: hr_utility.set_location('Tax Code error',20);
1498: end if;*/
1499:
1500: l_ovn := l_p46_rec.object_version_number;
1501: if l_arch then

Line 1502: hr_utility.set_location('Clear Flag',30);

1498: end if;*/
1499:
1500: l_ovn := l_p46_rec.object_version_number;
1501: if l_arch then
1502: hr_utility.set_location('Clear Flag',30);
1503: hr_assignment_extra_info_api.update_assignment_extra_info
1504: (p_validate => false,
1505: p_object_version_number => l_ovn,
1506: p_assignment_extra_info_id => l_p46_rec.assignment_extra_info_id,

Line 1521: hr_utility.set_location('Leaving: '||l_proc,999);

1517: p_p46_rec.act_info4 := l_p46_rec.eea_cw_citizen;
1518: p_p46_rec.act_info5 := l_p46_rec.date_started_uk;
1519: p_p46_rec.act_info6 := l_p46_rec.em6_scheme;
1520:
1521: hr_utility.set_location('Leaving: '||l_proc,999);
1522: return l_arch;
1523: END fetch_p46exp_rec;
1524:
1525: /*Changes for P46EXP_Ver6 End*/

Line 1537: hr_utility.set_location(' Entering: populate_run_msg',111);

1533: )
1534: IS
1535: PRAGMA AUTONOMOUS_TRANSACTION;
1536: BEGIN
1537: hr_utility.set_location(' Entering: populate_run_msg',111);
1538:
1539: INSERT INTO pay_message_lines(line_sequence,
1540: payroll_id,
1541: message_level,

Line 1554: hr_utility.set_location(' Leaving: populate_run_msg',999);

1550: ,'A'
1551: ,substr(p_message_text,1,240)
1552: );
1553:
1554: hr_utility.set_location(' Leaving: populate_run_msg',999);
1555: COMMIT;
1556: EXCEPTION
1557: WHEN OTHERS THEN
1558: hr_utility.trace('Error occured in populate_run_msg');

Line 1558: hr_utility.trace('Error occured in populate_run_msg');

1554: hr_utility.set_location(' Leaving: populate_run_msg',999);
1555: COMMIT;
1556: EXCEPTION
1557: WHEN OTHERS THEN
1558: hr_utility.trace('Error occured in populate_run_msg');
1559: RAISE;
1560: END populate_run_msg;
1561:
1562:

Line 1595: hr_utility.set_location('Etext41 l_sex'||l_sex,111);

1591: l_p46_expat_eea_citizen per_assignment_extra_info.aei_information5%TYPE;
1592:
1593: BEGIN
1594: l_sex := p_tab_rec_data(0).act_info17;
1595: hr_utility.set_location('Etext41 l_sex'||l_sex,111);
1596: l_assignment_number := p_tab_rec_data(0).act_info11;
1597: hr_utility.set_location('Etext41 l_assignment_number'||l_assignment_number,111);
1598:
1599: l_date_of_birth := p_tab_rec_data(0).act_info15;

Line 1597: hr_utility.set_location('Etext41 l_assignment_number'||l_assignment_number,111);

1593: BEGIN
1594: l_sex := p_tab_rec_data(0).act_info17;
1595: hr_utility.set_location('Etext41 l_sex'||l_sex,111);
1596: l_assignment_number := p_tab_rec_data(0).act_info11;
1597: hr_utility.set_location('Etext41 l_assignment_number'||l_assignment_number,111);
1598:
1599: l_date_of_birth := p_tab_rec_data(0).act_info15;
1600: hr_utility.set_location('Etext41 l_date_of_birth'||l_date_of_birth,111);
1601: l_tax_code_in_use := p_tab_rec_data(0).act_info21;

Line 1600: hr_utility.set_location('Etext41 l_date_of_birth'||l_date_of_birth,111);

1596: l_assignment_number := p_tab_rec_data(0).act_info11;
1597: hr_utility.set_location('Etext41 l_assignment_number'||l_assignment_number,111);
1598:
1599: l_date_of_birth := p_tab_rec_data(0).act_info15;
1600: hr_utility.set_location('Etext41 l_date_of_birth'||l_date_of_birth,111);
1601: l_tax_code_in_use := p_tab_rec_data(0).act_info21;
1602: l_tax_basis_in_use := p_tab_rec_data(0).act_info22;
1603: hr_utility.set_location('Etext42'||l_tax_basis_in_use,111);
1604:

Line 1603: hr_utility.set_location('Etext42'||l_tax_basis_in_use,111);

1599: l_date_of_birth := p_tab_rec_data(0).act_info15;
1600: hr_utility.set_location('Etext41 l_date_of_birth'||l_date_of_birth,111);
1601: l_tax_code_in_use := p_tab_rec_data(0).act_info21;
1602: l_tax_basis_in_use := p_tab_rec_data(0).act_info22;
1603: hr_utility.set_location('Etext42'||l_tax_basis_in_use,111);
1604:
1605: l_p46_expat_eea_citizen := p_tab_rec_data(2).act_info4;
1606: l_p46_expat_start_empl_date := p_tab_rec_data(2).act_info5;
1607: l_p46_expat_statement := p_tab_rec_data(2).act_info2;

Line 1609: hr_utility.set_location('Etext43'||l_p46_expat_statement,111);

1605: l_p46_expat_eea_citizen := p_tab_rec_data(2).act_info4;
1606: l_p46_expat_start_empl_date := p_tab_rec_data(2).act_info5;
1607: l_p46_expat_statement := p_tab_rec_data(2).act_info2;
1608:
1609: hr_utility.set_location('Etext43'||l_p46_expat_statement,111);
1610:
1611: IF l_p46_expat_eea_citizen = 'Y' AND (l_tax_code_in_use = ' ' OR l_tax_code_in_use IS NULL) THEN
1612: populate_run_msg(p_assactid,'You have not entered a tax code for the EEA Citizen ' || l_assignment_number || '. Ensure you enter Emergency Tax Code on a Cumulative Basis.');
1613: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : You have not entered a tax code for the EEA Citizen ' || l_assignment_number || '. Ensure you enter Emergency Tax Code on a Cumulative Basis.');

Line 1653: hr_utility.set_location('Etext43 l_date_of_birth'||l_date_of_birth,111);

1649: edi_validation_fail := 'Y';
1650: END IF;
1651:
1652: IF l_date_of_birth = ' ' OR l_date_of_birth IS NULL THEN
1653: hr_utility.set_location('Etext43 l_date_of_birth'||l_date_of_birth,111);
1654: populate_run_msg(p_assactid,' The Date of Birth of the assignment ' || l_assignment_number || ' is missing.');
1655: fnd_file.put_line (fnd_file.LOG,' : The Date of Birth of the assignment '|| l_assignment_number || ' is missing.');
1656: edi_validation_fail := 'Y';
1657: END IF;

Line 1673: hr_utility.trace('l_eff_date = '|| l_eff_date);

1669:
1670: --Modifications for the bug fix 10409668 starts here
1671: --l_eff_date := to_date(to_char(to_date(l_eff_date,'RRRR/MM/DD HH24:MI:SS'),'RRRR/MM/DD'),'RRRR/MM/DD');
1672: l_eff_date := trunc (l_eff_date);
1673: hr_utility.trace('l_eff_date = '|| l_eff_date);
1674: --Modifications for the bug fix 10409668 ends here
1675:
1676: l_msg_value := pay_gb_eoy_magtape.validate_tax_code_yrfil(p_assactid,l_tax_code_in_use,l_eff_date);
1677:

Line 1691: hr_utility.set_location('Etext44 Leaving',111);

1687: populate_run_msg(p_assactid, 'The Tax Basis in use is not present for Tax code in use, for assignment ' || l_assignment_number);
1688: fnd_file.put_line (fnd_file.LOG,' : The Tax Basis in use is not present for Tax code in use, for assignment ' || l_assignment_number);
1689: edi_validation_fail := 'Y';
1690: END IF;
1691: hr_utility.set_location('Etext44 Leaving',111);
1692:
1693: END p46exp_asg_etext_validations;
1694:
1695: --For bugs 9255173 and 9255183

Line 1759: hr_utility.set_location('Etext50',111);

1755:
1756: /* Modifications end here */
1757:
1758: BEGIN
1759: hr_utility.set_location('Etext50',111);
1760:
1761: l_count_char_errors := 0;
1762: l_count_missing_val := 0;
1763:

Line 2025: hr_utility.set_location('Etext50 Leaving',111);

2021: fnd_file.put_line (fnd_file.LOG,' : The Tax Code ' || l_tax_code || ' of the assignment ' || l_assignment_number || ' has invalid character(s).');
2022: edi_validation_fail := 'Y';
2023: END IF;
2024:
2025: hr_utility.set_location('Etext50 Leaving',111);
2026: END movded6_asg_etext_validations;
2027:
2028:
2029: FUNCTION fetch_p46_5_rec(p_effective_date IN DATE,

Line 2071: hr_utility.set_location('Entering: '||l_proc,1);

2067:
2068:
2069: l_p46_rec csr_p46_details%rowtype;
2070: BEGIN
2071: hr_utility.set_location('Entering: '||l_proc,1);
2072: fnd_file.put_line(fnd_file.LOG,'Entering: '||l_proc);
2073: l_arch := true;
2074:
2075: open csr_p46_details;

Line 2099: hr_utility.set_location('P46 Statement validation',10);

2095: end if;
2096:
2097: /* if not validate_data(l_p46_rec.p46_statement,'P46 Statement','FULL_EDI') then
2098: l_arch := false;
2099: hr_utility.set_location('P46 Statement validation',10);
2100: end if;
2101:
2102: l_temp := hr_gb_utility.tax_code_validate(p_tax_rec.tax_code,sysdate,p_person_rec.assignment_id);
2103: if l_temp <> ' ' then

Line 2108: hr_utility.set_location('Tax Code error',20);

2104: pay_core_utils.push_message(800, 'HR_78057_GB_MAGTAPE_VAILDATION', 'F');
2105: pay_core_utils.push_token('INPUT_NAME', 'Tax Code');
2106: pay_core_utils.push_token('INPUT_VALUE', p_tax_rec.tax_code);
2107: l_arch := false;
2108: hr_utility.set_location('Tax Code error',20);
2109: end if;*/
2110:
2111: l_ovn := l_p46_rec.object_version_number;
2112: if l_arch then

Line 2113: hr_utility.set_location('Clear Flag',30);

2109: end if;*/
2110:
2111: l_ovn := l_p46_rec.object_version_number;
2112: if l_arch then
2113: hr_utility.set_location('Clear Flag',30);
2114: if l_def_archive = 'N' then
2115: hr_assignment_extra_info_api.update_assignment_extra_info
2116: (p_validate => false,
2117: p_object_version_number => l_ovn,

Line 2139: hr_utility.set_location('Leaving: '||l_proc,999);

2135: p_p46_rec.act_info1 := l_ovn;
2136: p_p46_rec.act_info2 := l_p46_rec.p46_statement;
2137: p_p46_rec.act_info3 := l_p46_rec.student_loan;
2138: p_p46_rec.act_info4 := l_def_archive;
2139: hr_utility.set_location('Leaving: '||l_proc,999);
2140: fnd_file.put_line(fnd_file.LOG,'Leaving: '||l_proc);
2141: return l_arch;
2142: END fetch_p46_5_rec;
2143: --

Line 2166: hr_utility.set_location('Entering: '||l_proc,1);

2162: and aei.information_type = 'GB_P46PENNOT';
2163:
2164: l_p46p_rec csr_p46p_details%rowtype;
2165: BEGIN
2166: hr_utility.set_location('Entering: '||l_proc,1);
2167: l_arch := true;
2168:
2169: open csr_p46p_details;
2170: fetch csr_p46p_details into l_p46p_rec;

Line 2175: hr_utility.set_location('Annaul Pension',10);

2171: close csr_p46p_details;
2172:
2173: if not validate_data(l_p46p_rec.annual_pension,'Annual Pension','FULL_EDI') then
2174: l_arch := false;
2175: hr_utility.set_location('Annaul Pension',10);
2176: end if;
2177:
2178: if length(ltrim(p_tax_rec.tax_code,'S')) > 6 then
2179: l_arch := false;

Line 2183: hr_utility.set_location('Tax Code error',20);

2179: l_arch := false;
2180: pay_core_utils.push_message(801, 'PAY_78034_VALUE_EXCEEDS_MAX', 'F');
2181: pay_core_utils.push_token('ITEM_NAME', 'Tax Code');
2182: pay_core_utils.push_token('MAX_VALUE', '6 characters');
2183: hr_utility.set_location('Tax Code error',20);
2184: end if;
2185:
2186: l_ovn := l_p46p_rec.object_version_number;
2187: if l_arch then

Line 2188: hr_utility.set_location('Clear Flag',20);

2184: end if;
2185:
2186: l_ovn := l_p46p_rec.object_version_number;
2187: if l_arch then
2188: hr_utility.set_location('Clear Flag',20);
2189: hr_assignment_extra_info_api.update_assignment_extra_info
2190: (p_validate => false,
2191: p_object_version_number => l_ovn,
2192: p_assignment_extra_info_id => l_p46p_rec.assignment_extra_info_id,

Line 2204: hr_utility.set_location('Leaving: '||l_proc,999);

2200: p_p46p_rec.act_info1 := l_ovn;
2201: p_p46p_rec.act_info2 := l_p46p_rec.annual_pension;
2202: p_p46p_rec.act_info3 := l_p46p_rec.date_pension_start;
2203:
2204: hr_utility.set_location('Leaving: '||l_proc,999);
2205: return l_arch;
2206: END fetch_p46p_rec;
2207: --
2208: --

Line 2216: hr_utility.set_location('Entering: '||l_proc,1);

2212: l_proc CONSTANT VARCHAR2(50):= g_package||'insert_archive_row';
2213: l_ovn number;
2214: l_action_id number;
2215: BEGIN
2216: hr_utility.set_location('Entering: '||l_proc,1);
2217: if p_tab_rec_data.count > 0 then
2218: for i in p_tab_rec_data.first .. p_tab_rec_data.last loop
2219: hr_utility.trace('Defining category '|| p_tab_rec_data(i).action_info_category);
2220: hr_utility.trace('action_context_id = '|| p_assactid);

Line 2219: hr_utility.trace('Defining category '|| p_tab_rec_data(i).action_info_category);

2215: BEGIN
2216: hr_utility.set_location('Entering: '||l_proc,1);
2217: if p_tab_rec_data.count > 0 then
2218: for i in p_tab_rec_data.first .. p_tab_rec_data.last loop
2219: hr_utility.trace('Defining category '|| p_tab_rec_data(i).action_info_category);
2220: hr_utility.trace('action_context_id = '|| p_assactid);
2221: if p_tab_rec_data(i).action_info_category is not null then
2222: pay_action_information_api.create_action_information(
2223: p_action_information_id => l_action_id,

Line 2220: hr_utility.trace('action_context_id = '|| p_assactid);

2216: hr_utility.set_location('Entering: '||l_proc,1);
2217: if p_tab_rec_data.count > 0 then
2218: for i in p_tab_rec_data.first .. p_tab_rec_data.last loop
2219: hr_utility.trace('Defining category '|| p_tab_rec_data(i).action_info_category);
2220: hr_utility.trace('action_context_id = '|| p_assactid);
2221: if p_tab_rec_data(i).action_info_category is not null then
2222: pay_action_information_api.create_action_information(
2223: p_action_information_id => l_action_id,
2224: p_object_version_number => l_ovn,

Line 2264: hr_utility.set_location('Leaving: '||l_proc,999);

2260: );
2261: end if;
2262: end loop;
2263: end if;
2264: hr_utility.set_location('Leaving: '||l_proc,999);
2265: END insert_archive_row;
2266: --
2267: --
2268: /*------------ PUBLIC PROCEDURE --------------*/

Line 2309: hr_utility.set_location('Entering: '||l_proc,1);

2305: l_tax_dist_ref VARCHAR2(15);
2306: l_err BOOLEAN := False;
2307:
2308: BEGIN
2309: hr_utility.set_location('Entering: '||l_proc,1);
2310:
2311: l_tax_dist_no := substr(p_tax_ref,1,3);
2312: l_tax_dist_ref := substr(ltrim(substr(p_tax_ref,4,11),'/'),1,10);
2313:

Line 2314: hr_utility.set_location('l_tax_dist_no: '||l_tax_dist_no,1);

2310:
2311: l_tax_dist_no := substr(p_tax_ref,1,3);
2312: l_tax_dist_ref := substr(ltrim(substr(p_tax_ref,4,11),'/'),1,10);
2313:
2314: hr_utility.set_location('l_tax_dist_no: '||l_tax_dist_no,1);
2315: hr_utility.set_location('l_tax_dist_ref: '||l_tax_dist_ref,1);
2316:
2317: --Tax Reference validations
2318: IF l_tax_dist_no is null

Line 2315: hr_utility.set_location('l_tax_dist_ref: '||l_tax_dist_ref,1);

2311: l_tax_dist_no := substr(p_tax_ref,1,3);
2312: l_tax_dist_ref := substr(ltrim(substr(p_tax_ref,4,11),'/'),1,10);
2313:
2314: hr_utility.set_location('l_tax_dist_no: '||l_tax_dist_no,1);
2315: hr_utility.set_location('l_tax_dist_ref: '||l_tax_dist_ref,1);
2316:
2317: --Tax Reference validations
2318: IF l_tax_dist_no is null
2319: THEN

Line 2321: hr_utility.set_location('The HMRC Office Number is missing.',10);

2317: --Tax Reference validations
2318: IF l_tax_dist_no is null
2319: THEN
2320: l_err := TRUE;
2321: hr_utility.set_location('The HMRC Office Number is missing.',10);
2322: fnd_file.put_line(fnd_file.output,'The HMRC Office Number is missing.');
2323: END IF;
2324:
2325:

Line 2329: hr_utility.set_location('The employer''s PAYE Reference is missing.',10);

2325:
2326: IF l_tax_dist_ref is null
2327: THEN
2328: l_err := TRUE;
2329: hr_utility.set_location('The employer''s PAYE Reference is missing.',10);
2330: fnd_file.put_line(fnd_file.output,'The employer''s PAYE Reference is missing.');
2331:
2332: ELSIF pay_gb_eoy_magtape.validate_input(l_tax_dist_ref,'P14_FULL_EDI') > 0
2333: THEN

Line 2335: hr_utility.set_location('The employer''s PAYE Reference contains invalid characters.',10);

2331:
2332: ELSIF pay_gb_eoy_magtape.validate_input(l_tax_dist_ref,'P14_FULL_EDI') > 0
2333: THEN
2334: l_err := TRUE;
2335: hr_utility.set_location('The employer''s PAYE Reference contains invalid characters.',10);
2336: fnd_file.put_line(fnd_file.output,'The employer''s PAYE Reference contains invalid characters.');
2337: END IF;
2338:
2339: --Employer name validations

Line 2343: hr_utility.set_location('The employer''s name is missing for employer''s PAYE Reference '||p_tax_ref,10);

2339: --Employer name validations
2340: IF p_employer_name IS NULL
2341: THEN
2342: l_err := TRUE;
2343: hr_utility.set_location('The employer''s name is missing for employer''s PAYE Reference '||p_tax_ref,10);
2344: fnd_file.put_line(fnd_file.output,'The employer''s name is missing for employer''s PAYE Reference '||p_tax_ref);
2345:
2346: ELSIF pay_gb_eoy_magtape.validate_input(p_employer_name,'P14_FULL_EDI') > 0
2347: THEN

Line 2349: hr_utility.set_location('The employer''s name '||p_employer_name||' contains invalid character(s) for the employer''s PAYE Reference '||p_tax_ref,10);

2345:
2346: ELSIF pay_gb_eoy_magtape.validate_input(p_employer_name,'P14_FULL_EDI') > 0
2347: THEN
2348: l_err := TRUE;
2349: hr_utility.set_location('The employer''s name '||p_employer_name||' contains invalid character(s) for the employer''s PAYE Reference '||p_tax_ref,10);
2350: fnd_file.put_line(fnd_file.output,'The employer''s name '||p_employer_name||' contains invalid character(s) for the employer''s PAYE Reference '||p_tax_ref);
2351: END IF;
2352:
2353: --Test Indicator validations

Line 2359: hr_utility.set_location('The Test ID '||p_tst_id||' contains invalid character(s).',10);

2355: THEN
2356: IF pay_gb_eoy_magtape.validate_input(p_tst_id,'MIXED_CHAR_ALPHA_NUM') > 0
2357: THEN
2358: l_err := TRUE;
2359: hr_utility.set_location('The Test ID '||p_tst_id||' contains invalid character(s).',10);
2360: fnd_file.put_line(fnd_file.output,'The Test ID '||p_tst_id||' contains invalid character(s).');
2361: END IF;
2362: END IF;
2363:

Line 2364: hr_utility.set_location('Leaving: '||l_proc,999);

2360: fnd_file.put_line(fnd_file.output,'The Test ID '||p_tst_id||' contains invalid character(s).');
2361: END IF;
2362: END IF;
2363:
2364: hr_utility.set_location('Leaving: '||l_proc,999);
2365: RETURN l_err;
2366:
2367: END tax_dist_etext_vals;
2368:

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

2420: l_tst_id varchar2(10);
2421: l_rep_typ varchar2(15);
2422:
2423: BEGIN
2424: hr_utility.set_location('Entering '|| l_proc, 10);
2425: l_err := FALSE;
2426:
2427: open csr_sender_id;
2428: fetch csr_sender_id into l_sender_id, l_tax_ref, l_tax_dist, l_employer_name, l_employer_addr;

Line 2433: hr_utility.set_location('l_sender_id '|| l_sender_id, 10);

2429: close csr_sender_id;
2430:
2431: --For bugs 9255173 and 9255183
2432: --header validations
2433: hr_utility.set_location('l_sender_id '|| l_sender_id, 10);
2434:
2435: OPEN csr_cp_info;
2436: FETCH csr_cp_info into l_tst_indi,l_tst_id,l_rep_typ;
2437: CLOSE csr_cp_info;

Line 2439: hr_utility.set_location('l_tst_indi '|| l_tst_indi, 10);

2435: OPEN csr_cp_info;
2436: FETCH csr_cp_info into l_tst_indi,l_tst_id,l_rep_typ;
2437: CLOSE csr_cp_info;
2438:
2439: hr_utility.set_location('l_tst_indi '|| l_tst_indi, 10);
2440: hr_utility.set_location('l_tst_id '|| l_tst_id, 10);
2441: hr_utility.set_location('l_rep_typ '|| l_rep_typ, 10);
2442: hr_utility.set_location('l_tax_ref: '||l_tax_ref,1);
2443: hr_utility.set_location('l_employer_name: '||l_employer_name,1);

Line 2440: hr_utility.set_location('l_tst_id '|| l_tst_id, 10);

2436: FETCH csr_cp_info into l_tst_indi,l_tst_id,l_rep_typ;
2437: CLOSE csr_cp_info;
2438:
2439: hr_utility.set_location('l_tst_indi '|| l_tst_indi, 10);
2440: hr_utility.set_location('l_tst_id '|| l_tst_id, 10);
2441: hr_utility.set_location('l_rep_typ '|| l_rep_typ, 10);
2442: hr_utility.set_location('l_tax_ref: '||l_tax_ref,1);
2443: hr_utility.set_location('l_employer_name: '||l_employer_name,1);
2444:

Line 2441: hr_utility.set_location('l_rep_typ '|| l_rep_typ, 10);

2437: CLOSE csr_cp_info;
2438:
2439: hr_utility.set_location('l_tst_indi '|| l_tst_indi, 10);
2440: hr_utility.set_location('l_tst_id '|| l_tst_id, 10);
2441: hr_utility.set_location('l_rep_typ '|| l_rep_typ, 10);
2442: hr_utility.set_location('l_tax_ref: '||l_tax_ref,1);
2443: hr_utility.set_location('l_employer_name: '||l_employer_name,1);
2444:
2445: IF l_rep_typ in ('P46_VER6ET','P46EXP_VER6ET')

Line 2442: hr_utility.set_location('l_tax_ref: '||l_tax_ref,1);

2438:
2439: hr_utility.set_location('l_tst_indi '|| l_tst_indi, 10);
2440: hr_utility.set_location('l_tst_id '|| l_tst_id, 10);
2441: hr_utility.set_location('l_rep_typ '|| l_rep_typ, 10);
2442: hr_utility.set_location('l_tax_ref: '||l_tax_ref,1);
2443: hr_utility.set_location('l_employer_name: '||l_employer_name,1);
2444:
2445: IF l_rep_typ in ('P46_VER6ET','P46EXP_VER6ET')
2446: THEN

Line 2443: hr_utility.set_location('l_employer_name: '||l_employer_name,1);

2439: hr_utility.set_location('l_tst_indi '|| l_tst_indi, 10);
2440: hr_utility.set_location('l_tst_id '|| l_tst_id, 10);
2441: hr_utility.set_location('l_rep_typ '|| l_rep_typ, 10);
2442: hr_utility.set_location('l_tax_ref: '||l_tax_ref,1);
2443: hr_utility.set_location('l_employer_name: '||l_employer_name,1);
2444:
2445: IF l_rep_typ in ('P46_VER6ET','P46EXP_VER6ET')
2446: THEN
2447: hr_utility.set_location('Call header validations', 10);

Line 2447: hr_utility.set_location('Call header validations', 10);

2443: hr_utility.set_location('l_employer_name: '||l_employer_name,1);
2444:
2445: IF l_rep_typ in ('P46_VER6ET','P46EXP_VER6ET')
2446: THEN
2447: hr_utility.set_location('Call header validations', 10);
2448: l_err := tax_dist_etext_vals(l_tst_indi,
2449: l_tst_id,
2450: l_tax_ref,
2451: l_employer_name);

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

2483:
2484: if (l_err) then
2485: raise l_exp;
2486: end if;
2487: hr_utility.set_location('Leaving '|| l_proc, 10);
2488: EXCEPTION
2489: when others then
2490: hr_utility.raise_error;
2491: END archinit;

Line 2490: hr_utility.raise_error;

2486: end if;
2487: hr_utility.set_location('Leaving '|| l_proc, 10);
2488: EXCEPTION
2489: when others then
2490: hr_utility.raise_error;
2491: END archinit;
2492: --
2493: --
2494: PROCEDURE range_cursor (pactid IN NUMBER,

Line 2516: hr_utility.set_location('Entering: '||l_proc,1);

2512: test_indicator_error EXCEPTION;
2513: /* Changes for P45PT3 end*/
2514: l_proc CONSTANT VARCHAR2(35):= g_package||'range_cursor';
2515: BEGIN
2516: hr_utility.set_location('Entering: '||l_proc,1);
2517:
2518: /* Changes for P45PT3 start*/
2519: OPEN csr_parameter_info;
2520: fetch csr_parameter_info into l_test_indicator,l_test_id,l_report_type;

Line 2542: hr_utility.trace(' Range Cursor Statement : '||sqlstr);

2538: 'pay_payroll_actions ppa '||
2539: 'where ppa.payroll_action_id = :payroll_action_id '||
2540: 'and ppa.business_group_id = ppf.business_group_id '||
2541: 'order by ppf.person_id';
2542: hr_utility.trace(' Range Cursor Statement : '||sqlstr);
2543: hr_utility.set_location(' Leaving: '||l_proc,100);
2544: /* Changes for P45PT3 start*/
2545: EXCEPTION
2546: WHEN test_indicator_error THEN

Line 2543: hr_utility.set_location(' Leaving: '||l_proc,100);

2539: 'where ppa.payroll_action_id = :payroll_action_id '||
2540: 'and ppa.business_group_id = ppf.business_group_id '||
2541: 'order by ppf.person_id';
2542: hr_utility.trace(' Range Cursor Statement : '||sqlstr);
2543: hr_utility.set_location(' Leaving: '||l_proc,100);
2544: /* Changes for P45PT3 start*/
2545: EXCEPTION
2546: WHEN test_indicator_error THEN
2547: RAISE; -- reraise the error

Line 2615: hr_utility.set_location('Entering:p46_ver6et_action_creation',1);

2611: stperson in number,
2612: endperson in number,
2613: chunk in number) IS
2614: BEGIN
2615: hr_utility.set_location('Entering:p46_ver6et_action_creation',1);
2616: internal_action_creation(pactid, stperson, endperson, chunk,'GB_P46', 'P46_VER6ET');
2617: END p46_ver6et_action_creation;
2618:
2619:

Line 2626: hr_utility.set_location('Entering:p46exp_ver6et_action_creation',1);

2622: stperson in number,
2623: endperson in number,
2624: chunk in number) IS
2625: BEGIN
2626: hr_utility.set_location('Entering:p46exp_ver6et_action_creation',1);
2627: internal_action_creation(pactid, stperson, endperson, chunk,'GB_P46EXP', 'P46EXP_VER6ET');
2628: hr_utility.set_location('Leaving:p46exp_ver6et_action_creation',1);
2629: END p46exp_ver6et_action_creation;
2630:

Line 2628: hr_utility.set_location('Leaving:p46exp_ver6et_action_creation',1);

2624: chunk in number) IS
2625: BEGIN
2626: hr_utility.set_location('Entering:p46exp_ver6et_action_creation',1);
2627: internal_action_creation(pactid, stperson, endperson, chunk,'GB_P46EXP', 'P46EXP_VER6ET');
2628: hr_utility.set_location('Leaving:p46exp_ver6et_action_creation',1);
2629: END p46exp_ver6et_action_creation;
2630:
2631: --
2632: PROCEDURE p46_pennot_action_creation (pactid in number,

Line 2700: hr_utility.set_location('Entering: '||l_proc,1);

2696: l_msg_value VARCHAR2(1000);
2697:
2698:
2699: BEGIN
2700: hr_utility.set_location('Entering: '||l_proc,1);
2701:
2702: l_tax_code_in_use := p_tab_rec_data(0).act_info21;
2703: l_assignment_number := p_tab_rec_data(0).act_info11;
2704: l_sex := p_tab_rec_data(0).act_info17;

Line 2712: hr_utility.set_location('l_tax_code_in_use '||l_tax_code_in_use,111);

2708:
2709: l_default_p46 := p_tab_rec_data(2).act_info4;
2710: l_p46_statement := p_tab_rec_data(2).act_info2;
2711:
2712: hr_utility.set_location('l_tax_code_in_use '||l_tax_code_in_use,111);
2713: hr_utility.set_location('l_assignment_number '||l_assignment_number,111);
2714: hr_utility.set_location('l_sex '||l_sex,111);
2715: hr_utility.set_location('l_date_of_birth '||l_date_of_birth,111);
2716: hr_utility.set_location('l_hire_date '||l_hire_date,111);

Line 2713: hr_utility.set_location('l_assignment_number '||l_assignment_number,111);

2709: l_default_p46 := p_tab_rec_data(2).act_info4;
2710: l_p46_statement := p_tab_rec_data(2).act_info2;
2711:
2712: hr_utility.set_location('l_tax_code_in_use '||l_tax_code_in_use,111);
2713: hr_utility.set_location('l_assignment_number '||l_assignment_number,111);
2714: hr_utility.set_location('l_sex '||l_sex,111);
2715: hr_utility.set_location('l_date_of_birth '||l_date_of_birth,111);
2716: hr_utility.set_location('l_hire_date '||l_hire_date,111);
2717: hr_utility.set_location('l_tax_basis_in_use '||l_tax_basis_in_use,111);

Line 2714: hr_utility.set_location('l_sex '||l_sex,111);

2710: l_p46_statement := p_tab_rec_data(2).act_info2;
2711:
2712: hr_utility.set_location('l_tax_code_in_use '||l_tax_code_in_use,111);
2713: hr_utility.set_location('l_assignment_number '||l_assignment_number,111);
2714: hr_utility.set_location('l_sex '||l_sex,111);
2715: hr_utility.set_location('l_date_of_birth '||l_date_of_birth,111);
2716: hr_utility.set_location('l_hire_date '||l_hire_date,111);
2717: hr_utility.set_location('l_tax_basis_in_use '||l_tax_basis_in_use,111);
2718: hr_utility.set_location('l_default_p46 '||l_default_p46,111);

Line 2715: hr_utility.set_location('l_date_of_birth '||l_date_of_birth,111);

2711:
2712: hr_utility.set_location('l_tax_code_in_use '||l_tax_code_in_use,111);
2713: hr_utility.set_location('l_assignment_number '||l_assignment_number,111);
2714: hr_utility.set_location('l_sex '||l_sex,111);
2715: hr_utility.set_location('l_date_of_birth '||l_date_of_birth,111);
2716: hr_utility.set_location('l_hire_date '||l_hire_date,111);
2717: hr_utility.set_location('l_tax_basis_in_use '||l_tax_basis_in_use,111);
2718: hr_utility.set_location('l_default_p46 '||l_default_p46,111);
2719: hr_utility.set_location('l_p46_statement '||l_p46_statement,111);

Line 2716: hr_utility.set_location('l_hire_date '||l_hire_date,111);

2712: hr_utility.set_location('l_tax_code_in_use '||l_tax_code_in_use,111);
2713: hr_utility.set_location('l_assignment_number '||l_assignment_number,111);
2714: hr_utility.set_location('l_sex '||l_sex,111);
2715: hr_utility.set_location('l_date_of_birth '||l_date_of_birth,111);
2716: hr_utility.set_location('l_hire_date '||l_hire_date,111);
2717: hr_utility.set_location('l_tax_basis_in_use '||l_tax_basis_in_use,111);
2718: hr_utility.set_location('l_default_p46 '||l_default_p46,111);
2719: hr_utility.set_location('l_p46_statement '||l_p46_statement,111);
2720:

Line 2717: hr_utility.set_location('l_tax_basis_in_use '||l_tax_basis_in_use,111);

2713: hr_utility.set_location('l_assignment_number '||l_assignment_number,111);
2714: hr_utility.set_location('l_sex '||l_sex,111);
2715: hr_utility.set_location('l_date_of_birth '||l_date_of_birth,111);
2716: hr_utility.set_location('l_hire_date '||l_hire_date,111);
2717: hr_utility.set_location('l_tax_basis_in_use '||l_tax_basis_in_use,111);
2718: hr_utility.set_location('l_default_p46 '||l_default_p46,111);
2719: hr_utility.set_location('l_p46_statement '||l_p46_statement,111);
2720:
2721: --Validations

Line 2718: hr_utility.set_location('l_default_p46 '||l_default_p46,111);

2714: hr_utility.set_location('l_sex '||l_sex,111);
2715: hr_utility.set_location('l_date_of_birth '||l_date_of_birth,111);
2716: hr_utility.set_location('l_hire_date '||l_hire_date,111);
2717: hr_utility.set_location('l_tax_basis_in_use '||l_tax_basis_in_use,111);
2718: hr_utility.set_location('l_default_p46 '||l_default_p46,111);
2719: hr_utility.set_location('l_p46_statement '||l_p46_statement,111);
2720:
2721: --Validations
2722: IF l_tax_code_in_use IS NULL

Line 2719: hr_utility.set_location('l_p46_statement '||l_p46_statement,111);

2715: hr_utility.set_location('l_date_of_birth '||l_date_of_birth,111);
2716: hr_utility.set_location('l_hire_date '||l_hire_date,111);
2717: hr_utility.set_location('l_tax_basis_in_use '||l_tax_basis_in_use,111);
2718: hr_utility.set_location('l_default_p46 '||l_default_p46,111);
2719: hr_utility.set_location('l_p46_statement '||l_p46_statement,111);
2720:
2721: --Validations
2722: IF l_tax_code_in_use IS NULL
2723: THEN

Line 2726: hr_utility.set_location('The Tax Code in use of the assignment '||l_assignment_number||' is missing.',10);

2722: IF l_tax_code_in_use IS NULL
2723: THEN
2724: l_err := TRUE;
2725: populate_run_msg(p_assactid,'The Tax Code in use of the assignment '||l_assignment_number||' is missing.');
2726: hr_utility.set_location('The Tax Code in use of the assignment '||l_assignment_number||' is missing.',10);
2727: fnd_file.put_line (fnd_file.LOG,l_assignment_number||': The Tax Code in use of the assignment '||l_assignment_number||' is missing.');
2728: END IF;
2729:
2730: IF l_assignment_number IS NOT NULL

Line 2735: hr_utility.set_location('The Assignment Number '||l_assignment_number||' has invalid character(s).',10);

2731: AND pay_gb_eoy_magtape.validate_input(l_assignment_number,'P14_FULL_EDI') > 0
2732: THEN
2733: l_err := TRUE;
2734: populate_run_msg(p_assactid,'The Assignment Number '||l_assignment_number||' has invalid character(s).');
2735: hr_utility.set_location('The Assignment Number '||l_assignment_number||' has invalid character(s).',10);
2736: fnd_file.put_line (fnd_file.LOG,l_assignment_number||': The Assignment Number '||l_assignment_number||' has invalid character(s).');
2737: END IF;
2738:
2739: IF l_sex IS NULL

Line 2743: hr_utility.set_location('The Sex of the assignment '||l_assignment_number||' is missing.',10);

2739: IF l_sex IS NULL
2740: THEN
2741: l_err := TRUE;
2742: populate_run_msg(p_assactid,'The Sex of the assignment '||l_assignment_number||' is missing.');
2743: hr_utility.set_location('The Sex of the assignment '||l_assignment_number||' is missing.',10);
2744: fnd_file.put_line (fnd_file.LOG,l_assignment_number||': The Sex of the assignment '||l_assignment_number||' is missing.');
2745: ELSIF l_sex NOT IN ('M', 'F')
2746: THEN
2747: l_err := TRUE;

Line 2749: hr_utility.set_location('The sex '||l_sex||' is undefined for the assignment'||l_assignment_number,10);

2745: ELSIF l_sex NOT IN ('M', 'F')
2746: THEN
2747: l_err := TRUE;
2748: populate_run_msg(p_assactid,'The sex '||l_sex||' is undefined for the assignment'||l_assignment_number);
2749: hr_utility.set_location('The sex '||l_sex||' is undefined for the assignment'||l_assignment_number,10);
2750: fnd_file.put_line (fnd_file.LOG,l_assignment_number||': The sex '||l_sex||' is undefined for the assignment'||l_assignment_number);
2751: END IF;
2752:
2753: IF l_date_of_birth IS NULL

Line 2757: hr_utility.set_location('The Date of Birth of the assignment '||l_assignment_number||' is missing.',10);

2753: IF l_date_of_birth IS NULL
2754: THEN
2755: l_err := TRUE;
2756: populate_run_msg(p_assactid,'The Date of Birth of the assignment '||l_assignment_number||' is missing.');
2757: hr_utility.set_location('The Date of Birth of the assignment '||l_assignment_number||' is missing.',10);
2758: fnd_file.put_line (fnd_file.LOG,l_assignment_number||': The Date of Birth of the assignment '||l_assignment_number||' is missing.');
2759: END IF;
2760:
2761: IF l_default_p46 = 'N' AND l_p46_statement IS NULL

Line 2765: hr_utility.set_location('The assignment, '||l_assignment_number||', does not have a P46 Statement for a Normal P46 Process.',10);

2761: IF l_default_p46 = 'N' AND l_p46_statement IS NULL
2762: THEN
2763: l_err := TRUE;
2764: populate_run_msg(p_assactid,'The assignment, '||l_assignment_number||', does not have a P46 Statement for a Normal P46 Process.');
2765: hr_utility.set_location('The assignment, '||l_assignment_number||', does not have a P46 Statement for a Normal P46 Process.',10);
2766: fnd_file.put_line (fnd_file.LOG,l_assignment_number||': The assignment, '||l_assignment_number||', does not have a P46 Statement for a Normal P46 Process.');
2767: END IF;
2768:
2769: IF l_hire_date IS NULL

Line 2773: hr_utility.set_location('The assignment, '||l_assignment_number||', does not have a Hire Date.',10);

2769: IF l_hire_date IS NULL
2770: THEN
2771: l_err := TRUE;
2772: populate_run_msg(p_assactid,'The assignment, '||l_assignment_number||', does not have a Hire Date.');
2773: hr_utility.set_location('The assignment, '||l_assignment_number||', does not have a Hire Date.',10);
2774: fnd_file.put_line (fnd_file.LOG,l_assignment_number||': The assignment, '||l_assignment_number||', does not have a Hire Date.');
2775: END IF;
2776:
2777:

Line 2785: hr_utility.set_location('The '||l_msg_value||':tax code, '||l_tax_code_in_use||', for assignment '||l_assignment_number,10);

2781: AND l_msg_value <> ' '
2782: THEN
2783: l_err := TRUE;
2784: populate_run_msg(p_assactid,'The '||l_msg_value||':tax code, '||l_tax_code_in_use||', for assignment '||l_assignment_number);
2785: hr_utility.set_location('The '||l_msg_value||':tax code, '||l_tax_code_in_use||', for assignment '||l_assignment_number,10);
2786: fnd_file.put_line (fnd_file.LOG,l_assignment_number||': The '||l_msg_value||':tax code, '||l_tax_code_in_use||', for assignment '||l_assignment_number);
2787: END IF;
2788:
2789: IF l_tax_code_in_use IS NOT NULL

Line 2794: hr_utility.set_location('The Tax Basis in use is not present for Tax code in use, for assignment '||l_assignment_number,10);

2790: AND l_tax_basis_in_use IS NULL
2791: THEN
2792: l_err := TRUE;
2793: populate_run_msg(p_assactid,'The Tax Basis in use is not present for Tax code in use, for assignment '||l_assignment_number);
2794: hr_utility.set_location('The Tax Basis in use is not present for Tax code in use, for assignment '||l_assignment_number,10);
2795: fnd_file.put_line (fnd_file.LOG,l_assignment_number||': The Tax Basis in use is not present for Tax code in use, for assignment '||l_assignment_number);
2796: END IF;
2797:
2798: hr_utility.set_location('Leaving: '||l_proc,999);

Line 2798: hr_utility.set_location('Leaving: '||l_proc,999);

2794: hr_utility.set_location('The Tax Basis in use is not present for Tax code in use, for assignment '||l_assignment_number,10);
2795: fnd_file.put_line (fnd_file.LOG,l_assignment_number||': The Tax Basis in use is not present for Tax code in use, for assignment '||l_assignment_number);
2796: END IF;
2797:
2798: hr_utility.set_location('Leaving: '||l_proc,999);
2799: RETURN l_err;
2800:
2801: END p46_v6_asg_etext_vals;
2802:

Line 2838: hr_utility.trace('\n xxxx Test Indicator='||pay_magtape_generic.get_parameter_value('TEST'));

2834: where paa.assignment_action_id = p_assactid
2835: and paa.payroll_action_id = ppa.payroll_action_id;
2836:
2837: BEGIN
2838: hr_utility.trace('\n xxxx Test Indicator='||pay_magtape_generic.get_parameter_value('TEST'));
2839: --hr_utility.trace_on(null,'TKP');
2840: fnd_file.put_line(fnd_file.LOG,'Entering: '||l_proc);
2841: --hr_utility.trace('Tushar effective date is '|| to_char(p_effective_date,'DD-MON-YYYY') );
2842: --hr_utility.set_location('Entering: '||l_proc,1);

Line 2839: --hr_utility.trace_on(null,'TKP');

2835: and paa.payroll_action_id = ppa.payroll_action_id;
2836:
2837: BEGIN
2838: hr_utility.trace('\n xxxx Test Indicator='||pay_magtape_generic.get_parameter_value('TEST'));
2839: --hr_utility.trace_on(null,'TKP');
2840: fnd_file.put_line(fnd_file.LOG,'Entering: '||l_proc);
2841: --hr_utility.trace('Tushar effective date is '|| to_char(p_effective_date,'DD-MON-YYYY') );
2842: --hr_utility.set_location('Entering: '||l_proc,1);
2843: open csr_archive_type;

Line 2841: --hr_utility.trace('Tushar effective date is '|| to_char(p_effective_date,'DD-MON-YYYY') );

2837: BEGIN
2838: hr_utility.trace('\n xxxx Test Indicator='||pay_magtape_generic.get_parameter_value('TEST'));
2839: --hr_utility.trace_on(null,'TKP');
2840: fnd_file.put_line(fnd_file.LOG,'Entering: '||l_proc);
2841: --hr_utility.trace('Tushar effective date is '|| to_char(p_effective_date,'DD-MON-YYYY') );
2842: --hr_utility.set_location('Entering: '||l_proc,1);
2843: open csr_archive_type;
2844: fetch csr_archive_type into l_archive_type;
2845: close csr_archive_type;

Line 2842: --hr_utility.set_location('Entering: '||l_proc,1);

2838: hr_utility.trace('\n xxxx Test Indicator='||pay_magtape_generic.get_parameter_value('TEST'));
2839: --hr_utility.trace_on(null,'TKP');
2840: fnd_file.put_line(fnd_file.LOG,'Entering: '||l_proc);
2841: --hr_utility.trace('Tushar effective date is '|| to_char(p_effective_date,'DD-MON-YYYY') );
2842: --hr_utility.set_location('Entering: '||l_proc,1);
2843: open csr_archive_type;
2844: fetch csr_archive_type into l_archive_type;
2845: close csr_archive_type;
2846:

Line 2852: hr_utility.set_location('Fetching person details ',10);

2848: g_archive_type := l_archive_type;
2849:
2850: fetch_tax_rec(p_assactid,p_effective_date,l_tax_rec);
2851:
2852: hr_utility.set_location('Fetching person details ',10);
2853: l_archive_person := fetch_person_rec(p_assactid, p_effective_date, l_tax_rec, l_archive_tab(0));
2854:
2855: hr_utility.set_location('Fetching address details ',20);
2856: l_archive_addr := fetch_address_rec(l_archive_tab(0).person_id,

Line 2855: hr_utility.set_location('Fetching address details ',20);

2851:
2852: hr_utility.set_location('Fetching person details ',10);
2853: l_archive_person := fetch_person_rec(p_assactid, p_effective_date, l_tax_rec, l_archive_tab(0));
2854:
2855: hr_utility.set_location('Fetching address details ',20);
2856: l_archive_addr := fetch_address_rec(l_archive_tab(0).person_id,
2857: l_archive_tab(0).assignment_id,
2858: p_effective_date,
2859: l_archive_tab(1));

Line 2861: hr_utility.set_location('Fetching P45(3) details ',30);

2857: l_archive_tab(0).assignment_id,
2858: p_effective_date,
2859: l_archive_tab(1));
2860:
2861: hr_utility.set_location('Fetching P45(3) details ',30);
2862: if l_archive_type = 'P45_3' then
2863: l_archive_data := fetch_p45_3_rec(p_effective_date,l_tax_rec, l_archive_tab(0),l_archive_tab(2));
2864: /*changes for P45PT_3 start*/
2865: elsif l_archive_type = 'P45PT_3' then

Line 2910: hr_utility.set_location('Call P46 validations', 10);

2906: END IF;
2907:
2908: IF l_archive_type = 'P46_VER6ET'
2909: THEN
2910: hr_utility.set_location('Call P46 validations', 10);
2911: l_p46_val_err := p46_v6_asg_etext_vals(p_assactid, p_effective_date, l_archive_tab);
2912:
2913: ELSIF l_archive_type = 'P46EXP_VER6ET'
2914: THEN

Line 2915: hr_utility.set_location('Call P46Expat validations', 10);

2911: l_p46_val_err := p46_v6_asg_etext_vals(p_assactid, p_effective_date, l_archive_tab);
2912:
2913: ELSIF l_archive_type = 'P46EXP_VER6ET'
2914: THEN
2915: hr_utility.set_location('Call P46Expat validations', 10);
2916: p46exp_asg_etext_validations(p_assactid, p_effective_date, l_archive_tab, l_p46exp_etext_asg_flag);
2917:
2918: IF l_p46exp_etext_asg_flag = 'Y' THEN
2919: l_p46exp_val_err := TRUE;

Line 2933: hr_utility.set_location('l_assignment_number '||l_assignment_number,111);

2929: l_last_name := nvl(upper(substr(l_archive_tab(0).act_info8,1,35)),' ');
2930: l_middle_name := nvl(upper(substr(l_archive_tab(0).act_info7,1,35)),' ');
2931: l_title := nvl(substr(l_archive_tab(0).act_info14,1,4),' ');
2932:
2933: hr_utility.set_location('l_assignment_number '||l_assignment_number,111);
2934: hr_utility.set_location('l_national_insurance_number '||l_national_insurance_number,111);
2935: hr_utility.set_location('l_first_name '||l_first_name,111);
2936: hr_utility.set_location('l_last_name '||l_last_name,111);
2937: hr_utility.set_location('l_middle_name '||l_middle_name,111);

Line 2934: hr_utility.set_location('l_national_insurance_number '||l_national_insurance_number,111);

2930: l_middle_name := nvl(upper(substr(l_archive_tab(0).act_info7,1,35)),' ');
2931: l_title := nvl(substr(l_archive_tab(0).act_info14,1,4),' ');
2932:
2933: hr_utility.set_location('l_assignment_number '||l_assignment_number,111);
2934: hr_utility.set_location('l_national_insurance_number '||l_national_insurance_number,111);
2935: hr_utility.set_location('l_first_name '||l_first_name,111);
2936: hr_utility.set_location('l_last_name '||l_last_name,111);
2937: hr_utility.set_location('l_middle_name '||l_middle_name,111);
2938: hr_utility.set_location('l_title '||l_title,111);

Line 2935: hr_utility.set_location('l_first_name '||l_first_name,111);

2931: l_title := nvl(substr(l_archive_tab(0).act_info14,1,4),' ');
2932:
2933: hr_utility.set_location('l_assignment_number '||l_assignment_number,111);
2934: hr_utility.set_location('l_national_insurance_number '||l_national_insurance_number,111);
2935: hr_utility.set_location('l_first_name '||l_first_name,111);
2936: hr_utility.set_location('l_last_name '||l_last_name,111);
2937: hr_utility.set_location('l_middle_name '||l_middle_name,111);
2938: hr_utility.set_location('l_title '||l_title,111);
2939:

Line 2936: hr_utility.set_location('l_last_name '||l_last_name,111);

2932:
2933: hr_utility.set_location('l_assignment_number '||l_assignment_number,111);
2934: hr_utility.set_location('l_national_insurance_number '||l_national_insurance_number,111);
2935: hr_utility.set_location('l_first_name '||l_first_name,111);
2936: hr_utility.set_location('l_last_name '||l_last_name,111);
2937: hr_utility.set_location('l_middle_name '||l_middle_name,111);
2938: hr_utility.set_location('l_title '||l_title,111);
2939:
2940: IF (not l_p46_val_err) AND (not l_asg_val_err) AND (not l_p46exp_val_err)

Line 2937: hr_utility.set_location('l_middle_name '||l_middle_name,111);

2933: hr_utility.set_location('l_assignment_number '||l_assignment_number,111);
2934: hr_utility.set_location('l_national_insurance_number '||l_national_insurance_number,111);
2935: hr_utility.set_location('l_first_name '||l_first_name,111);
2936: hr_utility.set_location('l_last_name '||l_last_name,111);
2937: hr_utility.set_location('l_middle_name '||l_middle_name,111);
2938: hr_utility.set_location('l_title '||l_title,111);
2939:
2940: IF (not l_p46_val_err) AND (not l_asg_val_err) AND (not l_p46exp_val_err)
2941: AND l_archive_person AND l_archive_addr AND l_archive_data

Line 2938: hr_utility.set_location('l_title '||l_title,111);

2934: hr_utility.set_location('l_national_insurance_number '||l_national_insurance_number,111);
2935: hr_utility.set_location('l_first_name '||l_first_name,111);
2936: hr_utility.set_location('l_last_name '||l_last_name,111);
2937: hr_utility.set_location('l_middle_name '||l_middle_name,111);
2938: hr_utility.set_location('l_title '||l_title,111);
2939:
2940: IF (not l_p46_val_err) AND (not l_asg_val_err) AND (not l_p46exp_val_err)
2941: AND l_archive_person AND l_archive_addr AND l_archive_data
2942: THEN

Line 2956: hr_utility.set_location('Validation failed, raise error.',999);

2952: IF l_archive_type = 'P46_VER6ET' OR l_archive_type = 'P46EXP_VER6ET'
2953: THEN
2954: IF l_asg_val_err OR l_p46_val_err OR l_p46exp_val_err
2955: THEN
2956: hr_utility.set_location('Validation failed, raise error.',999);
2957: fnd_file.put_line(fnd_file.LOG,'Archiving');
2958: raise error_found;
2959: ELSE
2960: hr_utility.set_location('Validation successful, archive data.',999);

Line 2960: hr_utility.set_location('Validation successful, archive data.',999);

2956: hr_utility.set_location('Validation failed, raise error.',999);
2957: fnd_file.put_line(fnd_file.LOG,'Archiving');
2958: raise error_found;
2959: ELSE
2960: hr_utility.set_location('Validation successful, archive data.',999);
2961: insert_archive_row(p_assactid, p_effective_date, l_archive_tab);
2962: END IF;
2963: ELSE
2964: insert_archive_row(p_assactid, p_effective_date, l_archive_tab);

Line 2971: hr_utility.set_location('Leaving: '||l_proc,999);

2967: fnd_file.put_line(fnd_file.LOG,'Archiving');
2968: raise error_found;
2969: end if;
2970:
2971: hr_utility.set_location('Leaving: '||l_proc,999);
2972:
2973: EXCEPTION
2974: when error_found then
2975: if l_archive_type = 'P45_3' then

Line 3006: hr_utility.raise_error;

3002: IF l_archive_type in ('P46EXP_VER6ET','P46_VER6ET')
3003: THEN
3004: raise_application_error(-20001,'Error(s) found while archiving data.');
3005: ELSE
3006: hr_utility.raise_error;
3007: END IF;
3008: END archive_code;
3009: --
3010: --

Line 3320: hr_utility.set_location('Entering: '||l_proc,1);

3316: fnd_file.put_line(fnd_file.output,null);
3317: fnd_file.put_line(fnd_file.output,'Total Number Of Records : ' || l_counter);
3318: end write_footer;
3319: BEGIN
3320: hr_utility.set_location('Entering: '||l_proc,1);
3321:
3322: --For bugs 9255173 and 9255183: Modified logic for O/P file
3323: /*
3324: l_counter := 0;

Line 3355: hr_utility.set_location('This is a eText report, Spawn the BI Publisher process',1);

3351:
3352: IF l_is_etext_report = 'P46_VER6ET'
3353: THEN
3354: --this is a eText report, Spawn the BI Publisher process
3355: hr_utility.set_location('This is a eText report, Spawn the BI Publisher process',1);
3356:
3357: xml_layout := FND_REQUEST.ADD_LAYOUT('PAY','GB_P46_V6_ETO','en','US','ETEXT');
3358:
3359: IF xml_layout = true

Line 3371: hr_utility.set_location('Error spawning new process',1);

3367:
3368: --check for process submit error
3369: IF l_request_id = 0
3370: THEN
3371: hr_utility.set_location('Error spawning new process',1);
3372: END IF;
3373: END IF;
3374: END IF;
3375:

Line 3379: hr_utility.set_location('This is a eText report, Spawn the BI Publisher process',1);

3375:
3376: IF l_is_etext_report = 'P46EXP_VER6ET'
3377: THEN
3378: --this is a eText report, Spawn the BI Publisher process
3379: hr_utility.set_location('This is a eText report, Spawn the BI Publisher process',1);
3380:
3381: xml_layout := FND_REQUEST.ADD_LAYOUT('PAY','GB_P46EXP_V6_ETO','en','US','ETEXT');
3382:
3383: IF xml_layout = true

Line 3395: hr_utility.set_location('Error spawning new process',1);

3391:
3392: --check for process submit error
3393: IF l_request_id = 0
3394: THEN
3395: hr_utility.set_location('Error spawning new process',1);
3396: END IF;
3397: END IF;
3398: END IF;
3399:

Line 3400: hr_utility.set_location('Leaving: '||l_proc,999);

3396: END IF;
3397: END IF;
3398: END IF;
3399:
3400: hr_utility.set_location('Leaving: '||l_proc,999);
3401: END deinitialization_code;
3402: --
3403: --
3404: FUNCTION date_validate (c_assignment_action_id NUMBER,