eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_VALIDATE_HEADER_PAYMENT dependencies on FND_API

Line 17: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

13: , p_old_Header_Payment_rec IN OE_Order_PUB.Header_Payment_Rec_Type :=
14: OE_Order_PUB.G_MISS_HEADER_PAYMENT_REC
15: )
16: IS
17: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
18: l_prepay_payment_amount NUMBER := 0;
19: l_prepaid_amount NUMBER := 0;
20: l_count NUMBER := 0;
21: l_line_payment_count NUMBER := 0;

Line 32: l_return_status := FND_API.G_RET_STS_ERROR;

28:
29: IF p_Header_Payment_rec.payment_number IS NULL
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:

Line 48: l_return_status := FND_API.G_RET_STS_ERROR;

44:
45: IF p_Header_Payment_rec.payment_type_code IS NULL
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:

Line 66: l_return_status := FND_API.G_RET_STS_ERROR;

62:
63: /*
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:

Line 83: l_return_status := FND_API.G_RET_STS_ERROR;

79:
80:
81: IF p_Header_Payment_rec.payment_amount is null THEN
82:
83: l_return_status := FND_API.G_RET_STS_ERROR;
84:
85: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
86: THEN
87:

Line 98: l_return_status := FND_API.G_RET_STS_ERROR;

94: END IF;
95:
96: IF p_Header_Payment_rec.payment_amount < 0 THEN
97:
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:

Line 142: l_return_status := FND_API.G_RET_STS_ERROR;

138:
139: IF (p_Header_Payment_rec.payment_amount + l_prepay_payment_amount)
140: > OE_OE_TOTALS_SUMMARY.Outbound_Order_Total(p_Header_Payment_rec.header_id) THEN
141:
142: l_return_status := FND_API.G_RET_STS_ERROR;
143:
144: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
145: THEN
146:

Line 172: l_return_status := FND_API.G_RET_STS_ERROR;

168: fnd_message.set_name('ONT', 'ONT_LINE_PAYMENTS_EXIST');
169: oe_msg_pub.add;
170: END IF;
171:
172: l_return_status := FND_API.G_RET_STS_ERROR;
173:
174: end if;
175:
176: END IF; -- if payment_collection_event = 'PREPAY'

Line 184: l_return_status := FND_API.G_RET_STS_ERROR;

180:
181: IF p_Header_Payment_rec.HEADER_ID IS NULL
182: THEN
183:
184: l_return_status := FND_API.G_RET_STS_ERROR;
185:
186: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
187: THEN
188:

Line 202: l_return_status := FND_API.G_RET_STS_ERROR;

198: --R12 CC Encryption
199: IF p_header_payment_rec.trxn_extension_id is null then
200: --bug 5176015
201: /*IF p_Header_Payment_rec.credit_card_number IS NULL THEN
202: l_return_status := FND_API.G_RET_STS_ERROR;
203:
204: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
205: THEN
206:

Line 213: l_return_status := FND_API.G_RET_STS_ERROR;

209: oe_msg_pub.Add;
210:
211: END IF;
212: ELSIF p_Header_Payment_rec.credit_card_holder_name IS NULL THEN
213: l_return_status := FND_API.G_RET_STS_ERROR;
214:
215: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
216: THEN
217:

Line 224: l_return_status := FND_API.G_RET_STS_ERROR;

220: oe_msg_pub.Add;
221:
222: END IF;
223: ELSIF p_Header_Payment_rec.credit_card_expiration_date IS NULL THEN
224: l_return_status := FND_API.G_RET_STS_ERROR;
225:
226: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
227: THEN
228:

Line 249: l_return_status := FND_API.G_RET_STS_ERROR;

245: Null;
246: End;
247: oe_debug_pub.add('Invoice to org id'||l_invoice_to_org_id);
248: IF l_invoice_to_org_id IS NULL THEN
249: l_return_status := FND_API.G_RET_STS_ERROR;
250: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
251: THEN
252: FND_MESSAGE.SET_NAME('ONT', 'OE_VPM_INV_TO_REQUIRED');
253: oe_msg_pub.Add;

Line 263: l_return_status := FND_API.G_RET_STS_ERROR;

259:
260: ELSIF p_Header_Payment_rec.payment_type_code = 'CHECK' THEN
261:
262: IF p_Header_Payment_rec.check_number IS NULL THEN
263: l_return_status := FND_API.G_RET_STS_ERROR;
264:
265: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
266: THEN
267:

Line 279: l_return_status := FND_API.G_RET_STS_ERROR;

275: ELSIF p_Header_Payment_rec.payment_type_code in ('ACH', 'DIRECT_DEBIT')
276: THEN
277:
278: IF p_Header_Payment_rec.payment_trx_id IS NULL THEN
279: l_return_status := FND_API.G_RET_STS_ERROR;
280:
281: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
282: THEN
283:

Line 297: l_return_status := FND_API.G_RET_STS_ERROR;

293:
294: IF p_Header_Payment_rec.payment_type_code in ('ACH', 'DIRECT_DEBIT') THEN
295:
296: IF p_Header_Payment_rec.receipt_method_id IS NULL THEN
297: l_return_status := FND_API.G_RET_STS_ERROR;
298:
299: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
300: THEN
301:

Line 326: l_return_status := FND_API.G_RET_STS_ERROR;

322: AND nvl(payment_collection_event, 'INVOICE') = 'INVOICE'
323: AND nvl(payment_number, -1) <> nvl(p_Header_Payment_rec.payment_number, -1);
324:
325: IF l_count > 0 THEN
326: l_return_status := FND_API.G_RET_STS_ERROR;
327:
328: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
329: THEN
330:

Line 341: l_return_status := FND_API.G_RET_STS_ERROR;

337: p_Header_Payment_rec.payment_collection_event = 'PREPAY' THEN
338:
339: -- wire transfer is not supported for prepayment
340:
341: l_return_status := FND_API.G_RET_STS_ERROR;
342:
343: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
344: THEN
345: -- Wire Transfer is not supported for prepayments.

Line 355: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

351: END IF;
352:
353: -- Return Error if a required attribute is missing.
354:
355: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
356:
357: RAISE FND_API.G_EXC_ERROR;
358:
359: END IF;

Line 357: RAISE FND_API.G_EXC_ERROR;

353: -- Return Error if a required attribute is missing.
354:
355: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
356:
357: RAISE FND_API.G_EXC_ERROR;
358:
359: END IF;
360:
361: --

Line 377: WHEN FND_API.G_EXC_ERROR THEN

373:
374: OE_DEBUG_PUB.Add('Exiting OE_VALIDATE_Header_Payments.Entity',1);
375: EXCEPTION
376:
377: WHEN FND_API.G_EXC_ERROR THEN
378:
379: x_return_status := FND_API.G_RET_STS_ERROR;
380:
381: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 379: x_return_status := FND_API.G_RET_STS_ERROR;

375: EXCEPTION
376:
377: WHEN FND_API.G_EXC_ERROR THEN
378:
379: x_return_status := FND_API.G_RET_STS_ERROR;
380:
381: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
382:
383: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 381: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

377: WHEN FND_API.G_EXC_ERROR THEN
378:
379: x_return_status := FND_API.G_RET_STS_ERROR;
380:
381: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
382:
383: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
384:
385: WHEN OTHERS THEN

Line 383: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

379: x_return_status := FND_API.G_RET_STS_ERROR;
380:
381: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
382:
383: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
384:
385: WHEN OTHERS THEN
386:
387: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 387: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

383: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
384:
385: WHEN OTHERS THEN
386:
387: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
388:
389: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
390: THEN
391: oe_msg_pub.Add_Exc_Msg

Line 413: x_return_status := FND_API.G_RET_STS_SUCCESS;

409: l_cc_security_code_use VARCHAR2(20); --R12 CVV2
410: BEGIN
411:
412: OE_DEBUG_PUB.Add('Entering OE_VALIDATE_Header_Payments.Attributes',1);
413: x_return_status := FND_API.G_RET_STS_SUCCESS;
414:
415: -- Validate Header_Payment attributes
416:
417: IF p_Header_Payment_rec.created_by IS NOT NULL AND

Line 423: x_return_status := FND_API.G_RET_STS_ERROR;

419: p_old_Header_Payment_rec.created_by OR
420: p_old_Header_Payment_rec.created_by IS NULL )
421: THEN
422: IF NOT OE_Validate.Created_By(p_Header_Payment_rec.created_by) THEN
423: x_return_status := FND_API.G_RET_STS_ERROR;
424: END IF;
425: END IF;
426: oe_debug_pub.add('return status 1 : ' || x_return_status);
427:

Line 434: x_return_status := FND_API.G_RET_STS_ERROR;

430: p_old_Header_Payment_rec.creation_date OR
431: p_old_Header_Payment_rec.creation_date IS NULL )
432: THEN
433: IF NOT OE_Validate.Creation_Date(p_Header_Payment_rec.creation_date) THEN
434: x_return_status := FND_API.G_RET_STS_ERROR;
435: END IF;
436: END IF;
437: oe_debug_pub.add('return status 2 : ' || x_return_status);
438:

Line 445: x_return_status := FND_API.G_RET_STS_ERROR;

441: p_old_Header_Payment_rec.header_id OR
442: p_old_Header_Payment_rec.header_id IS NULL )
443: THEN
444: IF NOT OE_Validate.Header(p_Header_Payment_rec.header_id) THEN
445: x_return_status := FND_API.G_RET_STS_ERROR;
446: END IF;
447: END IF;
448:
449: oe_debug_pub.add('return status 3 : ' || x_return_status);

Line 457: x_return_status := FND_API.G_RET_STS_ERROR;

453: p_old_Header_Payment_rec.last_updated_by OR
454: p_old_Header_Payment_rec.last_updated_by IS NULL )
455: THEN
456: IF NOT OE_Validate.Last_Updated_By(p_Header_Payment_rec.last_updated_by) THEN
457: x_return_status := FND_API.G_RET_STS_ERROR;
458: END IF;
459: END IF;
460:
461: oe_debug_pub.add('return status 4 : ' || x_return_status);

Line 469: x_return_status := FND_API.G_RET_STS_ERROR;

465: p_old_Header_Payment_rec.last_update_date OR
466: p_old_Header_Payment_rec.last_update_date IS NULL )
467: THEN
468: IF NOT OE_Validate.Last_Update_Date(p_Header_Payment_rec.last_update_date) THEN
469: x_return_status := FND_API.G_RET_STS_ERROR;
470: END IF;
471: END IF;
472:
473: oe_debug_pub.add('return status 5 : ' || x_return_status);

Line 481: x_return_status := FND_API.G_RET_STS_ERROR;

477: p_old_Header_Payment_rec.last_update_login OR
478: p_old_Header_Payment_rec.last_update_login IS NULL )
479: THEN
480: IF NOT OE_Validate.Last_Update_Login(p_Header_Payment_rec.last_update_login) THEN
481: x_return_status := FND_API.G_RET_STS_ERROR;
482: END IF;
483: END IF;
484:
485: IF p_Header_Payment_rec.line_id IS NOT NULL AND

Line 491: x_return_status := FND_API.G_RET_STS_ERROR;

487: p_old_Header_Payment_rec.line_id OR
488: p_old_Header_Payment_rec.line_id IS NULL )
489: THEN
490: IF NOT OE_Validate.Line(p_Header_Payment_rec.line_id) THEN
491: x_return_status := FND_API.G_RET_STS_ERROR;
492: END IF;
493: END IF;
494:
495: IF p_Header_Payment_rec.check_number IS NOT NULL AND

Line 501: x_return_status := FND_API.G_RET_STS_ERROR;

497: p_old_Header_Payment_rec.check_number OR
498: p_old_Header_Payment_rec.check_number IS NULL )
499: THEN
500: IF NOT OE_Validate.check_number(p_Header_Payment_rec.check_number) THEN
501: x_return_status := FND_API.G_RET_STS_ERROR;
502: END IF;
503: END IF;
504:
505: IF p_Header_Payment_rec.credit_card_approval_code IS NOT NULL AND

Line 511: x_return_status := FND_API.G_RET_STS_ERROR;

507: p_old_Header_Payment_rec.credit_card_approval_code OR
508: p_old_Header_Payment_rec.credit_card_approval_code IS NULL )
509: THEN
510: IF NOT OE_Validate.credit_card_approval(p_Header_Payment_rec.credit_card_approval_code) THEN
511: x_return_status := FND_API.G_RET_STS_ERROR;
512: END IF;
513: END IF;
514:
515: oe_debug_pub.add('return status 6 : ' || x_return_status);

Line 524: x_return_status := FND_API.G_RET_STS_ERROR;

520: p_old_Header_Payment_rec.credit_card_approval_date OR
521: p_old_Header_Payment_rec.credit_card_approval_date IS NULL )
522: THEN
523: IF NOT OE_Validate.credit_card_approval_date(p_Header_Payment_rec.credit_card_approval_date) THEN
524: x_return_status := FND_API.G_RET_STS_ERROR;
525: END IF;
526: END IF;
527:
528: IF p_Header_Payment_rec.credit_card_code IS NOT NULL AND

Line 534: x_return_status := FND_API.G_RET_STS_ERROR;

530: p_old_Header_Payment_rec.credit_card_code OR
531: p_old_Header_Payment_rec.credit_card_code IS NULL )
532: THEN
533: IF NOT OE_Validate.credit_card(p_Header_Payment_rec.credit_card_code) THEN
534: x_return_status := FND_API.G_RET_STS_ERROR;
535: END IF;
536: END IF;
537:
538: oe_debug_pub.add('return status 7 : ' || x_return_status);

Line 542: IF p_Header_Payment_rec.credit_card_number IS NOT NULL AND p_Header_Payment_rec.credit_card_number <> FND_API.G_MISS_CHAR THEN

538: oe_debug_pub.add('return status 7 : ' || x_return_status);
539: oe_Debug_pub.add('after credit_card_code');
540:
541: --R12 CVV2
542: IF p_Header_Payment_rec.credit_card_number IS NOT NULL AND p_Header_Payment_rec.credit_card_number <> FND_API.G_MISS_CHAR THEN
543: l_cc_security_code_use := OE_Payment_Trxn_Util.Get_CC_Security_Code_Use;
544: IF l_cc_security_code_use = 'REQUIRED' THEN
545: IF p_Header_Payment_rec.instrument_security_code IS NULL OR
546: p_Header_Payment_rec.instrument_security_code = FND_API.G_MISS_CHAR THEN --bug 4613168, issue 22

Line 546: p_Header_Payment_rec.instrument_security_code = FND_API.G_MISS_CHAR THEN --bug 4613168, issue 22

542: IF p_Header_Payment_rec.credit_card_number IS NOT NULL AND p_Header_Payment_rec.credit_card_number <> FND_API.G_MISS_CHAR THEN
543: l_cc_security_code_use := OE_Payment_Trxn_Util.Get_CC_Security_Code_Use;
544: IF l_cc_security_code_use = 'REQUIRED' THEN
545: IF p_Header_Payment_rec.instrument_security_code IS NULL OR
546: p_Header_Payment_rec.instrument_security_code = FND_API.G_MISS_CHAR THEN --bug 4613168, issue 22
547: FND_MESSAGE.SET_NAME('ONT','OE_CC_SECURITY_CODE_REQD');
548: OE_MSG_PUB.ADD;
549: x_return_status := FND_API.G_RET_STS_ERROR;
550: END IF;

Line 549: x_return_status := FND_API.G_RET_STS_ERROR;

545: IF p_Header_Payment_rec.instrument_security_code IS NULL OR
546: p_Header_Payment_rec.instrument_security_code = FND_API.G_MISS_CHAR THEN --bug 4613168, issue 22
547: FND_MESSAGE.SET_NAME('ONT','OE_CC_SECURITY_CODE_REQD');
548: OE_MSG_PUB.ADD;
549: x_return_status := FND_API.G_RET_STS_ERROR;
550: END IF;
551: END IF;
552: END IF;
553: --R12 CVV2

Line 564: x_return_status := FND_API.G_RET_STS_ERROR;

560: p_old_Header_Payment_rec.credit_card_expiration_date OR
561: p_old_Header_Payment_rec.credit_card_expiration_date IS NULL )
562: THEN
563: IF NOT OE_Validate.credit_card_expiration_date(p_Header_Payment_rec.credit_card_expiration_date) THEN
564: x_return_status := FND_API.G_RET_STS_ERROR;
565: END IF;
566: END IF;
567:
568: oe_debug_pub.add('return status 8 : ' || x_return_status);

Line 577: x_return_status := FND_API.G_RET_STS_ERROR;

573: p_old_Header_Payment_rec.credit_card_holder_name OR
574: p_old_Header_Payment_rec.credit_card_holder_name IS NULL )
575: THEN
576: IF NOT OE_Validate.credit_card_holder_name(p_Header_Payment_rec.credit_card_holder_name) THEN
577: x_return_status := FND_API.G_RET_STS_ERROR;
578: END IF;
579: END IF;
580:
581: oe_debug_pub.add('after credit_card_holder_name');

Line 589: x_return_status := FND_API.G_RET_STS_ERROR;

585: p_old_Header_Payment_rec.credit_card_number OR
586: p_old_Header_Payment_rec.credit_card_number IS NULL )
587: THEN
588: IF NOT OE_Validate.credit_card_number(p_Header_Payment_rec.credit_card_number) THEN
589: x_return_status := FND_API.G_RET_STS_ERROR;
590: END IF;
591: END IF;
592:
593: oe_debug_pub.add('after credit_card_number');

Line 601: x_return_status := FND_API.G_RET_STS_ERROR;

597: p_old_Header_Payment_rec.payment_level_code OR
598: p_old_Header_Payment_rec.payment_level_code IS NULL )
599: THEN
600: IF NOT OE_Validate.payment_level(p_Header_Payment_rec.payment_level_code) THEN
601: x_return_status := FND_API.G_RET_STS_ERROR;
602: END IF;
603: END IF;
604:
605: oe_debug_pub.add('return status 9 : ' || x_return_status);

Line 614: x_return_status := FND_API.G_RET_STS_ERROR;

610: p_old_Header_Payment_rec.commitment_applied_amount OR
611: p_old_Header_Payment_rec.commitment_applied_amount IS NULL )
612: THEN
613: IF NOT OE_Validate.commitment_applied_amount(p_Header_Payment_rec.commitment_applied_amount) THEN
614: x_return_status := FND_API.G_RET_STS_ERROR;
615: END IF;
616: END IF;
617:
618: oe_debug_pub.add('after commitment_applied_amount');

Line 627: x_return_status := FND_API.G_RET_STS_ERROR;

623: p_old_Header_Payment_rec.commitment_interfaced_amount OR
624: p_old_Header_Payment_rec.commitment_interfaced_amount IS NULL )
625: THEN
626: IF NOT OE_Validate.commitment_interfaced_amount(p_Header_Payment_rec.commitment_interfaced_amount) THEN
627: x_return_status := FND_API.G_RET_STS_ERROR;
628: END IF;
629: END IF;
630:
631: oe_debug_pub.add('after commitment_interfaced_amount');

Line 639: x_return_status := FND_API.G_RET_STS_ERROR;

635: p_old_Header_Payment_rec.payment_amount OR
636: p_old_Header_Payment_rec.payment_amount IS NULL )
637: THEN
638: IF NOT OE_Validate.payment_amount(p_Header_Payment_rec.payment_amount) THEN
639: x_return_status := FND_API.G_RET_STS_ERROR;
640: END IF;
641: END IF;
642:
643: oe_debug_pub.add('after payment_amount');

Line 651: x_return_status := FND_API.G_RET_STS_ERROR;

647: p_old_Header_Payment_rec.payment_collection_event OR
648: p_old_Header_Payment_rec.payment_collection_event IS NULL )
649: THEN
650: IF NOT OE_Validate.payment_collection_event(p_Header_Payment_rec.payment_collection_event) THEN
651: x_return_status := FND_API.G_RET_STS_ERROR;
652: END IF;
653:
654: select count(payment_type_code) into l_line_payment_count
655: from oe_payments

Line 662: x_return_status := FND_API.G_RET_STS_ERROR;

658:
659: if l_line_payment_count > 0 then
660: fnd_message.set_name('ONT', 'ONT_LINE_PAYMENTS_EXIST');
661: oe_msg_pub.add;
662: x_return_status := FND_API.G_RET_STS_ERROR;
663: end if;
664:
665: END IF;
666:

Line 675: x_return_status := FND_API.G_RET_STS_ERROR;

671: p_old_Header_Payment_rec.payment_trx_id OR
672: p_old_Header_Payment_rec.payment_trx_id IS NULL )
673: THEN
674: IF NOT OE_Validate.payment_trx(p_Header_Payment_rec.payment_trx_id) THEN
675: x_return_status := FND_API.G_RET_STS_ERROR;
676: END IF;
677: END IF;
678:
679: oe_debug_pub.add('after payment_trx_id');

Line 687: x_return_status := FND_API.G_RET_STS_ERROR;

683: p_old_Header_Payment_rec.payment_type_code OR
684: p_old_Header_Payment_rec.payment_type_code IS NULL )
685: THEN
686: IF NOT OE_Validate.payment_type(p_Header_Payment_rec.payment_type_code) THEN
687: x_return_status := FND_API.G_RET_STS_ERROR;
688: END IF;
689: END IF;
690:
691: oe_debug_pub.add('after payment_type_code');

Line 699: x_return_status := FND_API.G_RET_STS_ERROR;

695: p_old_Header_Payment_rec.payment_set_id OR
696: p_old_Header_Payment_rec.payment_set_id IS NULL )
697: THEN
698: IF NOT OE_Validate.payment_set(p_Header_Payment_rec.payment_set_id) THEN
699: x_return_status := FND_API.G_RET_STS_ERROR;
700: END IF;
701: END IF;
702:
703: IF p_Header_Payment_rec.prepaid_amount IS NOT NULL AND

Line 709: x_return_status := FND_API.G_RET_STS_ERROR;

705: p_old_Header_Payment_rec.prepaid_amount OR
706: p_old_Header_Payment_rec.prepaid_amount IS NULL )
707: THEN
708: IF NOT OE_Validate.prepaid_amount(p_Header_Payment_rec.prepaid_amount) THEN
709: x_return_status := FND_API.G_RET_STS_ERROR;
710: END IF;
711: END IF;
712:
713: IF p_Header_Payment_rec.receipt_method_id IS NOT NULL AND

Line 719: x_return_status := FND_API.G_RET_STS_ERROR;

715: p_old_Header_Payment_rec.receipt_method_id OR
716: p_old_Header_Payment_rec.receipt_method_id IS NULL )
717: THEN
718: IF NOT OE_Validate.receipt_method(p_Header_Payment_rec.receipt_method_id) THEN
719: x_return_status := FND_API.G_RET_STS_ERROR;
720: END IF;
721: END IF;
722:
723: IF p_Header_Payment_rec.tangible_id IS NOT NULL AND

Line 729: x_return_status := FND_API.G_RET_STS_ERROR;

725: p_old_Header_Payment_rec.tangible_id OR
726: p_old_Header_Payment_rec.tangible_id IS NULL )
727: THEN
728: IF NOT OE_Validate.tangible(p_Header_Payment_rec.tangible_id) THEN
729: x_return_status := FND_API.G_RET_STS_ERROR;
730: END IF;
731: END IF;
732:
733: IF p_Header_Payment_rec.trxn_extension_id IS NOT NULL AND --R12 Process order api changes

Line 739: x_return_status := FND_API.G_RET_STS_ERROR;

735: p_old_Header_Payment_rec.trxn_extension_id OR
736: p_old_Header_Payment_rec.trxn_extension_id IS NULL )
737: THEN
738: IF NOT OE_Validate.Payment_Trxn_Extension(p_Header_Payment_rec.trxn_extension_id) THEN
739: x_return_status := FND_API.G_RET_STS_ERROR;
740: END IF;
741: END IF; --R12 Process order api changes
742:
743: oe_debug_pub.add('after trxn_extension_id ');

Line 863: x_return_status := FND_API.G_RET_STS_ERROR;

859: ,p_attribute13 => p_Header_Payment_rec.attribute13
860: ,p_attribute14 => p_Header_Payment_rec.attribute14
861: ,p_attribute15 => p_Header_Payment_rec.attribute15) THEN
862:
863: x_return_status := FND_API.G_RET_STS_ERROR;
864: END IF;
865:
866: oe_debug_pub.add('After Payments_Desc_Flex ' || x_return_status,2);
867:

Line 876: WHEN FND_API.G_EXC_ERROR THEN

872: -- Done validating attributes
873:
874: EXCEPTION
875:
876: WHEN FND_API.G_EXC_ERROR THEN
877:
878: x_return_status := FND_API.G_RET_STS_ERROR;
879:
880: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 878: x_return_status := FND_API.G_RET_STS_ERROR;

874: EXCEPTION
875:
876: WHEN FND_API.G_EXC_ERROR THEN
877:
878: x_return_status := FND_API.G_RET_STS_ERROR;
879:
880: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
881:
882: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 880: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

876: WHEN FND_API.G_EXC_ERROR THEN
877:
878: x_return_status := FND_API.G_RET_STS_ERROR;
879:
880: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
881:
882: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
883:
884: WHEN OTHERS THEN

Line 882: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

878: x_return_status := FND_API.G_RET_STS_ERROR;
879:
880: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
881:
882: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
883:
884: WHEN OTHERS THEN
885:
886: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 886: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

882: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
883:
884: WHEN OTHERS THEN
885:
886: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
887:
888: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
889: THEN
890: oe_msg_pub.Add_Exc_Msg

Line 905: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

901: ( x_return_status OUT NOCOPY VARCHAR2
902: , p_Header_Payment_rec IN OE_Order_PUB.Header_Payment_Rec_Type
903: )
904: IS
905: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
906: BEGIN
907:
908: OE_DEBUG_PUB.Add('Entering OE_VALIDATE_Header_Payments.Entity_Delete',1);
909: -- Validate entity delete.

Line 918: WHEN FND_API.G_EXC_ERROR THEN

914: OE_DEBUG_PUB.Add('Exiting OE_VALIDATE_Header_Payments.Entity_Delete',1);
915:
916: EXCEPTION
917:
918: WHEN FND_API.G_EXC_ERROR THEN
919:
920: x_return_status := FND_API.G_RET_STS_ERROR;
921:
922: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 920: x_return_status := FND_API.G_RET_STS_ERROR;

916: EXCEPTION
917:
918: WHEN FND_API.G_EXC_ERROR THEN
919:
920: x_return_status := FND_API.G_RET_STS_ERROR;
921:
922: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
923:
924: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 922: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

918: WHEN FND_API.G_EXC_ERROR THEN
919:
920: x_return_status := FND_API.G_RET_STS_ERROR;
921:
922: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
923:
924: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
925:
926: WHEN OTHERS THEN

Line 924: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

920: x_return_status := FND_API.G_RET_STS_ERROR;
921:
922: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
923:
924: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
925:
926: WHEN OTHERS THEN
927:
928: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 928: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

924: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
925:
926: WHEN OTHERS THEN
927:
928: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
929:
930: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
931: THEN
932: oe_msg_pub.Add_Exc_Msg