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

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

Line 96: fnd_message.raise_error;

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

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

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

Line 610: fnd_message.raise_error;

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

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

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

Line 639: fnd_message.raise_error;

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

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

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

Line 678: fnd_message.raise_error;

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

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

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

Line 963: fnd_message.raise_error;

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

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

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

Line 1215: fnd_message.raise_error;

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

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

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

Line 1404: fnd_message.raise_error;

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

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

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

Line 1498: fnd_message.raise_error;

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

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

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

Line 1502: fnd_message.raise_error;

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

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

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

Line 1540: fnd_message.raise_error;

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

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

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

Line 1544: fnd_message.raise_error;

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