eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_VALIDATE_LINE_PAYMENT dependencies on OE_VALIDATE

Line 1: PACKAGE BODY OE_Validate_Line_Payment AS

1: PACKAGE BODY OE_Validate_Line_Payment AS
2: /* $Header: OEXLLPMB.pls 120.6 2006/07/31 18:44:40 lkxu noship $ */
3:
4: -- Global constant holding the package name
5:

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

2: /* $Header: OEXLLPMB.pls 120.6 2006/07/31 18:44:40 lkxu noship $ */
3:
4: -- Global constant holding the package name
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_Validate_Line_Payment';
7:
8: -- Procedure Entity
9:
10: PROCEDURE Entity

Line 36: OE_DEBUG_PUB.Add('Entering OE_VALIDATE_Line_Payments.Entity',1);

32: --bug5176401 end
33:
34: BEGIN
35:
36: OE_DEBUG_PUB.Add('Entering OE_VALIDATE_Line_Payments.Entity',1);
37: -- Check required attributes.
38:
39: IF p_Line_Payment_rec.payment_number IS NULL
40: THEN

Line 385: OE_DEBUG_PUB.Add('Exiting OE_VALIDATE_Line_Payments.Entity',1);

381: -- Done validating entity
382:
383: x_return_status := l_return_status;
384:
385: OE_DEBUG_PUB.Add('Exiting OE_VALIDATE_Line_Payments.Entity',1);
386: EXCEPTION
387:
388: WHEN FND_API.G_EXC_ERROR THEN
389:

Line 422: OE_DEBUG_PUB.Add('Entering OE_VALIDATE_Line_Payments.Attributes',1);

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

Line 432: IF NOT OE_Validate.Created_By(p_Line_Payment_rec.created_by) THEN

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

Line 442: IF NOT OE_Validate.Creation_Date(p_Line_Payment_rec.creation_date) THEN

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

Line 452: IF NOT OE_Validate.Header(p_Line_Payment_rec.header_id) THEN

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

Line 462: IF NOT OE_Validate.Last_Updated_By(p_Line_Payment_rec.last_updated_by) THEN

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

Line 472: IF NOT OE_Validate.Last_Update_Date(p_Line_Payment_rec.last_update_date) THEN

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

Line 482: IF NOT OE_Validate.Last_Update_Login(p_Line_Payment_rec.last_update_login) THEN

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

Line 492: IF NOT OE_Validate.Line(p_Line_Payment_rec.line_id) THEN

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

Line 502: IF NOT OE_Validate.check_number(p_Line_Payment_rec.check_number) THEN

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

Line 512: IF NOT OE_Validate.credit_card_approval(p_Line_Payment_rec.credit_card_approval_code) THEN

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

Line 523: IF NOT OE_Validate.credit_card_approval_date(p_Line_Payment_rec.credit_card_approval_date) THEN

519: ( p_Line_Payment_rec.credit_card_approval_date <>
520: p_old_Line_Payment_rec.credit_card_approval_date OR
521: p_old_Line_Payment_rec.credit_card_approval_date IS NULL )
522: THEN
523: IF NOT OE_Validate.credit_card_approval_date(p_Line_Payment_rec.credit_card_approval_date) THEN
524: x_return_status := FND_API.G_RET_STS_ERROR;
525: END IF;
526: END IF;
527:

Line 533: IF NOT OE_Validate.credit_card(p_Line_Payment_rec.credit_card_code) THEN

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

Line 558: IF NOT OE_Validate.credit_card_expiration_date(p_Line_Payment_rec.credit_card_expiration_date) THEN

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

Line 568: IF NOT OE_Validate.credit_card_holder_name(p_Line_Payment_rec.credit_card_holder_name) THEN

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

Line 578: IF NOT OE_Validate.credit_card_number(p_Line_Payment_rec.credit_card_number) THEN

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

Line 588: IF NOT OE_Validate.payment_level(p_Line_Payment_rec.payment_level_code) THEN

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

Line 598: IF NOT OE_Validate.commitment_applied_amount(p_Line_Payment_rec.commitment_applied_amount) THEN

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

Line 608: IF NOT OE_Validate.commitment_interfaced_amount(p_Line_Payment_rec.commitment_interfaced_amount) THEN

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

Line 618: IF NOT OE_Validate.payment_amount(p_Line_Payment_rec.payment_amount) THEN

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

Line 628: IF NOT OE_Validate.payment_collection_event(p_Line_Payment_rec.payment_collection_event) THEN

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

Line 638: IF NOT OE_Validate.payment_trx(p_Line_Payment_rec.payment_trx_id) THEN

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

Line 648: IF NOT OE_Validate.payment_type(p_Line_Payment_rec.payment_type_code) THEN

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

Line 658: IF NOT OE_Validate.payment_set(p_Line_Payment_rec.payment_set_id) THEN

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

Line 668: IF NOT OE_Validate.prepaid_amount(p_Line_Payment_rec.prepaid_amount) THEN

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

Line 678: IF NOT OE_Validate.receipt_method(p_Line_Payment_rec.receipt_method_id) THEN

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

Line 688: IF NOT OE_Validate.tangible(p_Line_Payment_rec.tangible_id) THEN

684: ( p_Line_Payment_rec.tangible_id <>
685: p_old_Line_Payment_rec.tangible_id OR
686: p_old_Line_Payment_rec.tangible_id IS NULL )
687: THEN
688: IF NOT OE_Validate.tangible(p_Line_Payment_rec.tangible_id) THEN
689: x_return_status := FND_API.G_RET_STS_ERROR;
690: END IF;
691: END IF;
692:

Line 698: IF NOT OE_Validate.Payment_Trxn_Extension(p_Line_Payment_rec.trxn_extension_id) THEN

694: ( p_Line_Payment_rec.trxn_extension_id <>
695: p_old_Line_Payment_rec.trxn_extension_id OR
696: p_old_Line_Payment_rec.trxn_extension_id IS NULL )
697: THEN
698: IF NOT OE_Validate.Payment_Trxn_Extension(p_Line_Payment_rec.trxn_extension_id) THEN
699: x_return_status := FND_API.G_RET_STS_ERROR;
700: END IF;
701: END IF; --R12 Process order api changes
702: if OE_GLOBALS.g_validate_desc_flex ='Y' then --bug 4343612

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

699: x_return_status := FND_API.G_RET_STS_ERROR;
700: END IF;
701: END IF; --R12 Process order api changes
702: if OE_GLOBALS.g_validate_desc_flex ='Y' then --bug 4343612
703: oe_debug_pub.add('Validation of desc flex is set to Y in OE_Validate_Line_Payment.attributes ',1);
704: IF (p_Line_Payment_rec.attribute1 IS NOT NULL AND
705: ( p_Line_Payment_rec.attribute1 <>
706: p_old_Line_Payment_rec.attribute1 OR
707: p_old_Line_Payment_rec.attribute1 IS NULL ))

Line 772: IF NOT OE_VALIDATE.Payments_Desc_Flex

768: THEN
769:
770:
771: oe_debug_pub.add('Before calling Payments_Desc_Flex',2);
772: IF NOT OE_VALIDATE.Payments_Desc_Flex
773: (p_context => p_Line_Payment_rec.context
774: ,p_attribute1 => p_Line_Payment_rec.attribute1
775: ,p_attribute2 => p_Line_Payment_rec.attribute2
776: ,p_attribute3 => p_Line_Payment_rec.attribute3

Line 797: OE_DEBUG_PUB.Add('Exiting OE_VALIDATE_Line_Payments.Attributes',1);

793: oe_debug_pub.add('After Payments_Desc_Flex ' || x_return_status,2);
794:
795: END IF;
796:
797: OE_DEBUG_PUB.Add('Exiting OE_VALIDATE_Line_Payments.Attributes',1);
798: -- Done validating attributes
799: end if ; /*if OE_GLOBALS.g_validate_desc_flex ='Y' then bug 4343612*/
800: EXCEPTION
801:

Line 834: OE_DEBUG_PUB.Add('Entering OE_VALIDATE_Line_Payments.Entity_Delete',1);

830: IS
831: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
832: BEGIN
833:
834: OE_DEBUG_PUB.Add('Entering OE_VALIDATE_Line_Payments.Entity_Delete',1);
835: -- Validate entity delete.
836: NULL;
837: -- Done.
838:

Line 840: OE_DEBUG_PUB.Add('Exiting OE_VALIDATE_Line_Payments.Entity_Delete',1);

836: NULL;
837: -- Done.
838:
839: x_return_status := l_return_status;
840: OE_DEBUG_PUB.Add('Exiting OE_VALIDATE_Line_Payments.Entity_Delete',1);
841:
842: EXCEPTION
843:
844: WHEN FND_API.G_EXC_ERROR THEN

Line 866: END OE_Validate_Line_Payment;

862: END IF;
863:
864: END Entity_Delete;
865:
866: END OE_Validate_Line_Payment;