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_RTI_NINO_REPLY_PKG dependencies on FND_GLOBAL

Line 131: fnd_global.local_chr(10) || 'f_nino_verifed ' || f_nino_verifed

127: and pei_information_category = 'RTI_NINO';
128: */
129:
130: fnd_file.put_line(fnd_file.LOG, 'f_person_id: ' ||to_char(f_person_id) ||
131: fnd_global.local_chr(10) || 'f_nino_verifed ' || f_nino_verifed
132: ||fnd_global.local_chr(10) || to_char(f_date_of_issue)
133: ||fnd_global.local_chr(10) || f_nvrep_status
134: ||fnd_global.local_chr(10) || f_nino_ver_type
135: ||fnd_global.local_chr(10) || 'l_extra_info_id: ' || to_char(l_extra_info_id)

Line 132: ||fnd_global.local_chr(10) || to_char(f_date_of_issue)

128: */
129:
130: fnd_file.put_line(fnd_file.LOG, 'f_person_id: ' ||to_char(f_person_id) ||
131: fnd_global.local_chr(10) || 'f_nino_verifed ' || f_nino_verifed
132: ||fnd_global.local_chr(10) || to_char(f_date_of_issue)
133: ||fnd_global.local_chr(10) || f_nvrep_status
134: ||fnd_global.local_chr(10) || f_nino_ver_type
135: ||fnd_global.local_chr(10) || 'l_extra_info_id: ' || to_char(l_extra_info_id)
136: ||fnd_global.local_chr(10) || 'l_object_version_number: ' || to_char(l_object_version_number));

Line 133: ||fnd_global.local_chr(10) || f_nvrep_status

129:
130: fnd_file.put_line(fnd_file.LOG, 'f_person_id: ' ||to_char(f_person_id) ||
131: fnd_global.local_chr(10) || 'f_nino_verifed ' || f_nino_verifed
132: ||fnd_global.local_chr(10) || to_char(f_date_of_issue)
133: ||fnd_global.local_chr(10) || f_nvrep_status
134: ||fnd_global.local_chr(10) || f_nino_ver_type
135: ||fnd_global.local_chr(10) || 'l_extra_info_id: ' || to_char(l_extra_info_id)
136: ||fnd_global.local_chr(10) || 'l_object_version_number: ' || to_char(l_object_version_number));
137: open fetch_person_extra_info;

Line 134: ||fnd_global.local_chr(10) || f_nino_ver_type

130: fnd_file.put_line(fnd_file.LOG, 'f_person_id: ' ||to_char(f_person_id) ||
131: fnd_global.local_chr(10) || 'f_nino_verifed ' || f_nino_verifed
132: ||fnd_global.local_chr(10) || to_char(f_date_of_issue)
133: ||fnd_global.local_chr(10) || f_nvrep_status
134: ||fnd_global.local_chr(10) || f_nino_ver_type
135: ||fnd_global.local_chr(10) || 'l_extra_info_id: ' || to_char(l_extra_info_id)
136: ||fnd_global.local_chr(10) || 'l_object_version_number: ' || to_char(l_object_version_number));
137: open fetch_person_extra_info;
138: fetch fetch_person_extra_info into l_extra_info_id, l_object_version_number, l_nino_verified_flag,l_correlation_id;

Line 135: ||fnd_global.local_chr(10) || 'l_extra_info_id: ' || to_char(l_extra_info_id)

131: fnd_global.local_chr(10) || 'f_nino_verifed ' || f_nino_verifed
132: ||fnd_global.local_chr(10) || to_char(f_date_of_issue)
133: ||fnd_global.local_chr(10) || f_nvrep_status
134: ||fnd_global.local_chr(10) || f_nino_ver_type
135: ||fnd_global.local_chr(10) || 'l_extra_info_id: ' || to_char(l_extra_info_id)
136: ||fnd_global.local_chr(10) || 'l_object_version_number: ' || to_char(l_object_version_number));
137: open fetch_person_extra_info;
138: fetch fetch_person_extra_info into l_extra_info_id, l_object_version_number, l_nino_verified_flag,l_correlation_id;
139: close fetch_person_extra_info;

Line 136: ||fnd_global.local_chr(10) || 'l_object_version_number: ' || to_char(l_object_version_number));

132: ||fnd_global.local_chr(10) || to_char(f_date_of_issue)
133: ||fnd_global.local_chr(10) || f_nvrep_status
134: ||fnd_global.local_chr(10) || f_nino_ver_type
135: ||fnd_global.local_chr(10) || 'l_extra_info_id: ' || to_char(l_extra_info_id)
136: ||fnd_global.local_chr(10) || 'l_object_version_number: ' || to_char(l_object_version_number));
137: open fetch_person_extra_info;
138: fetch fetch_person_extra_info into l_extra_info_id, l_object_version_number, l_nino_verified_flag,l_correlation_id;
139: close fetch_person_extra_info;
140: -- Already record exists and we have to update it if all the validations satisfy.

Line 273: || fnd_global.local_chr(10) || 'p_start_date: ' || to_char(p_start_date)

269: l_obj_version number;
270: begin
271: fnd_file.put_line(fnd_file.LOG,'Entering ' || l_package_name || '.update_emp_record');
272: fnd_file.put_line(fnd_file.LOG,'Parameters ' || ' p_person_id: ' || to_char(p_person_id)
273: || fnd_global.local_chr(10) || 'p_start_date: ' || to_char(p_start_date)
274: || fnd_global.local_chr(10) || 'p_end_date: ' || to_char(p_end_date )
275: || fnd_global.local_chr(10) || 'p_nino_to_use: ' || p_nino_to_use
276: || fnd_global.local_chr(10) || 'p_date_issued: ' || to_date(p_date_issued)
277: || fnd_global.local_chr(10) || 'p_msg_ident: ' ||p_msg_ident

Line 274: || fnd_global.local_chr(10) || 'p_end_date: ' || to_char(p_end_date )

270: begin
271: fnd_file.put_line(fnd_file.LOG,'Entering ' || l_package_name || '.update_emp_record');
272: fnd_file.put_line(fnd_file.LOG,'Parameters ' || ' p_person_id: ' || to_char(p_person_id)
273: || fnd_global.local_chr(10) || 'p_start_date: ' || to_char(p_start_date)
274: || fnd_global.local_chr(10) || 'p_end_date: ' || to_char(p_end_date )
275: || fnd_global.local_chr(10) || 'p_nino_to_use: ' || p_nino_to_use
276: || fnd_global.local_chr(10) || 'p_date_issued: ' || to_date(p_date_issued)
277: || fnd_global.local_chr(10) || 'p_msg_ident: ' ||p_msg_ident
278: || fnd_global.local_chr(10) || 'p_nino_reply_type: ' || p_nino_reply_type

Line 275: || fnd_global.local_chr(10) || 'p_nino_to_use: ' || p_nino_to_use

271: fnd_file.put_line(fnd_file.LOG,'Entering ' || l_package_name || '.update_emp_record');
272: fnd_file.put_line(fnd_file.LOG,'Parameters ' || ' p_person_id: ' || to_char(p_person_id)
273: || fnd_global.local_chr(10) || 'p_start_date: ' || to_char(p_start_date)
274: || fnd_global.local_chr(10) || 'p_end_date: ' || to_char(p_end_date )
275: || fnd_global.local_chr(10) || 'p_nino_to_use: ' || p_nino_to_use
276: || fnd_global.local_chr(10) || 'p_date_issued: ' || to_date(p_date_issued)
277: || fnd_global.local_chr(10) || 'p_msg_ident: ' ||p_msg_ident
278: || fnd_global.local_chr(10) || 'p_nino_reply_type: ' || p_nino_reply_type
279: || fnd_global.local_chr(10) || 'p_object_version_number: ' || to_char(p_object_version_number)

Line 276: || fnd_global.local_chr(10) || 'p_date_issued: ' || to_date(p_date_issued)

272: fnd_file.put_line(fnd_file.LOG,'Parameters ' || ' p_person_id: ' || to_char(p_person_id)
273: || fnd_global.local_chr(10) || 'p_start_date: ' || to_char(p_start_date)
274: || fnd_global.local_chr(10) || 'p_end_date: ' || to_char(p_end_date )
275: || fnd_global.local_chr(10) || 'p_nino_to_use: ' || p_nino_to_use
276: || fnd_global.local_chr(10) || 'p_date_issued: ' || to_date(p_date_issued)
277: || fnd_global.local_chr(10) || 'p_msg_ident: ' ||p_msg_ident
278: || fnd_global.local_chr(10) || 'p_nino_reply_type: ' || p_nino_reply_type
279: || fnd_global.local_chr(10) || 'p_object_version_number: ' || to_char(p_object_version_number)
280: || fnd_global.local_chr(10) || 'p_employee_number: ' || p_employee_number

Line 277: || fnd_global.local_chr(10) || 'p_msg_ident: ' ||p_msg_ident

273: || fnd_global.local_chr(10) || 'p_start_date: ' || to_char(p_start_date)
274: || fnd_global.local_chr(10) || 'p_end_date: ' || to_char(p_end_date )
275: || fnd_global.local_chr(10) || 'p_nino_to_use: ' || p_nino_to_use
276: || fnd_global.local_chr(10) || 'p_date_issued: ' || to_date(p_date_issued)
277: || fnd_global.local_chr(10) || 'p_msg_ident: ' ||p_msg_ident
278: || fnd_global.local_chr(10) || 'p_nino_reply_type: ' || p_nino_reply_type
279: || fnd_global.local_chr(10) || 'p_object_version_number: ' || to_char(p_object_version_number)
280: || fnd_global.local_chr(10) || 'p_employee_number: ' || p_employee_number
281: || fnd_global.local_chr(10) || 'p_recent_start_date: ' ||to_char(p_recent_start_date)

Line 278: || fnd_global.local_chr(10) || 'p_nino_reply_type: ' || p_nino_reply_type

274: || fnd_global.local_chr(10) || 'p_end_date: ' || to_char(p_end_date )
275: || fnd_global.local_chr(10) || 'p_nino_to_use: ' || p_nino_to_use
276: || fnd_global.local_chr(10) || 'p_date_issued: ' || to_date(p_date_issued)
277: || fnd_global.local_chr(10) || 'p_msg_ident: ' ||p_msg_ident
278: || fnd_global.local_chr(10) || 'p_nino_reply_type: ' || p_nino_reply_type
279: || fnd_global.local_chr(10) || 'p_object_version_number: ' || to_char(p_object_version_number)
280: || fnd_global.local_chr(10) || 'p_employee_number: ' || p_employee_number
281: || fnd_global.local_chr(10) || 'p_recent_start_date: ' ||to_char(p_recent_start_date)
282: );

Line 279: || fnd_global.local_chr(10) || 'p_object_version_number: ' || to_char(p_object_version_number)

275: || fnd_global.local_chr(10) || 'p_nino_to_use: ' || p_nino_to_use
276: || fnd_global.local_chr(10) || 'p_date_issued: ' || to_date(p_date_issued)
277: || fnd_global.local_chr(10) || 'p_msg_ident: ' ||p_msg_ident
278: || fnd_global.local_chr(10) || 'p_nino_reply_type: ' || p_nino_reply_type
279: || fnd_global.local_chr(10) || 'p_object_version_number: ' || to_char(p_object_version_number)
280: || fnd_global.local_chr(10) || 'p_employee_number: ' || p_employee_number
281: || fnd_global.local_chr(10) || 'p_recent_start_date: ' ||to_char(p_recent_start_date)
282: );
283: /* Status Details.

Line 280: || fnd_global.local_chr(10) || 'p_employee_number: ' || p_employee_number

276: || fnd_global.local_chr(10) || 'p_date_issued: ' || to_date(p_date_issued)
277: || fnd_global.local_chr(10) || 'p_msg_ident: ' ||p_msg_ident
278: || fnd_global.local_chr(10) || 'p_nino_reply_type: ' || p_nino_reply_type
279: || fnd_global.local_chr(10) || 'p_object_version_number: ' || to_char(p_object_version_number)
280: || fnd_global.local_chr(10) || 'p_employee_number: ' || p_employee_number
281: || fnd_global.local_chr(10) || 'p_recent_start_date: ' ||to_char(p_recent_start_date)
282: );
283: /* Status Details.
284: 1. This notification shows the correct NINO. Please use this NINO for any future submissions instead of the one you originally provided.

Line 281: || fnd_global.local_chr(10) || 'p_recent_start_date: ' ||to_char(p_recent_start_date)

277: || fnd_global.local_chr(10) || 'p_msg_ident: ' ||p_msg_ident
278: || fnd_global.local_chr(10) || 'p_nino_reply_type: ' || p_nino_reply_type
279: || fnd_global.local_chr(10) || 'p_object_version_number: ' || to_char(p_object_version_number)
280: || fnd_global.local_chr(10) || 'p_employee_number: ' || p_employee_number
281: || fnd_global.local_chr(10) || 'p_recent_start_date: ' ||to_char(p_recent_start_date)
282: );
283: /* Status Details.
284: 1. This notification shows the correct NINO. Please use this NINO for any future submissions instead of the one you originally provided.
285: 2. There was no NINO provided or the one given is incl_orrect. Please do not use the incorrect one for any future submissions

Line 518: || fnd_global.local_chr(10) || 'p_validate_mode: ' || p_validate_mode

514: -- hr_utility.trace_on(null,'suma');
515: fnd_file.put_line(fnd_file.LOG,'PAY_GB_RTI_NINO_REPLY_PKG.read_nino_reply');
516: fnd_file.put_line(fnd_file.LOG,'Parameter values:');
517: fnd_file.put_line(fnd_file.LOG,'p_business_group: '|| to_char(p_business_group)
518: || fnd_global.local_chr(10) || 'p_validate_mode: ' || p_validate_mode
519: || fnd_global.local_chr(10) || 'p_filename: ' || p_filename);
520: --
521: l_filename := p_filename;
522: --

Line 519: || fnd_global.local_chr(10) || 'p_filename: ' || p_filename);

515: fnd_file.put_line(fnd_file.LOG,'PAY_GB_RTI_NINO_REPLY_PKG.read_nino_reply');
516: fnd_file.put_line(fnd_file.LOG,'Parameter values:');
517: fnd_file.put_line(fnd_file.LOG,'p_business_group: '|| to_char(p_business_group)
518: || fnd_global.local_chr(10) || 'p_validate_mode: ' || p_validate_mode
519: || fnd_global.local_chr(10) || 'p_filename: ' || p_filename);
520: --
521: l_filename := p_filename;
522: --
523: -- Get I/O Directory

Line 527: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;

523: -- Get I/O Directory
524: --
525: fnd_profile.get('PER_DATA_EXCHANGE_DIR', l_location);
526: -- Get request id
527: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
528:
529: fnd_file.put_line(fnd_file.LOG,'directory: <'|| l_location || '>');
530: if l_location is null then
531: -- error : I/O directory not defined

Line 650: || fnd_global.local_chr(10) || 'l_employer_paye_ref: ' || l_employer_paye_ref

646: -- writing into the database
647: if ((l_record_name = 'LIN1' and (l_employee_count > 1)) or
648: (l_record_name = 'UNS2')) then
649: fnd_file.put_line(fnd_file.LOG,'p_business_group:' || to_number(p_business_group)
650: || fnd_global.local_chr(10) || 'l_employer_paye_ref: ' || l_employer_paye_ref
651: || fnd_global.local_chr(10) || 'l_employee_number: ' || l_employee_number
652: || fnd_global.local_chr(10) || 'l_last_name: ' || l_last_name
653: || fnd_global.local_chr(10) || 'l_first_name: ' || l_first_name
654: || fnd_global.local_chr(10) || 'l_nino_provided: ' || l_nino_provided

Line 651: || fnd_global.local_chr(10) || 'l_employee_number: ' || l_employee_number

647: if ((l_record_name = 'LIN1' and (l_employee_count > 1)) or
648: (l_record_name = 'UNS2')) then
649: fnd_file.put_line(fnd_file.LOG,'p_business_group:' || to_number(p_business_group)
650: || fnd_global.local_chr(10) || 'l_employer_paye_ref: ' || l_employer_paye_ref
651: || fnd_global.local_chr(10) || 'l_employee_number: ' || l_employee_number
652: || fnd_global.local_chr(10) || 'l_last_name: ' || l_last_name
653: || fnd_global.local_chr(10) || 'l_first_name: ' || l_first_name
654: || fnd_global.local_chr(10) || 'l_nino_provided: ' || l_nino_provided
655: || fnd_global.local_chr(10) || 'l_payroll_id: ' || l_payroll_id

Line 652: || fnd_global.local_chr(10) || 'l_last_name: ' || l_last_name

648: (l_record_name = 'UNS2')) then
649: fnd_file.put_line(fnd_file.LOG,'p_business_group:' || to_number(p_business_group)
650: || fnd_global.local_chr(10) || 'l_employer_paye_ref: ' || l_employer_paye_ref
651: || fnd_global.local_chr(10) || 'l_employee_number: ' || l_employee_number
652: || fnd_global.local_chr(10) || 'l_last_name: ' || l_last_name
653: || fnd_global.local_chr(10) || 'l_first_name: ' || l_first_name
654: || fnd_global.local_chr(10) || 'l_nino_provided: ' || l_nino_provided
655: || fnd_global.local_chr(10) || 'l_payroll_id: ' || l_payroll_id
656: || fnd_global.local_chr(10) || 'l_correlation_id: ' || l_correlation_id

Line 653: || fnd_global.local_chr(10) || 'l_first_name: ' || l_first_name

649: fnd_file.put_line(fnd_file.LOG,'p_business_group:' || to_number(p_business_group)
650: || fnd_global.local_chr(10) || 'l_employer_paye_ref: ' || l_employer_paye_ref
651: || fnd_global.local_chr(10) || 'l_employee_number: ' || l_employee_number
652: || fnd_global.local_chr(10) || 'l_last_name: ' || l_last_name
653: || fnd_global.local_chr(10) || 'l_first_name: ' || l_first_name
654: || fnd_global.local_chr(10) || 'l_nino_provided: ' || l_nino_provided
655: || fnd_global.local_chr(10) || 'l_payroll_id: ' || l_payroll_id
656: || fnd_global.local_chr(10) || 'l_correlation_id: ' || l_correlation_id
657: || fnd_global.local_chr(10) || 'l_nino_to_use: ' || l_nino_to_use

Line 654: || fnd_global.local_chr(10) || 'l_nino_provided: ' || l_nino_provided

650: || fnd_global.local_chr(10) || 'l_employer_paye_ref: ' || l_employer_paye_ref
651: || fnd_global.local_chr(10) || 'l_employee_number: ' || l_employee_number
652: || fnd_global.local_chr(10) || 'l_last_name: ' || l_last_name
653: || fnd_global.local_chr(10) || 'l_first_name: ' || l_first_name
654: || fnd_global.local_chr(10) || 'l_nino_provided: ' || l_nino_provided
655: || fnd_global.local_chr(10) || 'l_payroll_id: ' || l_payroll_id
656: || fnd_global.local_chr(10) || 'l_correlation_id: ' || l_correlation_id
657: || fnd_global.local_chr(10) || 'l_nino_to_use: ' || l_nino_to_use
658: || fnd_global.local_chr(10) || 'l_date_issued: ' ||l_date_issued

Line 655: || fnd_global.local_chr(10) || 'l_payroll_id: ' || l_payroll_id

651: || fnd_global.local_chr(10) || 'l_employee_number: ' || l_employee_number
652: || fnd_global.local_chr(10) || 'l_last_name: ' || l_last_name
653: || fnd_global.local_chr(10) || 'l_first_name: ' || l_first_name
654: || fnd_global.local_chr(10) || 'l_nino_provided: ' || l_nino_provided
655: || fnd_global.local_chr(10) || 'l_payroll_id: ' || l_payroll_id
656: || fnd_global.local_chr(10) || 'l_correlation_id: ' || l_correlation_id
657: || fnd_global.local_chr(10) || 'l_nino_to_use: ' || l_nino_to_use
658: || fnd_global.local_chr(10) || 'l_date_issued: ' ||l_date_issued
659: || fnd_global.local_chr(10)|| 'l_msg_ident: ' || l_msg_ident

Line 656: || fnd_global.local_chr(10) || 'l_correlation_id: ' || l_correlation_id

652: || fnd_global.local_chr(10) || 'l_last_name: ' || l_last_name
653: || fnd_global.local_chr(10) || 'l_first_name: ' || l_first_name
654: || fnd_global.local_chr(10) || 'l_nino_provided: ' || l_nino_provided
655: || fnd_global.local_chr(10) || 'l_payroll_id: ' || l_payroll_id
656: || fnd_global.local_chr(10) || 'l_correlation_id: ' || l_correlation_id
657: || fnd_global.local_chr(10) || 'l_nino_to_use: ' || l_nino_to_use
658: || fnd_global.local_chr(10) || 'l_date_issued: ' ||l_date_issued
659: || fnd_global.local_chr(10)|| 'l_msg_ident: ' || l_msg_ident
660: || fnd_global.local_chr(10) || 'l_nino_reply_type: ' ||l_nino_reply_type

Line 657: || fnd_global.local_chr(10) || 'l_nino_to_use: ' || l_nino_to_use

653: || fnd_global.local_chr(10) || 'l_first_name: ' || l_first_name
654: || fnd_global.local_chr(10) || 'l_nino_provided: ' || l_nino_provided
655: || fnd_global.local_chr(10) || 'l_payroll_id: ' || l_payroll_id
656: || fnd_global.local_chr(10) || 'l_correlation_id: ' || l_correlation_id
657: || fnd_global.local_chr(10) || 'l_nino_to_use: ' || l_nino_to_use
658: || fnd_global.local_chr(10) || 'l_date_issued: ' ||l_date_issued
659: || fnd_global.local_chr(10)|| 'l_msg_ident: ' || l_msg_ident
660: || fnd_global.local_chr(10) || 'l_nino_reply_type: ' ||l_nino_reply_type
661: || fnd_global.local_chr(10) || 'l_date_issued_format ' || l_date_issued_format);

Line 658: || fnd_global.local_chr(10) || 'l_date_issued: ' ||l_date_issued

654: || fnd_global.local_chr(10) || 'l_nino_provided: ' || l_nino_provided
655: || fnd_global.local_chr(10) || 'l_payroll_id: ' || l_payroll_id
656: || fnd_global.local_chr(10) || 'l_correlation_id: ' || l_correlation_id
657: || fnd_global.local_chr(10) || 'l_nino_to_use: ' || l_nino_to_use
658: || fnd_global.local_chr(10) || 'l_date_issued: ' ||l_date_issued
659: || fnd_global.local_chr(10)|| 'l_msg_ident: ' || l_msg_ident
660: || fnd_global.local_chr(10) || 'l_nino_reply_type: ' ||l_nino_reply_type
661: || fnd_global.local_chr(10) || 'l_date_issued_format ' || l_date_issued_format);
662:

Line 659: || fnd_global.local_chr(10)|| 'l_msg_ident: ' || l_msg_ident

655: || fnd_global.local_chr(10) || 'l_payroll_id: ' || l_payroll_id
656: || fnd_global.local_chr(10) || 'l_correlation_id: ' || l_correlation_id
657: || fnd_global.local_chr(10) || 'l_nino_to_use: ' || l_nino_to_use
658: || fnd_global.local_chr(10) || 'l_date_issued: ' ||l_date_issued
659: || fnd_global.local_chr(10)|| 'l_msg_ident: ' || l_msg_ident
660: || fnd_global.local_chr(10) || 'l_nino_reply_type: ' ||l_nino_reply_type
661: || fnd_global.local_chr(10) || 'l_date_issued_format ' || l_date_issued_format);
662:
663:

Line 660: || fnd_global.local_chr(10) || 'l_nino_reply_type: ' ||l_nino_reply_type

656: || fnd_global.local_chr(10) || 'l_correlation_id: ' || l_correlation_id
657: || fnd_global.local_chr(10) || 'l_nino_to_use: ' || l_nino_to_use
658: || fnd_global.local_chr(10) || 'l_date_issued: ' ||l_date_issued
659: || fnd_global.local_chr(10)|| 'l_msg_ident: ' || l_msg_ident
660: || fnd_global.local_chr(10) || 'l_nino_reply_type: ' ||l_nino_reply_type
661: || fnd_global.local_chr(10) || 'l_date_issued_format ' || l_date_issued_format);
662:
663:
664: -- fetch person_id, start date and end date based on NI Number , first name and last name

Line 661: || fnd_global.local_chr(10) || 'l_date_issued_format ' || l_date_issued_format);

657: || fnd_global.local_chr(10) || 'l_nino_to_use: ' || l_nino_to_use
658: || fnd_global.local_chr(10) || 'l_date_issued: ' ||l_date_issued
659: || fnd_global.local_chr(10)|| 'l_msg_ident: ' || l_msg_ident
660: || fnd_global.local_chr(10) || 'l_nino_reply_type: ' ||l_nino_reply_type
661: || fnd_global.local_chr(10) || 'l_date_issued_format ' || l_date_issued_format);
662:
663:
664: -- fetch person_id, start date and end date based on NI Number , first name and last name
665: get_emp_details(

Line 686: || fnd_global.local_chr(10) || 'start_date' || to_char(l_start_date)

682: -- Update the records of the employees found .
683: if (l_person_id is not null) then
684: fnd_file.put_line(fnd_file.LOG,'Employee found for NI Number ' || l_nino_provided);
685: fnd_file.put_line(fnd_file.LOG,'person_id ' || to_char(l_person_id)
686: || fnd_global.local_chr(10) || 'start_date' || to_char(l_start_date)
687: || fnd_global.local_chr(10) || 'end_date' || to_char(l_end_date)
688: || fnd_global.local_chr(10) || 'recent_start_date ' || to_char(l_recent_start_date)
689: || fnd_global.local_chr(10) || 'employee_number ' || l_employee_number );
690: if l_emp_count = 1 then

Line 687: || fnd_global.local_chr(10) || 'end_date' || to_char(l_end_date)

683: if (l_person_id is not null) then
684: fnd_file.put_line(fnd_file.LOG,'Employee found for NI Number ' || l_nino_provided);
685: fnd_file.put_line(fnd_file.LOG,'person_id ' || to_char(l_person_id)
686: || fnd_global.local_chr(10) || 'start_date' || to_char(l_start_date)
687: || fnd_global.local_chr(10) || 'end_date' || to_char(l_end_date)
688: || fnd_global.local_chr(10) || 'recent_start_date ' || to_char(l_recent_start_date)
689: || fnd_global.local_chr(10) || 'employee_number ' || l_employee_number );
690: if l_emp_count = 1 then
691: l_updated_flag := update_emp_record(

Line 688: || fnd_global.local_chr(10) || 'recent_start_date ' || to_char(l_recent_start_date)

684: fnd_file.put_line(fnd_file.LOG,'Employee found for NI Number ' || l_nino_provided);
685: fnd_file.put_line(fnd_file.LOG,'person_id ' || to_char(l_person_id)
686: || fnd_global.local_chr(10) || 'start_date' || to_char(l_start_date)
687: || fnd_global.local_chr(10) || 'end_date' || to_char(l_end_date)
688: || fnd_global.local_chr(10) || 'recent_start_date ' || to_char(l_recent_start_date)
689: || fnd_global.local_chr(10) || 'employee_number ' || l_employee_number );
690: if l_emp_count = 1 then
691: l_updated_flag := update_emp_record(
692: p_person_id =>l_person_id,

Line 689: || fnd_global.local_chr(10) || 'employee_number ' || l_employee_number );

685: fnd_file.put_line(fnd_file.LOG,'person_id ' || to_char(l_person_id)
686: || fnd_global.local_chr(10) || 'start_date' || to_char(l_start_date)
687: || fnd_global.local_chr(10) || 'end_date' || to_char(l_end_date)
688: || fnd_global.local_chr(10) || 'recent_start_date ' || to_char(l_recent_start_date)
689: || fnd_global.local_chr(10) || 'employee_number ' || l_employee_number );
690: if l_emp_count = 1 then
691: l_updated_flag := update_emp_record(
692: p_person_id =>l_person_id,
693: p_start_date =>l_start_date,

Line 803: fnd_file.put_line(FND_FILE.OUTPUT, fnd_global.local_chr(10) || 'Total number of employees processed successfully:' || to_char(l_processed_success));

799: LOOP
800: fnd_file.put_line(FND_FILE.OUTPUT,report_output_success(i));
801: fnd_file.put_line(fnd_file.LOG,report_output_success(i));
802: END LOOP;
803: fnd_file.put_line(FND_FILE.OUTPUT, fnd_global.local_chr(10) || 'Total number of employees processed successfully:' || to_char(l_processed_success));
804: fnd_file.put_line(fnd_file.LOG,'No Of employees updated with NINO: ' || to_char(l_processed_success));
805: fnd_file.put_line(FND_FILE.OUTPUT,' ');
806: fnd_file.put_line(FND_FILE.OUTPUT,' ');
807: -- Printing the warnings part

Line 813: fnd_file.put_line(FND_FILE.OUTPUT, fnd_global.local_chr(10) || 'Total number of employees processed with Warnings:' || to_char(l_processed_warnings));

809: LOOP
810: fnd_file.put_line(FND_FILE.OUTPUT,report_output_warnings(i));
811: fnd_file.put_line(fnd_file.LOG,report_output_warnings(i));
812: END LOOP;
813: fnd_file.put_line(FND_FILE.OUTPUT, fnd_global.local_chr(10) || 'Total number of employees processed with Warnings:' || to_char(l_processed_warnings));
814: fnd_file.put_line(fnd_file.LOG,'No Of employees processed with warnings:' || to_char(warnings -1));
815:
816: fnd_file.put_line(FND_FILE.OUTPUT,fnd_global.local_chr(10) || 'Total number of employees in the file: ' || to_char(l_employee_count));
817: fnd_file.put_line(fnd_file.LOG, 'Total No of employees in the file: ' || to_char(l_employee_count));

Line 816: fnd_file.put_line(FND_FILE.OUTPUT,fnd_global.local_chr(10) || 'Total number of employees in the file: ' || to_char(l_employee_count));

812: END LOOP;
813: fnd_file.put_line(FND_FILE.OUTPUT, fnd_global.local_chr(10) || 'Total number of employees processed with Warnings:' || to_char(l_processed_warnings));
814: fnd_file.put_line(fnd_file.LOG,'No Of employees processed with warnings:' || to_char(warnings -1));
815:
816: fnd_file.put_line(FND_FILE.OUTPUT,fnd_global.local_chr(10) || 'Total number of employees in the file: ' || to_char(l_employee_count));
817: fnd_file.put_line(fnd_file.LOG, 'Total No of employees in the file: ' || to_char(l_employee_count));
818:
819: exception
820: when e_invalid_paye_ref then