22: --R12 CC Encryption
23: l_invoice_to_org_id NUMBER;
24: BEGIN
25:
26: OE_DEBUG_PUB.Add('Entering OE_VALIDATE_Header_Payments.Entity',1);
27: -- Check required attributes.
28:
29: IF p_Header_Payment_rec.payment_number IS NULL
30: THEN
269:
270: END IF;*/
271: --bug 5176015
272: --R12 CC Encryption
273: oe_debug_pub.add('Header id in entity ksu'||p_header_payment_rec.header_id);
274: Begin
275: Select invoice_to_org_id
276: Into l_invoice_to_org_id
277: From oe_order_headers_all
278: Where header_id = p_header_payment_rec.header_id;
279: EXCEPTION WHEN NO_DATA_FOUND THEN
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
405: -- Done validating entity
406:
407: x_return_status := l_return_status;
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:
443: l_line_payment_count number;
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:
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:
463: IF p_Header_Payment_rec.creation_date IS NOT NULL AND
464: ( p_Header_Payment_rec.creation_date <>
465: p_old_Header_Payment_rec.creation_date OR
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:
474: IF p_Header_Payment_rec.header_id IS NOT NULL AND
475: ( p_Header_Payment_rec.header_id <>
476: p_old_Header_Payment_rec.header_id OR
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);
485:
486: IF p_Header_Payment_rec.last_updated_by IS NOT NULL AND
487: ( p_Header_Payment_rec.last_updated_by <>
488: p_old_Header_Payment_rec.last_updated_by OR
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);
497:
498: IF p_Header_Payment_rec.last_update_date IS NOT NULL AND
499: ( p_Header_Payment_rec.last_update_date <>
500: p_old_Header_Payment_rec.last_update_date OR
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);
509:
510: IF p_Header_Payment_rec.last_update_login IS NOT NULL AND
511: ( p_Header_Payment_rec.last_update_login <>
512: p_old_Header_Payment_rec.last_update_login OR
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);
551:
552:
553: IF p_Header_Payment_rec.credit_card_approval_date IS NOT NULL AND
554: ( p_Header_Payment_rec.credit_card_approval_date <>
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);
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
570: END IF;
571: END IF;
572:
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;
586: END IF;
587: END IF;
588: --R12 CVV2
589:
590: oe_debug_pub.add('after security code');
591:
592:
593: IF p_Header_Payment_rec.credit_card_expiration_date IS NOT NULL AND
594: ( p_Header_Payment_rec.credit_card_expiration_date <>
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);
604: oe_debug_pub.add('after credit_card_expiration_date');
605:
606: IF p_Header_Payment_rec.credit_card_holder_name IS NOT NULL AND
607: ( p_Header_Payment_rec.credit_card_holder_name <>
600: END IF;
601: END IF;
602:
603: oe_debug_pub.add('return status 8 : ' || x_return_status);
604: oe_debug_pub.add('after credit_card_expiration_date');
605:
606: IF p_Header_Payment_rec.credit_card_holder_name IS NOT NULL AND
607: ( p_Header_Payment_rec.credit_card_holder_name <>
608: p_old_Header_Payment_rec.credit_card_holder_name OR
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');
617:
618: IF p_Header_Payment_rec.credit_card_number IS NOT NULL AND
619: ( p_Header_Payment_rec.credit_card_number <>
620: p_old_Header_Payment_rec.credit_card_number OR
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');
629:
630: IF p_Header_Payment_rec.payment_level_code IS NOT NULL AND
631: ( p_Header_Payment_rec.payment_level_code <>
632: p_old_Header_Payment_rec.payment_level_code OR
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);
641: oe_debug_pub.add('after payment_level_code');
642:
643: IF p_Header_Payment_rec.commitment_applied_amount IS NOT NULL AND
644: ( p_Header_Payment_rec.commitment_applied_amount <>
637: END IF;
638: END IF;
639:
640: oe_debug_pub.add('return status 9 : ' || x_return_status);
641: oe_debug_pub.add('after payment_level_code');
642:
643: IF p_Header_Payment_rec.commitment_applied_amount IS NOT NULL AND
644: ( p_Header_Payment_rec.commitment_applied_amount <>
645: p_old_Header_Payment_rec.commitment_applied_amount OR
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');
654:
655:
656: IF p_Header_Payment_rec.commitment_interfaced_amount IS NOT NULL AND
657: ( p_Header_Payment_rec.commitment_interfaced_amount <>
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');
667:
668: IF p_Header_Payment_rec.payment_amount IS NOT NULL AND
669: ( p_Header_Payment_rec.payment_amount <>
670: p_old_Header_Payment_rec.payment_amount OR
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');
679:
680: IF p_Header_Payment_rec.payment_collection_event IS NOT NULL AND
681: ( p_Header_Payment_rec.payment_collection_event <>
682: p_old_Header_Payment_rec.payment_collection_event OR
703: --16309734 End
704:
705: END IF;
706:
707: oe_debug_pub.add('after payment_collection_event');
708:
709: IF p_Header_Payment_rec.payment_trx_id IS NOT NULL AND
710: ( p_Header_Payment_rec.payment_trx_id <>
711: p_old_Header_Payment_rec.payment_trx_id OR
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');
720:
721: IF p_Header_Payment_rec.payment_type_code IS NOT NULL AND
722: ( p_Header_Payment_rec.payment_type_code <>
723: p_old_Header_Payment_rec.payment_type_code OR
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');
732:
733: IF p_Header_Payment_rec.payment_set_id IS NOT NULL AND
734: ( p_Header_Payment_rec.payment_set_id <>
735: p_old_Header_Payment_rec.payment_set_id OR
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 ');
784: oe_debug_pub.add('attribute1 new : ' || p_Header_Payment_rec.attribute1);
785: oe_debug_pub.add('attribute1 old : ' || p_old_Header_Payment_rec.attribute1);
786: oe_debug_pub.add('attribute10 new : ' || p_Header_Payment_rec.attribute10);
787: oe_debug_pub.add('attribute10 old : ' || p_old_Header_Payment_rec.attribute10);
780: END IF;
781: END IF; --R12 Process order api changes
782:
783: oe_debug_pub.add('after trxn_extension_id ');
784: oe_debug_pub.add('attribute1 new : ' || p_Header_Payment_rec.attribute1);
785: oe_debug_pub.add('attribute1 old : ' || p_old_Header_Payment_rec.attribute1);
786: oe_debug_pub.add('attribute10 new : ' || p_Header_Payment_rec.attribute10);
787: oe_debug_pub.add('attribute10 old : ' || p_old_Header_Payment_rec.attribute10);
788: oe_debug_pub.add('attribute11 new : ' || p_Header_Payment_rec.attribute11);
781: END IF; --R12 Process order api changes
782:
783: oe_debug_pub.add('after trxn_extension_id ');
784: oe_debug_pub.add('attribute1 new : ' || p_Header_Payment_rec.attribute1);
785: oe_debug_pub.add('attribute1 old : ' || p_old_Header_Payment_rec.attribute1);
786: oe_debug_pub.add('attribute10 new : ' || p_Header_Payment_rec.attribute10);
787: oe_debug_pub.add('attribute10 old : ' || p_old_Header_Payment_rec.attribute10);
788: oe_debug_pub.add('attribute11 new : ' || p_Header_Payment_rec.attribute11);
789: oe_debug_pub.add('attribute11 old : ' || p_old_Header_Payment_rec.attribute11);
782:
783: oe_debug_pub.add('after trxn_extension_id ');
784: oe_debug_pub.add('attribute1 new : ' || p_Header_Payment_rec.attribute1);
785: oe_debug_pub.add('attribute1 old : ' || p_old_Header_Payment_rec.attribute1);
786: oe_debug_pub.add('attribute10 new : ' || p_Header_Payment_rec.attribute10);
787: oe_debug_pub.add('attribute10 old : ' || p_old_Header_Payment_rec.attribute10);
788: oe_debug_pub.add('attribute11 new : ' || p_Header_Payment_rec.attribute11);
789: oe_debug_pub.add('attribute11 old : ' || p_old_Header_Payment_rec.attribute11);
790: oe_debug_pub.add('attribute12 new : ' || p_Header_Payment_rec.attribute12);
783: oe_debug_pub.add('after trxn_extension_id ');
784: oe_debug_pub.add('attribute1 new : ' || p_Header_Payment_rec.attribute1);
785: oe_debug_pub.add('attribute1 old : ' || p_old_Header_Payment_rec.attribute1);
786: oe_debug_pub.add('attribute10 new : ' || p_Header_Payment_rec.attribute10);
787: oe_debug_pub.add('attribute10 old : ' || p_old_Header_Payment_rec.attribute10);
788: oe_debug_pub.add('attribute11 new : ' || p_Header_Payment_rec.attribute11);
789: oe_debug_pub.add('attribute11 old : ' || p_old_Header_Payment_rec.attribute11);
790: oe_debug_pub.add('attribute12 new : ' || p_Header_Payment_rec.attribute12);
791: oe_debug_pub.add('attribute12 old : ' || p_old_Header_Payment_rec.attribute12);
784: oe_debug_pub.add('attribute1 new : ' || p_Header_Payment_rec.attribute1);
785: oe_debug_pub.add('attribute1 old : ' || p_old_Header_Payment_rec.attribute1);
786: oe_debug_pub.add('attribute10 new : ' || p_Header_Payment_rec.attribute10);
787: oe_debug_pub.add('attribute10 old : ' || p_old_Header_Payment_rec.attribute10);
788: oe_debug_pub.add('attribute11 new : ' || p_Header_Payment_rec.attribute11);
789: oe_debug_pub.add('attribute11 old : ' || p_old_Header_Payment_rec.attribute11);
790: oe_debug_pub.add('attribute12 new : ' || p_Header_Payment_rec.attribute12);
791: oe_debug_pub.add('attribute12 old : ' || p_old_Header_Payment_rec.attribute12);
792: oe_debug_pub.add('attribute13 new : ' || p_Header_Payment_rec.attribute13);
785: oe_debug_pub.add('attribute1 old : ' || p_old_Header_Payment_rec.attribute1);
786: oe_debug_pub.add('attribute10 new : ' || p_Header_Payment_rec.attribute10);
787: oe_debug_pub.add('attribute10 old : ' || p_old_Header_Payment_rec.attribute10);
788: oe_debug_pub.add('attribute11 new : ' || p_Header_Payment_rec.attribute11);
789: oe_debug_pub.add('attribute11 old : ' || p_old_Header_Payment_rec.attribute11);
790: oe_debug_pub.add('attribute12 new : ' || p_Header_Payment_rec.attribute12);
791: oe_debug_pub.add('attribute12 old : ' || p_old_Header_Payment_rec.attribute12);
792: oe_debug_pub.add('attribute13 new : ' || p_Header_Payment_rec.attribute13);
793: oe_debug_pub.add('attribute13 old : ' || p_old_Header_Payment_rec.attribute13);
786: oe_debug_pub.add('attribute10 new : ' || p_Header_Payment_rec.attribute10);
787: oe_debug_pub.add('attribute10 old : ' || p_old_Header_Payment_rec.attribute10);
788: oe_debug_pub.add('attribute11 new : ' || p_Header_Payment_rec.attribute11);
789: oe_debug_pub.add('attribute11 old : ' || p_old_Header_Payment_rec.attribute11);
790: oe_debug_pub.add('attribute12 new : ' || p_Header_Payment_rec.attribute12);
791: oe_debug_pub.add('attribute12 old : ' || p_old_Header_Payment_rec.attribute12);
792: oe_debug_pub.add('attribute13 new : ' || p_Header_Payment_rec.attribute13);
793: oe_debug_pub.add('attribute13 old : ' || p_old_Header_Payment_rec.attribute13);
794: oe_debug_pub.add('attribute14 new : ' || p_Header_Payment_rec.attribute14);
787: oe_debug_pub.add('attribute10 old : ' || p_old_Header_Payment_rec.attribute10);
788: oe_debug_pub.add('attribute11 new : ' || p_Header_Payment_rec.attribute11);
789: oe_debug_pub.add('attribute11 old : ' || p_old_Header_Payment_rec.attribute11);
790: oe_debug_pub.add('attribute12 new : ' || p_Header_Payment_rec.attribute12);
791: oe_debug_pub.add('attribute12 old : ' || p_old_Header_Payment_rec.attribute12);
792: oe_debug_pub.add('attribute13 new : ' || p_Header_Payment_rec.attribute13);
793: oe_debug_pub.add('attribute13 old : ' || p_old_Header_Payment_rec.attribute13);
794: oe_debug_pub.add('attribute14 new : ' || p_Header_Payment_rec.attribute14);
795: oe_debug_pub.add('attribute14 old : ' || p_old_Header_Payment_rec.attribute14);
788: oe_debug_pub.add('attribute11 new : ' || p_Header_Payment_rec.attribute11);
789: oe_debug_pub.add('attribute11 old : ' || p_old_Header_Payment_rec.attribute11);
790: oe_debug_pub.add('attribute12 new : ' || p_Header_Payment_rec.attribute12);
791: oe_debug_pub.add('attribute12 old : ' || p_old_Header_Payment_rec.attribute12);
792: oe_debug_pub.add('attribute13 new : ' || p_Header_Payment_rec.attribute13);
793: oe_debug_pub.add('attribute13 old : ' || p_old_Header_Payment_rec.attribute13);
794: oe_debug_pub.add('attribute14 new : ' || p_Header_Payment_rec.attribute14);
795: oe_debug_pub.add('attribute14 old : ' || p_old_Header_Payment_rec.attribute14);
796: oe_debug_pub.add('attribute15 new : ' || p_Header_Payment_rec.attribute15);
789: oe_debug_pub.add('attribute11 old : ' || p_old_Header_Payment_rec.attribute11);
790: oe_debug_pub.add('attribute12 new : ' || p_Header_Payment_rec.attribute12);
791: oe_debug_pub.add('attribute12 old : ' || p_old_Header_Payment_rec.attribute12);
792: oe_debug_pub.add('attribute13 new : ' || p_Header_Payment_rec.attribute13);
793: oe_debug_pub.add('attribute13 old : ' || p_old_Header_Payment_rec.attribute13);
794: oe_debug_pub.add('attribute14 new : ' || p_Header_Payment_rec.attribute14);
795: oe_debug_pub.add('attribute14 old : ' || p_old_Header_Payment_rec.attribute14);
796: oe_debug_pub.add('attribute15 new : ' || p_Header_Payment_rec.attribute15);
797: oe_debug_pub.add('attribute15 old : ' || p_old_Header_Payment_rec.attribute15);
790: oe_debug_pub.add('attribute12 new : ' || p_Header_Payment_rec.attribute12);
791: oe_debug_pub.add('attribute12 old : ' || p_old_Header_Payment_rec.attribute12);
792: oe_debug_pub.add('attribute13 new : ' || p_Header_Payment_rec.attribute13);
793: oe_debug_pub.add('attribute13 old : ' || p_old_Header_Payment_rec.attribute13);
794: oe_debug_pub.add('attribute14 new : ' || p_Header_Payment_rec.attribute14);
795: oe_debug_pub.add('attribute14 old : ' || p_old_Header_Payment_rec.attribute14);
796: oe_debug_pub.add('attribute15 new : ' || p_Header_Payment_rec.attribute15);
797: oe_debug_pub.add('attribute15 old : ' || p_old_Header_Payment_rec.attribute15);
798: oe_debug_pub.add('attribute2 new : ' || p_Header_Payment_rec.attribute2);
791: oe_debug_pub.add('attribute12 old : ' || p_old_Header_Payment_rec.attribute12);
792: oe_debug_pub.add('attribute13 new : ' || p_Header_Payment_rec.attribute13);
793: oe_debug_pub.add('attribute13 old : ' || p_old_Header_Payment_rec.attribute13);
794: oe_debug_pub.add('attribute14 new : ' || p_Header_Payment_rec.attribute14);
795: oe_debug_pub.add('attribute14 old : ' || p_old_Header_Payment_rec.attribute14);
796: oe_debug_pub.add('attribute15 new : ' || p_Header_Payment_rec.attribute15);
797: oe_debug_pub.add('attribute15 old : ' || p_old_Header_Payment_rec.attribute15);
798: oe_debug_pub.add('attribute2 new : ' || p_Header_Payment_rec.attribute2);
799: oe_debug_pub.add('attribute2 old : ' || p_old_Header_Payment_rec.attribute2);
792: oe_debug_pub.add('attribute13 new : ' || p_Header_Payment_rec.attribute13);
793: oe_debug_pub.add('attribute13 old : ' || p_old_Header_Payment_rec.attribute13);
794: oe_debug_pub.add('attribute14 new : ' || p_Header_Payment_rec.attribute14);
795: oe_debug_pub.add('attribute14 old : ' || p_old_Header_Payment_rec.attribute14);
796: oe_debug_pub.add('attribute15 new : ' || p_Header_Payment_rec.attribute15);
797: oe_debug_pub.add('attribute15 old : ' || p_old_Header_Payment_rec.attribute15);
798: oe_debug_pub.add('attribute2 new : ' || p_Header_Payment_rec.attribute2);
799: oe_debug_pub.add('attribute2 old : ' || p_old_Header_Payment_rec.attribute2);
800: oe_debug_pub.add('attribute3 new : ' || p_Header_Payment_rec.attribute3);
793: oe_debug_pub.add('attribute13 old : ' || p_old_Header_Payment_rec.attribute13);
794: oe_debug_pub.add('attribute14 new : ' || p_Header_Payment_rec.attribute14);
795: oe_debug_pub.add('attribute14 old : ' || p_old_Header_Payment_rec.attribute14);
796: oe_debug_pub.add('attribute15 new : ' || p_Header_Payment_rec.attribute15);
797: oe_debug_pub.add('attribute15 old : ' || p_old_Header_Payment_rec.attribute15);
798: oe_debug_pub.add('attribute2 new : ' || p_Header_Payment_rec.attribute2);
799: oe_debug_pub.add('attribute2 old : ' || p_old_Header_Payment_rec.attribute2);
800: oe_debug_pub.add('attribute3 new : ' || p_Header_Payment_rec.attribute3);
801: oe_debug_pub.add('attribute3 old : ' || p_old_Header_Payment_rec.attribute3);
794: oe_debug_pub.add('attribute14 new : ' || p_Header_Payment_rec.attribute14);
795: oe_debug_pub.add('attribute14 old : ' || p_old_Header_Payment_rec.attribute14);
796: oe_debug_pub.add('attribute15 new : ' || p_Header_Payment_rec.attribute15);
797: oe_debug_pub.add('attribute15 old : ' || p_old_Header_Payment_rec.attribute15);
798: oe_debug_pub.add('attribute2 new : ' || p_Header_Payment_rec.attribute2);
799: oe_debug_pub.add('attribute2 old : ' || p_old_Header_Payment_rec.attribute2);
800: oe_debug_pub.add('attribute3 new : ' || p_Header_Payment_rec.attribute3);
801: oe_debug_pub.add('attribute3 old : ' || p_old_Header_Payment_rec.attribute3);
802: oe_debug_pub.add('attribute4 new : ' || p_Header_Payment_rec.attribute4);
795: oe_debug_pub.add('attribute14 old : ' || p_old_Header_Payment_rec.attribute14);
796: oe_debug_pub.add('attribute15 new : ' || p_Header_Payment_rec.attribute15);
797: oe_debug_pub.add('attribute15 old : ' || p_old_Header_Payment_rec.attribute15);
798: oe_debug_pub.add('attribute2 new : ' || p_Header_Payment_rec.attribute2);
799: oe_debug_pub.add('attribute2 old : ' || p_old_Header_Payment_rec.attribute2);
800: oe_debug_pub.add('attribute3 new : ' || p_Header_Payment_rec.attribute3);
801: oe_debug_pub.add('attribute3 old : ' || p_old_Header_Payment_rec.attribute3);
802: oe_debug_pub.add('attribute4 new : ' || p_Header_Payment_rec.attribute4);
803: oe_debug_pub.add('attribute4 old : ' || p_old_Header_Payment_rec.attribute4);
796: oe_debug_pub.add('attribute15 new : ' || p_Header_Payment_rec.attribute15);
797: oe_debug_pub.add('attribute15 old : ' || p_old_Header_Payment_rec.attribute15);
798: oe_debug_pub.add('attribute2 new : ' || p_Header_Payment_rec.attribute2);
799: oe_debug_pub.add('attribute2 old : ' || p_old_Header_Payment_rec.attribute2);
800: oe_debug_pub.add('attribute3 new : ' || p_Header_Payment_rec.attribute3);
801: oe_debug_pub.add('attribute3 old : ' || p_old_Header_Payment_rec.attribute3);
802: oe_debug_pub.add('attribute4 new : ' || p_Header_Payment_rec.attribute4);
803: oe_debug_pub.add('attribute4 old : ' || p_old_Header_Payment_rec.attribute4);
804: oe_debug_pub.add('attribute5 new : ' || p_Header_Payment_rec.attribute5);
797: oe_debug_pub.add('attribute15 old : ' || p_old_Header_Payment_rec.attribute15);
798: oe_debug_pub.add('attribute2 new : ' || p_Header_Payment_rec.attribute2);
799: oe_debug_pub.add('attribute2 old : ' || p_old_Header_Payment_rec.attribute2);
800: oe_debug_pub.add('attribute3 new : ' || p_Header_Payment_rec.attribute3);
801: oe_debug_pub.add('attribute3 old : ' || p_old_Header_Payment_rec.attribute3);
802: oe_debug_pub.add('attribute4 new : ' || p_Header_Payment_rec.attribute4);
803: oe_debug_pub.add('attribute4 old : ' || p_old_Header_Payment_rec.attribute4);
804: oe_debug_pub.add('attribute5 new : ' || p_Header_Payment_rec.attribute5);
805: oe_debug_pub.add('attribute5 old : ' || p_old_Header_Payment_rec.attribute5);
798: oe_debug_pub.add('attribute2 new : ' || p_Header_Payment_rec.attribute2);
799: oe_debug_pub.add('attribute2 old : ' || p_old_Header_Payment_rec.attribute2);
800: oe_debug_pub.add('attribute3 new : ' || p_Header_Payment_rec.attribute3);
801: oe_debug_pub.add('attribute3 old : ' || p_old_Header_Payment_rec.attribute3);
802: oe_debug_pub.add('attribute4 new : ' || p_Header_Payment_rec.attribute4);
803: oe_debug_pub.add('attribute4 old : ' || p_old_Header_Payment_rec.attribute4);
804: oe_debug_pub.add('attribute5 new : ' || p_Header_Payment_rec.attribute5);
805: oe_debug_pub.add('attribute5 old : ' || p_old_Header_Payment_rec.attribute5);
806: oe_debug_pub.add('attribute6 new : ' || p_Header_Payment_rec.attribute6);
799: oe_debug_pub.add('attribute2 old : ' || p_old_Header_Payment_rec.attribute2);
800: oe_debug_pub.add('attribute3 new : ' || p_Header_Payment_rec.attribute3);
801: oe_debug_pub.add('attribute3 old : ' || p_old_Header_Payment_rec.attribute3);
802: oe_debug_pub.add('attribute4 new : ' || p_Header_Payment_rec.attribute4);
803: oe_debug_pub.add('attribute4 old : ' || p_old_Header_Payment_rec.attribute4);
804: oe_debug_pub.add('attribute5 new : ' || p_Header_Payment_rec.attribute5);
805: oe_debug_pub.add('attribute5 old : ' || p_old_Header_Payment_rec.attribute5);
806: oe_debug_pub.add('attribute6 new : ' || p_Header_Payment_rec.attribute6);
807: oe_debug_pub.add('attribute6 old : ' || p_old_Header_Payment_rec.attribute6);
800: oe_debug_pub.add('attribute3 new : ' || p_Header_Payment_rec.attribute3);
801: oe_debug_pub.add('attribute3 old : ' || p_old_Header_Payment_rec.attribute3);
802: oe_debug_pub.add('attribute4 new : ' || p_Header_Payment_rec.attribute4);
803: oe_debug_pub.add('attribute4 old : ' || p_old_Header_Payment_rec.attribute4);
804: oe_debug_pub.add('attribute5 new : ' || p_Header_Payment_rec.attribute5);
805: oe_debug_pub.add('attribute5 old : ' || p_old_Header_Payment_rec.attribute5);
806: oe_debug_pub.add('attribute6 new : ' || p_Header_Payment_rec.attribute6);
807: oe_debug_pub.add('attribute6 old : ' || p_old_Header_Payment_rec.attribute6);
808: oe_debug_pub.add('attribute7 new : ' || p_Header_Payment_rec.attribute7);
801: oe_debug_pub.add('attribute3 old : ' || p_old_Header_Payment_rec.attribute3);
802: oe_debug_pub.add('attribute4 new : ' || p_Header_Payment_rec.attribute4);
803: oe_debug_pub.add('attribute4 old : ' || p_old_Header_Payment_rec.attribute4);
804: oe_debug_pub.add('attribute5 new : ' || p_Header_Payment_rec.attribute5);
805: oe_debug_pub.add('attribute5 old : ' || p_old_Header_Payment_rec.attribute5);
806: oe_debug_pub.add('attribute6 new : ' || p_Header_Payment_rec.attribute6);
807: oe_debug_pub.add('attribute6 old : ' || p_old_Header_Payment_rec.attribute6);
808: oe_debug_pub.add('attribute7 new : ' || p_Header_Payment_rec.attribute7);
809: oe_debug_pub.add('attribute7 old : ' || p_old_Header_Payment_rec.attribute7);
802: oe_debug_pub.add('attribute4 new : ' || p_Header_Payment_rec.attribute4);
803: oe_debug_pub.add('attribute4 old : ' || p_old_Header_Payment_rec.attribute4);
804: oe_debug_pub.add('attribute5 new : ' || p_Header_Payment_rec.attribute5);
805: oe_debug_pub.add('attribute5 old : ' || p_old_Header_Payment_rec.attribute5);
806: oe_debug_pub.add('attribute6 new : ' || p_Header_Payment_rec.attribute6);
807: oe_debug_pub.add('attribute6 old : ' || p_old_Header_Payment_rec.attribute6);
808: oe_debug_pub.add('attribute7 new : ' || p_Header_Payment_rec.attribute7);
809: oe_debug_pub.add('attribute7 old : ' || p_old_Header_Payment_rec.attribute7);
810: oe_debug_pub.add('attribute8 new : ' || p_Header_Payment_rec.attribute8);
803: oe_debug_pub.add('attribute4 old : ' || p_old_Header_Payment_rec.attribute4);
804: oe_debug_pub.add('attribute5 new : ' || p_Header_Payment_rec.attribute5);
805: oe_debug_pub.add('attribute5 old : ' || p_old_Header_Payment_rec.attribute5);
806: oe_debug_pub.add('attribute6 new : ' || p_Header_Payment_rec.attribute6);
807: oe_debug_pub.add('attribute6 old : ' || p_old_Header_Payment_rec.attribute6);
808: oe_debug_pub.add('attribute7 new : ' || p_Header_Payment_rec.attribute7);
809: oe_debug_pub.add('attribute7 old : ' || p_old_Header_Payment_rec.attribute7);
810: oe_debug_pub.add('attribute8 new : ' || p_Header_Payment_rec.attribute8);
811: oe_debug_pub.add('attribute8 old : ' || p_old_Header_Payment_rec.attribute8);
804: oe_debug_pub.add('attribute5 new : ' || p_Header_Payment_rec.attribute5);
805: oe_debug_pub.add('attribute5 old : ' || p_old_Header_Payment_rec.attribute5);
806: oe_debug_pub.add('attribute6 new : ' || p_Header_Payment_rec.attribute6);
807: oe_debug_pub.add('attribute6 old : ' || p_old_Header_Payment_rec.attribute6);
808: oe_debug_pub.add('attribute7 new : ' || p_Header_Payment_rec.attribute7);
809: oe_debug_pub.add('attribute7 old : ' || p_old_Header_Payment_rec.attribute7);
810: oe_debug_pub.add('attribute8 new : ' || p_Header_Payment_rec.attribute8);
811: oe_debug_pub.add('attribute8 old : ' || p_old_Header_Payment_rec.attribute8);
812: oe_debug_pub.add('attribute9 new : ' || p_Header_Payment_rec.attribute9);
805: oe_debug_pub.add('attribute5 old : ' || p_old_Header_Payment_rec.attribute5);
806: oe_debug_pub.add('attribute6 new : ' || p_Header_Payment_rec.attribute6);
807: oe_debug_pub.add('attribute6 old : ' || p_old_Header_Payment_rec.attribute6);
808: oe_debug_pub.add('attribute7 new : ' || p_Header_Payment_rec.attribute7);
809: oe_debug_pub.add('attribute7 old : ' || p_old_Header_Payment_rec.attribute7);
810: oe_debug_pub.add('attribute8 new : ' || p_Header_Payment_rec.attribute8);
811: oe_debug_pub.add('attribute8 old : ' || p_old_Header_Payment_rec.attribute8);
812: oe_debug_pub.add('attribute9 new : ' || p_Header_Payment_rec.attribute9);
813: oe_debug_pub.add('attribute9 old : ' || p_old_Header_Payment_rec.attribute9);
806: oe_debug_pub.add('attribute6 new : ' || p_Header_Payment_rec.attribute6);
807: oe_debug_pub.add('attribute6 old : ' || p_old_Header_Payment_rec.attribute6);
808: oe_debug_pub.add('attribute7 new : ' || p_Header_Payment_rec.attribute7);
809: oe_debug_pub.add('attribute7 old : ' || p_old_Header_Payment_rec.attribute7);
810: oe_debug_pub.add('attribute8 new : ' || p_Header_Payment_rec.attribute8);
811: oe_debug_pub.add('attribute8 old : ' || p_old_Header_Payment_rec.attribute8);
812: oe_debug_pub.add('attribute9 new : ' || p_Header_Payment_rec.attribute9);
813: oe_debug_pub.add('attribute9 old : ' || p_old_Header_Payment_rec.attribute9);
814:
807: oe_debug_pub.add('attribute6 old : ' || p_old_Header_Payment_rec.attribute6);
808: oe_debug_pub.add('attribute7 new : ' || p_Header_Payment_rec.attribute7);
809: oe_debug_pub.add('attribute7 old : ' || p_old_Header_Payment_rec.attribute7);
810: oe_debug_pub.add('attribute8 new : ' || p_Header_Payment_rec.attribute8);
811: oe_debug_pub.add('attribute8 old : ' || p_old_Header_Payment_rec.attribute8);
812: oe_debug_pub.add('attribute9 new : ' || p_Header_Payment_rec.attribute9);
813: oe_debug_pub.add('attribute9 old : ' || p_old_Header_Payment_rec.attribute9);
814:
815: if OE_GLOBALS.g_validate_desc_flex ='Y' then --4343612
808: oe_debug_pub.add('attribute7 new : ' || p_Header_Payment_rec.attribute7);
809: oe_debug_pub.add('attribute7 old : ' || p_old_Header_Payment_rec.attribute7);
810: oe_debug_pub.add('attribute8 new : ' || p_Header_Payment_rec.attribute8);
811: oe_debug_pub.add('attribute8 old : ' || p_old_Header_Payment_rec.attribute8);
812: oe_debug_pub.add('attribute9 new : ' || p_Header_Payment_rec.attribute9);
813: oe_debug_pub.add('attribute9 old : ' || p_old_Header_Payment_rec.attribute9);
814:
815: if OE_GLOBALS.g_validate_desc_flex ='Y' then --4343612
816: oe_debug_pub.add('Validation of desc flex is set to Y in OE_Validate_Header_Payment.attributes',1);
809: oe_debug_pub.add('attribute7 old : ' || p_old_Header_Payment_rec.attribute7);
810: oe_debug_pub.add('attribute8 new : ' || p_Header_Payment_rec.attribute8);
811: oe_debug_pub.add('attribute8 old : ' || p_old_Header_Payment_rec.attribute8);
812: oe_debug_pub.add('attribute9 new : ' || p_Header_Payment_rec.attribute9);
813: oe_debug_pub.add('attribute9 old : ' || p_old_Header_Payment_rec.attribute9);
814:
815: if OE_GLOBALS.g_validate_desc_flex ='Y' then --4343612
816: oe_debug_pub.add('Validation of desc flex is set to Y in OE_Validate_Header_Payment.attributes',1);
817: IF (p_Header_Payment_rec.attribute1 IS NOT NULL AND
812: oe_debug_pub.add('attribute9 new : ' || p_Header_Payment_rec.attribute9);
813: oe_debug_pub.add('attribute9 old : ' || p_old_Header_Payment_rec.attribute9);
814:
815: if OE_GLOBALS.g_validate_desc_flex ='Y' then --4343612
816: oe_debug_pub.add('Validation of desc flex is set to Y in OE_Validate_Header_Payment.attributes',1);
817: IF (p_Header_Payment_rec.attribute1 IS NOT NULL AND
818: ( p_Header_Payment_rec.attribute1 <>
819: p_old_Header_Payment_rec.attribute1 OR
820: p_old_Header_Payment_rec.attribute1 IS NULL ))
880: p_old_Header_Payment_rec.context IS NULL ))
881: THEN
882:
883:
884: oe_debug_pub.add('Before calling Payments_Desc_Flex',2);
885: IF NOT OE_VALIDATE.Payments_Desc_Flex
886: (p_context => p_Header_Payment_rec.context
887: ,p_attribute1 => p_Header_Payment_rec.attribute1
888: ,p_attribute2 => p_Header_Payment_rec.attribute2
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:
908: END IF;
909:
910: OE_DEBUG_PUB.Add('Exiting OE_VALIDATE_Header_Payments.Attributes',1);
906: oe_debug_pub.add('After Payments_Desc_Flex ' || x_return_status,2);
907:
908: END IF;
909:
910: OE_DEBUG_PUB.Add('Exiting OE_VALIDATE_Header_Payments.Attributes',1);
911: end if ; /*if OE_GLOBALS.g_validate_desc_flex ='Y' then for bug4343612 */
912: -- Done validating attributes
913:
914: EXCEPTION
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.
950: NULL;
951: -- Done.
952:
950: NULL;
951: -- Done.
952:
953: x_return_status := l_return_status;
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