34: THEN
35:
36: l_return_status := FND_API.G_RET_STS_ERROR;
37:
38: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
39: THEN
40:
41: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
42: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_adjustment');
39: THEN
40:
41: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
42: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_adjustment');
43: OE_MSG_PUB.Add;
44:
45: END IF;
46:
47: END IF;
52: THEN
53:
54: l_return_status := FND_API.G_RET_STS_ERROR;
55:
56: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
57: THEN
58:
59: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
60: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
58:
59: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
60: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
61: OE_Order_UTIL.Get_Attribute_Name('HEADER_ID'));
62: OE_MSG_PUB.Add;
63:
64: END IF;
65:
66: END IF;
71: THEN
72:
73: l_return_status := FND_API.G_RET_STS_ERROR;
74:
75: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
76: THEN
77:
78: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
79: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','List_header');
76: THEN
77:
78: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
79: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','List_header');
80: OE_MSG_PUB.Add;
81:
82: END IF;
83:
84: END IF;
88: p_Header_adj_rec.list_line_id IS NULL THEN
89:
90: l_return_status := FND_API.G_RET_STS_ERROR;
91:
92: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
93: THEN
94:
95: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
96: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','List_Line');
93: THEN
94:
95: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
96: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','List_Line');
97: OE_MSG_PUB.Add;
98:
99: END IF;
100:
101: END IF;
104: IF p_Header_adj_rec.list_line_type_code IS NULL THEN
105:
106: l_return_status := FND_API.G_RET_STS_ERROR;
107:
108: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
109: THEN
110:
111: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
112: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','List_line_type_code');
109: THEN
110:
111: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
112: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','List_line_type_code');
113: OE_MSG_PUB.Add;
114:
115: END IF;
116:
117: END IF;
144: p_Header_adj_rec.change_reason_code is null THEN
145:
146: l_return_status := FND_API.G_RET_STS_ERROR;
147:
148: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
149: THEN
150:
151: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
152: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','change_reason_code');
149: THEN
150:
151: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
152: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','change_reason_code');
153: OE_MSG_PUB.Add;
154:
155: END IF;
156:
157: END IF; */
160: p_Header_adj_rec.charge_type_code IS NULL THEN
161:
162: l_return_status := FND_API.G_RET_STS_ERROR;
163:
164: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
165: THEN
166:
167: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
168: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
166:
167: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
168: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
169: OE_Order_UTIL.Get_Attribute_Name('CHARGE_TYPE_CODE'));
170: OE_MSG_PUB.Add;
171:
172: END IF;
173:
174: END IF;
178: THEN
179:
180: l_return_status := FND_API.G_RET_STS_ERROR;
181:
182: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
183: THEN
184:
185: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
186: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
184:
185: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
186: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
187: OE_Order_UTIL.Get_Attribute_Name('ADJUSTED_AMOUNT'));
188: OE_MSG_PUB.Add;
189:
190: END IF;
191: END IF;
192:
195: THEN
196:
197: l_return_status := FND_API.G_RET_STS_ERROR;
198:
199: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
200: THEN
201:
202: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
203: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
201:
202: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
203: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
204: OE_Order_UTIL.Get_Attribute_Name('OPERAND'));
205: OE_MSG_PUB.Add;
206:
207: END IF;
208: END IF;
209:
228: END IF;
229: IF l_attribute_name IS NOT NULL THEN
230: l_return_status := FND_API.G_RET_STS_ERROR;
231:
232: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
233: THEN
234:
235: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
236: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',l_attribute_name);
233: THEN
234:
235: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
236: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',l_attribute_name);
237: OE_MSG_PUB.Add;
238:
239: END IF;
240: END IF;
241:
268: l_return_status := FND_API.G_RET_STS_ERROR;
269: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
270: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
271: OE_Order_Util.Get_Attribute_Name('CHARGE_SUBTYPE_CODE'));
272: OE_MSG_PUB.Add;
273:
274: WHEN OTHERS THEN
275: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
276: THEN
271: OE_Order_Util.Get_Attribute_Name('CHARGE_SUBTYPE_CODE'));
272: OE_MSG_PUB.Add;
273:
274: WHEN OTHERS THEN
275: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
276: THEN
277: OE_MSG_PUB.Add_Exc_Msg
278: ( G_PKG_NAME ,
279: 'Record - Charge Type/Subtype validation'
273:
274: WHEN OTHERS THEN
275: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
276: THEN
277: OE_MSG_PUB.Add_Exc_Msg
278: ( G_PKG_NAME ,
279: 'Record - Charge Type/Subtype validation'
280: );
281: END IF;
288: THEN
289:
290: l_return_status := FND_API.G_RET_STS_ERROR;
291:
292: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
293: THEN
294:
295: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
296: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
294:
295: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
296: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
297: OE_Order_Util.Get_Attribute_Name('ARITHMETIC_OPERATOR'));
298: OE_MSG_PUB.Add;
299:
300: END IF;
301:
302: END IF;
336: WHEN OTHERS THEN
337:
338: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
339:
340: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
341: THEN
342: OE_MSG_PUB.Add_Exc_Msg
343: ( G_PKG_NAME
344: , 'Entity'
338: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
339:
340: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
341: THEN
342: OE_MSG_PUB.Add_Exc_Msg
343: ( G_PKG_NAME
344: , 'Entity'
345: );
346: END IF;
832: WHEN OTHERS THEN
833:
834: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
835:
836: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
837: THEN
838: OE_MSG_PUB.Add_Exc_Msg
839: ( G_PKG_NAME
840: , 'Attributes'
834: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
835:
836: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
837: THEN
838: OE_MSG_PUB.Add_Exc_Msg
839: ( G_PKG_NAME
840: , 'Attributes'
841: );
842: END IF;
874: WHEN OTHERS THEN
875:
876: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
877:
878: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
879: THEN
880: OE_MSG_PUB.Add_Exc_Msg
881: ( G_PKG_NAME
882: , 'Entity_Delete'
876: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
877:
878: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
879: THEN
880: OE_MSG_PUB.Add_Exc_Msg
881: ( G_PKG_NAME
882: , 'Entity_Delete'
883: );
884: END IF;