APPS.OE_VALIDATE_LINE_ADJ dependencies on OE_VALIDATE

Line 1: PACKAGE BODY OE_Validate_Line_Adj AS

1: PACKAGE BODY OE_Validate_Line_Adj AS
2: /* $Header: OEXLLADB.pls 120.2 2005/12/29 04:29:50 ppnair noship $ */
3:
4: -- Global constant holding the package name
5:

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

2: /* $Header: OEXLLADB.pls 120.2 2005/12/29 04:29:50 ppnair noship $ */
3:
4: -- Global constant holding the package name
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_Validate_Line_Adj';
7:
8: -- Procedure Entity
9:
10:

Line 33: Oe_debug_pub.add('Entering OE_Validate_Line_Adj.Entity');

29: stmt Number;
30: BEGIN
31:
32: stmt:=1;
33: Oe_debug_pub.add('Entering OE_Validate_Line_Adj.Entity');
34: -- Check required attributes.
35:
36: IF p_Line_Adj_rec.price_adjustment_id IS NULL
37: THEN

Line 598: oe_debug_pub.add('Leaving oe_validate_line_adj.entity');

594:
595: -- Return
596:
597: x_return_status := l_return_status;
598: oe_debug_pub.add('Leaving oe_validate_line_adj.entity');
599: EXCEPTION
600:
601: WHEN FND_API.G_EXC_ERROR THEN
602:

Line 633: oe_debug_pub.add('Entering OE_VALIDATE_LINE_ADJ.ATTRIBUTES');

629: OE_Order_PUB.G_MISS_LINE_ADJ_REC
630: )
631: IS
632: BEGIN
633: oe_debug_pub.add('Entering OE_VALIDATE_LINE_ADJ.ATTRIBUTES');
634: x_return_status := FND_API.G_RET_STS_SUCCESS;
635:
636: -- Validate Line_Adj attributes
637:

Line 643: IF NOT OE_Validate_adj.Price_Adjustment(p_Line_Adj_rec.price_adjustment_id) THEN

639: ( p_Line_Adj_rec.price_adjustment_id <>
640: p_old_Line_Adj_rec.price_adjustment_id OR
641: p_old_Line_Adj_rec.price_adjustment_id IS NULL )
642: THEN
643: IF NOT OE_Validate_adj.Price_Adjustment(p_Line_Adj_rec.price_adjustment_id) THEN
644: oe_debug_pub.add(' Error price_adjustment_id');
645: x_return_status := FND_API.G_RET_STS_ERROR;
646: END IF;
647: END IF;

Line 654: IF NOT OE_Validate_adj.Creation_Date(p_Line_Adj_rec.creation_date) THEN

650: ( p_Line_Adj_rec.creation_date <>
651: p_old_Line_Adj_rec.creation_date OR
652: p_old_Line_Adj_rec.creation_date IS NULL )
653: THEN
654: IF NOT OE_Validate_adj.Creation_Date(p_Line_Adj_rec.creation_date) THEN
655: oe_debug_pub.add(' Error creation_date');
656: x_return_status := FND_API.G_RET_STS_ERROR;
657: END IF;
658: END IF;

Line 665: IF NOT OE_Validate_adj.Created_By(p_Line_Adj_rec.created_by) THEN

661: ( p_Line_Adj_rec.created_by <>
662: p_old_Line_Adj_rec.created_by OR
663: p_old_Line_Adj_rec.created_by IS NULL )
664: THEN
665: IF NOT OE_Validate_adj.Created_By(p_Line_Adj_rec.created_by) THEN
666: oe_debug_pub.add(' Error created_by');
667: x_return_status := FND_API.G_RET_STS_ERROR;
668: END IF;
669: END IF;

Line 676: IF NOT OE_Validate_adj.Last_Update_Date(p_Line_Adj_rec.last_update_date) THEN

672: ( p_Line_Adj_rec.last_update_date <>
673: p_old_Line_Adj_rec.last_update_date OR
674: p_old_Line_Adj_rec.last_update_date IS NULL )
675: THEN
676: IF NOT OE_Validate_adj.Last_Update_Date(p_Line_Adj_rec.last_update_date) THEN
677: oe_debug_pub.add(' Error last_update_date');
678: x_return_status := FND_API.G_RET_STS_ERROR;
679: END IF;
680: END IF;

Line 687: IF NOT OE_Validate_adj.Last_Updated_By(p_Line_Adj_rec.last_updated_by) THEN

683: ( p_Line_Adj_rec.last_updated_by <>
684: p_old_Line_Adj_rec.last_updated_by OR
685: p_old_Line_Adj_rec.last_updated_by IS NULL )
686: THEN
687: IF NOT OE_Validate_adj.Last_Updated_By(p_Line_Adj_rec.last_updated_by) THEN
688: oe_debug_pub.add(' Error last_updated_by');
689: x_return_status := FND_API.G_RET_STS_ERROR;
690: END IF;
691: END IF;

Line 698: IF NOT OE_Validate_adj.Last_Update_Login(p_Line_Adj_rec.last_update_login) THEN

694: ( p_Line_Adj_rec.last_update_login <>
695: p_old_Line_Adj_rec.last_update_login OR
696: p_old_Line_Adj_rec.last_update_login IS NULL )
697: THEN
698: IF NOT OE_Validate_adj.Last_Update_Login(p_Line_Adj_rec.last_update_login) THEN
699: oe_debug_pub.add(' Error last_update_login');
700: x_return_status := FND_API.G_RET_STS_ERROR;
701: END IF;
702: END IF;

Line 709: IF NOT OE_Validate_adj.Program_Application(p_Line_Adj_rec.program_application_id) THEN

705: ( p_Line_Adj_rec.program_application_id <>
706: p_old_Line_Adj_rec.program_application_id OR
707: p_old_Line_Adj_rec.program_application_id IS NULL )
708: THEN
709: IF NOT OE_Validate_adj.Program_Application(p_Line_Adj_rec.program_application_id) THEN
710: oe_debug_pub.add(' Error program_application_id');
711: x_return_status := FND_API.G_RET_STS_ERROR;
712: END IF;
713: END IF;

Line 720: IF NOT OE_Validate_adj.Program(p_Line_Adj_rec.program_id) THEN

716: ( p_Line_Adj_rec.program_id <>
717: p_old_Line_Adj_rec.program_id OR
718: p_old_Line_Adj_rec.program_id IS NULL )
719: THEN
720: IF NOT OE_Validate_adj.Program(p_Line_Adj_rec.program_id) THEN
721: oe_debug_pub.add(' Error program id');
722: x_return_status := FND_API.G_RET_STS_ERROR;
723: END IF;
724: END IF;

Line 731: IF NOT OE_Validate_adj.Program_Update_Date(p_Line_Adj_rec.program_update_date) THEN

727: ( p_Line_Adj_rec.program_update_date <>
728: p_old_Line_Adj_rec.program_update_date OR
729: p_old_Line_Adj_rec.program_update_date IS NULL )
730: THEN
731: IF NOT OE_Validate_adj.Program_Update_Date(p_Line_Adj_rec.program_update_date) THEN
732: oe_debug_pub.add(' Error program_update_date');
733: x_return_status := FND_API.G_RET_STS_ERROR;
734: END IF;
735: END IF;

Line 742: IF NOT OE_Validate_adj.Request(p_Line_Adj_rec.request_id) THEN

738: ( p_Line_Adj_rec.request_id <>
739: p_old_Line_Adj_rec.request_id OR
740: p_old_Line_Adj_rec.request_id IS NULL )
741: THEN
742: IF NOT OE_Validate_adj.Request(p_Line_Adj_rec.request_id) THEN
743: oe_debug_pub.add(' Error request id');
744: x_return_status := FND_API.G_RET_STS_ERROR;
745: END IF;
746: END IF;

Line 753: IF NOT OE_Validate_adj.Header(p_Line_Adj_rec.header_id) THEN

749: ( p_Line_Adj_rec.header_id <>
750: p_old_Line_Adj_rec.header_id OR
751: p_old_Line_Adj_rec.header_id IS NULL )
752: THEN
753: IF NOT OE_Validate_adj.Header(p_Line_Adj_rec.header_id) THEN
754: oe_debug_pub.add(' Error header_id');
755: x_return_status := FND_API.G_RET_STS_ERROR;
756: END IF;
757: END IF;

Line 764: IF NOT OE_Validate_adj.Discount(p_Line_Adj_rec.discount_id) THEN

760: ( p_Line_Adj_rec.discount_id <>
761: p_old_Line_Adj_rec.discount_id OR
762: p_old_Line_Adj_rec.discount_id IS NULL )
763: THEN
764: IF NOT OE_Validate_adj.Discount(p_Line_Adj_rec.discount_id) THEN
765: oe_debug_pub.add(' Error discount_id');
766: x_return_status := FND_API.G_RET_STS_ERROR;
767: END IF;
768: END IF;

Line 775: IF NOT OE_Validate_adj.Discount_Line(p_Line_Adj_rec.discount_line_id) THEN

771: ( p_Line_Adj_rec.discount_line_id <>
772: p_old_Line_Adj_rec.discount_line_id OR
773: p_old_Line_Adj_rec.discount_line_id IS NULL )
774: THEN
775: IF NOT OE_Validate_adj.Discount_Line(p_Line_Adj_rec.discount_line_id) THEN
776: x_return_status := FND_API.G_RET_STS_ERROR;
777: END IF;
778: END IF;
779: oe_debug_pub.add(' LLADB half way');

Line 785: IF NOT OE_Validate_adj.Automatic(p_Line_Adj_rec.automatic_flag) THEN

781: ( p_Line_Adj_rec.automatic_flag <>
782: p_old_Line_Adj_rec.automatic_flag OR
783: p_old_Line_Adj_rec.automatic_flag IS NULL )
784: THEN
785: IF NOT OE_Validate_adj.Automatic(p_Line_Adj_rec.automatic_flag) THEN
786: oe_debug_pub.add(' Error automatic_flag');
787: x_return_status := FND_API.G_RET_STS_ERROR;
788: END IF;
789: END IF;

Line 796: IF NOT OE_Validate_adj.Percent(p_Line_Adj_rec.percent) THEN

792: ( p_Line_Adj_rec.percent <>
793: p_old_Line_Adj_rec.percent OR
794: p_old_Line_Adj_rec.percent IS NULL )
795: THEN
796: IF NOT OE_Validate_adj.Percent(p_Line_Adj_rec.percent) THEN
797: oe_debug_pub.add(' Error percent');
798: x_return_status := FND_API.G_RET_STS_ERROR;
799: END IF;
800: END IF;

Line 807: IF NOT OE_Validate_adj.Line(p_Line_Adj_rec.line_id) THEN

803: ( p_Line_Adj_rec.line_id <>
804: p_old_Line_Adj_rec.line_id OR
805: p_old_Line_Adj_rec.line_id IS NULL )
806: THEN
807: IF NOT OE_Validate_adj.Line(p_Line_Adj_rec.line_id) THEN
808: oe_debug_pub.add(' Error line_id');
809: x_return_status := FND_API.G_RET_STS_ERROR;
810: END IF;
811: END IF;

Line 818: IF NOT oe_validate_adj.List_Line_No(p_Line_Adj_rec.list_line_no) THEN

814: ( p_Line_Adj_rec.list_line_no <>
815: p_old_Line_Adj_rec.list_line_no OR
816: p_old_Line_Adj_rec.list_line_no IS NULL )
817: THEN
818: IF NOT oe_validate_adj.List_Line_No(p_Line_Adj_rec.list_line_no) THEN
819: oe_debug_pub.add(' Error list_line_no');
820: x_return_status := FND_API.G_RET_STS_ERROR;
821: END IF;
822: END IF;

Line 829: IF NOT oe_validate_adj.source_system_code(p_Line_Adj_rec.source_system_code) THEN

825: ( p_Line_Adj_rec.source_system_code <>
826: p_old_Line_Adj_rec.source_system_code OR
827: p_old_Line_Adj_rec.source_system_code IS NULL )
828: THEN
829: IF NOT oe_validate_adj.source_system_code(p_Line_Adj_rec.source_system_code) THEN
830: oe_debug_pub.add(' Error source_system_code');
831: x_return_status := FND_API.G_RET_STS_ERROR;
832: END IF;
833: END IF;

Line 840: IF NOT oe_validate_adj.benefit_qty(p_Line_Adj_rec.benefit_qty) THEN

836: ( p_Line_Adj_rec.benefit_qty <>
837: p_old_Line_Adj_rec.benefit_qty OR
838: p_old_Line_Adj_rec.benefit_qty IS NULL )
839: THEN
840: IF NOT oe_validate_adj.benefit_qty(p_Line_Adj_rec.benefit_qty) THEN
841: oe_debug_pub.add(' Error benefit_qty');
842: x_return_status := FND_API.G_RET_STS_ERROR;
843: END IF;
844: END IF;

Line 851: IF NOT oe_validate_adj.benefit_uom_code(p_Line_Adj_rec.benefit_uom_code) THEN

847: ( p_Line_Adj_rec.benefit_uom_code <>
848: p_old_Line_Adj_rec.benefit_uom_code OR
849: p_old_Line_Adj_rec.benefit_uom_code IS NULL )
850: THEN
851: IF NOT oe_validate_adj.benefit_uom_code(p_Line_Adj_rec.benefit_uom_code) THEN
852: oe_debug_pub.add(' Error benefit_uom_code');
853: x_return_status := FND_API.G_RET_STS_ERROR;
854: END IF;
855: END IF;

Line 862: IF NOT oe_validate_adj.print_on_invoice_flag(p_Line_Adj_rec.print_on_invoice_flag) THEN

858: ( p_Line_Adj_rec.print_on_invoice_flag <>
859: p_old_Line_Adj_rec.print_on_invoice_flag OR
860: p_old_Line_Adj_rec.print_on_invoice_flag IS NULL )
861: THEN
862: IF NOT oe_validate_adj.print_on_invoice_flag(p_Line_Adj_rec.print_on_invoice_flag) THEN
863: oe_debug_pub.add(' Error print_on_invoice_flag');
864: x_return_status := FND_API.G_RET_STS_ERROR;
865: END IF;
866: END IF;

Line 873: IF NOT oe_validate_adj.expiration_date(p_Line_Adj_rec.expiration_date) THEN

869: ( p_Line_Adj_rec.expiration_date <>
870: p_old_Line_Adj_rec.expiration_date OR
871: p_old_Line_Adj_rec.expiration_date IS NULL )
872: THEN
873: IF NOT oe_validate_adj.expiration_date(p_Line_Adj_rec.expiration_date) THEN
874: oe_debug_pub.add(' Error expiration_date');
875: x_return_status := FND_API.G_RET_STS_ERROR;
876: END IF;
877: END IF;

Line 884: IF NOT oe_validate_adj.rebate_transaction_type_code(p_Line_Adj_rec.rebate_transaction_type_code) THEN

880: ( p_Line_Adj_rec.rebate_transaction_type_code <>
881: p_old_Line_Adj_rec.rebate_transaction_type_code OR
882: p_old_Line_Adj_rec.rebate_transaction_type_code IS NULL )
883: THEN
884: IF NOT oe_validate_adj.rebate_transaction_type_code(p_Line_Adj_rec.rebate_transaction_type_code) THEN
885: oe_debug_pub.add(' Error rebate_transaction_type_code');
886: x_return_status := FND_API.G_RET_STS_ERROR;
887: END IF;
888: END IF;

Line 896: IF NOT oe_validate_adj.rebate_transaction_reference(p_Line_Adj_rec.rebate_transaction_reference) THEN

892: ( p_Line_Adj_rec.rebate_transaction_reference <>
893: p_old_Line_Adj_rec.rebate_transaction_reference OR
894: p_old_Line_Adj_rec.rebate_transaction_reference IS NULL )
895: THEN
896: IF NOT oe_validate_adj.rebate_transaction_reference(p_Line_Adj_rec.rebate_transaction_reference) THEN
897: x_return_status := FND_API.G_RET_STS_ERROR;
898: END IF;
899: END IF;
900:

Line 906: IF NOT oe_validate_adj.rebate_payment_system_code(p_Line_Adj_rec.rebate_payment_system_code) THEN

902: ( p_Line_Adj_rec.rebate_payment_system_code <>
903: p_old_Line_Adj_rec.rebate_payment_system_code OR
904: p_old_Line_Adj_rec.rebate_payment_system_code IS NULL )
905: THEN
906: IF NOT oe_validate_adj.rebate_payment_system_code(p_Line_Adj_rec.rebate_payment_system_code) THEN
907: oe_debug_pub.add(' Error ebate_payment_system_code');
908: x_return_status := FND_API.G_RET_STS_ERROR;
909: END IF;
910: END IF;

Line 917: IF NOT oe_validate_adj.Redeemed_Date(p_Line_Adj_rec.Redeemed_Date) THEN

913: ( p_Line_Adj_rec.Redeemed_Date <>
914: p_old_Line_Adj_rec.Redeemed_Date OR
915: p_old_Line_Adj_rec.Redeemed_Date IS NULL )
916: THEN
917: IF NOT oe_validate_adj.Redeemed_Date(p_Line_Adj_rec.Redeemed_Date) THEN
918: x_return_status := FND_API.G_RET_STS_ERROR;
919: END IF;
920: END IF;
921:

Line 927: IF NOT oe_validate_adj.Redeemed_Flag(p_Line_Adj_rec.redeemed_flag) THEN

923: ( p_Line_Adj_rec.redeemed_flag <>
924: p_old_Line_Adj_rec.redeemed_flag OR
925: p_old_Line_Adj_rec.redeemed_flag IS NULL )
926: THEN
927: IF NOT oe_validate_adj.Redeemed_Flag(p_Line_Adj_rec.redeemed_flag) THEN
928: oe_debug_pub.add(' Error redeemed_flag');
929: x_return_status := FND_API.G_RET_STS_ERROR;
930: END IF;
931: END IF;

Line 938: IF NOT oe_validate_adj.Accrual_Flag(p_Line_Adj_rec.accrual_flag) THEN

934: ( p_Line_Adj_rec.accrual_flag <>
935: p_old_Line_Adj_rec.accrual_flag OR
936: p_old_Line_Adj_rec.accrual_flag IS NULL )
937: THEN
938: IF NOT oe_validate_adj.Accrual_Flag(p_Line_Adj_rec.accrual_flag) THEN
939: oe_debug_pub.add(' Error accrual_flag');
940: x_return_status := FND_API.G_RET_STS_ERROR;
941: END IF;
942: END IF;

Line 949: IF NOT OE_Validate_adj.list_header_id(p_Line_Adj_rec.list_header_id) THEN

945: ( p_Line_Adj_rec.list_header_id <>
946: p_old_Line_Adj_rec.list_header_id OR
947: p_old_Line_Adj_rec.list_header_id IS NULL )
948: THEN
949: IF NOT OE_Validate_adj.list_header_id(p_Line_Adj_rec.list_header_id) THEN
950: oe_debug_pub.add(' Error list_header_id');
951: x_return_status := FND_API.G_RET_STS_ERROR;
952: END IF;
953: END IF;

Line 960: IF NOT OE_Validate_adj.list_line_id(p_Line_Adj_rec.list_line_id) THEN

956: ( p_Line_Adj_rec.list_line_id <>
957: p_old_Line_Adj_rec.list_line_id OR
958: p_old_Line_Adj_rec.list_line_id IS NULL )
959: THEN
960: IF NOT OE_Validate_adj.list_line_id(p_Line_Adj_rec.list_line_id) THEN
961: oe_debug_pub.add(' Error list_line_id');
962: x_return_status := FND_API.G_RET_STS_ERROR;
963: END IF;
964: END IF;

Line 971: IF NOT OE_Validate_adj.list_line_type_code(p_Line_Adj_rec.list_line_type_code) THEN

967: ( p_Line_Adj_rec.list_line_type_code <>
968: p_old_Line_Adj_rec.list_line_type_code OR
969: p_old_Line_Adj_rec.list_line_type_code IS NULL )
970: THEN
971: IF NOT OE_Validate_adj.list_line_type_code(p_Line_Adj_rec.list_line_type_code) THEN
972: oe_debug_pub.add(' Error list_line_type_code');
973: x_return_status := FND_API.G_RET_STS_ERROR;
974: END IF;
975: END IF;

Line 982: IF NOT OE_Validate_adj.modified_from(p_Line_Adj_rec.modified_from) THEN

978: ( p_Line_Adj_rec.modified_from <>
979: p_old_Line_Adj_rec.modified_from OR
980: p_old_Line_Adj_rec.modified_from IS NULL )
981: THEN
982: IF NOT OE_Validate_adj.modified_from(p_Line_Adj_rec.modified_from) THEN
983: oe_debug_pub.add(' Error modified_from');
984: x_return_status := FND_API.G_RET_STS_ERROR;
985: END IF;
986: END IF;

Line 993: IF NOT OE_Validate_adj.modified_to(p_Line_Adj_rec.modified_to) THEN

989: ( p_Line_Adj_rec.modified_to <>
990: p_old_Line_Adj_rec.modified_to OR
991: p_old_Line_Adj_rec.modified_to IS NULL )
992: THEN
993: IF NOT OE_Validate_adj.modified_to(p_Line_Adj_rec.modified_to) THEN
994: oe_debug_pub.add(' Error Modified to');
995: x_return_status := FND_API.G_RET_STS_ERROR;
996: END IF;
997: END IF;

Line 1004: IF NOT OE_Validate_adj.updated_flag(p_Line_Adj_rec.updated_flag) THEN

1000: ( p_Line_Adj_rec.updated_flag <>
1001: p_old_Line_Adj_rec.updated_flag OR
1002: p_old_Line_Adj_rec.updated_flag IS NULL )
1003: THEN
1004: IF NOT OE_Validate_adj.updated_flag(p_Line_Adj_rec.updated_flag) THEN
1005: oe_debug_pub.add(' Error updated_flag');
1006: x_return_status := FND_API.G_RET_STS_ERROR;
1007: END IF;
1008: END IF;

Line 1015: IF NOT OE_Validate_adj.update_allowed(p_Line_Adj_rec.update_allowed) THEN

1011: ( p_Line_Adj_rec.update_allowed <>
1012: p_old_Line_Adj_rec.update_allowed OR
1013: p_old_Line_Adj_rec.update_allowed IS NULL )
1014: THEN
1015: IF NOT OE_Validate_adj.update_allowed(p_Line_Adj_rec.update_allowed) THEN
1016: oe_debug_pub.add(' Erro update_allowed');
1017: x_return_status := FND_API.G_RET_STS_ERROR;
1018: END IF;
1019: END IF;

Line 1026: IF NOT OE_Validate_adj.applied_flag(p_Line_Adj_rec.applied_flag) THEN

1022: ( p_Line_Adj_rec.applied_flag <>
1023: p_old_Line_Adj_rec.applied_flag OR
1024: p_old_Line_Adj_rec.applied_flag IS NULL )
1025: THEN
1026: IF NOT OE_Validate_adj.applied_flag(p_Line_Adj_rec.applied_flag) THEN
1027: oe_debug_pub.add(' Error Applied flag');
1028: x_return_status := FND_API.G_RET_STS_ERROR;
1029: END IF;
1030: END IF;

Line 1037: IF NOT OE_Validate_adj.applied_flag(p_Line_Adj_rec.applied_flag) THEN

1033: ( p_Line_Adj_rec.applied_flag <>
1034: p_old_Line_Adj_rec.applied_flag OR
1035: p_old_Line_Adj_rec.applied_flag IS NULL )
1036: THEN
1037: IF NOT OE_Validate_adj.applied_flag(p_Line_Adj_rec.applied_flag) THEN
1038: x_return_status := FND_API.G_RET_STS_ERROR;
1039: END IF;
1040: END IF;
1041:

Line 1047: IF NOT OE_Validate_adj.change_reason_code(p_Line_Adj_rec.change_reason_code) THEN

1043: ( p_Line_Adj_rec.change_reason_code <>
1044: p_old_Line_Adj_rec.change_reason_code OR
1045: p_old_Line_Adj_rec.change_reason_code IS NULL )
1046: THEN
1047: IF NOT OE_Validate_adj.change_reason_code(p_Line_Adj_rec.change_reason_code) THEN
1048: oe_debug_pub.add(' Error change_reason_code');
1049: x_return_status := FND_API.G_RET_STS_ERROR;
1050: END IF;
1051: END IF;

Line 1058: IF NOT OE_Validate_adj.change_reason_text(p_Line_Adj_rec.change_reason_text) THEN

1054: ( p_Line_Adj_rec.change_reason_text <>
1055: p_old_Line_Adj_rec.change_reason_text OR
1056: p_old_Line_Adj_rec.change_reason_text IS NULL )
1057: THEN
1058: IF NOT OE_Validate_adj.change_reason_text(p_Line_Adj_rec.change_reason_text) THEN
1059: oe_debug_pub.add(' Error change reason code');
1060: x_return_status := FND_API.G_RET_STS_ERROR;
1061: END IF;
1062: END IF;

Line 1069: IF NOT OE_Validate_adj.Adjusted_Amount(p_Line_Adj_rec.adjusted_amount)

1065: ( p_Line_Adj_rec.adjusted_amount <>
1066: p_old_Line_Adj_rec.adjusted_amount OR
1067: p_old_Line_Adj_rec.adjusted_amount IS NULL )
1068: THEN
1069: IF NOT OE_Validate_adj.Adjusted_Amount(p_Line_Adj_rec.adjusted_amount)
1070: THEN
1071: oe_debug_pub.add(' Error adjusted_amount');
1072: x_return_status := FND_API.G_RET_STS_ERROR;
1073: END IF;

Line 1081: IF NOT OE_Validate_adj.Pricing_Phase_id(p_Line_Adj_rec.pricing_phase_id) THEN

1077: ( p_Line_Adj_rec.pricing_phase_id <>
1078: p_old_Line_Adj_rec.pricing_phase_id OR
1079: p_old_Line_Adj_rec.pricing_phase_id IS NULL )
1080: THEN
1081: IF NOT OE_Validate_adj.Pricing_Phase_id(p_Line_Adj_rec.pricing_phase_id) THEN
1082: oe_debug_pub.add(' Error Pricing phase id');
1083: x_return_status := FND_API.G_RET_STS_ERROR;
1084: END IF;
1085: END IF;

Line 1092: IF NOT OE_Validate_adj.operand(p_Line_Adj_rec.operand) THEN

1088: ( p_Line_Adj_rec.operand <>
1089: p_old_Line_Adj_rec.operand OR
1090: p_old_Line_Adj_rec.operand IS NULL )
1091: THEN
1092: IF NOT OE_Validate_adj.operand(p_Line_Adj_rec.operand) THEN
1093: oe_debug_pub.add(' Error Operand');
1094: x_return_status := FND_API.G_RET_STS_ERROR;
1095: END IF;
1096: END IF;

Line 1103: IF NOT OE_Validate_adj.arithmetic_operator(p_Line_Adj_rec.arithmetic_operator) THEN

1099: ( p_Line_Adj_rec.arithmetic_operator <>
1100: p_old_Line_Adj_rec.arithmetic_operator OR
1101: p_old_Line_Adj_rec.arithmetic_operator IS NULL )
1102: THEN
1103: IF NOT OE_Validate_adj.arithmetic_operator(p_Line_Adj_rec.arithmetic_operator) THEN
1104: oe_debug_pub.add(' Err arithmetic ope');
1105: x_return_status := FND_API.G_RET_STS_ERROR;
1106: END IF;
1107: END IF;

Line 1114: IF NOT OE_Validate_adj.range_break_quantity(p_Line_Adj_rec.range_break_quantity) THEN

1110: ( p_Line_Adj_rec.range_break_quantity <>
1111: p_old_Line_Adj_rec.range_break_quantity OR
1112: p_old_Line_Adj_rec.range_break_quantity IS NULL )
1113: THEN
1114: IF NOT OE_Validate_adj.range_break_quantity(p_Line_Adj_rec.range_break_quantity) THEN
1115: oe_debug_pub.add(' Err range_break_quanti');
1116: x_return_status := FND_API.G_RET_STS_ERROR;
1117: END IF;
1118: END IF;

Line 1125: IF NOT OE_Validate_adj.accrual_conversion_rate(p_Line_Adj_rec.accrual_conversion_rate) THEN

1121: ( p_Line_Adj_rec.accrual_conversion_rate <>
1122: p_old_Line_Adj_rec.accrual_conversion_rate OR
1123: p_old_Line_Adj_rec.accrual_conversion_rate IS NULL )
1124: THEN
1125: IF NOT OE_Validate_adj.accrual_conversion_rate(p_Line_Adj_rec.accrual_conversion_rate) THEN
1126: oe_debug_pub.add(' Erro accrual_conversion');
1127: x_return_status := FND_API.G_RET_STS_ERROR;
1128: END IF;
1129: END IF;

Line 1136: IF NOT OE_Validate_adj.pricing_group_sequence(p_Line_Adj_rec.pricing_group_sequence) THEN

1132: ( p_Line_Adj_rec.pricing_group_sequence <>
1133: p_old_Line_Adj_rec.pricing_group_sequence OR
1134: p_old_Line_Adj_rec.pricing_group_sequence IS NULL )
1135: THEN
1136: IF NOT OE_Validate_adj.pricing_group_sequence(p_Line_Adj_rec.pricing_group_sequence) THEN
1137: oe_debug_pub.add(' Error pricing_group_sequence');
1138: x_return_status := FND_API.G_RET_STS_ERROR;
1139: END IF;
1140: END IF;

Line 1147: IF NOT OE_Validate_adj.modifier_level_code(p_Line_Adj_rec.modifier_level_code) THEN

1143: ( p_Line_Adj_rec.modifier_level_code <>
1144: p_old_Line_Adj_rec.modifier_level_code OR
1145: p_old_Line_Adj_rec.modifier_level_code IS NULL )
1146: THEN
1147: IF NOT OE_Validate_adj.modifier_level_code(p_Line_Adj_rec.modifier_level_code) THEN
1148: oe_debug_pub.add(' Error modifier_level_code');
1149: x_return_status := FND_API.G_RET_STS_ERROR;
1150: END IF;
1151: END IF;

Line 1158: IF NOT OE_Validate_adj.price_break_type_code(p_Line_Adj_rec.price_break_type_code) THEN

1154: ( p_Line_Adj_rec.price_break_type_code <>
1155: p_old_Line_Adj_rec.price_break_type_code OR
1156: p_old_Line_Adj_rec.price_break_type_code IS NULL )
1157: THEN
1158: IF NOT OE_Validate_adj.price_break_type_code(p_Line_Adj_rec.price_break_type_code) THEN
1159: oe_debug_pub.add(' Erro price break type code');
1160: x_return_status := FND_API.G_RET_STS_ERROR;
1161: END IF;
1162: END IF;

Line 1169: IF NOT OE_Validate_adj.substitution_attribute(p_Line_Adj_rec.substitution_attribute) THEN

1165: ( p_Line_Adj_rec.substitution_attribute <>
1166: p_old_Line_Adj_rec.substitution_attribute OR
1167: p_old_Line_Adj_rec.substitution_attribute IS NULL )
1168: THEN
1169: IF NOT OE_Validate_adj.substitution_attribute(p_Line_Adj_rec.substitution_attribute) THEN
1170: x_return_status := FND_API.G_RET_STS_ERROR;
1171: END IF;
1172: END IF;
1173:

Line 1179: IF NOT OE_Validate_adj.proration_type_code(p_Line_Adj_rec.proration_type_code) THEN

1175: ( p_Line_Adj_rec.proration_type_code <>
1176: p_old_Line_Adj_rec.proration_type_code OR
1177: p_old_Line_Adj_rec.proration_type_code IS NULL )
1178: THEN
1179: IF NOT OE_Validate_adj.proration_type_code(p_Line_Adj_rec.proration_type_code) THEN
1180: x_return_status := FND_API.G_RET_STS_ERROR;
1181: END IF;
1182: END IF;
1183:

Line 1189: IF NOT OE_Validate.credit_or_charge_flag(p_Line_Adj_rec.credit_or_charge_flag) THEN

1185: ( p_Line_Adj_rec.credit_or_charge_flag <>
1186: p_old_Line_Adj_rec.credit_or_charge_flag OR
1187: p_old_Line_Adj_rec.credit_or_charge_flag IS NULL )
1188: THEN
1189: IF NOT OE_Validate.credit_or_charge_flag(p_Line_Adj_rec.credit_or_charge_flag) THEN
1190: x_return_status := FND_API.G_RET_STS_ERROR;
1191: END IF;
1192: END IF;
1193:

Line 1199: IF NOT OE_Validate.cost_id(p_Line_Adj_rec.cost_id) THEN

1195: ( p_Line_Adj_rec.cost_id <>
1196: p_old_Line_Adj_rec.cost_id OR
1197: p_old_Line_Adj_rec.cost_id IS NULL )
1198: THEN
1199: IF NOT OE_Validate.cost_id(p_Line_Adj_rec.cost_id) THEN
1200: x_return_status := FND_API.G_RET_STS_ERROR;
1201: END IF;
1202: END IF;
1203:

Line 1209: IF NOT OE_Validate.charge_type_code(p_Line_Adj_rec.charge_type_code) THEN

1205: ( p_Line_Adj_rec.charge_type_code <>
1206: p_old_Line_Adj_rec.charge_type_code OR
1207: p_old_Line_Adj_rec.charge_type_code IS NULL )
1208: THEN
1209: IF NOT OE_Validate.charge_type_code(p_Line_Adj_rec.charge_type_code) THEN
1210: oe_debug_pub.add(' Error charge_type_Code');
1211: x_return_status := FND_API.G_RET_STS_ERROR;
1212: END IF;
1213: END IF;

Line 1220: IF NOT OE_Validate.charge_subtype_code(p_Line_Adj_rec.charge_subtype_code) THEN

1216: ( p_Line_Adj_rec.charge_subtype_code <>
1217: p_old_Line_Adj_rec.charge_subtype_code OR
1218: p_old_Line_Adj_rec.charge_subtype_code IS NULL )
1219: THEN
1220: IF NOT OE_Validate.charge_subtype_code(p_Line_Adj_rec.charge_subtype_code) THEN
1221: x_return_status := FND_API.G_RET_STS_ERROR;
1222: END IF;
1223: END IF;
1224:

Line 1230: IF NOT OE_Validate.estimated(p_Line_Adj_rec.estimated_flag) THEN

1226: ( p_Line_Adj_rec.estimated_flag <>
1227: p_old_Line_Adj_rec.estimated_flag OR
1228: p_old_Line_Adj_rec.estimated_flag IS NULL )
1229: THEN
1230: IF NOT OE_Validate.estimated(p_Line_Adj_rec.estimated_flag) THEN
1231: x_return_status := FND_API.G_RET_STS_ERROR;
1232: END IF;
1233: END IF;
1234:

Line 1241: IF NOT OE_Validate.tax_rate_id(p_line_adj_rec.tax_rate_id) THEN

1237: ( p_line_adj_rec.tax_rate_id <>
1238: p_old_line_adj_rec.tax_rate_id OR
1239: p_old_line_adj_rec.tax_rate_id IS NULL )
1240: THEN
1241: IF NOT OE_Validate.tax_rate_id(p_line_adj_rec.tax_rate_id) THEN
1242: x_return_status := FND_API.G_RET_STS_ERROR;
1243: END IF;
1244: END IF;
1245: -- end eBTax changes

Line 1253: IF NOT OE_Validate.invoiced(p_Line_Adj_rec.invoiced_flag) THEN

1249: ( p_Line_Adj_rec.invoiced_flag <>
1250: p_old_Line_Adj_rec.invoiced_flag OR
1251: p_old_Line_Adj_rec.invoiced_flag IS NULL )
1252: THEN
1253: IF NOT OE_Validate.invoiced(p_Line_Adj_rec.invoiced_flag) THEN
1254: oe_debug_pub.add(' Error invoiced flag');
1255: x_return_status := FND_API.G_RET_STS_ERROR;
1256: END IF;
1257: END IF;

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

1255: x_return_status := FND_API.G_RET_STS_ERROR;
1256: END IF;
1257: END IF;
1258: if OE_GLOBALS.g_validate_desc_flex ='Y' then --bug4343612
1259: oe_debug_pub.add('Validation of desc flex is set to Y in OE_Validate_Line_Adj.attributes ',1);
1260: IF (p_Line_Adj_rec.context IS NOT NULL AND
1261: ( p_Line_Adj_rec.context <>
1262: p_old_Line_Adj_rec.context OR
1263: p_old_Line_Adj_rec.context IS NULL ))

Line 1327: IF NOT OE_VALIDATE_adj.Price_Adj_Desc_Flex

1323: p_old_Line_Adj_rec.attribute15 IS NULL ))
1324: THEN
1325:
1326: oe_debug_pub.add('Before calling Line Adjustment Price_Adj_Desc_Flex');
1327: IF NOT OE_VALIDATE_adj.Price_Adj_Desc_Flex
1328: (p_context => p_Line_Adj_rec.context
1329: ,p_attribute1 => p_Line_Adj_rec.attribute1
1330: ,p_attribute2 => p_Line_Adj_rec.attribute2
1331: ,p_attribute3 => p_Line_Adj_rec.attribute3

Line 1355: oe_debug_pub.add('Leaving OE_VALIDATE_LINE_ADJ.ATTRIBUTES without errors');

1351:
1352:
1353:
1354: END IF;
1355: oe_debug_pub.add('Leaving OE_VALIDATE_LINE_ADJ.ATTRIBUTES without errors');
1356: -- Done validating attributes
1357: end if ; /* if OE_GLOBALS.g_validate_desc_flex ='Y' then bug4343612 */
1358: EXCEPTION
1359:

Line 1424: END OE_Validate_Line_Adj;

1420: END IF;
1421:
1422: END Entity_Delete;
1423:
1424: END OE_Validate_Line_Adj;