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 trunc(sysdate) between nvl(jrs.start_date_active,trunc(sysdate)) --12675100, added trunc on sysdate
                   and nvl(jrs.end_date_active,trunc(sysdate)); --12675100, added trunc on sysdate
Line: 6072

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

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

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

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

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

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

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

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

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

    IF p_dw_update_advice_flag IS NULL OR
        p_dw_update_advice_flag = FND_API.G_MISS_CHAR
    THEN

        RETURN TRUE;
Line: 6198

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

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

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

            ,   'Dw_Update_Advice'
            );
Line: 6224

END Dw_Update_Advice;
Line: 6226

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

    IF p_wh_update_date IS NULL OR
        p_wh_update_date = FND_API.G_MISS_DATE
    THEN

        RETURN TRUE;
Line: 6255

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

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

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

            ,   'Wh_Update_Date'
            );
Line: 6281

END Wh_Update_Date;
Line: 6319

    /* 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: 6338

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

   SELECT 'Y'
     into l_exists
     FROM OE_LOOKUPS
    WHERE lookup_type='OM_BILLING_OPTION_FOR_SERVICES'
      AND enabled_flag='Y'
     AND  LOOKUP_CODE =p_service_bill_option_code;
Line: 10419

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SERVICE_BILL_OPTION_CODE');
Line: 10424

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

    select 'Y'
      INTO l_exists
      from oks_coverage_templts_v
     where item_type = 'SUBSCRIPTION'
       AND id =    p_service_subs_template_id
       and (sysdate between nvl(start_date, sysdate)
       and nvl(end_date, sysdate));
Line: 10459

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

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

   SELECT Profile_number
     INTO l_billing_profile
     from oks_billing_profiles_v
    where Id = p_service_bill_profile_id;
Line: 10497

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SERVICE_BILL_PROFILE_ID');
Line: 10502

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

    select 'Y'
      INTO l_exists
      from oks_coverage_templts_v
     where item_type = 'SERVICE'  AND id =p_service_cov_template_id
       and (sysdate between nvl(start_date, sysdate) and nvl(end_date, sysdate));
Line: 10536

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SERVICE_COV_TEMPLATE_ID');
Line: 10541

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

    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: 10594

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

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

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

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

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

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

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

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

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

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

    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: 10887

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

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

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

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

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

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

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

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

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

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

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

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

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

    IF p_auto_selected_quantity IS NULL OR
        p_auto_selected_quantity = FND_API.G_MISS_NUM
    THEN

        RETURN TRUE;
Line: 11235

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

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

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

            ,   'Auto_Selected_Quantity'
            );
Line: 11261

END Auto_Selected_Quantity;
Line: 11280

    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: 11299

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    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: 18691

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

       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: 19249

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

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

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

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

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

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

    /*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: 19421

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    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: 20904

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

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

    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: 20967

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    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: 21362

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

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

    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: 21421

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

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

    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: 21504

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

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

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

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

    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: 21616

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

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

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

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

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

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

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

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

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

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

    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: 21880

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

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

    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: 21941

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

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

    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: 22000

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

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

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

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

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

      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: 22140

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

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

      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: 22201

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

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

      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: 22262

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

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

    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: 22322

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

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

    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: 22379

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

      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: 23509

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

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

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

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

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

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

  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: 23676

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

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

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

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

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

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

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

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

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

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

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

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

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

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

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);