DBA Data[Home] [Help]

APPS.OE_VALIDATE_HEADER_PAYMENT dependencies on OE_MSG_PUB

Line 34: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

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');

Line 39: oe_msg_pub.Add;

35: THEN
36:
37: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
38: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','payment');
39: oe_msg_pub.Add;
40:
41: END IF;
42:
43: END IF;

Line 50: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

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');

Line 55: oe_msg_pub.Add;

51: THEN
52:
53: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
54: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','payment type code');
55: oe_msg_pub.Add;
56:
57: END IF;
58:
59: END IF;

Line 68: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

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');

Line 73: oe_msg_pub.Add;

69: THEN
70:
71: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
72: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Receipt Method');
73: oe_msg_pub.Add;
74:
75: END IF;
76:
77: END IF;

Line 89: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

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');

Line 94: oe_msg_pub.Add;

90: THEN
91:
92: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
93: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','payment amount or percentage');
94: oe_msg_pub.Add;
95:
96: END IF;
97: END IF;
98: ELSE

Line 104: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

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');

Line 109: oe_msg_pub.Add;

105: THEN
106:
107: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
108: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','payment amount');
109: oe_msg_pub.Add;
110:
111: END IF;
112: END IF;
113: END IF;

Line 120: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

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');

Line 125: oe_msg_pub.Add;

121: THEN
122:
123: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
124: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','payment amount');
125: oe_msg_pub.Add;
126:
127: END IF;
128:
129: END IF;*/

Line 135: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

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;

Line 139: oe_msg_pub.Add;

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;
140:
141: END IF;
142:
143: END IF;

Line 179: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

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;

Line 183: oe_msg_pub.Add;

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;
184:
185: END IF;
186:
187: END IF;

Line 201: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

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;

Line 204: oe_msg_pub.add;

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;
206:
207: l_return_status := FND_API.G_RET_STS_ERROR;
208:

Line 221: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

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');

Line 226: oe_msg_pub.Add;

222: THEN
223:
224: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
225: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','HEADER');
226: oe_msg_pub.Add;
227:
228: END IF;
229:
230: END IF;

Line 239: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

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');

Line 244: oe_msg_pub.Add;

240: THEN
241:
242: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
243: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','CREDIT_CARD_NUMBER');
244: oe_msg_pub.Add;
245:
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;

Line 250: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

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');

Line 255: oe_msg_pub.Add;

251: THEN
252:
253: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
254: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','CREDIT_CARD_HOLDER_NAME');
255: oe_msg_pub.Add;
256:
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;

Line 261: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

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');

Line 266: oe_msg_pub.Add;

262: THEN
263:
264: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
265: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','CREDIT_CARD_EXPIRATION_DATE');
266: oe_msg_pub.Add;
267:
268: END IF;
269:
270: END IF;*/

Line 285: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

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;

Line 288: oe_msg_pub.Add;

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;
290: END IF;
291: --R12 CC Encryption
292: END IF;

Line 300: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

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');

Line 305: oe_msg_pub.Add;

301: THEN
302:
303: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
304: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','CHECK_NUMBER');
305: oe_msg_pub.Add;
306:
307: END IF;
308: END IF;
309: /* comment out for R12

Line 316: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

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');

Line 321: oe_msg_pub.Add;

317: THEN
318:
319: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
320: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Bank Account ID');
321: oe_msg_pub.Add;
322:
323: END IF;
324: END IF;
325: */

Line 334: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

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');

Line 339: oe_msg_pub.Add;

335: THEN
336:
337: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
338: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Receipt Method');
339: oe_msg_pub.Add;
340:
341: END IF;
342: END IF;
343:

Line 363: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

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;

Line 367: oe_msg_pub.Add;

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;
368:
369: END IF;
370: END IF;
371: ELSIF p_Header_Payment_rec.payment_type_code = 'WIRE_TRANSFER' AND

Line 378: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

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;

Line 382: oe_msg_pub.Add;

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;
383:
384: END IF;
385:
386: END IF;

Line 424: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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'

Line 426: oe_msg_pub.Add_Exc_Msg

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'
429: );
430: END IF;

Line 583: OE_MSG_PUB.ADD;

579: IF l_cc_security_code_use = 'REQUIRED' THEN
580: IF p_Header_Payment_rec.instrument_security_code IS NULL OR
581: p_Header_Payment_rec.instrument_security_code = FND_API.G_MISS_CHAR THEN --bug 4613168, issue 22
582: FND_MESSAGE.SET_NAME('ONT','OE_CC_SECURITY_CODE_REQD');
583: OE_MSG_PUB.ADD;
584: x_return_status := FND_API.G_RET_STS_ERROR;
585: END IF;
586: END IF;
587: END IF;

Line 698: oe_msg_pub.add;

694: and line_id is not null;
695:
696: if l_line_payment_count > 0 then
697: fnd_message.set_name('ONT', 'ONT_LINE_PAYMENTS_EXIST');
698: oe_msg_pub.add;
699: x_return_status := FND_API.G_RET_STS_ERROR;
700: end if;
701: --16309734 Start
702: END IF;--end if of if prepay condition

Line 928: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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'

Line 930: oe_msg_pub.Add_Exc_Msg

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'
933: );
934: END IF;

Line 970: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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'

Line 972: oe_msg_pub.Add_Exc_Msg

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'
975: );
976: END IF;