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

Line 614: fnd_message.set_name('PQP','PQP_230059_ABP_SCHEME_OVERLAP');

610: IF (trunc(p_scheme_start_date) >=
611: trunc(temp_rec.date_from) AND
612: trunc(p_scheme_start_date) <=
613: trunc(temp_rec.date_to)) THEN
614: fnd_message.set_name('PQP','PQP_230059_ABP_SCHEME_OVERLAP');
615: fnd_message.set_token('SCHM',temp_rec.scheme_name);
616: fnd_message.set_token('FROM',to_char(temp_rec.date_from));
617: fnd_message.set_token('TO',to_char(temp_rec.date_to)) ;
618: fnd_message.raise_error;

Line 615: fnd_message.set_token('SCHM',temp_rec.scheme_name);

611: trunc(temp_rec.date_from) AND
612: trunc(p_scheme_start_date) <=
613: trunc(temp_rec.date_to)) THEN
614: fnd_message.set_name('PQP','PQP_230059_ABP_SCHEME_OVERLAP');
615: fnd_message.set_token('SCHM',temp_rec.scheme_name);
616: fnd_message.set_token('FROM',to_char(temp_rec.date_from));
617: fnd_message.set_token('TO',to_char(temp_rec.date_to)) ;
618: fnd_message.raise_error;
619: ELSIF (trunc(p_scheme_end_date) >=

Line 616: fnd_message.set_token('FROM',to_char(temp_rec.date_from));

612: trunc(p_scheme_start_date) <=
613: trunc(temp_rec.date_to)) THEN
614: fnd_message.set_name('PQP','PQP_230059_ABP_SCHEME_OVERLAP');
615: fnd_message.set_token('SCHM',temp_rec.scheme_name);
616: fnd_message.set_token('FROM',to_char(temp_rec.date_from));
617: fnd_message.set_token('TO',to_char(temp_rec.date_to)) ;
618: fnd_message.raise_error;
619: ELSIF (trunc(p_scheme_end_date) >=
620: trunc(temp_rec.date_from) AND

Line 617: fnd_message.set_token('TO',to_char(temp_rec.date_to)) ;

613: trunc(temp_rec.date_to)) THEN
614: fnd_message.set_name('PQP','PQP_230059_ABP_SCHEME_OVERLAP');
615: fnd_message.set_token('SCHM',temp_rec.scheme_name);
616: fnd_message.set_token('FROM',to_char(temp_rec.date_from));
617: fnd_message.set_token('TO',to_char(temp_rec.date_to)) ;
618: fnd_message.raise_error;
619: ELSIF (trunc(p_scheme_end_date) >=
620: trunc(temp_rec.date_from) AND
621: trunc(p_scheme_end_date) <=

Line 618: fnd_message.raise_error;

614: fnd_message.set_name('PQP','PQP_230059_ABP_SCHEME_OVERLAP');
615: fnd_message.set_token('SCHM',temp_rec.scheme_name);
616: fnd_message.set_token('FROM',to_char(temp_rec.date_from));
617: fnd_message.set_token('TO',to_char(temp_rec.date_to)) ;
618: fnd_message.raise_error;
619: ELSIF (trunc(p_scheme_end_date) >=
620: trunc(temp_rec.date_from) AND
621: trunc(p_scheme_end_date) <=
622: trunc(temp_rec.date_to)) THEN

Line 623: fnd_message.set_name('PQP','PQP_230059_ABP_SCHEME_OVERLAP');

619: ELSIF (trunc(p_scheme_end_date) >=
620: trunc(temp_rec.date_from) AND
621: trunc(p_scheme_end_date) <=
622: trunc(temp_rec.date_to)) THEN
623: fnd_message.set_name('PQP','PQP_230059_ABP_SCHEME_OVERLAP');
624: fnd_message.set_token('SCHM',temp_rec.scheme_name);
625: fnd_message.set_token('FROM',to_char(temp_rec.date_from));
626: fnd_message.set_token('TO',to_char(temp_rec.date_to));
627: fnd_message.raise_error;

Line 624: fnd_message.set_token('SCHM',temp_rec.scheme_name);

620: trunc(temp_rec.date_from) AND
621: trunc(p_scheme_end_date) <=
622: trunc(temp_rec.date_to)) THEN
623: fnd_message.set_name('PQP','PQP_230059_ABP_SCHEME_OVERLAP');
624: fnd_message.set_token('SCHM',temp_rec.scheme_name);
625: fnd_message.set_token('FROM',to_char(temp_rec.date_from));
626: fnd_message.set_token('TO',to_char(temp_rec.date_to));
627: fnd_message.raise_error;
628: END IF;

Line 625: fnd_message.set_token('FROM',to_char(temp_rec.date_from));

621: trunc(p_scheme_end_date) <=
622: trunc(temp_rec.date_to)) THEN
623: fnd_message.set_name('PQP','PQP_230059_ABP_SCHEME_OVERLAP');
624: fnd_message.set_token('SCHM',temp_rec.scheme_name);
625: fnd_message.set_token('FROM',to_char(temp_rec.date_from));
626: fnd_message.set_token('TO',to_char(temp_rec.date_to));
627: fnd_message.raise_error;
628: END IF;
629: END LOOP;

Line 626: fnd_message.set_token('TO',to_char(temp_rec.date_to));

622: trunc(temp_rec.date_to)) THEN
623: fnd_message.set_name('PQP','PQP_230059_ABP_SCHEME_OVERLAP');
624: fnd_message.set_token('SCHM',temp_rec.scheme_name);
625: fnd_message.set_token('FROM',to_char(temp_rec.date_from));
626: fnd_message.set_token('TO',to_char(temp_rec.date_to));
627: fnd_message.raise_error;
628: END IF;
629: END LOOP;
630:

Line 627: fnd_message.raise_error;

623: fnd_message.set_name('PQP','PQP_230059_ABP_SCHEME_OVERLAP');
624: fnd_message.set_token('SCHM',temp_rec.scheme_name);
625: fnd_message.set_token('FROM',to_char(temp_rec.date_from));
626: fnd_message.set_token('TO',to_char(temp_rec.date_to));
627: fnd_message.raise_error;
628: END IF;
629: END LOOP;
630:
631: hr_utility.set_location('Leaving: '||l_proc_name, 20);

Line 752: fnd_message.raise_error;

748: OPEN c_abp_ele;
749: FETCH c_abp_ele INTO l_abp_ele_id;
750: IF c_abp_ele%NOTFOUND THEN
751: CLOSE c_abp_ele;
752: fnd_message.raise_error;
753: ELSE
754: CLOSE c_abp_ele;
755: END IF;
756: --

Line 763: fnd_message.raise_error;

759: OPEN c_abp_ff;
760: FETCH c_abp_ff INTO l_abp_formula_id;
761: IF c_abp_ff%NOTFOUND THEN
762: CLOSE c_abp_ff;
763: fnd_message.raise_error;
764: ELSE
765: CLOSE c_abp_ff;
766: END IF;
767:

Line 798: fnd_message.raise_error;

794: ,'Contribution Type');
795: FETCH c_ip_val INTO l_input_result(1).input_value_id;
796: IF c_ip_val%NOTFOUND THEN
797: CLOSE c_ip_val;
798: fnd_message.raise_error;
799: ELSE
800: CLOSE c_ip_val;
801: END IF;
802:

Line 809: fnd_message.raise_error;

805: ,'Contribution Value');
806: FETCH c_ip_val INTO l_input_result(2).input_value_id;
807: IF c_ip_val%NOTFOUND THEN
808: CLOSE c_ip_val;
809: fnd_message.raise_error;
810: ELSE
811: CLOSE c_ip_val;
812: END IF;
813:

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

874: OPEN chk_pension_scheme_name_cur;
875: FETCH chk_pension_scheme_name_cur INTO l_scheme_dummy;
876: IF chk_pension_scheme_name_cur%FOUND THEN
877: CLOSE chk_pension_scheme_name_cur;
878: fnd_message.set_name('PQP', 'PQP_230924_SCHEME_NAME_ERR');
879: fnd_message.raise_error;
880: ELSE
881: CLOSE chk_pension_scheme_name_cur;
882: END IF;

Line 879: fnd_message.raise_error;

875: FETCH chk_pension_scheme_name_cur INTO l_scheme_dummy;
876: IF chk_pension_scheme_name_cur%FOUND THEN
877: CLOSE chk_pension_scheme_name_cur;
878: fnd_message.set_name('PQP', 'PQP_230924_SCHEME_NAME_ERR');
879: fnd_message.raise_error;
880: ELSE
881: CLOSE chk_pension_scheme_name_cur;
882: END IF;
883:

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

886: ,c_effective_date => p_effective_start_date);
887: FETCH csr_pty1 INTO r_pty_rec;
888: --
889: IF csr_pty1%NOTFOUND THEN
890: fnd_message.set_name('PQP', 'PQP_230805_INV_PENSIONID');
891: fnd_message.raise_error;
892: CLOSE csr_pty1;
893: ELSE
894: CLOSE csr_pty1;

Line 891: fnd_message.raise_error;

887: FETCH csr_pty1 INTO r_pty_rec;
888: --
889: IF csr_pty1%NOTFOUND THEN
890: fnd_message.set_name('PQP', 'PQP_230805_INV_PENSIONID');
891: fnd_message.raise_error;
892: CLOSE csr_pty1;
893: ELSE
894: CLOSE csr_pty1;
895: END IF;

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

1558: l_Balance_Feed_Id := NULL;
1559: l_row_id := NULL;
1560:
1561: ELSIF l_ee_contribution_bal_type_id IS NULL THEN
1562: fnd_message.set_name('PQP', 'PQP_230805_BAL_NOTFOUND');
1563: fnd_message.raise_error;
1564: END IF;
1565: hr_utility.set_location('..After creating the balance feed for
1566: the base, Pay Value', 50);

Line 1563: fnd_message.raise_error;

1559: l_row_id := NULL;
1560:
1561: ELSIF l_ee_contribution_bal_type_id IS NULL THEN
1562: fnd_message.set_name('PQP', 'PQP_230805_BAL_NOTFOUND');
1563: fnd_message.raise_error;
1564: END IF;
1565: hr_utility.set_location('..After creating the balance feed for
1566: the base, Pay Value', 50);
1567: END LOOP;

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

1609: l_Balance_Feed_Id := NULL;
1610: l_row_id := NULL;
1611:
1612: ELSIF l_ee_retro_bal_id IS NULL THEN
1613: fnd_message.set_name('PQP', 'PQP_230805_BAL_NOTFOUND');
1614: fnd_message.raise_error;
1615: END IF;
1616: hr_utility.set_location('..After creating the balance feed for
1617: the ee retro element, Pay Value', 54);

Line 1614: fnd_message.raise_error;

1610: l_row_id := NULL;
1611:
1612: ELSIF l_ee_retro_bal_id IS NULL THEN
1613: fnd_message.set_name('PQP', 'PQP_230805_BAL_NOTFOUND');
1614: fnd_message.raise_error;
1615: END IF;
1616: hr_utility.set_location('..After creating the balance feed for
1617: the ee retro element, Pay Value', 54);
1618: END LOOP;

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

1642: l_Balance_Feed_Id := NULL;
1643: l_row_id := NULL;
1644:
1645: ELSIF l_ee_retro_bal_id IS NULL THEN
1646: fnd_message.set_name('PQP', 'PQP_230805_BAL_NOTFOUND');
1647: fnd_message.raise_error;
1648: END IF;
1649: hr_utility.set_location('..After creating the balance feed for
1650: the ee retro element, Pay Value', 55);

Line 1647: fnd_message.raise_error;

1643: l_row_id := NULL;
1644:
1645: ELSIF l_ee_retro_bal_id IS NULL THEN
1646: fnd_message.set_name('PQP', 'PQP_230805_BAL_NOTFOUND');
1647: fnd_message.raise_error;
1648: END IF;
1649: hr_utility.set_location('..After creating the balance feed for
1650: the ee retro element, Pay Value', 55);
1651: END LOOP;*/

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

1680: l_Balance_Feed_Id := NULL;
1681: l_row_id := NULL;
1682:
1683: ELSIF l_er_contribution_bal_type_id IS NULL THEN
1684: fnd_message.set_name('PQP', 'PQP_230805_BAL_NOTFOUND');
1685: fnd_message.raise_error;
1686: END IF;
1687: hr_utility.set_location('..After creating the balance feed for
1688: the er base, Pay Value', 50);

Line 1685: fnd_message.raise_error;

1681: l_row_id := NULL;
1682:
1683: ELSIF l_er_contribution_bal_type_id IS NULL THEN
1684: fnd_message.set_name('PQP', 'PQP_230805_BAL_NOTFOUND');
1685: fnd_message.raise_error;
1686: END IF;
1687: hr_utility.set_location('..After creating the balance feed for
1688: the er base, Pay Value', 50);
1689: END LOOP;

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

1713: l_Balance_Feed_Id := NULL;
1714: l_row_id := NULL;
1715:
1716: ELSIF l_er_retro_bal_id IS NULL THEN
1717: fnd_message.set_name('PQP', 'PQP_230805_BAL_NOTFOUND');
1718: fnd_message.raise_error;
1719: END IF;
1720: hr_utility.set_location('..After creating the balance feed for the ER retro element,
1721: Pay Value', 57);

Line 1718: fnd_message.raise_error;

1714: l_row_id := NULL;
1715:
1716: ELSIF l_er_retro_bal_id IS NULL THEN
1717: fnd_message.set_name('PQP', 'PQP_230805_BAL_NOTFOUND');
1718: fnd_message.raise_error;
1719: END IF;
1720: hr_utility.set_location('..After creating the balance feed for the ER retro element,
1721: Pay Value', 57);
1722: END LOOP;

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

1742: l_Balance_Feed_Id := NULL;
1743: l_row_id := NULL;
1744:
1745: ELSIF l_er_retro_bal_id IS NULL THEN
1746: fnd_message.set_name('PQP', 'PQP_230805_BAL_NOTFOUND');
1747: fnd_message.raise_error;
1748: END IF;
1749: hr_utility.set_location('..After creating the balance feed for the ER retro element,
1750: Pay Value', 58);

Line 1747: fnd_message.raise_error;

1743: l_row_id := NULL;
1744:
1745: ELSIF l_er_retro_bal_id IS NULL THEN
1746: fnd_message.set_name('PQP', 'PQP_230805_BAL_NOTFOUND');
1747: fnd_message.raise_error;
1748: END IF;
1749: hr_utility.set_location('..After creating the balance feed for the ER retro element,
1750: Pay Value', 58);
1751: END LOOP;*/

Line 2258: fnd_message.set_name('PQP', 'PQP_230060_CHANGE_EFFECTIVE_DT');

2254: OPEN c_ele_processed(p_pension_dedn_ele_type_id);
2255: FETCH c_ele_processed INTO l_dummy;
2256: IF c_ele_processed%FOUND THEN
2257: CLOSE c_ele_processed;
2258: fnd_message.set_name('PQP', 'PQP_230060_CHANGE_EFFECTIVE_DT');
2259: fnd_message.raise_error;
2260: ELSIF c_ele_processed%NOTFOUND THEN
2261: CLOSE c_ele_processed;
2262: END IF;

Line 2259: fnd_message.raise_error;

2255: FETCH c_ele_processed INTO l_dummy;
2256: IF c_ele_processed%FOUND THEN
2257: CLOSE c_ele_processed;
2258: fnd_message.set_name('PQP', 'PQP_230060_CHANGE_EFFECTIVE_DT');
2259: fnd_message.raise_error;
2260: ELSIF c_ele_processed%NOTFOUND THEN
2261: CLOSE c_ele_processed;
2262: END IF;
2263:

Line 2269: fnd_message.set_name('PQP', 'PQP_230060_CHANGE_EFFECTIVE_DT');

2265: OPEN c_ele_processed(l_er_dedn_ele_type_id);
2266: FETCH c_ele_processed INTO l_dummy;
2267: IF c_ele_processed%FOUND THEN
2268: CLOSE c_ele_processed;
2269: fnd_message.set_name('PQP', 'PQP_230060_CHANGE_EFFECTIVE_DT');
2270: fnd_message.raise_error;
2271: ELSIF c_ele_processed%NOTFOUND THEN
2272: CLOSE c_ele_processed;
2273: END IF;

Line 2270: fnd_message.raise_error;

2266: FETCH c_ele_processed INTO l_dummy;
2267: IF c_ele_processed%FOUND THEN
2268: CLOSE c_ele_processed;
2269: fnd_message.set_name('PQP', 'PQP_230060_CHANGE_EFFECTIVE_DT');
2270: fnd_message.raise_error;
2271: ELSIF c_ele_processed%NOTFOUND THEN
2272: CLOSE c_ele_processed;
2273: END IF;
2274: END IF;