DBA Data[Home] [Help]

APPS.PAY_GB_RTI_FPS_ARCHIVE dependencies on PAY_GB_RTI_FPS_VALIDATE_13

Line 6791: pay_gb_rti_fps_validate_13.header_validations(pactid,g_validation_check);

6787: ||''''||l_payroll_id||''''|| ' order by person_id';
6788:
6789: hr_utility.trace(' Range Cursor Statement : '||sqlstr);
6790: -- Header validations
6791: pay_gb_rti_fps_validate_13.header_validations(pactid,g_validation_check);
6792:
6793: hr_utility.set_location(' Leaving: '||l_proc,100);
6794:
6795: EXCEPTION

Line 10367: pay_gb_rti_fps_validate_13.person_address_validations(p_assactid, sysdate, l_archive_tab,l_per_addr_val_flag);

10363: END IF;
10364:
10365:
10366: set_address_fields(l_archive_tab(1),l_archive_tab(0),l_archive_tab(2));
10367: pay_gb_rti_fps_validate_13.person_address_validations(p_assactid, sysdate, l_archive_tab,l_per_addr_val_flag);
10368: pay_gb_rti_fps_validate_13.assignment_validations(p_assactid, sysdate, l_archive_tab,l_asg_val_flag);
10369: l_fps_etext_ni_flag := 'Y';
10370: l_fps_ni_val_err := FALSE;
10371:

Line 10368: pay_gb_rti_fps_validate_13.assignment_validations(p_assactid, sysdate, l_archive_tab,l_asg_val_flag);

10364:
10365:
10366: set_address_fields(l_archive_tab(1),l_archive_tab(0),l_archive_tab(2));
10367: pay_gb_rti_fps_validate_13.person_address_validations(p_assactid, sysdate, l_archive_tab,l_per_addr_val_flag);
10368: pay_gb_rti_fps_validate_13.assignment_validations(p_assactid, sysdate, l_archive_tab,l_asg_val_flag);
10369: l_fps_etext_ni_flag := 'Y';
10370: l_fps_ni_val_err := FALSE;
10371:
10372: FOR i_count IN 4..i

Line 10375: pay_gb_rti_fps_validate_13.ni_validations(p_assactid, p_effective_date, l_archive_tab,i_count,l_fps_etext_ni_flag);

10371:
10372: FOR i_count IN 4..i
10373: LOOP
10374: hr_utility.set_location ('Calling FPS NI validations', 10);
10375: pay_gb_rti_fps_validate_13.ni_validations(p_assactid, p_effective_date, l_archive_tab,i_count,l_fps_etext_ni_flag);
10376: IF l_fps_etext_ni_flag = 'Y'
10377: THEN
10378: l_fps_ni_val_err := TRUE;
10379: END IF;

Line 10788: pay_gb_rti_fps_validate_13.person_address_validations(p_assactid, p_effective_date, l_archive_tab,l_per_addr_val_flag);

10784: set_address_fields(l_archive_tab(1),l_archive_tab(0),l_archive_tab(2));
10785:
10786: -- Validating fetched Person,Address,Assignment details for FPS
10787: hr_utility.set_location('Calling Person Address validations', 10);
10788: pay_gb_rti_fps_validate_13.person_address_validations(p_assactid, p_effective_date, l_archive_tab,l_per_addr_val_flag);
10789: hr_utility.trace('person address' ||l_per_addr_val_flag);
10790:
10791: IF l_per_addr_val_flag = 'Y' THEN -- If validation fails
10792: l_personaddr_val_err := TRUE;

Line 10796: pay_gb_rti_fps_validate_13.assignment_validations(p_assactid, p_effective_date, l_archive_tab,l_fps_etext_asg_flag);

10792: l_personaddr_val_err := TRUE;
10793: END IF;
10794:
10795: hr_utility.set_location('Calling FPS validations', 10);
10796: pay_gb_rti_fps_validate_13.assignment_validations(p_assactid, p_effective_date, l_archive_tab,l_fps_etext_asg_flag);
10797:
10798: IF l_fps_etext_asg_flag = 'Y' THEN -- If validation fails
10799: l_fps_val_err := TRUE;
10800: END IF;

Line 10809: pay_gb_rti_fps_validate_13.ni_validations(p_assactid, p_effective_date, l_archive_tab,i_count,l_fps_etext_ni_flag);

10805: LOOP
10806:
10807: hr_utility.set_location ('Calling FPS NI validations', 10);
10808:
10809: pay_gb_rti_fps_validate_13.ni_validations(p_assactid, p_effective_date, l_archive_tab,i_count,l_fps_etext_ni_flag);
10810:
10811: IF l_fps_etext_ni_flag = 'Y' THEN -- If validation fails
10812: l_fps_ni_val_err := TRUE;
10813: END IF;

Line 11526: pay_gb_rti_fps_validate_13.assignment_validations_aggr(p_assactid,

11522:
11523: --
11524: --Validations needs to be performed for each of the assignments separately
11525: hr_utility.set_location('In PAYE Aggr if Before Calling FPS validations', 10);
11526: pay_gb_rti_fps_validate_13.assignment_validations_aggr(p_assactid,
11527: p_effective_date,
11528: l_archive_tab,
11529: l_archive_tab_det1(l_archive_det1_counter),
11530: l_archive_tab_det2(l_archive_det2_counter),

Line 12044: pay_gb_rti_fps_validate_13.person_addr_validations_aggr(p_assactid,

12040: -- pay_gb_rti_fps_validate.person_address_validations(p_assactid, p_effective_date, l_archive_tab,l_per_addr_val_flag);
12041: hr_utility.trace('After l_archive_det1_counter' ||l_archive_det1_counter);
12042: hr_utility.trace('After l_archive_det2_counter' ||l_archive_det2_counter);
12043:
12044: pay_gb_rti_fps_validate_13.person_addr_validations_aggr(p_assactid,
12045: p_effective_date,
12046: l_archive_tab,
12047: l_archive_tab_det1(l_archive_det1_counter),
12048: l_archive_tab_det2(l_archive_det2_counter),

Line 12070: pay_gb_rti_fps_validate_13.assignment_validations_aggr(p_assactid,

12066: hr_utility.trace('l_archive_tab_det1(l_archive_det1_counter)' ||l_archive_tab_det1(l_archive_det1_counter).act_info3);
12067:
12068:
12069: -- pay_gb_rti_fps_validate.assignment_validations(p_assactid, p_effective_date, l_archive_tab,l_fps_etext_asg_flag);
12070: pay_gb_rti_fps_validate_13.assignment_validations_aggr(p_assactid,
12071: p_effective_date,
12072: l_archive_tab,
12073: l_archive_tab_det1(l_archive_det1_counter),
12074: l_archive_tab_det2(l_archive_det2_counter),

Line 12092: pay_gb_rti_fps_validate_13.ni_validations(p_assactid, p_effective_date, l_archive_tab_ni_det_1,i_count,l_fps_etext_ni_flag);

12088: LOOP
12089:
12090: hr_utility.set_location ('Calling FPS NI validations: i_2', 10);
12091:
12092: pay_gb_rti_fps_validate_13.ni_validations(p_assactid, p_effective_date, l_archive_tab_ni_det_1,i_count,l_fps_etext_ni_flag);
12093:
12094: -- l_fps_etext_ni_flag := 'N'; --for testing
12095:
12096: IF l_fps_etext_ni_flag = 'Y' THEN -- If validation fails

Line 12106: pay_gb_rti_fps_validate_13.ni_validations(p_assactid, p_effective_date, l_archive_tab_ni_det,i_count,l_fps_etext_ni_flag);

12102: LOOP
12103:
12104: hr_utility.set_location ('Calling FPS NI validations : i_1', 10);
12105:
12106: pay_gb_rti_fps_validate_13.ni_validations(p_assactid, p_effective_date, l_archive_tab_ni_det,i_count,l_fps_etext_ni_flag);
12107:
12108: -- l_fps_etext_ni_flag := 'N'; --for testing
12109:
12110: IF l_fps_etext_ni_flag = 'Y' THEN -- If validation fails

Line 12690: pay_gb_rti_fps_validate_13.person_address_validations(p_assactid, p_effective_date, l_archive_tab,l_per_addr_val_flag);

12686: set_address_fields(l_archive_tab(1),l_archive_tab(0),l_archive_tab(2));
12687:
12688: -- Validating fetched Person,Address,Assignment details for FPS
12689: hr_utility.set_location('Calling Person Address validations', 10);
12690: pay_gb_rti_fps_validate_13.person_address_validations(p_assactid, p_effective_date, l_archive_tab,l_per_addr_val_flag);
12691: hr_utility.trace('person address' ||l_per_addr_val_flag);
12692:
12693: --l_per_addr_val_flag := 'N'; --for testing
12694:

Line 12700: pay_gb_rti_fps_validate_13.assignment_validations(p_assactid, p_effective_date, l_archive_tab,l_fps_etext_asg_flag);

12696: l_personaddr_val_err := TRUE;
12697: END IF;
12698:
12699: hr_utility.set_location('Calling FPS validations', 10);
12700: pay_gb_rti_fps_validate_13.assignment_validations(p_assactid, p_effective_date, l_archive_tab,l_fps_etext_asg_flag);
12701:
12702: IF l_fps_etext_asg_flag = 'Y' THEN -- If validation fails
12703: l_fps_val_err := TRUE;
12704: END IF;

Line 12714: pay_gb_rti_fps_validate_13.ni_validations(p_assactid, p_effective_date, l_archive_tab,i_count,l_fps_etext_ni_flag);

12710: LOOP
12711:
12712: hr_utility.set_location ('C7alling FPS NI validations', 10);
12713:
12714: pay_gb_rti_fps_validate_13.ni_validations(p_assactid, p_effective_date, l_archive_tab,i_count,l_fps_etext_ni_flag);
12715:
12716: -- l_fps_etext_ni_flag := 'N'; --for testing
12717:
12718: IF l_fps_etext_ni_flag = 'Y' THEN -- If validation fails

Line 13659: pay_gb_rti_fps_validate_13.footer_validations(l_payroll_rec.econ_number,l_final_submission,l_flag);

13655:
13656: l_econ := l_payroll_rec.econ_number;
13657:
13658: --Footer Validations
13659: pay_gb_rti_fps_validate_13.footer_validations(l_payroll_rec.econ_number,l_final_submission,l_flag);
13660:
13661: pay_balance_pkg.set_context('PAYROLL_ACTION_ID',pactid);
13662: hr_utility.set_location('l_payroll_rec.bus_grp_id = ' || l_payroll_rec.bus_grp_id,10);
13663: hr_utility.set_location('l_payroll_rec.act_param_grp_id = ' || l_payroll_rec.act_param_grp_id,20);