30: ,p_sales_credit_id);
31: FETCH C_Dup_Salescredit INTO l_dummy;
32: CLOSE C_Dup_Salescredit;
33: IF l_dummy = 'DUPLICATE' THEN
34: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
35: THEN
36:
37: FND_MESSAGE.SET_NAME('ONT','OE_VAL_DUP_LINE_CREDIT');
38: oe_msg_pub.add;
34: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
35: THEN
36:
37: FND_MESSAGE.SET_NAME('ONT','OE_VAL_DUP_LINE_CREDIT');
38: oe_msg_pub.add;
39:
40: END IF;
41: OE_DEBUG_PUB.Add('Exiting OE_CNCL_VALIDATE_LINE_SCREDIT.Duplicate_Salescredit',1);
42: Return TRUE;
66: oe_debug_pub.add('Validate Entity - 1',1);
67:
68: l_return_status := FND_API.G_RET_STS_ERROR;
69:
70: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
71: THEN
72:
73: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
74: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','sales_credit');
71: THEN
72:
73: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
74: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','sales_credit');
75: oe_msg_pub.add;
76:
77: END IF;
78:
79: END IF;
84: oe_debug_pub.add('Validate Entity - 1',1);
85:
86: l_return_status := FND_API.G_RET_STS_ERROR;
87:
88: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
89: THEN
90:
91: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
92: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','sales_credit_type_id');
89: THEN
90:
91: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
92: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','sales_credit_type_id');
93: oe_msg_pub.add;
94:
95: END IF;
96:
97: END IF;
103: oe_debug_pub.add('Validate Entity - 2',1);
104:
105: l_return_status := FND_API.G_RET_STS_ERROR;
106:
107: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
108: THEN
109:
110: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
111: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','HEADER');
108: THEN
109:
110: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
111: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','HEADER');
112: oe_msg_pub.add;
113:
114: END IF;
115:
116: END IF;
120: oe_debug_pub.add('Validate Entity - 3',1);
121:
122: l_return_status := FND_API.G_RET_STS_ERROR;
123:
124: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
125: THEN
126:
127: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
128: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','LINE');
125: THEN
126:
127: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
128: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','LINE');
129: oe_msg_pub.add;
130:
131: END IF;
132:
133: END IF;
138: oe_debug_pub.add('Validate Entity - 5',1);
139:
140: l_return_status := FND_API.G_RET_STS_ERROR;
141:
142: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
143: THEN
144:
145: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
146: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','PERCENT');
143: THEN
144:
145: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
146: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','PERCENT');
147: oe_msg_pub.add;
148:
149: END IF;
150:
151: END IF;
201: WHEN OTHERS THEN
202:
203: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
204:
205: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
206: THEN
207: oe_msg_pub.add_Exc_Msg
208: ( G_PKG_NAME
209: , 'Entity'
203: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
204:
205: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
206: THEN
207: oe_msg_pub.add_Exc_Msg
208: ( G_PKG_NAME
209: , 'Entity'
210: );
211: END IF;
375: WHEN OTHERS THEN
376:
377: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
378:
379: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
380: THEN
381: oe_msg_pub.add_Exc_Msg
382: ( G_PKG_NAME
383: , 'Attributes'
377: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
378:
379: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
380: THEN
381: oe_msg_pub.add_Exc_Msg
382: ( G_PKG_NAME
383: , 'Attributes'
384: );
385: END IF;