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 1139: pqp_gb_psi_functions.store_extract_exceptions(

1135: DEBUG('l_meaning: ' || l_meaning);
1136: END IF;
1137:
1138: -- Raise setup error
1139: pqp_gb_psi_functions.store_extract_exceptions(
1140: p_extract_type => 'SERVICE_HISTORY'
1141: ,p_error_number => 93774
1142: ,p_error_text => 'BEN_93774_EXT_PSI_NO_ABS_TYPE'
1143: ,p_token1 => l_configuration_desc

Line 1169: pqp_gb_psi_functions.store_extract_exceptions(

1165: DEBUG('l_meaning: ' || l_meaning);
1166: END IF;
1167:
1168: -- Raise setup error
1169: pqp_gb_psi_functions.store_extract_exceptions(
1170: p_extract_type => 'SERVICE_HISTORY'
1171: ,p_error_number => 93776
1172: ,p_error_text => 'BEN_93776_EXT_PSI_NO_ASG_STS'
1173: ,p_token1 => l_configuration_desc

Line 1237: pqp_gb_psi_functions.store_extract_exceptions(

1233:
1234: IF l_new_joiner = 'N' OR l_ret_break = 'N'
1235: THEN
1236: -- Raise a setup error
1237: pqp_gb_psi_functions.store_extract_exceptions(
1238: p_extract_type => 'SERVICE_HISTORY'
1239: ,p_error_number => 93777
1240: ,p_error_text => 'BEN_93777_EXT_PSI_SER_EVNT_MAP'
1241: ,p_token1 => l_configuration_desc

Line 1277: pqp_gb_psi_functions.store_extract_exceptions(

1273: debug('Missing Events: '|| l_miss_events);
1274: END IF;
1275:
1276: -- Raise a setup warning
1277: pqp_gb_psi_functions.store_extract_exceptions(
1278: p_extract_type => 'SERVICE_HISTORY'
1279: ,p_error_number => 94363
1280: ,p_error_text => 'BEN_94363_EXT_PSI_EVNT_MAP_WRN'
1281: ,p_token1 => l_configuration_desc

Line 1387: pqp_gb_psi_functions.store_extract_exceptions(

1383: THEN
1384: DEBUG('l_meaning: ' || l_meaning);
1385: END IF;
1386:
1387: pqp_gb_psi_functions.store_extract_exceptions(
1388: p_extract_type => 'SERVICE_HISTORY'
1389: ,p_error_number => 94364
1390: ,p_error_text => 'BEN_94364_EXT_PSI_DUP_EVNT_MAP'
1391: ,p_token1 => 'Absence Type'

Line 1487: pqp_gb_psi_functions.store_extract_exceptions(

1483: THEN
1484: DEBUG('l_meaning: ' || l_meaning);
1485: END IF;
1486:
1487: pqp_gb_psi_functions.store_extract_exceptions(
1488: p_extract_type => 'SERVICE_HISTORY'
1489: ,p_error_number => 94364
1490: ,p_error_text => 'BEN_94364_EXT_PSI_DUP_EVNT_MAP'
1491: ,p_token1 => 'Assignment Status'

Line 1575: IF pqp_gb_psi_functions.g_pension_scheme_mapping.COUNT = 0

1571: END IF;
1572:
1573: l_configuration_type := 'PQP_GB_PENSERV_SCHEME_MAP_INFO';
1574:
1575: IF pqp_gb_psi_functions.g_pension_scheme_mapping.COUNT = 0
1576: THEN
1577: pqp_utilities.get_config_type_values(
1578: p_configuration_type => l_configuration_type
1579: ,p_business_group_id => p_business_group_id

Line 1585: pqp_gb_psi_functions.g_pension_scheme_mapping;

1581: ,p_tab_config_values => l_tab_config_values
1582: );
1583: ELSE -- get it from cached collection
1584: l_tab_config_values :=
1585: pqp_gb_psi_functions.g_pension_scheme_mapping;
1586: END IF;
1587:
1588: IF g_debug
1589: THEN

Line 1718: pqp_gb_psi_functions.store_extract_exceptions(

1714:
1715: IF l_tab_config_values.COUNT = 0 THEN
1716:
1717: -- Raise setup error
1718: pqp_gb_psi_functions.store_extract_exceptions(
1719: p_extract_type => 'SERVICE_HISTORY'
1720: ,p_error_number => 92799
1721: ,p_error_text => 'BEN_92799_EXT_PSI_NO_CONFIG'
1722: ,p_token1 => 'Penserver Interface'

Line 1818: IF pqp_gb_psi_functions.g_assign_category_mapping.COUNT > 0

1814: END IF;
1815:
1816: l_configuration_type := 'PQP_GB_PENSERVER_EMPLYMT_TYPE';
1817:
1818: IF pqp_gb_psi_functions.g_assign_category_mapping.COUNT > 0
1819: THEN
1820: -- available from cache
1821: l_tab_config_values :=
1822: pqp_gb_psi_functions.g_assign_category_mapping;

Line 1822: pqp_gb_psi_functions.g_assign_category_mapping;

1818: IF pqp_gb_psi_functions.g_assign_category_mapping.COUNT > 0
1819: THEN
1820: -- available from cache
1821: l_tab_config_values :=
1822: pqp_gb_psi_functions.g_assign_category_mapping;
1823: ELSE -- not available so fetch it
1824: pqp_utilities.get_config_type_values(
1825: p_configuration_type => l_configuration_type
1826: ,p_business_group_id => g_business_group_id

Line 2269: pqp_gb_psi_functions.store_extract_exceptions(

2265:
2266: IF csr_get_event_group_info%NOTFOUND
2267: THEN
2268: -- Raise an error
2269: pqp_gb_psi_functions.store_extract_exceptions(
2270: p_extract_type => 'SERVICE_HISTORY'
2271: ,p_error_number => 94423
2272: ,p_error_text => 'BEN_94423_EXT_PSI_NO_EVNT_GRP'
2273: ,p_token1 => l_event_group(i)

Line 3474: IF pqp_gb_psi_functions.chk_is_employee_a_leaver(

3470: THEN
3471: l_ser_start_date := l_asg_start_date;
3472: END IF;
3473:
3474: IF pqp_gb_psi_functions.chk_is_employee_a_leaver(
3475: p_assignment_id => p_assignment_id
3476: ,p_effective_date => g_effective_date
3477: ,p_leaver_date => l_leaver_date
3478: ) = 'Y'

Line 4243: pqp_gb_psi_functions.raise_extract_error(

4239: THEN
4240: DEBUG('Raise Data Error: Leaving Reason Missing');
4241: END IF;
4242: l_value :=
4243: pqp_gb_psi_functions.raise_extract_error(
4244: p_error_number => 94479
4245: ,p_error_text => 'BEN_94479_EXT_PSI_REQ_FLD_MISS'
4246: ,p_token1 => 'Leaving Reason'
4247: );

Line 4266: pqp_gb_psi_functions.raise_extract_warning(

4262: DEBUG('Not a member of CS scheme');
4263: END IF;
4264:
4265: l_value :=
4266: pqp_gb_psi_functions.raise_extract_warning(
4267: p_error_number => 93775
4268: ,p_error_text => 'BEN_93775_EXT_PSI_NOT_PEN_MEMB'
4269: ,p_token1 => p_assignment_id
4270: ,p_token2 => fnd_date.date_to_displaydt(g_effective_date)

Line 4569: pqp_gb_psi_functions.g_effective_end_date

4565: SUBSTR(g_tab_event_map_cv(l_index).pcv_information1, 1, 1);
4566:
4567: IF l_rec_abs_dtls.date_end IS NOT NULL
4568: AND l_rec_abs_dtls.date_end <=
4569: pqp_gb_psi_functions.g_effective_end_date
4570: AND p_event_group_name = 'PQP_GB_PSI_SER_ABSENCES'
4571: THEN
4572: -- For Bug 5970465
4573: OPEN csr_get_term_date;

Line 5531: pqp_gb_psi_functions.g_effective_end_date

5527: IF g_tab_pen_ele_ids.EXISTS(l_rec_ele_ent_info.element_type_id)
5528: AND g_opt_out = 'Y'
5529: AND l_rec_ele_ent_info.effective_end_date <> hr_api.g_eot
5530: AND l_rec_ele_ent_info.effective_end_date <=
5531: pqp_gb_psi_functions.g_effective_end_date
5532: THEN
5533: -- Yes this is an end date event
5534: IF g_debug
5535: THEN

Line 5695: pqp_gb_psi_functions.g_effective_end_date

5691: fnd_date.canonical_to_date(l_rec_ele_ent_val.screen_entry_value);
5692:
5693: IF l_opt_out_date IS NOT NULL
5694: AND l_opt_out_date <=
5695: pqp_gb_psi_functions.g_effective_end_date
5696: THEN
5697: l_ser_start_date :=
5698: LEAST(
5699: l_opt_out_date

Line 6034: pqp_gb_psi_functions.include_event(

6030: DEBUG(l_proc_name, l_proc_step);
6031: END IF;
6032:
6033: l_return :=
6034: pqp_gb_psi_functions.include_event(
6035: p_actual_date => l_tab_pay_proc_evnts(g_event_counter).actual_date
6036: ,p_effective_date => l_tab_pay_proc_evnts(g_event_counter).effective_date
6037: );
6038:

Line 6260: pqp_gb_psi_functions.g_effective_end_date

6256: CLOSE csr_get_ser_details;
6257:
6258: IF l_rec_ser_details.actual_termination_date IS NOT NULL
6259: AND l_rec_ser_details.actual_termination_date <=
6260: pqp_gb_psi_functions.g_effective_end_date
6261: THEN
6262: IF g_debug
6263: THEN
6264: DEBUG(

Line 6328: pqp_gb_psi_functions.raise_extract_error(

6324: DEBUG('Raise Data Error: Leaving Reason Missing');
6325: END IF;
6326:
6327: l_value :=
6328: pqp_gb_psi_functions.raise_extract_error(
6329: p_error_number => 94479
6330: ,p_error_text => 'BEN_94479_EXT_PSI_REQ_FLD_MISS'
6331: ,p_token1 => 'Leaving Reason'
6332: );

Line 6412: IF pqp_gb_psi_functions.chk_is_employee_a_leaver(

6408: IF l_rec_ser_details.final_process_date=
6409: l_rec_ser_details.actual_termination_date
6410: THEN
6411: --report leaver event only if fpd is same as atd
6412: IF pqp_gb_psi_functions.chk_is_employee_a_leaver(
6413: p_assignment_id => p_assignment_id
6414: ,p_effective_date => g_effective_date
6415: ,p_leaver_date => l_leaver_date
6416: ) = 'Y'

Line 6454: IF pqp_gb_psi_functions.chk_is_employee_a_leaver(

6450:
6451: IF l_rec_ser_details.final_process_date=
6452: l_rec_ser_details.actual_termination_date THEN
6453: --report leaver event only if fpd is same as atd
6454: IF pqp_gb_psi_functions.chk_is_employee_a_leaver(
6455: p_assignment_id => p_assignment_id
6456: ,p_effective_date => g_effective_date
6457: ,p_leaver_date => l_leaver_date
6458: ) = 'Y'

Line 6712: pqp_gb_psi_functions.raise_extract_error(

6708: THEN
6709: DEBUG('Raise Data Error: Leaving Reason Missing');
6710: END IF;
6711: l_value :=
6712: pqp_gb_psi_functions.raise_extract_error(
6713: p_error_number => 94479
6714: ,p_error_text => 'BEN_94479_EXT_PSI_REQ_FLD_MISS'
6715: ,p_token1 => 'Leaving Reason'
6716: );

Line 6741: pqp_gb_psi_functions.raise_extract_warning(

6737: DEBUG('Not a member of CS scheme');
6738: END IF;
6739:
6740: l_value :=
6741: pqp_gb_psi_functions.raise_extract_warning(
6742: p_error_number => 93775
6743: ,p_error_text => 'BEN_93775_EXT_PSI_NOT_PEN_MEMB'
6744: ,p_token1 => p_assignment_id
6745: ,p_token2 => fnd_date.date_to_displaydt(g_effective_date)

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

6859: IF g_business_group_id IS NULL
6860: THEN
6861: -- Always clear cache before proceeding to set globals
6862: clear_cache;
6863: g_debug := pqp_gb_psi_functions.check_debug(p_business_group_id);
6864: -- -- set g_debug based on process definition configuration
6865: -- IF g_tab_prs_dfn_cv.COUNT = 0
6866: -- THEN
6867: -- fetch_process_defn_cv(p_business_group_id => p_business_group_id);

Line 6906: pqp_gb_psi_functions.set_shared_globals(

6902: DEBUG(l_proc_name, l_proc_step);
6903: END IF;
6904:
6905: -- set shared globals
6906: pqp_gb_psi_functions.set_shared_globals(
6907: p_business_group_id => p_business_group_id
6908: ,p_paypoint => g_paypoint
6909: ,p_cutover_date => g_cutover_date
6910: ,p_ext_dfn_id => g_ext_dfn_id

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

6932: DEBUG(l_proc_name, l_proc_step);
6933: END IF;
6934:
6935: -- Raise Extract Exceptions
6936: pqp_gb_psi_functions.raise_extract_exceptions('S');
6937: END IF; -- End if of business group id is null check ...
6938:
6939: IF g_extract_type = 'PERIODIC'
6940: THEN

Line 6966: pqp_gb_psi_functions.chk_penserver_basic_criteria(

6962: DEBUG(l_proc_name, l_proc_step);
6963: END IF;
6964:
6965: l_include_flag :=
6966: pqp_gb_psi_functions.chk_penserver_basic_criteria(
6967: p_business_group_id => g_business_group_id
6968: ,p_effective_date => g_effective_date
6969: ,p_assignment_id => p_assignment_id
6970: ,p_person_dtl => g_person_dtl

Line 7031: pqp_gb_psi_functions.process_retro_event;

7027: -- DEBUG(l_proc_name, l_proc_step);
7028: -- DEBUG('Last Counter: ' || ben_ext_person.g_pay_proc_evt_tab.LAST);
7029: -- DEBUG('g_event_counter: ' || g_event_counter);
7030: -- END IF;
7031: pqp_gb_psi_functions.process_retro_event;
7032: -- END IF; -- End if of event counter is last check ...
7033: END IF; -- End if of g_extract_type = 'CUTOVER' check ...
7034: END IF; -- End if of l_include_flag = Y check ...
7035:

Line 7118: pqp_gb_psi_functions.raise_extract_error(

7114: END IF;
7115:
7116: -- Raise data error
7117: l_value :=
7118: pqp_gb_psi_functions.raise_extract_error(
7119: p_error_number => 94479
7120: ,p_error_text => 'BEN_94479_EXT_PSI_REQ_FLD_MISS'
7121: ,p_token1 => 'Start Date'
7122: );

Line 7141: pqp_gb_psi_functions.raise_extract_error(

7137: END IF;
7138:
7139: -- Raise data error
7140: l_value :=
7141: pqp_gb_psi_functions.raise_extract_error(
7142: p_error_number => 94479
7143: ,p_error_text => 'BEN_94479_EXT_PSI_REQ_FLD_MISS'
7144: ,p_token1 => 'End Date'
7145: );

Line 7161: pqp_gb_psi_functions.raise_extract_error(

7157: END IF;
7158:
7159: -- Raise data error
7160: l_value :=
7161: pqp_gb_psi_functions.raise_extract_error(
7162: p_error_number => 94479
7163: ,p_error_text => 'BEN_94479_EXT_PSI_REQ_FLD_MISS'
7164: ,p_token1 => 'Start Reason'
7165: );

Line 7180: pqp_gb_psi_functions.raise_extract_error(

7176: END IF;
7177:
7178: -- Raise data error
7179: l_value :=
7180: pqp_gb_psi_functions.raise_extract_error(
7181: p_error_number => 94479
7182: ,p_error_text => 'BEN_94479_EXT_PSI_REQ_FLD_MISS'
7183: ,p_token1 => 'Scheme Category'
7184: );

Line 7199: pqp_gb_psi_functions.raise_extract_error(

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

Line 7219: pqp_gb_psi_functions.raise_extract_error(

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

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

7273: l_proc_step := 10;
7274: debug_enter(l_proc_name);
7275: END IF;
7276:
7277: -- pqp_gb_psi_functions.raise_extract_exceptions('DE');
7278: pqp_gb_psi_functions.common_post_process(p_business_group_id => g_business_group_id);
7279:
7280: IF g_debug
7281: THEN

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

7274: debug_enter(l_proc_name);
7275: END IF;
7276:
7277: -- pqp_gb_psi_functions.raise_extract_exceptions('DE');
7278: pqp_gb_psi_functions.common_post_process(p_business_group_id => g_business_group_id);
7279:
7280: IF g_debug
7281: THEN
7282: l_proc_step := 20;