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.PQH_GENERIC_HIERARCHY_PACKAGE dependencies on FND_MESSAGE

Line 534: fnd_message.set_name('PQH', 'PQH_GHR_EFF_DATE_NO_VERSION');

530: close csr_version_exists;
531: if g_debug then
532: hr_utility.set_location('Error: No version found', 20);
533: end if;
534: fnd_message.set_name('PQH', 'PQH_GHR_EFF_DATE_NO_VERSION');
535: fnd_message.raise_error;
536: else
537: close csr_version_exists;
538: end if;

Line 535: fnd_message.raise_error;

531: if g_debug then
532: hr_utility.set_location('Error: No version found', 20);
533: end if;
534: fnd_message.set_name('PQH', 'PQH_GHR_EFF_DATE_NO_VERSION');
535: fnd_message.raise_error;
536: else
537: close csr_version_exists;
538: end if;
539: --

Line 682: fnd_message.set_name('PQH','PQH_GHR_INVALID_LOOKUP_TYPE');

678: if p_lookup_type not in ('HIERARCHY_TYPE','HIERARCHY_NODE_TYPE') then
679: if g_debug then
680: hr_utility.set_location('Error: Invalid lookup Type', 20);
681: end if;
682: fnd_message.set_name('PQH','PQH_GHR_INVALID_LOOKUP_TYPE');
683: hr_multi_message.add;
684: else
685: --
686: -- Code has been supplied so lets check its unique

Line 696: fnd_message.set_name('PQH','PQH_GHR_LOOKUP_CODE_EXISTS');

692: if g_debug then
693: hr_utility.set_location('Error: Lookup code already exists', 30);
694: end if;
695: -- raise error as the supplied lookup_code already exists
696: fnd_message.set_name('PQH','PQH_GHR_LOOKUP_CODE_EXISTS');
697: fnd_message.set_token('TYPE',p_lookup_type);
698: fnd_message.set_token('CODE',p_lookup_code);
699: hr_multi_message.add;
700: else

Line 697: fnd_message.set_token('TYPE',p_lookup_type);

693: hr_utility.set_location('Error: Lookup code already exists', 30);
694: end if;
695: -- raise error as the supplied lookup_code already exists
696: fnd_message.set_name('PQH','PQH_GHR_LOOKUP_CODE_EXISTS');
697: fnd_message.set_token('TYPE',p_lookup_type);
698: fnd_message.set_token('CODE',p_lookup_code);
699: hr_multi_message.add;
700: else
701: close csr_lookup_code_unique;

Line 698: fnd_message.set_token('CODE',p_lookup_code);

694: end if;
695: -- raise error as the supplied lookup_code already exists
696: fnd_message.set_name('PQH','PQH_GHR_LOOKUP_CODE_EXISTS');
697: fnd_message.set_token('TYPE',p_lookup_type);
698: fnd_message.set_token('CODE',p_lookup_code);
699: hr_multi_message.add;
700: else
701: close csr_lookup_code_unique;
702: l_lookup_code := p_lookup_code;

Line 715: fnd_message.set_name('PQH','PQH_GHR_LOOKUP_MEANING_EXISTS');

711: if g_debug then
712: hr_utility.set_location('Error: Meaning Already Exists', 40);
713: end if;
714: -- raise error as the supplied meaning already exists
715: fnd_message.set_name('PQH','PQH_GHR_LOOKUP_MEANING_EXISTS');
716: fnd_message.set_token('TYPE',p_lookup_type);
717: fnd_message.set_token('MEANING',p_meaning);
718: hr_multi_message.add;
719: else

Line 716: fnd_message.set_token('TYPE',p_lookup_type);

712: hr_utility.set_location('Error: Meaning Already Exists', 40);
713: end if;
714: -- raise error as the supplied meaning already exists
715: fnd_message.set_name('PQH','PQH_GHR_LOOKUP_MEANING_EXISTS');
716: fnd_message.set_token('TYPE',p_lookup_type);
717: fnd_message.set_token('MEANING',p_meaning);
718: hr_multi_message.add;
719: else
720: close csr_lookup_meaning_unique;

Line 717: fnd_message.set_token('MEANING',p_meaning);

713: end if;
714: -- raise error as the supplied meaning already exists
715: fnd_message.set_name('PQH','PQH_GHR_LOOKUP_MEANING_EXISTS');
716: fnd_message.set_token('TYPE',p_lookup_type);
717: fnd_message.set_token('MEANING',p_meaning);
718: hr_multi_message.add;
719: else
720: close csr_lookup_meaning_unique;
721: l_lookup_code := p_lookup_code;

Line 800: fnd_message.set_name('PQH','PQH_GHR_LOOKUP_INS_FAIL');

796: hr_multi_message.disable_message_list;
797: if g_debug then
798: hr_utility.set_location('Unexpected Error:'||l_proc, 80);
799: end if;
800: fnd_message.set_name('PQH','PQH_GHR_LOOKUP_INS_FAIL');
801: fnd_message.set_token('TYPE',p_lookup_type);
802: fnd_message.set_token('CODE',p_lookup_code);
803: fnd_msg_pub.add;
804: end create_lookup_value;

Line 801: fnd_message.set_token('TYPE',p_lookup_type);

797: if g_debug then
798: hr_utility.set_location('Unexpected Error:'||l_proc, 80);
799: end if;
800: fnd_message.set_name('PQH','PQH_GHR_LOOKUP_INS_FAIL');
801: fnd_message.set_token('TYPE',p_lookup_type);
802: fnd_message.set_token('CODE',p_lookup_code);
803: fnd_msg_pub.add;
804: end create_lookup_value;
805: -- ----------------------------------------------------------------------------

Line 802: fnd_message.set_token('CODE',p_lookup_code);

798: hr_utility.set_location('Unexpected Error:'||l_proc, 80);
799: end if;
800: fnd_message.set_name('PQH','PQH_GHR_LOOKUP_INS_FAIL');
801: fnd_message.set_token('TYPE',p_lookup_type);
802: fnd_message.set_token('CODE',p_lookup_code);
803: fnd_msg_pub.add;
804: end create_lookup_value;
805: -- ----------------------------------------------------------------------------
806: -- |--------------------------< update_lookup_value >-------------------------|

Line 923: fnd_message.set_name('PQH','PQH_GHR_SHARED_TYPE_DUP');

919: if g_debug then
920: hr_utility.set_location('Error: Duplicate shared type', 20);
921: end if;
922: -- raise error as the supplied lookup_code already exists
923: fnd_message.set_name('PQH','PQH_GHR_SHARED_TYPE_DUP');
924: hr_multi_message.add;
925: else
926: close csr_shared_type_entry_unique;
927: end if;

Line 978: fnd_message.set_name('PQH','PQH_GHR_SHARED_TYPE_INS_FAIL');

974: if g_debug then
975: hr_utility.set_location('Unexpected Error'||l_proc, 60);
976: end if;
977: hr_multi_message.disable_message_list;
978: fnd_message.set_name('PQH','PQH_GHR_SHARED_TYPE_INS_FAIL');
979: fnd_msg_pub.add;
980: end create_shared_type;
981: --
982: -- ----------------------------------------------------------------------------

Line 1033: fnd_message.set_name('PQH','PQH_GHR_SHARED_TYPE_INV');

1029: if g_debug then
1030: hr_utility.set_location('Error: Lookup Code does not exist', 20);
1031: end if;
1032: -- raise error as the supplied lookup_code does not exist
1033: fnd_message.set_name('PQH','PQH_GHR_SHARED_TYPE_INV');
1034: fnd_message.raise_error;
1035: else
1036: close csr_shared_type_entry;
1037: end if;

Line 1034: fnd_message.raise_error;

1030: hr_utility.set_location('Error: Lookup Code does not exist', 20);
1031: end if;
1032: -- raise error as the supplied lookup_code does not exist
1033: fnd_message.set_name('PQH','PQH_GHR_SHARED_TYPE_INV');
1034: fnd_message.raise_error;
1035: else
1036: close csr_shared_type_entry;
1037: end if;
1038: --

Line 1045: fnd_message.set_name('PQH','PQH_GHR_SHARED_TYPE_INV_INFO');

1041: if g_debug then
1042: hr_utility.set_location('Error: Info. Value is not y or n', 30);
1043: end if;
1044: --Raise error for invalid information value
1045: fnd_message.set_name('PQH','PQH_GHR_SHARED_TYPE_INV_INFO');
1046: fnd_message.raise_error;
1047: Else
1048: -- Now we attempt to update the shared types entry
1049:

Line 1046: fnd_message.raise_error;

1042: hr_utility.set_location('Error: Info. Value is not y or n', 30);
1043: end if;
1044: --Raise error for invalid information value
1045: fnd_message.set_name('PQH','PQH_GHR_SHARED_TYPE_INV_INFO');
1046: fnd_message.raise_error;
1047: Else
1048: -- Now we attempt to update the shared types entry
1049:
1050: per_shared_types_api.update_shared_type

Line 1148: fnd_message.set_name('PQH','PQH_GHR_DUPLICATE_NODE_TYPE');

1144: hr_utility.set_location('Error:Duplicate Node Type', 20);
1145: end if;
1146: -- This is a duplicate entry..so raise error.
1147: Close csr_chk_duplicate;
1148: fnd_message.set_name('PQH','PQH_GHR_DUPLICATE_NODE_TYPE');
1149: fnd_message.raise_error;
1150: End if;
1151: Close csr_chk_duplicate;
1152:

Line 1149: fnd_message.raise_error;

1145: end if;
1146: -- This is a duplicate entry..so raise error.
1147: Close csr_chk_duplicate;
1148: fnd_message.set_name('PQH','PQH_GHR_DUPLICATE_NODE_TYPE');
1149: fnd_message.raise_error;
1150: End if;
1151: Close csr_chk_duplicate;
1152:
1153: For c_rec in csr_chk_recursion

Line 1161: fnd_message.set_name('PQH','PQH_GHR_RECURSIVE_NODE_TYPE');

1157: if g_debug then
1158: hr_utility.set_location('Error:Recursive Structure', 30);
1159: end if;
1160: -- This will cause recursion
1161: fnd_message.set_name('PQH','PQH_GHR_RECURSIVE_NODE_TYPE');
1162: fnd_message.raise_error;
1163: end if;
1164: End loop;
1165:

Line 1162: fnd_message.raise_error;

1158: hr_utility.set_location('Error:Recursive Structure', 30);
1159: end if;
1160: -- This will cause recursion
1161: fnd_message.set_name('PQH','PQH_GHR_RECURSIVE_NODE_TYPE');
1162: fnd_message.raise_error;
1163: end if;
1164: End loop;
1165:
1166: if(p_parent_node_type = p_child_node_type)

Line 1172: fnd_message.set_name('PQH','PQH_GHR_RECURSIVE_NODE_TYPE');

1168: if g_debug then
1169: hr_utility.set_location('Error:Recursive Structure', 40);
1170: end if;
1171: -- Again a recursive case
1172: fnd_message.set_name('PQH','PQH_GHR_RECURSIVE_NODE_TYPE');
1173: fnd_message.raise_error;
1174: end if;
1175: --
1176: --

Line 1173: fnd_message.raise_error;

1169: hr_utility.set_location('Error:Recursive Structure', 40);
1170: end if;
1171: -- Again a recursive case
1172: fnd_message.set_name('PQH','PQH_GHR_RECURSIVE_NODE_TYPE');
1173: fnd_message.raise_error;
1174: end if;
1175: --
1176: --
1177: -- All validations are passed. Insert values into the table

Line 1271: fnd_message.set_name('PQH','PQH_GHR_NO_NODE_TYPE_ENTRY');

1267: hr_utility.set_location('Error: No Matching Node Type Entry', 20);
1268: end if;
1269: --
1270: Close csr_node_type_entry;
1271: fnd_message.set_name('PQH','PQH_GHR_NO_NODE_TYPE_ENTRY');
1272: fnd_message.raise_error;
1273: End if;
1274: Close csr_node_type_entry;
1275: --

Line 1272: fnd_message.raise_error;

1268: end if;
1269: --
1270: Close csr_node_type_entry;
1271: fnd_message.set_name('PQH','PQH_GHR_NO_NODE_TYPE_ENTRY');
1272: fnd_message.raise_error;
1273: End if;
1274: Close csr_node_type_entry;
1275: --
1276: If (p_object_version_number

Line 1283: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');

1279: if g_debug then
1280: hr_utility.set_location('Error:Invalid Object Version', 30);
1281: end if;
1282: --
1283: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
1284: fnd_message.raise_error;
1285: End If;
1286: --
1287: -- Increment object_version_number

Line 1284: fnd_message.raise_error;

1280: hr_utility.set_location('Error:Invalid Object Version', 30);
1281: end if;
1282: --
1283: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
1284: fnd_message.raise_error;
1285: End If;
1286: --
1287: -- Increment object_version_number
1288: --

Line 1324: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');

1320: if g_debug then
1321: hr_utility.set_location('Error: Object Locked', 60);
1322: end if;
1323: --
1324: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
1325: fnd_message.set_token('TABLE_NAME', 'per_gen_hier_node_types');
1326: fnd_msg_pub.add;
1327: When others
1328: then

Line 1325: fnd_message.set_token('TABLE_NAME', 'per_gen_hier_node_types');

1321: hr_utility.set_location('Error: Object Locked', 60);
1322: end if;
1323: --
1324: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
1325: fnd_message.set_token('TABLE_NAME', 'per_gen_hier_node_types');
1326: fnd_msg_pub.add;
1327: When others
1328: then
1329: if g_debug then

Line 1408: fnd_message.set_name('PQH','PQH_GHR_NO_NODE_TYPE_ENTRY');

1404: hr_utility.set_location('Error: No Matching Node Type Entry', 20);
1405: end if;
1406: --
1407: Close csr_node_type_entry;
1408: fnd_message.set_name('PQH','PQH_GHR_NO_NODE_TYPE_ENTRY');
1409: fnd_message.raise_error;
1410: End if;
1411: Close csr_node_type_entry;
1412: --

Line 1409: fnd_message.raise_error;

1405: end if;
1406: --
1407: Close csr_node_type_entry;
1408: fnd_message.set_name('PQH','PQH_GHR_NO_NODE_TYPE_ENTRY');
1409: fnd_message.raise_error;
1410: End if;
1411: Close csr_node_type_entry;
1412: --
1413: -- Loop through to delete node and children

Line 1449: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');

1445: --
1446: if g_debug then
1447: hr_utility.set_location('Error: Object Locked', 50);
1448: end if;
1449: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
1450: fnd_message.set_token('TABLE_NAME', 'per_gen_hier_node_types');
1451: fnd_msg_pub.add;
1452: When others
1453: then

Line 1450: fnd_message.set_token('TABLE_NAME', 'per_gen_hier_node_types');

1446: if g_debug then
1447: hr_utility.set_location('Error: Object Locked', 50);
1448: end if;
1449: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
1450: fnd_message.set_token('TABLE_NAME', 'per_gen_hier_node_types');
1451: fnd_msg_pub.add;
1452: When others
1453: then
1454: if g_debug then