DBA Data[Home] [Help]

APPS.PQP_NL_SAVINGS_TEMPLATE dependencies on FND_MESSAGE

Line 625: fnd_message.set_name('PQP','PQP_230300_SAV_PREFIX_LEN_ERR');

621:
622: -- Limit the prefix length due to DBI's
623: -- generated for the element names. Max of 8 chars is allowed.
624: --
625: fnd_message.set_name('PQP','PQP_230300_SAV_PREFIX_LEN_ERR');
626: fnd_message.raise_error;
627: END IF;
628:
629: pqp_nl_pension_template.chk_scheme_prefix(p_scheme_prefix);

Line 626: fnd_message.raise_error;

622: -- Limit the prefix length due to DBI's
623: -- generated for the element names. Max of 8 chars is allowed.
624: --
625: fnd_message.set_name('PQP','PQP_230300_SAV_PREFIX_LEN_ERR');
626: fnd_message.raise_error;
627: END IF;
628:
629: pqp_nl_pension_template.chk_scheme_prefix(p_scheme_prefix);
630:

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

633: FETCH chk_savings_scheme_name_cur INTO l_scheme_dummy;
634: IF chk_savings_scheme_name_cur%FOUND THEN
635: CLOSE chk_savings_scheme_name_cur;
636: hr_utility.set_location('Check unique scheme name : '||l_proc_name, 12);
637: fnd_message.set_name('PQP', 'PQP_230924_SCHEME_NAME_ERR');
638: fnd_message.raise_error;
639: ELSE
640: CLOSE chk_savings_scheme_name_cur;
641: END IF;

Line 638: fnd_message.raise_error;

634: IF chk_savings_scheme_name_cur%FOUND THEN
635: CLOSE chk_savings_scheme_name_cur;
636: hr_utility.set_location('Check unique scheme name : '||l_proc_name, 12);
637: fnd_message.set_name('PQP', 'PQP_230924_SCHEME_NAME_ERR');
638: fnd_message.raise_error;
639: ELSE
640: CLOSE chk_savings_scheme_name_cur;
641: END IF;
642:

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

663: FETCH csr_pty1 INTO r_pty_rec;
664:
665: IF csr_pty1%notfound THEN
666:
667: fnd_message.set_name('PQP', 'PQP_230805_INV_PENSIONID');
668: fnd_message.raise_error;
669: CLOSE csr_pty1;
670:
671: ELSE

Line 668: fnd_message.raise_error;

664:
665: IF csr_pty1%notfound THEN
666:
667: fnd_message.set_name('PQP', 'PQP_230805_INV_PENSIONID');
668: fnd_message.raise_error;
669: CLOSE csr_pty1;
670:
671: ELSE
672:

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

1256: ,c_effective_date => p_effective_start_date);
1257: FETCH csr_pty INTO l_ee_contribution_bal_type_id;
1258:
1259: IF csr_pty%notfound THEN
1260: fnd_message.set_name('PQP', 'PQP_230805_INV_PENSIONID');
1261: fnd_message.raise_error;
1262: CLOSE csr_pty;
1263: ELSE
1264:

Line 1261: fnd_message.raise_error;

1257: FETCH csr_pty INTO l_ee_contribution_bal_type_id;
1258:
1259: IF csr_pty%notfound THEN
1260: fnd_message.set_name('PQP', 'PQP_230805_INV_PENSIONID');
1261: fnd_message.raise_error;
1262: CLOSE csr_pty;
1263: ELSE
1264:
1265: FOR temp_rec IN csr_get_formula_txt(l_shad_formula_id)

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

1395: ,c_effective_date => p_effective_start_date);
1396: FETCH csr_pty2 INTO l_er_contribution_bal_type_id;
1397: hr_utility.set_location('leaving'||l_er_contribution_bal_type_id,50);
1398: IF csr_pty2%notfound THEN
1399: fnd_message.set_name('PQP', 'PQP_230805_INV_PENSIONID');
1400: fnd_message.raise_error;
1401: CLOSE csr_pty2;
1402: ELSE
1403: hr_utility.set_location('leaving',60);

Line 1400: fnd_message.raise_error;

1396: FETCH csr_pty2 INTO l_er_contribution_bal_type_id;
1397: hr_utility.set_location('leaving'||l_er_contribution_bal_type_id,50);
1398: IF csr_pty2%notfound THEN
1399: fnd_message.set_name('PQP', 'PQP_230805_INV_PENSIONID');
1400: fnd_message.raise_error;
1401: CLOSE csr_pty2;
1402: ELSE
1403: hr_utility.set_location('leaving',60);
1404: FOR temp_rec IN csr_get_formula_txt(l_shad_formula_id1)

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

1537: ,c_effective_date => p_effective_start_date);
1538: FETCH csr_pty1 INTO r_pty_rec;
1539:
1540: IF csr_pty1%notfound THEN
1541: fnd_message.set_name('PQP', 'PQP_230805_INV_PENSIONID');
1542: fnd_message.raise_error;
1543: CLOSE csr_pty1;
1544: ELSE
1545: IF p_deduction_method = 'PE'

Line 1542: fnd_message.raise_error;

1538: FETCH csr_pty1 INTO r_pty_rec;
1539:
1540: IF csr_pty1%notfound THEN
1541: fnd_message.set_name('PQP', 'PQP_230805_INV_PENSIONID');
1542: fnd_message.raise_error;
1543: CLOSE csr_pty1;
1544: ELSE
1545: IF p_deduction_method = 'PE'
1546: AND r_pty_rec.pension_basis_calc_method = '13' THEN

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

1631: open csr_pty (c_pension_type_id => p_pension_type_id
1632: ,c_effective_date => p_effective_start_date);
1633: fetch csr_pty into l_ee_contribution_bal_type_id;
1634: if csr_pty%notfound then
1635: fnd_message.set_name('PQP', 'PQP_230805_INV_PENSIONID');
1636: fnd_message.raise_error;
1637: close csr_pty;
1638: elsif l_ee_contribution_bal_type_id is null then
1639: fnd_message.set_name('PQP', 'PQP_230805_BAL_NOTFOUND');

Line 1636: fnd_message.raise_error;

1632: ,c_effective_date => p_effective_start_date);
1633: fetch csr_pty into l_ee_contribution_bal_type_id;
1634: if csr_pty%notfound then
1635: fnd_message.set_name('PQP', 'PQP_230805_INV_PENSIONID');
1636: fnd_message.raise_error;
1637: close csr_pty;
1638: elsif l_ee_contribution_bal_type_id is null then
1639: fnd_message.set_name('PQP', 'PQP_230805_BAL_NOTFOUND');
1640: fnd_message.raise_error;

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

1635: fnd_message.set_name('PQP', 'PQP_230805_INV_PENSIONID');
1636: fnd_message.raise_error;
1637: close csr_pty;
1638: elsif l_ee_contribution_bal_type_id is null then
1639: fnd_message.set_name('PQP', 'PQP_230805_BAL_NOTFOUND');
1640: fnd_message.raise_error;
1641: close csr_pty;
1642: end if;
1643: close csr_pty;

Line 1640: fnd_message.raise_error;

1636: fnd_message.raise_error;
1637: close csr_pty;
1638: elsif l_ee_contribution_bal_type_id is null then
1639: fnd_message.set_name('PQP', 'PQP_230805_BAL_NOTFOUND');
1640: fnd_message.raise_error;
1641: close csr_pty;
1642: end if;
1643: close csr_pty;
1644: Pay_Balance_Feeds_f_pkg.Insert_Row(

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

1673: open csr_pty2 (c_pension_type_id => p_pension_type_id
1674: ,c_effective_date => p_effective_start_date);
1675: fetch csr_pty2 into l_er_contribution_bal_type_id;
1676: if csr_pty2%notfound then
1677: fnd_message.set_name('PQP', 'PQP_230805_INV_PENSIONID');
1678: fnd_message.raise_error;
1679: close csr_pty2;
1680: elsif l_er_contribution_bal_type_id is null then
1681: fnd_message.set_name('PQP', 'PQP_230805_BAL_NOTFOUND');

Line 1678: fnd_message.raise_error;

1674: ,c_effective_date => p_effective_start_date);
1675: fetch csr_pty2 into l_er_contribution_bal_type_id;
1676: if csr_pty2%notfound then
1677: fnd_message.set_name('PQP', 'PQP_230805_INV_PENSIONID');
1678: fnd_message.raise_error;
1679: close csr_pty2;
1680: elsif l_er_contribution_bal_type_id is null then
1681: fnd_message.set_name('PQP', 'PQP_230805_BAL_NOTFOUND');
1682: fnd_message.raise_error;

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

1677: fnd_message.set_name('PQP', 'PQP_230805_INV_PENSIONID');
1678: fnd_message.raise_error;
1679: close csr_pty2;
1680: elsif l_er_contribution_bal_type_id is null then
1681: fnd_message.set_name('PQP', 'PQP_230805_BAL_NOTFOUND');
1682: fnd_message.raise_error;
1683: close csr_pty2;
1684: end if;
1685: close csr_pty2;

Line 1682: fnd_message.raise_error;

1678: fnd_message.raise_error;
1679: close csr_pty2;
1680: elsif l_er_contribution_bal_type_id is null then
1681: fnd_message.set_name('PQP', 'PQP_230805_BAL_NOTFOUND');
1682: fnd_message.raise_error;
1683: close csr_pty2;
1684: end if;
1685: close csr_pty2;
1686: Pay_Balance_Feeds_f_pkg.Insert_Row(