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.5 2006/07/31 18:42:56 lkxu noship $ */
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.5 2006/07/31 18:42:56 lkxu noship $ */
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 374: OE_DEBUG_PUB.Add('Exiting OE_VALIDATE_Header_Payments.Entity',1);

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:

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

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:

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

418: ( p_Header_Payment_rec.created_by <>
419: p_old_Header_Payment_rec.created_by OR
420: p_old_Header_Payment_rec.created_by IS NULL )
421: THEN
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);

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

429: ( p_Header_Payment_rec.creation_date <>
430: p_old_Header_Payment_rec.creation_date OR
431: p_old_Header_Payment_rec.creation_date IS NULL )
432: THEN
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);

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

440: ( p_Header_Payment_rec.header_id <>
441: p_old_Header_Payment_rec.header_id OR
442: p_old_Header_Payment_rec.header_id IS NULL )
443: THEN
444: IF NOT OE_Validate.Header(p_Header_Payment_rec.header_id) THEN
445: x_return_status := FND_API.G_RET_STS_ERROR;
446: END IF;
447: END IF;
448:

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

452: ( p_Header_Payment_rec.last_updated_by <>
453: p_old_Header_Payment_rec.last_updated_by OR
454: p_old_Header_Payment_rec.last_updated_by IS NULL )
455: THEN
456: IF NOT OE_Validate.Last_Updated_By(p_Header_Payment_rec.last_updated_by) THEN
457: x_return_status := FND_API.G_RET_STS_ERROR;
458: END IF;
459: END IF;
460:

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

464: ( p_Header_Payment_rec.last_update_date <>
465: p_old_Header_Payment_rec.last_update_date OR
466: p_old_Header_Payment_rec.last_update_date IS NULL )
467: THEN
468: IF NOT OE_Validate.Last_Update_Date(p_Header_Payment_rec.last_update_date) THEN
469: x_return_status := FND_API.G_RET_STS_ERROR;
470: END IF;
471: END IF;
472:

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

476: ( p_Header_Payment_rec.last_update_login <>
477: p_old_Header_Payment_rec.last_update_login OR
478: p_old_Header_Payment_rec.last_update_login IS NULL )
479: THEN
480: IF NOT OE_Validate.Last_Update_Login(p_Header_Payment_rec.last_update_login) THEN
481: x_return_status := FND_API.G_RET_STS_ERROR;
482: END IF;
483: END IF;
484:

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

486: ( p_Header_Payment_rec.line_id <>
487: p_old_Header_Payment_rec.line_id OR
488: p_old_Header_Payment_rec.line_id IS NULL )
489: THEN
490: IF NOT OE_Validate.Line(p_Header_Payment_rec.line_id) THEN
491: x_return_status := FND_API.G_RET_STS_ERROR;
492: END IF;
493: END IF;
494:

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

496: ( p_Header_Payment_rec.check_number <>
497: p_old_Header_Payment_rec.check_number OR
498: p_old_Header_Payment_rec.check_number IS NULL )
499: THEN
500: IF NOT OE_Validate.check_number(p_Header_Payment_rec.check_number) THEN
501: x_return_status := FND_API.G_RET_STS_ERROR;
502: END IF;
503: END IF;
504:

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

506: ( p_Header_Payment_rec.credit_card_approval_code <>
507: p_old_Header_Payment_rec.credit_card_approval_code OR
508: p_old_Header_Payment_rec.credit_card_approval_code IS NULL )
509: THEN
510: IF NOT OE_Validate.credit_card_approval(p_Header_Payment_rec.credit_card_approval_code) THEN
511: x_return_status := FND_API.G_RET_STS_ERROR;
512: END IF;
513: END IF;
514:

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

519: ( p_Header_Payment_rec.credit_card_approval_date <>
520: p_old_Header_Payment_rec.credit_card_approval_date OR
521: p_old_Header_Payment_rec.credit_card_approval_date IS NULL )
522: THEN
523: IF NOT OE_Validate.credit_card_approval_date(p_Header_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_Header_Payment_rec.credit_card_code) THEN

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

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

559: ( p_Header_Payment_rec.credit_card_expiration_date <>
560: p_old_Header_Payment_rec.credit_card_expiration_date OR
561: p_old_Header_Payment_rec.credit_card_expiration_date IS NULL )
562: THEN
563: IF NOT OE_Validate.credit_card_expiration_date(p_Header_Payment_rec.credit_card_expiration_date) THEN
564: x_return_status := FND_API.G_RET_STS_ERROR;
565: END IF;
566: END IF;
567:

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

572: ( p_Header_Payment_rec.credit_card_holder_name <>
573: p_old_Header_Payment_rec.credit_card_holder_name OR
574: p_old_Header_Payment_rec.credit_card_holder_name IS NULL )
575: THEN
576: IF NOT OE_Validate.credit_card_holder_name(p_Header_Payment_rec.credit_card_holder_name) THEN
577: x_return_status := FND_API.G_RET_STS_ERROR;
578: END IF;
579: END IF;
580:

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

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

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

596: ( p_Header_Payment_rec.payment_level_code <>
597: p_old_Header_Payment_rec.payment_level_code OR
598: p_old_Header_Payment_rec.payment_level_code IS NULL )
599: THEN
600: IF NOT OE_Validate.payment_level(p_Header_Payment_rec.payment_level_code) THEN
601: x_return_status := FND_API.G_RET_STS_ERROR;
602: END IF;
603: END IF;
604:

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

609: ( p_Header_Payment_rec.commitment_applied_amount <>
610: p_old_Header_Payment_rec.commitment_applied_amount OR
611: p_old_Header_Payment_rec.commitment_applied_amount IS NULL )
612: THEN
613: IF NOT OE_Validate.commitment_applied_amount(p_Header_Payment_rec.commitment_applied_amount) THEN
614: x_return_status := FND_API.G_RET_STS_ERROR;
615: END IF;
616: END IF;
617:

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

622: ( p_Header_Payment_rec.commitment_interfaced_amount <>
623: p_old_Header_Payment_rec.commitment_interfaced_amount OR
624: p_old_Header_Payment_rec.commitment_interfaced_amount IS NULL )
625: THEN
626: IF NOT OE_Validate.commitment_interfaced_amount(p_Header_Payment_rec.commitment_interfaced_amount) THEN
627: x_return_status := FND_API.G_RET_STS_ERROR;
628: END IF;
629: END IF;
630:

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

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

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

646: ( p_Header_Payment_rec.payment_collection_event <>
647: p_old_Header_Payment_rec.payment_collection_event OR
648: p_old_Header_Payment_rec.payment_collection_event IS NULL )
649: THEN
650: IF NOT OE_Validate.payment_collection_event(p_Header_Payment_rec.payment_collection_event) THEN
651: x_return_status := FND_API.G_RET_STS_ERROR;
652: END IF;
653:
654: select count(payment_type_code) into l_line_payment_count

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

670: ( p_Header_Payment_rec.payment_trx_id <>
671: p_old_Header_Payment_rec.payment_trx_id OR
672: p_old_Header_Payment_rec.payment_trx_id IS NULL )
673: THEN
674: IF NOT OE_Validate.payment_trx(p_Header_Payment_rec.payment_trx_id) THEN
675: x_return_status := FND_API.G_RET_STS_ERROR;
676: END IF;
677: END IF;
678:

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

682: ( p_Header_Payment_rec.payment_type_code <>
683: p_old_Header_Payment_rec.payment_type_code OR
684: p_old_Header_Payment_rec.payment_type_code IS NULL )
685: THEN
686: IF NOT OE_Validate.payment_type(p_Header_Payment_rec.payment_type_code) THEN
687: x_return_status := FND_API.G_RET_STS_ERROR;
688: END IF;
689: END IF;
690:

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

694: ( p_Header_Payment_rec.payment_set_id <>
695: p_old_Header_Payment_rec.payment_set_id OR
696: p_old_Header_Payment_rec.payment_set_id IS NULL )
697: THEN
698: IF NOT OE_Validate.payment_set(p_Header_Payment_rec.payment_set_id) THEN
699: x_return_status := FND_API.G_RET_STS_ERROR;
700: END IF;
701: END IF;
702:

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

704: ( p_Header_Payment_rec.prepaid_amount <>
705: p_old_Header_Payment_rec.prepaid_amount OR
706: p_old_Header_Payment_rec.prepaid_amount IS NULL )
707: THEN
708: IF NOT OE_Validate.prepaid_amount(p_Header_Payment_rec.prepaid_amount) THEN
709: x_return_status := FND_API.G_RET_STS_ERROR;
710: END IF;
711: END IF;
712:

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

714: ( p_Header_Payment_rec.receipt_method_id <>
715: p_old_Header_Payment_rec.receipt_method_id OR
716: p_old_Header_Payment_rec.receipt_method_id IS NULL )
717: THEN
718: IF NOT OE_Validate.receipt_method(p_Header_Payment_rec.receipt_method_id) THEN
719: x_return_status := FND_API.G_RET_STS_ERROR;
720: END IF;
721: END IF;
722:

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

724: ( p_Header_Payment_rec.tangible_id <>
725: p_old_Header_Payment_rec.tangible_id OR
726: p_old_Header_Payment_rec.tangible_id IS NULL )
727: THEN
728: IF NOT OE_Validate.tangible(p_Header_Payment_rec.tangible_id) THEN
729: x_return_status := FND_API.G_RET_STS_ERROR;
730: END IF;
731: END IF;
732:

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

734: ( p_Header_Payment_rec.trxn_extension_id <>
735: p_old_Header_Payment_rec.trxn_extension_id OR
736: p_old_Header_Payment_rec.trxn_extension_id IS NULL )
737: THEN
738: IF NOT OE_Validate.Payment_Trxn_Extension(p_Header_Payment_rec.trxn_extension_id) THEN
739: x_return_status := FND_API.G_RET_STS_ERROR;
740: END IF;
741: END IF; --R12 Process order api changes
742:

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

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

Line 845: IF NOT OE_VALIDATE.Payments_Desc_Flex

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

Line 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

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

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:

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

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

Line 940: END OE_Validate_Header_Payment;

936: END IF;
937:
938: END Entity_Delete;
939:
940: END OE_Validate_Header_Payment;