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 OE_VALIDATE

Line 1: PACKAGE BODY OE_Validate_Header_Payment AS

1: PACKAGE BODY OE_Validate_Header_Payment AS
2: /* $Header: OEXLHPMB.pls 120.6.12020000.2 2013/02/19 05:04:08 kadiraju ship $ */
3:
4: -- Global constant holding the package name
5:

Line 6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_Validate_Header_Payment';

2: /* $Header: OEXLHPMB.pls 120.6.12020000.2 2013/02/19 05:04:08 kadiraju ship $ */
3:
4: -- Global constant holding the package name
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_Validate_Header_Payment';
7:
8: -- Procedure Entity
9:
10: PROCEDURE Entity

Line 26: OE_DEBUG_PUB.Add('Entering OE_VALIDATE_Header_Payments.Entity',1);

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

Line 409: OE_DEBUG_PUB.Add('Exiting OE_VALIDATE_Header_Payments.Entity',1);

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:

Line 447: OE_DEBUG_PUB.Add('Entering OE_VALIDATE_Header_Payments.Attributes',1);

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:

Line 457: IF NOT OE_Validate.Created_By(p_Header_Payment_rec.created_by) THEN

453: ( p_Header_Payment_rec.created_by <>
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);

Line 468: IF NOT OE_Validate.Creation_Date(p_Header_Payment_rec.creation_date) THEN

464: ( p_Header_Payment_rec.creation_date <>
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);

Line 479: IF NOT OE_Validate.Header(p_Header_Payment_rec.header_id) THEN

475: ( p_Header_Payment_rec.header_id <>
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:

Line 491: IF NOT OE_Validate.Last_Updated_By(p_Header_Payment_rec.last_updated_by) THEN

487: ( p_Header_Payment_rec.last_updated_by <>
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:

Line 503: IF NOT OE_Validate.Last_Update_Date(p_Header_Payment_rec.last_update_date) THEN

499: ( p_Header_Payment_rec.last_update_date <>
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:

Line 515: IF NOT OE_Validate.Last_Update_Login(p_Header_Payment_rec.last_update_login) THEN

511: ( p_Header_Payment_rec.last_update_login <>
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:

Line 525: IF NOT OE_Validate.Line(p_Header_Payment_rec.line_id) THEN

521: ( p_Header_Payment_rec.line_id <>
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:

Line 535: IF NOT OE_Validate.check_number(p_Header_Payment_rec.check_number) THEN

531: ( p_Header_Payment_rec.check_number <>
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:

Line 545: IF NOT OE_Validate.credit_card_approval(p_Header_Payment_rec.credit_card_approval_code) THEN

541: ( p_Header_Payment_rec.credit_card_approval_code <>
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:

Line 558: IF NOT OE_Validate.credit_card_approval_date(p_Header_Payment_rec.credit_card_approval_date) THEN

554: ( p_Header_Payment_rec.credit_card_approval_date <>
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:

Line 568: IF NOT OE_Validate.credit_card(p_Header_Payment_rec.credit_card_code) THEN

564: ( p_Header_Payment_rec.credit_card_code <>
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:

Line 598: IF NOT OE_Validate.credit_card_expiration_date(p_Header_Payment_rec.credit_card_expiration_date) THEN

594: ( p_Header_Payment_rec.credit_card_expiration_date <>
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:

Line 611: IF NOT OE_Validate.credit_card_holder_name(p_Header_Payment_rec.credit_card_holder_name) THEN

607: ( p_Header_Payment_rec.credit_card_holder_name <>
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:

Line 623: IF NOT OE_Validate.credit_card_number(p_Header_Payment_rec.credit_card_number) THEN

619: ( p_Header_Payment_rec.credit_card_number <>
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:

Line 635: IF NOT OE_Validate.payment_level(p_Header_Payment_rec.payment_level_code) THEN

631: ( p_Header_Payment_rec.payment_level_code <>
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:

Line 648: IF NOT OE_Validate.commitment_applied_amount(p_Header_Payment_rec.commitment_applied_amount) THEN

644: ( p_Header_Payment_rec.commitment_applied_amount <>
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:

Line 661: IF NOT OE_Validate.commitment_interfaced_amount(p_Header_Payment_rec.commitment_interfaced_amount) THEN

657: ( p_Header_Payment_rec.commitment_interfaced_amount <>
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:

Line 673: IF NOT OE_Validate.payment_amount(p_Header_Payment_rec.payment_amount) THEN

669: ( p_Header_Payment_rec.payment_amount <>
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:

Line 685: IF NOT OE_Validate.payment_collection_event(p_Header_Payment_rec.payment_collection_event) THEN

681: ( p_Header_Payment_rec.payment_collection_event <>
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

Line 714: IF NOT OE_Validate.payment_trx(p_Header_Payment_rec.payment_trx_id) THEN

710: ( p_Header_Payment_rec.payment_trx_id <>
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:

Line 726: IF NOT OE_Validate.payment_type(p_Header_Payment_rec.payment_type_code) THEN

722: ( p_Header_Payment_rec.payment_type_code <>
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:

Line 738: IF NOT OE_Validate.payment_set(p_Header_Payment_rec.payment_set_id) THEN

734: ( p_Header_Payment_rec.payment_set_id <>
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:

Line 748: IF NOT OE_Validate.prepaid_amount(p_Header_Payment_rec.prepaid_amount) THEN

744: ( p_Header_Payment_rec.prepaid_amount <>
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:

Line 758: IF NOT OE_Validate.receipt_method(p_Header_Payment_rec.receipt_method_id) THEN

754: ( p_Header_Payment_rec.receipt_method_id <>
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:

Line 768: IF NOT OE_Validate.tangible(p_Header_Payment_rec.tangible_id) THEN

764: ( p_Header_Payment_rec.tangible_id <>
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:

Line 778: IF NOT OE_Validate.Payment_Trxn_Extension(p_Header_Payment_rec.trxn_extension_id) THEN

774: ( p_Header_Payment_rec.trxn_extension_id <>
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:

Line 816: oe_debug_pub.add('Validation of desc flex is set to Y in OE_Validate_Header_Payment.attributes',1);

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 ))

Line 885: IF NOT OE_VALIDATE.Payments_Desc_Flex

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
889: ,p_attribute3 => p_Header_Payment_rec.attribute3

Line 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

Line 948: OE_DEBUG_PUB.Add('Entering OE_VALIDATE_Header_Payments.Entity_Delete',1);

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:

Line 954: OE_DEBUG_PUB.Add('Exiting OE_VALIDATE_Header_Payments.Entity_Delete',1);

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

Line 980: END OE_Validate_Header_Payment;

976: END IF;
977:
978: END Entity_Delete;
979:
980: END OE_Validate_Header_Payment;