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

Line 358: pqp_gb_psi_functions.store_extract_exceptions(

354:
355: IF csr_get_iv_id%NOTFOUND
356: THEN
357: -- Raise setup error
358: pqp_gb_psi_functions.store_extract_exceptions(
359: p_extract_type => 'EARNINGS_HISTORY'
360: ,p_error_number => 92493
361: ,p_error_text => 'BEN_92493_EXT_PSI_NO_INPUT_VAL'
362: ,p_token1 => p_element_name

Line 516: pqp_gb_psi_functions.store_extract_exceptions(

512:
513: IF csr_get_eei_info%NOTFOUND
514: THEN
515: -- Raise setup error
516: pqp_gb_psi_functions.store_extract_exceptions(
517: p_extract_type => 'EARNINGS_HISTORY'
518: ,p_error_number => 92583
519: ,p_error_text => 'BEN_92583_EXT_PSI_NO_EEI_INFO'
520: ,p_token1 => g_tab_pen_ele_ids(p_element_type_id).element_name

Line 675: -- l_value := pqp_gb_psi_functions.raise_extract_warning(p_error_text => 'SPN not found');

671:
672: IF csr_get_aei_info%NOTFOUND
673: THEN
674: l_svpn_no := '01';
675: -- l_value := pqp_gb_psi_functions.raise_extract_warning(p_error_text => 'SPN not found');
676: /* -- Raise setup error
677: pqp_gb_psi_functions.store_extract_exceptions(
678: p_extract_type => 'EARNINGS_HISTORY'
679: ,p_error_number => 92583

Line 677: pqp_gb_psi_functions.store_extract_exceptions(

673: THEN
674: l_svpn_no := '01';
675: -- l_value := pqp_gb_psi_functions.raise_extract_warning(p_error_text => 'SPN not found');
676: /* -- Raise setup error
677: pqp_gb_psi_functions.store_extract_exceptions(
678: p_extract_type => 'EARNINGS_HISTORY'
679: ,p_error_number => 92583
680: ,p_error_text => 'BEN_92583_EXT_PSI_NO_EEI_INFO'
681: ,p_token1 => p_assignment_id

Line 964: pqp_gb_psi_functions.store_extract_exceptions(

960: or
961: p_balance_name LIKE '%Added Years Family Benefit')
962: THEN
963: -- Raise setup error
964: pqp_gb_psi_functions.store_extract_exceptions(
965: p_extract_type => 'EARNINGS_HISTORY'
966: ,p_error_number => 92642
967: ,p_error_text => 'BEN_92642_EXT_PSI_BAL_NOTFOUND'
968: ,p_token1 => p_balance_name

Line 1056: pqp_gb_psi_functions.store_extract_exceptions(

1052:
1053: IF csr_get_bal_dimension_id%NOTFOUND
1054: THEN
1055: -- Raise setup error
1056: pqp_gb_psi_functions.store_extract_exceptions(
1057: p_extract_type => 'EARNINGS_HISTORY'
1058: ,p_error_number => 92766
1059: ,p_error_text => 'BEN_92766_EXT_PSI_NO_BAL_DIM'
1060: ,p_token1 => p_dimension_name

Line 1136: pqp_gb_psi_functions.store_extract_exceptions(

1132:
1133: IF csr_get_def_bal_id%NOTFOUND
1134: THEN
1135: -- Raise setup error
1136: pqp_gb_psi_functions.store_extract_exceptions(
1137: p_extract_type => 'EARNINGS_HISTORY'
1138: ,p_error_number => 92780
1139: ,p_error_text => 'BEN_92780_EXT_PSI_NO_DEF_BAL'
1140: ,p_token1 => p_balance_type_id

Line 1551: IF pqp_gb_psi_functions.g_pension_scheme_mapping.COUNT = 0

1547: END IF;
1548:
1549: l_configuration_type := 'PQP_GB_PENSERV_SCHEME_MAP_INFO';
1550:
1551: IF pqp_gb_psi_functions.g_pension_scheme_mapping.COUNT = 0
1552: THEN
1553: pqp_utilities.get_config_type_values(
1554: p_configuration_type => l_configuration_type
1555: ,p_business_group_id => p_business_group_id

Line 1561: pqp_gb_psi_functions.g_pension_scheme_mapping;

1557: ,p_tab_config_values => l_tab_config_values
1558: );
1559: ELSE -- get it from cached collection
1560: l_tab_config_values :=
1561: pqp_gb_psi_functions.g_pension_scheme_mapping;
1562: END IF;
1563:
1564: IF g_debug
1565: THEN

Line 1606: pqp_gb_psi_functions.store_extract_exceptions(

1602:
1603: IF l_tab_config_values.COUNT = 0
1604: THEN
1605: -- Raise setup error
1606: pqp_gb_psi_functions.store_extract_exceptions(
1607: p_extract_type => 'EARNINGS_HISTORY'
1608: ,p_error_number => 94268
1609: ,p_error_text => 'BEN_92799_EXT_PSI_NO_CONFIG'
1610: ,p_token1 => 'Penserver Interface'

Line 2452: pqp_gb_psi_functions.raise_extract_warning(

2448: IF l_ele_classification = 'Pre Tax Deductions'
2449: THEN
2450:
2451: l_value :=
2452: pqp_gb_psi_functions.raise_extract_warning(
2453: p_error_number => 94892
2454: ,p_error_text => 'BEN_94892_NO_AVC_CLASSIFIC'
2455: ,p_token1 => l_rec_avc_eei_info.eei_information1
2456: );

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

3143: IF g_business_group_id IS NULL
3144: THEN
3145: -- Always clear cache before proceeding to set globals
3146: clear_cache;
3147: g_debug := pqp_gb_psi_functions.check_debug(p_business_group_id);
3148: -- -- set g_debug based on process definition configuration
3149: -- IF g_tab_prs_dfn_cv.COUNT = 0
3150: -- THEN
3151: -- fetch_process_defn_cv(p_business_group_id => p_business_group_id);

Line 3198: pqp_gb_psi_functions.set_shared_globals(

3194: DEBUG(l_proc_name, l_proc_step);
3195: END IF;
3196:
3197: -- set shared globals
3198: pqp_gb_psi_functions.set_shared_globals(
3199: p_business_group_id => p_business_group_id
3200: ,p_paypoint => g_paypoint
3201: ,p_cutover_date => g_cutover_date
3202: ,p_ext_dfn_id => g_ext_dfn_id

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

3224: DEBUG(l_proc_name, l_proc_step);
3225: END IF;
3226:
3227: -- Raise Extract Exceptions
3228: pqp_gb_psi_functions.raise_extract_exceptions('S');
3229: END IF; -- End if of business group id is null check ...
3230:
3231: -- IF g_extract_type = 'PERIODIC' THEN
3232: -- g_effective_date := p_effective_date;

Line 3263: pqp_gb_psi_functions.chk_penserver_basic_criteria(

3259:
3260: g_person_dtl := NULL;
3261: g_assignment_dtl := NULL;
3262: l_include_flag :=
3263: pqp_gb_psi_functions.chk_penserver_basic_criteria(
3264: p_business_group_id => g_business_group_id
3265: ,p_effective_date => l_effective_end_date
3266: ,p_assignment_id => p_assignment_id
3267: ,p_person_dtl => g_person_dtl

Line 3310: pqp_gb_psi_functions.raise_extract_warning(

3306: DEBUG(l_proc_name, l_proc_step);
3307: END IF;
3308:
3309: l_value :=
3310: pqp_gb_psi_functions.raise_extract_warning(
3311: p_error_number => 93775
3312: ,p_error_text => 'BEN_93775_EXT_PSI_NOT_PEN_MEMB'
3313: ,p_token1 => p_assignment_id
3314: ,p_token2 => fnd_date.date_to_displaydt(g_effective_date)

Line 3439: pqp_gb_psi_functions.raise_extract_warning(

3435: );
3436: g_ni_ele_ent_details := l_rec_ele_ent_details;
3437: ELSE -- raise person data warning
3438: l_value :=
3439: pqp_gb_psi_functions.raise_extract_warning(
3440: p_error_number => 94480
3441: ,p_error_text => 'BEN_94480_EXT_PSI_NO_NI_ELEMT'
3442: ,p_token1 => p_assignment_id
3443: ,p_token2 => fnd_date.date_to_displaydt(g_effective_date)

Line 5677: l_return_value := TRIM(RPAD(pqp_gb_psi_functions.g_pension_scheme,4,' '));

5673: ELSE
5674: l_return_value := RPAD(' ', 12, ' ');
5675: END IF;
5676: ELSIF p_rule_parameter = 'Scheme' THEN
5677: l_return_value := TRIM(RPAD(pqp_gb_psi_functions.g_pension_scheme,4,' '));
5678:
5679: /* BEGIN For Nuvos */
5680:
5681: ELSIF p_rule_parameter = 'APAVC'

Line 5878: pqp_gb_psi_functions.raise_extract_error(

5874: DEBUG('Maximum length error');
5875: END IF;
5876:
5877: l_value :=
5878: pqp_gb_psi_functions.raise_extract_error(
5879: p_error_number => 94589
5880: ,p_error_text => 'BEN_94589_EXT_MAX_LENGTH_ERROR'
5881: ,p_token1 => l_field_name || ' '
5882: || TO_CHAR(l_earnings)

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

5933: l_proc_step := 10;
5934: debug_enter(l_proc_name);
5935: END IF;
5936:
5937: pqp_gb_psi_functions.raise_extract_exceptions('S');
5938: pqp_gb_psi_functions.common_post_process(p_business_group_id => g_business_group_id);
5939:
5940: IF g_debug
5941: THEN

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

5934: debug_enter(l_proc_name);
5935: END IF;
5936:
5937: pqp_gb_psi_functions.raise_extract_exceptions('S');
5938: pqp_gb_psi_functions.common_post_process(p_business_group_id => g_business_group_id);
5939:
5940: IF g_debug
5941: THEN
5942: l_proc_step := 20;