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_STH_HISTORY dependencies on PQP_GB_PSI_FUNCTIONS

Line 402: PQP_GB_PSI_FUNCTIONS.store_extract_exceptions

398: -- bug abcedfg
399:
400: -- raise error that the element type has no claim date
401: debug('ERROR: No Claim Date for element type: '||l_element_names(l_index),40);
402: PQP_GB_PSI_FUNCTIONS.store_extract_exceptions
403: (p_extract_type => 'SHORT-TIME HOURS HISTORY'
404: ,p_error_number => 94502
405: ,p_error_text => 'BEN_94502_NO_CLAIM_DATE_IV'
406: ,p_token1 => l_element_name

Line 421: PQP_GB_PSI_FUNCTIONS.store_extract_exceptions

417: nvl(g_adj_hrs_source,' ') <> 'BALANCE' )
418: THEN
419: -- raise error that the element type has no adjusted hours
420: debug('ERROR: No Adjusted Hours for element type: '||l_element_names(l_index),40);
421: PQP_GB_PSI_FUNCTIONS.store_extract_exceptions
422: (p_extract_type => 'SHORT-TIME HOURS HISTORY'
423: ,p_error_number => 94503
424: ,p_error_text => 'BEN_94503_NO_ADJ_HOURS_IV'
425: ,p_token1 => l_element_name

Line 460: PQP_GB_PSI_FUNCTIONS.store_extract_exceptions

456: ELSE
457: debug('Element Type '||l_element_name||' does NOT Qualify initial check',40);
458: IF l_ele_proc_type = 'R' THEN
459: debug('WARNING: Element Type '||l_element_name||' is recurring element');
460: PQP_GB_PSI_FUNCTIONS.store_extract_exceptions
461: (p_extract_type => 'SHORT-TIME HOURS HISTORY'
462: ,p_error_number => 94529
463: ,p_error_text => 'BEN_94529_REC_STH_ELEMENT'
464: ,p_token1 => l_element_name

Line 508: PQP_GB_PSI_FUNCTIONS.store_extract_exceptions

504: l_claim_date_exists := TRUE;
505: -- error on the data type of the claim date
506: l_err_claim_date := TRUE;
507: debug('ERROR: Invalid Claim Date for element type: '||l_element_names(l_index),30);
508: PQP_GB_PSI_FUNCTIONS.store_extract_exceptions
509: (p_extract_type => 'SHORT-TIME HOURS HISTORY'
510: ,p_error_number => 94504
511: ,p_error_text => 'BEN_94504_ERR_CLAIM_DATE_IV'
512: ,p_token1 => l_element_names(l_index)

Line 544: PQP_GB_PSI_FUNCTIONS.store_extract_exceptions

540: l_adj_hours_exists := TRUE;
541: -- error on the data type of the claim date
542: l_err_adj_hours := TRUE;
543: debug('ERROR: Invalid Adjusted Hours for element type: '||l_element_names(l_index),30);
544: PQP_GB_PSI_FUNCTIONS.store_extract_exceptions
545: (p_extract_type => 'SHORT-TIME HOURS HISTORY'
546: ,p_error_number => 94505
547: ,p_error_text => 'BEN_94505_ERR_ADJ_HOURS_IV'
548: ,p_token1 => l_element_names(l_index)

Line 624: PQP_GB_PSI_FUNCTIONS.store_extract_exceptions

620:
621: IF g_adj_hrs_source = 'BALANCE'
622: AND g_adj_hrs_bal_type IS NULL THEN
623: debug('ERROR: No value provided for balance type.',30);
624: PQP_GB_PSI_FUNCTIONS.store_extract_exceptions
625: (p_extract_type => 'SHORT-TIME HOURS HISTORY'
626: ,p_error_number => 94632
627: ,p_error_text => 'BEN_94632_NO_ADJ_HRS_BAL_TYPE'
628: ,p_error_warning_flag => 'E'

Line 634: PQP_GB_PSI_FUNCTIONS.store_extract_exceptions

630: END IF;
631: ELSE
632: debug('Configration value is nto present',20);
633: -- raise error
634: PQP_GB_PSI_FUNCTIONS.store_extract_exceptions
635: (p_extract_type => 'SHORT-TIME HOURS HISTORY'
636: ,p_error_number => 94633
637: ,p_error_text => 'BEN_94633_NO_ADJ_HRS_CONFIG'
638: ,p_error_warning_flag => 'E'

Line 821: g_person_id := PQP_GB_PSI_FUNCTIONS.get_current_extract_person

817:
818: -- set global assignment_id
819: g_assignment_id := p_assignment_id;
820: debug('g_assignment_id: '||g_assignment_id,10);
821: g_person_id := PQP_GB_PSI_FUNCTIONS.get_current_extract_person
822: (
823: p_assignment_id => p_assignment_id
824: );
825:

Line 870: l_temp := PQP_GB_PSI_FUNCTIONS.raise_extract_error

866:
867: IF round(p_adj_hours,2) > +99999999.99 OR p_adj_hours < -99999999.99 THEN
868: -- raise ERROR
869: debug('ERROR: Adjusted hours is not in the range of -99999999.99 to +99999999.99',30);
870: l_temp := PQP_GB_PSI_FUNCTIONS.raise_extract_error
871: (p_error_number => 94538
872: ,p_error_text => 'BEN_94538_INV_ADJ_HOURS'
873: ,p_token1 => SUBSTR(p_element_name
874: ||'('||p_element_entry_id||')',1,80)

Line 930: l_return := PQP_GB_PSI_FUNCTIONS.raise_extract_warning

926: CLOSE csr_get_fte_value;
927:
928: IF l_fte_value IS NULL THEN
929: debug('WARNING: No FTE Value');
930: l_return := PQP_GB_PSI_FUNCTIONS.raise_extract_warning
931: (p_error_number => 94515
932: ,p_error_text => 'BEN_94515_NO_FTE_VALUE'
933: ,p_token1 => to_char(p_claim_date,'dd/mm/yyyy')
934: ,p_token2 => SUBSTR(g_curr_element_type_name

Line 940: l_return := PQP_GB_PSI_FUNCTIONS.raise_extract_warning

936: );
937:
938: ElSIF l_fte_value >= 1 THEN
939: debug('WARNING: Full Timer');
940: l_return := PQP_GB_PSI_FUNCTIONS.raise_extract_warning
941: (p_error_number => 94516
942: ,p_error_text => 'BEN_94516_STH_FULL_TIMER'
943: ,p_token1 => to_char(p_claim_date,'dd/mm/yyyy')
944: ,p_token2 => SUBSTR(g_curr_element_type_name

Line 1136: IF pqp_gb_psi_functions.is_proper_claim_date(l_claim_date_dt

1132: l_claim_date_no := fnd_number.canonical_to_number(TO_CHAR(l_claim_date_dt,'ddmmyyyy'));
1133:
1134:
1135:
1136: IF pqp_gb_psi_functions.is_proper_claim_date(l_claim_date_dt
1137: ,g_curr_element_type_name
1138: ,g_curr_element_entry_id
1139: ,g_assg_start_date) THEN
1140:

Line 1168: l_return := PQP_GB_PSI_FUNCTIONS.raise_extract_error

1164: END IF;--IF g_current_layout = 'SINGLE'
1165: ELSE
1166: debug('ERROR: the claim date is already reported by element entry id: '
1167: ||g_reported_claim_dates(l_claim_date_no));
1168: l_return := PQP_GB_PSI_FUNCTIONS.raise_extract_error
1169: (p_error_number => 94514
1170: ,p_error_text => 'BEN_94514_DUP_CLAIM_DATE'
1171: ,p_token1 => to_date(l_claim_date_dt,'dd/mm/yyyy')
1172: ,p_token2 => SUBSTR(g_curr_element_type_name

Line 1265: PQP_GB_PSI_FUNCTIONS.set_shared_globals

1261: OR p_business_group_id <> nvl(g_business_group_id,0) THEN
1262:
1263: g_business_group_id := p_business_group_id;
1264:
1265: PQP_GB_PSI_FUNCTIONS.set_shared_globals
1266: (p_business_group_id => p_business_group_id
1267: ,p_paypoint => g_paypoint
1268: ,p_cutover_date => l_cutover_date
1269: ,p_ext_dfn_id => g_ext_dfn_id

Line 1284: PQP_GB_PSI_FUNCTIONS.store_extract_exceptions

1280: debug('Count of valid elements: '||g_valid_element_type_details.COUNT,20);
1281: ELSE
1282: --raise error saying that there are no valid elements
1283: debug('ERROR: No Valid Elements',30);
1284: PQP_GB_PSI_FUNCTIONS.store_extract_exceptions
1285: (p_extract_type => 'SHORT-TIME HOURS HISTORY'
1286: ,p_error_number => 94506
1287: ,p_error_text => 'BEN_94506_NO_VALID_STH_ELEMENT'
1288: ,p_error_warning_flag => 'E'

Line 1297: PQP_GB_PSI_FUNCTIONS.raise_extract_exceptions('S');

1293:
1294:
1295: --Raise extract exceptions which are stored while checking for the setup
1296: debug('Raising the set-up errors, with input parameter as S',10);
1297: PQP_GB_PSI_FUNCTIONS.raise_extract_exceptions('S');
1298: END IF; --IF g_business_group_id IS NULL
1299:
1300: IF l_include = 'N' THEN
1301: debug('Returning : '||l_include,20);

Line 1312: l_include := PQP_GB_PSI_FUNCTIONS.chk_penserver_basic_criteria

1308: OR p_assignment_id <> nvl(g_assignment_id,0) )
1309: OR nvl(g_adj_hrs_source,' ') = 'BALANCE' THEN
1310:
1311: -- if adj hrs source is balance or fro a new assignment
1312: l_include := PQP_GB_PSI_FUNCTIONS.chk_penserver_basic_criteria
1313: (p_business_group_id => p_business_group_id
1314: ,p_effective_date => p_effective_date
1315: ,p_assignment_id => p_assignment_id
1316: ,p_person_dtl => g_curr_person_dtls

Line 1377: l_include := pqp_gb_psi_functions.include_event

1373: debug('actual_date :'||to_char(g_pay_proc_evt_tab(l_curr_evt_index).actual_date,'DD/MM/YYYY'),20);
1374: debug('----------');
1375:
1376: debug('Calling the common include event proc');
1377: l_include := pqp_gb_psi_functions.include_event
1378: (p_actual_date => g_pay_proc_evt_tab(l_curr_evt_index).actual_date
1379: ,p_effective_date => g_pay_proc_evt_tab(l_curr_evt_index).effective_date
1380: ,p_run_from_cutover_date => 'Y' ---- Bugfix 4969368
1381: );

Line 1390: pqp_gb_psi_functions.process_retro_event(l_include);

1386: --current event is not accepted
1387: l_include := 'N';
1388: END IF;
1389:
1390: pqp_gb_psi_functions.process_retro_event(l_include);
1391:
1392: debug('Returning : '||l_include,10);
1393: debug_exit(l_proc);
1394: return l_include;

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

1428: IF g_business_group_id IS NULL
1429: OR p_business_group_id <> nvl(g_business_group_id,0) THEN
1430:
1431: -- set the global debug value
1432: g_debug := pqp_gb_psi_functions.check_debug(p_business_group_id);
1433: debug_enter(l_proc);
1434: END IF;
1435: l_return := short_time_hours_criteria
1436: (

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

1478: IF g_business_group_id IS NULL
1479: OR p_business_group_id <> nvl(g_business_group_id,0) THEN
1480:
1481: -- set the global debug value
1482: g_debug := pqp_gb_psi_functions.check_debug(p_business_group_id);
1483: debug_enter(l_proc);
1484: END IF;
1485:
1486: l_return := short_time_hours_criteria

Line 1540: l_return := PQP_GB_PSI_FUNCTIONS.raise_extract_error

1536:
1537: IF g_effective_date IS NULL THEN
1538: p_output_value := NULL;
1539: debug('ERROR: No Claim Date for the element entry');
1540: l_return := PQP_GB_PSI_FUNCTIONS.raise_extract_error
1541: (p_error_number => 94507
1542: ,p_error_text => 'BEN_94507_NO_CLAIM_DATE_SIN'
1543: ,p_token1 => SUBSTR(g_curr_element_type_name
1544: ||'('||ben_ext_person.g_chg_surrogate_key||')',1,80)

Line 1588: l_return := PQP_GB_PSI_FUNCTIONS.raise_extract_error

1584: debug('Last event on the current person');
1585: IF g_start_date IS NULL THEN
1586: p_output_value := NULL;
1587: --raise error
1588: l_return := PQP_GB_PSI_FUNCTIONS.raise_extract_error
1589: (p_error_number => 94509
1590: ,p_error_text => 'BEN_94509_NO_START_END_DATE'
1591: );
1592: ELSE

Line 1747: l_return := PQP_GB_PSI_FUNCTIONS.raise_extract_error

1743: debug('Last event on the current person');
1744: IF g_adjusted_hours IS NULL THEN
1745: p_output_value := NULL;
1746: --raise error
1747: l_return := PQP_GB_PSI_FUNCTIONS.raise_extract_error
1748: (p_error_number => 94510
1749: ,p_error_text => 'BEN_94510_NO_ADJ_HRS_ACC'
1750: );
1751: ELSE

Line 1763: l_return := PQP_GB_PSI_FUNCTIONS.raise_extract_error

1759: END IF;
1760: END IF;
1761: IF g_current_layout = 'SINGLE' AND p_output_value IS NULL THEN
1762: -- raise error
1763: l_return := PQP_GB_PSI_FUNCTIONS.raise_extract_error
1764: (p_error_number => 94511
1765: ,p_error_text => 'BEN_94511_NO_ADJ_HRS_SIN'
1766: ,p_token1 => SUBSTR(g_curr_element_type_name
1767: ||'('||ben_ext_person.g_chg_surrogate_key||')',1,80)

Line 1877: --PQP_GB_PSI_FUNCTIONS.raise_extract_exceptions();

1873: BEGIN
1874: debug_enter(l_proc);
1875:
1876: --Raise extract exceptions which are stored while processing the data elements
1877: --PQP_GB_PSI_FUNCTIONS.raise_extract_exceptions();
1878:
1879: PQP_GB_PSI_FUNCTIONS.common_post_process(g_business_group_id);
1880:
1881: debug_exit(l_proc);

Line 1879: PQP_GB_PSI_FUNCTIONS.common_post_process(g_business_group_id);

1875:
1876: --Raise extract exceptions which are stored while processing the data elements
1877: --PQP_GB_PSI_FUNCTIONS.raise_extract_exceptions();
1878:
1879: PQP_GB_PSI_FUNCTIONS.common_post_process(g_business_group_id);
1880:
1881: debug_exit(l_proc);
1882: return 'Y';
1883: EXCEPTION