DBA Data[Home] [Help]

APPS.PQP_GB_PENSION_SCHEME_TEMPLATE dependencies on PQP_GB_PENSION_SCHEMES_V

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

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

Line 1868: => 'PQP_GB_PENSION_SCHEMES_V.SCHEME_PREFIX'

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

Line 2010: => 'PQP_GB_PENSION_SCHEMES_V.EMPLOYEE_DEDUCTION_METHOD'

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

Line 2034: => 'PQP_GB_PENSION_SCHEMES_V.EMPLOYEE_DEDUCTION_METHOD'

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

Line 2065: => 'PQP_GB_PENSION_SCHEMES_V.EMPLOYER_DEDUCTION_METHOD'

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

Line 2084: => 'PQP_GB_PENSION_SCHEMES_V.EMPLOYER_DEDUCTION_METHOD'

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

Line 2106: => 'PQP_GB_PENSION_SCHEMES_V.EMPLOYER_DEDUCTION_METHOD'

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

Line 2120: => 'PQP_GB_PENSION_SCHEMES_V.EMPLOYER_DEDUCTION_METHOD'

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

Line 2134: => 'PQP_GB_PENSION_SCHEMES_V.EMPLOYER_DEDUCTION_METHOD'

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

Line 3454: => 'PQP_GB_PENSION_SCHEMES_V.PENSION_SCHEME_NAME'

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

Line 3967: FROM pqp_gb_pension_schemes_v

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

Line 4019: => 'PQP_GB_PENSION_SCHEMES_V.EMPLOYEE_DEDUCTION_METHOD'

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

Line 4040: => 'PQP_GB_PENSION_SCHEMES_V.ELEMENT_TYPE_ID'

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