[Home] [Help]
30: THEN
31:
32: l_return_status := FND_API.G_RET_STS_ERROR;
33:
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_ATTRIBUTE_REQUIRED');
38: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','payment');
46: THEN
47:
48: l_return_status := FND_API.G_RET_STS_ERROR;
49:
50: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
51: THEN
52:
53: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
54: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','payment type code');
64: IF p_Header_Payment_rec.receipt_method_id is null THEN
65:
66: l_return_status := FND_API.G_RET_STS_ERROR;
67:
68: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
69: THEN
70:
71: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
72: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Receipt Method');
85: THEN
86:
87: l_return_status := FND_API.G_RET_STS_ERROR;
88:
89: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
90: THEN
91:
92: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
93: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','payment amount or percentage');
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','payment amount');
116: /*IF p_Header_Payment_rec.payment_amount is null THEN
117:
118: l_return_status := FND_API.G_RET_STS_ERROR;
119:
120: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
121: THEN
122:
123: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
124: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','payment amount');
131: IF p_Header_Payment_rec.payment_amount < 0 THEN
132:
133: l_return_status := FND_API.G_RET_STS_ERROR;
134:
135: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
136: THEN
137:
138: FND_MESSAGE.SET_NAME('ONT','ONT_NO_NEGTIVE_PAYMENT_AMOUNT');
139: oe_msg_pub.Add;
175: > OE_OE_TOTALS_SUMMARY.Outbound_Order_Total(p_Header_Payment_rec.header_id) THEN
176:
177: l_return_status := FND_API.G_RET_STS_ERROR;
178:
179: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
180: THEN
181:
182: FND_MESSAGE.SET_NAME('ONT','ONT_PREPAYMENT_PERCENT');
183: oe_msg_pub.Add;
197: and payment_type_code <> 'COMMITMENT';
198:
199: if l_line_payment_count > 0 then
200:
201: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
202: THEN
203: fnd_message.set_name('ONT', 'ONT_LINE_PAYMENTS_EXIST');
204: oe_msg_pub.add;
205: END IF;
217: THEN
218:
219: l_return_status := FND_API.G_RET_STS_ERROR;
220:
221: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
222: THEN
223:
224: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
225: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','HEADER');
235: --bug 5176015
236: /*IF p_Header_Payment_rec.credit_card_number IS NULL THEN
237: l_return_status := FND_API.G_RET_STS_ERROR;
238:
239: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
240: THEN
241:
242: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
243: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','CREDIT_CARD_NUMBER');
246: END IF;
247: ELSIF p_Header_Payment_rec.credit_card_holder_name IS NULL THEN
248: l_return_status := FND_API.G_RET_STS_ERROR;
249:
250: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
251: THEN
252:
253: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
254: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','CREDIT_CARD_HOLDER_NAME');
257: END IF;
258: ELSIF p_Header_Payment_rec.credit_card_expiration_date IS NULL THEN
259: l_return_status := FND_API.G_RET_STS_ERROR;
260:
261: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
262: THEN
263:
264: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
265: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','CREDIT_CARD_EXPIRATION_DATE');
281: End;
282: oe_debug_pub.add('Invoice to org id'||l_invoice_to_org_id);
283: IF l_invoice_to_org_id IS NULL THEN
284: l_return_status := FND_API.G_RET_STS_ERROR;
285: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
286: THEN
287: FND_MESSAGE.SET_NAME('ONT', 'OE_VPM_INV_TO_REQUIRED');
288: oe_msg_pub.Add;
289: END IF;
296:
297: IF p_Header_Payment_rec.check_number IS NULL THEN
298: l_return_status := FND_API.G_RET_STS_ERROR;
299:
300: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
301: THEN
302:
303: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
304: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','CHECK_NUMBER');
312:
313: IF p_Header_Payment_rec.payment_trx_id IS NULL THEN
314: l_return_status := FND_API.G_RET_STS_ERROR;
315:
316: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
317: THEN
318:
319: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
320: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Bank Account ID');
330:
331: IF p_Header_Payment_rec.receipt_method_id IS NULL THEN
332: l_return_status := FND_API.G_RET_STS_ERROR;
333:
334: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
335: THEN
336:
337: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
338: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Receipt Method');
359:
360: IF l_count > 0 THEN
361: l_return_status := FND_API.G_RET_STS_ERROR;
362:
363: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
364: THEN
365:
366: FND_MESSAGE.SET_NAME('ONT','ONT_INVOICE_PAYMENT_INSTRUMENT');
367: oe_msg_pub.Add;
374: -- wire transfer is not supported for prepayment
375:
376: l_return_status := FND_API.G_RET_STS_ERROR;
377:
378: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
379: THEN
380: -- Wire Transfer is not supported for prepayments.
381: FND_MESSAGE.SET_NAME('ONT','ONT_NO_WIRE_FOR_PREPAY');
382: oe_msg_pub.Add;
420: WHEN OTHERS THEN
421:
422: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
423:
424: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
425: THEN
426: oe_msg_pub.Add_Exc_Msg
427: ( G_PKG_NAME
428: , 'Entity'
924: WHEN OTHERS THEN
925:
926: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
927:
928: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
929: THEN
930: oe_msg_pub.Add_Exc_Msg
931: ( G_PKG_NAME
932: , 'Attributes'
966: WHEN OTHERS THEN
967:
968: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
969:
970: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
971: THEN
972: oe_msg_pub.Add_Exc_Msg
973: ( G_PKG_NAME
974: , 'Entity_Delete'