1032:
1033: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1034: THEN
1035:
1036: FND_MESSAGE.SET_NAME('OE','OE_LOCK_ROW_CHANGED');
1037: OE_MSG_PUB.Add;
1038:
1039: END IF;
1040:
1049:
1050: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1051: THEN
1052:
1053: FND_MESSAGE.SET_NAME('OE','OE_LOCK_ROW_DELETED');
1054: OE_MSG_PUB.Add;
1055:
1056: END IF;
1057: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
1061:
1062: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1063: THEN
1064:
1065: FND_MESSAGE.SET_NAME('OE','OE_LOCK_ROW_ALREADY_LOCKED');
1066: OE_MSG_PUB.Add;
1067:
1068: END IF;
1069: WHEN OTHERS THEN
1153:
1154: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1155: THEN
1156:
1157: FND_MESSAGE.SET_NAME('OE','FND_BOTH_VAL_AND_ID_EXIST');
1158: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','agreement');
1159: OE_MSG_PUB.Add;
1160:
1161: END IF;
1154: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1155: THEN
1156:
1157: FND_MESSAGE.SET_NAME('OE','FND_BOTH_VAL_AND_ID_EXIST');
1158: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','agreement');
1159: OE_MSG_PUB.Add;
1160:
1161: END IF;
1162:
1183:
1184: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1185: THEN
1186:
1187: FND_MESSAGE.SET_NAME('OE','FND_BOTH_VAL_AND_ID_EXIST');
1188: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','discount');
1189: OE_MSG_PUB.Add;
1190:
1191: END IF;
1184: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1185: THEN
1186:
1187: FND_MESSAGE.SET_NAME('OE','FND_BOTH_VAL_AND_ID_EXIST');
1188: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','discount');
1189: OE_MSG_PUB.Add;
1190:
1191: END IF;
1192:
1213:
1214: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1215: THEN
1216:
1217: FND_MESSAGE.SET_NAME('OE','FND_BOTH_VAL_AND_ID_EXIST');
1218: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_list');
1219: OE_MSG_PUB.Add;
1220:
1221: END IF;
1214: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1215: THEN
1216:
1217: FND_MESSAGE.SET_NAME('OE','FND_BOTH_VAL_AND_ID_EXIST');
1218: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_list');
1219: OE_MSG_PUB.Add;
1220:
1221: END IF;
1222: