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

Line 379: fnd_message.set_name('PQP', 'PQP_230815_INVALID_ORG');

375: Open csr_org;
376: Fetch csr_org Into l_org_rec;
377: If csr_org%NOTFOUND Then
378: Close csr_org;
379: fnd_message.set_name('PQP', 'PQP_230815_INVALID_ORG');
380: fnd_message.raise_error;
381: Else
382: Close csr_org;
383: End If;

Line 380: fnd_message.raise_error;

376: Fetch csr_org Into l_org_rec;
377: If csr_org%NOTFOUND Then
378: Close csr_org;
379: fnd_message.set_name('PQP', 'PQP_230815_INVALID_ORG');
380: fnd_message.raise_error;
381: Else
382: Close csr_org;
383: End If;
384:

Line 694: fnd_message.set_name('PQP', 'PQP_230816_INV_ST_ED_DATES');

690: If p_start_date < l_min_start_date Or
691: p_end_date > l_max_end_date Then
692: -- Error : Start or End date can't be less than or greater
693: -- than the pension types Start or End date.
694: fnd_message.set_name('PQP', 'PQP_230816_INV_ST_ED_DATES');
695: fnd_message.raise_error;
696: End If;
697: Close csr_pen_type;
698: Else

Line 695: fnd_message.raise_error;

691: p_end_date > l_max_end_date Then
692: -- Error : Start or End date can't be less than or greater
693: -- than the pension types Start or End date.
694: fnd_message.set_name('PQP', 'PQP_230816_INV_ST_ED_DATES');
695: fnd_message.raise_error;
696: End If;
697: Close csr_pen_type;
698: Else
699: -- Error : Invalid pension type id passed

Line 700: fnd_message.set_name('PQP', 'PQP_230817_INVALID_PEN_TYPE');

696: End If;
697: Close csr_pen_type;
698: Else
699: -- Error : Invalid pension type id passed
700: fnd_message.set_name('PQP', 'PQP_230817_INVALID_PEN_TYPE');
701: fnd_message.raise_error;
702: Close csr_pen_type;
703: End If;
704: -- Insert the information into the hr_organization_information table

Line 701: fnd_message.raise_error;

697: Close csr_pen_type;
698: Else
699: -- Error : Invalid pension type id passed
700: fnd_message.set_name('PQP', 'PQP_230817_INVALID_PEN_TYPE');
701: fnd_message.raise_error;
702: Close csr_pen_type;
703: End If;
704: -- Insert the information into the hr_organization_information table
705: If p_transaction_mode = 'INSERT' Then

Line 712: fnd_message.set_name('PQP','PQP_230870_PTYPE_ALREADY_ASSIG');

708: open csr_assigned_pen_types;
709: Fetch csr_assigned_pen_types Into l_assigned_pen_type;
710: If csr_assigned_pen_types%Found Then
711: --Error : The pension type is already assigned to this org
712: fnd_message.set_name('PQP','PQP_230870_PTYPE_ALREADY_ASSIG');
713: fnd_message.set_token('PTYPE_NAME',l_assigned_pen_type);
714: fnd_message.raise_error;
715: Close csr_assigned_pen_types;
716: End If;

Line 713: fnd_message.set_token('PTYPE_NAME',l_assigned_pen_type);

709: Fetch csr_assigned_pen_types Into l_assigned_pen_type;
710: If csr_assigned_pen_types%Found Then
711: --Error : The pension type is already assigned to this org
712: fnd_message.set_name('PQP','PQP_230870_PTYPE_ALREADY_ASSIG');
713: fnd_message.set_token('PTYPE_NAME',l_assigned_pen_type);
714: fnd_message.raise_error;
715: Close csr_assigned_pen_types;
716: End If;
717:

Line 714: fnd_message.raise_error;

710: If csr_assigned_pen_types%Found Then
711: --Error : The pension type is already assigned to this org
712: fnd_message.set_name('PQP','PQP_230870_PTYPE_ALREADY_ASSIG');
713: fnd_message.set_token('PTYPE_NAME',l_assigned_pen_type);
714: fnd_message.raise_error;
715: Close csr_assigned_pen_types;
716: End If;
717:
718: hr_org_information_pkg.insert_row

Line 780: fnd_message.set_name('PQP', 'PQP_230815_INVALID_ORG');

776: -- Invalid org_information_id, organization_id or combination
777: -- does not exists for PQP_NL_ER_PENSION_TYPES context
778: --
779: Close csr_org_info;
780: fnd_message.set_name('PQP', 'PQP_230815_INVALID_ORG');
781: fnd_message.raise_error;
782: Else
783: Close csr_org_info;
784: End If;

Line 781: fnd_message.raise_error;

777: -- does not exists for PQP_NL_ER_PENSION_TYPES context
778: --
779: Close csr_org_info;
780: fnd_message.set_name('PQP', 'PQP_230815_INVALID_ORG');
781: fnd_message.raise_error;
782: Else
783: Close csr_org_info;
784: End If;
785: -- Update the information in the hr_organization_information table

Line 937: fnd_message.set_name('PQP', 'PQP_230867_PTYPE_ASSIGN_TO_EMP');

933: FETCH c_chk_asg_employer INTO l_dummy;
934: IF c_chk_asg_employer%FOUND THEN
935: -- Error Pension type is assigned to an employer.
936: close c_chk_asg_employer;
937: fnd_message.set_name('PQP', 'PQP_230867_PTYPE_ASSIGN_TO_EMP');
938: fnd_message.raise_error;
939: ELSE
940: -- It is not assigned so it can be deleted.
941: close c_chk_asg_employer;

Line 938: fnd_message.raise_error;

934: IF c_chk_asg_employer%FOUND THEN
935: -- Error Pension type is assigned to an employer.
936: close c_chk_asg_employer;
937: fnd_message.set_name('PQP', 'PQP_230867_PTYPE_ASSIGN_TO_EMP');
938: fnd_message.raise_error;
939: ELSE
940: -- It is not assigned so it can be deleted.
941: close c_chk_asg_employer;
942: OPEN c_is_pentype_attached_nl;

Line 947: fnd_message.set_name('PQP', 'PQP_230960_PTYPE_ATTACH_SCHM');

943: FETCH c_is_pentype_attached_nl into l_dummy;
944: IF c_is_pentype_attached_nl%FOUND THEN
945: -- error the pension type cannot be removed since its used in a scheme
946: close c_is_pentype_attached_nl;
947: fnd_message.set_name('PQP', 'PQP_230960_PTYPE_ATTACH_SCHM');
948: fnd_message.raise_error;
949: ELSE
950: close c_is_pentype_attached_nl;
951: hr_org_information_pkg.delete_row(l_org_info_rowid);

Line 948: fnd_message.raise_error;

944: IF c_is_pentype_attached_nl%FOUND THEN
945: -- error the pension type cannot be removed since its used in a scheme
946: close c_is_pentype_attached_nl;
947: fnd_message.set_name('PQP', 'PQP_230960_PTYPE_ATTACH_SCHM');
948: fnd_message.raise_error;
949: ELSE
950: close c_is_pentype_attached_nl;
951: hr_org_information_pkg.delete_row(l_org_info_rowid);
952: END IF; -- if c_is_pentype_attached_nl

Line 961: fnd_message.set_name('PQP', 'PQP_230960_PTYPE_ATTACH_SCHM');

957: FETCH c_is_pentype_attached_gb INTO l_dummy;
958: IF c_is_pentype_attached_gb%FOUND THEN
959: -- Error Pension type is attached to a scheme.
960: close c_is_pentype_attached_gb;
961: fnd_message.set_name('PQP', 'PQP_230960_PTYPE_ATTACH_SCHM');
962: fnd_message.raise_error;
963: ELSE
964: -- It is not assigned so it can be deleted.
965: close c_is_pentype_attached_gb;

Line 962: fnd_message.raise_error;

958: IF c_is_pentype_attached_gb%FOUND THEN
959: -- Error Pension type is attached to a scheme.
960: close c_is_pentype_attached_gb;
961: fnd_message.set_name('PQP', 'PQP_230960_PTYPE_ATTACH_SCHM');
962: fnd_message.raise_error;
963: ELSE
964: -- It is not assigned so it can be deleted.
965: close c_is_pentype_attached_gb;
966: hr_org_information_pkg.delete_row(l_org_info_rowid);

Line 975: fnd_message.set_name('PQP', 'PQP_230960_PTYPE_ATTACH_SCHM');

971: FETCH c_is_pentype_attached_hu INTO l_dummy;
972: IF c_is_pentype_attached_hu%FOUND THEN
973: -- Error Pension type is attached to a scheme.
974: close c_is_pentype_attached_hu;
975: fnd_message.set_name('PQP', 'PQP_230960_PTYPE_ATTACH_SCHM');
976: fnd_message.raise_error;
977: ELSE
978: -- It is not assigned so it can be deleted.
979: close c_is_pentype_attached_hu;

Line 976: fnd_message.raise_error;

972: IF c_is_pentype_attached_hu%FOUND THEN
973: -- Error Pension type is attached to a scheme.
974: close c_is_pentype_attached_hu;
975: fnd_message.set_name('PQP', 'PQP_230960_PTYPE_ATTACH_SCHM');
976: fnd_message.raise_error;
977: ELSE
978: -- It is not assigned so it can be deleted.
979: close c_is_pentype_attached_hu;
980: hr_org_information_pkg.delete_row(l_org_info_rowid);

Line 989: fnd_message.set_name('PQP', 'PQP_230960_PTYPE_ATTACH_SCHM');

985: FETCH c_is_pentype_attached_ie INTO l_dummy;
986: IF c_is_pentype_attached_ie%FOUND THEN
987: -- Error Pension type is attached to a scheme.
988: close c_is_pentype_attached_ie;
989: fnd_message.set_name('PQP', 'PQP_230960_PTYPE_ATTACH_SCHM');
990: fnd_message.raise_error;
991: ELSE
992: -- It is not assigned so it can be deleted.
993: close c_is_pentype_attached_ie;

Line 990: fnd_message.raise_error;

986: IF c_is_pentype_attached_ie%FOUND THEN
987: -- Error Pension type is attached to a scheme.
988: close c_is_pentype_attached_ie;
989: fnd_message.set_name('PQP', 'PQP_230960_PTYPE_ATTACH_SCHM');
990: fnd_message.raise_error;
991: ELSE
992: -- It is not assigned so it can be deleted.
993: close c_is_pentype_attached_ie;
994: hr_org_information_pkg.delete_row(l_org_info_rowid);

Line 1095: fnd_message.set_name('PQP','PQP_230868_PRVDR_ASSIGN_TO_EMP');

1091: Fetch csr_is_provider_assigned Into l_assigned_provider;
1092: If csr_is_provider_assigned%Found Then
1093: Close csr_is_provider_assigned;
1094: --Error : The provider is assigned to an employer
1095: fnd_message.set_name('PQP','PQP_230868_PRVDR_ASSIGN_TO_EMP');
1096: fnd_message.raise_error;
1097:
1098: Else
1099: Close csr_is_provider_assigned;

Line 1096: fnd_message.raise_error;

1092: If csr_is_provider_assigned%Found Then
1093: Close csr_is_provider_assigned;
1094: --Error : The provider is assigned to an employer
1095: fnd_message.set_name('PQP','PQP_230868_PRVDR_ASSIGN_TO_EMP');
1096: fnd_message.raise_error;
1097:
1098: Else
1099: Close csr_is_provider_assigned;
1100:

Line 1108: fnd_message.set_name('PQP','PQP_230959_PRVDR_ATTACH_SCHM');

1104: Fetch csr_is_provider_attached Into l_assigned_provider;
1105: If csr_is_provider_attached%Found Then
1106: Close csr_is_provider_attached;
1107: --Error : The provider is attached to a scheme
1108: fnd_message.set_name('PQP','PQP_230959_PRVDR_ATTACH_SCHM');
1109: fnd_message.raise_error;
1110:
1111: Else
1112: Close csr_is_provider_attached;

Line 1109: fnd_message.raise_error;

1105: If csr_is_provider_attached%Found Then
1106: Close csr_is_provider_attached;
1107: --Error : The provider is attached to a scheme
1108: fnd_message.set_name('PQP','PQP_230959_PRVDR_ATTACH_SCHM');
1109: fnd_message.raise_error;
1110:
1111: Else
1112: Close csr_is_provider_attached;
1113:

Line 1246: fnd_message.set_name('PQP','PQP_230959_PRVDR_ATTACH_SCHM');

1242: Fetch csr_is_provider_assigned Into l_assigned_provider;
1243: If csr_is_provider_assigned%Found Then
1244: Close csr_is_provider_assigned;
1245: --Error : The provider is assigned to an employer
1246: fnd_message.set_name('PQP','PQP_230959_PRVDR_ATTACH_SCHM');
1247: fnd_message.raise_error;
1248:
1249: Else
1250: Close csr_is_provider_assigned;

Line 1247: fnd_message.raise_error;

1243: If csr_is_provider_assigned%Found Then
1244: Close csr_is_provider_assigned;
1245: --Error : The provider is assigned to an employer
1246: fnd_message.set_name('PQP','PQP_230959_PRVDR_ATTACH_SCHM');
1247: fnd_message.raise_error;
1248:
1249: Else
1250: Close csr_is_provider_assigned;
1251:

Line 1387: fnd_message.set_name('PQP', 'PQP_230815_INVALID_ORG');

1383: Open csr_org;
1384: Fetch csr_org into l_org_rec;
1385: If csr_org%NOTFOUND Then
1386: Close csr_org;
1387: fnd_message.set_name('PQP', 'PQP_230815_INVALID_ORG');
1388: fnd_message.raise_error;
1389: Else
1390: Close csr_org;
1391: End If;

Line 1388: fnd_message.raise_error;

1384: Fetch csr_org into l_org_rec;
1385: If csr_org%NOTFOUND Then
1386: Close csr_org;
1387: fnd_message.set_name('PQP', 'PQP_230815_INVALID_ORG');
1388: fnd_message.raise_error;
1389: Else
1390: Close csr_org;
1391: End If;
1392: hr_organization_units_pkg.Update_Row

Line 1492: fnd_message.set_name('PQP','PQP_230959_PRVDR_ATTACH_SCHM');

1488: Fetch csr_is_provider_assigned Into l_assigned_provider;
1489: If csr_is_provider_assigned%Found Then
1490: Close csr_is_provider_assigned;
1491: --Error : The provider is attached to a scheme
1492: fnd_message.set_name('PQP','PQP_230959_PRVDR_ATTACH_SCHM');
1493: fnd_message.raise_error;
1494:
1495: Else
1496: Close csr_is_provider_assigned;

Line 1493: fnd_message.raise_error;

1489: If csr_is_provider_assigned%Found Then
1490: Close csr_is_provider_assigned;
1491: --Error : The provider is attached to a scheme
1492: fnd_message.set_name('PQP','PQP_230959_PRVDR_ATTACH_SCHM');
1493: fnd_message.raise_error;
1494:
1495: Else
1496: Close csr_is_provider_assigned;
1497:

Line 1633: fnd_message.set_name('PQP', 'PQP_230815_INVALID_ORG');

1629: Open csr_org;
1630: Fetch csr_org into l_org_rec;
1631: If csr_org%NOTFOUND Then
1632: Close csr_org;
1633: fnd_message.set_name('PQP', 'PQP_230815_INVALID_ORG');
1634: fnd_message.raise_error;
1635: Else
1636: Close csr_org;
1637: End If;

Line 1634: fnd_message.raise_error;

1630: Fetch csr_org into l_org_rec;
1631: If csr_org%NOTFOUND Then
1632: Close csr_org;
1633: fnd_message.set_name('PQP', 'PQP_230815_INVALID_ORG');
1634: fnd_message.raise_error;
1635: Else
1636: Close csr_org;
1637: End If;
1638: hr_organization_units_pkg.Update_Row

Line 1737: fnd_message.set_name('PQP','PQP_230959_PRVDR_ATTACH_SCHM');

1733: Fetch csr_is_provider_assigned Into l_assigned_provider;
1734: If csr_is_provider_assigned%Found Then
1735: Close csr_is_provider_assigned;
1736: --Error : The provider is attached to a scheme
1737: fnd_message.set_name('PQP','PQP_230959_PRVDR_ATTACH_SCHM');
1738: fnd_message.raise_error;
1739:
1740: Else
1741: Close csr_is_provider_assigned;

Line 1738: fnd_message.raise_error;

1734: If csr_is_provider_assigned%Found Then
1735: Close csr_is_provider_assigned;
1736: --Error : The provider is attached to a scheme
1737: fnd_message.set_name('PQP','PQP_230959_PRVDR_ATTACH_SCHM');
1738: fnd_message.raise_error;
1739:
1740: Else
1741: Close csr_is_provider_assigned;
1742:

Line 1878: fnd_message.set_name('PQP', 'PQP_230815_INVALID_ORG');

1874: Open csr_org;
1875: Fetch csr_org into l_org_rec;
1876: If csr_org%NOTFOUND Then
1877: Close csr_org;
1878: fnd_message.set_name('PQP', 'PQP_230815_INVALID_ORG');
1879: fnd_message.raise_error;
1880: Else
1881: Close csr_org;
1882: End If;

Line 1879: fnd_message.raise_error;

1875: Fetch csr_org into l_org_rec;
1876: If csr_org%NOTFOUND Then
1877: Close csr_org;
1878: fnd_message.set_name('PQP', 'PQP_230815_INVALID_ORG');
1879: fnd_message.raise_error;
1880: Else
1881: Close csr_org;
1882: End If;
1883: hr_organization_units_pkg.Update_Row

Line 3127: fnd_message.set_name('PQP', 'PQP_230815_INVALID_ORG');

3123: -- Invalid org_information_id, organization_id or combination
3124: -- does not exists for PQP_NL_ER_PENSION_TYPES context
3125: --
3126: Close csr_org_info;
3127: fnd_message.set_name('PQP', 'PQP_230815_INVALID_ORG');
3128: fnd_message.raise_error;
3129: Else
3130: -- found the rowid,now call the delete procedure
3131: Close csr_org_info;

Line 3128: fnd_message.raise_error;

3124: -- does not exists for PQP_NL_ER_PENSION_TYPES context
3125: --
3126: Close csr_org_info;
3127: fnd_message.set_name('PQP', 'PQP_230815_INVALID_ORG');
3128: fnd_message.raise_error;
3129: Else
3130: -- found the rowid,now call the delete procedure
3131: Close csr_org_info;
3132: hr_org_information_pkg.delete_row(l_hoi_rowid);