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_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.70.12020000.5 2013/01/07 09:42:30 sujithku 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.70.12020000.5 2013/01/07 09:42:30 sujithku 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 788: oe_debug_pub.add('Entering OE_HEADER_UTIL.Clear_Dependent',1);

784:
785:
786: BEGIN
787:
788: oe_debug_pub.add('Entering OE_HEADER_UTIL.Clear_Dependent',1);
789: IF p_src_attr_tbl.COUNT <> 0 THEN
790:
791: OE_Dependencies.Mark_Dependent
792: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,

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

793: p_source_attr_tbl => p_src_attr_tbl,
794: p_dep_attr_tbl => l_dep_attr_tbl);
795:
796: FOR I IN 1..l_dep_attr_tbl.COUNT LOOP
797: IF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_ACCOUNTING_RULE THEN
798: ACCOUNTING_RULE;
799: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_ACCOUNTING_RULE_DURATION THEN
800: ACCOUNTING_RULE_DURATION;
801: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_AGREEMENT THEN

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

795:
796: FOR I IN 1..l_dep_attr_tbl.COUNT LOOP
797: IF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_ACCOUNTING_RULE THEN
798: ACCOUNTING_RULE;
799: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_ACCOUNTING_RULE_DURATION THEN
800: ACCOUNTING_RULE_DURATION;
801: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_AGREEMENT THEN
802: AGREEMENT;
803: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_CONVERSION_RATE THEN

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

797: IF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_ACCOUNTING_RULE THEN
798: ACCOUNTING_RULE;
799: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_ACCOUNTING_RULE_DURATION THEN
800: ACCOUNTING_RULE_DURATION;
801: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_AGREEMENT THEN
802: AGREEMENT;
803: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_CONVERSION_RATE THEN
804: CONVERSION_RATE;
805: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_CONVERSION_RATE_DATE THEN

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

799: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_ACCOUNTING_RULE_DURATION THEN
800: ACCOUNTING_RULE_DURATION;
801: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_AGREEMENT THEN
802: AGREEMENT;
803: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_CONVERSION_RATE THEN
804: CONVERSION_RATE;
805: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_CONVERSION_RATE_DATE THEN
806: CONVERSION_RATE_DATE;
807: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_CONVERSION_TYPE THEN

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

801: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_AGREEMENT THEN
802: AGREEMENT;
803: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_CONVERSION_RATE THEN
804: CONVERSION_RATE;
805: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_CONVERSION_RATE_DATE THEN
806: CONVERSION_RATE_DATE;
807: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_CONVERSION_TYPE THEN
808: CONVERSION_TYPE;
809: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_CREDIT_CARD_EXPIRATION_DATE THEN

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

803: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_CONVERSION_RATE THEN
804: CONVERSION_RATE;
805: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_CONVERSION_RATE_DATE THEN
806: CONVERSION_RATE_DATE;
807: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_CONVERSION_TYPE THEN
808: CONVERSION_TYPE;
809: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_CREDIT_CARD_EXPIRATION_DATE THEN
810: CREDIT_CARD_EXPIRATION_DATE;
811: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_CREDIT_CARD_HOLDER_NAME THEN

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

805: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_CONVERSION_RATE_DATE THEN
806: CONVERSION_RATE_DATE;
807: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_CONVERSION_TYPE THEN
808: CONVERSION_TYPE;
809: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_CREDIT_CARD_EXPIRATION_DATE THEN
810: CREDIT_CARD_EXPIRATION_DATE;
811: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_CREDIT_CARD_HOLDER_NAME THEN
812: CREDIT_CARD_HOLDER_NAME;
813: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_CREDIT_CARD_NUMBER THEN

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

807: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_CONVERSION_TYPE THEN
808: CONVERSION_TYPE;
809: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_CREDIT_CARD_EXPIRATION_DATE THEN
810: CREDIT_CARD_EXPIRATION_DATE;
811: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_CREDIT_CARD_HOLDER_NAME THEN
812: CREDIT_CARD_HOLDER_NAME;
813: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_CREDIT_CARD_NUMBER THEN
814: CREDIT_CARD_NUMBER;
815: /* Fix Bug # 2297053: Added to clear Credit Card Type */

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

809: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_CREDIT_CARD_EXPIRATION_DATE THEN
810: CREDIT_CARD_EXPIRATION_DATE;
811: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_CREDIT_CARD_HOLDER_NAME THEN
812: CREDIT_CARD_HOLDER_NAME;
813: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_CREDIT_CARD_NUMBER THEN
814: CREDIT_CARD_NUMBER;
815: /* Fix Bug # 2297053: Added to clear Credit Card Type */
816: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_CREDIT_CARD THEN
817: CREDIT_CARD;

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

812: CREDIT_CARD_HOLDER_NAME;
813: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_CREDIT_CARD_NUMBER THEN
814: CREDIT_CARD_NUMBER;
815: /* Fix Bug # 2297053: Added to clear Credit Card Type */
816: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_CREDIT_CARD THEN
817: CREDIT_CARD;
818: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_CHECK_NUMBER THEN --For bug 2692314
819: CHECK_NUMBER;
820: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_CUST_PO_NUMBER THEN

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

814: CREDIT_CARD_NUMBER;
815: /* Fix Bug # 2297053: Added to clear Credit Card Type */
816: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_CREDIT_CARD THEN
817: CREDIT_CARD;
818: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_CHECK_NUMBER THEN --For bug 2692314
819: CHECK_NUMBER;
820: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_CUST_PO_NUMBER THEN
821: CUST_PO_NUMBER;
822: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_CUSTOMER_PREFERENCE_SET THEN

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

816: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_CREDIT_CARD THEN
817: CREDIT_CARD;
818: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_CHECK_NUMBER THEN --For bug 2692314
819: CHECK_NUMBER;
820: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_CUST_PO_NUMBER THEN
821: CUST_PO_NUMBER;
822: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_CUSTOMER_PREFERENCE_SET THEN
823: CUSTOMER_PREFERENCE_SET_CODE;
824: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_DEFAULT_FULFILLMENT_SET THEN

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

818: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_CHECK_NUMBER THEN --For bug 2692314
819: CHECK_NUMBER;
820: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_CUST_PO_NUMBER THEN
821: CUST_PO_NUMBER;
822: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_CUSTOMER_PREFERENCE_SET THEN
823: CUSTOMER_PREFERENCE_SET_CODE;
824: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_DEFAULT_FULFILLMENT_SET THEN
825: DEFAULT_FULFILLMENT_SET;
826: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_DELIVER_TO_CONTACT THEN

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

820: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_CUST_PO_NUMBER THEN
821: CUST_PO_NUMBER;
822: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_CUSTOMER_PREFERENCE_SET THEN
823: CUSTOMER_PREFERENCE_SET_CODE;
824: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_DEFAULT_FULFILLMENT_SET THEN
825: DEFAULT_FULFILLMENT_SET;
826: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_DELIVER_TO_CONTACT THEN
827: DELIVER_TO_CONTACT;
828: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_DELIVER_TO_ORG THEN

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

822: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_CUSTOMER_PREFERENCE_SET THEN
823: CUSTOMER_PREFERENCE_SET_CODE;
824: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_DEFAULT_FULFILLMENT_SET THEN
825: DEFAULT_FULFILLMENT_SET;
826: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_DELIVER_TO_CONTACT THEN
827: DELIVER_TO_CONTACT;
828: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_DELIVER_TO_ORG THEN
829: DELIVER_TO_ORG;
830: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_DEMAND_CLASS THEN

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

824: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_DEFAULT_FULFILLMENT_SET THEN
825: DEFAULT_FULFILLMENT_SET;
826: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_DELIVER_TO_CONTACT THEN
827: DELIVER_TO_CONTACT;
828: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_DELIVER_TO_ORG THEN
829: DELIVER_TO_ORG;
830: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_DEMAND_CLASS THEN
831: DEMAND_CLASS;
832: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_FOB_POINT THEN

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

826: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_DELIVER_TO_CONTACT THEN
827: DELIVER_TO_CONTACT;
828: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_DELIVER_TO_ORG THEN
829: DELIVER_TO_ORG;
830: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_DEMAND_CLASS THEN
831: DEMAND_CLASS;
832: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_FOB_POINT THEN
833: FOB_POINT;
834: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_FREIGHT_TERMS THEN

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

828: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_DELIVER_TO_ORG THEN
829: DELIVER_TO_ORG;
830: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_DEMAND_CLASS THEN
831: DEMAND_CLASS;
832: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_FOB_POINT THEN
833: FOB_POINT;
834: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_FREIGHT_TERMS THEN
835: FREIGHT_TERMS;
836: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_INVOICE_TO_CONTACT THEN

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

830: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_DEMAND_CLASS THEN
831: DEMAND_CLASS;
832: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_FOB_POINT THEN
833: FOB_POINT;
834: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_FREIGHT_TERMS THEN
835: FREIGHT_TERMS;
836: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_INVOICE_TO_CONTACT THEN
837: INVOICE_TO_CONTACT;
838: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_INVOICE_TO_ORG THEN

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

832: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_FOB_POINT THEN
833: FOB_POINT;
834: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_FREIGHT_TERMS THEN
835: FREIGHT_TERMS;
836: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_INVOICE_TO_CONTACT THEN
837: INVOICE_TO_CONTACT;
838: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_INVOICE_TO_ORG THEN
839: INVOICE_TO_ORG;
840: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_INVOICING_RULE THEN

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

834: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_FREIGHT_TERMS THEN
835: FREIGHT_TERMS;
836: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_INVOICE_TO_CONTACT THEN
837: INVOICE_TO_CONTACT;
838: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_INVOICE_TO_ORG THEN
839: INVOICE_TO_ORG;
840: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_INVOICING_RULE THEN
841: INVOICING_RULE;
842: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_ORDER_CATEGORY THEN

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

836: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_INVOICE_TO_CONTACT THEN
837: INVOICE_TO_CONTACT;
838: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_INVOICE_TO_ORG THEN
839: INVOICE_TO_ORG;
840: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_INVOICING_RULE THEN
841: INVOICING_RULE;
842: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_ORDER_CATEGORY THEN
843: ORDER_CATEGORY;
844: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_ORDER_DATE_TYPE_CODE THEN

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

838: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_INVOICE_TO_ORG THEN
839: INVOICE_TO_ORG;
840: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_INVOICING_RULE THEN
841: INVOICING_RULE;
842: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_ORDER_CATEGORY THEN
843: ORDER_CATEGORY;
844: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_ORDER_DATE_TYPE_CODE THEN
845: ORDER_DATE_TYPE;
846: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_ORDER_TYPE THEN

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

840: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_INVOICING_RULE THEN
841: INVOICING_RULE;
842: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_ORDER_CATEGORY THEN
843: ORDER_CATEGORY;
844: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_ORDER_DATE_TYPE_CODE THEN
845: ORDER_DATE_TYPE;
846: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_ORDER_TYPE THEN
847: ORDER_TYPE;
848: -- Added the call to the method to clear the payment amount bug 4360599

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

842: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_ORDER_CATEGORY THEN
843: ORDER_CATEGORY;
844: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_ORDER_DATE_TYPE_CODE THEN
845: ORDER_DATE_TYPE;
846: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_ORDER_TYPE THEN
847: ORDER_TYPE;
848: -- Added the call to the method to clear the payment amount bug 4360599
849: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_PAYMENT_AMOUNT THEN
850: PAYMENT_AMOUNT;

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

845: ORDER_DATE_TYPE;
846: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_ORDER_TYPE THEN
847: ORDER_TYPE;
848: -- Added the call to the method to clear the payment amount bug 4360599
849: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_PAYMENT_AMOUNT THEN
850: PAYMENT_AMOUNT;
851: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_PAYMENT_TERM THEN
852: PAYMENT_TERM;
853: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_PRICE_LIST THEN

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

847: ORDER_TYPE;
848: -- Added the call to the method to clear the payment amount bug 4360599
849: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_PAYMENT_AMOUNT THEN
850: PAYMENT_AMOUNT;
851: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_PAYMENT_TERM THEN
852: PAYMENT_TERM;
853: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_PRICE_LIST THEN
854: PRICE_LIST;
855: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_PRICE_REQUEST_CODE THEN -- PROMOTIONS SEP/01

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

849: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_PAYMENT_AMOUNT THEN
850: PAYMENT_AMOUNT;
851: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_PAYMENT_TERM THEN
852: PAYMENT_TERM;
853: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_PRICE_LIST THEN
854: PRICE_LIST;
855: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_PRICE_REQUEST_CODE THEN -- PROMOTIONS SEP/01
856: PRICE_REQUEST_CODE;
857: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_REQUEST_DATE THEN

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

851: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_PAYMENT_TERM THEN
852: PAYMENT_TERM;
853: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_PRICE_LIST THEN
854: PRICE_LIST;
855: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_PRICE_REQUEST_CODE THEN -- PROMOTIONS SEP/01
856: PRICE_REQUEST_CODE;
857: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_REQUEST_DATE THEN
858: REQUEST_DATE;
859: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SALESREP THEN

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

853: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_PRICE_LIST THEN
854: PRICE_LIST;
855: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_PRICE_REQUEST_CODE THEN -- PROMOTIONS SEP/01
856: PRICE_REQUEST_CODE;
857: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_REQUEST_DATE THEN
858: REQUEST_DATE;
859: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SALESREP THEN
860: SALESREP;
861: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SALES_CHANNEL THEN

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

855: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_PRICE_REQUEST_CODE THEN -- PROMOTIONS SEP/01
856: PRICE_REQUEST_CODE;
857: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_REQUEST_DATE THEN
858: REQUEST_DATE;
859: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SALESREP THEN
860: SALESREP;
861: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SALES_CHANNEL THEN
862: SALES_CHANNEL;
863: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SHIPMENT_PRIORITY THEN

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

857: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_REQUEST_DATE THEN
858: REQUEST_DATE;
859: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SALESREP THEN
860: SALESREP;
861: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SALES_CHANNEL THEN
862: SALES_CHANNEL;
863: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SHIPMENT_PRIORITY THEN
864: SHIPMENT_PRIORITY;
865: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SHIPPING_METHOD THEN

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

859: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SALESREP THEN
860: SALESREP;
861: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SALES_CHANNEL THEN
862: SALES_CHANNEL;
863: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SHIPMENT_PRIORITY THEN
864: SHIPMENT_PRIORITY;
865: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SHIPPING_METHOD THEN
866: SHIPPING_METHOD;
867: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SHIP_FROM_ORG THEN

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

861: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SALES_CHANNEL THEN
862: SALES_CHANNEL;
863: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SHIPMENT_PRIORITY THEN
864: SHIPMENT_PRIORITY;
865: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SHIPPING_METHOD THEN
866: SHIPPING_METHOD;
867: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SHIP_FROM_ORG THEN
868: SHIP_FROM_ORG;
869: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SHIP_TOLERANCE_ABOVE THEN

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

863: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SHIPMENT_PRIORITY THEN
864: SHIPMENT_PRIORITY;
865: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SHIPPING_METHOD THEN
866: SHIPPING_METHOD;
867: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SHIP_FROM_ORG THEN
868: SHIP_FROM_ORG;
869: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SHIP_TOLERANCE_ABOVE THEN
870: SHIP_TOLERANCE_ABOVE;
871: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SHIP_TOLERANCE_BELOW THEN

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

865: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SHIPPING_METHOD THEN
866: SHIPPING_METHOD;
867: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SHIP_FROM_ORG THEN
868: SHIP_FROM_ORG;
869: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SHIP_TOLERANCE_ABOVE THEN
870: SHIP_TOLERANCE_ABOVE;
871: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SHIP_TOLERANCE_BELOW THEN
872: SHIP_TOLERANCE_BELOW;
873: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SHIP_TO_CONTACT THEN

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

867: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SHIP_FROM_ORG THEN
868: SHIP_FROM_ORG;
869: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SHIP_TOLERANCE_ABOVE THEN
870: SHIP_TOLERANCE_ABOVE;
871: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SHIP_TOLERANCE_BELOW THEN
872: SHIP_TOLERANCE_BELOW;
873: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SHIP_TO_CONTACT THEN
874: SHIP_TO_CONTACT;
875: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SHIP_TO_ORG THEN

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

869: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SHIP_TOLERANCE_ABOVE THEN
870: SHIP_TOLERANCE_ABOVE;
871: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SHIP_TOLERANCE_BELOW THEN
872: SHIP_TOLERANCE_BELOW;
873: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SHIP_TO_CONTACT THEN
874: SHIP_TO_CONTACT;
875: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SHIP_TO_ORG THEN
876: SHIP_TO_ORG;
877: -- Fix bug 1753101: sold to contact dependency code added

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

871: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SHIP_TOLERANCE_BELOW THEN
872: SHIP_TOLERANCE_BELOW;
873: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SHIP_TO_CONTACT THEN
874: SHIP_TO_CONTACT;
875: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SHIP_TO_ORG THEN
876: SHIP_TO_ORG;
877: -- Fix bug 1753101: sold to contact dependency code added
878: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SOLD_TO_CONTACT THEN
879: SOLD_TO_CONTACT;

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

874: SHIP_TO_CONTACT;
875: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SHIP_TO_ORG THEN
876: SHIP_TO_ORG;
877: -- Fix bug 1753101: sold to contact dependency code added
878: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SOLD_TO_CONTACT THEN
879: SOLD_TO_CONTACT;
880: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SOLD_TO_ORG THEN
881: SOLD_TO_ORG;
882: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SOLD_TO_PHONE THEN

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

876: SHIP_TO_ORG;
877: -- Fix bug 1753101: sold to contact dependency code added
878: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SOLD_TO_CONTACT THEN
879: SOLD_TO_CONTACT;
880: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SOLD_TO_ORG THEN
881: SOLD_TO_ORG;
882: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SOLD_TO_PHONE THEN
883: SOLD_TO_PHONE;
884: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_TAX_EXEMPT THEN

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

878: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SOLD_TO_CONTACT THEN
879: SOLD_TO_CONTACT;
880: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SOLD_TO_ORG THEN
881: SOLD_TO_ORG;
882: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SOLD_TO_PHONE THEN
883: SOLD_TO_PHONE;
884: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_TAX_EXEMPT THEN
885: TAX_EXEMPT; -- Bug# 14589391
886: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_TAX_EXEMPT_NUMBER THEN

Line 884: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_TAX_EXEMPT THEN

880: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SOLD_TO_ORG THEN
881: SOLD_TO_ORG;
882: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SOLD_TO_PHONE THEN
883: SOLD_TO_PHONE;
884: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_TAX_EXEMPT THEN
885: TAX_EXEMPT; -- Bug# 14589391
886: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_TAX_EXEMPT_NUMBER THEN
887: TAX_EXEMPT_NUMBER;
888: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_TAX_EXEMPT_REASON THEN

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

882: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SOLD_TO_PHONE THEN
883: SOLD_TO_PHONE;
884: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_TAX_EXEMPT THEN
885: TAX_EXEMPT; -- Bug# 14589391
886: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_TAX_EXEMPT_NUMBER THEN
887: TAX_EXEMPT_NUMBER;
888: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_TAX_EXEMPT_REASON THEN
889: TAX_EXEMPT_REASON;
890: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_TRANSACTIONAL_CURR THEN

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

884: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_TAX_EXEMPT THEN
885: TAX_EXEMPT; -- Bug# 14589391
886: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_TAX_EXEMPT_NUMBER THEN
887: TAX_EXEMPT_NUMBER;
888: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_TAX_EXEMPT_REASON THEN
889: TAX_EXEMPT_REASON;
890: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_TRANSACTIONAL_CURR THEN
891: TRANSACTIONAL_CURR;
892: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_LATEST_SCHEDULE_LIMIT THEN

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

886: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_TAX_EXEMPT_NUMBER THEN
887: TAX_EXEMPT_NUMBER;
888: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_TAX_EXEMPT_REASON THEN
889: TAX_EXEMPT_REASON;
890: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_TRANSACTIONAL_CURR THEN
891: TRANSACTIONAL_CURR;
892: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_LATEST_SCHEDULE_LIMIT THEN
893: LATEST_SCHEDULE_LIMIT;
894: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_PACKING_INSTRUCTIONS THEN

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

888: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_TAX_EXEMPT_REASON THEN
889: TAX_EXEMPT_REASON;
890: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_TRANSACTIONAL_CURR THEN
891: TRANSACTIONAL_CURR;
892: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_LATEST_SCHEDULE_LIMIT THEN
893: LATEST_SCHEDULE_LIMIT;
894: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_PACKING_INSTRUCTIONS THEN
895: PACKING_INSTRUCTIONS; -- added for 2665264
896: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SHIPPING_INSTRUCTIONS THEN

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

890: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_TRANSACTIONAL_CURR THEN
891: TRANSACTIONAL_CURR;
892: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_LATEST_SCHEDULE_LIMIT THEN
893: LATEST_SCHEDULE_LIMIT;
894: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_PACKING_INSTRUCTIONS THEN
895: PACKING_INSTRUCTIONS; -- added for 2665264
896: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SHIPPING_INSTRUCTIONS THEN
897: SHIPPING_INSTRUCTIONS; -- added for 2766005
898:

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

892: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_LATEST_SCHEDULE_LIMIT THEN
893: LATEST_SCHEDULE_LIMIT;
894: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_PACKING_INSTRUCTIONS THEN
895: PACKING_INSTRUCTIONS; -- added for 2665264
896: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SHIPPING_INSTRUCTIONS THEN
897: SHIPPING_INSTRUCTIONS; -- added for 2766005
898:
899: -- QUOTING changes
900: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_TRANSACTION_PHASE THEN

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

896: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SHIPPING_INSTRUCTIONS THEN
897: SHIPPING_INSTRUCTIONS; -- added for 2766005
898:
899: -- QUOTING changes
900: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_TRANSACTION_PHASE THEN
901: IF OE_Code_Control.Code_Release_Level >= '110510' THEN
902: TRANSACTION_PHASE;
903: END IF;
904: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SOLD_TO_SITE_USE THEN

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

900: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_TRANSACTION_PHASE THEN
901: IF OE_Code_Control.Code_Release_Level >= '110510' THEN
902: TRANSACTION_PHASE;
903: END IF;
904: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SOLD_TO_SITE_USE THEN
905: IF OE_Code_Control.Code_Release_Level >= '110510' THEN
906: SOLD_TO_SITE_USE;
907: END IF;
908: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_QUOTE_DATE THEN

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

904: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SOLD_TO_SITE_USE THEN
905: IF OE_Code_Control.Code_Release_Level >= '110510' THEN
906: SOLD_TO_SITE_USE;
907: END IF;
908: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_QUOTE_DATE THEN
909: IF OE_Code_Control.Code_Release_Level >= '110510' THEN
910: QUOTE_DATE;
911: END IF;
912: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_ORDERED_DATE THEN

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

908: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_QUOTE_DATE THEN
909: IF OE_Code_Control.Code_Release_Level >= '110510' THEN
910: QUOTE_DATE;
911: END IF;
912: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_ORDERED_DATE THEN
913: IF OE_Code_Control.Code_Release_Level >= '110510' THEN
914: ORDERED_DATE;
915: END IF;
916: -- QUOTING changes END

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

914: ORDERED_DATE;
915: END IF;
916: -- QUOTING changes END
917: -- Distributed orders @
918: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_END_CUSTOMER THEN
919: END_CUSTOMER;
920: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_END_CUSTOMER_CONTACT THEN
921: END_CUSTOMER_CONTACT;
922: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_END_CUSTOMER_SITE_USE THEN

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

916: -- QUOTING changes END
917: -- Distributed orders @
918: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_END_CUSTOMER THEN
919: END_CUSTOMER;
920: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_END_CUSTOMER_CONTACT THEN
921: END_CUSTOMER_CONTACT;
922: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_END_CUSTOMER_SITE_USE THEN
923: END_CUSTOMER_SITE_USE;
924: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_ORDER_FIRMED_DATE THEN --Key Transaction Dates

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

918: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_END_CUSTOMER THEN
919: END_CUSTOMER;
920: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_END_CUSTOMER_CONTACT THEN
921: END_CUSTOMER_CONTACT;
922: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_END_CUSTOMER_SITE_USE THEN
923: END_CUSTOMER_SITE_USE;
924: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_ORDER_FIRMED_DATE THEN --Key Transaction Dates
925: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110509' THEN
926: order_firmed_date;

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

920: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_END_CUSTOMER_CONTACT THEN
921: END_CUSTOMER_CONTACT;
922: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_END_CUSTOMER_SITE_USE THEN
923: END_CUSTOMER_SITE_USE;
924: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_ORDER_FIRMED_DATE THEN --Key Transaction Dates
925: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110509' THEN
926: order_firmed_date;
927: END IF;
928: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_BLANKET_NUMBER THEN ---bug 8517526

Line 928: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_BLANKET_NUMBER THEN ---bug 8517526

924: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_ORDER_FIRMED_DATE THEN --Key Transaction Dates
925: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110509' THEN
926: order_firmed_date;
927: END IF;
928: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_BLANKET_NUMBER THEN ---bug 8517526
929: BLANKET_NUMBER; ---bug 8517526
930: END IF;
931: END LOOP;
932: END IF;

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

930: END IF;
931: END LOOP;
932: END IF;
933:
934: oe_debug_pub.add('Exiting OE_HEADER_UTIL.Clear_Dependent',1);
935:
936: EXCEPTION
937:
938: WHEN FND_API.G_EXC_ERROR THEN

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

1546: l_index NUMBER :=0;
1547: l_src_attr_tbl OE_GLOBALS.NUMBER_Tbl_Type;
1548: BEGIN
1549:
1550: oe_debug_pub.add('Entering OE_HEADER_UTIL.CLEAR_DEPENDENT_ATTR', 1);
1551:
1552: IF p_attr_id <> FND_API.G_MISS_NUM THEN
1553:
1554: l_index := l_index + 1.0;

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

1561:
1562: IF NOT OE_GLOBALS.Equal(p_x_header_rec.agreement_id,p_old_header_rec.agreement_id)
1563: THEN
1564: l_index := l_index + 1.0;
1565: l_src_attr_tbl(l_index) := OE_HEADER_UTIL.G_AGREEMENT;
1566: END IF;
1567:
1568: IF NOT OE_GLOBALS.Equal(p_x_header_rec.deliver_to_org_id,p_old_header_rec.deliver_to_org_id)
1569: THEN

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

1567:
1568: IF NOT OE_GLOBALS.Equal(p_x_header_rec.deliver_to_org_id,p_old_header_rec.deliver_to_org_id)
1569: THEN
1570: l_index := l_index + 1.0;
1571: l_src_attr_tbl(l_index) := OE_HEADER_UTIL.G_DELIVER_TO_ORG;
1572: END IF;
1573:
1574: IF NOT OE_GLOBALS.Equal(p_x_header_rec.invoice_to_contact_id,p_old_header_rec.invoice_to_contact_id)
1575: THEN

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

1573:
1574: IF NOT OE_GLOBALS.Equal(p_x_header_rec.invoice_to_contact_id,p_old_header_rec.invoice_to_contact_id)
1575: THEN
1576: l_index := l_index + 1.0;
1577: l_src_attr_tbl(l_index) := OE_HEADER_UTIL.G_INVOICE_TO_CONTACT;
1578: END IF;
1579:
1580: IF NOT OE_GLOBALS.Equal(p_x_header_rec.invoice_to_org_id,p_old_header_rec.invoice_to_org_id)
1581: THEN

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

1579:
1580: IF NOT OE_GLOBALS.Equal(p_x_header_rec.invoice_to_org_id,p_old_header_rec.invoice_to_org_id)
1581: THEN
1582: l_index := l_index + 1.0;
1583: l_src_attr_tbl(l_index) := OE_HEADER_UTIL.G_INVOICE_TO_ORG;
1584: END IF;
1585:
1586: IF NOT OE_GLOBALS.Equal(p_x_header_rec.ordered_date,p_old_header_rec.ordered_date)
1587: THEN

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

1585:
1586: IF NOT OE_GLOBALS.Equal(p_x_header_rec.ordered_date,p_old_header_rec.ordered_date)
1587: THEN
1588: l_index := l_index + 1.0;
1589: l_src_attr_tbl(l_index) := OE_HEADER_UTIL.G_ORDERED_DATE;
1590: END IF;
1591:
1592: IF NOT OE_GLOBALS.Equal(p_x_header_rec.order_type_id,p_old_header_rec.order_type_id)
1593: THEN

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

1591:
1592: IF NOT OE_GLOBALS.Equal(p_x_header_rec.order_type_id,p_old_header_rec.order_type_id)
1593: THEN
1594: l_index := l_index + 1.0;
1595: l_src_attr_tbl(l_index) := OE_HEADER_UTIL.G_ORDER_TYPE;
1596: END IF;
1597:
1598: IF NOT OE_GLOBALS.Equal(p_x_header_rec.payment_type_code,p_old_header_rec.payment_type_code)
1599: THEN

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

1597:
1598: IF NOT OE_GLOBALS.Equal(p_x_header_rec.payment_type_code,p_old_header_rec.payment_type_code)
1599: THEN
1600: l_index := l_index + 1.0;
1601: l_src_attr_tbl(l_index) := OE_HEADER_UTIL.G_PAYMENT_TYPE;
1602: END IF;
1603:
1604: /* Fix Bug # 2297053: Clear attributes dependent on Credit Card Number */
1605: IF NOT OE_GLOBALS.Is_Same_Credit_Card(p_old_header_rec.credit_card_number,p_x_header_rec.credit_card_number,

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

1605: IF NOT OE_GLOBALS.Is_Same_Credit_Card(p_old_header_rec.credit_card_number,p_x_header_rec.credit_card_number,
1606: p_old_instrument_id,p_x_instrument_id)
1607: THEN
1608: l_index := l_index + 1.0;
1609: l_src_attr_tbl(l_index) := OE_HEADER_UTIL.G_CREDIT_CARD_NUMBER;
1610: END IF;
1611:
1612: IF NOT OE_GLOBALS.Equal(p_x_header_rec.price_list_id,p_old_header_rec.price_list_id)
1613: THEN

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

1611:
1612: IF NOT OE_GLOBALS.Equal(p_x_header_rec.price_list_id,p_old_header_rec.price_list_id)
1613: THEN
1614: l_index := l_index + 1.0;
1615: l_src_attr_tbl(l_index) := OE_HEADER_UTIL.G_PRICE_LIST;
1616: END IF;
1617:
1618: IF NOT OE_GLOBALS.Equal(p_x_header_rec.request_date,p_old_header_rec.request_date)
1619: THEN

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

1617:
1618: IF NOT OE_GLOBALS.Equal(p_x_header_rec.request_date,p_old_header_rec.request_date)
1619: THEN
1620: l_index := l_index + 1.0;
1621: l_src_attr_tbl(l_index) := OE_HEADER_UTIL.G_REQUEST_DATE;
1622: END IF;
1623:
1624: IF NOT OE_GLOBALS.Equal(p_x_header_rec.ship_from_org_id,p_old_header_rec.ship_from_org_id)
1625: THEN

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

1623:
1624: IF NOT OE_GLOBALS.Equal(p_x_header_rec.ship_from_org_id,p_old_header_rec.ship_from_org_id)
1625: THEN
1626: l_index := l_index + 1.0;
1627: l_src_attr_tbl(l_index) := OE_HEADER_UTIL.G_SHIP_FROM_ORG;
1628: END IF;
1629:
1630: IF NOT OE_GLOBALS.Equal(p_x_header_rec.ship_to_contact_id,p_old_header_rec.ship_to_contact_id)
1631: THEN

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

1629:
1630: IF NOT OE_GLOBALS.Equal(p_x_header_rec.ship_to_contact_id,p_old_header_rec.ship_to_contact_id)
1631: THEN
1632: l_index := l_index + 1.0;
1633: l_src_attr_tbl(l_index) := OE_HEADER_UTIL.G_SHIP_TO_CONTACT;
1634: END IF;
1635:
1636: IF NOT OE_GLOBALS.Equal(p_x_header_rec.ship_to_org_id,p_old_header_rec.ship_to_org_id)
1637: THEN

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

1635:
1636: IF NOT OE_GLOBALS.Equal(p_x_header_rec.ship_to_org_id,p_old_header_rec.ship_to_org_id)
1637: THEN
1638: l_index := l_index + 1.0;
1639: l_src_attr_tbl(l_index) := OE_HEADER_UTIL.G_SHIP_TO_ORG;
1640: END IF;
1641:
1642: IF NOT OE_GLOBALS.Equal(p_x_header_rec.sold_to_org_id,p_old_header_rec.sold_to_org_id)
1643: THEN

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

1641:
1642: IF NOT OE_GLOBALS.Equal(p_x_header_rec.sold_to_org_id,p_old_header_rec.sold_to_org_id)
1643: THEN
1644: l_index := l_index + 1.0;
1645: l_src_attr_tbl(l_index) := OE_HEADER_UTIL.G_SOLD_TO_ORG;
1646: END IF;
1647:
1648: IF NOT OE_GLOBALS.Equal(p_x_header_rec.sold_to_phone_id,p_old_header_rec.sold_to_phone_id)
1649: THEN

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

1647:
1648: IF NOT OE_GLOBALS.Equal(p_x_header_rec.sold_to_phone_id,p_old_header_rec.sold_to_phone_id)
1649: THEN
1650: l_index := l_index + 1.0;
1651: l_src_attr_tbl(l_index) := OE_HEADER_UTIL.G_SOLD_TO_PHONE;
1652: END IF;
1653:
1654: IF NOT OE_GLOBALS.Equal(p_x_header_rec.tax_exempt_flag,p_old_header_rec.tax_exempt_flag)
1655: THEN

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

1653:
1654: IF NOT OE_GLOBALS.Equal(p_x_header_rec.tax_exempt_flag,p_old_header_rec.tax_exempt_flag)
1655: THEN
1656: l_index := l_index + 1.0;
1657: l_src_attr_tbl(l_index) := OE_HEADER_UTIL.G_TAX_EXEMPT;
1658: END IF;
1659:
1660: IF NOT OE_GLOBALS.Equal(p_x_header_rec.transactional_curr_code,p_old_header_rec.transactional_curr_code)
1661: THEN

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

1659:
1660: IF NOT OE_GLOBALS.Equal(p_x_header_rec.transactional_curr_code,p_old_header_rec.transactional_curr_code)
1661: THEN
1662: l_index := l_index + 1.0;
1663: l_src_attr_tbl(l_index) := OE_HEADER_UTIL.G_TRANSACTIONAL_CURR;
1664: END IF;
1665:
1666: IF NOT OE_GLOBALS.Equal(p_x_header_rec.blanket_number,p_old_header_rec.blanket_number)
1667: THEN

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

1665:
1666: IF NOT OE_GLOBALS.Equal(p_x_header_rec.blanket_number,p_old_header_rec.blanket_number)
1667: THEN
1668: l_index := l_index + 1.0;
1669: l_src_attr_tbl(l_index) := OE_HEADER_UTIL.G_BLANKET_NUMBER;
1670: END IF;
1671:
1672: -- QUOTING changes
1673: IF NOT OE_GLOBALS.Equal(p_x_header_rec.transaction_phase_code,p_old_header_rec.transaction_phase_code)

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

1672: -- QUOTING changes
1673: IF NOT OE_GLOBALS.Equal(p_x_header_rec.transaction_phase_code,p_old_header_rec.transaction_phase_code)
1674: THEN
1675: l_index := l_index + 1.0;
1676: l_src_attr_tbl(l_index) := OE_HEADER_UTIL.G_TRANSACTION_PHASE;
1677: END IF;
1678: -- QUOTING changes END
1679:
1680: --distributed order @

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

1680: --distributed order @
1681: IF NOT OE_GLOBALS.Equal(p_x_header_rec.end_customer_id,p_old_header_rec.end_customer_id)
1682: THEN
1683: l_index := l_index + 1.0;
1684: l_src_attr_tbl(l_index) := OE_HEADER_UTIL.G_END_CUSTOMER;
1685: END IF;
1686:
1687: -- bug 5127922
1688: IF NOT OE_GLOBALS.Equal(p_x_header_rec.sold_to_site_use_id,p_old_header_rec.sold_to_site_use_id)

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

1687: -- bug 5127922
1688: IF NOT OE_GLOBALS.Equal(p_x_header_rec.sold_to_site_use_id,p_old_header_rec.sold_to_site_use_id)
1689: THEN
1690: l_index := l_index + 1.0;
1691: l_src_attr_tbl(l_index) := OE_HEADER_UTIL.G_SOLD_TO_SITE_USE;
1692: END IF;
1693:
1694: END IF;
1695:

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

1705: --can be cleared during the future calls when the cc is not selected
1706: --from the LOV.
1707: g_is_cc_selected_from_LOV := 'N';
1708:
1709: oe_debug_pub.add('Exiting OE_HEADER_UTIL.CLEAR_DEPENDENT_ATTR', 1);
1710:
1711: EXCEPTION
1712: WHEN FND_API.G_EXC_ERROR THEN
1713: RAISE FND_API.G_EXC_ERROR;

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

1801: -- ER#3667551 end
1802:
1803: BEGIN
1804:
1805: oe_debug_pub.add('Entering OE_HEADER_UTIL.APPLY_ATTRIBUTE_CHANGES', 1);
1806:
1807: -- Load out record
1808:
1809: IF NOT OE_GLOBALS.Equal(p_x_header_rec.booked_flag,p_old_header_rec.booked_flag)

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

2522: THEN
2523: OE_Schedule_Util.G_DATE_TYPE := p_x_header_rec.order_date_type_code; END IF;
2524: END IF;
2525: /*-- 3288805 --*/
2526: oe_debug_pub.add('Exiting OE_HEADER_UTIL.APPLY_ATTRIBUTE_CHANGES', 1);
2527:
2528: END Apply_Attribute_Changes;
2529:
2530: -- Procedure Complete_Record

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

2536: IS
2537:
2538: BEGIN
2539:
2540: oe_debug_pub.add('Entering OE_HEADER_UTIL.COMPLETE_RECORD', 1);
2541:
2542: IF p_x_header_rec.accounting_rule_id = FND_API.G_MISS_NUM THEN
2543: p_x_header_rec.accounting_rule_id := p_old_header_rec.accounting_rule_id;
2544: END IF;

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

3264:
3265: --8219019 end
3266:
3267:
3268: oe_debug_pub.add('Exiting OE_HEADER_UTIL.COMPLETE_RECORD', 1);
3269:
3270:
3271: END Complete_Record;
3272:

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

3278: IS
3279: --p_x_header_rec OE_Order_PUB.Header_Rec_Type := p_header_rec;
3280: BEGIN
3281:
3282: oe_debug_pub.add('Entering OE_HEADER_UTIL.CONVERT_MISS_TO_NULL', 1);
3283:
3284: IF p_x_header_rec.accounting_rule_id = FND_API.G_MISS_NUM THEN
3285: p_x_header_rec.accounting_rule_id := NULL;
3286: END IF;

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

3934: END IF;
3935:
3936: --8219019 end
3937:
3938: oe_debug_pub.add('Exiting OE_HEADER_UTIL.CONVERT_MISS_TO_NULL', 1);
3939:
3940:
3941: END Convert_Miss_To_Null;
3942:

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

3952: l_index NUMBER;
3953: l_return_status VARCHAR2(1);
3954: BEGIN
3955:
3956: oe_debug_pub.add('Entering OE_HEADER_UTIL.UPDATE_ROW', 1);
3957: --Commented for MOAC start
3958: /*l_org_id := OE_GLOBALS.G_ORG_ID;
3959:
3960: IF l_org_id IS NULL THEN

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

3980: p_header_id => p_header_rec.header_id,
3981: x_index => l_index,
3982: x_return_status => l_return_status);
3983:
3984: OE_DEBUG_PUB.ADD('Update_Global Return Status from OE_HEADER_UTIL.update_row is: ' || l_return_status);
3985: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3986: OE_DEBUG_PUB.ADD('EVENT NOTIFY - Unexpected Error');
3987: OE_DEBUG_PUB.ADD('Exiting OE_HEADER_UTIL.Update_ROW', 1);
3988: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

3983:
3984: OE_DEBUG_PUB.ADD('Update_Global Return Status from OE_HEADER_UTIL.update_row is: ' || l_return_status);
3985: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3986: OE_DEBUG_PUB.ADD('EVENT NOTIFY - Unexpected Error');
3987: OE_DEBUG_PUB.ADD('Exiting OE_HEADER_UTIL.Update_ROW', 1);
3988: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3989: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3990: OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_HEADER_UTIL.Update_row');
3991: OE_DEBUG_PUB.ADD('Exiting OE_HEADER_UTIL.Update_ROW', 1);

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

3986: OE_DEBUG_PUB.ADD('EVENT NOTIFY - Unexpected Error');
3987: OE_DEBUG_PUB.ADD('Exiting OE_HEADER_UTIL.Update_ROW', 1);
3988: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3989: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3990: OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_HEADER_UTIL.Update_row');
3991: OE_DEBUG_PUB.ADD('Exiting OE_HEADER_UTIL.Update_ROW', 1);
3992: RAISE FND_API.G_EXC_ERROR;
3993: END IF;
3994: END IF; /*code_release_level*/

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

3987: OE_DEBUG_PUB.ADD('Exiting OE_HEADER_UTIL.Update_ROW', 1);
3988: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3989: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3990: OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_HEADER_UTIL.Update_row');
3991: OE_DEBUG_PUB.ADD('Exiting OE_HEADER_UTIL.Update_ROW', 1);
3992: RAISE FND_API.G_EXC_ERROR;
3993: END IF;
3994: END IF; /*code_release_level*/
3995: -- notification framework end

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

4193: -- to call below procedure to update, updated directly above
4194:
4195: -- OE_Order_Cache.Set_Order_Header(p_header_rec);
4196:
4197: oe_debug_pub.add('Exiting OE_HEADER_UTIL.UPDATE_ROW', 1);
4198:
4199: EXCEPTION
4200:
4201: WHEN OTHERS THEN

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

4225: l_return_status VARCHAR2(1);
4226: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4227: BEGIN
4228:
4229: oe_debug_pub.add('Entering OE_HEADER_UTIL.INSERT_ROW', 1);
4230:
4231: --MOAC change
4232: OE_GLOBALS.Set_Context;
4233: l_org_id := OE_GLOBALS.G_ORG_ID;

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

4624: p_Header_rec =>p_header_rec,
4625: p_header_id => p_header_rec.header_id,
4626: x_index => l_index,
4627: x_return_status => l_return_status);
4628: OE_DEBUG_PUB.ADD('Update_Global Return Status from OE_HEADER_UTIL.insert_row is: ' || l_return_status);
4629: OE_DEBUG_PUB.ADD('returned index is: ' || l_index ,1);
4630: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4631: OE_DEBUG_PUB.ADD('EVENT NOTIFY - Unexpected Error');
4632: OE_DEBUG_PUB.ADD('Exiting OE_HEADER_UTIL.INSERT_ROW', 1);

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

4628: OE_DEBUG_PUB.ADD('Update_Global Return Status from OE_HEADER_UTIL.insert_row is: ' || l_return_status);
4629: OE_DEBUG_PUB.ADD('returned index is: ' || l_index ,1);
4630: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4631: OE_DEBUG_PUB.ADD('EVENT NOTIFY - Unexpected Error');
4632: OE_DEBUG_PUB.ADD('Exiting OE_HEADER_UTIL.INSERT_ROW', 1);
4633: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4634: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4635: OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_HEADER_UTIL.Insert_row');
4636: OE_DEBUG_PUB.ADD('Exiting OE_HEADER_UTIL.INSERT_ROW', 1);

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

4631: OE_DEBUG_PUB.ADD('EVENT NOTIFY - Unexpected Error');
4632: OE_DEBUG_PUB.ADD('Exiting OE_HEADER_UTIL.INSERT_ROW', 1);
4633: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4634: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4635: OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_HEADER_UTIL.Insert_row');
4636: OE_DEBUG_PUB.ADD('Exiting OE_HEADER_UTIL.INSERT_ROW', 1);
4637: RAISE FND_API.G_EXC_ERROR;
4638: END IF;
4639: END IF; /*code_release_level*/

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

4632: OE_DEBUG_PUB.ADD('Exiting OE_HEADER_UTIL.INSERT_ROW', 1);
4633: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4634: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4635: OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_HEADER_UTIL.Insert_row');
4636: OE_DEBUG_PUB.ADD('Exiting OE_HEADER_UTIL.INSERT_ROW', 1);
4637: RAISE FND_API.G_EXC_ERROR;
4638: END IF;
4639: END IF; /*code_release_level*/
4640: -- notification framework end

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

4638: END IF;
4639: END IF; /*code_release_level*/
4640: -- notification framework end
4641:
4642: oe_debug_pub.add('Exiting OE_HEADER_UTIL.INSERT_ROW', 1);
4643:
4644: EXCEPTION
4645:
4646: WHEN OTHERS THEN

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

4675: l_msg_count NUMBER;
4676: l_msg_data VARCHAR2(2000);
4677: BEGIN
4678:
4679: oe_debug_pub.add('Entering OE_HEADER_UTIL.DELETE_ROW', 1);
4680: --Commented for MOAC start
4681: /*l_org_id := OE_GLOBALS.G_ORG_ID;
4682: IF l_org_id IS NULL THEN
4683: OE_GLOBALS.Set_Context;

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

4694: p_Header_rec =>l_new_header_rec,
4695: p_header_id => p_header_id,
4696: x_index => l_index,
4697: x_return_status => l_return_status);
4698: OE_DEBUG_PUB.ADD('Update_Global Return Status from OE_HEADER_UTIL.delete_row is: ' || l_return_status);
4699:
4700: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4701: OE_DEBUG_PUB.ADD('EVENT NOTIFY - Unexpected Error');
4702: OE_DEBUG_PUB.ADD('Exiting OE_HEADER_UTIL.DELETE_ROW', 1);

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

4698: OE_DEBUG_PUB.ADD('Update_Global Return Status from OE_HEADER_UTIL.delete_row is: ' || l_return_status);
4699:
4700: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4701: OE_DEBUG_PUB.ADD('EVENT NOTIFY - Unexpected Error');
4702: OE_DEBUG_PUB.ADD('Exiting OE_HEADER_UTIL.DELETE_ROW', 1);
4703: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4704: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4705: OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_HEADER_UTIL.Delete_row');
4706: OE_DEBUG_PUB.ADD('Exiting OE_HEADER_UTIL.DELETE_ROW', 1);

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

4701: OE_DEBUG_PUB.ADD('EVENT NOTIFY - Unexpected Error');
4702: OE_DEBUG_PUB.ADD('Exiting OE_HEADER_UTIL.DELETE_ROW', 1);
4703: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4704: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4705: OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_HEADER_UTIL.Delete_row');
4706: OE_DEBUG_PUB.ADD('Exiting OE_HEADER_UTIL.DELETE_ROW', 1);
4707: RAISE FND_API.G_EXC_ERROR;
4708: END IF;
4709: END IF; /* code_release_level*/

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

4702: OE_DEBUG_PUB.ADD('Exiting OE_HEADER_UTIL.DELETE_ROW', 1);
4703: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4704: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4705: OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_HEADER_UTIL.Delete_row');
4706: OE_DEBUG_PUB.ADD('Exiting OE_HEADER_UTIL.DELETE_ROW', 1);
4707: RAISE FND_API.G_EXC_ERROR;
4708: END IF;
4709: END IF; /* code_release_level*/
4710: -- notification framework end

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

4734: , p_ret_price_request_code => NULL
4735: , p_returned_qty => NULL
4736: , p_line_id => NULL
4737: );
4738: oe_debug_pub.add('Request to Reverse_Limits in OE_HEADER_UTIL.Delete_Row is done',1);
4739: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4740: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4741: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4742: RAISE FND_API.G_EXC_ERROR;

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

4800: /* AND
4801: (NVL(ORG_ID,NVL(l_org_id,0))= NVL(l_org_id,0))
4802: ;*/
4803:
4804: oe_debug_pub.add('Exiting OE_HEADER_UTIL.DELETE_ROW', 1);
4805:
4806: EXCEPTION
4807: WHEN FND_API.G_EXC_ERROR THEN
4808: --takintoy, added for delete articles

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

5005: l_return_status VARCHAR2(1);
5006: BEGIN
5007:
5008: if l_debug_level > 0 then
5009: oe_debug_pub.add('Entering OE_HEADER_UTIL.QUERY_ROW', 1);
5010: end if;
5011: --Commented for MOAC start
5012: /*l_org_id := OE_GLOBALS.G_ORG_ID;
5013: IF l_org_id IS NULL THEN

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

5428:
5429: -- aksingh assigning the global record, so later the cached record
5430: -- will be used instead of querying again
5431: if l_debug_level > 0 then
5432: oe_debug_pub.add('Before caching OE_HEADER_UTIL.QUERY_ROW', 1);
5433: end if;
5434:
5435: oe_order_cache.g_header_rec := x_header_rec;
5436: oe_order_cache.g_header_rec.operation := null;

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

5435: oe_order_cache.g_header_rec := x_header_rec;
5436: oe_order_cache.g_header_rec.operation := null;
5437:
5438: if l_debug_level > 0 then
5439: oe_debug_pub.add('Exiting OE_HEADER_UTIL.QUERY_ROW', 1);
5440: end if;
5441:
5442:
5443: EXCEPTION

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

5474: l_lock_control NUMBER;
5475: l_db_lock_control NUMBER;
5476: BEGIN
5477:
5478: oe_debug_pub.add('Entering OE_HEADER_UTIL.LOCK_ROW', 1);
5479:
5480: SAVEPOINT Lock_Row;
5481:
5482: l_lock_control := NULL;

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

5502: p_x_header_rec.lock_control := -1;
5503: END IF;
5504: -- End of the fix 2436046 }
5505:
5506: OE_Header_Util.Query_Row(p_header_id => l_header_id,
5507: x_header_rec => p_x_header_rec);
5508:
5509: oe_debug_pub.add('selected for update, now compare', 3);
5510:

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

5569: END IF;
5570:
5571: END IF;
5572:
5573: oe_debug_pub.add('Exiting OE_HEADER_UTIL.LOCK_ROW', 1);
5574:
5575: OE_GLOBALS.G_LOCK_TEST := 'N';
5576: EXCEPTION
5577:

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

5637: l_msg_count NUMBER;
5638: l_msg_data VARCHAR2(2000);
5639: BEGIN
5640:
5641: oe_debug_pub.add('Entering OE_HEADER_UTIL.GET_VALUES', 1);
5642:
5643: l_header_val_rec := OE_Order_PUB.G_MISS_HEADER_VAL_REC;
5644:
5645: IF (p_header_rec.accounting_rule_id IS NULL OR

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

6157: );
6158:
6159: END IF;
6160:
6161: oe_debug_pub.add('Exiting OE_HEADER_UTIL.GET_VALUES', 1);
6162:
6163: RETURN l_header_val_rec;
6164:
6165: END Get_Values;

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

6176: l_invoice_to_org_id NUMBER;
6177: l_deliver_to_org_id NUMBER;
6178: BEGIN
6179:
6180: oe_debug_pub.add('Entering OE_HEADER_UTIL.GET_IDS', 1);
6181:
6182:
6183: IF p_header_val_rec.accounting_rule <> FND_API.G_MISS_CHAR
6184: THEN

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

7546: ----------------------------------------------------------------------
7547: -- End of get IDs for customer related fields
7548: ----------------------------------------------------------------------
7549:
7550: oe_debug_pub.add('Exiting OE_HEADER_UTIL.GET_IDS', 1);
7551:
7552: END Get_Ids;
7553:
7554:

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

7574: x_result NUMBER;
7575:
7576: BEGIN
7577:
7578: oe_debug_pub.add('Entering OE_HEADER_UTIL.Get_Ord_Seq_Type',1);
7579:
7580: IF p_order_type_id IS NULL OR
7581: p_order_type_id = FND_API.G_MISS_NUM
7582: THEN

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

7616: IF x_result <> 0 THEN
7617: RAISE FND_API.G_EXC_ERROR;
7618: END IF;
7619:
7620: oe_debug_pub.add('Exiting OE_HEADER_UTIL.Get_Ord_Seq_Type',1);
7621:
7622: RETURN x_doc_sequence_type;
7623:
7624: EXCEPTION

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

7647: BEGIN
7648:
7649: --Commenting the oe_debug_pub call to fix bug 2105266.
7650:
7651: -- oe_debug_pub.add('Entering OE_HEADER_UTIL.Get_Order_Info',1);
7652:
7653: BEGIN
7654: SELECT order_number,order_type_id
7655: INTO l_order_number,l_order_type_id

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

7677: WHEN NO_DATA_FOUND THEN
7678: x_order_type := NULL;
7679: END;
7680:
7681: -- oe_debug_pub.add('Exiting OE_HEADER_UTIL.Get_Order_Info',1);
7682:
7683: END Get_Order_Info;
7684:
7685: FUNCTION Get_Header_Id (p_order_number IN NUMBER,

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

7774: lcount NUMBER;
7775: x_result NUMBER;
7776:
7777: BEGIN
7778: oe_debug_pub.add('Entering OE_HEADER_UTIL.Get_Order_Number',1);
7779: oe_debug_pub.add('Entering OE_HEADER_UTIL.Get_Order_Number',1);
7780: -- Check if Order Number can be updated or not???? bug 4146258
7781: -- Fixed by Srini
7782: IF NOT OE_GLOBALS.EQUAL(p_x_header_rec.order_number,

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

7775: x_result NUMBER;
7776:
7777: BEGIN
7778: oe_debug_pub.add('Entering OE_HEADER_UTIL.Get_Order_Number',1);
7779: oe_debug_pub.add('Entering OE_HEADER_UTIL.Get_Order_Number',1);
7780: -- Check if Order Number can be updated or not???? bug 4146258
7781: -- Fixed by Srini
7782: IF NOT OE_GLOBALS.EQUAL(p_x_header_rec.order_number,
7783: p_old_header_rec.order_number)

Line 8254: /* Oe_Header_Util.get_order_number(p_x_header_rec => p_x_header_rec,p_old_header_rec => p_old_header_rec);*/

8250: END IF;
8251: END IF;
8252: -- Included to fix bug 1589196 End
8253:
8254: /* Oe_Header_Util.get_order_number(p_x_header_rec => p_x_header_rec,p_old_header_rec => p_old_header_rec);*/
8255: --Commented for bug#13081490.Moved this call to after completion of Shipping Method validation.
8256:
8257:
8258: -- Call Cancellation Related Code

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

8272: -- When the order header level cancellation is triggered, and all the
8273: -- order lines are successfully cancelled, we should log a delayed request
8274: -- G_UPDATE_REQUISITION to call the Purchasing API so as to trigger the
8275: -- requisition header cancellation. For this, we need to log the delayed
8276: -- requests from Pre_Write_Process procedure of OE_Header_Util package.
8277: -- In this procedure, we need to raise this delayed request only after
8278: -- successful execution of OE_Sales_Can_Util.Perform_Cancel_Order API,
8279: -- which is responsible for canceling both order header and all order
8280: -- lines. This code will be triggered in the event of Full Order

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

8569: END IF;
8570: END IF;
8571: END IF;
8572: END IF;
8573: Oe_Header_Util.get_order_number(p_x_header_rec => p_x_header_rec,
8574: p_old_header_rec => p_old_header_rec); --Added for bug 13081490
8575:
8576:
8577: -- Log delayed request to create automatic attachments

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

8923: L_DOWNPAYMENT number;
8924: l_line_payment_count NUMBER;
8925: --bug 5258767
8926: BEGIN
8927: oe_debug_pub.add('Entering OE_HEADER_UTIL.Post_Write_Process',1);
8928:
8929: -- Added call to new procedure eval_post_write_header for performance
8930: -- and to be consistent with evalualte_post_write for lines.
8931: -- See bug#1777317

Line 9175: OE_HEADER_UTIL.g_rollback_done := 'N';

9171:
9172: -- OE_GLOBALS.G_RECURSION_MODE := 'Y';
9173: -- SAVEPOINT added for Bug 12759791
9174: SAVEPOINT LINES_IN_HPOST_WRITE ;
9175: OE_HEADER_UTIL.g_rollback_done := 'N';
9176:
9177: OE_Order_PVT.Lines
9178: ( p_validation_level => FND_API.G_VALID_LEVEL_NONE
9179: , p_control_rec => l_control_rec

Line 9189: OE_HEADER_UTIL.g_rollback_done := 'Y'; -- Bug 12759791

9185: -- OE_GLOBALS.G_RECURSION_MODE := 'N';
9186:
9187: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
9188: ROLLBACK TO SAVEPOINT LINES_IN_HPOST_WRITE; -- Bug 12759791
9189: OE_HEADER_UTIL.g_rollback_done := 'Y'; -- Bug 12759791
9190: RAISE FND_API.G_EXC_ERROR;
9191: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
9192: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9193: END IF;

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

9281: );
9282:
9283: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
9284: if l_debug_level > 0 then
9285: oe_debug_pub.ADD('OE_Header_Util.Post_Write unexp error in instantiate doc terms',1);
9286: end if;
9287: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9288: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
9289: if l_debug_level > 0 then

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

9286: end if;
9287: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9288: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
9289: if l_debug_level > 0 then
9290: oe_debug_pub.ADD('OE_Header_Util.Post_Write exp error in instantiate doc terms',1);
9291: end if;
9292: RAISE FND_API.G_EXC_ERROR;
9293: END IF;
9294:

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

9566: oe_debug_pub.add('Success in Header Payments call...');
9567: END IF;
9568: END IF;
9569: --R12 CC Encryption
9570: oe_debug_pub.add('Exiting OE_HEADER_UTIL.Post_Write_Process',1);
9571: EXCEPTION
9572: WHEN FND_API.G_EXC_ERROR THEN
9573: RAISE FND_API.G_EXC_ERROR;
9574: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 9953: oe_debug_pub.add('Entering OE_HEADER_UTIL.Get_customer_info_ids :'||p_header_customer_info_tbl.count);

9949:
9950: x_return_status := FND_API.G_RET_STS_SUCCESS;
9951:
9952: IF l_debug_level >0 then
9953: oe_debug_pub.add('Entering OE_HEADER_UTIL.Get_customer_info_ids :'||p_header_customer_info_tbl.count);
9954: End IF;
9955:
9956: OE_CUSTOMER_INFO_PVT.G_SOLD_TO_CUSTOMER_ID := NULL;
9957:

Line 10121: oe_debug_pub.add('Exiting OE_HEADER_UTIL.Get_customer_info_ids');

10117: oe_debug_pub.add('p_x_header_rec.ship_to_contact_id :' ||p_x_header_rec.ship_to_contact_id);
10118: oe_debug_pub.add('p_x_header_rec.invoice_to_contact_id :' ||p_x_header_rec.invoice_to_contact_id);
10119: oe_debug_pub.add('p_x_header_rec.deliver_to_contact_id :' ||p_x_header_rec.deliver_to_contact_id);
10120:
10121: oe_debug_pub.add('Exiting OE_HEADER_UTIL.Get_customer_info_ids');
10122: End IF;
10123:
10124:
10125: EXCEPTION

Line 10183: END OE_Header_Util;

10179: WHEN TOO_MANY_ROWS THEN
10180: RETURN NULL;
10181: END;
10182:
10183: END OE_Header_Util;