26:
27: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
28: THEN
29:
30: FND_MESSAGE.SET_NAME('OE','OE_ATTRIBUTE_REQUIRED');
31: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','attribute1 Missing');
32: OE_MSG_PUB.Add;
33:
34: END IF;
27: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
28: THEN
29:
30: FND_MESSAGE.SET_NAME('OE','OE_ATTRIBUTE_REQUIRED');
31: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','attribute1 Missing');
32: OE_MSG_PUB.Add;
33:
34: END IF;
35:
82: l_return_status := FND_API.G_RET_STS_ERROR;
83:
84: /* IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
85: THEN
86: FND_MESSAGE.SET_NAME('OE','OE_ATTRIBUTE_REQUIRED');
87: FND_MESSAGE.SET_TOKEN('REVISION','revision');
88: OE_MSG_PUB.Add;
89: x_return_status := l_return_status;
90:
83:
84: /* IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
85: THEN
86: FND_MESSAGE.SET_NAME('OE','OE_ATTRIBUTE_REQUIRED');
87: FND_MESSAGE.SET_TOKEN('REVISION','revision');
88: OE_MSG_PUB.Add;
89: x_return_status := l_return_status;
90:
91: END IF;
95: l_return_status := FND_API.G_RET_STS_SUCCESS;
96: /*
97: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
98: THEN
99: FND_MESSAGE.SET_NAME('OE','Changed OE_ATTRIBUTE_REQUIRED');
100: FND_MESSAGE.SET_TOKEN('REVISION','revision');
101: OE_MSG_PUB.Add;
102: x_return_status := l_return_status;
103: END IF;
96: /*
97: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
98: THEN
99: FND_MESSAGE.SET_NAME('OE','Changed OE_ATTRIBUTE_REQUIRED');
100: FND_MESSAGE.SET_TOKEN('REVISION','revision');
101: OE_MSG_PUB.Add;
102: x_return_status := l_return_status;
103: END IF;
104: */
109: l_return_status := FND_API.G_RET_STS_SUCCESS;
110: /*
111: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
112: THEN
113: FND_MESSAGE.SET_NAME('OE','Equal OE_ATTRIBUTE_REQUIRED');
114: FND_MESSAGE.SET_TOKEN('REVISION','revision');
115: OE_MSG_PUB.Add;
116: END IF;
117: */
110: /*
111: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
112: THEN
113: FND_MESSAGE.SET_NAME('OE','Equal OE_ATTRIBUTE_REQUIRED');
114: FND_MESSAGE.SET_TOKEN('REVISION','revision');
115: OE_MSG_PUB.Add;
116: END IF;
117: */
118: end if;
216: if l_Count <> 0 then
217: l_return_status := FND_API.G_RET_STS_ERROR;
218: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
219: THEN
220: FND_MESSAGE.SET_NAME('OE','ATTRIBUTE_REQUIRED');
221: FND_MESSAGE.SET_TOKEN('REVISION','revision');
222: OE_MSG_PUB.Add;
223: END IF;
224: RAISE PLL_DUPLICATES;
217: l_return_status := FND_API.G_RET_STS_ERROR;
218: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
219: THEN
220: FND_MESSAGE.SET_NAME('OE','ATTRIBUTE_REQUIRED');
221: FND_MESSAGE.SET_TOKEN('REVISION','revision');
222: OE_MSG_PUB.Add;
223: END IF;
224: RAISE PLL_DUPLICATES;
225: end if;