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
234:
235: END IF;*/
236: --bug 5176015
237: --R12 CC Encryption
238: oe_debug_pub.add('Header id in entity ksu'||p_header_payment_rec.header_id);
239: Begin
240: Select invoice_to_org_id
241: Into l_invoice_to_org_id
242: From oe_order_headers_all
243: Where header_id = p_header_payment_rec.header_id;
244: EXCEPTION WHEN NO_DATA_FOUND THEN
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
370: -- Done validating entity
371:
372: x_return_status := l_return_status;
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:
408: l_line_payment_count number;
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:
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:
428: IF p_Header_Payment_rec.creation_date IS NOT NULL AND
429: ( p_Header_Payment_rec.creation_date <>
430: p_old_Header_Payment_rec.creation_date OR
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:
439: IF p_Header_Payment_rec.header_id IS NOT NULL AND
440: ( p_Header_Payment_rec.header_id <>
441: p_old_Header_Payment_rec.header_id OR
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);
450:
451: IF p_Header_Payment_rec.last_updated_by IS NOT NULL AND
452: ( p_Header_Payment_rec.last_updated_by <>
453: p_old_Header_Payment_rec.last_updated_by OR
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);
462:
463: IF p_Header_Payment_rec.last_update_date IS NOT NULL AND
464: ( p_Header_Payment_rec.last_update_date <>
465: p_old_Header_Payment_rec.last_update_date OR
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);
474:
475: IF p_Header_Payment_rec.last_update_login IS NOT NULL AND
476: ( p_Header_Payment_rec.last_update_login <>
477: p_old_Header_Payment_rec.last_update_login OR
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);
516:
517:
518: IF p_Header_Payment_rec.credit_card_approval_date IS NOT NULL AND
519: ( p_Header_Payment_rec.credit_card_approval_date <>
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);
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
535: END IF;
536: END IF;
537:
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;
551: END IF;
552: END IF;
553: --R12 CVV2
554:
555: oe_debug_pub.add('after security code');
556:
557:
558: IF p_Header_Payment_rec.credit_card_expiration_date IS NOT NULL AND
559: ( p_Header_Payment_rec.credit_card_expiration_date <>
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);
569: oe_debug_pub.add('after credit_card_expiration_date');
570:
571: IF p_Header_Payment_rec.credit_card_holder_name IS NOT NULL AND
572: ( p_Header_Payment_rec.credit_card_holder_name <>
565: END IF;
566: END IF;
567:
568: oe_debug_pub.add('return status 8 : ' || x_return_status);
569: oe_debug_pub.add('after credit_card_expiration_date');
570:
571: IF p_Header_Payment_rec.credit_card_holder_name IS NOT NULL AND
572: ( p_Header_Payment_rec.credit_card_holder_name <>
573: p_old_Header_Payment_rec.credit_card_holder_name OR
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');
582:
583: IF p_Header_Payment_rec.credit_card_number IS NOT NULL AND
584: ( p_Header_Payment_rec.credit_card_number <>
585: p_old_Header_Payment_rec.credit_card_number OR
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');
594:
595: IF p_Header_Payment_rec.payment_level_code IS NOT NULL AND
596: ( p_Header_Payment_rec.payment_level_code <>
597: p_old_Header_Payment_rec.payment_level_code OR
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);
606: oe_debug_pub.add('after payment_level_code');
607:
608: IF p_Header_Payment_rec.commitment_applied_amount IS NOT NULL AND
609: ( p_Header_Payment_rec.commitment_applied_amount <>
602: END IF;
603: END IF;
604:
605: oe_debug_pub.add('return status 9 : ' || x_return_status);
606: oe_debug_pub.add('after payment_level_code');
607:
608: IF p_Header_Payment_rec.commitment_applied_amount IS NOT NULL AND
609: ( p_Header_Payment_rec.commitment_applied_amount <>
610: p_old_Header_Payment_rec.commitment_applied_amount OR
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');
619:
620:
621: IF p_Header_Payment_rec.commitment_interfaced_amount IS NOT NULL AND
622: ( p_Header_Payment_rec.commitment_interfaced_amount <>
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');
632:
633: IF p_Header_Payment_rec.payment_amount IS NOT NULL AND
634: ( p_Header_Payment_rec.payment_amount <>
635: p_old_Header_Payment_rec.payment_amount OR
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');
644:
645: IF p_Header_Payment_rec.payment_collection_event IS NOT NULL AND
646: ( p_Header_Payment_rec.payment_collection_event <>
647: p_old_Header_Payment_rec.payment_collection_event OR
663: end if;
664:
665: END IF;
666:
667: oe_debug_pub.add('after payment_collection_event');
668:
669: IF p_Header_Payment_rec.payment_trx_id IS NOT NULL AND
670: ( p_Header_Payment_rec.payment_trx_id <>
671: p_old_Header_Payment_rec.payment_trx_id OR
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');
680:
681: IF p_Header_Payment_rec.payment_type_code IS NOT NULL AND
682: ( p_Header_Payment_rec.payment_type_code <>
683: p_old_Header_Payment_rec.payment_type_code OR
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');
692:
693: IF p_Header_Payment_rec.payment_set_id IS NOT NULL AND
694: ( p_Header_Payment_rec.payment_set_id <>
695: p_old_Header_Payment_rec.payment_set_id OR
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 ');
744: oe_debug_pub.add('attribute1 new : ' || p_Header_Payment_rec.attribute1);
745: oe_debug_pub.add('attribute1 old : ' || p_old_Header_Payment_rec.attribute1);
746: oe_debug_pub.add('attribute10 new : ' || p_Header_Payment_rec.attribute10);
747: oe_debug_pub.add('attribute10 old : ' || p_old_Header_Payment_rec.attribute10);
740: END IF;
741: END IF; --R12 Process order api changes
742:
743: oe_debug_pub.add('after trxn_extension_id ');
744: oe_debug_pub.add('attribute1 new : ' || p_Header_Payment_rec.attribute1);
745: oe_debug_pub.add('attribute1 old : ' || p_old_Header_Payment_rec.attribute1);
746: oe_debug_pub.add('attribute10 new : ' || p_Header_Payment_rec.attribute10);
747: oe_debug_pub.add('attribute10 old : ' || p_old_Header_Payment_rec.attribute10);
748: oe_debug_pub.add('attribute11 new : ' || p_Header_Payment_rec.attribute11);
741: END IF; --R12 Process order api changes
742:
743: oe_debug_pub.add('after trxn_extension_id ');
744: oe_debug_pub.add('attribute1 new : ' || p_Header_Payment_rec.attribute1);
745: oe_debug_pub.add('attribute1 old : ' || p_old_Header_Payment_rec.attribute1);
746: oe_debug_pub.add('attribute10 new : ' || p_Header_Payment_rec.attribute10);
747: oe_debug_pub.add('attribute10 old : ' || p_old_Header_Payment_rec.attribute10);
748: oe_debug_pub.add('attribute11 new : ' || p_Header_Payment_rec.attribute11);
749: oe_debug_pub.add('attribute11 old : ' || p_old_Header_Payment_rec.attribute11);
742:
743: oe_debug_pub.add('after trxn_extension_id ');
744: oe_debug_pub.add('attribute1 new : ' || p_Header_Payment_rec.attribute1);
745: oe_debug_pub.add('attribute1 old : ' || p_old_Header_Payment_rec.attribute1);
746: oe_debug_pub.add('attribute10 new : ' || p_Header_Payment_rec.attribute10);
747: oe_debug_pub.add('attribute10 old : ' || p_old_Header_Payment_rec.attribute10);
748: oe_debug_pub.add('attribute11 new : ' || p_Header_Payment_rec.attribute11);
749: oe_debug_pub.add('attribute11 old : ' || p_old_Header_Payment_rec.attribute11);
750: oe_debug_pub.add('attribute12 new : ' || p_Header_Payment_rec.attribute12);
743: oe_debug_pub.add('after trxn_extension_id ');
744: oe_debug_pub.add('attribute1 new : ' || p_Header_Payment_rec.attribute1);
745: oe_debug_pub.add('attribute1 old : ' || p_old_Header_Payment_rec.attribute1);
746: oe_debug_pub.add('attribute10 new : ' || p_Header_Payment_rec.attribute10);
747: oe_debug_pub.add('attribute10 old : ' || p_old_Header_Payment_rec.attribute10);
748: oe_debug_pub.add('attribute11 new : ' || p_Header_Payment_rec.attribute11);
749: oe_debug_pub.add('attribute11 old : ' || p_old_Header_Payment_rec.attribute11);
750: oe_debug_pub.add('attribute12 new : ' || p_Header_Payment_rec.attribute12);
751: oe_debug_pub.add('attribute12 old : ' || p_old_Header_Payment_rec.attribute12);
744: oe_debug_pub.add('attribute1 new : ' || p_Header_Payment_rec.attribute1);
745: oe_debug_pub.add('attribute1 old : ' || p_old_Header_Payment_rec.attribute1);
746: oe_debug_pub.add('attribute10 new : ' || p_Header_Payment_rec.attribute10);
747: oe_debug_pub.add('attribute10 old : ' || p_old_Header_Payment_rec.attribute10);
748: oe_debug_pub.add('attribute11 new : ' || p_Header_Payment_rec.attribute11);
749: oe_debug_pub.add('attribute11 old : ' || p_old_Header_Payment_rec.attribute11);
750: oe_debug_pub.add('attribute12 new : ' || p_Header_Payment_rec.attribute12);
751: oe_debug_pub.add('attribute12 old : ' || p_old_Header_Payment_rec.attribute12);
752: oe_debug_pub.add('attribute13 new : ' || p_Header_Payment_rec.attribute13);
745: oe_debug_pub.add('attribute1 old : ' || p_old_Header_Payment_rec.attribute1);
746: oe_debug_pub.add('attribute10 new : ' || p_Header_Payment_rec.attribute10);
747: oe_debug_pub.add('attribute10 old : ' || p_old_Header_Payment_rec.attribute10);
748: oe_debug_pub.add('attribute11 new : ' || p_Header_Payment_rec.attribute11);
749: oe_debug_pub.add('attribute11 old : ' || p_old_Header_Payment_rec.attribute11);
750: oe_debug_pub.add('attribute12 new : ' || p_Header_Payment_rec.attribute12);
751: oe_debug_pub.add('attribute12 old : ' || p_old_Header_Payment_rec.attribute12);
752: oe_debug_pub.add('attribute13 new : ' || p_Header_Payment_rec.attribute13);
753: oe_debug_pub.add('attribute13 old : ' || p_old_Header_Payment_rec.attribute13);
746: oe_debug_pub.add('attribute10 new : ' || p_Header_Payment_rec.attribute10);
747: oe_debug_pub.add('attribute10 old : ' || p_old_Header_Payment_rec.attribute10);
748: oe_debug_pub.add('attribute11 new : ' || p_Header_Payment_rec.attribute11);
749: oe_debug_pub.add('attribute11 old : ' || p_old_Header_Payment_rec.attribute11);
750: oe_debug_pub.add('attribute12 new : ' || p_Header_Payment_rec.attribute12);
751: oe_debug_pub.add('attribute12 old : ' || p_old_Header_Payment_rec.attribute12);
752: oe_debug_pub.add('attribute13 new : ' || p_Header_Payment_rec.attribute13);
753: oe_debug_pub.add('attribute13 old : ' || p_old_Header_Payment_rec.attribute13);
754: oe_debug_pub.add('attribute14 new : ' || p_Header_Payment_rec.attribute14);
747: oe_debug_pub.add('attribute10 old : ' || p_old_Header_Payment_rec.attribute10);
748: oe_debug_pub.add('attribute11 new : ' || p_Header_Payment_rec.attribute11);
749: oe_debug_pub.add('attribute11 old : ' || p_old_Header_Payment_rec.attribute11);
750: oe_debug_pub.add('attribute12 new : ' || p_Header_Payment_rec.attribute12);
751: oe_debug_pub.add('attribute12 old : ' || p_old_Header_Payment_rec.attribute12);
752: oe_debug_pub.add('attribute13 new : ' || p_Header_Payment_rec.attribute13);
753: oe_debug_pub.add('attribute13 old : ' || p_old_Header_Payment_rec.attribute13);
754: oe_debug_pub.add('attribute14 new : ' || p_Header_Payment_rec.attribute14);
755: oe_debug_pub.add('attribute14 old : ' || p_old_Header_Payment_rec.attribute14);
748: oe_debug_pub.add('attribute11 new : ' || p_Header_Payment_rec.attribute11);
749: oe_debug_pub.add('attribute11 old : ' || p_old_Header_Payment_rec.attribute11);
750: oe_debug_pub.add('attribute12 new : ' || p_Header_Payment_rec.attribute12);
751: oe_debug_pub.add('attribute12 old : ' || p_old_Header_Payment_rec.attribute12);
752: oe_debug_pub.add('attribute13 new : ' || p_Header_Payment_rec.attribute13);
753: oe_debug_pub.add('attribute13 old : ' || p_old_Header_Payment_rec.attribute13);
754: oe_debug_pub.add('attribute14 new : ' || p_Header_Payment_rec.attribute14);
755: oe_debug_pub.add('attribute14 old : ' || p_old_Header_Payment_rec.attribute14);
756: oe_debug_pub.add('attribute15 new : ' || p_Header_Payment_rec.attribute15);
749: oe_debug_pub.add('attribute11 old : ' || p_old_Header_Payment_rec.attribute11);
750: oe_debug_pub.add('attribute12 new : ' || p_Header_Payment_rec.attribute12);
751: oe_debug_pub.add('attribute12 old : ' || p_old_Header_Payment_rec.attribute12);
752: oe_debug_pub.add('attribute13 new : ' || p_Header_Payment_rec.attribute13);
753: oe_debug_pub.add('attribute13 old : ' || p_old_Header_Payment_rec.attribute13);
754: oe_debug_pub.add('attribute14 new : ' || p_Header_Payment_rec.attribute14);
755: oe_debug_pub.add('attribute14 old : ' || p_old_Header_Payment_rec.attribute14);
756: oe_debug_pub.add('attribute15 new : ' || p_Header_Payment_rec.attribute15);
757: oe_debug_pub.add('attribute15 old : ' || p_old_Header_Payment_rec.attribute15);
750: oe_debug_pub.add('attribute12 new : ' || p_Header_Payment_rec.attribute12);
751: oe_debug_pub.add('attribute12 old : ' || p_old_Header_Payment_rec.attribute12);
752: oe_debug_pub.add('attribute13 new : ' || p_Header_Payment_rec.attribute13);
753: oe_debug_pub.add('attribute13 old : ' || p_old_Header_Payment_rec.attribute13);
754: oe_debug_pub.add('attribute14 new : ' || p_Header_Payment_rec.attribute14);
755: oe_debug_pub.add('attribute14 old : ' || p_old_Header_Payment_rec.attribute14);
756: oe_debug_pub.add('attribute15 new : ' || p_Header_Payment_rec.attribute15);
757: oe_debug_pub.add('attribute15 old : ' || p_old_Header_Payment_rec.attribute15);
758: oe_debug_pub.add('attribute2 new : ' || p_Header_Payment_rec.attribute2);
751: oe_debug_pub.add('attribute12 old : ' || p_old_Header_Payment_rec.attribute12);
752: oe_debug_pub.add('attribute13 new : ' || p_Header_Payment_rec.attribute13);
753: oe_debug_pub.add('attribute13 old : ' || p_old_Header_Payment_rec.attribute13);
754: oe_debug_pub.add('attribute14 new : ' || p_Header_Payment_rec.attribute14);
755: oe_debug_pub.add('attribute14 old : ' || p_old_Header_Payment_rec.attribute14);
756: oe_debug_pub.add('attribute15 new : ' || p_Header_Payment_rec.attribute15);
757: oe_debug_pub.add('attribute15 old : ' || p_old_Header_Payment_rec.attribute15);
758: oe_debug_pub.add('attribute2 new : ' || p_Header_Payment_rec.attribute2);
759: oe_debug_pub.add('attribute2 old : ' || p_old_Header_Payment_rec.attribute2);
752: oe_debug_pub.add('attribute13 new : ' || p_Header_Payment_rec.attribute13);
753: oe_debug_pub.add('attribute13 old : ' || p_old_Header_Payment_rec.attribute13);
754: oe_debug_pub.add('attribute14 new : ' || p_Header_Payment_rec.attribute14);
755: oe_debug_pub.add('attribute14 old : ' || p_old_Header_Payment_rec.attribute14);
756: oe_debug_pub.add('attribute15 new : ' || p_Header_Payment_rec.attribute15);
757: oe_debug_pub.add('attribute15 old : ' || p_old_Header_Payment_rec.attribute15);
758: oe_debug_pub.add('attribute2 new : ' || p_Header_Payment_rec.attribute2);
759: oe_debug_pub.add('attribute2 old : ' || p_old_Header_Payment_rec.attribute2);
760: oe_debug_pub.add('attribute3 new : ' || p_Header_Payment_rec.attribute3);
753: oe_debug_pub.add('attribute13 old : ' || p_old_Header_Payment_rec.attribute13);
754: oe_debug_pub.add('attribute14 new : ' || p_Header_Payment_rec.attribute14);
755: oe_debug_pub.add('attribute14 old : ' || p_old_Header_Payment_rec.attribute14);
756: oe_debug_pub.add('attribute15 new : ' || p_Header_Payment_rec.attribute15);
757: oe_debug_pub.add('attribute15 old : ' || p_old_Header_Payment_rec.attribute15);
758: oe_debug_pub.add('attribute2 new : ' || p_Header_Payment_rec.attribute2);
759: oe_debug_pub.add('attribute2 old : ' || p_old_Header_Payment_rec.attribute2);
760: oe_debug_pub.add('attribute3 new : ' || p_Header_Payment_rec.attribute3);
761: oe_debug_pub.add('attribute3 old : ' || p_old_Header_Payment_rec.attribute3);
754: oe_debug_pub.add('attribute14 new : ' || p_Header_Payment_rec.attribute14);
755: oe_debug_pub.add('attribute14 old : ' || p_old_Header_Payment_rec.attribute14);
756: oe_debug_pub.add('attribute15 new : ' || p_Header_Payment_rec.attribute15);
757: oe_debug_pub.add('attribute15 old : ' || p_old_Header_Payment_rec.attribute15);
758: oe_debug_pub.add('attribute2 new : ' || p_Header_Payment_rec.attribute2);
759: oe_debug_pub.add('attribute2 old : ' || p_old_Header_Payment_rec.attribute2);
760: oe_debug_pub.add('attribute3 new : ' || p_Header_Payment_rec.attribute3);
761: oe_debug_pub.add('attribute3 old : ' || p_old_Header_Payment_rec.attribute3);
762: oe_debug_pub.add('attribute4 new : ' || p_Header_Payment_rec.attribute4);
755: oe_debug_pub.add('attribute14 old : ' || p_old_Header_Payment_rec.attribute14);
756: oe_debug_pub.add('attribute15 new : ' || p_Header_Payment_rec.attribute15);
757: oe_debug_pub.add('attribute15 old : ' || p_old_Header_Payment_rec.attribute15);
758: oe_debug_pub.add('attribute2 new : ' || p_Header_Payment_rec.attribute2);
759: oe_debug_pub.add('attribute2 old : ' || p_old_Header_Payment_rec.attribute2);
760: oe_debug_pub.add('attribute3 new : ' || p_Header_Payment_rec.attribute3);
761: oe_debug_pub.add('attribute3 old : ' || p_old_Header_Payment_rec.attribute3);
762: oe_debug_pub.add('attribute4 new : ' || p_Header_Payment_rec.attribute4);
763: oe_debug_pub.add('attribute4 old : ' || p_old_Header_Payment_rec.attribute4);
756: oe_debug_pub.add('attribute15 new : ' || p_Header_Payment_rec.attribute15);
757: oe_debug_pub.add('attribute15 old : ' || p_old_Header_Payment_rec.attribute15);
758: oe_debug_pub.add('attribute2 new : ' || p_Header_Payment_rec.attribute2);
759: oe_debug_pub.add('attribute2 old : ' || p_old_Header_Payment_rec.attribute2);
760: oe_debug_pub.add('attribute3 new : ' || p_Header_Payment_rec.attribute3);
761: oe_debug_pub.add('attribute3 old : ' || p_old_Header_Payment_rec.attribute3);
762: oe_debug_pub.add('attribute4 new : ' || p_Header_Payment_rec.attribute4);
763: oe_debug_pub.add('attribute4 old : ' || p_old_Header_Payment_rec.attribute4);
764: oe_debug_pub.add('attribute5 new : ' || p_Header_Payment_rec.attribute5);
757: oe_debug_pub.add('attribute15 old : ' || p_old_Header_Payment_rec.attribute15);
758: oe_debug_pub.add('attribute2 new : ' || p_Header_Payment_rec.attribute2);
759: oe_debug_pub.add('attribute2 old : ' || p_old_Header_Payment_rec.attribute2);
760: oe_debug_pub.add('attribute3 new : ' || p_Header_Payment_rec.attribute3);
761: oe_debug_pub.add('attribute3 old : ' || p_old_Header_Payment_rec.attribute3);
762: oe_debug_pub.add('attribute4 new : ' || p_Header_Payment_rec.attribute4);
763: oe_debug_pub.add('attribute4 old : ' || p_old_Header_Payment_rec.attribute4);
764: oe_debug_pub.add('attribute5 new : ' || p_Header_Payment_rec.attribute5);
765: oe_debug_pub.add('attribute5 old : ' || p_old_Header_Payment_rec.attribute5);
758: oe_debug_pub.add('attribute2 new : ' || p_Header_Payment_rec.attribute2);
759: oe_debug_pub.add('attribute2 old : ' || p_old_Header_Payment_rec.attribute2);
760: oe_debug_pub.add('attribute3 new : ' || p_Header_Payment_rec.attribute3);
761: oe_debug_pub.add('attribute3 old : ' || p_old_Header_Payment_rec.attribute3);
762: oe_debug_pub.add('attribute4 new : ' || p_Header_Payment_rec.attribute4);
763: oe_debug_pub.add('attribute4 old : ' || p_old_Header_Payment_rec.attribute4);
764: oe_debug_pub.add('attribute5 new : ' || p_Header_Payment_rec.attribute5);
765: oe_debug_pub.add('attribute5 old : ' || p_old_Header_Payment_rec.attribute5);
766: oe_debug_pub.add('attribute6 new : ' || p_Header_Payment_rec.attribute6);
759: oe_debug_pub.add('attribute2 old : ' || p_old_Header_Payment_rec.attribute2);
760: oe_debug_pub.add('attribute3 new : ' || p_Header_Payment_rec.attribute3);
761: oe_debug_pub.add('attribute3 old : ' || p_old_Header_Payment_rec.attribute3);
762: oe_debug_pub.add('attribute4 new : ' || p_Header_Payment_rec.attribute4);
763: oe_debug_pub.add('attribute4 old : ' || p_old_Header_Payment_rec.attribute4);
764: oe_debug_pub.add('attribute5 new : ' || p_Header_Payment_rec.attribute5);
765: oe_debug_pub.add('attribute5 old : ' || p_old_Header_Payment_rec.attribute5);
766: oe_debug_pub.add('attribute6 new : ' || p_Header_Payment_rec.attribute6);
767: oe_debug_pub.add('attribute6 old : ' || p_old_Header_Payment_rec.attribute6);
760: oe_debug_pub.add('attribute3 new : ' || p_Header_Payment_rec.attribute3);
761: oe_debug_pub.add('attribute3 old : ' || p_old_Header_Payment_rec.attribute3);
762: oe_debug_pub.add('attribute4 new : ' || p_Header_Payment_rec.attribute4);
763: oe_debug_pub.add('attribute4 old : ' || p_old_Header_Payment_rec.attribute4);
764: oe_debug_pub.add('attribute5 new : ' || p_Header_Payment_rec.attribute5);
765: oe_debug_pub.add('attribute5 old : ' || p_old_Header_Payment_rec.attribute5);
766: oe_debug_pub.add('attribute6 new : ' || p_Header_Payment_rec.attribute6);
767: oe_debug_pub.add('attribute6 old : ' || p_old_Header_Payment_rec.attribute6);
768: oe_debug_pub.add('attribute7 new : ' || p_Header_Payment_rec.attribute7);
761: oe_debug_pub.add('attribute3 old : ' || p_old_Header_Payment_rec.attribute3);
762: oe_debug_pub.add('attribute4 new : ' || p_Header_Payment_rec.attribute4);
763: oe_debug_pub.add('attribute4 old : ' || p_old_Header_Payment_rec.attribute4);
764: oe_debug_pub.add('attribute5 new : ' || p_Header_Payment_rec.attribute5);
765: oe_debug_pub.add('attribute5 old : ' || p_old_Header_Payment_rec.attribute5);
766: oe_debug_pub.add('attribute6 new : ' || p_Header_Payment_rec.attribute6);
767: oe_debug_pub.add('attribute6 old : ' || p_old_Header_Payment_rec.attribute6);
768: oe_debug_pub.add('attribute7 new : ' || p_Header_Payment_rec.attribute7);
769: oe_debug_pub.add('attribute7 old : ' || p_old_Header_Payment_rec.attribute7);
762: oe_debug_pub.add('attribute4 new : ' || p_Header_Payment_rec.attribute4);
763: oe_debug_pub.add('attribute4 old : ' || p_old_Header_Payment_rec.attribute4);
764: oe_debug_pub.add('attribute5 new : ' || p_Header_Payment_rec.attribute5);
765: oe_debug_pub.add('attribute5 old : ' || p_old_Header_Payment_rec.attribute5);
766: oe_debug_pub.add('attribute6 new : ' || p_Header_Payment_rec.attribute6);
767: oe_debug_pub.add('attribute6 old : ' || p_old_Header_Payment_rec.attribute6);
768: oe_debug_pub.add('attribute7 new : ' || p_Header_Payment_rec.attribute7);
769: oe_debug_pub.add('attribute7 old : ' || p_old_Header_Payment_rec.attribute7);
770: oe_debug_pub.add('attribute8 new : ' || p_Header_Payment_rec.attribute8);
763: oe_debug_pub.add('attribute4 old : ' || p_old_Header_Payment_rec.attribute4);
764: oe_debug_pub.add('attribute5 new : ' || p_Header_Payment_rec.attribute5);
765: oe_debug_pub.add('attribute5 old : ' || p_old_Header_Payment_rec.attribute5);
766: oe_debug_pub.add('attribute6 new : ' || p_Header_Payment_rec.attribute6);
767: oe_debug_pub.add('attribute6 old : ' || p_old_Header_Payment_rec.attribute6);
768: oe_debug_pub.add('attribute7 new : ' || p_Header_Payment_rec.attribute7);
769: oe_debug_pub.add('attribute7 old : ' || p_old_Header_Payment_rec.attribute7);
770: oe_debug_pub.add('attribute8 new : ' || p_Header_Payment_rec.attribute8);
771: oe_debug_pub.add('attribute8 old : ' || p_old_Header_Payment_rec.attribute8);
764: oe_debug_pub.add('attribute5 new : ' || p_Header_Payment_rec.attribute5);
765: oe_debug_pub.add('attribute5 old : ' || p_old_Header_Payment_rec.attribute5);
766: oe_debug_pub.add('attribute6 new : ' || p_Header_Payment_rec.attribute6);
767: oe_debug_pub.add('attribute6 old : ' || p_old_Header_Payment_rec.attribute6);
768: oe_debug_pub.add('attribute7 new : ' || p_Header_Payment_rec.attribute7);
769: oe_debug_pub.add('attribute7 old : ' || p_old_Header_Payment_rec.attribute7);
770: oe_debug_pub.add('attribute8 new : ' || p_Header_Payment_rec.attribute8);
771: oe_debug_pub.add('attribute8 old : ' || p_old_Header_Payment_rec.attribute8);
772: oe_debug_pub.add('attribute9 new : ' || p_Header_Payment_rec.attribute9);
765: oe_debug_pub.add('attribute5 old : ' || p_old_Header_Payment_rec.attribute5);
766: oe_debug_pub.add('attribute6 new : ' || p_Header_Payment_rec.attribute6);
767: oe_debug_pub.add('attribute6 old : ' || p_old_Header_Payment_rec.attribute6);
768: oe_debug_pub.add('attribute7 new : ' || p_Header_Payment_rec.attribute7);
769: oe_debug_pub.add('attribute7 old : ' || p_old_Header_Payment_rec.attribute7);
770: oe_debug_pub.add('attribute8 new : ' || p_Header_Payment_rec.attribute8);
771: oe_debug_pub.add('attribute8 old : ' || p_old_Header_Payment_rec.attribute8);
772: oe_debug_pub.add('attribute9 new : ' || p_Header_Payment_rec.attribute9);
773: oe_debug_pub.add('attribute9 old : ' || p_old_Header_Payment_rec.attribute9);
766: oe_debug_pub.add('attribute6 new : ' || p_Header_Payment_rec.attribute6);
767: oe_debug_pub.add('attribute6 old : ' || p_old_Header_Payment_rec.attribute6);
768: oe_debug_pub.add('attribute7 new : ' || p_Header_Payment_rec.attribute7);
769: oe_debug_pub.add('attribute7 old : ' || p_old_Header_Payment_rec.attribute7);
770: oe_debug_pub.add('attribute8 new : ' || p_Header_Payment_rec.attribute8);
771: oe_debug_pub.add('attribute8 old : ' || p_old_Header_Payment_rec.attribute8);
772: oe_debug_pub.add('attribute9 new : ' || p_Header_Payment_rec.attribute9);
773: oe_debug_pub.add('attribute9 old : ' || p_old_Header_Payment_rec.attribute9);
774:
767: oe_debug_pub.add('attribute6 old : ' || p_old_Header_Payment_rec.attribute6);
768: oe_debug_pub.add('attribute7 new : ' || p_Header_Payment_rec.attribute7);
769: oe_debug_pub.add('attribute7 old : ' || p_old_Header_Payment_rec.attribute7);
770: oe_debug_pub.add('attribute8 new : ' || p_Header_Payment_rec.attribute8);
771: oe_debug_pub.add('attribute8 old : ' || p_old_Header_Payment_rec.attribute8);
772: oe_debug_pub.add('attribute9 new : ' || p_Header_Payment_rec.attribute9);
773: oe_debug_pub.add('attribute9 old : ' || p_old_Header_Payment_rec.attribute9);
774:
775: if OE_GLOBALS.g_validate_desc_flex ='Y' then --4343612
768: oe_debug_pub.add('attribute7 new : ' || p_Header_Payment_rec.attribute7);
769: oe_debug_pub.add('attribute7 old : ' || p_old_Header_Payment_rec.attribute7);
770: oe_debug_pub.add('attribute8 new : ' || p_Header_Payment_rec.attribute8);
771: oe_debug_pub.add('attribute8 old : ' || p_old_Header_Payment_rec.attribute8);
772: oe_debug_pub.add('attribute9 new : ' || p_Header_Payment_rec.attribute9);
773: oe_debug_pub.add('attribute9 old : ' || p_old_Header_Payment_rec.attribute9);
774:
775: if OE_GLOBALS.g_validate_desc_flex ='Y' then --4343612
776: oe_debug_pub.add('Validation of desc flex is set to Y in OE_Validate_Header_Payment.attributes',1);
769: oe_debug_pub.add('attribute7 old : ' || p_old_Header_Payment_rec.attribute7);
770: oe_debug_pub.add('attribute8 new : ' || p_Header_Payment_rec.attribute8);
771: oe_debug_pub.add('attribute8 old : ' || p_old_Header_Payment_rec.attribute8);
772: oe_debug_pub.add('attribute9 new : ' || p_Header_Payment_rec.attribute9);
773: oe_debug_pub.add('attribute9 old : ' || p_old_Header_Payment_rec.attribute9);
774:
775: if OE_GLOBALS.g_validate_desc_flex ='Y' then --4343612
776: oe_debug_pub.add('Validation of desc flex is set to Y in OE_Validate_Header_Payment.attributes',1);
777: IF (p_Header_Payment_rec.attribute1 IS NOT NULL AND
772: oe_debug_pub.add('attribute9 new : ' || p_Header_Payment_rec.attribute9);
773: oe_debug_pub.add('attribute9 old : ' || p_old_Header_Payment_rec.attribute9);
774:
775: if OE_GLOBALS.g_validate_desc_flex ='Y' then --4343612
776: oe_debug_pub.add('Validation of desc flex is set to Y in OE_Validate_Header_Payment.attributes',1);
777: IF (p_Header_Payment_rec.attribute1 IS NOT NULL AND
778: ( p_Header_Payment_rec.attribute1 <>
779: p_old_Header_Payment_rec.attribute1 OR
780: p_old_Header_Payment_rec.attribute1 IS NULL ))
840: p_old_Header_Payment_rec.context IS NULL ))
841: THEN
842:
843:
844: oe_debug_pub.add('Before calling Payments_Desc_Flex',2);
845: IF NOT OE_VALIDATE.Payments_Desc_Flex
846: (p_context => p_Header_Payment_rec.context
847: ,p_attribute1 => p_Header_Payment_rec.attribute1
848: ,p_attribute2 => p_Header_Payment_rec.attribute2
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:
868: END IF;
869:
870: OE_DEBUG_PUB.Add('Exiting OE_VALIDATE_Header_Payments.Attributes',1);
866: oe_debug_pub.add('After Payments_Desc_Flex ' || x_return_status,2);
867:
868: END IF;
869:
870: OE_DEBUG_PUB.Add('Exiting OE_VALIDATE_Header_Payments.Attributes',1);
871: end if ; /*if OE_GLOBALS.g_validate_desc_flex ='Y' then for bug4343612 */
872: -- Done validating attributes
873:
874: EXCEPTION
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.
910: NULL;
911: -- Done.
912:
910: NULL;
911: -- Done.
912:
913: x_return_status := l_return_status;
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