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 79: fnd_message.set_name('PQP', 'PQP_230805_EE_BAL_NAME_EXISTS');

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

Line 80: fnd_message.raise_error;

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

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

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

Line 95: fnd_message.raise_error;

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

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

270: Open csr_bal_name(c_balance_name => p_pension_type_name ||' ER Contribution');
271: Fetch csr_bal_name Into l_bal_name_exists;
272: If csr_bal_name%FOUND Then
273: close csr_bal_name;
274: fnd_message.set_name('PQP', 'PQP_230805_EE_BAL_NAME_EXISTS');
275: fnd_message.raise_error;
276: End If;
277: --
278: -- Get the currency code for the business group or leg code

Line 275: fnd_message.raise_error;

271: Fetch csr_bal_name Into l_bal_name_exists;
272: If csr_bal_name%FOUND Then
273: close csr_bal_name;
274: fnd_message.set_name('PQP', 'PQP_230805_EE_BAL_NAME_EXISTS');
275: fnd_message.raise_error;
276: End If;
277: --
278: -- Get the currency code for the business group or leg code
279: --

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

285: ElsIf p_legislation_code Is Not Null Then
286: l_currency_code := hr_general.default_currency_code(p_legislation_code);
287: l_legislation_code := p_legislation_code;
288: Else
289: fnd_message.set_name('PQP', 'PQP_230807_INV_BUSGRP_LEGCODE');
290: fnd_message.raise_error;
291: End If;
292:
293: If (l_legislation_code is Not Null and l_legislation_code = 'NL') Then

Line 290: fnd_message.raise_error;

286: l_currency_code := hr_general.default_currency_code(p_legislation_code);
287: l_legislation_code := p_legislation_code;
288: Else
289: fnd_message.set_name('PQP', 'PQP_230807_INV_BUSGRP_LEGCODE');
290: fnd_message.raise_error;
291: End If;
292:
293: If (l_legislation_code is Not Null and l_legislation_code = 'NL') Then
294: l_balance_cat_id := Null;

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

465: Open csr_bal_name(c_balance_name => p_pension_type_name ||' EE Contribution');
466: Fetch csr_bal_name Into l_bal_name_exists;
467: If csr_bal_name%FOUND Then
468: close csr_bal_name;
469: fnd_message.set_name('PQP', 'PQP_230805_EE_BAL_NAME_EXISTS');
470: fnd_message.raise_error;
471: Else
472: close csr_bal_name;
473: Open csr_bal_name(c_balance_name => p_pension_type_name ||' ER Contribution');

Line 470: fnd_message.raise_error;

466: Fetch csr_bal_name Into l_bal_name_exists;
467: If csr_bal_name%FOUND Then
468: close csr_bal_name;
469: fnd_message.set_name('PQP', 'PQP_230805_EE_BAL_NAME_EXISTS');
470: fnd_message.raise_error;
471: Else
472: close csr_bal_name;
473: Open csr_bal_name(c_balance_name => p_pension_type_name ||' ER Contribution');
474: Fetch csr_bal_name Into l_bal_name_exists;

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

473: Open csr_bal_name(c_balance_name => p_pension_type_name ||' ER Contribution');
474: Fetch csr_bal_name Into l_bal_name_exists;
475: If csr_bal_name%FOUND Then
476: close csr_bal_name;
477: fnd_message.set_name('PQP', 'PQP_230806_ER_BAL_NAME_EXISTS');
478: fnd_message.raise_error;
479: End If;
480: close csr_bal_name;
481: End If;

Line 478: fnd_message.raise_error;

474: Fetch csr_bal_name Into l_bal_name_exists;
475: If csr_bal_name%FOUND Then
476: close csr_bal_name;
477: fnd_message.set_name('PQP', 'PQP_230806_ER_BAL_NAME_EXISTS');
478: fnd_message.raise_error;
479: End If;
480: close csr_bal_name;
481: End If;
482: --

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

490: ElsIf p_legislation_code Is Not Null Then
491: l_currency_code := hr_general.default_currency_code(p_legislation_code);
492: l_legislation_code := p_legislation_code;
493: Else
494: fnd_message.set_name('PQP', 'PQP_230807_INV_BUSGRP_LEGCODE');
495: fnd_message.raise_error;
496: End If;
497:
498: --

Line 495: fnd_message.raise_error;

491: l_currency_code := hr_general.default_currency_code(p_legislation_code);
492: l_legislation_code := p_legislation_code;
493: Else
494: fnd_message.set_name('PQP', 'PQP_230807_INV_BUSGRP_LEGCODE');
495: fnd_message.raise_error;
496: End If;
497:
498: --
499: --Get the balance category id for 'Other Deductions' category (UK pensions only)

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

728: ElsIf p_legislation_code Is Not Null Then
729: l_currency_code := hr_general.default_currency_code(p_legislation_code);
730: l_legislation_code := p_legislation_code;
731: Else
732: fnd_message.set_name('PQP', 'PQP_230807_INV_BUSGRP_LEGCODE');
733: fnd_message.raise_error;
734: End If;
735:
736: --

Line 733: fnd_message.raise_error;

729: l_currency_code := hr_general.default_currency_code(p_legislation_code);
730: l_legislation_code := p_legislation_code;
731: Else
732: fnd_message.set_name('PQP', 'PQP_230807_INV_BUSGRP_LEGCODE');
733: fnd_message.raise_error;
734: End If;
735:
736: --
737: -- These global variables would be used by other procedures

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

1092:
1093: EXCEPTION
1094:
1095: WHEN OTHERS THEN
1096: fnd_message.set_name('PQP', 'PQP_230922_PEN_TYPE_NAME_ERR');
1097: fnd_message.raise_error;
1098:
1099: END chk_pension_type_name;
1100:

Line 1097: fnd_message.raise_error;

1093: EXCEPTION
1094:
1095: WHEN OTHERS THEN
1096: fnd_message.set_name('PQP', 'PQP_230922_PEN_TYPE_NAME_ERR');
1097: fnd_message.raise_error;
1098:
1099: END chk_pension_type_name;
1100:
1101: -- ----------------------------------------------------------------------------

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

1122: OPEN csr_pension_type;
1123: FETCH csr_pension_type INTO l_dummy;
1124: IF csr_pension_type%FOUND THEN
1125: CLOSE csr_pension_type;
1126: fnd_message.set_name('PQP', 'PQP_230813_PEN_TYPE_EXISTS');
1127: fnd_message.raise_error;
1128: ELSE
1129: CLOSE csr_pension_type;
1130: END IF;

Line 1127: fnd_message.raise_error;

1123: FETCH csr_pension_type INTO l_dummy;
1124: IF csr_pension_type%FOUND THEN
1125: CLOSE csr_pension_type;
1126: fnd_message.set_name('PQP', 'PQP_230813_PEN_TYPE_EXISTS');
1127: fnd_message.raise_error;
1128: ELSE
1129: CLOSE csr_pension_type;
1130: END IF;
1131:

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

1278: if(p_salary_calculation_method = '3') then
1279: l_sum_percent := p_ee_contribution_percent + p_er_contribution_percent;
1280:
1281: if l_sum_percent Is Null then
1282: fnd_message.set_name('PQP', 'PQP_230892_PEN_TYPE_PERCNT_INV');
1283: fnd_message.raise_error;
1284: end if;
1285:
1286: if((l_sum_percent > 100) or (l_sum_percent < 100)) then

Line 1283: fnd_message.raise_error;

1279: l_sum_percent := p_ee_contribution_percent + p_er_contribution_percent;
1280:
1281: if l_sum_percent Is Null then
1282: fnd_message.set_name('PQP', 'PQP_230892_PEN_TYPE_PERCNT_INV');
1283: fnd_message.raise_error;
1284: end if;
1285:
1286: if((l_sum_percent > 100) or (l_sum_percent < 100)) then
1287: fnd_message.set_name('PQP', 'PQP_230892_PEN_TYPE_PERCNT_INV');

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

1283: fnd_message.raise_error;
1284: end if;
1285:
1286: if((l_sum_percent > 100) or (l_sum_percent < 100)) then
1287: fnd_message.set_name('PQP', 'PQP_230892_PEN_TYPE_PERCNT_INV');
1288: fnd_message.raise_error;
1289: end if;
1290:
1291: end if;

Line 1288: fnd_message.raise_error;

1284: end if;
1285:
1286: if((l_sum_percent > 100) or (l_sum_percent < 100)) then
1287: fnd_message.set_name('PQP', 'PQP_230892_PEN_TYPE_PERCNT_INV');
1288: fnd_message.raise_error;
1289: end if;
1290:
1291: end if;
1292:

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

1296: if (p_salary_calculation_method is Null and p_pension_category = 'S') then
1297:
1298: if(p_er_annual_limit is Null or p_ee_annual_limit is Null) then
1299:
1300: fnd_message.set_name('PQP', 'PQP_230990_SAV_NULL_ANN_LIMITS');
1301: fnd_message.raise_error;
1302:
1303: end if;
1304:

Line 1301: fnd_message.raise_error;

1297:
1298: if(p_er_annual_limit is Null or p_ee_annual_limit is Null) then
1299:
1300: fnd_message.set_name('PQP', 'PQP_230990_SAV_NULL_ANN_LIMITS');
1301: fnd_message.raise_error;
1302:
1303: end if;
1304:
1305: end if;

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

1322: --
1323: if p_special_pension_type_code IS NOT NULL THEN
1324: if p_special_pension_type_code IN('ABP','PGGM') THEN
1325: if p_pension_sub_category IS NULL THEN
1326: fnd_message.set_name('PQP','PQP_230069_PEN_SUB_CAT_REQ');
1327: fnd_message.raise_error;
1328: end if;
1329: end if;
1330: end if;

Line 1327: fnd_message.raise_error;

1323: if p_special_pension_type_code IS NOT NULL THEN
1324: if p_special_pension_type_code IN('ABP','PGGM') THEN
1325: if p_pension_sub_category IS NULL THEN
1326: fnd_message.set_name('PQP','PQP_230069_PEN_SUB_CAT_REQ');
1327: fnd_message.raise_error;
1328: end if;
1329: end if;
1330: end if;
1331:

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

1336: IF p_special_pension_type_code IS NOT NULL THEN
1337: IF p_special_pension_type_code = 'PGGM' THEN
1338: IF nvl(p_er_contribution_percent,0) <
1339: nvl(p_ee_contribution_percent,0) THEN
1340: fnd_message.set_name('PQP','PQP_230221_PGGM_INV_PERCENTAGE');
1341: fnd_message.raise_error;
1342: END IF;
1343: END IF;
1344: END IF;

Line 1341: fnd_message.raise_error;

1337: IF p_special_pension_type_code = 'PGGM' THEN
1338: IF nvl(p_er_contribution_percent,0) <
1339: nvl(p_ee_contribution_percent,0) THEN
1340: fnd_message.set_name('PQP','PQP_230221_PGGM_INV_PERCENTAGE');
1341: fnd_message.raise_error;
1342: END IF;
1343: END IF;
1344: END IF;
1345:

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

1964: if(p_salary_calculation_method = '3') then
1965: l_sum_percent := p_ee_contribution_percent + p_er_contribution_percent;
1966:
1967: if l_sum_percent Is Null then
1968: fnd_message.set_name('PQP', 'PQP_230892_PEN_TYPE_PERCNT_INV');
1969: fnd_message.raise_error;
1970: end if;
1971:
1972: if((l_sum_percent > 100) or (l_sum_percent < 100)) then

Line 1969: fnd_message.raise_error;

1965: l_sum_percent := p_ee_contribution_percent + p_er_contribution_percent;
1966:
1967: if l_sum_percent Is Null then
1968: fnd_message.set_name('PQP', 'PQP_230892_PEN_TYPE_PERCNT_INV');
1969: fnd_message.raise_error;
1970: end if;
1971:
1972: if((l_sum_percent > 100) or (l_sum_percent < 100)) then
1973: fnd_message.set_name('PQP', 'PQP_230892_PEN_TYPE_PERCNT_INV');

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

1969: fnd_message.raise_error;
1970: end if;
1971:
1972: if((l_sum_percent > 100) or (l_sum_percent < 100)) then
1973: fnd_message.set_name('PQP', 'PQP_230892_PEN_TYPE_PERCNT_INV');
1974: fnd_message.raise_error;
1975: end if;
1976: end if;
1977:

Line 1974: fnd_message.raise_error;

1970: end if;
1971:
1972: if((l_sum_percent > 100) or (l_sum_percent < 100)) then
1973: fnd_message.set_name('PQP', 'PQP_230892_PEN_TYPE_PERCNT_INV');
1974: fnd_message.raise_error;
1975: end if;
1976: end if;
1977:
1978: -- check to see if the annual limits have been entered for Savings Pension Type

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

1981: if (p_salary_calculation_method is Null and p_pension_category = 'S') then
1982:
1983: if(p_er_annual_limit is Null or p_ee_annual_limit is Null) then
1984:
1985: fnd_message.set_name('PQP', 'PQP_230990_SAV_NULL_ANN_LIMITS');
1986: fnd_message.raise_error;
1987:
1988: end if;
1989:

Line 1986: fnd_message.raise_error;

1982:
1983: if(p_er_annual_limit is Null or p_ee_annual_limit is Null) then
1984:
1985: fnd_message.set_name('PQP', 'PQP_230990_SAV_NULL_ANN_LIMITS');
1986: fnd_message.raise_error;
1987:
1988: end if;
1989:
1990: end if;

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

2009: IF p_special_pension_type_code IS NOT NULL THEN
2010: IF p_special_pension_type_code = 'PGGM' THEN
2011: IF nvl(p_er_contribution_percent,0) <
2012: nvl(p_ee_contribution_percent,0) THEN
2013: fnd_message.set_name('PQP','PQP_230221_PGGM_INV_PERCENTAGE');
2014: fnd_message.raise_error;
2015: END IF;
2016: END IF;
2017: END IF;

Line 2014: fnd_message.raise_error;

2010: IF p_special_pension_type_code = 'PGGM' THEN
2011: IF nvl(p_er_contribution_percent,0) <
2012: nvl(p_ee_contribution_percent,0) THEN
2013: fnd_message.set_name('PQP','PQP_230221_PGGM_INV_PERCENTAGE');
2014: fnd_message.raise_error;
2015: END IF;
2016: END IF;
2017: END IF;
2018:

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

2025: OPEN c_chk_scheme;
2026: FETCH c_chk_scheme INTO l_schm_exists;
2027: IF c_chk_scheme%FOUND THEN
2028: CLOSE c_chk_scheme;
2029: fnd_message.set_name('PQP','PQP_230125_PT_UPD_NOT_ALLOWED');
2030: fnd_message.raise_error;
2031: ELSE
2032: CLOSE c_chk_scheme;
2033: END IF;

Line 2030: fnd_message.raise_error;

2026: FETCH c_chk_scheme INTO l_schm_exists;
2027: IF c_chk_scheme%FOUND THEN
2028: CLOSE c_chk_scheme;
2029: fnd_message.set_name('PQP','PQP_230125_PT_UPD_NOT_ALLOWED');
2030: fnd_message.raise_error;
2031: ELSE
2032: CLOSE c_chk_scheme;
2033: END IF;
2034: END IF;