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_FPS dependencies on PAY_GB_RTI_FPS

Line 1: PACKAGE BODY PAY_GB_RTI_FPS AS

1: PACKAGE BODY PAY_GB_RTI_FPS AS
2: /* $Header: pygbrtifps.pkb 120.1.12020000.134 2013/03/29 13:37:12 ssarap noship $ */
3: /*===========================================================================+
4: | Copyright (c) 1993 Oracle Corporation |
5: | Redwood Shores, California, USA |

Line 9: PAY_GB_RTI_FPS

5: | Redwood Shores, California, USA |
6: | All rights reserved. |
7: +============================================================================
8: Name:
9: PAY_GB_RTI_FPS
10: Purpose:
11: It fetches the live data and archives it for RTI Processes.
12: This is a UK Specific payroll package.
13: History:

Line 176: g_package CONSTANT VARCHAR2(20) := 'pay_gb_rti_fps.';

172: Fetched the correct NI Employee values .
173: ============================================================================*/
174: --
175: --
176: g_package CONSTANT VARCHAR2(20) := 'pay_gb_rti_fps.';
177: c_contract_table_name CONSTANT pay_user_tables.user_table_name%TYPE := 'PQP_CONTRACT_TYPES';
178: g_start_year DATE;
179: g_end_year DATE;
180: g_effective_date DATE;

Line 6122: pay_gb_rti_fps_validate.header_validations(pactid,g_validation_check);

6118: ||''''||l_payroll_id||''''|| ' order by person_id';
6119:
6120: hr_utility.trace(' Range Cursor Statement : '||sqlstr);
6121: -- Header validations
6122: pay_gb_rti_fps_validate.header_validations(pactid,g_validation_check);
6123:
6124: hr_utility.set_location(' Leaving: '||l_proc,100);
6125:
6126: EXCEPTION

Line 9705: pay_gb_rti_fps_validate.person_address_validations(p_assactid, sysdate, l_archive_tab,l_per_addr_val_flag);

9701: end if;
9702: END IF;
9703:
9704: set_address_fields(l_archive_tab(1),l_archive_tab(0),l_archive_tab(2));
9705: pay_gb_rti_fps_validate.person_address_validations(p_assactid, sysdate, l_archive_tab,l_per_addr_val_flag);
9706: pay_gb_rti_fps_validate.assignment_validations(p_assactid, sysdate, l_archive_tab,l_asg_val_flag);
9707:
9708: l_fps_ni_val_err := FALSE;
9709: l_fps_etext_ni_flag := 'Y';

Line 9706: pay_gb_rti_fps_validate.assignment_validations(p_assactid, sysdate, l_archive_tab,l_asg_val_flag);

9702: END IF;
9703:
9704: set_address_fields(l_archive_tab(1),l_archive_tab(0),l_archive_tab(2));
9705: pay_gb_rti_fps_validate.person_address_validations(p_assactid, sysdate, l_archive_tab,l_per_addr_val_flag);
9706: pay_gb_rti_fps_validate.assignment_validations(p_assactid, sysdate, l_archive_tab,l_asg_val_flag);
9707:
9708: l_fps_ni_val_err := FALSE;
9709: l_fps_etext_ni_flag := 'Y';
9710:

Line 9714: pay_gb_rti_fps_validate.ni_validations(p_assactid, p_effective_date, l_archive_tab,i_count,l_fps_etext_ni_flag);

9710:
9711: FOR i_count IN 4..i
9712: LOOP
9713: hr_utility.set_location ('Calling FPS NI validations', 10);
9714: pay_gb_rti_fps_validate.ni_validations(p_assactid, p_effective_date, l_archive_tab,i_count,l_fps_etext_ni_flag);
9715: IF l_fps_etext_ni_flag = 'Y'
9716: THEN
9717: l_fps_ni_val_err := TRUE;
9718: END IF;

Line 10111: pay_gb_rti_fps_validate.person_address_validations(p_assactid, p_effective_date, l_archive_tab,l_per_addr_val_flag);

10107: set_address_fields(l_archive_tab(1),l_archive_tab(0),l_archive_tab(2));
10108:
10109: -- Validating fetched Person,Address,Assignment details for FPS
10110: hr_utility.set_location('Calling Person Address validations', 10);
10111: pay_gb_rti_fps_validate.person_address_validations(p_assactid, p_effective_date, l_archive_tab,l_per_addr_val_flag);
10112: hr_utility.trace('person address' ||l_per_addr_val_flag);
10113:
10114: IF l_per_addr_val_flag = 'Y' THEN -- If validation fails
10115: l_personaddr_val_err := TRUE;

Line 10119: pay_gb_rti_fps_validate.assignment_validations(p_assactid, p_effective_date, l_archive_tab,l_fps_etext_asg_flag);

10115: l_personaddr_val_err := TRUE;
10116: END IF;
10117:
10118: hr_utility.set_location('Calling FPS validations', 10);
10119: pay_gb_rti_fps_validate.assignment_validations(p_assactid, p_effective_date, l_archive_tab,l_fps_etext_asg_flag);
10120:
10121: IF l_fps_etext_asg_flag = 'Y' THEN -- If validation fails
10122: l_fps_val_err := TRUE;
10123: END IF;

Line 10132: pay_gb_rti_fps_validate.ni_validations(p_assactid, p_effective_date, l_archive_tab,i_count,l_fps_etext_ni_flag);

10128: LOOP
10129:
10130: hr_utility.set_location ('Calling FPS NI validations', 10);
10131:
10132: pay_gb_rti_fps_validate.ni_validations(p_assactid, p_effective_date, l_archive_tab,i_count,l_fps_etext_ni_flag);
10133:
10134: IF l_fps_etext_ni_flag = 'Y' THEN -- If validation fails
10135: l_fps_ni_val_err := TRUE;
10136: END IF;

Line 10826: pay_gb_rti_fps_validate.assignment_validations_aggr(p_assactid,

10822:
10823: --
10824: --Validations needs to be performed for each of the assignments separately
10825: hr_utility.set_location('In PAYE Aggr if Before Calling FPS validations', 10);
10826: pay_gb_rti_fps_validate.assignment_validations_aggr(p_assactid,
10827: p_effective_date,
10828: l_archive_tab,
10829: l_archive_tab_det1(l_archive_det1_counter),
10830: l_archive_tab_det2(l_archive_det2_counter),

Line 11326: -- pay_gb_rti_fps_validate.person_address_validations(p_assactid, p_effective_date, l_archive_tab,l_per_addr_val_flag);

11322: set_address_fields(l_archive_tab(1),l_archive_tab(0),l_archive_tab_det1(l_archive_det1_counter));
11323:
11324: -- Validating fetched Person,Address,Assignment details for FPS
11325: hr_utility.set_location('Calling Person Address validations', 10);
11326: -- pay_gb_rti_fps_validate.person_address_validations(p_assactid, p_effective_date, l_archive_tab,l_per_addr_val_flag);
11327: hr_utility.trace('After l_archive_det1_counter' ||l_archive_det1_counter);
11328: hr_utility.trace('After l_archive_det2_counter' ||l_archive_det2_counter);
11329:
11330: pay_gb_rti_fps_validate.person_addr_validations_aggr(p_assactid,

Line 11330: pay_gb_rti_fps_validate.person_addr_validations_aggr(p_assactid,

11326: -- pay_gb_rti_fps_validate.person_address_validations(p_assactid, p_effective_date, l_archive_tab,l_per_addr_val_flag);
11327: hr_utility.trace('After l_archive_det1_counter' ||l_archive_det1_counter);
11328: hr_utility.trace('After l_archive_det2_counter' ||l_archive_det2_counter);
11329:
11330: pay_gb_rti_fps_validate.person_addr_validations_aggr(p_assactid,
11331: p_effective_date,
11332: l_archive_tab,
11333: l_archive_tab_det1(l_archive_det1_counter),
11334: l_archive_tab_det2(l_archive_det2_counter),

Line 11355: -- pay_gb_rti_fps_validate.assignment_validations(p_assactid, p_effective_date, l_archive_tab,l_fps_etext_asg_flag);

11351: hr_utility.trace('l_archive_tab_det1(l_archive_det1_counter)' ||l_archive_tab_det1(l_archive_det1_counter).act_info2);
11352: hr_utility.trace('l_archive_tab_det1(l_archive_det1_counter)' ||l_archive_tab_det1(l_archive_det1_counter).act_info3);
11353:
11354:
11355: -- pay_gb_rti_fps_validate.assignment_validations(p_assactid, p_effective_date, l_archive_tab,l_fps_etext_asg_flag);
11356: pay_gb_rti_fps_validate.assignment_validations_aggr(p_assactid,
11357: p_effective_date,
11358: l_archive_tab,
11359: l_archive_tab_det1(l_archive_det1_counter),

Line 11356: pay_gb_rti_fps_validate.assignment_validations_aggr(p_assactid,

11352: hr_utility.trace('l_archive_tab_det1(l_archive_det1_counter)' ||l_archive_tab_det1(l_archive_det1_counter).act_info3);
11353:
11354:
11355: -- pay_gb_rti_fps_validate.assignment_validations(p_assactid, p_effective_date, l_archive_tab,l_fps_etext_asg_flag);
11356: pay_gb_rti_fps_validate.assignment_validations_aggr(p_assactid,
11357: p_effective_date,
11358: l_archive_tab,
11359: l_archive_tab_det1(l_archive_det1_counter),
11360: l_archive_tab_det2(l_archive_det2_counter),

Line 11378: pay_gb_rti_fps_validate.ni_validations(p_assactid, p_effective_date, l_archive_tab_ni_det_1,i_count,l_fps_etext_ni_flag);

11374: LOOP
11375:
11376: hr_utility.set_location ('Calling FPS NI validations: i_2', 10);
11377:
11378: pay_gb_rti_fps_validate.ni_validations(p_assactid, p_effective_date, l_archive_tab_ni_det_1,i_count,l_fps_etext_ni_flag);
11379:
11380: -- l_fps_etext_ni_flag := 'N'; --for testing
11381:
11382: IF l_fps_etext_ni_flag = 'Y' THEN -- If validation fails

Line 11392: pay_gb_rti_fps_validate.ni_validations(p_assactid, p_effective_date, l_archive_tab_ni_det,i_count,l_fps_etext_ni_flag);

11388: LOOP
11389:
11390: hr_utility.set_location ('Calling FPS NI validations : i_1', 10);
11391:
11392: pay_gb_rti_fps_validate.ni_validations(p_assactid, p_effective_date, l_archive_tab_ni_det,i_count,l_fps_etext_ni_flag);
11393:
11394: -- l_fps_etext_ni_flag := 'N'; --for testing
11395:
11396: IF l_fps_etext_ni_flag = 'Y' THEN -- If validation fails

Line 11960: pay_gb_rti_fps_validate.person_address_validations(p_assactid, p_effective_date, l_archive_tab,l_per_addr_val_flag);

11956: set_address_fields(l_archive_tab(1),l_archive_tab(0),l_archive_tab(2));
11957:
11958: -- Validating fetched Person,Address,Assignment details for FPS
11959: hr_utility.set_location('Calling Person Address validations', 10);
11960: pay_gb_rti_fps_validate.person_address_validations(p_assactid, p_effective_date, l_archive_tab,l_per_addr_val_flag);
11961: hr_utility.trace('person address' ||l_per_addr_val_flag);
11962:
11963: l_per_addr_val_flag := 'N'; --for testing
11964:

Line 11970: pay_gb_rti_fps_validate.assignment_validations(p_assactid, p_effective_date, l_archive_tab,l_fps_etext_asg_flag);

11966: l_personaddr_val_err := TRUE;
11967: END IF;
11968:
11969: hr_utility.set_location('Calling FPS validations', 10);
11970: pay_gb_rti_fps_validate.assignment_validations(p_assactid, p_effective_date, l_archive_tab,l_fps_etext_asg_flag);
11971:
11972: IF l_fps_etext_asg_flag = 'Y' THEN -- If validation fails
11973: l_fps_val_err := TRUE;
11974: END IF;

Line 11984: pay_gb_rti_fps_validate.ni_validations(p_assactid, p_effective_date, l_archive_tab,i_count,l_fps_etext_ni_flag);

11980: LOOP
11981:
11982: hr_utility.set_location ('C7alling FPS NI validations', 10);
11983:
11984: pay_gb_rti_fps_validate.ni_validations(p_assactid, p_effective_date, l_archive_tab,i_count,l_fps_etext_ni_flag);
11985:
11986: -- l_fps_etext_ni_flag := 'N'; --for testing
11987:
11988: IF l_fps_etext_ni_flag = 'Y' THEN -- If validation fails

Line 12900: pay_gb_rti_fps_validate.footer_validations(l_payroll_rec.econ_number,l_final_submission,l_flag);

12896:
12897: l_econ := l_payroll_rec.econ_number;
12898:
12899: --Footer Validations
12900: pay_gb_rti_fps_validate.footer_validations(l_payroll_rec.econ_number,l_final_submission,l_flag);
12901:
12902: pay_balance_pkg.set_context('PAYROLL_ACTION_ID',pactid);
12903: hr_utility.set_location('l_payroll_rec.bus_grp_id = ' || l_payroll_rec.bus_grp_id,10);
12904: hr_utility.set_location('l_payroll_rec.act_param_grp_id = ' || l_payroll_rec.act_param_grp_id,20);

Line 13028: END PAY_GB_RTI_FPS;

13024: fnd_file.put_line(fnd_file.LOG,'Errors found while archiving data.');
13025: raise_application_error(-20001,'Errors found while archiving data.');
13026: END deinitialization_code;
13027: --
13028: END PAY_GB_RTI_FPS;