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

Line 303: -- FND_MESSAGE.Set_Name('AHL','AHL_PC_UNIT_DEL_HAS_ASSOS');

299: UPDATE ahl_pc_nodes_b
300: SET child_count = NVL(child_count, 1) - 1
301: WHERE pc_node_id = p_x_assos_rec.pc_node_id;
302: --ELSE
303: -- FND_MESSAGE.Set_Name('AHL','AHL_PC_UNIT_DEL_HAS_ASSOS');
304: -- FND_MSG_PUB.ADD;
305: END IF;
306:
307: SET_PC_HEADER_STATUS (p_x_assos_rec.pc_node_id);

Line 649: -- FND_MESSAGE.Set_Name('AHL','AHL_PC_PART_DEL_HAS_ASSOS');

645: UPDATE ahl_pc_nodes_b
646: SET child_count = NVL(child_count, 1) - 1
647: WHERE pc_node_id = p_x_assos_rec.pc_node_id;
648: --ELSE
649: -- FND_MESSAGE.Set_Name('AHL','AHL_PC_PART_DEL_HAS_ASSOS');
650: -- FND_MSG_PUB.ADD;
651: END IF;
652:
653: SET_PC_HEADER_STATUS (p_x_assos_rec.pc_node_id);

Line 789: FND_MESSAGE.Set_Name('AHL','AHL_PC_DOC_NO_REV');

785:
786: -- If revision not chosen, throw error
787: IF (p_x_assos_tbl(i).REVISION_NO IS NULL)
788: THEN
789: FND_MESSAGE.Set_Name('AHL','AHL_PC_DOC_NO_REV');
790: FND_MESSAGE.Set_Token('DOC',p_x_assos_tbl(i).DOCUMENT_NO);
791: FND_MSG_PUB.ADD;
792: RAISE FND_API.G_EXC_ERROR;
793: END IF;

Line 790: FND_MESSAGE.Set_Token('DOC',p_x_assos_tbl(i).DOCUMENT_NO);

786: -- If revision not chosen, throw error
787: IF (p_x_assos_tbl(i).REVISION_NO IS NULL)
788: THEN
789: FND_MESSAGE.Set_Name('AHL','AHL_PC_DOC_NO_REV');
790: FND_MESSAGE.Set_Token('DOC',p_x_assos_tbl(i).DOCUMENT_NO);
791: FND_MSG_PUB.ADD;
792: RAISE FND_API.G_EXC_ERROR;
793: END IF;
794:

Line 806: FND_MESSAGE.Set_Name('AHL','AHL_PC_STATUS_COMPLETE');

802:
803: -- If PC is pending for approval, throw error
804: IF (l_status = 'APPROVAL_PENDING')
805: THEN
806: FND_MESSAGE.Set_Name('AHL','AHL_PC_STATUS_COMPLETE');
807: FND_MSG_PUB.ADD;
808: RAISE FND_API.G_EXC_ERROR;
809: -- If PC is in complete status, there are 2 cases...
810: -- 1. If it has a DRAFT version, allow document association

Line 822: FND_MESSAGE.Set_Name('AHL','AHL_PC_STATUS_COMPLETE');

818: IF (check_draft_version_exists%NOTFOUND)
819: THEN
820:
821: CLOSE check_draft_version_exists;
822: FND_MESSAGE.Set_Name('AHL','AHL_PC_STATUS_COMPLETE');
823: FND_MSG_PUB.ADD;
824: RAISE FND_API.G_EXC_ERROR;
825: ELSE
826:

Line 840: FND_MESSAGE.Set_Name('AHL','AHL_PC_NODE_NOT_FOUND');

836: CLOSE check_node_exists;
837: SET_PC_HEADER_STATUS(p_x_assos_tbl(i).ASO_OBJECT_ID);
838: ELSE
839: CLOSE check_node_exists;
840: FND_MESSAGE.Set_Name('AHL','AHL_PC_NODE_NOT_FOUND');
841: FND_MSG_PUB.ADD;
842: RAISE FND_API.G_EXC_ERROR;
843: END IF;
844: END LOOP;

Line 1067: FND_MESSAGE.Set_Name('AHL','AHL_COM_RECORD_CHANGED');

1063: FETCH get_node_object_version INTO l_object_version_number;
1064: CLOSE get_node_object_version;
1065: IF (l_object_version_number <> p_x_assos_rec.object_version_number)
1066: THEN
1067: FND_MESSAGE.Set_Name('AHL','AHL_COM_RECORD_CHANGED');
1068: FND_MSG_PUB.ADD;
1069: RAISE FND_API.G_EXC_ERROR;
1070: END IF;
1071: END IF;

Line 1081: FND_MESSAGE.set_name( 'AHL','AHL_UC_INVALID_Q_ACTION' );

1077: OPEN check_unit_quarantine (p_x_assos_rec.unit_item_id);
1078: FETCH check_unit_quarantine INTO l_dummy;
1079: IF (check_unit_quarantine%FOUND)
1080: THEN
1081: FND_MESSAGE.set_name( 'AHL','AHL_UC_INVALID_Q_ACTION' );
1082: FND_MSG_PUB.add;
1083: CLOSE check_unit_quarantine;
1084: RAISE FND_API.G_EXC_ERROR;
1085: END IF;

Line 1096: FND_MESSAGE.Set_Name('AHL','AHL_PC_STATUS_COMPLETE');

1092: FETCH get_pc_header_status INTO l_status;
1093: CLOSE get_pc_header_status;
1094: IF (l_status <> 'DRAFT' and l_status <> 'APPROVAL_REJECTED')
1095: THEN
1096: FND_MESSAGE.Set_Name('AHL','AHL_PC_STATUS_COMPLETE');
1097: FND_MSG_PUB.ADD;
1098: RAISE FND_API.G_EXC_ERROR;
1099: END IF;
1100: END IF;

Line 1110: FND_MESSAGE.Set_Name('AHL','AHL_PC_ASSOS_NOT_FOUND');

1106: OPEN check_id_exists_in_PC (p_x_assos_rec.pc_association_id);
1107: FETCH check_id_exists_in_PC INTO l_dummy;
1108: IF (check_id_exists_in_PC%NOTFOUND)
1109: THEN
1110: FND_MESSAGE.Set_Name('AHL','AHL_PC_ASSOS_NOT_FOUND');
1111: FND_MSG_PUB.ADD;
1112: CLOSE check_id_exists_in_PC;
1113: RAISE FND_API.G_EXC_ERROR;
1114: END IF;

Line 1126: FND_MESSAGE.Set_Name('AHL','AHL_PC_UNIT_ITEM_EXISTS');

1122: OPEN check_unit_item_exists (p_x_assos_rec.unit_item_id, p_x_assos_rec.pc_node_id);
1123: FETCH check_unit_item_exists INTO l_dummy;
1124: IF (check_unit_item_exists%FOUND)
1125: THEN
1126: FND_MESSAGE.Set_Name('AHL','AHL_PC_UNIT_ITEM_EXISTS');
1127: FND_MESSAGE.Set_Token('UNIT_NAME',p_x_assos_rec.unit_item_name);
1128: FND_MSG_PUB.ADD;
1129: CLOSE check_unit_item_exists;
1130: RAISE FND_API.G_EXC_ERROR;

Line 1127: FND_MESSAGE.Set_Token('UNIT_NAME',p_x_assos_rec.unit_item_name);

1123: FETCH check_unit_item_exists INTO l_dummy;
1124: IF (check_unit_item_exists%FOUND)
1125: THEN
1126: FND_MESSAGE.Set_Name('AHL','AHL_PC_UNIT_ITEM_EXISTS');
1127: FND_MESSAGE.Set_Token('UNIT_NAME',p_x_assos_rec.unit_item_name);
1128: FND_MSG_PUB.ADD;
1129: CLOSE check_unit_item_exists;
1130: RAISE FND_API.G_EXC_ERROR;
1131: END IF;

Line 1138: FND_MESSAGE.Set_Name('AHL','AHL_PC_UNIT_PART_EXISTS_AT_LVL'); -- SATHAPLI BUG:5576835:Changed to correct message code

1134: OPEN check_unit_item_at_same_level (p_x_assos_rec.unit_item_id, p_x_assos_rec.pc_node_id);
1135: FETCH check_unit_item_at_same_level INTO l_dummy;
1136: IF (check_unit_item_at_same_level%FOUND)
1137: THEN
1138: FND_MESSAGE.Set_Name('AHL','AHL_PC_UNIT_PART_EXISTS_AT_LVL'); -- SATHAPLI BUG:5576835:Changed to correct message code
1139: FND_MESSAGE.Set_Token('UNIT_NAME',p_x_assos_rec.unit_item_name);
1140: FND_MSG_PUB.ADD;
1141: CLOSE check_unit_item_at_same_level;
1142: RAISE FND_API.G_EXC_ERROR;

Line 1139: FND_MESSAGE.Set_Token('UNIT_NAME',p_x_assos_rec.unit_item_name);

1135: FETCH check_unit_item_at_same_level INTO l_dummy;
1136: IF (check_unit_item_at_same_level%FOUND)
1137: THEN
1138: FND_MESSAGE.Set_Name('AHL','AHL_PC_UNIT_PART_EXISTS_AT_LVL'); -- SATHAPLI BUG:5576835:Changed to correct message code
1139: FND_MESSAGE.Set_Token('UNIT_NAME',p_x_assos_rec.unit_item_name);
1140: FND_MSG_PUB.ADD;
1141: CLOSE check_unit_item_at_same_level;
1142: RAISE FND_API.G_EXC_ERROR;
1143: END IF;

Line 1153: FND_MESSAGE.Set_Name('AHL','AHL_PC_UNIT_NOT_FOUND');

1149: OPEN check_unit_exists (p_x_assos_rec.unit_item_id);
1150: FETCH check_unit_exists INTO l_dummy;
1151: IF (check_unit_exists%NOTFOUND)
1152: THEN
1153: FND_MESSAGE.Set_Name('AHL','AHL_PC_UNIT_NOT_FOUND');
1154: FND_MSG_PUB.ADD;
1155: CLOSE check_unit_exists;
1156: RAISE FND_API.G_EXC_ERROR;
1157: END IF;

Line 1164: FND_MESSAGE.Set_Name('AHL','AHL_PC_UNIT_NOT_VALID');

1160: OPEN check_unit_valid (p_x_assos_rec.unit_item_id);
1161: FETCH check_unit_valid INTO l_dummy;
1162: IF (check_unit_valid%NOTFOUND)
1163: THEN
1164: FND_MESSAGE.Set_Name('AHL','AHL_PC_UNIT_NOT_VALID');
1165: FND_MESSAGE.Set_Token('UNIT_NAME',p_x_assos_rec.unit_item_name);
1166: FND_MSG_PUB.ADD;
1167: CLOSE check_unit_valid;
1168: RAISE FND_API.G_EXC_ERROR;

Line 1165: FND_MESSAGE.Set_Token('UNIT_NAME',p_x_assos_rec.unit_item_name);

1161: FETCH check_unit_valid INTO l_dummy;
1162: IF (check_unit_valid%NOTFOUND)
1163: THEN
1164: FND_MESSAGE.Set_Name('AHL','AHL_PC_UNIT_NOT_VALID');
1165: FND_MESSAGE.Set_Token('UNIT_NAME',p_x_assos_rec.unit_item_name);
1166: FND_MSG_PUB.ADD;
1167: CLOSE check_unit_valid;
1168: RAISE FND_API.G_EXC_ERROR;
1169: END IF;

Line 1177: FND_MESSAGE.Set_Name('AHL','AHL_PC_ITEM_NOT_FOUND');

1173: OPEN check_item_exists (p_x_assos_rec.unit_item_id);
1174: FETCH check_item_exists INTO l_dummy;
1175: IF (check_item_exists%NOTFOUND)
1176: THEN
1177: FND_MESSAGE.Set_Name('AHL','AHL_PC_ITEM_NOT_FOUND');
1178: FND_MSG_PUB.ADD;
1179: CLOSE check_item_exists;
1180: RAISE FND_API.G_EXC_ERROR;
1181: END IF;

Line 1188: FND_MESSAGE.Set_Name('AHL','AHL_PC_ITEM_NOT_VALID');

1184: OPEN check_item_valid (p_x_assos_rec.unit_item_id);
1185: FETCH check_item_valid INTO l_dummy;
1186: IF (check_item_valid%NOTFOUND)
1187: THEN
1188: FND_MESSAGE.Set_Name('AHL','AHL_PC_ITEM_NOT_VALID');
1189: FND_MESSAGE.Set_Token('ITEM_NAME',p_x_assos_rec.unit_item_name);
1190: FND_MSG_PUB.ADD;
1191: CLOSE check_item_valid;
1192: RAISE FND_API.G_EXC_ERROR;

Line 1189: FND_MESSAGE.Set_Token('ITEM_NAME',p_x_assos_rec.unit_item_name);

1185: FETCH check_item_valid INTO l_dummy;
1186: IF (check_item_valid%NOTFOUND)
1187: THEN
1188: FND_MESSAGE.Set_Name('AHL','AHL_PC_ITEM_NOT_VALID');
1189: FND_MESSAGE.Set_Token('ITEM_NAME',p_x_assos_rec.unit_item_name);
1190: FND_MSG_PUB.ADD;
1191: CLOSE check_item_valid;
1192: RAISE FND_API.G_EXC_ERROR;
1193: END IF;

Line 1205: FND_MESSAGE.Set_Name('AHL','AHL_PC_ATTACH_LEAF_ONLY');

1201: OPEN check_child_node_exists (p_x_assos_rec.pc_node_id);
1202: FETCH check_child_node_exists INTO l_dummy;
1203: IF (check_child_node_exists%FOUND)
1204: THEN
1205: FND_MESSAGE.Set_Name('AHL','AHL_PC_ATTACH_LEAF_ONLY');
1206: FND_MSG_PUB.ADD;
1207: CLOSE check_child_node_exists;
1208: RAISE FND_API.G_EXC_ERROR;
1209: END IF;