DBA Data[Home] [Help]

APPS.PQP_GB_PSI_EARNINGS_HISTORY dependencies on PQP_GB_PSI_FUNCTIONS

Line 438: pqp_gb_psi_functions.store_extract_exceptions(

434:
435: IF csr_get_iv_id%NOTFOUND
436: THEN
437: -- Raise setup error
438: pqp_gb_psi_functions.store_extract_exceptions(
439: p_extract_type => 'EARNINGS_HISTORY'
440: ,p_error_number => 92493
441: ,p_error_text => 'BEN_92493_EXT_PSI_NO_INPUT_VAL'
442: ,p_token1 => p_element_name

Line 596: pqp_gb_psi_functions.store_extract_exceptions(

592:
593: IF csr_get_eei_info%NOTFOUND
594: THEN
595: -- Raise setup error
596: pqp_gb_psi_functions.store_extract_exceptions(
597: p_extract_type => 'EARNINGS_HISTORY'
598: ,p_error_number => 92583
599: ,p_error_text => 'BEN_92583_EXT_PSI_NO_EEI_INFO'
600: ,p_token1 => g_tab_pen_ele_ids(p_element_type_id).element_name

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

751:
752: IF csr_get_aei_info%NOTFOUND
753: THEN
754: l_svpn_no := '01';
755: -- l_value := pqp_gb_psi_functions.raise_extract_warning(p_error_text => 'SPN not found');
756: /* -- Raise setup error
757: pqp_gb_psi_functions.store_extract_exceptions(
758: p_extract_type => 'EARNINGS_HISTORY'
759: ,p_error_number => 92583

Line 757: pqp_gb_psi_functions.store_extract_exceptions(

753: THEN
754: l_svpn_no := '01';
755: -- l_value := pqp_gb_psi_functions.raise_extract_warning(p_error_text => 'SPN not found');
756: /* -- Raise setup error
757: pqp_gb_psi_functions.store_extract_exceptions(
758: p_extract_type => 'EARNINGS_HISTORY'
759: ,p_error_number => 92583
760: ,p_error_text => 'BEN_92583_EXT_PSI_NO_EEI_INFO'
761: ,p_token1 => p_assignment_id

Line 1081: pqp_gb_psi_functions.store_extract_exceptions(

1077: or
1078: p_balance_name LIKE '%Added Years Family Benefit')
1079: THEN
1080: /* -- Raise setup error
1081: pqp_gb_psi_functions.store_extract_exceptions(
1082: p_extract_type => 'EARNINGS_HISTORY'
1083: ,p_error_number => 92642
1084: ,p_error_text => 'BEN_92642_EXT_PSI_BAL_NOTFOUND'
1085: ,p_token1 => p_balance_name

Line 1091: l_value := pqp_gb_psi_functions.raise_extract_error

1087: ,p_error_warning_flag => 'E'
1088: ); */
1089:
1090: -- For bug 7428527
1091: l_value := pqp_gb_psi_functions.raise_extract_error
1092: (p_error_number => 92642
1093: ,p_error_text => 'BEN_92642_EXT_PSI_BAL_NOTFOUND'
1094: ,p_token1 => p_balance_name
1095: );

Line 1181: pqp_gb_psi_functions.store_extract_exceptions(

1177:
1178: IF csr_get_bal_dimension_id%NOTFOUND
1179: THEN
1180: -- Raise setup error
1181: pqp_gb_psi_functions.store_extract_exceptions(
1182: p_extract_type => 'EARNINGS_HISTORY'
1183: ,p_error_number => 92766
1184: ,p_error_text => 'BEN_92766_EXT_PSI_NO_BAL_DIM'
1185: ,p_token1 => p_dimension_name

Line 1261: pqp_gb_psi_functions.store_extract_exceptions(

1257:
1258: IF csr_get_def_bal_id%NOTFOUND
1259: THEN
1260: -- Raise setup error
1261: pqp_gb_psi_functions.store_extract_exceptions(
1262: p_extract_type => 'EARNINGS_HISTORY'
1263: ,p_error_number => 92780
1264: ,p_error_text => 'BEN_92780_EXT_PSI_NO_DEF_BAL'
1265: ,p_token1 => p_balance_type_id

Line 1676: IF pqp_gb_psi_functions.g_pension_scheme_mapping.COUNT = 0

1672: END IF;
1673:
1674: l_configuration_type := 'PQP_GB_PENSERV_SCHEME_MAP_INFO';
1675:
1676: IF pqp_gb_psi_functions.g_pension_scheme_mapping.COUNT = 0
1677: THEN
1678: pqp_utilities.get_config_type_values(
1679: p_configuration_type => l_configuration_type
1680: ,p_business_group_id => p_business_group_id

Line 1686: pqp_gb_psi_functions.g_pension_scheme_mapping;

1682: ,p_tab_config_values => l_tab_config_values
1683: );
1684: ELSE -- get it from cached collection
1685: l_tab_config_values :=
1686: pqp_gb_psi_functions.g_pension_scheme_mapping;
1687: END IF;
1688:
1689: IF g_debug
1690: THEN

Line 1731: pqp_gb_psi_functions.store_extract_exceptions(

1727:
1728: IF l_tab_config_values.COUNT = 0
1729: THEN
1730: -- Raise setup error
1731: pqp_gb_psi_functions.store_extract_exceptions(
1732: p_extract_type => 'EARNINGS_HISTORY'
1733: ,p_error_number => 94268
1734: ,p_error_text => 'BEN_92799_EXT_PSI_NO_CONFIG'
1735: ,p_token1 => 'Penserver Interface'

Line 2608: pqp_gb_psi_functions.raise_extract_warning(

2604: IF l_ele_classification = 'Pre Tax Deductions'
2605: THEN
2606:
2607: l_value :=
2608: pqp_gb_psi_functions.raise_extract_warning(
2609: p_error_number => 94892
2610: ,p_error_text => 'BEN_94892_NO_AVC_CLASSIFIC'
2611: ,p_token1 => l_rec_avc_eei_info.eei_information1
2612: );

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

3319: IF g_business_group_id IS NULL
3320: THEN
3321: -- Always clear cache before proceeding to set globals
3322: clear_cache;
3323: g_debug := pqp_gb_psi_functions.check_debug(p_business_group_id);
3324: -- -- set g_debug based on process definition configuration
3325: -- IF g_tab_prs_dfn_cv.COUNT = 0
3326: -- THEN
3327: -- fetch_process_defn_cv(p_business_group_id => p_business_group_id);

Line 3374: pqp_gb_psi_functions.set_shared_globals(

3370: DEBUG(l_proc_name, l_proc_step);
3371: END IF;
3372:
3373: -- set shared globals
3374: pqp_gb_psi_functions.set_shared_globals(
3375: p_business_group_id => p_business_group_id
3376: ,p_paypoint => g_paypoint
3377: ,p_cutover_date => g_cutover_date
3378: ,p_ext_dfn_id => g_ext_dfn_id

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

3400: DEBUG(l_proc_name, l_proc_step);
3401: END IF;
3402:
3403: -- Raise Extract Exceptions
3404: pqp_gb_psi_functions.raise_extract_exceptions('S');
3405: END IF; -- End if of business group id is null check ...
3406:
3407: -- IF g_extract_type = 'PERIODIC' THEN
3408: -- g_effective_date := p_effective_date;

Line 3439: pqp_gb_psi_functions.chk_penserver_basic_criteria(

3435:
3436: g_person_dtl := NULL;
3437: g_assignment_dtl := NULL;
3438: l_include_flag :=
3439: pqp_gb_psi_functions.chk_penserver_basic_criteria(
3440: p_business_group_id => g_business_group_id
3441: ,p_effective_date => l_effective_end_date
3442: ,p_assignment_id => p_assignment_id
3443: ,p_person_dtl => g_person_dtl

Line 3486: pqp_gb_psi_functions.raise_extract_warning(

3482: DEBUG(l_proc_name, l_proc_step);
3483: END IF;
3484:
3485: l_value :=
3486: pqp_gb_psi_functions.raise_extract_warning(
3487: p_error_number => 93775
3488: ,p_error_text => 'BEN_93775_EXT_PSI_NOT_PEN_MEMB'
3489: ,p_token1 => p_assignment_id
3490: ,p_token2 => fnd_date.date_to_displaydt(g_effective_date)

Line 3630: pqp_gb_psi_functions.raise_extract_warning(

3626: );
3627: g_ni_ele_ent_details := l_rec_ele_ent_details;
3628: ELSE -- raise person data warning
3629: l_value :=
3630: pqp_gb_psi_functions.raise_extract_warning(
3631: p_error_number => 94480
3632: ,p_error_text => 'BEN_94480_EXT_PSI_NO_NI_ELEMT'
3633: ,p_token1 => p_assignment_id
3634: ,p_token2 => fnd_date.date_to_displaydt(g_effective_date)

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

6143: ELSE
6144: l_return_value := RPAD(' ', 12, ' ');
6145: END IF;
6146: ELSIF p_rule_parameter = 'Scheme' THEN
6147: l_return_value := TRIM(RPAD(pqp_gb_psi_functions.g_pension_scheme,4,' '));
6148:
6149: /* BEGIN For Nuvos */
6150:
6151: ELSIF p_rule_parameter = 'APAVC' AND g_check_balance = 'Y'

Line 6365: pqp_gb_psi_functions.raise_extract_error(

6361: DEBUG('Maximum length error');
6362: END IF;
6363:
6364: l_value :=
6365: pqp_gb_psi_functions.raise_extract_error(
6366: p_error_number => 94589
6367: ,p_error_text => 'BEN_94589_EXT_MAX_LENGTH_ERROR'
6368: ,p_token1 => l_field_name || ' '
6369: || TO_CHAR(l_earnings)

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

6420: l_proc_step := 10;
6421: debug_enter(l_proc_name);
6422: END IF;
6423:
6424: pqp_gb_psi_functions.raise_extract_exceptions('S');
6425: pqp_gb_psi_functions.common_post_process(p_business_group_id => g_business_group_id);
6426:
6427: IF g_debug
6428: THEN

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

6421: debug_enter(l_proc_name);
6422: END IF;
6423:
6424: pqp_gb_psi_functions.raise_extract_exceptions('S');
6425: pqp_gb_psi_functions.common_post_process(p_business_group_id => g_business_group_id);
6426:
6427: IF g_debug
6428: THEN
6429: l_proc_step := 20;