40: THEN
41:
42: l_return_status := FND_API.G_RET_STS_ERROR;
43:
44: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
45: THEN
46:
47: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
48: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','payment');
45: THEN
46:
47: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
48: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','payment');
49: oe_msg_pub.Add;
50:
51: END IF;
52:
53: END IF;
56: THEN
57:
58: l_return_status := FND_API.G_RET_STS_ERROR;
59:
60: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
61: THEN
62:
63: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
64: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Header');
61: THEN
62:
63: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
64: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Header');
65: oe_msg_pub.Add;
66:
67: END IF;
68:
69: END IF;
73: THEN
74:
75: l_return_status := FND_API.G_RET_STS_ERROR;
76:
77: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
78: THEN
79:
80: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
81: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','LINE');
78: THEN
79:
80: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
81: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','LINE');
82: oe_msg_pub.Add;
83:
84: END IF;
85:
86: END IF;
96: --bug 5176015
97: /*IF p_Line_Payment_rec.credit_card_number IS NULL THEN
98: l_return_status := FND_API.G_RET_STS_ERROR;
99:
100: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
101: THEN
102:
103: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
104: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','CREDIT_CARD_NUMBER');
101: THEN
102:
103: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
104: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','CREDIT_CARD_NUMBER');
105: oe_msg_pub.Add;
106:
107: END IF;
108: ELSIF p_line_Payment_rec.credit_card_holder_name IS NULL THEN
109: l_return_status := FND_API.G_RET_STS_ERROR;
107: END IF;
108: ELSIF p_line_Payment_rec.credit_card_holder_name IS NULL THEN
109: l_return_status := FND_API.G_RET_STS_ERROR;
110:
111: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
112: THEN
113:
114: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
115: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','CREDIT_CARD_HOLDER_NAME');
112: THEN
113:
114: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
115: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','CREDIT_CARD_HOLDER_NAME');
116: oe_msg_pub.Add;
117:
118: END IF;
119: ELSIF p_line_Payment_rec.credit_card_expiration_date IS NULL THEN
120: l_return_status := FND_API.G_RET_STS_ERROR;
118: END IF;
119: ELSIF p_line_Payment_rec.credit_card_expiration_date IS NULL THEN
120: l_return_status := FND_API.G_RET_STS_ERROR;
121:
122: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
123: THEN
124:
125: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
126: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','CREDIT_CARD_EXPIRATION_DATE');
123: THEN
124:
125: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
126: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','CREDIT_CARD_EXPIRATION_DATE');
127: oe_msg_pub.Add;
128:
129: END IF;
130: END IF;*/
131: --bug 5176015
191:
192: IF NOT l_lin_cc_pmt_allowed THEN
193: l_return_status := FND_API.G_RET_STS_ERROR;
194:
195: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
196: THEN
197:
198: FND_MESSAGE.SET_NAME('ONT','ONT_LIN_CC_NOT_ALLOWED');
199: oe_msg_pub.Add;
195: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
196: THEN
197:
198: FND_MESSAGE.SET_NAME('ONT','ONT_LIN_CC_NOT_ALLOWED');
199: oe_msg_pub.Add;
200:
201: END IF;
202:
203: END IF;
217: End;
218:
219: IF l_invoice_to_org_id IS NULL THEN
220: l_return_status := FND_API.G_RET_STS_ERROR;
221: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
222: THEN
223: FND_MESSAGE.SET_NAME('ONT', 'OE_VPM_INV_TO_REQUIRED');
224: oe_msg_pub.Add;
225: END IF;
220: l_return_status := FND_API.G_RET_STS_ERROR;
221: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
222: THEN
223: FND_MESSAGE.SET_NAME('ONT', 'OE_VPM_INV_TO_REQUIRED');
224: oe_msg_pub.Add;
225: END IF;
226: END IF;
227: --R12 CC Encryption
228: END IF; --Trxn extension id is null
230:
231: IF p_Line_Payment_rec.check_number IS NULL THEN
232: l_return_status := FND_API.G_RET_STS_ERROR;
233:
234: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
235: THEN
236:
237: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
238: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','CHECK_NUMBER');
235: THEN
236:
237: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
238: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','CHECK_NUMBER');
239: oe_msg_pub.Add;
240:
241: END IF;
242: END IF;
243:
246:
247: IF p_Line_Payment_rec.payment_trx_id 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','Bank Account ID');
251: THEN
252:
253: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
254: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Bank Account ID');
255: oe_msg_pub.Add;
256:
257: END IF;
258: END IF;
259: */
288:
289: IF l_count > 0 or l_comt_count > 0 THEN
290: l_return_status := FND_API.G_RET_STS_ERROR;
291:
292: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
293: THEN
294:
295: FND_MESSAGE.SET_NAME('ONT','ONT_INVOICE_PAYMENT_INSTRUMENT');
296: oe_msg_pub.Add;
292: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
293: THEN
294:
295: FND_MESSAGE.SET_NAME('ONT','ONT_INVOICE_PAYMENT_INSTRUMENT');
296: oe_msg_pub.Add;
297:
298: END IF;
299: END IF;
300:
320: oe_Debug_Pub.add('OEXLLPMB.pls: Prepayment exists at order level');
321:
322: l_return_status := FND_API.G_RET_STS_ERROR;
323:
324: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
325: THEN
326: fnd_message.set_name('ONT', 'ONT_LINE_INVOICE_NOT_SUPPORTED');
327: oe_msg_pub.Add;
328: END IF;
323:
324: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
325: THEN
326: fnd_message.set_name('ONT', 'ONT_LINE_INVOICE_NOT_SUPPORTED');
327: oe_msg_pub.Add;
328: END IF;
329:
330: end if;
331:
333: ELSIF p_Line_Payment_rec.payment_collection_event = 'PREPAY' THEN
334:
335: l_return_status := FND_API.G_RET_STS_ERROR;
336:
337: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
338: THEN
339: -- Prepayment instruments are not supported at line level
340: FND_MESSAGE.SET_NAME('ONT','ONT_LINE_PREPAY_NOT_SUPPORTED');
341: oe_msg_pub.Add;
337: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
338: THEN
339: -- Prepayment instruments are not supported at line level
340: FND_MESSAGE.SET_NAME('ONT','ONT_LINE_PREPAY_NOT_SUPPORTED');
341: oe_msg_pub.Add;
342:
343: END IF;
344:
345: END IF;
348:
349: IF p_Line_Payment_rec.receipt_method_id IS NULL THEN
350: l_return_status := FND_API.G_RET_STS_ERROR;
351:
352: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
353: THEN
354:
355: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
356: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Receipt Method');
353: THEN
354:
355: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
356: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Receipt Method');
357: oe_msg_pub.Add;
358:
359: END IF;
360: END IF;
361:
396: WHEN OTHERS THEN
397:
398: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
399:
400: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
401: THEN
402: oe_msg_pub.Add_Exc_Msg
403: ( G_PKG_NAME
404: , 'Entity'
398: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
399:
400: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
401: THEN
402: oe_msg_pub.Add_Exc_Msg
403: ( G_PKG_NAME
404: , 'Entity'
405: );
406: END IF;
542: IF p_Line_Payment_rec.instrument_security_code IS NULL OR
543: p_Line_Payment_rec.instrument_security_code = FND_API.G_MISS_CHAR
544: THEN
545: FND_MESSAGE.SET_NAME('ONT','OE_CC_SECURITY_CODE_REQD');
546: OE_MSG_PUB.ADD;
547: x_return_status := FND_API.G_RET_STS_ERROR;
548: END IF;
549: END IF;
550: END IF;
810: WHEN OTHERS THEN
811:
812: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
813:
814: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
815: THEN
816: oe_msg_pub.Add_Exc_Msg
817: ( G_PKG_NAME
818: , 'Attributes'
812: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
813:
814: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
815: THEN
816: oe_msg_pub.Add_Exc_Msg
817: ( G_PKG_NAME
818: , 'Attributes'
819: );
820: END IF;
852: WHEN OTHERS THEN
853:
854: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
855:
856: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
857: THEN
858: oe_msg_pub.Add_Exc_Msg
859: ( G_PKG_NAME
860: , 'Entity_Delete'
854: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
855:
856: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
857: THEN
858: oe_msg_pub.Add_Exc_Msg
859: ( G_PKG_NAME
860: , 'Entity_Delete'
861: );
862: END IF;