DBA Data[Home] [Help]

APPS.OE_HEADER_UTIL dependencies on OE_HEADER_UTIL

Line 1: PACKAGE BODY OE_Header_Util AS

1: PACKAGE BODY OE_Header_Util AS
2: /* $Header: OEXUHDRB.pls 120.36.12010000.11 2008/12/26 07:34:57 vbkapoor ship $ */
3:
4: -- Global constant holding the package name
5:

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

2: /* $Header: OEXUHDRB.pls 120.36.12010000.11 2008/12/26 07:34:57 vbkapoor ship $ */
3:
4: -- Global constant holding the package name
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_Header_Util';
7:
8: -- LOCAL Procedures
9:
10: -- Added 09-DEC-2002

Line 761: oe_debug_pub.add('Entering OE_HEADER_UTIL.Clear_Dependent',1);

757: -- end
758:
759: BEGIN
760:
761: oe_debug_pub.add('Entering OE_HEADER_UTIL.Clear_Dependent',1);
762: IF p_src_attr_tbl.COUNT <> 0 THEN
763:
764: OE_Dependencies.Mark_Dependent
765: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,

Line 770: IF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_ACCOUNTING_RULE THEN

766: p_source_attr_tbl => p_src_attr_tbl,
767: p_dep_attr_tbl => l_dep_attr_tbl);
768:
769: FOR I IN 1..l_dep_attr_tbl.COUNT LOOP
770: IF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_ACCOUNTING_RULE THEN
771: ACCOUNTING_RULE;
772: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_ACCOUNTING_RULE_DURATION THEN
773: ACCOUNTING_RULE_DURATION;
774: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_AGREEMENT THEN

Line 772: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_ACCOUNTING_RULE_DURATION THEN

768:
769: FOR I IN 1..l_dep_attr_tbl.COUNT LOOP
770: IF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_ACCOUNTING_RULE THEN
771: ACCOUNTING_RULE;
772: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_ACCOUNTING_RULE_DURATION THEN
773: ACCOUNTING_RULE_DURATION;
774: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_AGREEMENT THEN
775: AGREEMENT;
776: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_CONVERSION_RATE THEN

Line 774: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_AGREEMENT THEN

770: IF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_ACCOUNTING_RULE THEN
771: ACCOUNTING_RULE;
772: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_ACCOUNTING_RULE_DURATION THEN
773: ACCOUNTING_RULE_DURATION;
774: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_AGREEMENT THEN
775: AGREEMENT;
776: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_CONVERSION_RATE THEN
777: CONVERSION_RATE;
778: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_CONVERSION_RATE_DATE THEN

Line 776: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_CONVERSION_RATE THEN

772: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_ACCOUNTING_RULE_DURATION THEN
773: ACCOUNTING_RULE_DURATION;
774: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_AGREEMENT THEN
775: AGREEMENT;
776: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_CONVERSION_RATE THEN
777: CONVERSION_RATE;
778: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_CONVERSION_RATE_DATE THEN
779: CONVERSION_RATE_DATE;
780: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_CONVERSION_TYPE THEN

Line 778: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_CONVERSION_RATE_DATE THEN

774: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_AGREEMENT THEN
775: AGREEMENT;
776: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_CONVERSION_RATE THEN
777: CONVERSION_RATE;
778: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_CONVERSION_RATE_DATE THEN
779: CONVERSION_RATE_DATE;
780: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_CONVERSION_TYPE THEN
781: CONVERSION_TYPE;
782: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_CREDIT_CARD_EXPIRATION_DATE THEN

Line 780: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_CONVERSION_TYPE THEN

776: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_CONVERSION_RATE THEN
777: CONVERSION_RATE;
778: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_CONVERSION_RATE_DATE THEN
779: CONVERSION_RATE_DATE;
780: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_CONVERSION_TYPE THEN
781: CONVERSION_TYPE;
782: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_CREDIT_CARD_EXPIRATION_DATE THEN
783: CREDIT_CARD_EXPIRATION_DATE;
784: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_CREDIT_CARD_HOLDER_NAME THEN

Line 782: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_CREDIT_CARD_EXPIRATION_DATE THEN

778: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_CONVERSION_RATE_DATE THEN
779: CONVERSION_RATE_DATE;
780: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_CONVERSION_TYPE THEN
781: CONVERSION_TYPE;
782: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_CREDIT_CARD_EXPIRATION_DATE THEN
783: CREDIT_CARD_EXPIRATION_DATE;
784: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_CREDIT_CARD_HOLDER_NAME THEN
785: CREDIT_CARD_HOLDER_NAME;
786: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_CREDIT_CARD_NUMBER THEN

Line 784: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_CREDIT_CARD_HOLDER_NAME THEN

780: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_CONVERSION_TYPE THEN
781: CONVERSION_TYPE;
782: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_CREDIT_CARD_EXPIRATION_DATE THEN
783: CREDIT_CARD_EXPIRATION_DATE;
784: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_CREDIT_CARD_HOLDER_NAME THEN
785: CREDIT_CARD_HOLDER_NAME;
786: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_CREDIT_CARD_NUMBER THEN
787: CREDIT_CARD_NUMBER;
788: /* Fix Bug # 2297053: Added to clear Credit Card Type */

Line 786: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_CREDIT_CARD_NUMBER THEN

782: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_CREDIT_CARD_EXPIRATION_DATE THEN
783: CREDIT_CARD_EXPIRATION_DATE;
784: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_CREDIT_CARD_HOLDER_NAME THEN
785: CREDIT_CARD_HOLDER_NAME;
786: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_CREDIT_CARD_NUMBER THEN
787: CREDIT_CARD_NUMBER;
788: /* Fix Bug # 2297053: Added to clear Credit Card Type */
789: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_CREDIT_CARD THEN
790: CREDIT_CARD;

Line 789: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_CREDIT_CARD THEN

785: CREDIT_CARD_HOLDER_NAME;
786: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_CREDIT_CARD_NUMBER THEN
787: CREDIT_CARD_NUMBER;
788: /* Fix Bug # 2297053: Added to clear Credit Card Type */
789: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_CREDIT_CARD THEN
790: CREDIT_CARD;
791: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_CHECK_NUMBER THEN --For bug 2692314
792: CHECK_NUMBER;
793: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_CUST_PO_NUMBER THEN

Line 791: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_CHECK_NUMBER THEN --For bug 2692314

787: CREDIT_CARD_NUMBER;
788: /* Fix Bug # 2297053: Added to clear Credit Card Type */
789: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_CREDIT_CARD THEN
790: CREDIT_CARD;
791: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_CHECK_NUMBER THEN --For bug 2692314
792: CHECK_NUMBER;
793: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_CUST_PO_NUMBER THEN
794: CUST_PO_NUMBER;
795: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_CUSTOMER_PREFERENCE_SET THEN

Line 793: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_CUST_PO_NUMBER THEN

789: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_CREDIT_CARD THEN
790: CREDIT_CARD;
791: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_CHECK_NUMBER THEN --For bug 2692314
792: CHECK_NUMBER;
793: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_CUST_PO_NUMBER THEN
794: CUST_PO_NUMBER;
795: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_CUSTOMER_PREFERENCE_SET THEN
796: CUSTOMER_PREFERENCE_SET_CODE;
797: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_DEFAULT_FULFILLMENT_SET THEN

Line 795: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_CUSTOMER_PREFERENCE_SET THEN

791: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_CHECK_NUMBER THEN --For bug 2692314
792: CHECK_NUMBER;
793: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_CUST_PO_NUMBER THEN
794: CUST_PO_NUMBER;
795: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_CUSTOMER_PREFERENCE_SET THEN
796: CUSTOMER_PREFERENCE_SET_CODE;
797: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_DEFAULT_FULFILLMENT_SET THEN
798: DEFAULT_FULFILLMENT_SET;
799: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_DELIVER_TO_CONTACT THEN

Line 797: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_DEFAULT_FULFILLMENT_SET THEN

793: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_CUST_PO_NUMBER THEN
794: CUST_PO_NUMBER;
795: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_CUSTOMER_PREFERENCE_SET THEN
796: CUSTOMER_PREFERENCE_SET_CODE;
797: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_DEFAULT_FULFILLMENT_SET THEN
798: DEFAULT_FULFILLMENT_SET;
799: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_DELIVER_TO_CONTACT THEN
800: DELIVER_TO_CONTACT;
801: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_DELIVER_TO_ORG THEN

Line 799: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_DELIVER_TO_CONTACT THEN

795: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_CUSTOMER_PREFERENCE_SET THEN
796: CUSTOMER_PREFERENCE_SET_CODE;
797: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_DEFAULT_FULFILLMENT_SET THEN
798: DEFAULT_FULFILLMENT_SET;
799: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_DELIVER_TO_CONTACT THEN
800: DELIVER_TO_CONTACT;
801: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_DELIVER_TO_ORG THEN
802: DELIVER_TO_ORG;
803: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_DEMAND_CLASS THEN

Line 801: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_DELIVER_TO_ORG THEN

797: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_DEFAULT_FULFILLMENT_SET THEN
798: DEFAULT_FULFILLMENT_SET;
799: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_DELIVER_TO_CONTACT THEN
800: DELIVER_TO_CONTACT;
801: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_DELIVER_TO_ORG THEN
802: DELIVER_TO_ORG;
803: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_DEMAND_CLASS THEN
804: DEMAND_CLASS;
805: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_FOB_POINT THEN

Line 803: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_DEMAND_CLASS THEN

799: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_DELIVER_TO_CONTACT THEN
800: DELIVER_TO_CONTACT;
801: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_DELIVER_TO_ORG THEN
802: DELIVER_TO_ORG;
803: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_DEMAND_CLASS THEN
804: DEMAND_CLASS;
805: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_FOB_POINT THEN
806: FOB_POINT;
807: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_FREIGHT_TERMS THEN

Line 805: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_FOB_POINT THEN

801: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_DELIVER_TO_ORG THEN
802: DELIVER_TO_ORG;
803: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_DEMAND_CLASS THEN
804: DEMAND_CLASS;
805: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_FOB_POINT THEN
806: FOB_POINT;
807: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_FREIGHT_TERMS THEN
808: FREIGHT_TERMS;
809: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_INVOICE_TO_CONTACT THEN

Line 807: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_FREIGHT_TERMS THEN

803: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_DEMAND_CLASS THEN
804: DEMAND_CLASS;
805: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_FOB_POINT THEN
806: FOB_POINT;
807: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_FREIGHT_TERMS THEN
808: FREIGHT_TERMS;
809: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_INVOICE_TO_CONTACT THEN
810: INVOICE_TO_CONTACT;
811: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_INVOICE_TO_ORG THEN

Line 809: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_INVOICE_TO_CONTACT THEN

805: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_FOB_POINT THEN
806: FOB_POINT;
807: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_FREIGHT_TERMS THEN
808: FREIGHT_TERMS;
809: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_INVOICE_TO_CONTACT THEN
810: INVOICE_TO_CONTACT;
811: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_INVOICE_TO_ORG THEN
812: INVOICE_TO_ORG;
813: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_INVOICING_RULE THEN

Line 811: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_INVOICE_TO_ORG THEN

807: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_FREIGHT_TERMS THEN
808: FREIGHT_TERMS;
809: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_INVOICE_TO_CONTACT THEN
810: INVOICE_TO_CONTACT;
811: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_INVOICE_TO_ORG THEN
812: INVOICE_TO_ORG;
813: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_INVOICING_RULE THEN
814: INVOICING_RULE;
815: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_ORDER_CATEGORY THEN

Line 813: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_INVOICING_RULE THEN

809: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_INVOICE_TO_CONTACT THEN
810: INVOICE_TO_CONTACT;
811: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_INVOICE_TO_ORG THEN
812: INVOICE_TO_ORG;
813: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_INVOICING_RULE THEN
814: INVOICING_RULE;
815: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_ORDER_CATEGORY THEN
816: ORDER_CATEGORY;
817: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_ORDER_DATE_TYPE_CODE THEN

Line 815: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_ORDER_CATEGORY THEN

811: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_INVOICE_TO_ORG THEN
812: INVOICE_TO_ORG;
813: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_INVOICING_RULE THEN
814: INVOICING_RULE;
815: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_ORDER_CATEGORY THEN
816: ORDER_CATEGORY;
817: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_ORDER_DATE_TYPE_CODE THEN
818: ORDER_DATE_TYPE;
819: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_ORDER_TYPE THEN

Line 817: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_ORDER_DATE_TYPE_CODE THEN

813: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_INVOICING_RULE THEN
814: INVOICING_RULE;
815: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_ORDER_CATEGORY THEN
816: ORDER_CATEGORY;
817: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_ORDER_DATE_TYPE_CODE THEN
818: ORDER_DATE_TYPE;
819: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_ORDER_TYPE THEN
820: ORDER_TYPE;
821: -- Added the call to the method to clear the payment amount bug 4360599

Line 819: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_ORDER_TYPE THEN

815: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_ORDER_CATEGORY THEN
816: ORDER_CATEGORY;
817: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_ORDER_DATE_TYPE_CODE THEN
818: ORDER_DATE_TYPE;
819: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_ORDER_TYPE THEN
820: ORDER_TYPE;
821: -- Added the call to the method to clear the payment amount bug 4360599
822: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_PAYMENT_AMOUNT THEN
823: PAYMENT_AMOUNT;

Line 822: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_PAYMENT_AMOUNT THEN

818: ORDER_DATE_TYPE;
819: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_ORDER_TYPE THEN
820: ORDER_TYPE;
821: -- Added the call to the method to clear the payment amount bug 4360599
822: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_PAYMENT_AMOUNT THEN
823: PAYMENT_AMOUNT;
824: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_PAYMENT_TERM THEN
825: PAYMENT_TERM;
826: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_PRICE_LIST THEN

Line 824: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_PAYMENT_TERM THEN

820: ORDER_TYPE;
821: -- Added the call to the method to clear the payment amount bug 4360599
822: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_PAYMENT_AMOUNT THEN
823: PAYMENT_AMOUNT;
824: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_PAYMENT_TERM THEN
825: PAYMENT_TERM;
826: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_PRICE_LIST THEN
827: PRICE_LIST;
828: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_PRICE_REQUEST_CODE THEN -- PROMOTIONS SEP/01

Line 826: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_PRICE_LIST THEN

822: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_PAYMENT_AMOUNT THEN
823: PAYMENT_AMOUNT;
824: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_PAYMENT_TERM THEN
825: PAYMENT_TERM;
826: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_PRICE_LIST THEN
827: PRICE_LIST;
828: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_PRICE_REQUEST_CODE THEN -- PROMOTIONS SEP/01
829: PRICE_REQUEST_CODE;
830: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_REQUEST_DATE THEN

Line 828: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_PRICE_REQUEST_CODE THEN -- PROMOTIONS SEP/01

824: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_PAYMENT_TERM THEN
825: PAYMENT_TERM;
826: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_PRICE_LIST THEN
827: PRICE_LIST;
828: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_PRICE_REQUEST_CODE THEN -- PROMOTIONS SEP/01
829: PRICE_REQUEST_CODE;
830: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_REQUEST_DATE THEN
831: REQUEST_DATE;
832: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SALESREP THEN

Line 830: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_REQUEST_DATE THEN

826: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_PRICE_LIST THEN
827: PRICE_LIST;
828: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_PRICE_REQUEST_CODE THEN -- PROMOTIONS SEP/01
829: PRICE_REQUEST_CODE;
830: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_REQUEST_DATE THEN
831: REQUEST_DATE;
832: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SALESREP THEN
833: SALESREP;
834: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SALES_CHANNEL THEN

Line 832: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SALESREP THEN

828: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_PRICE_REQUEST_CODE THEN -- PROMOTIONS SEP/01
829: PRICE_REQUEST_CODE;
830: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_REQUEST_DATE THEN
831: REQUEST_DATE;
832: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SALESREP THEN
833: SALESREP;
834: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SALES_CHANNEL THEN
835: SALES_CHANNEL;
836: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SHIPMENT_PRIORITY THEN

Line 834: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SALES_CHANNEL THEN

830: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_REQUEST_DATE THEN
831: REQUEST_DATE;
832: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SALESREP THEN
833: SALESREP;
834: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SALES_CHANNEL THEN
835: SALES_CHANNEL;
836: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SHIPMENT_PRIORITY THEN
837: SHIPMENT_PRIORITY;
838: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SHIPPING_METHOD THEN

Line 836: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SHIPMENT_PRIORITY THEN

832: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SALESREP THEN
833: SALESREP;
834: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SALES_CHANNEL THEN
835: SALES_CHANNEL;
836: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SHIPMENT_PRIORITY THEN
837: SHIPMENT_PRIORITY;
838: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SHIPPING_METHOD THEN
839: SHIPPING_METHOD;
840: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SHIP_FROM_ORG THEN

Line 838: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SHIPPING_METHOD THEN

834: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SALES_CHANNEL THEN
835: SALES_CHANNEL;
836: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SHIPMENT_PRIORITY THEN
837: SHIPMENT_PRIORITY;
838: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SHIPPING_METHOD THEN
839: SHIPPING_METHOD;
840: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SHIP_FROM_ORG THEN
841: SHIP_FROM_ORG;
842: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SHIP_TOLERANCE_ABOVE THEN

Line 840: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SHIP_FROM_ORG THEN

836: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SHIPMENT_PRIORITY THEN
837: SHIPMENT_PRIORITY;
838: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SHIPPING_METHOD THEN
839: SHIPPING_METHOD;
840: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SHIP_FROM_ORG THEN
841: SHIP_FROM_ORG;
842: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SHIP_TOLERANCE_ABOVE THEN
843: SHIP_TOLERANCE_ABOVE;
844: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SHIP_TOLERANCE_BELOW THEN

Line 842: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SHIP_TOLERANCE_ABOVE THEN

838: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SHIPPING_METHOD THEN
839: SHIPPING_METHOD;
840: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SHIP_FROM_ORG THEN
841: SHIP_FROM_ORG;
842: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SHIP_TOLERANCE_ABOVE THEN
843: SHIP_TOLERANCE_ABOVE;
844: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SHIP_TOLERANCE_BELOW THEN
845: SHIP_TOLERANCE_BELOW;
846: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SHIP_TO_CONTACT THEN

Line 844: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SHIP_TOLERANCE_BELOW THEN

840: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SHIP_FROM_ORG THEN
841: SHIP_FROM_ORG;
842: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SHIP_TOLERANCE_ABOVE THEN
843: SHIP_TOLERANCE_ABOVE;
844: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SHIP_TOLERANCE_BELOW THEN
845: SHIP_TOLERANCE_BELOW;
846: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SHIP_TO_CONTACT THEN
847: SHIP_TO_CONTACT;
848: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SHIP_TO_ORG THEN

Line 846: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SHIP_TO_CONTACT THEN

842: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SHIP_TOLERANCE_ABOVE THEN
843: SHIP_TOLERANCE_ABOVE;
844: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SHIP_TOLERANCE_BELOW THEN
845: SHIP_TOLERANCE_BELOW;
846: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SHIP_TO_CONTACT THEN
847: SHIP_TO_CONTACT;
848: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SHIP_TO_ORG THEN
849: SHIP_TO_ORG;
850: -- Fix bug 1753101: sold to contact dependency code added

Line 848: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SHIP_TO_ORG THEN

844: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SHIP_TOLERANCE_BELOW THEN
845: SHIP_TOLERANCE_BELOW;
846: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SHIP_TO_CONTACT THEN
847: SHIP_TO_CONTACT;
848: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SHIP_TO_ORG THEN
849: SHIP_TO_ORG;
850: -- Fix bug 1753101: sold to contact dependency code added
851: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SOLD_TO_CONTACT THEN
852: SOLD_TO_CONTACT;

Line 851: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SOLD_TO_CONTACT THEN

847: SHIP_TO_CONTACT;
848: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SHIP_TO_ORG THEN
849: SHIP_TO_ORG;
850: -- Fix bug 1753101: sold to contact dependency code added
851: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SOLD_TO_CONTACT THEN
852: SOLD_TO_CONTACT;
853: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SOLD_TO_ORG THEN
854: SOLD_TO_ORG;
855: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SOLD_TO_PHONE THEN

Line 853: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SOLD_TO_ORG THEN

849: SHIP_TO_ORG;
850: -- Fix bug 1753101: sold to contact dependency code added
851: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SOLD_TO_CONTACT THEN
852: SOLD_TO_CONTACT;
853: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SOLD_TO_ORG THEN
854: SOLD_TO_ORG;
855: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SOLD_TO_PHONE THEN
856: SOLD_TO_PHONE;
857: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_TAX_EXEMPT_NUMBER THEN

Line 855: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SOLD_TO_PHONE THEN

851: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SOLD_TO_CONTACT THEN
852: SOLD_TO_CONTACT;
853: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SOLD_TO_ORG THEN
854: SOLD_TO_ORG;
855: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SOLD_TO_PHONE THEN
856: SOLD_TO_PHONE;
857: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_TAX_EXEMPT_NUMBER THEN
858: TAX_EXEMPT_NUMBER;
859: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_TAX_EXEMPT_REASON THEN

Line 857: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_TAX_EXEMPT_NUMBER THEN

853: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SOLD_TO_ORG THEN
854: SOLD_TO_ORG;
855: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SOLD_TO_PHONE THEN
856: SOLD_TO_PHONE;
857: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_TAX_EXEMPT_NUMBER THEN
858: TAX_EXEMPT_NUMBER;
859: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_TAX_EXEMPT_REASON THEN
860: TAX_EXEMPT_REASON;
861: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_TRANSACTIONAL_CURR THEN

Line 859: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_TAX_EXEMPT_REASON THEN

855: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SOLD_TO_PHONE THEN
856: SOLD_TO_PHONE;
857: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_TAX_EXEMPT_NUMBER THEN
858: TAX_EXEMPT_NUMBER;
859: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_TAX_EXEMPT_REASON THEN
860: TAX_EXEMPT_REASON;
861: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_TRANSACTIONAL_CURR THEN
862: TRANSACTIONAL_CURR;
863: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_LATEST_SCHEDULE_LIMIT THEN

Line 861: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_TRANSACTIONAL_CURR THEN

857: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_TAX_EXEMPT_NUMBER THEN
858: TAX_EXEMPT_NUMBER;
859: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_TAX_EXEMPT_REASON THEN
860: TAX_EXEMPT_REASON;
861: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_TRANSACTIONAL_CURR THEN
862: TRANSACTIONAL_CURR;
863: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_LATEST_SCHEDULE_LIMIT THEN
864: LATEST_SCHEDULE_LIMIT;
865: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_PACKING_INSTRUCTIONS THEN

Line 863: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_LATEST_SCHEDULE_LIMIT THEN

859: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_TAX_EXEMPT_REASON THEN
860: TAX_EXEMPT_REASON;
861: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_TRANSACTIONAL_CURR THEN
862: TRANSACTIONAL_CURR;
863: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_LATEST_SCHEDULE_LIMIT THEN
864: LATEST_SCHEDULE_LIMIT;
865: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_PACKING_INSTRUCTIONS THEN
866: PACKING_INSTRUCTIONS; -- added for 2665264
867: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SHIPPING_INSTRUCTIONS THEN

Line 865: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_PACKING_INSTRUCTIONS THEN

861: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_TRANSACTIONAL_CURR THEN
862: TRANSACTIONAL_CURR;
863: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_LATEST_SCHEDULE_LIMIT THEN
864: LATEST_SCHEDULE_LIMIT;
865: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_PACKING_INSTRUCTIONS THEN
866: PACKING_INSTRUCTIONS; -- added for 2665264
867: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SHIPPING_INSTRUCTIONS THEN
868: SHIPPING_INSTRUCTIONS; -- added for 2766005
869:

Line 867: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SHIPPING_INSTRUCTIONS THEN

863: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_LATEST_SCHEDULE_LIMIT THEN
864: LATEST_SCHEDULE_LIMIT;
865: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_PACKING_INSTRUCTIONS THEN
866: PACKING_INSTRUCTIONS; -- added for 2665264
867: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SHIPPING_INSTRUCTIONS THEN
868: SHIPPING_INSTRUCTIONS; -- added for 2766005
869:
870: -- QUOTING changes
871: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_TRANSACTION_PHASE THEN

Line 871: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_TRANSACTION_PHASE THEN

867: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SHIPPING_INSTRUCTIONS THEN
868: SHIPPING_INSTRUCTIONS; -- added for 2766005
869:
870: -- QUOTING changes
871: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_TRANSACTION_PHASE THEN
872: IF OE_Code_Control.Code_Release_Level >= '110510' THEN
873: TRANSACTION_PHASE;
874: END IF;
875: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SOLD_TO_SITE_USE THEN

Line 875: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SOLD_TO_SITE_USE THEN

871: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_TRANSACTION_PHASE THEN
872: IF OE_Code_Control.Code_Release_Level >= '110510' THEN
873: TRANSACTION_PHASE;
874: END IF;
875: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SOLD_TO_SITE_USE THEN
876: IF OE_Code_Control.Code_Release_Level >= '110510' THEN
877: SOLD_TO_SITE_USE;
878: END IF;
879: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_QUOTE_DATE THEN

Line 879: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_QUOTE_DATE THEN

875: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SOLD_TO_SITE_USE THEN
876: IF OE_Code_Control.Code_Release_Level >= '110510' THEN
877: SOLD_TO_SITE_USE;
878: END IF;
879: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_QUOTE_DATE THEN
880: IF OE_Code_Control.Code_Release_Level >= '110510' THEN
881: QUOTE_DATE;
882: END IF;
883: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_ORDERED_DATE THEN

Line 883: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_ORDERED_DATE THEN

879: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_QUOTE_DATE THEN
880: IF OE_Code_Control.Code_Release_Level >= '110510' THEN
881: QUOTE_DATE;
882: END IF;
883: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_ORDERED_DATE THEN
884: IF OE_Code_Control.Code_Release_Level >= '110510' THEN
885: ORDERED_DATE;
886: END IF;
887: -- QUOTING changes END

Line 889: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_END_CUSTOMER THEN

885: ORDERED_DATE;
886: END IF;
887: -- QUOTING changes END
888: -- Distributed orders @
889: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_END_CUSTOMER THEN
890: END_CUSTOMER;
891: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_END_CUSTOMER_CONTACT THEN
892: END_CUSTOMER_CONTACT;
893: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_END_CUSTOMER_SITE_USE THEN

Line 891: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_END_CUSTOMER_CONTACT THEN

887: -- QUOTING changes END
888: -- Distributed orders @
889: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_END_CUSTOMER THEN
890: END_CUSTOMER;
891: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_END_CUSTOMER_CONTACT THEN
892: END_CUSTOMER_CONTACT;
893: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_END_CUSTOMER_SITE_USE THEN
894: END_CUSTOMER_SITE_USE;
895: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_ORDER_FIRMED_DATE THEN --Key Transaction Dates

Line 893: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_END_CUSTOMER_SITE_USE THEN

889: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_END_CUSTOMER THEN
890: END_CUSTOMER;
891: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_END_CUSTOMER_CONTACT THEN
892: END_CUSTOMER_CONTACT;
893: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_END_CUSTOMER_SITE_USE THEN
894: END_CUSTOMER_SITE_USE;
895: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_ORDER_FIRMED_DATE THEN --Key Transaction Dates
896: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110509' THEN
897: order_firmed_date;

Line 895: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_ORDER_FIRMED_DATE THEN --Key Transaction Dates

891: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_END_CUSTOMER_CONTACT THEN
892: END_CUSTOMER_CONTACT;
893: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_END_CUSTOMER_SITE_USE THEN
894: END_CUSTOMER_SITE_USE;
895: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_ORDER_FIRMED_DATE THEN --Key Transaction Dates
896: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110509' THEN
897: order_firmed_date;
898: END IF;
899: END IF;

Line 903: oe_debug_pub.add('Exiting OE_HEADER_UTIL.Clear_Dependent',1);

899: END IF;
900: END LOOP;
901: END IF;
902:
903: oe_debug_pub.add('Exiting OE_HEADER_UTIL.Clear_Dependent',1);
904:
905: EXCEPTION
906:
907: WHEN FND_API.G_EXC_ERROR THEN

Line 1519: oe_debug_pub.add('Entering OE_HEADER_UTIL.CLEAR_DEPENDENT_ATTR', 1);

1515: l_index NUMBER :=0;
1516: l_src_attr_tbl OE_GLOBALS.NUMBER_Tbl_Type;
1517: BEGIN
1518:
1519: oe_debug_pub.add('Entering OE_HEADER_UTIL.CLEAR_DEPENDENT_ATTR', 1);
1520:
1521: IF p_attr_id <> FND_API.G_MISS_NUM THEN
1522:
1523: l_index := l_index + 1.0;

Line 1534: l_src_attr_tbl(l_index) := OE_HEADER_UTIL.G_AGREEMENT;

1530:
1531: IF NOT OE_GLOBALS.Equal(p_x_header_rec.agreement_id,p_old_header_rec.agreement_id)
1532: THEN
1533: l_index := l_index + 1.0;
1534: l_src_attr_tbl(l_index) := OE_HEADER_UTIL.G_AGREEMENT;
1535: END IF;
1536:
1537: IF NOT OE_GLOBALS.Equal(p_x_header_rec.deliver_to_org_id,p_old_header_rec.deliver_to_org_id)
1538: THEN

Line 1540: l_src_attr_tbl(l_index) := OE_HEADER_UTIL.G_DELIVER_TO_ORG;

1536:
1537: IF NOT OE_GLOBALS.Equal(p_x_header_rec.deliver_to_org_id,p_old_header_rec.deliver_to_org_id)
1538: THEN
1539: l_index := l_index + 1.0;
1540: l_src_attr_tbl(l_index) := OE_HEADER_UTIL.G_DELIVER_TO_ORG;
1541: END IF;
1542:
1543: IF NOT OE_GLOBALS.Equal(p_x_header_rec.invoice_to_contact_id,p_old_header_rec.invoice_to_contact_id)
1544: THEN

Line 1546: l_src_attr_tbl(l_index) := OE_HEADER_UTIL.G_INVOICE_TO_CONTACT;

1542:
1543: IF NOT OE_GLOBALS.Equal(p_x_header_rec.invoice_to_contact_id,p_old_header_rec.invoice_to_contact_id)
1544: THEN
1545: l_index := l_index + 1.0;
1546: l_src_attr_tbl(l_index) := OE_HEADER_UTIL.G_INVOICE_TO_CONTACT;
1547: END IF;
1548:
1549: IF NOT OE_GLOBALS.Equal(p_x_header_rec.invoice_to_org_id,p_old_header_rec.invoice_to_org_id)
1550: THEN

Line 1552: l_src_attr_tbl(l_index) := OE_HEADER_UTIL.G_INVOICE_TO_ORG;

1548:
1549: IF NOT OE_GLOBALS.Equal(p_x_header_rec.invoice_to_org_id,p_old_header_rec.invoice_to_org_id)
1550: THEN
1551: l_index := l_index + 1.0;
1552: l_src_attr_tbl(l_index) := OE_HEADER_UTIL.G_INVOICE_TO_ORG;
1553: END IF;
1554:
1555: IF NOT OE_GLOBALS.Equal(p_x_header_rec.ordered_date,p_old_header_rec.ordered_date)
1556: THEN

Line 1558: l_src_attr_tbl(l_index) := OE_HEADER_UTIL.G_ORDERED_DATE;

1554:
1555: IF NOT OE_GLOBALS.Equal(p_x_header_rec.ordered_date,p_old_header_rec.ordered_date)
1556: THEN
1557: l_index := l_index + 1.0;
1558: l_src_attr_tbl(l_index) := OE_HEADER_UTIL.G_ORDERED_DATE;
1559: END IF;
1560:
1561: IF NOT OE_GLOBALS.Equal(p_x_header_rec.order_type_id,p_old_header_rec.order_type_id)
1562: THEN

Line 1564: l_src_attr_tbl(l_index) := OE_HEADER_UTIL.G_ORDER_TYPE;

1560:
1561: IF NOT OE_GLOBALS.Equal(p_x_header_rec.order_type_id,p_old_header_rec.order_type_id)
1562: THEN
1563: l_index := l_index + 1.0;
1564: l_src_attr_tbl(l_index) := OE_HEADER_UTIL.G_ORDER_TYPE;
1565: END IF;
1566:
1567: IF NOT OE_GLOBALS.Equal(p_x_header_rec.payment_type_code,p_old_header_rec.payment_type_code)
1568: THEN

Line 1570: l_src_attr_tbl(l_index) := OE_HEADER_UTIL.G_PAYMENT_TYPE;

1566:
1567: IF NOT OE_GLOBALS.Equal(p_x_header_rec.payment_type_code,p_old_header_rec.payment_type_code)
1568: THEN
1569: l_index := l_index + 1.0;
1570: l_src_attr_tbl(l_index) := OE_HEADER_UTIL.G_PAYMENT_TYPE;
1571: END IF;
1572:
1573: /* Fix Bug # 2297053: Clear attributes dependent on Credit Card Number */
1574: IF NOT OE_GLOBALS.Is_Same_Credit_Card(p_old_header_rec.credit_card_number,p_x_header_rec.credit_card_number,

Line 1578: l_src_attr_tbl(l_index) := OE_HEADER_UTIL.G_CREDIT_CARD_NUMBER;

1574: IF NOT OE_GLOBALS.Is_Same_Credit_Card(p_old_header_rec.credit_card_number,p_x_header_rec.credit_card_number,
1575: p_old_instrument_id,p_x_instrument_id)
1576: THEN
1577: l_index := l_index + 1.0;
1578: l_src_attr_tbl(l_index) := OE_HEADER_UTIL.G_CREDIT_CARD_NUMBER;
1579: END IF;
1580:
1581: IF NOT OE_GLOBALS.Equal(p_x_header_rec.price_list_id,p_old_header_rec.price_list_id)
1582: THEN

Line 1584: l_src_attr_tbl(l_index) := OE_HEADER_UTIL.G_PRICE_LIST;

1580:
1581: IF NOT OE_GLOBALS.Equal(p_x_header_rec.price_list_id,p_old_header_rec.price_list_id)
1582: THEN
1583: l_index := l_index + 1.0;
1584: l_src_attr_tbl(l_index) := OE_HEADER_UTIL.G_PRICE_LIST;
1585: END IF;
1586:
1587: IF NOT OE_GLOBALS.Equal(p_x_header_rec.request_date,p_old_header_rec.request_date)
1588: THEN

Line 1590: l_src_attr_tbl(l_index) := OE_HEADER_UTIL.G_REQUEST_DATE;

1586:
1587: IF NOT OE_GLOBALS.Equal(p_x_header_rec.request_date,p_old_header_rec.request_date)
1588: THEN
1589: l_index := l_index + 1.0;
1590: l_src_attr_tbl(l_index) := OE_HEADER_UTIL.G_REQUEST_DATE;
1591: END IF;
1592:
1593: IF NOT OE_GLOBALS.Equal(p_x_header_rec.ship_from_org_id,p_old_header_rec.ship_from_org_id)
1594: THEN

Line 1596: l_src_attr_tbl(l_index) := OE_HEADER_UTIL.G_SHIP_FROM_ORG;

1592:
1593: IF NOT OE_GLOBALS.Equal(p_x_header_rec.ship_from_org_id,p_old_header_rec.ship_from_org_id)
1594: THEN
1595: l_index := l_index + 1.0;
1596: l_src_attr_tbl(l_index) := OE_HEADER_UTIL.G_SHIP_FROM_ORG;
1597: END IF;
1598:
1599: IF NOT OE_GLOBALS.Equal(p_x_header_rec.ship_to_contact_id,p_old_header_rec.ship_to_contact_id)
1600: THEN

Line 1602: l_src_attr_tbl(l_index) := OE_HEADER_UTIL.G_SHIP_TO_CONTACT;

1598:
1599: IF NOT OE_GLOBALS.Equal(p_x_header_rec.ship_to_contact_id,p_old_header_rec.ship_to_contact_id)
1600: THEN
1601: l_index := l_index + 1.0;
1602: l_src_attr_tbl(l_index) := OE_HEADER_UTIL.G_SHIP_TO_CONTACT;
1603: END IF;
1604:
1605: IF NOT OE_GLOBALS.Equal(p_x_header_rec.ship_to_org_id,p_old_header_rec.ship_to_org_id)
1606: THEN

Line 1608: l_src_attr_tbl(l_index) := OE_HEADER_UTIL.G_SHIP_TO_ORG;

1604:
1605: IF NOT OE_GLOBALS.Equal(p_x_header_rec.ship_to_org_id,p_old_header_rec.ship_to_org_id)
1606: THEN
1607: l_index := l_index + 1.0;
1608: l_src_attr_tbl(l_index) := OE_HEADER_UTIL.G_SHIP_TO_ORG;
1609: END IF;
1610:
1611: IF NOT OE_GLOBALS.Equal(p_x_header_rec.sold_to_org_id,p_old_header_rec.sold_to_org_id)
1612: THEN

Line 1614: l_src_attr_tbl(l_index) := OE_HEADER_UTIL.G_SOLD_TO_ORG;

1610:
1611: IF NOT OE_GLOBALS.Equal(p_x_header_rec.sold_to_org_id,p_old_header_rec.sold_to_org_id)
1612: THEN
1613: l_index := l_index + 1.0;
1614: l_src_attr_tbl(l_index) := OE_HEADER_UTIL.G_SOLD_TO_ORG;
1615: END IF;
1616:
1617: IF NOT OE_GLOBALS.Equal(p_x_header_rec.sold_to_phone_id,p_old_header_rec.sold_to_phone_id)
1618: THEN

Line 1620: l_src_attr_tbl(l_index) := OE_HEADER_UTIL.G_SOLD_TO_PHONE;

1616:
1617: IF NOT OE_GLOBALS.Equal(p_x_header_rec.sold_to_phone_id,p_old_header_rec.sold_to_phone_id)
1618: THEN
1619: l_index := l_index + 1.0;
1620: l_src_attr_tbl(l_index) := OE_HEADER_UTIL.G_SOLD_TO_PHONE;
1621: END IF;
1622:
1623: IF NOT OE_GLOBALS.Equal(p_x_header_rec.tax_exempt_flag,p_old_header_rec.tax_exempt_flag)
1624: THEN

Line 1626: l_src_attr_tbl(l_index) := OE_HEADER_UTIL.G_TAX_EXEMPT;

1622:
1623: IF NOT OE_GLOBALS.Equal(p_x_header_rec.tax_exempt_flag,p_old_header_rec.tax_exempt_flag)
1624: THEN
1625: l_index := l_index + 1.0;
1626: l_src_attr_tbl(l_index) := OE_HEADER_UTIL.G_TAX_EXEMPT;
1627: END IF;
1628:
1629: IF NOT OE_GLOBALS.Equal(p_x_header_rec.transactional_curr_code,p_old_header_rec.transactional_curr_code)
1630: THEN

Line 1632: l_src_attr_tbl(l_index) := OE_HEADER_UTIL.G_TRANSACTIONAL_CURR;

1628:
1629: IF NOT OE_GLOBALS.Equal(p_x_header_rec.transactional_curr_code,p_old_header_rec.transactional_curr_code)
1630: THEN
1631: l_index := l_index + 1.0;
1632: l_src_attr_tbl(l_index) := OE_HEADER_UTIL.G_TRANSACTIONAL_CURR;
1633: END IF;
1634:
1635: IF NOT OE_GLOBALS.Equal(p_x_header_rec.blanket_number,p_old_header_rec.blanket_number)
1636: THEN

Line 1638: l_src_attr_tbl(l_index) := OE_HEADER_UTIL.G_BLANKET_NUMBER;

1634:
1635: IF NOT OE_GLOBALS.Equal(p_x_header_rec.blanket_number,p_old_header_rec.blanket_number)
1636: THEN
1637: l_index := l_index + 1.0;
1638: l_src_attr_tbl(l_index) := OE_HEADER_UTIL.G_BLANKET_NUMBER;
1639: END IF;
1640:
1641: -- QUOTING changes
1642: IF NOT OE_GLOBALS.Equal(p_x_header_rec.transaction_phase_code,p_old_header_rec.transaction_phase_code)

Line 1645: l_src_attr_tbl(l_index) := OE_HEADER_UTIL.G_TRANSACTION_PHASE;

1641: -- QUOTING changes
1642: IF NOT OE_GLOBALS.Equal(p_x_header_rec.transaction_phase_code,p_old_header_rec.transaction_phase_code)
1643: THEN
1644: l_index := l_index + 1.0;
1645: l_src_attr_tbl(l_index) := OE_HEADER_UTIL.G_TRANSACTION_PHASE;
1646: END IF;
1647: -- QUOTING changes END
1648:
1649: --distributed order @

Line 1653: l_src_attr_tbl(l_index) := OE_HEADER_UTIL.G_END_CUSTOMER;

1649: --distributed order @
1650: IF NOT OE_GLOBALS.Equal(p_x_header_rec.end_customer_id,p_old_header_rec.end_customer_id)
1651: THEN
1652: l_index := l_index + 1.0;
1653: l_src_attr_tbl(l_index) := OE_HEADER_UTIL.G_END_CUSTOMER;
1654: END IF;
1655:
1656: -- bug 5127922
1657: IF NOT OE_GLOBALS.Equal(p_x_header_rec.sold_to_site_use_id,p_old_header_rec.sold_to_site_use_id)

Line 1660: l_src_attr_tbl(l_index) := OE_HEADER_UTIL.G_SOLD_TO_SITE_USE;

1656: -- bug 5127922
1657: IF NOT OE_GLOBALS.Equal(p_x_header_rec.sold_to_site_use_id,p_old_header_rec.sold_to_site_use_id)
1658: THEN
1659: l_index := l_index + 1.0;
1660: l_src_attr_tbl(l_index) := OE_HEADER_UTIL.G_SOLD_TO_SITE_USE;
1661: END IF;
1662:
1663: END IF;
1664:

Line 1678: oe_debug_pub.add('Exiting OE_HEADER_UTIL.CLEAR_DEPENDENT_ATTR', 1);

1674: --can be cleared during the future calls when the cc is not selected
1675: --from the LOV.
1676: g_is_cc_selected_from_LOV := 'N';
1677:
1678: oe_debug_pub.add('Exiting OE_HEADER_UTIL.CLEAR_DEPENDENT_ATTR', 1);
1679:
1680: EXCEPTION
1681: WHEN FND_API.G_EXC_ERROR THEN
1682: RAISE FND_API.G_EXC_ERROR;

Line 1762: oe_debug_pub.add('Entering OE_HEADER_UTIL.APPLY_ATTRIBUTE_CHANGES', 1);

1758: l_log_delete_payment_req VARCHAR2(1) := 'N';
1759:
1760: BEGIN
1761:
1762: oe_debug_pub.add('Entering OE_HEADER_UTIL.APPLY_ATTRIBUTE_CHANGES', 1);
1763:
1764: -- Load out record
1765:
1766: IF NOT OE_GLOBALS.Equal(p_x_header_rec.booked_flag,p_old_header_rec.booked_flag)

Line 2407: oe_debug_pub.add('Exiting OE_HEADER_UTIL.APPLY_ATTRIBUTE_CHANGES', 1);

2403: THEN
2404: OE_Schedule_Util.G_DATE_TYPE := p_x_header_rec.order_date_type_code; END IF;
2405: END IF;
2406: /*-- 3288805 --*/
2407: oe_debug_pub.add('Exiting OE_HEADER_UTIL.APPLY_ATTRIBUTE_CHANGES', 1);
2408:
2409: END Apply_Attribute_Changes;
2410:
2411: -- Procedure Complete_Record

Line 2421: oe_debug_pub.add('Entering OE_HEADER_UTIL.COMPLETE_RECORD', 1);

2417: IS
2418:
2419: BEGIN
2420:
2421: oe_debug_pub.add('Entering OE_HEADER_UTIL.COMPLETE_RECORD', 1);
2422:
2423: IF p_x_header_rec.accounting_rule_id = FND_API.G_MISS_NUM THEN
2424: p_x_header_rec.accounting_rule_id := p_old_header_rec.accounting_rule_id;
2425: END IF;

Line 3133: oe_debug_pub.add('Exiting OE_HEADER_UTIL.COMPLETE_RECORD', 1);

3129: --key Transaction Dates
3130: IF p_x_header_rec.order_firmed_date = FND_API.G_MISS_DATE THEN
3131: p_x_header_rec.order_firmed_date := p_old_header_rec.order_firmed_date;
3132: END IF;
3133: oe_debug_pub.add('Exiting OE_HEADER_UTIL.COMPLETE_RECORD', 1);
3134:
3135:
3136: END Complete_Record;
3137:

Line 3147: oe_debug_pub.add('Entering OE_HEADER_UTIL.CONVERT_MISS_TO_NULL', 1);

3143: IS
3144: --p_x_header_rec OE_Order_PUB.Header_Rec_Type := p_header_rec;
3145: BEGIN
3146:
3147: oe_debug_pub.add('Entering OE_HEADER_UTIL.CONVERT_MISS_TO_NULL', 1);
3148:
3149: IF p_x_header_rec.accounting_rule_id = FND_API.G_MISS_NUM THEN
3150: p_x_header_rec.accounting_rule_id := NULL;
3151: END IF;

Line 3789: oe_debug_pub.add('Exiting OE_HEADER_UTIL.CONVERT_MISS_TO_NULL', 1);

3785: IF p_x_header_rec.order_firmed_date = FND_API.G_MISS_DATE THEN
3786: p_x_header_rec.order_firmed_date := NULL;
3787: END IF;
3788:
3789: oe_debug_pub.add('Exiting OE_HEADER_UTIL.CONVERT_MISS_TO_NULL', 1);
3790:
3791:
3792: END Convert_Miss_To_Null;
3793:

Line 3807: oe_debug_pub.add('Entering OE_HEADER_UTIL.UPDATE_ROW', 1);

3803: l_index NUMBER;
3804: l_return_status VARCHAR2(1);
3805: BEGIN
3806:
3807: oe_debug_pub.add('Entering OE_HEADER_UTIL.UPDATE_ROW', 1);
3808: --Commented for MOAC start
3809: /*l_org_id := OE_GLOBALS.G_ORG_ID;
3810:
3811: IF l_org_id IS NULL THEN

Line 3835: OE_DEBUG_PUB.ADD('Update_Global Return Status from OE_HEADER_UTIL.update_row is: ' || l_return_status);

3831: p_header_id => p_header_rec.header_id,
3832: x_index => l_index,
3833: x_return_status => l_return_status);
3834:
3835: OE_DEBUG_PUB.ADD('Update_Global Return Status from OE_HEADER_UTIL.update_row is: ' || l_return_status);
3836: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3837: OE_DEBUG_PUB.ADD('EVENT NOTIFY - Unexpected Error');
3838: OE_DEBUG_PUB.ADD('Exiting OE_HEADER_UTIL.Update_ROW', 1);
3839: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3838: OE_DEBUG_PUB.ADD('Exiting OE_HEADER_UTIL.Update_ROW', 1);

3834:
3835: OE_DEBUG_PUB.ADD('Update_Global Return Status from OE_HEADER_UTIL.update_row is: ' || l_return_status);
3836: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3837: OE_DEBUG_PUB.ADD('EVENT NOTIFY - Unexpected Error');
3838: OE_DEBUG_PUB.ADD('Exiting OE_HEADER_UTIL.Update_ROW', 1);
3839: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3840: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3841: OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_HEADER_UTIL.Update_row');
3842: OE_DEBUG_PUB.ADD('Exiting OE_HEADER_UTIL.Update_ROW', 1);

Line 3841: OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_HEADER_UTIL.Update_row');

3837: OE_DEBUG_PUB.ADD('EVENT NOTIFY - Unexpected Error');
3838: OE_DEBUG_PUB.ADD('Exiting OE_HEADER_UTIL.Update_ROW', 1);
3839: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3840: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3841: OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_HEADER_UTIL.Update_row');
3842: OE_DEBUG_PUB.ADD('Exiting OE_HEADER_UTIL.Update_ROW', 1);
3843: RAISE FND_API.G_EXC_ERROR;
3844: END IF;
3845: END IF; /*code_release_level*/

Line 3842: OE_DEBUG_PUB.ADD('Exiting OE_HEADER_UTIL.Update_ROW', 1);

3838: OE_DEBUG_PUB.ADD('Exiting OE_HEADER_UTIL.Update_ROW', 1);
3839: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3840: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3841: OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_HEADER_UTIL.Update_row');
3842: OE_DEBUG_PUB.ADD('Exiting OE_HEADER_UTIL.Update_ROW', 1);
3843: RAISE FND_API.G_EXC_ERROR;
3844: END IF;
3845: END IF; /*code_release_level*/
3846: -- notification framework end

Line 4048: oe_debug_pub.add('Exiting OE_HEADER_UTIL.UPDATE_ROW', 1);

4044: -- to call below procedure to update, updated directly above
4045:
4046: -- OE_Order_Cache.Set_Order_Header(p_header_rec);
4047:
4048: oe_debug_pub.add('Exiting OE_HEADER_UTIL.UPDATE_ROW', 1);
4049:
4050: EXCEPTION
4051:
4052: WHEN OTHERS THEN

Line 4080: oe_debug_pub.add('Entering OE_HEADER_UTIL.INSERT_ROW', 1);

4076: l_return_status VARCHAR2(1);
4077: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4078: BEGIN
4079:
4080: oe_debug_pub.add('Entering OE_HEADER_UTIL.INSERT_ROW', 1);
4081:
4082: --MOAC change
4083: OE_GLOBALS.Set_Context;
4084: l_org_id := OE_GLOBALS.G_ORG_ID;

Line 4479: OE_DEBUG_PUB.ADD('Update_Global Return Status from OE_HEADER_UTIL.insert_row is: ' || l_return_status);

4475: p_Header_rec =>p_header_rec,
4476: p_header_id => p_header_rec.header_id,
4477: x_index => l_index,
4478: x_return_status => l_return_status);
4479: OE_DEBUG_PUB.ADD('Update_Global Return Status from OE_HEADER_UTIL.insert_row is: ' || l_return_status);
4480: OE_DEBUG_PUB.ADD('returned index is: ' || l_index ,1);
4481: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4482: OE_DEBUG_PUB.ADD('EVENT NOTIFY - Unexpected Error');
4483: OE_DEBUG_PUB.ADD('Exiting OE_HEADER_UTIL.INSERT_ROW', 1);

Line 4483: OE_DEBUG_PUB.ADD('Exiting OE_HEADER_UTIL.INSERT_ROW', 1);

4479: OE_DEBUG_PUB.ADD('Update_Global Return Status from OE_HEADER_UTIL.insert_row is: ' || l_return_status);
4480: OE_DEBUG_PUB.ADD('returned index is: ' || l_index ,1);
4481: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4482: OE_DEBUG_PUB.ADD('EVENT NOTIFY - Unexpected Error');
4483: OE_DEBUG_PUB.ADD('Exiting OE_HEADER_UTIL.INSERT_ROW', 1);
4484: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4485: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4486: OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_HEADER_UTIL.Insert_row');
4487: OE_DEBUG_PUB.ADD('Exiting OE_HEADER_UTIL.INSERT_ROW', 1);

Line 4486: OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_HEADER_UTIL.Insert_row');

4482: OE_DEBUG_PUB.ADD('EVENT NOTIFY - Unexpected Error');
4483: OE_DEBUG_PUB.ADD('Exiting OE_HEADER_UTIL.INSERT_ROW', 1);
4484: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4485: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4486: OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_HEADER_UTIL.Insert_row');
4487: OE_DEBUG_PUB.ADD('Exiting OE_HEADER_UTIL.INSERT_ROW', 1);
4488: RAISE FND_API.G_EXC_ERROR;
4489: END IF;
4490: END IF; /*code_release_level*/

Line 4487: OE_DEBUG_PUB.ADD('Exiting OE_HEADER_UTIL.INSERT_ROW', 1);

4483: OE_DEBUG_PUB.ADD('Exiting OE_HEADER_UTIL.INSERT_ROW', 1);
4484: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4485: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4486: OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_HEADER_UTIL.Insert_row');
4487: OE_DEBUG_PUB.ADD('Exiting OE_HEADER_UTIL.INSERT_ROW', 1);
4488: RAISE FND_API.G_EXC_ERROR;
4489: END IF;
4490: END IF; /*code_release_level*/
4491: -- notification framework end

Line 4493: oe_debug_pub.add('Exiting OE_HEADER_UTIL.INSERT_ROW', 1);

4489: END IF;
4490: END IF; /*code_release_level*/
4491: -- notification framework end
4492:
4493: oe_debug_pub.add('Exiting OE_HEADER_UTIL.INSERT_ROW', 1);
4494:
4495: EXCEPTION
4496:
4497: WHEN OTHERS THEN

Line 4530: oe_debug_pub.add('Entering OE_HEADER_UTIL.DELETE_ROW', 1);

4526: l_msg_count NUMBER;
4527: l_msg_data VARCHAR2(2000);
4528: BEGIN
4529:
4530: oe_debug_pub.add('Entering OE_HEADER_UTIL.DELETE_ROW', 1);
4531: --Commented for MOAC start
4532: /*l_org_id := OE_GLOBALS.G_ORG_ID;
4533: IF l_org_id IS NULL THEN
4534: OE_GLOBALS.Set_Context;

Line 4549: OE_DEBUG_PUB.ADD('Update_Global Return Status from OE_HEADER_UTIL.delete_row is: ' || l_return_status);

4545: p_Header_rec =>l_new_header_rec,
4546: p_header_id => p_header_id,
4547: x_index => l_index,
4548: x_return_status => l_return_status);
4549: OE_DEBUG_PUB.ADD('Update_Global Return Status from OE_HEADER_UTIL.delete_row is: ' || l_return_status);
4550:
4551: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4552: OE_DEBUG_PUB.ADD('EVENT NOTIFY - Unexpected Error');
4553: OE_DEBUG_PUB.ADD('Exiting OE_HEADER_UTIL.DELETE_ROW', 1);

Line 4553: OE_DEBUG_PUB.ADD('Exiting OE_HEADER_UTIL.DELETE_ROW', 1);

4549: OE_DEBUG_PUB.ADD('Update_Global Return Status from OE_HEADER_UTIL.delete_row is: ' || l_return_status);
4550:
4551: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4552: OE_DEBUG_PUB.ADD('EVENT NOTIFY - Unexpected Error');
4553: OE_DEBUG_PUB.ADD('Exiting OE_HEADER_UTIL.DELETE_ROW', 1);
4554: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4555: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4556: OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_HEADER_UTIL.Delete_row');
4557: OE_DEBUG_PUB.ADD('Exiting OE_HEADER_UTIL.DELETE_ROW', 1);

Line 4556: OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_HEADER_UTIL.Delete_row');

4552: OE_DEBUG_PUB.ADD('EVENT NOTIFY - Unexpected Error');
4553: OE_DEBUG_PUB.ADD('Exiting OE_HEADER_UTIL.DELETE_ROW', 1);
4554: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4555: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4556: OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_HEADER_UTIL.Delete_row');
4557: OE_DEBUG_PUB.ADD('Exiting OE_HEADER_UTIL.DELETE_ROW', 1);
4558: RAISE FND_API.G_EXC_ERROR;
4559: END IF;
4560: END IF; /* code_release_level*/

Line 4557: OE_DEBUG_PUB.ADD('Exiting OE_HEADER_UTIL.DELETE_ROW', 1);

4553: OE_DEBUG_PUB.ADD('Exiting OE_HEADER_UTIL.DELETE_ROW', 1);
4554: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4555: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4556: OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_HEADER_UTIL.Delete_row');
4557: OE_DEBUG_PUB.ADD('Exiting OE_HEADER_UTIL.DELETE_ROW', 1);
4558: RAISE FND_API.G_EXC_ERROR;
4559: END IF;
4560: END IF; /* code_release_level*/
4561: -- notification framework end

Line 4589: oe_debug_pub.add('Request to Reverse_Limits in OE_HEADER_UTIL.Delete_Row is done',1);

4585: , p_ret_price_request_code => NULL
4586: , p_returned_qty => NULL
4587: , p_line_id => NULL
4588: );
4589: oe_debug_pub.add('Request to Reverse_Limits in OE_HEADER_UTIL.Delete_Row is done',1);
4590: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4591: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4592: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4593: RAISE FND_API.G_EXC_ERROR;

Line 4654: oe_debug_pub.add('Exiting OE_HEADER_UTIL.DELETE_ROW', 1);

4650: /* AND
4651: (NVL(ORG_ID,NVL(l_org_id,0))= NVL(l_org_id,0))
4652: ;*/
4653:
4654: oe_debug_pub.add('Exiting OE_HEADER_UTIL.DELETE_ROW', 1);
4655:
4656: EXCEPTION
4657: WHEN FND_API.G_EXC_ERROR THEN
4658: --takintoy, added for delete articles

Line 4859: oe_debug_pub.add('Entering OE_HEADER_UTIL.QUERY_ROW', 1);

4855: l_return_status VARCHAR2(1);
4856: BEGIN
4857:
4858: if l_debug_level > 0 then
4859: oe_debug_pub.add('Entering OE_HEADER_UTIL.QUERY_ROW', 1);
4860: end if;
4861: --Commented for MOAC start
4862: /*l_org_id := OE_GLOBALS.G_ORG_ID;
4863: IF l_org_id IS NULL THEN

Line 5282: oe_debug_pub.add('Before caching OE_HEADER_UTIL.QUERY_ROW', 1);

5278:
5279: -- aksingh assigning the global record, so later the cached record
5280: -- will be used instead of querying again
5281: if l_debug_level > 0 then
5282: oe_debug_pub.add('Before caching OE_HEADER_UTIL.QUERY_ROW', 1);
5283: end if;
5284:
5285: oe_order_cache.g_header_rec := x_header_rec;
5286: oe_order_cache.g_header_rec.operation := null;

Line 5289: oe_debug_pub.add('Exiting OE_HEADER_UTIL.QUERY_ROW', 1);

5285: oe_order_cache.g_header_rec := x_header_rec;
5286: oe_order_cache.g_header_rec.operation := null;
5287:
5288: if l_debug_level > 0 then
5289: oe_debug_pub.add('Exiting OE_HEADER_UTIL.QUERY_ROW', 1);
5290: end if;
5291:
5292:
5293: EXCEPTION

Line 5328: oe_debug_pub.add('Entering OE_HEADER_UTIL.LOCK_ROW', 1);

5324: l_lock_control NUMBER;
5325: l_db_lock_control NUMBER;
5326: BEGIN
5327:
5328: oe_debug_pub.add('Entering OE_HEADER_UTIL.LOCK_ROW', 1);
5329:
5330: SAVEPOINT Lock_Row;
5331:
5332: l_lock_control := NULL;

Line 5356: OE_Header_Util.Query_Row(p_header_id => l_header_id,

5352: p_x_header_rec.lock_control := -1;
5353: END IF;
5354: -- End of the fix 2436046 }
5355:
5356: OE_Header_Util.Query_Row(p_header_id => l_header_id,
5357: x_header_rec => p_x_header_rec);
5358:
5359: oe_debug_pub.add('selected for update, now compare', 3);
5360:

Line 5423: oe_debug_pub.add('Exiting OE_HEADER_UTIL.LOCK_ROW', 1);

5419: END IF;
5420:
5421: END IF;
5422:
5423: oe_debug_pub.add('Exiting OE_HEADER_UTIL.LOCK_ROW', 1);
5424:
5425: OE_GLOBALS.G_LOCK_TEST := 'N';
5426: EXCEPTION
5427:

Line 5491: oe_debug_pub.add('Entering OE_HEADER_UTIL.GET_VALUES', 1);

5487: l_msg_count NUMBER;
5488: l_msg_data VARCHAR2(2000);
5489: BEGIN
5490:
5491: oe_debug_pub.add('Entering OE_HEADER_UTIL.GET_VALUES', 1);
5492:
5493: l_header_val_rec := OE_Order_PUB.G_MISS_HEADER_VAL_REC;
5494:
5495: IF (p_header_rec.accounting_rule_id IS NULL OR

Line 6011: oe_debug_pub.add('Exiting OE_HEADER_UTIL.GET_VALUES', 1);

6007: );
6008:
6009: END IF;
6010:
6011: oe_debug_pub.add('Exiting OE_HEADER_UTIL.GET_VALUES', 1);
6012:
6013: RETURN l_header_val_rec;
6014:
6015: END Get_Values;

Line 6030: oe_debug_pub.add('Entering OE_HEADER_UTIL.GET_IDS', 1);

6026: l_invoice_to_org_id NUMBER;
6027: l_deliver_to_org_id NUMBER;
6028: BEGIN
6029:
6030: oe_debug_pub.add('Entering OE_HEADER_UTIL.GET_IDS', 1);
6031:
6032:
6033: IF p_header_val_rec.accounting_rule <> FND_API.G_MISS_CHAR
6034: THEN

Line 7398: oe_debug_pub.add('Exiting OE_HEADER_UTIL.GET_IDS', 1);

7394: ----------------------------------------------------------------------
7395: -- End of get IDs for customer related fields
7396: ----------------------------------------------------------------------
7397:
7398: oe_debug_pub.add('Exiting OE_HEADER_UTIL.GET_IDS', 1);
7399:
7400: END Get_Ids;
7401:
7402:

Line 7426: oe_debug_pub.add('Entering OE_HEADER_UTIL.Get_Ord_Seq_Type',1);

7422: x_result NUMBER;
7423:
7424: BEGIN
7425:
7426: oe_debug_pub.add('Entering OE_HEADER_UTIL.Get_Ord_Seq_Type',1);
7427:
7428: IF p_order_type_id IS NULL OR
7429: p_order_type_id = FND_API.G_MISS_NUM
7430: THEN

Line 7468: oe_debug_pub.add('Exiting OE_HEADER_UTIL.Get_Ord_Seq_Type',1);

7464: IF x_result <> 0 THEN
7465: RAISE FND_API.G_EXC_ERROR;
7466: END IF;
7467:
7468: oe_debug_pub.add('Exiting OE_HEADER_UTIL.Get_Ord_Seq_Type',1);
7469:
7470: RETURN x_doc_sequence_type;
7471:
7472: EXCEPTION

Line 7499: -- oe_debug_pub.add('Entering OE_HEADER_UTIL.Get_Order_Info',1);

7495: BEGIN
7496:
7497: --Commenting the oe_debug_pub call to fix bug 2105266.
7498:
7499: -- oe_debug_pub.add('Entering OE_HEADER_UTIL.Get_Order_Info',1);
7500:
7501: BEGIN
7502: SELECT order_number,order_type_id
7503: INTO l_order_number,l_order_type_id

Line 7529: -- oe_debug_pub.add('Exiting OE_HEADER_UTIL.Get_Order_Info',1);

7525: WHEN NO_DATA_FOUND THEN
7526: x_order_type := NULL;
7527: END;
7528:
7529: -- oe_debug_pub.add('Exiting OE_HEADER_UTIL.Get_Order_Info',1);
7530:
7531: END Get_Order_Info;
7532:
7533: FUNCTION Get_Header_Id (p_order_number IN NUMBER,

Line 7626: oe_debug_pub.add('Entering OE_HEADER_UTIL.Get_Order_Number',1);

7622: lcount NUMBER;
7623: x_result NUMBER;
7624:
7625: BEGIN
7626: oe_debug_pub.add('Entering OE_HEADER_UTIL.Get_Order_Number',1);
7627: oe_debug_pub.add('Entering OE_HEADER_UTIL.Get_Order_Number',1);
7628: -- Check if Order Number can be updated or not???? bug 4146258
7629: -- Fixed by Srini
7630: IF NOT OE_GLOBALS.EQUAL(p_x_header_rec.order_number,

Line 7627: oe_debug_pub.add('Entering OE_HEADER_UTIL.Get_Order_Number',1);

7623: x_result NUMBER;
7624:
7625: BEGIN
7626: oe_debug_pub.add('Entering OE_HEADER_UTIL.Get_Order_Number',1);
7627: oe_debug_pub.add('Entering OE_HEADER_UTIL.Get_Order_Number',1);
7628: -- Check if Order Number can be updated or not???? bug 4146258
7629: -- Fixed by Srini
7630: IF NOT OE_GLOBALS.EQUAL(p_x_header_rec.order_number,
7631: p_old_header_rec.order_number)

Line 8069: Oe_Header_Util.get_order_number(p_x_header_rec => p_x_header_rec,

8065: END IF;
8066: END IF;
8067: -- Included to fix bug 1589196 End
8068:
8069: Oe_Header_Util.get_order_number(p_x_header_rec => p_x_header_rec,
8070: p_old_header_rec => p_old_header_rec);
8071:
8072:
8073: -- Call Cancellation Related Code

Line 8090: -- requests from Pre_Write_Process procedure of OE_Header_Util package.

8086: -- When the order header level cancellation is triggered, and all the
8087: -- order lines are successfully cancelled, we should log a delayed request
8088: -- G_UPDATE_REQUISITION to call the Purchasing API so as to trigger the
8089: -- requisition header cancellation. For this, we need to log the delayed
8090: -- requests from Pre_Write_Process procedure of OE_Header_Util package.
8091: -- In this procedure, we need to raise this delayed request only after
8092: -- successful execution of OE_Sales_Can_Util.Perform_Cancel_Order API,
8093: -- which is responsible for canceling both order header and all order
8094: -- lines. This code will be triggered in the event of Full Order

Line 8734: oe_debug_pub.add('Entering OE_HEADER_UTIL.Post_Write_Process',1);

8730: L_DOWNPAYMENT number;
8731: l_line_payment_count NUMBER;
8732: --bug 5258767
8733: BEGIN
8734: oe_debug_pub.add('Entering OE_HEADER_UTIL.Post_Write_Process',1);
8735:
8736: -- Added call to new procedure eval_post_write_header for performance
8737: -- and to be consistent with evalualte_post_write for lines.
8738: -- See bug#1777317

Line 9069: oe_debug_pub.ADD('OE_Header_Util.Post_Write unexp error in instantiate doc terms',1);

9065: );
9066:
9067: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
9068: if l_debug_level > 0 then
9069: oe_debug_pub.ADD('OE_Header_Util.Post_Write unexp error in instantiate doc terms',1);
9070: end if;
9071: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9072: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
9073: if l_debug_level > 0 then

Line 9074: oe_debug_pub.ADD('OE_Header_Util.Post_Write exp error in instantiate doc terms',1);

9070: end if;
9071: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9072: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
9073: if l_debug_level > 0 then
9074: oe_debug_pub.ADD('OE_Header_Util.Post_Write exp error in instantiate doc terms',1);
9075: end if;
9076: RAISE FND_API.G_EXC_ERROR;
9077: END IF;
9078:

Line 9352: oe_debug_pub.add('Exiting OE_HEADER_UTIL.Post_Write_Process',1);

9348: oe_debug_pub.add('Success in Header Payments call...');
9349: END IF;
9350: END IF;
9351: --R12 CC Encryption
9352: oe_debug_pub.add('Exiting OE_HEADER_UTIL.Post_Write_Process',1);
9353: EXCEPTION
9354: WHEN FND_API.G_EXC_ERROR THEN
9355: RAISE FND_API.G_EXC_ERROR;
9356: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 9689: END OE_Header_Util;

9685:
9686: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9687:
9688: END Blkt_Req_For_Curr_Upd_And_Del;
9689: END OE_Header_Util;