403:
404: IF csr_get_event_group_info%NOTFOUND
405: THEN
406: -- Raise an error
407: pqp_gb_psi_functions.store_extract_exceptions(
408: p_extract_type => 'PART_TIME_HOURS'
409: ,p_error_number => 94423
410: ,p_error_text => 'BEN_94423_EXT_PSI_NO_EVNT_GRP'
411: ,p_token1 => l_event_group(i)
622: debug('Raise abv not found error');
623: END IF;
624: -- Raise data error
625: l_value :=
626: pqp_gb_psi_functions.raise_extract_error(
627: p_error_number => 94479
628: ,p_error_text => 'BEN_94479_EXT_PSI_REQ_FLD_MISS'
629: ,p_token1 => 'FTE'
630: );
808: debug('Raise aat not found error');
809: END IF;
810: -- Raise data error
811: l_value :=
812: pqp_gb_psi_functions.raise_extract_error(
813: p_error_number => 94479
814: ,p_error_text => 'BEN_94479_EXT_PSI_REQ_FLD_MISS'
815: ,p_token1 => 'Assignment Attribute'
816: );
823: debug('Raise contract type is null error');
824: END IF;
825: -- Raise data error
826: l_value :=
827: pqp_gb_psi_functions.raise_extract_error(
828: p_error_number => 94479
829: ,p_error_text => 'BEN_94479_EXT_PSI_REQ_FLD_MISS'
830: ,p_token1 => 'Contract Type'
831: );
858:
859: IF l_return = -1 THEN
860: -- Raise error
861: l_value :=
862: pqp_gb_psi_functions.raise_extract_error(
863: p_error_number => 94479
864: ,p_error_text => 'BEN_94479_EXT_PSI_REQ_FLD_MISS'
865: ,p_token1 => 'Penserver P/T Hours Type'
866: );
876: ELSIF l_hours_type IS NULL
877: THEN
878: -- Raise error
879: l_value :=
880: pqp_gb_psi_functions.raise_extract_error(
881: p_error_number => 94479
882: ,p_error_text => 'BEN_94479_EXT_PSI_REQ_FLD_MISS'
883: ,p_token1 => 'Penserver P/T Hours Type'
884: );
883: ,p_token1 => 'Penserver P/T Hours Type'
884: );
885: ELSE
886: l_value :=
887: pqp_gb_psi_functions.raise_extract_error(
888: p_error_number => 94636
889: ,p_error_text => 'BEN_94636_EXT_PSI_INV_HRS_TYPE'
890: ,p_token1 => l_hours_type
891: ,p_token2 => l_rec_aat_dtls.contract_type
917: END IF;
918: IF l_return = -1 THEN
919: -- Raise error
920: l_value :=
921: pqp_gb_psi_functions.raise_extract_error(
922: p_error_number => 94479
923: ,p_error_text => 'BEN_94479_EXT_PSI_REQ_FLD_MISS'
924: ,p_token1 => 'Period Divisor'
925: );
1387: DEBUG(l_proc_name, l_proc_step);
1388: END IF;
1389:
1390: l_return :=
1391: pqp_gb_psi_functions.include_event(
1392: p_actual_date => l_tab_pay_proc_evnts(g_event_counter).actual_date
1393: ,p_effective_date => l_tab_pay_proc_evnts(g_event_counter).effective_date
1394: );
1395:
1491: l_proc_step := 110;
1492: DEBUG(l_proc_name, l_proc_step);
1493: END IF;
1494:
1495: IF pqp_gb_psi_functions.chk_is_employee_a_leaver(
1496: p_assignment_id => p_assignment_id
1497: ,p_effective_date => g_effective_date
1498: ,p_leaver_date => l_leaver_date
1499: ) = 'Y'
1594: IF g_business_group_id IS NULL
1595: THEN
1596: -- Always clear cache before proceeding to set globals
1597: clear_cache;
1598: g_debug := pqp_gb_psi_functions.check_debug(p_business_group_id);
1599: END IF; -- End if of g_business_group_id is Null check ...
1600:
1601: IF g_debug
1602: THEN
1619: DEBUG(l_proc_name, l_proc_step);
1620: END IF;
1621:
1622: -- set shared globals
1623: pqp_gb_psi_functions.set_shared_globals(
1624: p_business_group_id => p_business_group_id
1625: ,p_paypoint => g_paypoint
1626: ,p_cutover_date => g_cutover_date
1627: ,p_ext_dfn_id => g_ext_dfn_id
1651: DEBUG(l_proc_name, l_proc_step);
1652: END IF;
1653:
1654: -- Raise Extract Exceptions
1655: pqp_gb_psi_functions.raise_extract_exceptions('S');
1656: END IF; -- End if of business group id is null check ...
1657:
1658: g_start_date := NULL;
1659: g_end_date := NULL;
1668: DEBUG(l_proc_name, l_proc_step);
1669: END IF;
1670:
1671: l_include_flag :=
1672: pqp_gb_psi_functions.chk_penserver_basic_criteria(
1673: p_business_group_id => g_business_group_id
1674: ,p_effective_date => g_effective_date
1675: ,p_assignment_id => p_assignment_id
1676: ,p_person_dtl => g_person_dtl
1750: IF g_business_group_id IS NULL
1751: THEN
1752: -- Always clear cache before proceeding to set globals
1753: clear_cache;
1754: g_debug := pqp_gb_psi_functions.check_debug(p_business_group_id);
1755: END IF; -- End if of g_business_group_id is Null check ...
1756:
1757: IF g_debug
1758: THEN
1775: DEBUG(l_proc_name, l_proc_step);
1776: END IF;
1777:
1778: -- set shared globals
1779: pqp_gb_psi_functions.set_shared_globals(
1780: p_business_group_id => p_business_group_id
1781: ,p_paypoint => g_paypoint
1782: ,p_cutover_date => g_cutover_date
1783: ,p_ext_dfn_id => g_ext_dfn_id
1807: DEBUG(l_proc_name, l_proc_step);
1808: END IF;
1809:
1810: -- Raise Extract Exceptions
1811: pqp_gb_psi_functions.raise_extract_exceptions('S');
1812: END IF; -- End if of business group id is null check ...
1813:
1814: g_start_date := NULL;
1815: g_end_date := NULL;
1827: DEBUG(l_proc_name, l_proc_step);
1828: END IF;
1829:
1830: l_include_flag :=
1831: pqp_gb_psi_functions.chk_penserver_basic_criteria(
1832: p_business_group_id => g_business_group_id
1833: ,p_effective_date => g_effective_date
1834: ,p_assignment_id => p_assignment_id
1835: ,p_person_dtl => g_person_dtl
1861: THEN
1862: l_proc_step := 80;
1863: DEBUG(l_proc_name, l_proc_step);
1864: END IF;
1865: pqp_gb_psi_functions.process_retro_event;
1866: END IF;
1867: END IF; -- End if of l_include_flag = 'Y' check ...
1868:
1869: IF g_debug
1935: END IF;
1936:
1937: -- Raise data error
1938: l_value :=
1939: pqp_gb_psi_functions.raise_extract_error(
1940: p_error_number => 94479
1941: ,p_error_text => 'BEN_94479_EXT_PSI_REQ_FLD_MISS'
1942: ,p_token1 => 'Start Date'
1943: );
1958: END IF;
1959:
1960: -- Raise data error
1961: l_value :=
1962: pqp_gb_psi_functions.raise_extract_error(
1963: p_error_number => 94479
1964: ,p_error_text => 'BEN_94479_EXT_PSI_REQ_FLD_MISS'
1965: ,p_token1 => 'Part Time Hours'
1966: );
1979: END IF;
1980:
1981: -- Raise data error
1982: l_value :=
1983: pqp_gb_psi_functions.raise_extract_error(
1984: p_error_number => 94479
1985: ,p_error_text => 'BEN_94479_EXT_PSI_REQ_FLD_MISS'
1986: ,p_token1 => 'Full Time Hours'
1987: );
2038: l_proc_step := 10;
2039: debug_enter(l_proc_name);
2040: END IF;
2041:
2042: -- pqp_gb_psi_functions.raise_extract_exceptions('DE');
2043: pqp_gb_psi_functions.common_post_process(
2044: p_business_group_id => g_business_group_id
2045: );
2046:
2039: debug_enter(l_proc_name);
2040: END IF;
2041:
2042: -- pqp_gb_psi_functions.raise_extract_exceptions('DE');
2043: pqp_gb_psi_functions.common_post_process(
2044: p_business_group_id => g_business_group_id
2045: );
2046:
2047: IF g_debug