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_PENSION_TYPES_API dependencies on FND_MESSAGE

Line 77: fnd_message.set_name('PQP', 'PQP_230805_EE_BAL_NAME_EXISTS');

73: Open csr_bal_name(c_balance_name => p_pension_type_name ||' EE Contribution');
74: Fetch csr_bal_name Into l_bal_name_exists;
75: If csr_bal_name%FOUND Then
76: close csr_bal_name;
77: fnd_message.set_name('PQP', 'PQP_230805_EE_BAL_NAME_EXISTS');
78: fnd_message.raise_error;
79: End If;
80: --
81: -- Get the currency code for the business group or leg code

Line 78: fnd_message.raise_error;

74: Fetch csr_bal_name Into l_bal_name_exists;
75: If csr_bal_name%FOUND Then
76: close csr_bal_name;
77: fnd_message.set_name('PQP', 'PQP_230805_EE_BAL_NAME_EXISTS');
78: fnd_message.raise_error;
79: End If;
80: --
81: -- Get the currency code for the business group or leg code
82: --

Line 92: fnd_message.set_name('PQP', 'PQP_230807_INV_BUSGRP_LEGCODE');

88: ElsIf p_legislation_code Is Not Null Then
89: l_currency_code := hr_general.default_currency_code(p_legislation_code);
90: l_legislation_code := p_legislation_code;
91: Else
92: fnd_message.set_name('PQP', 'PQP_230807_INV_BUSGRP_LEGCODE');
93: fnd_message.raise_error;
94: End If;
95:
96: If (l_legislation_code is Not Null and l_legislation_code = 'NL') Then

Line 93: fnd_message.raise_error;

89: l_currency_code := hr_general.default_currency_code(p_legislation_code);
90: l_legislation_code := p_legislation_code;
91: Else
92: fnd_message.set_name('PQP', 'PQP_230807_INV_BUSGRP_LEGCODE');
93: fnd_message.raise_error;
94: End If;
95:
96: If (l_legislation_code is Not Null and l_legislation_code = 'NL') Then
97: l_balance_cat_id := Null;

Line 258: fnd_message.set_name('PQP', 'PQP_230805_EE_BAL_NAME_EXISTS');

254: Open csr_bal_name(c_balance_name => p_pension_type_name ||' ER Contribution');
255: Fetch csr_bal_name Into l_bal_name_exists;
256: If csr_bal_name%FOUND Then
257: close csr_bal_name;
258: fnd_message.set_name('PQP', 'PQP_230805_EE_BAL_NAME_EXISTS');
259: fnd_message.raise_error;
260: End If;
261: --
262: -- Get the currency code for the business group or leg code

Line 259: fnd_message.raise_error;

255: Fetch csr_bal_name Into l_bal_name_exists;
256: If csr_bal_name%FOUND Then
257: close csr_bal_name;
258: fnd_message.set_name('PQP', 'PQP_230805_EE_BAL_NAME_EXISTS');
259: fnd_message.raise_error;
260: End If;
261: --
262: -- Get the currency code for the business group or leg code
263: --

Line 273: fnd_message.set_name('PQP', 'PQP_230807_INV_BUSGRP_LEGCODE');

269: ElsIf p_legislation_code Is Not Null Then
270: l_currency_code := hr_general.default_currency_code(p_legislation_code);
271: l_legislation_code := p_legislation_code;
272: Else
273: fnd_message.set_name('PQP', 'PQP_230807_INV_BUSGRP_LEGCODE');
274: fnd_message.raise_error;
275: End If;
276:
277: If (l_legislation_code is Not Null and l_legislation_code = 'NL') Then

Line 274: fnd_message.raise_error;

270: l_currency_code := hr_general.default_currency_code(p_legislation_code);
271: l_legislation_code := p_legislation_code;
272: Else
273: fnd_message.set_name('PQP', 'PQP_230807_INV_BUSGRP_LEGCODE');
274: fnd_message.raise_error;
275: End If;
276:
277: If (l_legislation_code is Not Null and l_legislation_code = 'NL') Then
278: l_balance_cat_id := Null;

Line 439: fnd_message.set_name('PQP', 'PQP_230805_EE_BAL_NAME_EXISTS');

435: Open csr_bal_name(c_balance_name => p_pension_type_name ||' EE Contribution');
436: Fetch csr_bal_name Into l_bal_name_exists;
437: If csr_bal_name%FOUND Then
438: close csr_bal_name;
439: fnd_message.set_name('PQP', 'PQP_230805_EE_BAL_NAME_EXISTS');
440: fnd_message.raise_error;
441: Else
442: close csr_bal_name;
443: Open csr_bal_name(c_balance_name => p_pension_type_name ||' ER Contribution');

Line 440: fnd_message.raise_error;

436: Fetch csr_bal_name Into l_bal_name_exists;
437: If csr_bal_name%FOUND Then
438: close csr_bal_name;
439: fnd_message.set_name('PQP', 'PQP_230805_EE_BAL_NAME_EXISTS');
440: fnd_message.raise_error;
441: Else
442: close csr_bal_name;
443: Open csr_bal_name(c_balance_name => p_pension_type_name ||' ER Contribution');
444: Fetch csr_bal_name Into l_bal_name_exists;

Line 447: fnd_message.set_name('PQP', 'PQP_230806_ER_BAL_NAME_EXISTS');

443: Open csr_bal_name(c_balance_name => p_pension_type_name ||' ER Contribution');
444: Fetch csr_bal_name Into l_bal_name_exists;
445: If csr_bal_name%FOUND Then
446: close csr_bal_name;
447: fnd_message.set_name('PQP', 'PQP_230806_ER_BAL_NAME_EXISTS');
448: fnd_message.raise_error;
449: End If;
450: close csr_bal_name;
451: End If;

Line 448: fnd_message.raise_error;

444: Fetch csr_bal_name Into l_bal_name_exists;
445: If csr_bal_name%FOUND Then
446: close csr_bal_name;
447: fnd_message.set_name('PQP', 'PQP_230806_ER_BAL_NAME_EXISTS');
448: fnd_message.raise_error;
449: End If;
450: close csr_bal_name;
451: End If;
452: --

Line 464: fnd_message.set_name('PQP', 'PQP_230807_INV_BUSGRP_LEGCODE');

460: ElsIf p_legislation_code Is Not Null Then
461: l_currency_code := hr_general.default_currency_code(p_legislation_code);
462: l_legislation_code := p_legislation_code;
463: Else
464: fnd_message.set_name('PQP', 'PQP_230807_INV_BUSGRP_LEGCODE');
465: fnd_message.raise_error;
466: End If;
467:
468: --

Line 465: fnd_message.raise_error;

461: l_currency_code := hr_general.default_currency_code(p_legislation_code);
462: l_legislation_code := p_legislation_code;
463: Else
464: fnd_message.set_name('PQP', 'PQP_230807_INV_BUSGRP_LEGCODE');
465: fnd_message.raise_error;
466: End If;
467:
468: --
469: --Get the balance category id for 'Other Deductions' category (UK pensions only)

Line 670: fnd_message.set_name('PQP', 'PQP_230807_INV_BUSGRP_LEGCODE');

666: ElsIf p_legislation_code Is Not Null Then
667: l_currency_code := hr_general.default_currency_code(p_legislation_code);
668: l_legislation_code := p_legislation_code;
669: Else
670: fnd_message.set_name('PQP', 'PQP_230807_INV_BUSGRP_LEGCODE');
671: fnd_message.raise_error;
672: End If;
673:
674: --

Line 671: fnd_message.raise_error;

667: l_currency_code := hr_general.default_currency_code(p_legislation_code);
668: l_legislation_code := p_legislation_code;
669: Else
670: fnd_message.set_name('PQP', 'PQP_230807_INV_BUSGRP_LEGCODE');
671: fnd_message.raise_error;
672: End If;
673:
674: --
675: -- These global variables would be used by other procedures

Line 1027: fnd_message.set_name('PQP', 'PQP_230922_PEN_TYPE_NAME_ERR');

1023:
1024: EXCEPTION
1025:
1026: WHEN OTHERS THEN
1027: fnd_message.set_name('PQP', 'PQP_230922_PEN_TYPE_NAME_ERR');
1028: fnd_message.raise_error;
1029:
1030: END chk_pension_type_name;
1031:

Line 1028: fnd_message.raise_error;

1024: EXCEPTION
1025:
1026: WHEN OTHERS THEN
1027: fnd_message.set_name('PQP', 'PQP_230922_PEN_TYPE_NAME_ERR');
1028: fnd_message.raise_error;
1029:
1030: END chk_pension_type_name;
1031:
1032: -- ----------------------------------------------------------------------------

Line 1057: fnd_message.set_name('PQP', 'PQP_230813_PEN_TYPE_EXISTS');

1053: OPEN csr_pension_type;
1054: FETCH csr_pension_type INTO l_dummy;
1055: IF csr_pension_type%FOUND THEN
1056: CLOSE csr_pension_type;
1057: fnd_message.set_name('PQP', 'PQP_230813_PEN_TYPE_EXISTS');
1058: fnd_message.raise_error;
1059: ELSE
1060: CLOSE csr_pension_type;
1061: END IF;

Line 1058: fnd_message.raise_error;

1054: FETCH csr_pension_type INTO l_dummy;
1055: IF csr_pension_type%FOUND THEN
1056: CLOSE csr_pension_type;
1057: fnd_message.set_name('PQP', 'PQP_230813_PEN_TYPE_EXISTS');
1058: fnd_message.raise_error;
1059: ELSE
1060: CLOSE csr_pension_type;
1061: END IF;
1062:

Line 1213: fnd_message.set_name('PQP', 'PQP_230892_PEN_TYPE_PERCNT_INV');

1209: if(p_salary_calculation_method = '3') then
1210: l_sum_percent := p_ee_contribution_percent + p_er_contribution_percent;
1211:
1212: if l_sum_percent Is Null then
1213: fnd_message.set_name('PQP', 'PQP_230892_PEN_TYPE_PERCNT_INV');
1214: fnd_message.raise_error;
1215: end if;
1216:
1217: if((l_sum_percent > 100) or (l_sum_percent < 100)) then

Line 1214: fnd_message.raise_error;

1210: l_sum_percent := p_ee_contribution_percent + p_er_contribution_percent;
1211:
1212: if l_sum_percent Is Null then
1213: fnd_message.set_name('PQP', 'PQP_230892_PEN_TYPE_PERCNT_INV');
1214: fnd_message.raise_error;
1215: end if;
1216:
1217: if((l_sum_percent > 100) or (l_sum_percent < 100)) then
1218: fnd_message.set_name('PQP', 'PQP_230892_PEN_TYPE_PERCNT_INV');

Line 1218: fnd_message.set_name('PQP', 'PQP_230892_PEN_TYPE_PERCNT_INV');

1214: fnd_message.raise_error;
1215: end if;
1216:
1217: if((l_sum_percent > 100) or (l_sum_percent < 100)) then
1218: fnd_message.set_name('PQP', 'PQP_230892_PEN_TYPE_PERCNT_INV');
1219: fnd_message.raise_error;
1220: end if;
1221:
1222: end if;

Line 1219: fnd_message.raise_error;

1215: end if;
1216:
1217: if((l_sum_percent > 100) or (l_sum_percent < 100)) then
1218: fnd_message.set_name('PQP', 'PQP_230892_PEN_TYPE_PERCNT_INV');
1219: fnd_message.raise_error;
1220: end if;
1221:
1222: end if;
1223:

Line 1231: fnd_message.set_name('PQP', 'PQP_230990_SAV_NULL_ANN_LIMITS');

1227: if (p_salary_calculation_method is Null and p_pension_category = 'S') then
1228:
1229: if(p_er_annual_limit is Null or p_ee_annual_limit is Null) then
1230:
1231: fnd_message.set_name('PQP', 'PQP_230990_SAV_NULL_ANN_LIMITS');
1232: fnd_message.raise_error;
1233:
1234: end if;
1235:

Line 1232: fnd_message.raise_error;

1228:
1229: if(p_er_annual_limit is Null or p_ee_annual_limit is Null) then
1230:
1231: fnd_message.set_name('PQP', 'PQP_230990_SAV_NULL_ANN_LIMITS');
1232: fnd_message.raise_error;
1233:
1234: end if;
1235:
1236: end if;

Line 1257: fnd_message.set_name('PQP','PQP_230069_PEN_SUB_CAT_REQ');

1253: --
1254: if p_special_pension_type_code IS NOT NULL THEN
1255: if p_special_pension_type_code IN('ABP','PGGM') THEN
1256: if p_pension_sub_category IS NULL THEN
1257: fnd_message.set_name('PQP','PQP_230069_PEN_SUB_CAT_REQ');
1258: fnd_message.raise_error;
1259: end if;
1260: end if;
1261: end if;

Line 1258: fnd_message.raise_error;

1254: if p_special_pension_type_code IS NOT NULL THEN
1255: if p_special_pension_type_code IN('ABP','PGGM') THEN
1256: if p_pension_sub_category IS NULL THEN
1257: fnd_message.set_name('PQP','PQP_230069_PEN_SUB_CAT_REQ');
1258: fnd_message.raise_error;
1259: end if;
1260: end if;
1261: end if;
1262:

Line 1271: fnd_message.set_name('PQP','PQP_230221_PGGM_INV_PERCENTAGE');

1267: IF p_special_pension_type_code IS NOT NULL THEN
1268: IF p_special_pension_type_code = 'PGGM' THEN
1269: IF nvl(p_er_contribution_percent,0) <
1270: nvl(p_ee_contribution_percent,0) THEN
1271: fnd_message.set_name('PQP','PQP_230221_PGGM_INV_PERCENTAGE');
1272: fnd_message.raise_error;
1273: END IF;
1274: END IF;
1275: END IF;

Line 1272: fnd_message.raise_error;

1268: IF p_special_pension_type_code = 'PGGM' THEN
1269: IF nvl(p_er_contribution_percent,0) <
1270: nvl(p_ee_contribution_percent,0) THEN
1271: fnd_message.set_name('PQP','PQP_230221_PGGM_INV_PERCENTAGE');
1272: fnd_message.raise_error;
1273: END IF;
1274: END IF;
1275: END IF;
1276:

Line 1895: fnd_message.set_name('PQP', 'PQP_230892_PEN_TYPE_PERCNT_INV');

1891: if(p_salary_calculation_method = '3') then
1892: l_sum_percent := p_ee_contribution_percent + p_er_contribution_percent;
1893:
1894: if l_sum_percent Is Null then
1895: fnd_message.set_name('PQP', 'PQP_230892_PEN_TYPE_PERCNT_INV');
1896: fnd_message.raise_error;
1897: end if;
1898:
1899: if((l_sum_percent > 100) or (l_sum_percent < 100)) then

Line 1896: fnd_message.raise_error;

1892: l_sum_percent := p_ee_contribution_percent + p_er_contribution_percent;
1893:
1894: if l_sum_percent Is Null then
1895: fnd_message.set_name('PQP', 'PQP_230892_PEN_TYPE_PERCNT_INV');
1896: fnd_message.raise_error;
1897: end if;
1898:
1899: if((l_sum_percent > 100) or (l_sum_percent < 100)) then
1900: fnd_message.set_name('PQP', 'PQP_230892_PEN_TYPE_PERCNT_INV');

Line 1900: fnd_message.set_name('PQP', 'PQP_230892_PEN_TYPE_PERCNT_INV');

1896: fnd_message.raise_error;
1897: end if;
1898:
1899: if((l_sum_percent > 100) or (l_sum_percent < 100)) then
1900: fnd_message.set_name('PQP', 'PQP_230892_PEN_TYPE_PERCNT_INV');
1901: fnd_message.raise_error;
1902: end if;
1903: end if;
1904:

Line 1901: fnd_message.raise_error;

1897: end if;
1898:
1899: if((l_sum_percent > 100) or (l_sum_percent < 100)) then
1900: fnd_message.set_name('PQP', 'PQP_230892_PEN_TYPE_PERCNT_INV');
1901: fnd_message.raise_error;
1902: end if;
1903: end if;
1904:
1905: -- check to see if the annual limits have been entered for Savings Pension Type

Line 1912: fnd_message.set_name('PQP', 'PQP_230990_SAV_NULL_ANN_LIMITS');

1908: if (p_salary_calculation_method is Null and p_pension_category = 'S') then
1909:
1910: if(p_er_annual_limit is Null or p_ee_annual_limit is Null) then
1911:
1912: fnd_message.set_name('PQP', 'PQP_230990_SAV_NULL_ANN_LIMITS');
1913: fnd_message.raise_error;
1914:
1915: end if;
1916:

Line 1913: fnd_message.raise_error;

1909:
1910: if(p_er_annual_limit is Null or p_ee_annual_limit is Null) then
1911:
1912: fnd_message.set_name('PQP', 'PQP_230990_SAV_NULL_ANN_LIMITS');
1913: fnd_message.raise_error;
1914:
1915: end if;
1916:
1917: end if;

Line 1940: fnd_message.set_name('PQP','PQP_230221_PGGM_INV_PERCENTAGE');

1936: IF p_special_pension_type_code IS NOT NULL THEN
1937: IF p_special_pension_type_code = 'PGGM' THEN
1938: IF nvl(p_er_contribution_percent,0) <
1939: nvl(p_ee_contribution_percent,0) THEN
1940: fnd_message.set_name('PQP','PQP_230221_PGGM_INV_PERCENTAGE');
1941: fnd_message.raise_error;
1942: END IF;
1943: END IF;
1944: END IF;

Line 1941: fnd_message.raise_error;

1937: IF p_special_pension_type_code = 'PGGM' THEN
1938: IF nvl(p_er_contribution_percent,0) <
1939: nvl(p_ee_contribution_percent,0) THEN
1940: fnd_message.set_name('PQP','PQP_230221_PGGM_INV_PERCENTAGE');
1941: fnd_message.raise_error;
1942: END IF;
1943: END IF;
1944: END IF;
1945:

Line 1956: fnd_message.set_name('PQP','PQP_230125_PT_UPD_NOT_ALLOWED');

1952: OPEN c_chk_scheme;
1953: FETCH c_chk_scheme INTO l_schm_exists;
1954: IF c_chk_scheme%FOUND THEN
1955: CLOSE c_chk_scheme;
1956: fnd_message.set_name('PQP','PQP_230125_PT_UPD_NOT_ALLOWED');
1957: fnd_message.raise_error;
1958: ELSE
1959: CLOSE c_chk_scheme;
1960: END IF;

Line 1957: fnd_message.raise_error;

1953: FETCH c_chk_scheme INTO l_schm_exists;
1954: IF c_chk_scheme%FOUND THEN
1955: CLOSE c_chk_scheme;
1956: fnd_message.set_name('PQP','PQP_230125_PT_UPD_NOT_ALLOWED');
1957: fnd_message.raise_error;
1958: ELSE
1959: CLOSE c_chk_scheme;
1960: END IF;
1961: END IF;