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

Line 97: fnd_message.set_name('PQP', 'PQP_230923_SCHEME_PREFIX_ERR');

93:
94: EXCEPTION
95:
96: WHEN OTHERS THEN
97: fnd_message.set_name('PQP', 'PQP_230923_SCHEME_PREFIX_ERR');
98: fnd_message.raise_error;
99:
100: END chk_scheme_prefix;
101:

Line 98: fnd_message.raise_error;

94: EXCEPTION
95:
96: WHEN OTHERS THEN
97: fnd_message.set_name('PQP', 'PQP_230923_SCHEME_PREFIX_ERR');
98: fnd_message.raise_error;
99:
100: END chk_scheme_prefix;
101:
102: -- ---------------------------------------------------------------------

Line 611: fnd_message.set_name('PQP', 'PQP_230924_SCHEME_NAME_ERR');

607: OPEN chk_pension_scheme_name_cur;
608: FETCH chk_pension_scheme_name_cur INTO l_scheme_dummy;
609: IF chk_pension_scheme_name_cur%FOUND THEN
610: CLOSE chk_pension_scheme_name_cur;
611: fnd_message.set_name('PQP', 'PQP_230924_SCHEME_NAME_ERR');
612: fnd_message.raise_error;
613: ELSE
614: CLOSE chk_pension_scheme_name_cur;
615: END IF;

Line 612: fnd_message.raise_error;

608: FETCH chk_pension_scheme_name_cur INTO l_scheme_dummy;
609: IF chk_pension_scheme_name_cur%FOUND THEN
610: CLOSE chk_pension_scheme_name_cur;
611: fnd_message.set_name('PQP', 'PQP_230924_SCHEME_NAME_ERR');
612: fnd_message.raise_error;
613: ELSE
614: CLOSE chk_pension_scheme_name_cur;
615: END IF;
616:

Line 640: fnd_message.set_name('PQP', 'PQP_230805_INV_PENSIONID');

636: ,c_effective_date => p_effective_start_date);
637: FETCH csr_pty1 INTO r_pty_rec;
638:
639: IF csr_pty1%notfound THEN
640: fnd_message.set_name('PQP', 'PQP_230805_INV_PENSIONID');
641: fnd_message.raise_error;
642: CLOSE csr_pty1;
643: ELSE
644:

Line 641: fnd_message.raise_error;

637: FETCH csr_pty1 INTO r_pty_rec;
638:
639: IF csr_pty1%notfound THEN
640: fnd_message.set_name('PQP', 'PQP_230805_INV_PENSIONID');
641: fnd_message.raise_error;
642: CLOSE csr_pty1;
643: ELSE
644:
645: -- Fixed premium amount exclusion rules

Line 679: fnd_message.set_name('PQP', 'PQP_230805_INV_PENSIONID');

675: FETCH csr_pty3 INTO l_pen_sal_bal_type_id;
676:
677: IF csr_pty3%notfound THEN
678: CLOSE csr_pty3;
679: fnd_message.set_name('PQP', 'PQP_230805_INV_PENSIONID');
680: fnd_message.raise_error;
681: ELSE
682: IF l_pen_sal_bal_type_id is not null then
683: l_configuration_information9 := 'N';

Line 680: fnd_message.raise_error;

676:
677: IF csr_pty3%notfound THEN
678: CLOSE csr_pty3;
679: fnd_message.set_name('PQP', 'PQP_230805_INV_PENSIONID');
680: fnd_message.raise_error;
681: ELSE
682: IF l_pen_sal_bal_type_id is not null then
683: l_configuration_information9 := 'N';
684: ELSE

Line 964: fnd_message.set_name('PQP', 'PQP_230805_INV_PENSIONID');

960: ,c_effective_date => p_effective_start_date);
961: FETCH csr_pty INTO l_ee_contribution_bal_type_id;
962:
963: IF csr_pty%notfound THEN
964: fnd_message.set_name('PQP', 'PQP_230805_INV_PENSIONID');
965: fnd_message.raise_error;
966: CLOSE csr_pty;
967: ELSE
968:

Line 965: fnd_message.raise_error;

961: FETCH csr_pty INTO l_ee_contribution_bal_type_id;
962:
963: IF csr_pty%notfound THEN
964: fnd_message.set_name('PQP', 'PQP_230805_INV_PENSIONID');
965: fnd_message.raise_error;
966: CLOSE csr_pty;
967: ELSE
968:
969: FOR temp_rec IN csr_get_formula_txt(l_shad_formula_id)

Line 1216: fnd_message.set_name('PQP', 'PQP_230805_INV_PENSIONID');

1212: ,c_effective_date => p_effective_start_date);
1213: FETCH csr_pty2 INTO l_er_contribution_bal_type_id;
1214:
1215: IF csr_pty2%notfound THEN
1216: fnd_message.set_name('PQP', 'PQP_230805_INV_PENSIONID');
1217: fnd_message.raise_error;
1218: CLOSE csr_pty2;
1219: ELSE
1220:

Line 1217: fnd_message.raise_error;

1213: FETCH csr_pty2 INTO l_er_contribution_bal_type_id;
1214:
1215: IF csr_pty2%notfound THEN
1216: fnd_message.set_name('PQP', 'PQP_230805_INV_PENSIONID');
1217: fnd_message.raise_error;
1218: CLOSE csr_pty2;
1219: ELSE
1220:
1221: FOR temp_rec IN csr_get_formula_txt(l_shad_formula_id1)

Line 1405: fnd_message.set_name('PQP', 'PQP_230805_INV_PENSIONID');

1401: ,c_effective_date => p_effective_start_date);
1402: FETCH csr_pty1 INTO r_pty_rec;
1403:
1404: IF csr_pty1%notfound THEN
1405: fnd_message.set_name('PQP', 'PQP_230805_INV_PENSIONID');
1406: fnd_message.raise_error;
1407: CLOSE csr_pty1;
1408: ELSE
1409: IF p_deduction_method = 'PE'

Line 1406: fnd_message.raise_error;

1402: FETCH csr_pty1 INTO r_pty_rec;
1403:
1404: IF csr_pty1%notfound THEN
1405: fnd_message.set_name('PQP', 'PQP_230805_INV_PENSIONID');
1406: fnd_message.raise_error;
1407: CLOSE csr_pty1;
1408: ELSE
1409: IF p_deduction_method = 'PE'
1410: AND r_pty_rec.salary_calculation_method = '3' THEN

Line 1499: fnd_message.set_name('PQP', 'PQP_230805_INV_PENSIONID');

1495: open csr_pty (c_pension_type_id => p_pension_type_id
1496: ,c_effective_date => p_effective_start_date);
1497: fetch csr_pty into l_ee_contribution_bal_type_id;
1498: if csr_pty%notfound then
1499: fnd_message.set_name('PQP', 'PQP_230805_INV_PENSIONID');
1500: fnd_message.raise_error;
1501: close csr_pty;
1502: elsif l_ee_contribution_bal_type_id is null then
1503: fnd_message.set_name('PQP', 'PQP_230805_BAL_NOTFOUND');

Line 1500: fnd_message.raise_error;

1496: ,c_effective_date => p_effective_start_date);
1497: fetch csr_pty into l_ee_contribution_bal_type_id;
1498: if csr_pty%notfound then
1499: fnd_message.set_name('PQP', 'PQP_230805_INV_PENSIONID');
1500: fnd_message.raise_error;
1501: close csr_pty;
1502: elsif l_ee_contribution_bal_type_id is null then
1503: fnd_message.set_name('PQP', 'PQP_230805_BAL_NOTFOUND');
1504: fnd_message.raise_error;

Line 1503: fnd_message.set_name('PQP', 'PQP_230805_BAL_NOTFOUND');

1499: fnd_message.set_name('PQP', 'PQP_230805_INV_PENSIONID');
1500: fnd_message.raise_error;
1501: close csr_pty;
1502: elsif l_ee_contribution_bal_type_id is null then
1503: fnd_message.set_name('PQP', 'PQP_230805_BAL_NOTFOUND');
1504: fnd_message.raise_error;
1505: close csr_pty;
1506: end if;
1507: close csr_pty;

Line 1504: fnd_message.raise_error;

1500: fnd_message.raise_error;
1501: close csr_pty;
1502: elsif l_ee_contribution_bal_type_id is null then
1503: fnd_message.set_name('PQP', 'PQP_230805_BAL_NOTFOUND');
1504: fnd_message.raise_error;
1505: close csr_pty;
1506: end if;
1507: close csr_pty;
1508: Pay_Balance_Feeds_f_pkg.Insert_Row(

Line 1541: fnd_message.set_name('PQP', 'PQP_230805_INV_PENSIONID');

1537: open csr_pty2 (c_pension_type_id => p_pension_type_id
1538: ,c_effective_date => p_effective_start_date);
1539: fetch csr_pty2 into l_er_contribution_bal_type_id;
1540: if csr_pty2%notfound then
1541: fnd_message.set_name('PQP', 'PQP_230805_INV_PENSIONID');
1542: fnd_message.raise_error;
1543: close csr_pty2;
1544: elsif l_er_contribution_bal_type_id is null then
1545: fnd_message.set_name('PQP', 'PQP_230805_BAL_NOTFOUND');

Line 1542: fnd_message.raise_error;

1538: ,c_effective_date => p_effective_start_date);
1539: fetch csr_pty2 into l_er_contribution_bal_type_id;
1540: if csr_pty2%notfound then
1541: fnd_message.set_name('PQP', 'PQP_230805_INV_PENSIONID');
1542: fnd_message.raise_error;
1543: close csr_pty2;
1544: elsif l_er_contribution_bal_type_id is null then
1545: fnd_message.set_name('PQP', 'PQP_230805_BAL_NOTFOUND');
1546: fnd_message.raise_error;

Line 1545: fnd_message.set_name('PQP', 'PQP_230805_BAL_NOTFOUND');

1541: fnd_message.set_name('PQP', 'PQP_230805_INV_PENSIONID');
1542: fnd_message.raise_error;
1543: close csr_pty2;
1544: elsif l_er_contribution_bal_type_id is null then
1545: fnd_message.set_name('PQP', 'PQP_230805_BAL_NOTFOUND');
1546: fnd_message.raise_error;
1547: close csr_pty2;
1548: end if;
1549: close csr_pty2;

Line 1546: fnd_message.raise_error;

1542: fnd_message.raise_error;
1543: close csr_pty2;
1544: elsif l_er_contribution_bal_type_id is null then
1545: fnd_message.set_name('PQP', 'PQP_230805_BAL_NOTFOUND');
1546: fnd_message.raise_error;
1547: close csr_pty2;
1548: end if;
1549: close csr_pty2;
1550: Pay_Balance_Feeds_f_pkg.Insert_Row(