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_LINE_PAYMENT dependencies on FND_API

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

13: , p_old_Line_Payment_rec IN OE_Order_PUB.Line_Payment_Rec_Type :=
14: OE_Order_PUB.G_MISS_LINE_PAYMENT_REC
15: )
16: IS
17: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
18: l_count NUMBER := 0;
19: l_comt_count NUMBER := 0;
20: l_prepay_count number;
21: l_term_id number;

Line 42: l_return_status := FND_API.G_RET_STS_ERROR;

38:
39: IF p_Line_Payment_rec.payment_number IS NULL
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:

Line 58: l_return_status := FND_API.G_RET_STS_ERROR;

54:
55: IF p_Line_Payment_rec.HEADER_ID IS NULL
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:

Line 75: l_return_status := FND_API.G_RET_STS_ERROR;

71:
72: IF p_Line_Payment_rec.LINE_ID IS NULL
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:

Line 98: l_return_status := FND_API.G_RET_STS_ERROR;

94: --trxn extension id is null
95: IF p_Line_Payment_rec.trxn_extension_id is null THEN --R12 CC Encryption
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:

Line 109: l_return_status := FND_API.G_RET_STS_ERROR;

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;
110:
111: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
112: THEN
113:

Line 120: l_return_status := FND_API.G_RET_STS_ERROR;

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;
121:
122: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
123: THEN
124:

Line 171: RAISE FND_API.G_EXC_ERROR;

167: FROM oe_order_lines_all
168: WHERE line_id=p_line_Payment_rec.line_id;
169: EXCEPTION
170: WHEN OTHERS THEN
171: RAISE FND_API.G_EXC_ERROR;
172: END;
173:
174: IF l_lin_creation_date <= l_hdr_auth_date THEN
175: l_lin_cc_pmt_allowed := FALSE;

Line 193: l_return_status := FND_API.G_RET_STS_ERROR;

189: l_lin_cc_pmt_allowed := TRUE;
190: END IF;
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:

Line 220: l_return_status := FND_API.G_RET_STS_ERROR;

216: Null;
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;

Line 232: l_return_status := FND_API.G_RET_STS_ERROR;

228: END IF; --Trxn extension id is null
229: ELSIF p_Line_Payment_rec.payment_type_code = 'CHECK' THEN
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:

Line 248: l_return_status := FND_API.G_RET_STS_ERROR;

244: /* commment out for R12
245: ELSIF p_Line_Payment_rec.payment_type_code in ('ACH', 'DIRECT_DEBIT') THEN
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:

Line 290: l_return_status := FND_API.G_RET_STS_ERROR;

286: and payment_type_code = 'COMMITMENT';
287: END IF;
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:

Line 322: l_return_status := FND_API.G_RET_STS_ERROR;

318:
319: if l_prepay_count > 0 and nvl(p_Line_Payment_rec.payment_type_code, 'x') <> 'COMMITMENT' then
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');

Line 335: l_return_status := FND_API.G_RET_STS_ERROR;

331:
332:
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

Line 350: l_return_status := FND_API.G_RET_STS_ERROR;

346:
347: IF p_Line_Payment_rec.payment_type_code in ('ACH', 'DIRECT_DEBIT') THEN
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:

Line 366: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

362: END IF; -- if payment_type_code in ACH, DIRECT_DEBIT, CREDIT_CARD
363:
364: -- Return Error if a required attribute is missing.
365:
366: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
367:
368: RAISE FND_API.G_EXC_ERROR;
369:
370: END IF;

Line 368: RAISE FND_API.G_EXC_ERROR;

364: -- Return Error if a required attribute is missing.
365:
366: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
367:
368: RAISE FND_API.G_EXC_ERROR;
369:
370: END IF;
371:
372: --

Line 388: WHEN FND_API.G_EXC_ERROR THEN

384:
385: OE_DEBUG_PUB.Add('Exiting OE_VALIDATE_Line_Payments.Entity',1);
386: EXCEPTION
387:
388: WHEN FND_API.G_EXC_ERROR THEN
389:
390: x_return_status := FND_API.G_RET_STS_ERROR;
391:
392: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 390: x_return_status := FND_API.G_RET_STS_ERROR;

386: EXCEPTION
387:
388: WHEN FND_API.G_EXC_ERROR THEN
389:
390: x_return_status := FND_API.G_RET_STS_ERROR;
391:
392: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
393:
394: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 392: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

388: WHEN FND_API.G_EXC_ERROR THEN
389:
390: x_return_status := FND_API.G_RET_STS_ERROR;
391:
392: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
393:
394: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
395:
396: WHEN OTHERS THEN

Line 394: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

390: x_return_status := FND_API.G_RET_STS_ERROR;
391:
392: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
393:
394: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
395:
396: WHEN OTHERS THEN
397:
398: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 398: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

394: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
395:
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

Line 423: x_return_status := FND_API.G_RET_STS_SUCCESS;

419: l_cc_security_code_use VARCHAR2(20); --R12 CVV2
420: BEGIN
421:
422: OE_DEBUG_PUB.Add('Entering OE_VALIDATE_Line_Payments.Attributes',1);
423: x_return_status := FND_API.G_RET_STS_SUCCESS;
424:
425: -- Validate Line_Payment attributes
426:
427: IF p_Line_Payment_rec.created_by IS NOT NULL AND

Line 433: x_return_status := FND_API.G_RET_STS_ERROR;

429: p_old_Line_Payment_rec.created_by OR
430: p_old_Line_Payment_rec.created_by IS NULL )
431: THEN
432: IF NOT OE_Validate.Created_By(p_Line_Payment_rec.created_by) THEN
433: x_return_status := FND_API.G_RET_STS_ERROR;
434: END IF;
435: END IF;
436:
437: IF p_Line_Payment_rec.creation_date IS NOT NULL AND

Line 443: x_return_status := FND_API.G_RET_STS_ERROR;

439: p_old_Line_Payment_rec.creation_date OR
440: p_old_Line_Payment_rec.creation_date IS NULL )
441: THEN
442: IF NOT OE_Validate.Creation_Date(p_Line_Payment_rec.creation_date) THEN
443: x_return_status := FND_API.G_RET_STS_ERROR;
444: END IF;
445: END IF;
446:
447: IF p_Line_Payment_rec.header_id IS NOT NULL AND

Line 453: x_return_status := FND_API.G_RET_STS_ERROR;

449: p_old_Line_Payment_rec.header_id OR
450: p_old_Line_Payment_rec.header_id IS NULL )
451: THEN
452: IF NOT OE_Validate.Header(p_Line_Payment_rec.header_id) THEN
453: x_return_status := FND_API.G_RET_STS_ERROR;
454: END IF;
455: END IF;
456:
457: IF p_Line_Payment_rec.last_updated_by IS NOT NULL AND

Line 463: x_return_status := FND_API.G_RET_STS_ERROR;

459: p_old_Line_Payment_rec.last_updated_by OR
460: p_old_Line_Payment_rec.last_updated_by IS NULL )
461: THEN
462: IF NOT OE_Validate.Last_Updated_By(p_Line_Payment_rec.last_updated_by) THEN
463: x_return_status := FND_API.G_RET_STS_ERROR;
464: END IF;
465: END IF;
466:
467: IF p_Line_Payment_rec.last_update_date IS NOT NULL AND

Line 473: x_return_status := FND_API.G_RET_STS_ERROR;

469: p_old_Line_Payment_rec.last_update_date OR
470: p_old_Line_Payment_rec.last_update_date IS NULL )
471: THEN
472: IF NOT OE_Validate.Last_Update_Date(p_Line_Payment_rec.last_update_date) THEN
473: x_return_status := FND_API.G_RET_STS_ERROR;
474: END IF;
475: END IF;
476:
477: IF p_Line_Payment_rec.last_update_login IS NOT NULL AND

Line 483: x_return_status := FND_API.G_RET_STS_ERROR;

479: p_old_Line_Payment_rec.last_update_login OR
480: p_old_Line_Payment_rec.last_update_login IS NULL )
481: THEN
482: IF NOT OE_Validate.Last_Update_Login(p_Line_Payment_rec.last_update_login) THEN
483: x_return_status := FND_API.G_RET_STS_ERROR;
484: END IF;
485: END IF;
486:
487: IF p_Line_Payment_rec.line_id IS NOT NULL AND

Line 493: x_return_status := FND_API.G_RET_STS_ERROR;

489: p_old_Line_Payment_rec.line_id OR
490: p_old_Line_Payment_rec.line_id IS NULL )
491: THEN
492: IF NOT OE_Validate.Line(p_Line_Payment_rec.line_id) THEN
493: x_return_status := FND_API.G_RET_STS_ERROR;
494: END IF;
495: END IF;
496:
497: IF p_Line_Payment_rec.check_number IS NOT NULL AND

Line 503: x_return_status := FND_API.G_RET_STS_ERROR;

499: p_old_Line_Payment_rec.check_number OR
500: p_old_Line_Payment_rec.check_number IS NULL )
501: THEN
502: IF NOT OE_Validate.check_number(p_Line_Payment_rec.check_number) THEN
503: x_return_status := FND_API.G_RET_STS_ERROR;
504: END IF;
505: END IF;
506:
507: IF p_Line_Payment_rec.credit_card_approval_code IS NOT NULL AND

Line 513: x_return_status := FND_API.G_RET_STS_ERROR;

509: p_old_Line_Payment_rec.credit_card_approval_code OR
510: p_old_Line_Payment_rec.credit_card_approval_code IS NULL )
511: THEN
512: IF NOT OE_Validate.credit_card_approval(p_Line_Payment_rec.credit_card_approval_code) THEN
513: x_return_status := FND_API.G_RET_STS_ERROR;
514: END IF;
515: END IF;
516:
517:

Line 524: x_return_status := FND_API.G_RET_STS_ERROR;

520: p_old_Line_Payment_rec.credit_card_approval_date OR
521: p_old_Line_Payment_rec.credit_card_approval_date IS NULL )
522: THEN
523: IF NOT OE_Validate.credit_card_approval_date(p_Line_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_Line_Payment_rec.credit_card_code IS NOT NULL AND

Line 534: x_return_status := FND_API.G_RET_STS_ERROR;

530: p_old_Line_Payment_rec.credit_card_code OR
531: p_old_Line_Payment_rec.credit_card_code IS NULL )
532: THEN
533: IF NOT OE_Validate.credit_card(p_Line_Payment_rec.credit_card_code) THEN
534: x_return_status := FND_API.G_RET_STS_ERROR;
535: END IF;
536: END IF;
537:
538: --R12 CVV2

Line 539: IF p_Line_Payment_rec.credit_card_number IS NOT NULL AND p_Line_Payment_rec.credit_card_number <> FND_API.G_MISS_CHAR THEN --bug 4613168, issue 22

535: END IF;
536: END IF;
537:
538: --R12 CVV2
539: IF p_Line_Payment_rec.credit_card_number IS NOT NULL AND p_Line_Payment_rec.credit_card_number <> FND_API.G_MISS_CHAR THEN --bug 4613168, issue 22
540: l_cc_security_code_use := OE_Payment_Trxn_Util.Get_CC_Security_Code_Use;
541: IF l_cc_security_code_use = 'REQUIRED' THEN
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

Line 543: p_Line_Payment_rec.instrument_security_code = FND_API.G_MISS_CHAR

539: IF p_Line_Payment_rec.credit_card_number IS NOT NULL AND p_Line_Payment_rec.credit_card_number <> FND_API.G_MISS_CHAR THEN --bug 4613168, issue 22
540: l_cc_security_code_use := OE_Payment_Trxn_Util.Get_CC_Security_Code_Use;
541: IF l_cc_security_code_use = 'REQUIRED' THEN
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;

Line 547: x_return_status := FND_API.G_RET_STS_ERROR;

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;
551: --R12 CVV2

Line 559: x_return_status := FND_API.G_RET_STS_ERROR;

555: p_old_Line_Payment_rec.credit_card_expiration_date OR
556: p_old_Line_Payment_rec.credit_card_expiration_date IS NULL )
557: THEN
558: IF NOT OE_Validate.credit_card_expiration_date(p_Line_Payment_rec.credit_card_expiration_date) THEN
559: x_return_status := FND_API.G_RET_STS_ERROR;
560: END IF;
561: END IF;
562:
563: IF p_Line_Payment_rec.credit_card_holder_name IS NOT NULL AND

Line 569: x_return_status := FND_API.G_RET_STS_ERROR;

565: p_old_Line_Payment_rec.credit_card_holder_name OR
566: p_old_Line_Payment_rec.credit_card_holder_name IS NULL )
567: THEN
568: IF NOT OE_Validate.credit_card_holder_name(p_Line_Payment_rec.credit_card_holder_name) THEN
569: x_return_status := FND_API.G_RET_STS_ERROR;
570: END IF;
571: END IF;
572:
573: IF p_Line_Payment_rec.credit_card_number IS NOT NULL AND

Line 579: x_return_status := FND_API.G_RET_STS_ERROR;

575: p_old_Line_Payment_rec.credit_card_number OR
576: p_old_Line_Payment_rec.credit_card_number IS NULL )
577: THEN
578: IF NOT OE_Validate.credit_card_number(p_Line_Payment_rec.credit_card_number) THEN
579: x_return_status := FND_API.G_RET_STS_ERROR;
580: END IF;
581: END IF;
582:
583: IF p_Line_Payment_rec.payment_level_code IS NOT NULL AND

Line 589: x_return_status := FND_API.G_RET_STS_ERROR;

585: p_old_Line_Payment_rec.payment_level_code OR
586: p_old_Line_Payment_rec.payment_level_code IS NULL )
587: THEN
588: IF NOT OE_Validate.payment_level(p_Line_Payment_rec.payment_level_code) THEN
589: x_return_status := FND_API.G_RET_STS_ERROR;
590: END IF;
591: END IF;
592:
593: IF p_Line_Payment_rec.commitment_applied_amount IS NOT NULL AND

Line 599: x_return_status := FND_API.G_RET_STS_ERROR;

595: p_old_Line_Payment_rec.commitment_applied_amount OR
596: p_old_Line_Payment_rec.commitment_applied_amount IS NULL )
597: THEN
598: IF NOT OE_Validate.commitment_applied_amount(p_Line_Payment_rec.commitment_applied_amount) THEN
599: x_return_status := FND_API.G_RET_STS_ERROR;
600: END IF;
601: END IF;
602:
603: IF p_Line_Payment_rec.commitment_interfaced_amount IS NOT NULL AND

Line 609: x_return_status := FND_API.G_RET_STS_ERROR;

605: p_old_Line_Payment_rec.commitment_interfaced_amount OR
606: p_old_Line_Payment_rec.commitment_interfaced_amount IS NULL )
607: THEN
608: IF NOT OE_Validate.commitment_interfaced_amount(p_Line_Payment_rec.commitment_interfaced_amount) THEN
609: x_return_status := FND_API.G_RET_STS_ERROR;
610: END IF;
611: END IF;
612:
613: IF p_Line_Payment_rec.payment_amount IS NOT NULL AND

Line 619: x_return_status := FND_API.G_RET_STS_ERROR;

615: p_old_Line_Payment_rec.payment_amount OR
616: p_old_Line_Payment_rec.payment_amount IS NULL )
617: THEN
618: IF NOT OE_Validate.payment_amount(p_Line_Payment_rec.payment_amount) THEN
619: x_return_status := FND_API.G_RET_STS_ERROR;
620: END IF;
621: END IF;
622:
623: IF p_Line_Payment_rec.payment_collection_event IS NOT NULL AND

Line 629: x_return_status := FND_API.G_RET_STS_ERROR;

625: p_old_Line_Payment_rec.payment_collection_event OR
626: p_old_Line_Payment_rec.payment_collection_event IS NULL )
627: THEN
628: IF NOT OE_Validate.payment_collection_event(p_Line_Payment_rec.payment_collection_event) THEN
629: x_return_status := FND_API.G_RET_STS_ERROR;
630: END IF;
631: END IF;
632:
633: IF p_Line_Payment_rec.payment_trx_id IS NOT NULL AND

Line 639: x_return_status := FND_API.G_RET_STS_ERROR;

635: p_old_Line_Payment_rec.payment_trx_id OR
636: p_old_Line_Payment_rec.payment_trx_id IS NULL )
637: THEN
638: IF NOT OE_Validate.payment_trx(p_Line_Payment_rec.payment_trx_id) THEN
639: x_return_status := FND_API.G_RET_STS_ERROR;
640: END IF;
641: END IF;
642:
643: IF p_Line_Payment_rec.payment_type_code IS NOT NULL AND

Line 649: x_return_status := FND_API.G_RET_STS_ERROR;

645: p_old_Line_Payment_rec.payment_type_code OR
646: p_old_Line_Payment_rec.payment_type_code IS NULL )
647: THEN
648: IF NOT OE_Validate.payment_type(p_Line_Payment_rec.payment_type_code) THEN
649: x_return_status := FND_API.G_RET_STS_ERROR;
650: END IF;
651: END IF;
652:
653: IF p_Line_Payment_rec.payment_set_id IS NOT NULL AND

Line 659: x_return_status := FND_API.G_RET_STS_ERROR;

655: p_old_Line_Payment_rec.payment_set_id OR
656: p_old_Line_Payment_rec.payment_set_id IS NULL )
657: THEN
658: IF NOT OE_Validate.payment_set(p_Line_Payment_rec.payment_set_id) THEN
659: x_return_status := FND_API.G_RET_STS_ERROR;
660: END IF;
661: END IF;
662:
663: IF p_Line_Payment_rec.prepaid_amount IS NOT NULL AND

Line 669: x_return_status := FND_API.G_RET_STS_ERROR;

665: p_old_Line_Payment_rec.prepaid_amount OR
666: p_old_Line_Payment_rec.prepaid_amount IS NULL )
667: THEN
668: IF NOT OE_Validate.prepaid_amount(p_Line_Payment_rec.prepaid_amount) THEN
669: x_return_status := FND_API.G_RET_STS_ERROR;
670: END IF;
671: END IF;
672:
673: IF p_Line_Payment_rec.receipt_method_id IS NOT NULL AND

Line 679: x_return_status := FND_API.G_RET_STS_ERROR;

675: p_old_Line_Payment_rec.receipt_method_id OR
676: p_old_Line_Payment_rec.receipt_method_id IS NULL )
677: THEN
678: IF NOT OE_Validate.receipt_method(p_Line_Payment_rec.receipt_method_id) THEN
679: x_return_status := FND_API.G_RET_STS_ERROR;
680: END IF;
681: END IF;
682:
683: IF p_Line_Payment_rec.tangible_id IS NOT NULL AND

Line 689: x_return_status := FND_API.G_RET_STS_ERROR;

685: p_old_Line_Payment_rec.tangible_id OR
686: p_old_Line_Payment_rec.tangible_id IS NULL )
687: THEN
688: IF NOT OE_Validate.tangible(p_Line_Payment_rec.tangible_id) THEN
689: x_return_status := FND_API.G_RET_STS_ERROR;
690: END IF;
691: END IF;
692:
693: IF p_Line_Payment_rec.trxn_extension_id IS NOT NULL AND --R12 Process order api changes

Line 699: x_return_status := FND_API.G_RET_STS_ERROR;

695: p_old_Line_Payment_rec.trxn_extension_id OR
696: p_old_Line_Payment_rec.trxn_extension_id IS NULL )
697: THEN
698: IF NOT OE_Validate.Payment_Trxn_Extension(p_Line_Payment_rec.trxn_extension_id) THEN
699: x_return_status := FND_API.G_RET_STS_ERROR;
700: END IF;
701: END IF; --R12 Process order api changes
702: if OE_GLOBALS.g_validate_desc_flex ='Y' then --bug 4343612
703: oe_debug_pub.add('Validation of desc flex is set to Y in OE_Validate_Line_Payment.attributes ',1);

Line 790: x_return_status := FND_API.G_RET_STS_ERROR;

786: ,p_attribute13 => p_Line_Payment_rec.attribute13
787: ,p_attribute14 => p_Line_Payment_rec.attribute14
788: ,p_attribute15 => p_Line_Payment_rec.attribute15) THEN
789:
790: x_return_status := FND_API.G_RET_STS_ERROR;
791: END IF;
792:
793: oe_debug_pub.add('After Payments_Desc_Flex ' || x_return_status,2);
794:

Line 802: WHEN FND_API.G_EXC_ERROR THEN

798: -- Done validating attributes
799: end if ; /*if OE_GLOBALS.g_validate_desc_flex ='Y' then bug 4343612*/
800: EXCEPTION
801:
802: WHEN FND_API.G_EXC_ERROR THEN
803:
804: x_return_status := FND_API.G_RET_STS_ERROR;
805:
806: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 804: x_return_status := FND_API.G_RET_STS_ERROR;

800: EXCEPTION
801:
802: WHEN FND_API.G_EXC_ERROR THEN
803:
804: x_return_status := FND_API.G_RET_STS_ERROR;
805:
806: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
807:
808: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 806: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

802: WHEN FND_API.G_EXC_ERROR THEN
803:
804: x_return_status := FND_API.G_RET_STS_ERROR;
805:
806: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
807:
808: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
809:
810: WHEN OTHERS THEN

Line 808: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

804: x_return_status := FND_API.G_RET_STS_ERROR;
805:
806: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
807:
808: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
809:
810: WHEN OTHERS THEN
811:
812: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 812: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

808: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
809:
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

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

827: ( x_return_status OUT NOCOPY VARCHAR2
828: , p_Line_Payment_rec IN OE_Order_PUB.Line_Payment_Rec_Type
829: )
830: IS
831: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
832: BEGIN
833:
834: OE_DEBUG_PUB.Add('Entering OE_VALIDATE_Line_Payments.Entity_Delete',1);
835: -- Validate entity delete.

Line 844: WHEN FND_API.G_EXC_ERROR THEN

840: OE_DEBUG_PUB.Add('Exiting OE_VALIDATE_Line_Payments.Entity_Delete',1);
841:
842: EXCEPTION
843:
844: WHEN FND_API.G_EXC_ERROR THEN
845:
846: x_return_status := FND_API.G_RET_STS_ERROR;
847:
848: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 846: x_return_status := FND_API.G_RET_STS_ERROR;

842: EXCEPTION
843:
844: WHEN FND_API.G_EXC_ERROR THEN
845:
846: x_return_status := FND_API.G_RET_STS_ERROR;
847:
848: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
849:
850: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 848: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

844: WHEN FND_API.G_EXC_ERROR THEN
845:
846: x_return_status := FND_API.G_RET_STS_ERROR;
847:
848: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
849:
850: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
851:
852: WHEN OTHERS THEN

Line 850: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

846: x_return_status := FND_API.G_RET_STS_ERROR;
847:
848: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
849:
850: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
851:
852: WHEN OTHERS THEN
853:
854: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 854: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

850: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
851:
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