35: ,p_sales_credit_id);
36: fetch C_Dup_Salescredit into l_dummy;
37: close C_Dup_Salescredit;
38: IF l_dummy = 'DUPLICATE' THEN
39: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
40: THEN
41:
42: FND_MESSAGE.SET_NAME('ONT','OE_VAL_DUP_ORDER_CREDIT');
43: oe_msg_pub.Add;
80: THEN
81:
82: l_return_status := FND_API.G_RET_STS_ERROR;
83:
84: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
85: THEN
86:
87: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
88: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','sales_credit');
100: THEN
101:
102: l_return_status := FND_API.G_RET_STS_ERROR;
103:
104: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
105: THEN
106:
107: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
108: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','HEADER');
117: THEN
118:
119: l_return_status := FND_API.G_RET_STS_ERROR;
120:
121: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
122: THEN
123:
124: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
125: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','PERCENT');
133: THEN
134:
135: l_return_status := FND_API.G_RET_STS_ERROR;
136:
137: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
138: THEN
139:
140: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
141: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','sales_credit_type');
193: WHEN OTHERS THEN
194:
195: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
196:
197: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
198: THEN
199: oe_msg_pub.Add_Exc_Msg
200: ( G_PKG_NAME
201: , 'Entity'
387: WHEN OTHERS THEN
388:
389: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
390:
391: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
392: THEN
393: oe_msg_pub.Add_Exc_Msg
394: ( G_PKG_NAME
395: , 'Attributes'