DBA Data[Home] [Help]

APPS.OE_VALIDATE SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 22

    FND_API.g_attr_tbl.DELETE;
Line: 73

    FND_API.g_attr_tbl(I).name     := 'last_updated_by';
Line: 75

    FND_API.g_attr_tbl(I).name     := 'last_update_date';
Line: 77

    FND_API.g_attr_tbl(I).name     := 'last_update_login';
Line: 107

    FND_API.g_attr_tbl(I).name     := 'program_update_date';
Line: 184

    FND_API.g_attr_tbl(I).name     := 'updated_flag';
Line: 186

    FND_API.g_attr_tbl(I).name     := 'update_allowed';
Line: 189

    FND_API.g_attr_tbl(I).name     := 'dw_update_advice';
Line: 199

    FND_API.g_attr_tbl(I).name     := 'wh_update_date';
Line: 649

		OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'HEADER_ID');
Line: 655

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 703

            OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'ORG_ID');
Line: 710

		OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 771

 /*   SELECT  'VALID'
    INTO    l_dummy
    FROM    OE_ORDER_TYPES_V
    WHERE   ORDER_TYPE_ID = p_order_type_id
    AND     SYSDATE BETWEEN NVL( START_DATE_ACTIVE, SYSDATE  )
                    AND     NVL( END_DATE_ACTIVE, SYSDATE );
Line: 791

            OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'ORDER_TYPE_ID');
Line: 798

            OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 856

    				select type into t
      				from FND_DOCUMENT_SEQUENCES
     				where DOC_SEQUENCE_ID = x_doc_sequence_id;
Line: 883

           OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'ORDER_NUMBER');
Line: 890

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 940

            OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'VERSION_NUMBER');
Line: 946

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 995

            OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'EXPIRATION_DATE');
Line: 1001

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 1036

    SELECT  'VALID'
    INTO    l_dummy
    FROM    OE_ORDER_SOURCES
    WHERE   ORDER_SOURCE_ID = p_order_source_id
    AND     ENABLED_FLAG = 'Y';
Line: 1053

		OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'ORDER_SOURCE_ID');
Line: 1059

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 1094

    SELECT  'VALID'
    INTO    l_dummy
    FROM    OE_ORDER_SOURCES
    WHERE   ORDER_SOURCE_ID = p_source_document_type_id
    AND     ENABLED_FLAG = 'Y';
Line: 1109

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SOURCE_DOCUMENT_TYPE_ID');
Line: 1115

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 1151

    SELECT  'VALID'
    INTO    l_dummy
    FROM    OE_LOOKUPS
    WHERE   LOOKUP_CODE = p_source_type_code
    AND     LOOKUP_TYPE = l_lookup_type
    AND     ENABLED_FLAG = 'Y'
    AND     SYSDATE     BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)
                        AND NVL(END_DATE_ACTIVE, SYSDATE);
Line: 1170

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SOURCE_TYPE_CODE');
Line: 1176

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 1226

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SOURCE_DOCUMENT_ID');
Line: 1232

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 1282

            OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'ORIG_SYS_DOCUMENT_REF');
Line: 1288

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 1338

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'DATE_ORDERED');
Line: 1344

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 1393

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'DATE_REQUESTED');
Line: 1399

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 1436

    SELECT  'VALID'
    INTO    l_dummy
    FROM    OE_LOOKUPS
    WHERE   LOOKUP_CODE = p_shipment_priority_code
    AND     LOOKUP_TYPE = l_lookup_type
    AND     ENABLED_FLAG = 'Y'
    AND     SYSDATE     BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)
                        AND NVL(END_DATE_ACTIVE, SYSDATE);
Line: 1456

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SHIPMENT_PRIORITY_CODE');
Line: 1462

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 1497

    SELECT  'VALID'
    INTO    l_dummy
    FROM    OE_FND_COMMON_LOOKUPS_V
    WHERE   LOOKUP_CODE = p_demand_class_code
    AND     LOOKUP_TYPE = l_lookup_type
    AND     APPLICATION_ID = 700
    AND     ENABLED_FLAG = 'Y'
    AND     SYSDATE     BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)
                        AND NVL(END_DATE_ACTIVE, SYSDATE);
Line: 1518

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'DEMAND_CLASS_CODE');
Line: 1524

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 1578

    /*SELECT  'VALID'
    INTO    l_dummy
    FROM    qp_list_headers_vl
    WHERE   list_header_id = p_price_list_id
    and list_type_code in ('PRL', 'AGR') and
	nvl(active_flag,'Y') ='Y';
Line: 1599

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'PRICE_LIST_ID');
Line: 1605

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 1643

    SELECT  'VALID'
    INTO    l_dummy
    FROM    fnd_lookups
    WHERE   LOOKUP_CODE = p_tax_exempt_flag
    AND     LOOKUP_TYPE = l_lookup_type
    AND     ENABLED_FLAG = 'Y'
    AND     SYSDATE     BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)
                        AND NVL(END_DATE_ACTIVE, SYSDATE);
Line: 1662

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'TAX_EXEMPT_FLAG');
Line: 1668

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 1717

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'TAX_EXEMPT_NUMBER');
Line: 1723

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 1760

    SELECT  'VALID'
    INTO    l_dummy
    FROM    fnd_lookups
    WHERE   LOOKUP_CODE = p_tax_exempt_reason_code
    AND     LOOKUP_TYPE = l_lookup_type
    AND     ENABLED_FLAG = 'Y'
    AND     SYSDATE     BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)
                        AND NVL(END_DATE_ACTIVE, SYSDATE);
Line: 1779

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'TAX_EXEMPT_REASON_CODE');
Line: 1785

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 1837

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CONVERSION_RATE');
Line: 1843

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 1888

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CUSTOMER_PREFERENCE_SET_CODE');
Line: 1894

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 1928

    SELECT  'VALID'
    INTO    l_dummy
    FROM    OE_GL_DAILY_CONVERSION_TYPES_V
    WHERE   CONVERSION_TYPE = p_conversion_type_code;
Line: 1943

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CONVERSION_TYPE_CODE');
Line: 1949

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 1997

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CONVERSION_RATE_DATE');
Line: 2003

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 2039

    SELECT  'VALID'
    INTO     l_dummy
    FROM     OE_FND_COMMON_LOOKUPS_V
    WHERE    LOOKUP_CODE = p_partial_shipments_allowed
    AND      LOOKUP_TYPE = l_lookup_type
    AND      SYSDATE BETWEEN NVL(START_DATE_ACTIVE,SYSDATE)
                     AND     NVL(END_DATE_ACTIVE, SYSDATE );
Line: 2058

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'PARTIAL_SHIPMENTS_ALLOWED');
Line: 2064

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 2114

		OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SHIP_TOLERANCE_ABOVE');
Line: 2120

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 2170

		OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SHIP_TOLERANCE_BELOW');
Line: 2176

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 2230

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SHIPPABLE_FLAG');
Line: 2236

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 2290

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SHIPPING_INTERFACED_FLAG');
Line: 2296

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 2346

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SHIPPING_INSTRUCTIONS');
Line: 2352

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 2403

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'PAQCKING_INSTRUCTIONS');
Line: 2409

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 2460

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'UNDER_SHIPMENT_TOLERANCE');
Line: 2466

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 2515

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'OVER_SHIPMENT_TOLERANCE');
Line: 2521

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 2570

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'OVER_RETURN_TOLERANCE');
Line: 2576

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 2625

	    OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'UNDER_RETURN_TOLERANCE');
Line: 2631

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 2666

    SELECT  'VALID'
    INTO    l_dummy
    FROM    OE_FND_CURRENCIES_V
    WHERE   CURRENCY_CODE = p_transactional_curr_code
    AND     CURRENCY_FLAG = 'Y'
    AND     ENABLED_FLAG = 'Y'
    AND     SYSDATE     BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)
                        AND NVL(END_DATE_ACTIVE, SYSDATE);
Line: 2688

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'TRANSACTIONAL_CURR_CODE');
Line: 2694

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 2731

    SELECT  'VALID'
    INTO    l_dummy
    FROM    OE_AGREEMENTS_B  A
    WHERE   A.AGREEMENT_ID = p_agreement_id;
Line: 2749

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'AGREEMENT_ID');
Line: 2755

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 2793

    SELECT  'VALID'
    INTO    l_dummy
    FROM    OE_LOOKUPS
    WHERE   LOOKUP_CODE = p_tax_point_code
    AND     LOOKUP_TYPE = l_lookup_type
    AND     ENABLED_FLAG = 'Y'
    AND     SYSDATE     BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)
                        AND NVL(END_DATE_ACTIVE, SYSDATE);
Line: 2812

		OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'TAX_POINT_CODE');
Line: 2818

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 2869

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CUST_PO_NUMBER');
Line: 2875

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 2911

    SELECT  'VALID'
    INTO    l_dummy
    FROM    OE_RA_RULES_V
    WHERE   RULE_ID = p_invoicing_rule_id
    AND     STATUS = 'A'
    AND     TYPE = 'I';
Line: 2929

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'INVOICING_RULE_ID');
Line: 2935

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 2990

    /*SELECT  'VALID'
    INTO    l_dummy
    FROM    OE_RA_TERMS_V
    WHERE   TERM_ID = p_payment_term_id
    AND     SYSDATE     BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)
                        AND NVL(END_DATE_ACTIVE, SYSDATE);
Line: 3008

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'PAYMENT_TERM_ID');
Line: 3014

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 3064

	      OE_MSG_PUB.Update_Msg_Context
				 (p_attribute_code => 'PLANNING_PRIORITY');
Line: 3070

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 3107

    SELECT  'VALID'
    INTO    l_dummy
    FROM    OE_SHIP_METHODS_V
    WHERE   lookup_code = p_shipping_method_code
    AND     ENABLED_FLAG = 'Y'
    AND     SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)
    AND     NVL(END_DATE_ACTIVE, SYSDATE)
    AND     ROWNUM = 1;
Line: 3127

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SHIPPING_METHOD_CODE');
Line: 3133

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 3184

		OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'FREIGHT_CARRIER_CODE');
Line: 3190

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 3227

    SELECT  'VALID'
    INTO    l_dummy
    FROM    OE_AR_LOOKUPS_V
    WHERE   LOOKUP_CODE = p_fob_point_code
    AND     LOOKUP_TYPE = l_lookup_type
    AND     ENABLED_FLAG = 'Y'
    AND     SYSDATE     BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)
                        AND NVL(END_DATE_ACTIVE, SYSDATE);
Line: 3248

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'FOB_POINT_CODE');
Line: 3254

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 3291

    SELECT  'VALID'
    INTO    l_dummy
    FROM    OE_LOOKUPS
    WHERE   LOOKUP_CODE = p_freight_terms_code
    AND     LOOKUP_TYPE = l_lookup_type
    AND     ENABLED_FLAG = 'Y'
    AND     SYSDATE     BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)
                        AND NVL(END_DATE_ACTIVE, SYSDATE);
Line: 3314

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'FREIGHT_TERMS_CODE');
Line: 3321

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 3358

    SELECT  'VALID'
    INTO    l_dummy
    FROM    OE_SOLD_TO_ORGS_V
    WHERE   ORGANIZATION_ID =p_sold_to_org_id
    AND     STATUS = 'A'
    AND     SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)
                    AND     NVL(END_DATE_ACTIVE, SYSDATE);
Line: 3377

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SOLD_TO_ORG_ID');
Line: 3383

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 3419

    SELECT  'VALID'
    INTO    l_dummy
    FROM    HZ_CONTACT_POINTS
    WHERE   CONTACT_POINT_ID =p_sold_to_phone_id
    AND     STATUS = 'A';
Line: 3435

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SOLD_TO_PHONE_ID');
Line: 3441

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 3477

    SELECT  'VALID'
    INTO    l_dummy
    FROM    OE_SOLD_TO_ORGS_V
    WHERE   ORGANIZATION_ID =p_customer_id
    AND     STATUS = 'A'
    AND     SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)
                    AND     NVL(END_DATE_ACTIVE, SYSDATE);
Line: 3496

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CUSTOMER_ID');
Line: 3502

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 3553

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'INTERNAL_ITEM_ID');
Line: 3560

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 3611

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CUST_ITEM_SETTING_ID');
Line: 3617

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 3668

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SHIP_FROM_ORG_ID');
Line: 3674

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 3723

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SUBINVENTORY');
Line: 3729

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 3780

		OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'INVENTORY_ORG_ID');
Line: 3786

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 3827

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SHIP_TO_ORG_ID');
Line: 3833

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 3884

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SITE_USE_ID');
Line: 3890

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 3930

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'INTERMED_SHIP_TO_ORG_ID');
Line: 3936

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 3991

    /*SELECT  'VALID'
    INTO    l_dummy
    FROM    OE_INVOICE_TO_ORGS_V   INV
    WHERE   INV.ORGANIZATION_ID =p_invoice_to_org_id
    AND     INV.STATUS = 'A'
    AND     INV.ADDRESS_STATUS ='A' --bug 2752321
    AND     SYSDATE BETWEEN NVL(INV.START_DATE_ACTIVE, SYSDATE)
                    AND     NVL(INV.END_DATE_ACTIVE, SYSDATE);
Line: 4012

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'INVOICE_TO_ORG_ID');
Line: 4018

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 4054

    SELECT  'VALID'
    INTO    l_dummy
    FROM    OE_DELIVER_TO_ORGS_V   DEL
    WHERE   DEL.ORGANIZATION_ID =p_deliver_to_org_id
    AND     DEL.STATUS = 'A'
    AND     DEL.ADDRESS_STATUS ='A' --bug 2752321
    AND     SYSDATE BETWEEN NVL(DEL.START_DATE_ACTIVE, SYSDATE)
                    AND     NVL(DEL.END_DATE_ACTIVE, SYSDATE);
Line: 4073

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'DELIVER_TO_ORG_ID');
Line: 4079

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 4115

    SELECT  'VALID'
    INTO    l_dummy
    FROM    HZ_CUST_ACCOUNT_ROLES
    WHERE   CUST_ACCOUNT_ROLE_ID = p_sold_to_contact_id
    AND     ROLE_TYPE = 'CONTACT'
    AND     STATUS = 'A';
Line: 4133

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SOLD_TO_CONTACT_ID');
Line: 4139

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 4178

    SELECT  'VALID'
    INTO    l_dummy
    FROM    HZ_CUST_ACCOUNT_ROLES    ACCT_ROLE
    ,       HZ_ROLE_RESPONSIBILITY   ROL
    WHERE   ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_ship_to_contact_id
    AND     ACCT_ROLE.STATUS = 'A'
    AND     ACCT_ROLE.ROLE_TYPE = 'CONTACT'
    AND     ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = ROL.CUST_ACCOUNT_ROLE_ID (+)
    AND     NVL( ROL.RESPONSIBILITY_TYPE,l_resp_type)=l_resp_type;
Line: 4201

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SHIP_TO_CONTACT_ID');
Line: 4207

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 4246

    SELECT  'VALID'
    INTO    l_dummy
    FROM    HZ_CUST_ACCOUNT_ROLES    ACCT_ROLE
    ,       HZ_ROLE_RESPONSIBILITY   ROL
    WHERE   ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_intermed_ship_to_contact_id
    AND     ACCT_ROLE.STATUS = 'A'
    AND     ACCT_ROLE.ROLE_TYPE = 'CONTACT'
    AND     ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = ROL.CUST_ACCOUNT_ROLE_ID (+)
    AND     NVL( ROL.RESPONSIBILITY_TYPE,l_resp_type)=l_resp_type;
Line: 4269

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'INTERMED_SHIP_TO_CONTACT_ID');
Line: 4275

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 4315

    SELECT  'VALID'
    INTO    l_dummy
    FROM    HZ_CUST_ACCOUNT_ROLES    ACCT_ROLE
    ,       HZ_ROLE_RESPONSIBILITY   ROL
    WHERE   ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_invoice_to_contact_id
    AND     ACCT_ROLE.STATUS = 'A'
    AND     ACCT_ROLE.ROLE_TYPE = 'CONTACT'
    AND     ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = ROL.CUST_ACCOUNT_ROLE_ID (+)
    AND     NVL( ROL.RESPONSIBILITY_TYPE,l_resp_type)=l_resp_type;
Line: 4336

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'INVOICE_TO_CONTACT_ID');
Line: 4342

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 4377

    SELECT  'VALID'
    INTO    l_dummy
    FROM    HZ_CUST_ACCOUNT_ROLES                ACCT_ROLE
    ,       HZ_ROLE_RESPONSIBILITY           ROL
    WHERE   ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_deliver_to_contact_id
    AND     ACCT_ROLE.STATUS = 'A'
    AND     ACCT_ROLE.ROLE_TYPE = 'CONTACT'
    AND     ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = ROL.CUST_ACCOUNT_ROLE_ID (+)
    AND     NVL( ROL.RESPONSIBILITY_TYPE,'DELIVER_TO') in ('DELIVER_TO','SHIP_TO');
Line: 4400

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'DELIVER_TO_CONTACT_ID');
Line: 4406

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 4430

FUNCTION Last_Updated_By ( p_last_updated_by IN NUMBER )
RETURN BOOLEAN
IS
l_dummy                       VARCHAR2(10);
Line: 4437

    IF p_last_updated_by IS NULL OR
        p_last_updated_by = FND_API.G_MISS_NUM
    THEN

        RETURN TRUE;
Line: 4459

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'LAST_UPDATED_BY');
Line: 4463

				OE_Order_Util.Get_Attribute_Name('last_updated_by'));
Line: 4465

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 4478

            ,   'Last_Updated_By'
            );
Line: 4485

END Last_Updated_By;
Line: 4487

FUNCTION Last_Update_Date ( p_last_update_date IN DATE )
RETURN BOOLEAN
IS
l_dummy                       VARCHAR2(10);
Line: 4494

    IF p_last_update_date IS NULL OR
        p_last_update_date = FND_API.G_MISS_DATE
    THEN

        RETURN TRUE;
Line: 4516

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'LAST_UPDATE_DATE');
Line: 4520

				OE_Order_Util.Get_Attribute_Name('last_update_date'));
Line: 4522

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 4535

            ,   'Last_Update_Date'
            );
Line: 4542

END Last_Update_Date;
Line: 4544

FUNCTION Last_Update_Login ( p_last_update_login IN NUMBER )
RETURN BOOLEAN
IS
l_dummy                       VARCHAR2(10);
Line: 4551

    IF p_last_update_login IS NULL OR
        p_last_update_login = FND_API.G_MISS_NUM
    THEN

        RETURN TRUE;
Line: 4573

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'LAST_UPDATE_LOGIN');
Line: 4577

				OE_Order_Util.Get_Attribute_Name('last_update_login'));
Line: 4579

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 4592

            ,   'Last_Update_Login'
            );
Line: 4599

END Last_Update_Login;
Line: 4630

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'PROGRAM_APPLICATION_ID');
Line: 4636

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 4687

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'PROGRAM_ID');
Line: 4693

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 4715

FUNCTION Program_Update_Date ( p_program_update_date IN DATE )
RETURN BOOLEAN
IS
l_dummy                       VARCHAR2(10);
Line: 4722

    IF p_program_update_date IS NULL OR
        p_program_update_date = FND_API.G_MISS_DATE
    THEN

        RETURN TRUE;
Line: 4744

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'PROGRAM_UPDATE_DATE');
Line: 4748

				OE_Order_Util.Get_Attribute_Name('program_update_date'));
Line: 4750

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 4763

            ,   'Program_Update_Date'
            );
Line: 4770

END Program_Update_Date;
Line: 4801

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'REQUEST_ID');
Line: 4807

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 4858

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'GLOBAL_ATTRIBUTE1');
Line: 4864

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 4916

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'PRICE_ADJUSTMENT_ID');
Line: 4922

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 4973

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'DISCOUNT_ID');
Line: 4979

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 5031

		OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'DISCOUNT_LINE_ID');
Line: 5037

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 5088

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'AUTOMATIC_FLAG');
Line: 5094

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 5157

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'PERCENT');
Line: 5163

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 5214

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'LINE_ID');
Line: 5220

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 5271

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'APPLIED_FLAG');
Line: 5277

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 5315

    SELECT  'VALID'
    INTO    l_dummy
    FROM    OE_LOOKUPS
    WHERE   LOOKUP_CODE = p_change_reason_code
    AND     LOOKUP_TYPE = l_lookup_type
    AND     ENABLED_FLAG = 'Y'
    AND     SYSDATE  BETWEEN NVL(START_DATE_ACTIVE, SYSDATE) AND NVL(END_DATE_ACTIVE, SYSDATE);
Line: 5333

	    OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CHANGE_REASON_CODE');
Line: 5337

	    OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 5377

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CHANGE_REASON_TEXT');
Line: 5383

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 5435

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'LIST_HEADER_ID');
Line: 5441

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 5493

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'LIST_LINE_ID');
Line: 5499

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 5550

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'LIST_LINE_TYPE_CODE');
Line: 5556

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 5608

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'MODIFIED_FROM');
Line: 5614

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 5665

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'MODIFIED_TO');
Line: 5671

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 5723

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'MODIFIER_MECHANISM_TYPE_CODE');
Line: 5729

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 5753

FUNCTION Updated_Flag(p_Updated_Flag IN VARCHAR2)
RETURN BOOLEAN
IS
l_dummy                       VARCHAR2(10);
Line: 5760

    IF p_Updated_Flag IS NULL OR
        p_Updated_Flag = FND_API.G_MISS_NUM
    THEN

        RETURN TRUE;
Line: 5782

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'UPDATED_FLAG');
Line: 5786

				OE_Order_Util.Get_Attribute_Name('Updated_Flag'));
Line: 5788

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 5801

            ,   'Updated_Flag'
            );
Line: 5808

END Updated_Flag;
Line: 5811

FUNCTION Update_Allowed(p_Update_Allowed IN VARCHAR2)
RETURN BOOLEAN
IS
l_dummy                       VARCHAR2(10);
Line: 5818

    IF p_Update_Allowed IS NULL OR
        p_Update_Allowed = FND_API.G_MISS_NUM
    THEN

        RETURN TRUE;
Line: 5840

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'UPDATE_ALLOWED');
Line: 5844

				OE_Order_Util.Get_Attribute_Name('Update_Allowed'));
Line: 5846

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 5859

            ,   'Update_Allowed'
            );
Line: 5866

END Update_Allowed;
Line: 5897

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SALES_CREDIT_ID');
Line: 5903

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 5930

       select 'VALID'
       from oe_sales_credit_types
       where Sales_credit_type_id = p_Sales_credit_type_id;
Line: 5953

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'Sales_credit_type_id');
Line: 5959

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 5992

       select  'VALID'
       from ra_salesreps --Bug 3358986.Changed ra_salesreps_all to ra_salesreps
       where salesrep_id = p_salesrep_id
       and sysdate between NVL(start_date_active,sysdate)
       and NVL(end_date_active,sysdate);
Line: 6000

       select /* MOAC_SQL_CHANGE */ 'VALID'
       from jtf_rs_salesreps jrs,
            jtf_rs_resource_extns b
       where jrs.salesrep_id = p_salesrep_id
       and jrs.resource_id = b.resource_id
       and b.category in ('EMPLOYEE','OTHER','PARTY','PARTNER','SUPPLIER_CONTACT')
       and jrs.org_id =l_org_id
       and sysdate between nvl(jrs.start_date_active,sysdate)
                   and nvl(jrs.end_date_active,sysdate);
Line: 6058

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SALESREP_ID');
Line: 6064

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 6094

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SALESREP_ID');
Line: 6100

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 6111

        OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SALESREP_ID');
Line: 6116

        OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 6133

FUNCTION Dw_Update_Advice ( p_dw_update_advice_flag IN VARCHAR2 )
RETURN BOOLEAN
IS
l_dummy                       VARCHAR2(10);
Line: 6140

    IF p_dw_update_advice_flag IS NULL OR
        p_dw_update_advice_flag = FND_API.G_MISS_CHAR
    THEN

        RETURN TRUE;
Line: 6162

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'DW_UPDATE_ADVICE_FLAG');
Line: 6166

				OE_Order_Util.Get_Attribute_Name('dw_update_advice_flag'));
Line: 6168

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 6181

            ,   'Dw_Update_Advice'
            );
Line: 6188

END Dw_Update_Advice;
Line: 6190

FUNCTION Wh_Update_Date ( p_wh_update_date IN DATE )
RETURN BOOLEAN
IS
l_dummy                       VARCHAR2(10);
Line: 6197

    IF p_wh_update_date IS NULL OR
        p_wh_update_date = FND_API.G_MISS_DATE
    THEN

        RETURN TRUE;
Line: 6219

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'WH_UPDATE_DATE');
Line: 6223

				OE_Order_Util.Get_Attribute_Name('wh_update_date'));
Line: 6225

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 6238

            ,   'Wh_Update_Date'
            );
Line: 6245

END Wh_Update_Date;
Line: 6283

    /* SELECT  'VALID'
    INTO    l_dummy
    FROM    OE_LINE_TYPES_V
    WHERE   LINE_TYPE_ID = p_line_type_id
    AND     SYSDATE BETWEEN NVL( START_DATE_ACTIVE, SYSDATE  )
                     AND     NVL( END_DATE_ACTIVE, SYSDATE );
Line: 6302

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'LINE_TYPE_ID');
Line: 6308

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 6359

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'LINE_NUMBER');
Line: 6365

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 6416

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'ORDERED_ITEM_ID');
Line: 6422

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 6473

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'ITEM_IDENTIFIER_TYPE');
Line: 6479

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 6530

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'ORDERED_ITEM');
Line: 6536

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 6587

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'DATE_AND_TIME_REQUESTED');
Line: 6593

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 6644

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'DATE_AND_TIME_PROMISED');
Line: 6650

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 6701

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'DATE_AND_TIME_SCHEDULED');
Line: 6707

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 6758

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'ORDER_QUANTITY_UOM');
Line: 6764

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 6811

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'ORDERED_QUANTITY_UOM2');
Line: 6817

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 6858

    SELECT  'VALID'
    INTO    l_dummy
    FROM    MTL_GRADES_B
    WHERE   grade_code  = p_preferred_grade -- INVCONV
    AND     DISABLE_FLAG <> 'Y'; -- INVCONV
Line: 6873

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'PREFERRED_GRADE');
Line: 6879

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 6932

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'PRICE_REQUEST_CODE');
Line: 6938

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 6991

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'PRICING_QUANTITY');
Line: 6997

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 7048

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'PRICING_QUANTITY_UOM');
Line: 7054

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 7105

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'QUANTITY_CANCELLED');
Line: 7111

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 7162

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'QUANTITY_SHIPPED');
Line: 7168

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 7219

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'QUANTITY_ORDERED');
Line: 7225

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 7276

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'QUANTITY_FULFILLED');
Line: 7282

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 7336

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'FULFILLED_FLAG');
Line: 7342

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 7398

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CALCULATE_PRICE_FLAG');
Line: 7404

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 7455

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'FULFILLMENT_METHOD_CODE');
Line: 7461

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 7511

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'FULFILLMENT_DATE');
Line: 7517

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 7568

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SHIPPING_QUANTITY');
Line: 7574

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 7625

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SHIPPING_QUANTITY_UOM');
Line: 7631

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 7682

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'DELIVERY_LEAD_TIME');
Line: 7688

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 7739

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'DEMAND_BUCKET_TYPE');
Line: 7745

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 7796

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SCHEDULE_ITEM_DETAIL_ID');
Line: 7802

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 7853

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'DEMAND_STREAM_ID');
Line: 7859

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 7910

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CUST_DOCK_CODE');
Line: 7916

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 7967

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CUST_JOB');
Line: 7973

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 8024

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CUST_PRODUCTION_LINE');
Line: 8030

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 8081

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CUST_MODEL_SERIAL_NUMBER');
Line: 8087

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 8137

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'PLANNING_PROD_SEQ_NO');
Line: 8143

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 8177

      SELECT  'VALID'
      INTO     l_dummy
      FROM     pjm_projects_org_v
      WHERE    project_id = p_project_id
	 AND      rownum = 1;
Line: 8203

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'PROJECT_ID');
Line: 8209

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 8261

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'TASK_ID');
Line: 8267

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 8318

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'INVENTORY_ITEM_ID');
Line: 8324

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 8376

		OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'TAX_DATE');
Line: 8382

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 8434

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'PRICING_DATE');
Line: 8440

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 8491

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SHIPMENT_NUMBER');
Line: 8497

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 8548

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'ORIG_SYS_LINE_REF');
Line: 8554

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 8605

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SOURCE_DOCUMENT_LINE_ID');
Line: 8611

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 8662

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'REFERENCE_LINE_ID');
Line: 8668

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 8720

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'REFERENCE_TYPE');
Line: 8726

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 8777

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'REFERENCE_HEADER_ID');
Line: 8783

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 8836

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'REVISION');
Line: 8842

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 8893

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'UNIT_SELLING_PRICE');
Line: 8899

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 8951

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'UNIT_SELLING_PRICE_PER_PQTY');
Line: 8957

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 9009

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'UNIT_LIST_PRICE');
Line: 9015

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 9066

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'UNIT_LIST_PRICE_PER_PQTY');
Line: 9072

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 9123

		OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'TAX_VALUE');
Line: 9129

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 9183

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'ORDER_NUMBER_SOURCE_ID');
Line: 9189

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 9240

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'NAME');
Line: 9246

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 9297

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SEQUENCE_STARTING_POINT');
Line: 9303

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 9355

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'DESCRIPTION');
Line: 9362

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 9413

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'START_DATE_ACTIVE');
Line: 9419

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 9470

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'END_DATE_ACTIVE');
Line: 9476

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 9503

  OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'PERCENT');
Line: 9514

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 9554

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CONFIGURATION_ID');
Line: 9560

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 9611

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'TOP_MODEL_LINE_ID');
Line: 9617

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 9668

		OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'LINK_TO_LINE_ID');
Line: 9674

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 9725

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'COMPONENT_SEQUENCE_ID');
Line: 9731

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 9782

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CONFIG_HEADER');
Line: 9788

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 9839

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CONFIG_REV_NBR');
Line: 9845

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 9896

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'COMPONENT_CODE');
Line: 9902

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 9953

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CONFIG_DISPLAY_SEQUENCE');
Line: 9959

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 10010

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SORT_ORDER');
Line: 10016

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 10067

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'OE_ITEM_TYPE');
Line: 10072

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 10124

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'OPTION_NUMBER');
Line: 10130

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 10181

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'COMPONENT_NUMBER');
Line: 10187

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 10217

    OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'EXPLOSION_DATE');
Line: 10241

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'EXPLOSION_DATE');
Line: 10247

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 10384

    SELECT 'VALID'
    INTO l_dummy
    FROM    OE_RA_RULES_V
    WHERE   RULE_ID = p_accounting_rule_id
    AND     STATUS = 'A'
    AND     TYPE IN ('A', 'ACC_DUR','PP_DR_ALL','PP_DR_PP');
Line: 10400

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'ACCOUNTING_RULE_ID');
Line: 10406

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 10458

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'ACCOUNTING_RULE_DURATION');
Line: 10464

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 10516

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CREATED_BY');
Line: 10522

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 10573

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CREATION_DATE');
Line: 10579

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 10631

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'ORDERED_DATE');
Line: 10637

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 10674

    SELECT  'VALID'
    INTO    l_dummy
    FROM    OE_LOOKUPS
    WHERE   LOOKUP_CODE = p_order_date_type_code
    AND     LOOKUP_TYPE = l_lookup_type
    AND     ENABLED_FLAG = 'Y'
    AND     SYSDATE     BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)
                        AND NVL(END_DATE_ACTIVE, SYSDATE);
Line: 10693

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'ORDER_DATE_TYPE_CODE');
Line: 10699

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 10753

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'REQUEST_DATE');
Line: 10759

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 10810

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'RESERVED_QUANTITY');
Line: 10816

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 10867

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'ACTUAL_ARRIVAL_DATE');
Line: 10873

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 10925

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'ACTUAL_SHIPMENT_DATE');
Line: 10931

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 10983

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'ATO_LINE_ID');
Line: 10989

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 11012

FUNCTION Auto_Selected_Quantity ( p_auto_selected_quantity IN NUMBER )
RETURN BOOLEAN
IS
l_dummy                       VARCHAR2(10);
Line: 11019

    IF p_auto_selected_quantity IS NULL OR
        p_auto_selected_quantity = FND_API.G_MISS_NUM
    THEN

        RETURN TRUE;
Line: 11041

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'AUTO_SELECTED_QUANTITY');
Line: 11045

				OE_Order_Util.Get_Attribute_Name('auto_selected_quantity'));
Line: 11047

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 11060

            ,   'Auto_Selected_Quantity'
            );
Line: 11067

END Auto_Selected_Quantity;
Line: 11086

    SELECT  'VALID'
    INTO    l_dummy
    FROM    OE_BLANKET_HEADERS BH,OE_BLANKET_HEADERS_EXT BHE
    WHERE   BH.ORDER_NUMBER = p_blanket_number
    AND     TRUNC(SYSDATE) BETWEEN TRUNC(BHE.START_DATE_ACTIVE )
                    AND     TRUNC(NVL( BHE.END_DATE_ACTIVE, SYSDATE )) AND
            BHE.ON_HOLD_FLAG = 'N'
    AND     BH.ORDER_NUMBER = BHE.ORDER_NUMBER
    AND     BH.SALES_DOCUMENT_TYPE_CODE = 'B';
Line: 11105

            OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'BLANKET_NUMBER');
Line: 11112

                OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 11160

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'BOOKED_FLAG');
Line: 11166

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 11217

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CANCELLED_FLAG');
Line: 11223

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 11275

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CANCELLED_QUANTITY');
Line: 11281

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 11334

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CREDIT_INVOICE_LINE_ID');
Line: 11340

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 11392

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CUSTOMER_DOCK_CODE');
Line: 11398

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 11452

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CUSTOMER_JOB');
Line: 11458

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 11509

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CUSTOMER_PRODUCTION_LINE');
Line: 11515

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 11566

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CUSTOMER_TRX_LINE_ID');
Line: 11572

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 11625

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'DEP_PLAN_REQUIRED_FLAG');
Line: 11631

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 11683

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'FULFILLED_QUANTITY');
Line: 11689

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 11741

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'INVOICE_INTERFACE_STATUS_CODE');
Line: 11747

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 11800

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'ITEM_REVISION');
Line: 11806

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 11857

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'ITEM_TYPE_CODE');
Line: 11863

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 11914

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'LINE_CATEGORY_CODE');
Line: 11920

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 11971

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'OPEN_FLAG');
Line: 11977

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 12029

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'OPTION_FLAG');
Line: 12035

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 12091

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'ORDERED_QUANTITY');
Line: 12097

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 12145

	     OE_MSG_PUB.Update_Msg_Context(p_attribute_code =>'ORDERED_QUANTITY2');
Line: 12150

	       OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 12205

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'PROMISE_DATE');
Line: 12211

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 12264

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'RE_SOURCE_FLAG');
Line: 12270

            OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 12322

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'RLA_SCHEDULE_TYPE_CODE');
Line: 12328

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 12379

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SCHEDULE_SHIP_DATE');
Line: 12385

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 12439

              OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'LATE_DEMAND_PENALTY_FACTOR');
Line: 12445

              OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 12496

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SCHEDULE_STATUS_CODE');
Line: 12502

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 12565

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'TAX_CODE');
Line: 12571

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 12622

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'TAX_RATE');
Line: 12628

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 12682

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'VISIBLE_DEMAND_FLAG');
Line: 12688

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 12741

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SHIPPED_QUANTITY');
Line: 12747

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 12798

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'EARLIEST_ACCEPTABLE_DATE');
Line: 12804

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 12854

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'EARLIEST_SCHEDULE_LIMIT');
Line: 12860

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 12911

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'LATEST_ACCEPTABLE_DATE');
Line: 12918

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 12969

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'LATEST_SCHEDULE_LIMIT');
Line: 12975

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 13026

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'MODEL_GROUP_NUMBER');
Line: 13032

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 13084

	      OE_MSG_PUB.Update_Msg_Context
			    (p_attribute_code => 'MFG_COMPONENT_SEQUENCE_ID');
Line: 13092

	       OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 13143

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SCHEDULE_ARRIVAL_DATE');
Line: 13149

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 13202

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SHIP_MODEL_COMPLETE_FLAG');
Line: 13208

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 13259

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'FROM_SERIAL_NUMBER');
Line: 13265

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 13316

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'LOT_NUMBER');
Line: 13322

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 13373

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SUBLOT_NUMBER');
Line: 13379

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 13430

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'LOT_SERIAL_ID');
Line: 13436

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 13487

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'QUANTITY');
Line: 13493

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 13544

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'QUANTITY2');
Line: 13550

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 13601

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'TO_SERIAL_NUMBER');
Line: 13607

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 13658

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'Line_Set_ID');
Line: 13664

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 13715

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'AMOUNT');
Line: 13721

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 13772

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'APPEAR_ON_ACK_FLAG');
Line: 13778

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 13829

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'APPEAR_ON_INVOICE_FLAG');
Line: 13835

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 13886

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CHARGE_ID');
Line: 13892

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 13943

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CHARGE_TYPE_ID');
Line: 13949

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 14000

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CONVERSION_DATE');
Line: 14007

		OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 14059

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'COST_OR_CHARGE_FLAG');
Line: 14065

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 14116

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CURRENCY_CODE');
Line: 14122

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 14173

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'DEPARTURE_ID');
Line: 14179

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 14230

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'ESTIMATED_FLAG');
Line: 14236

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 14287

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'INC_IN_SALES_PERFORMANCE');
Line: 14293

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 14345

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'INVOICED_FLAG');
Line: 14351

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 14402

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'LPN');
Line: 14408

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 14459

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'PARENT_CHARGE_ID');
Line: 14465

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 14516

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'RETURNABLE_FLAG');
Line: 14522

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 14573

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'TAX_GROUP_CODE');
Line: 14579

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 18479

    SELECT  'VALID'
    INTO    l_dummy
    FROM    OE_AR_LOOKUPS_V
    WHERE   LOOKUP_CODE = p_return_reason_code
    AND     LOOKUP_TYPE = l_lookup_type
    AND     ENABLED_FLAG = 'Y'
    AND     SYSDATE     BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)
                        AND NVL(END_DATE_ACTIVE, SYSDATE);
Line: 18497

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'RETURN_REASON_CODE');
Line: 18504

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 18559

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SPLIT_FROM_LINE_ID');
Line: 18565

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 18619

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CUST_PRODUCTION_SEQ_NUM');
Line: 18625

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 18680

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'AUTHORIZED_TO_SHIP_FLAG');
Line: 18686

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 18740

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'VEH_CUS_ITEM_CUM_KEY_ID');
Line: 18746

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 18800

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'ARRIVAL_SET_ID');
Line: 18807

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 18861

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SHIP_SET_ID');
Line: 18867

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 18921

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'OVER_SHIP_REASON_CODE');
Line: 18927

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 18982

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'OVER_SHIP_RESOLVED_FLAG');
Line: 18988

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 19029

       SELECT  'VALID'
       INTO    l_dummy
       FROM    oe_payment_types_vl
       WHERE   payment_type_code = p_payment_type_code
       AND     ENABLED_FLAG = 'Y';
Line: 19035

       SELECT  'VALID'
       INTO    l_dummy
       FROM    OE_LOOKUPS
       WHERE   LOOKUP_CODE = p_payment_type_code
       AND     LOOKUP_TYPE = l_lookup_type
       AND     ENABLED_FLAG = 'Y'
       AND     SYSDATE     BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)
                           AND NVL(END_DATE_ACTIVE, SYSDATE);
Line: 19055

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'PAYMENT_TYPE_CODE');
Line: 19061

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 19113

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'PAYMENT_AMOUNT');
Line: 19119

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 19172

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CHECK_NUMBER');
Line: 19178

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 19218

    /*SELECT  'VALID'
    INTO    l_dummy
    FROM    OE_LOOKUPS
    WHERE   LOOKUP_CODE = p_credit_card_code
    AND     LOOKUP_TYPE = l_lookup_type
    AND     ENABLED_FLAG = 'Y'
    AND     SYSDATE     BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)
                        AND NVL(END_DATE_ACTIVE, SYSDATE);*/
Line: 19227

    select 'VALID'
    into l_dummy
    from iby_creditcard_issuers_v
    where card_issuer_code = p_credit_card_code
    and rownum=1;
Line: 19246

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CREDIT_CARD_CODE');
Line: 19252

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 19310

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CREDIT_CARD_HOLDER_NAME');
Line: 19316

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 19367

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CREDIT_CARD_NUMBER');
Line: 19373

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 19414

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CREDIT_CARD_APPROVAL_DATE');
Line: 19419

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 19452

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CREDIT_CARD_EXPIRATION_DATE');
Line: 19457

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 19500

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CREDIT_CARD_APPROVAL_CODE');
Line: 19506

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 19558

	     OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'FIRST_ACK_CODE');
Line: 19565

            OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 19617

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'FIRST_ACK_DATE');
Line: 19623

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 19674

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'LAST_ACK_CODE');
Line: 19680

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 19732

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'LAST_ACK_DATE');
Line: 19738

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 19773

      SELECT  'VALID'
      INTO     l_dummy
      FROM     pjm_unit_numbers_lov_v
      WHERE    unit_number = p_end_item_unit_number;
Line: 19787

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'END_ITEM_UNIT_NUMBER');
Line: 19794

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 19845

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'INVOICED_QUANTITY');
Line: 19851

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 19903

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SERVICE_TXN_TYPE_REASON');
Line: 19909

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 19961

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SERVICE_TXN_TYPE_COMMENTS');
Line: 19967

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 20019

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'Serviced_Duration');
Line: 20025

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 20076

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'Service_Period');
Line: 20082

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 20134

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'Service_Start_Date');
Line: 20140

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 20191

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'Service_End_Date');
Line: 20197

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 20248

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'Service_Coterminate');
Line: 20254

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 20305

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'Unit_List_Percent');
Line: 20311

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 20362

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'Unit_Selling_Percent');
Line: 20368

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 20419

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'Unit_Percent_base_Price');
Line: 20425

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 20476

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'Service_Number');
Line: 20482

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 20533

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'Service_Reference_Type_Code');
Line: 20539

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 20590

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'Service_Reference_Line_id');
Line: 20596

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 20647

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'Service_Reference_System_id');
Line: 20653

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 20690

    SELECT  'VALID'
    INTO    l_dummy
    FROM    OE_LOOKUPS
    WHERE   LOOKUP_CODE = p_flow_status_code
    AND     LOOKUP_TYPE = l_lookup_type
    AND     ENABLED_FLAG = 'Y'
    AND     SYSDATE     BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)
                        AND NVL(END_DATE_ACTIVE, SYSDATE);
Line: 20710

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'FLOW_STATUS_CODE');
Line: 20716

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 20753

    SELECT  'VALID'
    INTO    l_dummy
    FROM    OE_LOOKUPS
    WHERE   LOOKUP_CODE = p_flow_status_code
    AND     LOOKUP_TYPE = l_lookup_type
    AND     ENABLED_FLAG = 'Y'
    AND     SYSDATE     BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)
                        AND NVL(END_DATE_ACTIVE, SYSDATE);
Line: 20773

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'FLOW_STATUS_CODE');
Line: 20779

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 20829

		OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SPLIT_ACTION_CODE');
Line: 20835

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 20887

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'Marketing_Source_Code_id');
Line: 20893

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 20944

		OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'COST_ID');
Line: 20950

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 20983

    SELECT  'VALID'
    INTO     l_dummy
    FROM     QP_CHARGE_LOOKUP
    WHERE    LOOKUP_CODE = p_charge_type_code;
Line: 20999

		OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CHARGE_TYPE_CODE');
Line: 21005

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 21054

		OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CHARGE_SUBTYPE_CODE');
Line: 21060

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 21109

                OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'COMMITMENT_ID');
Line: 21115

              OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 21149

    SELECT  'VALID'
    INTO     l_dummy
    FROM     OE_LOOKUPS
    WHERE    LOOKUP_CODE = p_credit_or_charge_flag
    AND      LOOKUP_TYPE = l_lookup_type
    AND      SYSDATE BETWEEN NVL(START_DATE_ACTIVE,SYSDATE)
                     AND     NVL(END_DATE_ACTIVE, SYSDATE );
Line: 21168

		OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CREDIT_OR_CHARGE_FLAG');
Line: 21174

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 21208

    SELECT  'VALID'
    INTO     l_dummy
    FROM     OE_FND_COMMON_LOOKUPS_V
    WHERE    LOOKUP_CODE = p_Include_On_Returns_Flag
    AND      LOOKUP_TYPE = l_lookup_type
    AND      SYSDATE BETWEEN NVL(START_DATE_ACTIVE,SYSDATE)
                     AND     NVL(END_DATE_ACTIVE, SYSDATE );
Line: 21227

		OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'INCLUDE_ON_RETURNS_FLAG');
Line: 21233

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 21290

    SELECT  'VALID'
    INTO     l_dummy
    FROM     OE_LOOKUPS
    WHERE    LOOKUP_CODE = p_sales_channel_code
    AND      LOOKUP_TYPE = l_lookup_type
    AND      ENABLED_FLAG = 'Y'
    AND      SYSDATE BETWEEN NVL(START_DATE_ACTIVE,SYSDATE)
                     AND     NVL(END_DATE_ACTIVE, SYSDATE );
Line: 21310

		OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SALES_CHANNEL_CODE');
Line: 21317

	     OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 21367

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'USER_ITEM_DESCRIPTION');
Line: 21373

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 21408

    SELECT  'VALID'
    INTO    l_dummy
    FROM    MFG_LOOKUPS
    WHERE   LOOKUP_CODE = p_Item_Relationship_Type
    AND     LOOKUP_TYPE = l_lookup_type
    AND     ENABLED_FLAG = 'Y'
    AND     SYSDATE     BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)
                        AND NVL(END_DATE_ACTIVE, SYSDATE);
Line: 21422

              OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'ITEM_RELATIONSHIP_TYPE');
Line: 21427

              OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 21467

                OE_MSG_PUB.Update_Msg_Context(p_attribute_code =>  'Default_Fulfillment_Set');
Line: 21473

                OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 21518

                OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'Fulfillment_Set_Name');
Line: 21524

                OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 21569

                OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'Line_Set_Name');
Line: 21575

               OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 21623

                OE_MSG_PUB.Update_Msg_Context(p_attribute_code =>  'Customer_Shipment_Number');
Line: 21629

                OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 21667

    SELECT  'VALID'
    INTO    l_dummy
    FROM    OE_LOOKUPS
    WHERE   LOOKUP_CODE = p_transaction_phase_code
    AND     LOOKUP_TYPE = l_lookup_type
    AND     ENABLED_FLAG = 'Y'
    AND     SYSDATE     BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)
                        AND NVL(END_DATE_ACTIVE, SYSDATE);
Line: 21686

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'TRANSACTION_PHASE_CODE');
Line: 21692

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 21728

    SELECT  'VALID'
    INTO    l_dummy
    FROM    OE_LOOKUPS
    WHERE   LOOKUP_CODE = p_user_status_code
    AND     LOOKUP_TYPE = l_lookup_type
    AND     ENABLED_FLAG = 'Y'
    AND     SYSDATE     BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)
                        AND NVL(END_DATE_ACTIVE, SYSDATE);
Line: 21747

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'USER_STATUS_CODE');
Line: 21753

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 21789

    SELECT  'VALID'
    INTO    l_dummy
    FROM    HZ_CUST_SITE_USES   SITE
    WHERE   SITE.SITE_USE_ID =p_sold_to_site_use_id
    AND     SITE.SITE_USE_CODE = 'SOLD_TO'
    AND     SITE.STATUS = 'A';
Line: 21806

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SOLD_TO_SITE_USE_ID');
Line: 21812

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 21854

    l_sql_stat := 'select 1 from IBE_MSITES_B where msite_id= :bind_minisite_id';
Line: 21879

            OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'MINISITE_ID');
Line: 21886

                OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 21929

      SELECT  'VALID'
      INTO     l_dummy
      FROM     OE_LOOKUPS
      WHERE    lookup_code = p_ib_owner AND
              ( lookup_type = l_lookup_type1 OR lookup_type=l_lookup_type2);
Line: 21946

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'IB_OWNER');
Line: 21952

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 21990

      SELECT  'VALID'
      INTO     l_dummy
      FROM     OE_LOOKUPS
      WHERE    lookup_code = p_ib_installed_at_location AND
               (lookup_type = l_lookup_type1 OR lookup_type= l_lookup_type2);
Line: 22007

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'IB_INSTALLED_AT_LOCATION');
Line: 22013

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 22051

      SELECT  'VALID'
      INTO     l_dummy
      FROM     OE_LOOKUPS
      WHERE    lookup_code = p_ib_current_location AND
               (lookup_type = l_lookup_type1 OR lookup_type=l_lookup_type2);
Line: 22068

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'IB_CURRENT_LOCATION');
Line: 22074

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 22109

    SELECT  'VALID'
    INTO    l_dummy
    FROM    OE_SOLD_TO_ORGS_V
    WHERE   ORGANIZATION_ID =p_end_customer_id
    AND     STATUS = 'A'
    AND     SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)
                    AND     NVL(END_DATE_ACTIVE, SYSDATE);
Line: 22128

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'END_CUSTOMER_ID');
Line: 22134

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 22169

    SELECT  'VALID'
    INTO    l_dummy
    FROM    HZ_CUST_ACCOUNT_ROLES
    WHERE   CUST_ACCOUNT_ROLE_ID = p_end_customer_contact_id
    AND     ROLE_TYPE = 'CONTACT'
    AND     STATUS = 'A';
Line: 22185

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'END_CUSTOMER_CONTACT_ID');
Line: 22191

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 22242

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'END_CUSTOMER_SITE_USE_ID');
Line: 22248

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 22299

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SUPPLIER_SIGNATURE');
Line: 22305

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 22356

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SUPPLIER_SIGNATURE');
Line: 22362

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 22413

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CUSTOMER_SIGNATURE');
Line: 22419

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 22470

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CUSTOMER_SIGNATURE_DATE');
Line: 22476

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 22526

              OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CONTRACT_TEMPLATE_ID
');
Line: 22533

              OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 22569

              OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CONTRACT_SOURCE_DOC_TYPE_CODE
');
Line: 22576

              OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 22613

              OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CONTRACT_SOURCE_DOCUMENT_ID');
Line: 22619

              OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 22931

              OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'Payment_Level_Code');
Line: 22937

              OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 22986

            OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'COMMITMENT_APPLIED_AMOUNT');
Line: 22992

              OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 23040

            OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'COMMITMENT_INTERFACED_AMOUNT');
Line: 23046

              OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 23081

      SELECT  'VALID'
      INTO     l_dummy
      FROM     OE_LOOKUPS
      WHERE    lookup_type = l_lookup_type
      AND      lookup_code = p_payment_collection_event;
Line: 23096

            OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'PAYMENT_COLLECTION_EVENT');
Line: 23102

              OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 23150

            OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'PAYMENT_TRX_ID');
Line: 23156

              OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 23204

            OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'PAYMENT_SET_ID');
Line: 23210

              OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 23258

            OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'PREPAID_AMOUNT');
Line: 23264

              OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 23298

      SELECT  'VALID'
      INTO     l_dummy
      FROM    ar_receipt_methods rm,
              ar_receipt_classes rc
      Where   nvl(rc.bill_of_exchange_flag, 'N') = 'N'
      and     rc.receipt_class_id = rm.receipt_class_id
      and     rm.receipt_method_id = p_receipt_method_id;
Line: 23315

            OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'RECEIPT_METHOD');
Line: 23321

              OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 23368

            OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'TANGIBLE_ID');
Line: 23374

              OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 23423

            OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'PAYMENT_NUMBER');
Line: 23429

              OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 23459

  SELECT uom_class
  INTO   l_uom_class
  FROM   MTL_UNITS_OF_MEASURE_VL
  WHERE  uom_code = p_charge_periodicity
  AND    uom_class = FND_PROFILE.Value('ONT_UOM_CLASS_CHARGE_PERIODICITY');
Line: 23482

       OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CHARGE_PERIODICITY');
Line: 23487

       OE_MSG_PUB.Update_Msg_Context(p_attribute_code => NULL);
Line: 23534

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SHIPPED_QUANTITY2');
Line: 23540

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 23591

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'FULFILLED_QUANTITY2');
Line: 23597

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 23648

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SHIPPING_QUANTITY2');
Line: 23654

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 23705

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SHIPPING_QUANTITY_UOM2');
Line: 23711

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 23747

   SELECT  'VALID'
    INTO    l_dummy
    FROM    IBY_FNDCPT_TX_EXTENSIONS
    Where trxn_extension_id = p_trxn_extension_id;
Line: 23764

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'TRXN_EXTENSION_ID');
Line: 23770

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 23822

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'TAX_RATE_ID');
Line: 23828

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);