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 87: l_return_status := FND_API.G_RET_STS_ERROR;

83: IF p_Header_Payment_rec.payment_amount is null AND
84: p_Header_Payment_rec.payment_percentage is null
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:

Line 102: l_return_status := FND_API.G_RET_STS_ERROR;

98: ELSE
99: IF p_Header_Payment_rec.payment_amount is null
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:

Line 118: l_return_status := FND_API.G_RET_STS_ERROR;

114: -- End of changes for bug 8478559
115: --commented for bug 8478559
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:

Line 133: l_return_status := FND_API.G_RET_STS_ERROR;

129: END IF;*/
130:
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:

Line 177: l_return_status := FND_API.G_RET_STS_ERROR;

173:
174: IF (p_Header_Payment_rec.payment_amount + l_prepay_payment_amount)
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:

Line 207: l_return_status := FND_API.G_RET_STS_ERROR;

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:
209: end if;
210:
211: END IF; -- if payment_collection_event = 'PREPAY'

Line 219: l_return_status := FND_API.G_RET_STS_ERROR;

215:
216: IF p_Header_Payment_rec.HEADER_ID IS NULL
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:

Line 237: l_return_status := FND_API.G_RET_STS_ERROR;

233: --R12 CC Encryption
234: IF p_header_payment_rec.trxn_extension_id is null then
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:

Line 248: l_return_status := FND_API.G_RET_STS_ERROR;

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;
249:
250: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
251: THEN
252:

Line 259: l_return_status := FND_API.G_RET_STS_ERROR;

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;
260:
261: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
262: THEN
263:

Line 284: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 298: l_return_status := FND_API.G_RET_STS_ERROR;

294:
295: ELSIF p_Header_Payment_rec.payment_type_code = 'CHECK' THEN
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:

Line 314: l_return_status := FND_API.G_RET_STS_ERROR;

310: ELSIF p_Header_Payment_rec.payment_type_code in ('ACH', 'DIRECT_DEBIT')
311: THEN
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:

Line 332: l_return_status := FND_API.G_RET_STS_ERROR;

328:
329: IF p_Header_Payment_rec.payment_type_code in ('ACH', 'DIRECT_DEBIT') THEN
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:

Line 361: l_return_status := FND_API.G_RET_STS_ERROR;

357: AND nvl(payment_collection_event, 'INVOICE') = 'INVOICE'
358: AND nvl(payment_number, -1) <> nvl(p_Header_Payment_rec.payment_number, -1);
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:

Line 376: l_return_status := FND_API.G_RET_STS_ERROR;

372: p_Header_Payment_rec.payment_collection_event = 'PREPAY' THEN
373:
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.

Line 390: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

386: END IF;
387:
388: -- Return Error if a required attribute is missing.
389:
390: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
391:
392: RAISE FND_API.G_EXC_ERROR;
393:
394: END IF;

Line 392: RAISE FND_API.G_EXC_ERROR;

388: -- Return Error if a required attribute is missing.
389:
390: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
391:
392: RAISE FND_API.G_EXC_ERROR;
393:
394: END IF;
395:
396: --

Line 412: WHEN FND_API.G_EXC_ERROR THEN

408:
409: OE_DEBUG_PUB.Add('Exiting OE_VALIDATE_Header_Payments.Entity',1);
410: EXCEPTION
411:
412: WHEN FND_API.G_EXC_ERROR THEN
413:
414: x_return_status := FND_API.G_RET_STS_ERROR;
415:
416: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 414: x_return_status := FND_API.G_RET_STS_ERROR;

410: EXCEPTION
411:
412: WHEN FND_API.G_EXC_ERROR THEN
413:
414: x_return_status := FND_API.G_RET_STS_ERROR;
415:
416: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
417:
418: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 416: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

412: WHEN FND_API.G_EXC_ERROR THEN
413:
414: x_return_status := FND_API.G_RET_STS_ERROR;
415:
416: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
417:
418: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
419:
420: WHEN OTHERS THEN

Line 418: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

414: x_return_status := FND_API.G_RET_STS_ERROR;
415:
416: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
417:
418: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
419:
420: WHEN OTHERS THEN
421:
422: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 422: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

418: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
419:
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

Line 448: x_return_status := FND_API.G_RET_STS_SUCCESS;

444: l_cc_security_code_use VARCHAR2(20); --R12 CVV2
445: BEGIN
446:
447: OE_DEBUG_PUB.Add('Entering OE_VALIDATE_Header_Payments.Attributes',1);
448: x_return_status := FND_API.G_RET_STS_SUCCESS;
449:
450: -- Validate Header_Payment attributes
451:
452: IF p_Header_Payment_rec.created_by IS NOT NULL AND

Line 458: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 469: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 480: x_return_status := FND_API.G_RET_STS_ERROR;

476: p_old_Header_Payment_rec.header_id OR
477: p_old_Header_Payment_rec.header_id IS NULL )
478: THEN
479: IF NOT OE_Validate.Header(p_Header_Payment_rec.header_id) THEN
480: x_return_status := FND_API.G_RET_STS_ERROR;
481: END IF;
482: END IF;
483:
484: oe_debug_pub.add('return status 3 : ' || x_return_status);

Line 492: x_return_status := FND_API.G_RET_STS_ERROR;

488: p_old_Header_Payment_rec.last_updated_by OR
489: p_old_Header_Payment_rec.last_updated_by IS NULL )
490: THEN
491: IF NOT OE_Validate.Last_Updated_By(p_Header_Payment_rec.last_updated_by) THEN
492: x_return_status := FND_API.G_RET_STS_ERROR;
493: END IF;
494: END IF;
495:
496: oe_debug_pub.add('return status 4 : ' || x_return_status);

Line 504: x_return_status := FND_API.G_RET_STS_ERROR;

500: p_old_Header_Payment_rec.last_update_date OR
501: p_old_Header_Payment_rec.last_update_date IS NULL )
502: THEN
503: IF NOT OE_Validate.Last_Update_Date(p_Header_Payment_rec.last_update_date) THEN
504: x_return_status := FND_API.G_RET_STS_ERROR;
505: END IF;
506: END IF;
507:
508: oe_debug_pub.add('return status 5 : ' || x_return_status);

Line 516: x_return_status := FND_API.G_RET_STS_ERROR;

512: p_old_Header_Payment_rec.last_update_login OR
513: p_old_Header_Payment_rec.last_update_login IS NULL )
514: THEN
515: IF NOT OE_Validate.Last_Update_Login(p_Header_Payment_rec.last_update_login) THEN
516: x_return_status := FND_API.G_RET_STS_ERROR;
517: END IF;
518: END IF;
519:
520: IF p_Header_Payment_rec.line_id IS NOT NULL AND

Line 526: x_return_status := FND_API.G_RET_STS_ERROR;

522: p_old_Header_Payment_rec.line_id OR
523: p_old_Header_Payment_rec.line_id IS NULL )
524: THEN
525: IF NOT OE_Validate.Line(p_Header_Payment_rec.line_id) THEN
526: x_return_status := FND_API.G_RET_STS_ERROR;
527: END IF;
528: END IF;
529:
530: IF p_Header_Payment_rec.check_number IS NOT NULL AND

Line 536: x_return_status := FND_API.G_RET_STS_ERROR;

532: p_old_Header_Payment_rec.check_number OR
533: p_old_Header_Payment_rec.check_number IS NULL )
534: THEN
535: IF NOT OE_Validate.check_number(p_Header_Payment_rec.check_number) THEN
536: x_return_status := FND_API.G_RET_STS_ERROR;
537: END IF;
538: END IF;
539:
540: IF p_Header_Payment_rec.credit_card_approval_code IS NOT NULL AND

Line 546: x_return_status := FND_API.G_RET_STS_ERROR;

542: p_old_Header_Payment_rec.credit_card_approval_code OR
543: p_old_Header_Payment_rec.credit_card_approval_code IS NULL )
544: THEN
545: IF NOT OE_Validate.credit_card_approval(p_Header_Payment_rec.credit_card_approval_code) THEN
546: x_return_status := FND_API.G_RET_STS_ERROR;
547: END IF;
548: END IF;
549:
550: oe_debug_pub.add('return status 6 : ' || x_return_status);

Line 559: x_return_status := FND_API.G_RET_STS_ERROR;

555: p_old_Header_Payment_rec.credit_card_approval_date OR
556: p_old_Header_Payment_rec.credit_card_approval_date IS NULL )
557: THEN
558: IF NOT OE_Validate.credit_card_approval_date(p_Header_Payment_rec.credit_card_approval_date) THEN
559: x_return_status := FND_API.G_RET_STS_ERROR;
560: END IF;
561: END IF;
562:
563: IF p_Header_Payment_rec.credit_card_code IS NOT NULL AND

Line 569: x_return_status := FND_API.G_RET_STS_ERROR;

565: p_old_Header_Payment_rec.credit_card_code OR
566: p_old_Header_Payment_rec.credit_card_code IS NULL )
567: THEN
568: IF NOT OE_Validate.credit_card(p_Header_Payment_rec.credit_card_code) THEN
569: x_return_status := FND_API.G_RET_STS_ERROR;
570: END IF;
571: END IF;
572:
573: oe_debug_pub.add('return status 7 : ' || x_return_status);

Line 577: 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

573: oe_debug_pub.add('return status 7 : ' || x_return_status);
574: oe_Debug_pub.add('after credit_card_code');
575:
576: --R12 CVV2
577: 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
578: l_cc_security_code_use := OE_Payment_Trxn_Util.Get_CC_Security_Code_Use;
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

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

577: 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
578: l_cc_security_code_use := OE_Payment_Trxn_Util.Get_CC_Security_Code_Use;
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;

Line 584: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 599: x_return_status := FND_API.G_RET_STS_ERROR;

595: p_old_Header_Payment_rec.credit_card_expiration_date OR
596: p_old_Header_Payment_rec.credit_card_expiration_date IS NULL )
597: THEN
598: IF NOT OE_Validate.credit_card_expiration_date(p_Header_Payment_rec.credit_card_expiration_date) THEN
599: x_return_status := FND_API.G_RET_STS_ERROR;
600: END IF;
601: END IF;
602:
603: oe_debug_pub.add('return status 8 : ' || x_return_status);

Line 612: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 624: x_return_status := FND_API.G_RET_STS_ERROR;

620: p_old_Header_Payment_rec.credit_card_number OR
621: p_old_Header_Payment_rec.credit_card_number IS NULL )
622: THEN
623: IF NOT OE_Validate.credit_card_number(p_Header_Payment_rec.credit_card_number) THEN
624: x_return_status := FND_API.G_RET_STS_ERROR;
625: END IF;
626: END IF;
627:
628: oe_debug_pub.add('after credit_card_number');

Line 636: x_return_status := FND_API.G_RET_STS_ERROR;

632: p_old_Header_Payment_rec.payment_level_code OR
633: p_old_Header_Payment_rec.payment_level_code IS NULL )
634: THEN
635: IF NOT OE_Validate.payment_level(p_Header_Payment_rec.payment_level_code) THEN
636: x_return_status := FND_API.G_RET_STS_ERROR;
637: END IF;
638: END IF;
639:
640: oe_debug_pub.add('return status 9 : ' || x_return_status);

Line 649: x_return_status := FND_API.G_RET_STS_ERROR;

645: p_old_Header_Payment_rec.commitment_applied_amount OR
646: p_old_Header_Payment_rec.commitment_applied_amount IS NULL )
647: THEN
648: IF NOT OE_Validate.commitment_applied_amount(p_Header_Payment_rec.commitment_applied_amount) THEN
649: x_return_status := FND_API.G_RET_STS_ERROR;
650: END IF;
651: END IF;
652:
653: oe_debug_pub.add('after commitment_applied_amount');

Line 662: x_return_status := FND_API.G_RET_STS_ERROR;

658: p_old_Header_Payment_rec.commitment_interfaced_amount OR
659: p_old_Header_Payment_rec.commitment_interfaced_amount IS NULL )
660: THEN
661: IF NOT OE_Validate.commitment_interfaced_amount(p_Header_Payment_rec.commitment_interfaced_amount) THEN
662: x_return_status := FND_API.G_RET_STS_ERROR;
663: END IF;
664: END IF;
665:
666: oe_debug_pub.add('after commitment_interfaced_amount');

Line 674: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 686: x_return_status := FND_API.G_RET_STS_ERROR;

682: p_old_Header_Payment_rec.payment_collection_event OR
683: p_old_Header_Payment_rec.payment_collection_event IS NULL )
684: THEN
685: IF NOT OE_Validate.payment_collection_event(p_Header_Payment_rec.payment_collection_event) THEN
686: x_return_status := FND_API.G_RET_STS_ERROR;
687: END IF;
688: --16309734 Start
689: IF p_Header_Payment_rec.payment_collection_event ='PREPAY' THEN
690: --16309734 End

Line 699: x_return_status := FND_API.G_RET_STS_ERROR;

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
703: --16309734 End

Line 715: x_return_status := FND_API.G_RET_STS_ERROR;

711: p_old_Header_Payment_rec.payment_trx_id OR
712: p_old_Header_Payment_rec.payment_trx_id IS NULL )
713: THEN
714: IF NOT OE_Validate.payment_trx(p_Header_Payment_rec.payment_trx_id) THEN
715: x_return_status := FND_API.G_RET_STS_ERROR;
716: END IF;
717: END IF;
718:
719: oe_debug_pub.add('after payment_trx_id');

Line 727: x_return_status := FND_API.G_RET_STS_ERROR;

723: p_old_Header_Payment_rec.payment_type_code OR
724: p_old_Header_Payment_rec.payment_type_code IS NULL )
725: THEN
726: IF NOT OE_Validate.payment_type(p_Header_Payment_rec.payment_type_code) THEN
727: x_return_status := FND_API.G_RET_STS_ERROR;
728: END IF;
729: END IF;
730:
731: oe_debug_pub.add('after payment_type_code');

Line 739: x_return_status := FND_API.G_RET_STS_ERROR;

735: p_old_Header_Payment_rec.payment_set_id OR
736: p_old_Header_Payment_rec.payment_set_id IS NULL )
737: THEN
738: IF NOT OE_Validate.payment_set(p_Header_Payment_rec.payment_set_id) THEN
739: x_return_status := FND_API.G_RET_STS_ERROR;
740: END IF;
741: END IF;
742:
743: IF p_Header_Payment_rec.prepaid_amount IS NOT NULL AND

Line 749: x_return_status := FND_API.G_RET_STS_ERROR;

745: p_old_Header_Payment_rec.prepaid_amount OR
746: p_old_Header_Payment_rec.prepaid_amount IS NULL )
747: THEN
748: IF NOT OE_Validate.prepaid_amount(p_Header_Payment_rec.prepaid_amount) THEN
749: x_return_status := FND_API.G_RET_STS_ERROR;
750: END IF;
751: END IF;
752:
753: IF p_Header_Payment_rec.receipt_method_id IS NOT NULL AND

Line 759: x_return_status := FND_API.G_RET_STS_ERROR;

755: p_old_Header_Payment_rec.receipt_method_id OR
756: p_old_Header_Payment_rec.receipt_method_id IS NULL )
757: THEN
758: IF NOT OE_Validate.receipt_method(p_Header_Payment_rec.receipt_method_id) THEN
759: x_return_status := FND_API.G_RET_STS_ERROR;
760: END IF;
761: END IF;
762:
763: IF p_Header_Payment_rec.tangible_id IS NOT NULL AND

Line 769: x_return_status := FND_API.G_RET_STS_ERROR;

765: p_old_Header_Payment_rec.tangible_id OR
766: p_old_Header_Payment_rec.tangible_id IS NULL )
767: THEN
768: IF NOT OE_Validate.tangible(p_Header_Payment_rec.tangible_id) THEN
769: x_return_status := FND_API.G_RET_STS_ERROR;
770: END IF;
771: END IF;
772:
773: IF p_Header_Payment_rec.trxn_extension_id IS NOT NULL AND --R12 Process order api changes

Line 779: x_return_status := FND_API.G_RET_STS_ERROR;

775: p_old_Header_Payment_rec.trxn_extension_id OR
776: p_old_Header_Payment_rec.trxn_extension_id IS NULL )
777: THEN
778: IF NOT OE_Validate.Payment_Trxn_Extension(p_Header_Payment_rec.trxn_extension_id) THEN
779: x_return_status := FND_API.G_RET_STS_ERROR;
780: END IF;
781: END IF; --R12 Process order api changes
782:
783: oe_debug_pub.add('after trxn_extension_id ');

Line 903: x_return_status := FND_API.G_RET_STS_ERROR;

899: ,p_attribute13 => p_Header_Payment_rec.attribute13
900: ,p_attribute14 => p_Header_Payment_rec.attribute14
901: ,p_attribute15 => p_Header_Payment_rec.attribute15) THEN
902:
903: x_return_status := FND_API.G_RET_STS_ERROR;
904: END IF;
905:
906: oe_debug_pub.add('After Payments_Desc_Flex ' || x_return_status,2);
907:

Line 916: WHEN FND_API.G_EXC_ERROR THEN

912: -- Done validating attributes
913:
914: EXCEPTION
915:
916: WHEN FND_API.G_EXC_ERROR THEN
917:
918: x_return_status := FND_API.G_RET_STS_ERROR;
919:
920: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 918: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 920: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 922: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 926: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

922: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
923:
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

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

941: ( x_return_status OUT NOCOPY VARCHAR2
942: , p_Header_Payment_rec IN OE_Order_PUB.Header_Payment_Rec_Type
943: )
944: IS
945: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
946: BEGIN
947:
948: OE_DEBUG_PUB.Add('Entering OE_VALIDATE_Header_Payments.Entity_Delete',1);
949: -- Validate entity delete.

Line 958: WHEN FND_API.G_EXC_ERROR THEN

954: OE_DEBUG_PUB.Add('Exiting OE_VALIDATE_Header_Payments.Entity_Delete',1);
955:
956: EXCEPTION
957:
958: WHEN FND_API.G_EXC_ERROR THEN
959:
960: x_return_status := FND_API.G_RET_STS_ERROR;
961:
962: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 960: x_return_status := FND_API.G_RET_STS_ERROR;

956: EXCEPTION
957:
958: WHEN FND_API.G_EXC_ERROR THEN
959:
960: x_return_status := FND_API.G_RET_STS_ERROR;
961:
962: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
963:
964: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 962: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

958: WHEN FND_API.G_EXC_ERROR THEN
959:
960: x_return_status := FND_API.G_RET_STS_ERROR;
961:
962: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
963:
964: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
965:
966: WHEN OTHERS THEN

Line 964: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

960: x_return_status := FND_API.G_RET_STS_ERROR;
961:
962: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
963:
964: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
965:
966: WHEN OTHERS THEN
967:
968: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 968: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

964: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
965:
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