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 PAY_GB_RTI_NINO_REPLY_PKG

Line 1: package body PAY_GB_RTI_NINO_REPLY_PKG AS

1: package body PAY_GB_RTI_NINO_REPLY_PKG AS
2: /* $Header: pygbrtininoreply.pkb 120.23.12020000.2 2013/02/08 13:49:48 ssarap noship $ */
3: /* This package reads the response file for NI Number verification sent by HMRC
4: and updates the changes in the system.
5: **/

Line 29: l_package_name varchar2(30) := 'PAY_GB_RTI_NINO_REPLY_PKG';

25: p_validate_mode varchar2
26: ) IS
27:
28: l_filename varchar2(200);
29: l_package_name varchar2(30) := 'PAY_GB_RTI_NINO_REPLY_PKG';
30: l_file_handle utl_file.file_type;
31: l_request_id varchar2(10);
32: l_location varchar2(2000) := null;
33: l_processing BOOLEAN := true;

Line 515: fnd_file.put_line(fnd_file.LOG,'PAY_GB_RTI_NINO_REPLY_PKG.read_nino_reply');

511: end get_emp_details;
512:
513: begin
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);

Line 544: fnd_file.put_line(fnd_file.LOG,'PAY_GB_RTI_NINO_REPLY_PKG.read_nino_reply');

540: --l_file_handle := utl_file.fopen('/usr/tmp','Reply.mf','r');
541: --
542: utl_file.get_line(l_file_handle,l_present_line);
543:
544: fnd_file.put_line(fnd_file.LOG,'PAY_GB_RTI_NINO_REPLY_PKG.read_nino_reply');
545:
546: fnd_file.put_line(fnd_file.LOG,'line: '|| l_present_line);
547:
548: report_output_success(success) := 'The following employees have been updated with NINO received: ';

Line 750: fnd_file.put_line(fnd_file.LOG,'PAY_GB_RTI_NINO_REPLY_PKG.read_nino_reply');

746: --
747: begin
748: utl_file.get_line(l_file_handle,l_present_line);
749: --
750: fnd_file.put_line(fnd_file.LOG,'PAY_GB_RTI_NINO_REPLY_PKG.read_nino_reply');
751: fnd_file.put_line(fnd_file.LOG,'line: '|| l_present_line);
752: --
753: exception
754: when no_data_found then

Line 837: fnd_file.put_line(fnd_file.LOG,'PAY_GB_RTI_NINO_REPLY_PKG.read_nino_reply');

833: fnd_file.put_line(fnd_file.LOG,'Fatal Error');
834: rollback;
835: when UTL_FILE.INVALID_OPERATION then
836: UTL_FILE.FCLOSE(l_file_handle);
837: fnd_file.put_line(fnd_file.LOG,'PAY_GB_RTI_NINO_REPLY_PKG.read_nino_reply');
838: retcode:=2;
839: errbuf := 'Reading NINO Reply File - Invalid Operation (file not found).';
840: when UTL_FILE.INTERNAL_ERROR then
841: UTL_FILE.FCLOSE(l_file_handle);

Line 842: fnd_file.put_line(fnd_file.LOG,'PAY_GB_RTI_NINO_REPLY_PKG.read_nino_reply');

838: retcode:=2;
839: errbuf := 'Reading NINO Reply File - Invalid Operation (file not found).';
840: when UTL_FILE.INTERNAL_ERROR then
841: UTL_FILE.FCLOSE(l_file_handle);
842: fnd_file.put_line(fnd_file.LOG,'PAY_GB_RTI_NINO_REPLY_PKG.read_nino_reply');
843: retcode:=2;
844: errbuf := 'Reading NINO Reply File - Internal Error.';
845: when UTL_FILE.INVALID_MODE then
846: UTL_FILE.FCLOSE(l_file_handle);

Line 847: fnd_file.put_line(fnd_file.LOG,'PAY_GB_RTI_NINO_REPLY_PKG.read_nino_reply');

843: retcode:=2;
844: errbuf := 'Reading NINO Reply File - Internal Error.';
845: when UTL_FILE.INVALID_MODE then
846: UTL_FILE.FCLOSE(l_file_handle);
847: fnd_file.put_line(fnd_file.LOG,'PAY_GB_RTI_NINO_REPLY_PKG.read_nino_reply');
848: retcode:=2;
849: errbuf := 'Reading NINO Reply File - Invalid Mode.';
850: when UTL_FILE.INVALID_PATH then
851: UTL_FILE.FCLOSE(l_file_handle);

Line 852: fnd_file.put_line(fnd_file.LOG,'PAY_GB_RTI_NINO_REPLY_PKG.read_nino_reply');

848: retcode:=2;
849: errbuf := 'Reading NINO Reply File - Invalid Mode.';
850: when UTL_FILE.INVALID_PATH then
851: UTL_FILE.FCLOSE(l_file_handle);
852: fnd_file.put_line(fnd_file.LOG,'PAY_GB_RTI_NINO_REPLY_PKG.read_nino_reply');
853: retcode:=2;
854: errbuf := 'Reading NINO Reply File - Invalid Path.';
855: when UTL_FILE.INVALID_FILEHANDLE then
856: UTL_FILE.FCLOSE(l_file_handle);

Line 857: fnd_file.put_line(fnd_file.LOG,'PAY_GB_RTI_NINO_REPLY_PKG.read_nino_reply');

853: retcode:=2;
854: errbuf := 'Reading NINO Reply File - Invalid Path.';
855: when UTL_FILE.INVALID_FILEHANDLE then
856: UTL_FILE.FCLOSE(l_file_handle);
857: fnd_file.put_line(fnd_file.LOG,'PAY_GB_RTI_NINO_REPLY_PKG.read_nino_reply');
858: retcode:=2;
859: errbuf := 'Reading NINO Reply File - Invalid File Handle.';
860: when UTL_FILE.READ_ERROR then
861: UTL_FILE.FCLOSE(l_file_handle);

Line 862: fnd_file.put_line(fnd_file.LOG,'PAY_GB_RTI_NINO_REPLY_PKG.read_nino_reply');

858: retcode:=2;
859: errbuf := 'Reading NINO Reply File - Invalid File Handle.';
860: when UTL_FILE.READ_ERROR then
861: UTL_FILE.FCLOSE(l_file_handle);
862: fnd_file.put_line(fnd_file.LOG,'PAY_GB_RTI_NINO_REPLY_PKG.read_nino_reply');
863: retcode:=2;
864: errbuf := 'Reading NINO Reply File - Read Error.';
865:
866: when others then