DBA Data[Home] [Help]

APPS.PQP_GB_PENSION_SCHEME_TEMPLATE dependencies on PQP_GB_PENSION_SCHEMES_V

Line 1333: -- => 'PQP_GB_PENSION_SCHEMES_V.SCON'

1329: -- -- Raise an error
1330: -- fnd_message.set_name ('PQP', 'PQP_230983_PEN_SCON_ECON_NULL');
1331: -- hr_multi_message.add
1332: -- (p_associated_column4
1333: -- => 'PQP_GB_PENSION_SCHEMES_V.SCON'
1334: -- );
1335: -- END IF; -- End if of scon or econ is null check ...
1336: END IF; -- End if of pension scheme type specified check ...
1337:

Line 1866: => 'PQP_GB_PENSION_SCHEMES_V.SCHEME_PREFIX'

1862: fnd_message.set_token ('BASE_NAME', p_ele_base_name);
1863: CLOSE csr_chk_uniq_base_name;
1864: hr_multi_message.add
1865: (p_associated_column4
1866: => 'PQP_GB_PENSION_SCHEMES_V.SCHEME_PREFIX'
1867: );
1868: END IF; -- End if of base name row found check...
1869:
1870: IF csr_chk_uniq_base_name%ISOPEN THEN

Line 2008: => 'PQP_GB_PENSION_SCHEMES_V.EMPLOYEE_DEDUCTION_METHOD'

2004: ,g_tab_pension_types_info (p_pension_type_id).pension_type_name
2005: );
2006: hr_multi_message.add
2007: (p_associated_column2
2008: => 'PQP_GB_PENSION_SCHEMES_V.EMPLOYEE_DEDUCTION_METHOD'
2009: );
2010: END IF; -- End if of pension type support FR deduction method check ...
2011:
2012: l_emp_deduction_method := 'PE';

Line 2032: => 'PQP_GB_PENSION_SCHEMES_V.EMPLOYEE_DEDUCTION_METHOD'

2028: ,g_tab_pension_types_info (p_pension_type_id).pension_type_name
2029: );
2030: hr_multi_message.add
2031: (p_associated_column2
2032: => 'PQP_GB_PENSION_SCHEMES_V.EMPLOYEE_DEDUCTION_METHOD'
2033: );
2034: END IF; -- End if of pension type support FR deduction method check ...
2035:
2036: l_exc_ees_cram_rule_id := NULL;

Line 2063: => 'PQP_GB_PENSION_SCHEMES_V.EMPLOYER_DEDUCTION_METHOD'

2059: ,g_tab_pension_types_info (p_pension_type_id).pension_type_name
2060: );
2061: hr_multi_message.add
2062: (p_associated_column3
2063: => 'PQP_GB_PENSION_SCHEMES_V.EMPLOYER_DEDUCTION_METHOD'
2064: );
2065:
2066: END IF; -- End if of pension type support % deduction method check ...
2067:

Line 2082: => 'PQP_GB_PENSION_SCHEMES_V.EMPLOYER_DEDUCTION_METHOD'

2078: ,g_tab_pension_types_info (p_pension_type_id).pension_type_name
2079: );
2080: hr_multi_message.add
2081: (p_associated_column3
2082: => 'PQP_GB_PENSION_SCHEMES_V.EMPLOYER_DEDUCTION_METHOD'
2083: );
2084: END IF; -- End if of pension type support FR deduction method check ...
2085:
2086: l_exc_ers_fxd_rule_id := NULL;

Line 2104: => 'PQP_GB_PENSION_SCHEMES_V.EMPLOYER_DEDUCTION_METHOD'

2100: ,g_tab_pension_types_info (p_pension_type_id).pension_type_name
2101: );
2102: hr_multi_message.add
2103: (p_associated_column3
2104: => 'PQP_GB_PENSION_SCHEMES_V.EMPLOYER_DEDUCTION_METHOD'
2105: );
2106: END IF; -- End if of pension type support % and FR deduction method check ...
2107:
2108: IF g_tab_pension_types_info (p_pension_type_id).er_contribution_fixed_rate IS NULL

Line 2118: => 'PQP_GB_PENSION_SCHEMES_V.EMPLOYER_DEDUCTION_METHOD'

2114: ,g_tab_pension_types_info (p_pension_type_id).pension_type_name
2115: );
2116: hr_multi_message.add
2117: (p_associated_column3
2118: => 'PQP_GB_PENSION_SCHEMES_V.EMPLOYER_DEDUCTION_METHOD'
2119: );
2120: END IF; -- End if of fixed rate is null check ...
2121:
2122: IF g_tab_pension_types_info (p_pension_type_id).er_contribution_percent IS NULL

Line 2132: => 'PQP_GB_PENSION_SCHEMES_V.EMPLOYER_DEDUCTION_METHOD'

2128: ,g_tab_pension_types_info (p_pension_type_id).pension_type_name
2129: );
2130: hr_multi_message.add
2131: (p_associated_column3
2132: => 'PQP_GB_PENSION_SCHEMES_V.EMPLOYER_DEDUCTION_METHOD'
2133: );
2134: END IF; -- End if of percentage is null check ...
2135:
2136: l_exc_ers_cent_rule_id := NULL;

Line 3452: => 'PQP_GB_PENSION_SCHEMES_V.PENSION_SCHEME_NAME'

3448: CLOSE csr_chk_uniq_sch_name;
3449: fnd_message.set_name ('PQP', 'PQP_230924_SCHEME_NAME_ERR');
3450: hr_multi_message.add
3451: (p_associated_column1
3452: => 'PQP_GB_PENSION_SCHEMES_V.PENSION_SCHEME_NAME'
3453: );
3454: END IF; -- End if of csr uniq row found check ...
3455:
3456: IF csr_chk_uniq_sch_name%ISOPEN THEN

Line 3964: FROM pqp_gb_pension_schemes_v

3960: IS
3961: SELECT 'X'
3962: FROM DUAL
3963: WHERE EXISTS ( SELECT 1
3964: FROM pqp_gb_pension_schemes_v
3965: WHERE ( associated_ocp_ele_type_id IS NOT NULL
3966: AND associated_ocp_ele_type_id =
3967: p_element_type_id
3968: )

Line 4016: => 'PQP_GB_PENSION_SCHEMES_V.EMPLOYEE_DEDUCTION_METHOD'

4012: CLOSE csr_chk_fr_exists;
4013: fnd_message.set_name ('PQP', 'PQP_230981_PEN_FR_DED_EXISTS');
4014: hr_multi_message.add
4015: (p_associated_column1
4016: => 'PQP_GB_PENSION_SCHEMES_V.EMPLOYEE_DEDUCTION_METHOD'
4017: );
4018: END IF; -- End if of fr deduction method exist check ...
4019:
4020: IF csr_chk_fr_exists%ISOPEN THEN

Line 4037: => 'PQP_GB_PENSION_SCHEMES_V.ELEMENT_TYPE_ID'

4033: CLOSE csr_chk_ocp_asoc_avc;
4034: fnd_message.set_name ('PQP', 'PQP_230945_PEN_AVC_CHILD_EXIST');
4035: hr_multi_message.add
4036: (p_associated_column2
4037: => 'PQP_GB_PENSION_SCHEMES_V.ELEMENT_TYPE_ID'
4038: );
4039: END IF; -- End if of ocp associated with AVC check ...
4040:
4041: IF csr_chk_ocp_asoc_avc%ISOPEN THEN