DBA Data[Home] [Help]

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 823: -- FND_MESSAGE.Set_Name('AHL','AHL_PC_STATUS_COMPLETE');

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

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

840: SET_PC_HEADER_STATUS(p_x_assos_tbl(i).ASO_OBJECT_ID);
841: END IF;
842: ELSE
843: CLOSE check_node_exists;
844: FND_MESSAGE.Set_Name('AHL','AHL_PC_NODE_NOT_FOUND');
845: FND_MSG_PUB.ADD;
846: RAISE FND_API.G_EXC_ERROR;
847: END IF;
848: END LOOP;

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

1069: FETCH get_node_object_version INTO l_object_version_number;
1070: CLOSE get_node_object_version;
1071: IF (l_object_version_number <> p_x_assos_rec.object_version_number)
1072: THEN
1073: FND_MESSAGE.Set_Name('AHL','AHL_COM_RECORD_CHANGED');
1074: FND_MSG_PUB.ADD;
1075: RAISE FND_API.G_EXC_ERROR;
1076: END IF;
1077: END IF;

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

1083: OPEN check_unit_quarantine (p_x_assos_rec.unit_item_id);
1084: FETCH check_unit_quarantine INTO l_dummy;
1085: IF (check_unit_quarantine%FOUND)
1086: THEN
1087: FND_MESSAGE.set_name( 'AHL','AHL_UC_INVALID_Q_ACTION' );
1088: FND_MSG_PUB.add;
1089: CLOSE check_unit_quarantine;
1090: RAISE FND_API.G_EXC_ERROR;
1091: END IF;

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

1098: FETCH get_pc_header_status INTO l_status;
1099: CLOSE get_pc_header_status;
1100: IF (l_status <> 'DRAFT' and l_status <> 'APPROVAL_REJECTED')
1101: THEN
1102: FND_MESSAGE.Set_Name('AHL','AHL_PC_STATUS_COMPLETE');
1103: FND_MSG_PUB.ADD;
1104: RAISE FND_API.G_EXC_ERROR;
1105: END IF;
1106: END IF;

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

1112: OPEN check_id_exists_in_PC (p_x_assos_rec.pc_association_id);
1113: FETCH check_id_exists_in_PC INTO l_dummy;
1114: IF (check_id_exists_in_PC%NOTFOUND)
1115: THEN
1116: FND_MESSAGE.Set_Name('AHL','AHL_PC_ASSOS_NOT_FOUND');
1117: FND_MSG_PUB.ADD;
1118: CLOSE check_id_exists_in_PC;
1119: RAISE FND_API.G_EXC_ERROR;
1120: END IF;

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

1128: OPEN check_unit_item_exists (p_x_assos_rec.unit_item_id, p_x_assos_rec.pc_node_id);
1129: FETCH check_unit_item_exists INTO l_dummy;
1130: IF (check_unit_item_exists%FOUND)
1131: THEN
1132: FND_MESSAGE.Set_Name('AHL','AHL_PC_UNIT_ITEM_EXISTS');
1133: FND_MESSAGE.Set_Token('UNIT_NAME',p_x_assos_rec.unit_item_name);
1134: FND_MSG_PUB.ADD;
1135: CLOSE check_unit_item_exists;
1136: RAISE FND_API.G_EXC_ERROR;

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

1129: FETCH check_unit_item_exists INTO l_dummy;
1130: IF (check_unit_item_exists%FOUND)
1131: THEN
1132: FND_MESSAGE.Set_Name('AHL','AHL_PC_UNIT_ITEM_EXISTS');
1133: FND_MESSAGE.Set_Token('UNIT_NAME',p_x_assos_rec.unit_item_name);
1134: FND_MSG_PUB.ADD;
1135: CLOSE check_unit_item_exists;
1136: RAISE FND_API.G_EXC_ERROR;
1137: END IF;

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

1140: OPEN check_unit_item_at_same_level (p_x_assos_rec.unit_item_id, p_x_assos_rec.pc_node_id);
1141: FETCH check_unit_item_at_same_level INTO l_dummy;
1142: IF (check_unit_item_at_same_level%FOUND)
1143: THEN
1144: FND_MESSAGE.Set_Name('AHL','AHL_PC_UNIT_PART_EXISTS_AT_LVL'); -- SATHAPLI BUG:5576835:Changed to correct message code
1145: FND_MESSAGE.Set_Token('UNIT_NAME',p_x_assos_rec.unit_item_name);
1146: FND_MSG_PUB.ADD;
1147: CLOSE check_unit_item_at_same_level;
1148: RAISE FND_API.G_EXC_ERROR;

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

1141: FETCH check_unit_item_at_same_level INTO l_dummy;
1142: IF (check_unit_item_at_same_level%FOUND)
1143: THEN
1144: FND_MESSAGE.Set_Name('AHL','AHL_PC_UNIT_PART_EXISTS_AT_LVL'); -- SATHAPLI BUG:5576835:Changed to correct message code
1145: FND_MESSAGE.Set_Token('UNIT_NAME',p_x_assos_rec.unit_item_name);
1146: FND_MSG_PUB.ADD;
1147: CLOSE check_unit_item_at_same_level;
1148: RAISE FND_API.G_EXC_ERROR;
1149: END IF;

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

1155: OPEN check_unit_exists (p_x_assos_rec.unit_item_id);
1156: FETCH check_unit_exists INTO l_dummy;
1157: IF (check_unit_exists%NOTFOUND)
1158: THEN
1159: FND_MESSAGE.Set_Name('AHL','AHL_PC_UNIT_NOT_FOUND');
1160: FND_MSG_PUB.ADD;
1161: CLOSE check_unit_exists;
1162: RAISE FND_API.G_EXC_ERROR;
1163: END IF;

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

1166: OPEN check_unit_valid (p_x_assos_rec.unit_item_id);
1167: FETCH check_unit_valid INTO l_dummy;
1168: IF (check_unit_valid%NOTFOUND)
1169: THEN
1170: FND_MESSAGE.Set_Name('AHL','AHL_PC_UNIT_NOT_VALID');
1171: FND_MESSAGE.Set_Token('UNIT_NAME',p_x_assos_rec.unit_item_name);
1172: FND_MSG_PUB.ADD;
1173: CLOSE check_unit_valid;
1174: RAISE FND_API.G_EXC_ERROR;

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

1167: FETCH check_unit_valid INTO l_dummy;
1168: IF (check_unit_valid%NOTFOUND)
1169: THEN
1170: FND_MESSAGE.Set_Name('AHL','AHL_PC_UNIT_NOT_VALID');
1171: FND_MESSAGE.Set_Token('UNIT_NAME',p_x_assos_rec.unit_item_name);
1172: FND_MSG_PUB.ADD;
1173: CLOSE check_unit_valid;
1174: RAISE FND_API.G_EXC_ERROR;
1175: END IF;

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

1179: OPEN check_item_exists (p_x_assos_rec.unit_item_id);
1180: FETCH check_item_exists INTO l_dummy;
1181: IF (check_item_exists%NOTFOUND)
1182: THEN
1183: FND_MESSAGE.Set_Name('AHL','AHL_PC_ITEM_NOT_FOUND');
1184: FND_MSG_PUB.ADD;
1185: CLOSE check_item_exists;
1186: RAISE FND_API.G_EXC_ERROR;
1187: END IF;

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

1190: OPEN check_item_valid (p_x_assos_rec.unit_item_id);
1191: FETCH check_item_valid INTO l_dummy;
1192: IF (check_item_valid%NOTFOUND)
1193: THEN
1194: FND_MESSAGE.Set_Name('AHL','AHL_PC_ITEM_NOT_VALID');
1195: FND_MESSAGE.Set_Token('ITEM_NAME',p_x_assos_rec.unit_item_name);
1196: FND_MSG_PUB.ADD;
1197: CLOSE check_item_valid;
1198: RAISE FND_API.G_EXC_ERROR;

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

1191: FETCH check_item_valid INTO l_dummy;
1192: IF (check_item_valid%NOTFOUND)
1193: THEN
1194: FND_MESSAGE.Set_Name('AHL','AHL_PC_ITEM_NOT_VALID');
1195: FND_MESSAGE.Set_Token('ITEM_NAME',p_x_assos_rec.unit_item_name);
1196: FND_MSG_PUB.ADD;
1197: CLOSE check_item_valid;
1198: RAISE FND_API.G_EXC_ERROR;
1199: END IF;

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

1207: OPEN check_child_node_exists (p_x_assos_rec.pc_node_id);
1208: FETCH check_child_node_exists INTO l_dummy;
1209: IF (check_child_node_exists%FOUND)
1210: THEN
1211: FND_MESSAGE.Set_Name('AHL','AHL_PC_ATTACH_LEAF_ONLY');
1212: FND_MSG_PUB.ADD;
1213: CLOSE check_child_node_exists;
1214: RAISE FND_API.G_EXC_ERROR;
1215: END IF;