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.PQP_GB_PSI_SERVICE_HISTORY dependencies on PQP_GB_PSI_FUNCTIONS

Line 655: pqp_gb_psi_functions.raise_extract_error(

651: get_config_type_desc(p_config_type => 'PQP_GB_PENSERVER_SER_LVRSN_MAP');
652:
653: -- Raise data error
654: l_value :=
655: pqp_gb_psi_functions.raise_extract_error(
656: p_error_number => 94635
657: ,p_error_text => 'BEN_94635_EXT_PSI_MISS_LVRSN'
658: ,p_token1 => l_meaning
659: ,p_token2 => l_configuration_desc

Line 1145: pqp_gb_psi_functions.store_extract_exceptions(

1141: DEBUG('l_meaning: ' || l_meaning);
1142: END IF;
1143:
1144: -- Raise setup error
1145: pqp_gb_psi_functions.store_extract_exceptions(
1146: p_extract_type => 'SERVICE_HISTORY'
1147: ,p_error_number => 93774
1148: ,p_error_text => 'BEN_93774_EXT_PSI_NO_ABS_TYPE'
1149: ,p_token1 => l_configuration_desc

Line 1175: pqp_gb_psi_functions.store_extract_exceptions(

1171: DEBUG('l_meaning: ' || l_meaning);
1172: END IF;
1173:
1174: -- Raise setup error
1175: pqp_gb_psi_functions.store_extract_exceptions(
1176: p_extract_type => 'SERVICE_HISTORY'
1177: ,p_error_number => 93776
1178: ,p_error_text => 'BEN_93776_EXT_PSI_NO_ASG_STS'
1179: ,p_token1 => l_configuration_desc

Line 1243: pqp_gb_psi_functions.store_extract_exceptions(

1239:
1240: IF l_new_joiner = 'N' OR l_ret_break = 'N'
1241: THEN
1242: -- Raise a setup error
1243: pqp_gb_psi_functions.store_extract_exceptions(
1244: p_extract_type => 'SERVICE_HISTORY'
1245: ,p_error_number => 93777
1246: ,p_error_text => 'BEN_93777_EXT_PSI_SER_EVNT_MAP'
1247: ,p_token1 => l_configuration_desc

Line 1283: pqp_gb_psi_functions.store_extract_exceptions(

1279: debug('Missing Events: '|| l_miss_events);
1280: END IF;
1281:
1282: -- Raise a setup warning
1283: pqp_gb_psi_functions.store_extract_exceptions(
1284: p_extract_type => 'SERVICE_HISTORY'
1285: ,p_error_number => 94363
1286: ,p_error_text => 'BEN_94363_EXT_PSI_EVNT_MAP_WRN'
1287: ,p_token1 => l_configuration_desc

Line 1395: pqp_gb_psi_functions.store_extract_exceptions(

1391: THEN
1392: DEBUG('l_meaning: ' || l_meaning);
1393: END IF;
1394:
1395: pqp_gb_psi_functions.store_extract_exceptions(
1396: p_extract_type => 'SERVICE_HISTORY'
1397: ,p_error_number => 94364
1398: ,p_error_text => 'BEN_94364_EXT_PSI_DUP_EVNT_MAP'
1399: ,p_token1 => 'Absence Type'

Line 1495: pqp_gb_psi_functions.store_extract_exceptions(

1491: THEN
1492: DEBUG('l_meaning: ' || l_meaning);
1493: END IF;
1494:
1495: pqp_gb_psi_functions.store_extract_exceptions(
1496: p_extract_type => 'SERVICE_HISTORY'
1497: ,p_error_number => 94364
1498: ,p_error_text => 'BEN_94364_EXT_PSI_DUP_EVNT_MAP'
1499: ,p_token1 => 'Assignment Status'

Line 1593: IF pqp_gb_psi_functions.g_pension_scheme_mapping.COUNT = 0

1589: END IF;
1590:
1591: l_configuration_type := 'PQP_GB_PENSERV_SCHEME_MAP_INFO';
1592:
1593: IF pqp_gb_psi_functions.g_pension_scheme_mapping.COUNT = 0
1594: THEN
1595: pqp_utilities.get_config_type_values(
1596: p_configuration_type => l_configuration_type
1597: ,p_business_group_id => p_business_group_id

Line 1603: pqp_gb_psi_functions.g_pension_scheme_mapping;

1599: ,p_tab_config_values => l_tab_config_values
1600: );
1601: ELSE -- get it from cached collection
1602: l_tab_config_values :=
1603: pqp_gb_psi_functions.g_pension_scheme_mapping;
1604: END IF;
1605:
1606: IF g_debug
1607: THEN

Line 1736: pqp_gb_psi_functions.store_extract_exceptions(

1732:
1733: IF l_tab_config_values.COUNT = 0 THEN
1734:
1735: -- Raise setup error
1736: pqp_gb_psi_functions.store_extract_exceptions(
1737: p_extract_type => 'SERVICE_HISTORY'
1738: ,p_error_number => 92799
1739: ,p_error_text => 'BEN_92799_EXT_PSI_NO_CONFIG'
1740: ,p_token1 => 'Penserver Interface'

Line 1836: IF pqp_gb_psi_functions.g_assign_category_mapping.COUNT > 0

1832: END IF;
1833:
1834: l_configuration_type := 'PQP_GB_PENSERVER_EMPLYMT_TYPE';
1835:
1836: IF pqp_gb_psi_functions.g_assign_category_mapping.COUNT > 0
1837: THEN
1838: -- available from cache
1839: l_tab_config_values :=
1840: pqp_gb_psi_functions.g_assign_category_mapping;

Line 1840: pqp_gb_psi_functions.g_assign_category_mapping;

1836: IF pqp_gb_psi_functions.g_assign_category_mapping.COUNT > 0
1837: THEN
1838: -- available from cache
1839: l_tab_config_values :=
1840: pqp_gb_psi_functions.g_assign_category_mapping;
1841: ELSE -- not available so fetch it
1842: pqp_utilities.get_config_type_values(
1843: p_configuration_type => l_configuration_type
1844: ,p_business_group_id => g_business_group_id

Line 2287: pqp_gb_psi_functions.store_extract_exceptions(

2283:
2284: IF csr_get_event_group_info%NOTFOUND
2285: THEN
2286: -- Raise an error
2287: pqp_gb_psi_functions.store_extract_exceptions(
2288: p_extract_type => 'SERVICE_HISTORY'
2289: ,p_error_number => 94423
2290: ,p_error_text => 'BEN_94423_EXT_PSI_NO_EVNT_GRP'
2291: ,p_token1 => l_event_group(i)

Line 3508: IF pqp_gb_psi_functions.chk_is_employee_a_leaver(

3504:
3505: --For bug 7705147
3506: --Commented out the old logic for checking leaver
3507: /*
3508: IF pqp_gb_psi_functions.chk_is_employee_a_leaver(
3509: p_assignment_id => p_assignment_id
3510: ,p_effective_date => g_effective_date
3511: ,p_leaver_date => l_leaver_date
3512: ) = 'Y'

Line 4297: pqp_gb_psi_functions.raise_extract_error(

4293: THEN
4294: DEBUG('Raise Data Error: Leaving Reason Missing');
4295: END IF;
4296: l_value :=
4297: pqp_gb_psi_functions.raise_extract_error(
4298: p_error_number => 94479
4299: ,p_error_text => 'BEN_94479_EXT_PSI_REQ_FLD_MISS'
4300: ,p_token1 => 'Leaving Reason'
4301: );

Line 4320: pqp_gb_psi_functions.raise_extract_warning(

4316: DEBUG('Not a member of CS scheme');
4317: END IF;
4318:
4319: l_value :=
4320: pqp_gb_psi_functions.raise_extract_warning(
4321: p_error_number => 93775
4322: ,p_error_text => 'BEN_93775_EXT_PSI_NOT_PEN_MEMB'
4323: ,p_token1 => p_assignment_id
4324: ,p_token2 => fnd_date.date_to_displaydt(g_effective_date)

Line 4623: pqp_gb_psi_functions.g_effective_end_date

4619: SUBSTR(g_tab_event_map_cv(l_index).pcv_information1, 1, 1);
4620:
4621: IF l_rec_abs_dtls.date_end IS NOT NULL
4622: AND l_rec_abs_dtls.date_end <=
4623: pqp_gb_psi_functions.g_effective_end_date
4624: AND p_event_group_name = 'PQP_GB_PSI_SER_ABSENCES'
4625: THEN
4626: -- For Bug 5970465
4627: OPEN csr_get_term_date;

Line 5593: pqp_gb_psi_functions.g_effective_end_date

5589: IF g_tab_pen_ele_ids.EXISTS(l_rec_ele_ent_info.element_type_id)
5590: AND g_opt_out = 'Y'
5591: AND l_rec_ele_ent_info.effective_end_date <> hr_api.g_eot
5592: AND l_rec_ele_ent_info.effective_end_date <=
5593: pqp_gb_psi_functions.g_effective_end_date
5594: THEN
5595: -- Yes this is an end date event
5596: IF g_debug
5597: THEN

Line 5757: pqp_gb_psi_functions.g_effective_end_date

5753: fnd_date.canonical_to_date(l_rec_ele_ent_val.screen_entry_value);
5754:
5755: IF l_opt_out_date IS NOT NULL
5756: AND l_opt_out_date <=
5757: pqp_gb_psi_functions.g_effective_end_date
5758: THEN
5759: l_ser_start_date :=
5760: LEAST(
5761: l_opt_out_date

Line 6096: pqp_gb_psi_functions.include_event(

6092: DEBUG(l_proc_name, l_proc_step);
6093: END IF;
6094:
6095: l_return :=
6096: pqp_gb_psi_functions.include_event(
6097: p_actual_date => l_tab_pay_proc_evnts(g_event_counter).actual_date
6098: ,p_effective_date => l_tab_pay_proc_evnts(g_event_counter).effective_date
6099: );
6100:

Line 6322: pqp_gb_psi_functions.g_effective_end_date

6318: CLOSE csr_get_ser_details;
6319:
6320: IF l_rec_ser_details.actual_termination_date IS NOT NULL
6321: AND l_rec_ser_details.actual_termination_date <=
6322: pqp_gb_psi_functions.g_effective_end_date
6323: THEN
6324: IF g_debug
6325: THEN
6326: DEBUG(

Line 6390: pqp_gb_psi_functions.raise_extract_error(

6386: DEBUG('Raise Data Error: Leaving Reason Missing');
6387: END IF;
6388:
6389: l_value :=
6390: pqp_gb_psi_functions.raise_extract_error(
6391: p_error_number => 94479
6392: ,p_error_text => 'BEN_94479_EXT_PSI_REQ_FLD_MISS'
6393: ,p_token1 => 'Leaving Reason'
6394: );

Line 6492: IF pqp_gb_psi_functions.chk_is_employee_a_leaver(

6488: IF l_rec_ser_details.final_process_date=
6489: l_rec_ser_details.actual_termination_date
6490: THEN
6491: --report leaver event only if fpd is same as atd
6492: IF pqp_gb_psi_functions.chk_is_employee_a_leaver(
6493: p_assignment_id => p_assignment_id
6494: ,p_effective_date => g_effective_date
6495: ,p_leaver_date => l_leaver_date
6496: ) = 'Y'

Line 6534: IF pqp_gb_psi_functions.chk_is_employee_a_leaver(

6530:
6531: IF l_rec_ser_details.final_process_date=
6532: l_rec_ser_details.actual_termination_date THEN
6533: --report leaver event only if fpd is same as atd
6534: IF pqp_gb_psi_functions.chk_is_employee_a_leaver(
6535: p_assignment_id => p_assignment_id
6536: ,p_effective_date => g_effective_date
6537: ,p_leaver_date => l_leaver_date
6538: ) = 'Y'

Line 6792: pqp_gb_psi_functions.raise_extract_error(

6788: THEN
6789: DEBUG('Raise Data Error: Leaving Reason Missing');
6790: END IF;
6791: l_value :=
6792: pqp_gb_psi_functions.raise_extract_error(
6793: p_error_number => 94479
6794: ,p_error_text => 'BEN_94479_EXT_PSI_REQ_FLD_MISS'
6795: ,p_token1 => 'Leaving Reason'
6796: );

Line 6821: pqp_gb_psi_functions.raise_extract_warning(

6817: DEBUG('Not a member of CS scheme');
6818: END IF;
6819:
6820: l_value :=
6821: pqp_gb_psi_functions.raise_extract_warning(
6822: p_error_number => 93775
6823: ,p_error_text => 'BEN_93775_EXT_PSI_NOT_PEN_MEMB'
6824: ,p_token1 => p_assignment_id
6825: ,p_token2 => fnd_date.date_to_displaydt(g_effective_date)

Line 6943: g_debug := pqp_gb_psi_functions.check_debug(p_business_group_id);

6939: IF g_business_group_id IS NULL
6940: THEN
6941: -- Always clear cache before proceeding to set globals
6942: clear_cache;
6943: g_debug := pqp_gb_psi_functions.check_debug(p_business_group_id);
6944: -- -- set g_debug based on process definition configuration
6945: -- IF g_tab_prs_dfn_cv.COUNT = 0
6946: -- THEN
6947: -- fetch_process_defn_cv(p_business_group_id => p_business_group_id);

Line 6986: pqp_gb_psi_functions.set_shared_globals(

6982: DEBUG(l_proc_name, l_proc_step);
6983: END IF;
6984:
6985: -- set shared globals
6986: pqp_gb_psi_functions.set_shared_globals(
6987: p_business_group_id => p_business_group_id
6988: ,p_paypoint => g_paypoint
6989: ,p_cutover_date => g_cutover_date
6990: ,p_ext_dfn_id => g_ext_dfn_id

Line 7016: pqp_gb_psi_functions.raise_extract_exceptions('S');

7012: DEBUG(l_proc_name, l_proc_step);
7013: END IF;
7014:
7015: -- Raise Extract Exceptions
7016: pqp_gb_psi_functions.raise_extract_exceptions('S');
7017: END IF; -- End if of business group id is null check ...
7018:
7019: IF g_extract_type = 'PERIODIC'
7020: THEN

Line 7046: pqp_gb_psi_functions.chk_penserver_basic_criteria(

7042: DEBUG(l_proc_name, l_proc_step);
7043: END IF;
7044:
7045: l_include_flag :=
7046: pqp_gb_psi_functions.chk_penserver_basic_criteria(
7047: p_business_group_id => g_business_group_id
7048: ,p_effective_date => g_effective_date
7049: ,p_assignment_id => p_assignment_id
7050: ,p_person_dtl => g_person_dtl

Line 7111: pqp_gb_psi_functions.process_retro_event;

7107: -- DEBUG(l_proc_name, l_proc_step);
7108: -- DEBUG('Last Counter: ' || ben_ext_person.g_pay_proc_evt_tab.LAST);
7109: -- DEBUG('g_event_counter: ' || g_event_counter);
7110: -- END IF;
7111: pqp_gb_psi_functions.process_retro_event;
7112: -- END IF; -- End if of event counter is last check ...
7113: END IF; -- End if of g_extract_type = 'CUTOVER' check ...
7114: END IF; -- End if of l_include_flag = Y check ...
7115:

Line 7198: pqp_gb_psi_functions.raise_extract_error(

7194: END IF;
7195:
7196: -- Raise data error
7197: l_value :=
7198: pqp_gb_psi_functions.raise_extract_error(
7199: p_error_number => 94479
7200: ,p_error_text => 'BEN_94479_EXT_PSI_REQ_FLD_MISS'
7201: ,p_token1 => 'Start Date'
7202: );

Line 7221: pqp_gb_psi_functions.raise_extract_error(

7217: END IF;
7218:
7219: -- Raise data error
7220: l_value :=
7221: pqp_gb_psi_functions.raise_extract_error(
7222: p_error_number => 94479
7223: ,p_error_text => 'BEN_94479_EXT_PSI_REQ_FLD_MISS'
7224: ,p_token1 => 'End Date'
7225: );

Line 7241: pqp_gb_psi_functions.raise_extract_error(

7237: END IF;
7238:
7239: -- Raise data error
7240: l_value :=
7241: pqp_gb_psi_functions.raise_extract_error(
7242: p_error_number => 94479
7243: ,p_error_text => 'BEN_94479_EXT_PSI_REQ_FLD_MISS'
7244: ,p_token1 => 'Start Reason'
7245: );

Line 7260: pqp_gb_psi_functions.raise_extract_error(

7256: END IF;
7257:
7258: -- Raise data error
7259: l_value :=
7260: pqp_gb_psi_functions.raise_extract_error(
7261: p_error_number => 94479
7262: ,p_error_text => 'BEN_94479_EXT_PSI_REQ_FLD_MISS'
7263: ,p_token1 => 'Scheme Category'
7264: );

Line 7279: pqp_gb_psi_functions.raise_extract_error(

7275: END IF;
7276:
7277: -- Raise data error
7278: l_value :=
7279: pqp_gb_psi_functions.raise_extract_error(
7280: p_error_number => 94479
7281: ,p_error_text => 'BEN_94479_EXT_PSI_REQ_FLD_MISS'
7282: ,p_token1 => 'Scheme Status'
7283: );

Line 7299: pqp_gb_psi_functions.raise_extract_error(

7295: END IF;
7296:
7297: -- Raise data error
7298: l_value :=
7299: pqp_gb_psi_functions.raise_extract_error(
7300: p_error_number => 94479
7301: ,p_error_text => 'BEN_94479_EXT_PSI_REQ_FLD_MISS'
7302: ,p_token1 => 'End Reason'
7303: );

Line 7357: -- pqp_gb_psi_functions.raise_extract_exceptions('DE');

7353: l_proc_step := 10;
7354: debug_enter(l_proc_name);
7355: END IF;
7356:
7357: -- pqp_gb_psi_functions.raise_extract_exceptions('DE');
7358: pqp_gb_psi_functions.common_post_process(p_business_group_id => g_business_group_id);
7359:
7360: IF g_debug
7361: THEN

Line 7358: pqp_gb_psi_functions.common_post_process(p_business_group_id => g_business_group_id);

7354: debug_enter(l_proc_name);
7355: END IF;
7356:
7357: -- pqp_gb_psi_functions.raise_extract_exceptions('DE');
7358: pqp_gb_psi_functions.common_post_process(p_business_group_id => g_business_group_id);
7359:
7360: IF g_debug
7361: THEN
7362: l_proc_step := 20;