DBA Data[Home] [Help]

APPS.OE_CNCL_VALIDATE SQL Statements

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

Line: 90

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

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

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

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

    SELECT  'VALID'
    INTO    l_dummy
    FROM    OE_ORDER_TYPES_V
    WHERE   ORDER_TYPE_ID = p_order_type_id
    AND     ROWNUM = 1;
Line: 215

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

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

      SELECT  'VALID'
      INTO     l_dummy
      FROM     OE_LOOKUPS
      WHERE    lookup_code = p_ib_owner AND
               lookup_type = l_lookup_type1;
Line: 276

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

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

      SELECT  'VALID'
      INTO     l_dummy
      FROM     OE_LOOKUPS
      WHERE    lookup_code = p_ib_installed_at_location AND
               lookup_type = l_lookup_type1;
Line: 337

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

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

      SELECT  'VALID'
      INTO     l_dummy
      FROM     OE_LOOKUPS
      WHERE    lookup_code = p_ib_current_location AND
               lookup_type = l_lookup_type1;
Line: 398

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

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

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

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

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

    SELECT  'VALID'
    INTO    l_dummy
    FROM    OE_RA_CONTACTS_V                CON
    WHERE   CON.CONTACT_ID = p_end_customer_contact_id
    AND     CON.STATUS = 'A';
Line: 514

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

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

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

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

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

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

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

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

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

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

    SELECT  'VALID'
    INTO    l_dummy
    FROM    OE_ORDER_SOURCES
    WHERE   ORDER_SOURCE_ID = p_order_source_id
    AND     ROWNUM = 1;
Line: 808

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

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

    SELECT  'VALID'
    INTO    l_dummy
    FROM    OE_ORDER_SOURCES
    WHERE   ORDER_SOURCE_ID = p_source_document_type_id
    AND     ROWNUM = 1;
Line: 868

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

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

    SELECT  'VALID'
    INTO    l_dummy
    FROM    OE_LOOKUPS
    WHERE   LOOKUP_CODE = p_source_type_code
    AND     LOOKUP_TYPE = l_lookup_type
    AND     ROWNUM = 1;
Line: 932

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

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

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

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

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

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

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

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

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

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

    SELECT  'VALID'
    INTO    l_dummy
    FROM    OE_LOOKUPS
    WHERE   LOOKUP_CODE = p_shipment_priority_code
    AND     LOOKUP_TYPE = l_lookup_type
    AND     ROWNUM = 1;
Line: 1213

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

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

    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     ROWNUM = 1;
Line: 1278

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

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

   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     ROWNUM = 1;
Line: 1342

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

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

    SELECT  'VALID'
    INTO    l_dummy
    FROM    fnd_lookups
    WHERE   LOOKUP_CODE = p_tax_exempt_flag
    AND     LOOKUP_TYPE = l_lookup_type
    AND     ROWNUM = 1;
Line: 1408

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

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

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

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

    SELECT  'VALID'
    INTO    l_dummy
    FROM    fnd_lookups
    WHERE   LOOKUP_CODE = p_tax_exempt_reason_code
    AND     LOOKUP_TYPE = l_lookup_type
    AND     ROWNUM = 1;
Line: 1529

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

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

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

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

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

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

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

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

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

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

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

    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      ROWNUM = 1;
Line: 1812

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    SELECT  'VALID'
    INTO    l_dummy
    FROM    OE_FND_CURRENCIES_V
    WHERE   CURRENCY_CODE = p_transactional_curr_code
    AND     CURRENCY_FLAG = 'Y'
    AND     ROWNUM = 1;
Line: 2446

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

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

    SELECT  'VALID'
    INTO    l_dummy
    FROM    OE_AGREEMENTS_B  A
    WHERE   A.AGREEMENT_ID = p_agreement_id
    AND     ROWNUM = 1;
Line: 2510

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

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

    SELECT  'VALID'
    INTO    l_dummy
    FROM    OE_LOOKUPS
    WHERE   LOOKUP_CODE = p_tax_point_code
    AND     LOOKUP_TYPE = l_lookup_type
    AND     ROWNUM = 1;
Line: 2577

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

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

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

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

    SELECT  'VALID'
    INTO    l_dummy
    FROM    OE_RA_RULES_V
    WHERE   RULE_ID = p_invoicing_rule_id
    AND     TYPE = 'I'
    AND     ROWNUM = 1;
Line: 2698

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

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

    SELECT  'VALID'
    INTO    l_dummy
    FROM    OE_RA_TERMS_V
    WHERE   TERM_ID = p_payment_term_id
    AND     ROWNUM = 1;
Line: 2763

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

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

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

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

    SELECT  'VALID'
    INTO    l_dummy
    FROM    OE_SHIP_METHODS_V
    WHERE   lookup_code = p_shipping_method_code
    AND     ROWNUM = 1;
Line: 2883

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

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

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

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

    SELECT  'VALID'
    INTO    l_dummy
    FROM    OE_AR_LOOKUPS_V
    WHERE   LOOKUP_CODE = p_fob_point_code
    AND     LOOKUP_TYPE = l_lookup_type
    AND     ROWNUM = 1;
Line: 3008

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

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

    SELECT  'VALID'
    INTO    l_dummy
    FROM    OE_LOOKUPS
    WHERE   LOOKUP_CODE = p_freight_terms_code
    AND     LOOKUP_TYPE = l_lookup_type
    AND     ROWNUM = 1;
Line: 3078

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

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

    SELECT  'VALID'
    INTO    l_dummy
    FROM    OE_SOLD_TO_ORGS_V
    WHERE   ORGANIZATION_ID =p_sold_to_org_id
    AND     ROWNUM = 1;
Line: 3145

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

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

    SELECT  'VALID'
    INTO    l_dummy
    FROM    OE_SOLD_TO_ORGS_V
    WHERE   ORGANIZATION_ID =p_customer_id
    AND     ROWNUM = 1;
Line: 3210

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

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

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

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

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

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

    SELECT 'VALID'
    INTO   l_dummy
    FROM   oe_ship_from_orgs_v
    WHERE  organization_id = p_ship_from_org_id
    AND    ROWNUM = 1;
Line: 3384

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

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

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

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

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

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

    SELECT 'VALID'
    INTO   l_dummy
    FROM   oe_ship_to_orgs_v
    WHERE  organization_id = p_ship_to_org_id
    AND    ROWNUM = 1;
Line: 3551

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

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

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

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

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

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

    SELECT  'VALID'
    INTO    l_dummy
    FROM    OE_INVOICE_TO_ORGS_V   INV
    WHERE   INV.ORGANIZATION_ID =p_invoice_to_org_id
    AND     ROWNUM = 1;
Line: 3718

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

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

    SELECT  'VALID'
    INTO    l_dummy
    FROM    OE_DELIVER_TO_ORGS_V   DEL
    WHERE   DEL.ORGANIZATION_ID =p_deliver_to_org_id
    AND     ROWNUM = 1;
Line: 3782

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

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

    SELECT  'VALID'
    INTO    l_dummy
    FROM    OE_RA_CONTACTS_V
    WHERE   CONTACT_ID = p_sold_to_contact_id
    AND     ROWNUM = 1;
Line: 3845

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

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

    SELECT  'VALID'
    INTO    l_dummy
    FROM    OE_RA_CONTACTS_V                CON
    ,       OE_RA_CONTACT_ROLES_V           ROL
    WHERE   CON.CONTACT_ID = p_ship_to_contact_id
    AND     CON.CONTACT_ID = ROL.CONTACT_ID (+)
    AND     NVL( ROL.USAGE_CODE,'SHIP_TO')='SHIP_TO'
    AND     ROWNUM = 1;
Line: 3912

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

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

    SELECT  'VALID'
    INTO    l_dummy
    FROM    OE_RA_CONTACTS_V                CON
    ,       OE_RA_CONTACT_ROLES_V           ROL
    WHERE   CON.CONTACT_ID = p_intermed_ship_to_contact_id
    AND     CON.CONTACT_ID = ROL.CONTACT_ID (+)
    AND     NVL( ROL.USAGE_CODE,'SHIP_TO')='SHIP_TO'
    AND     ROWNUM = 1;
Line: 3978

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

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

    SELECT  'VALID'
    INTO    l_dummy
    FROM    OE_RA_CONTACTS_V                CON
    ,       OE_RA_CONTACT_ROLES_V           ROL
    WHERE   CON.CONTACT_ID = p_invoice_to_contact_id
    AND     CON.CONTACT_ID = ROL.CONTACT_ID (+)
    AND     NVL( ROL.USAGE_CODE,'BILL_TO')='BILL_TO'
    AND     ROWNUM = 1;
Line: 4044

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

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

    SELECT  'VALID'
    INTO    l_dummy
    FROM    OE_RA_CONTACTS_V                CON
    ,       OE_RA_CONTACT_ROLES_V           ROL
    WHERE   CON.CONTACT_ID = p_deliver_to_contact_id
    AND     CON.CONTACT_ID = ROL.CONTACT_ID (+)
    AND     NVL( ROL.USAGE_CODE,'SHIP_TO')='SHIP_TO'
    AND     ROWNUM = 1;
Line: 4109

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

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

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

    IF p_last_updated_by IS NULL OR
        p_last_updated_by = FND_API.G_MISS_NUM
    THEN

        RETURN TRUE;
Line: 4168

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

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

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

            ,   'Last_Updated_By'
            );
Line: 4194

END Last_Updated_By;
Line: 4196

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

    IF p_last_update_date IS NULL OR
        p_last_update_date = FND_API.G_MISS_DATE
    THEN

        RETURN TRUE;
Line: 4225

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

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

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

            ,   'Last_Update_Date'
            );
Line: 4251

END Last_Update_Date;
Line: 4253

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

    IF p_last_update_login IS NULL OR
        p_last_update_login = FND_API.G_MISS_NUM
    THEN

        RETURN TRUE;
Line: 4282

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

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

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

            ,   'Last_Update_Login'
            );
Line: 4308

END Last_Update_Login;
Line: 4339

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

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

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

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

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

    IF p_program_update_date IS NULL OR
        p_program_update_date = FND_API.G_MISS_DATE
    THEN

        RETURN TRUE;
Line: 4453

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

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

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

            ,   'Program_Update_Date'
            );
Line: 4479

END Program_Update_Date;
Line: 4510

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    IF p_Updated_Flag IS NULL OR
        p_Updated_Flag = FND_API.G_MISS_NUM
    THEN

        RETURN TRUE;
Line: 5504

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

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

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

            ,   'Updated_Flag'
            );
Line: 5530

END Updated_Flag;
Line: 5533

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

    IF p_Update_Allowed IS NULL OR
        p_Update_Allowed = FND_API.G_MISS_NUM
    THEN

        RETURN TRUE;
Line: 5562

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

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

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

            ,   'Update_Allowed'
            );
Line: 5588

END Update_Allowed;
Line: 5619

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

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

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

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

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

       select 'VALID'
       from ra_salesreps_all
       where salesrep_id = p_salesrep_id;
Line: 5738

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

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

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

    IF p_dw_update_advice_flag IS NULL OR
        p_dw_update_advice_flag = FND_API.G_MISS_CHAR
    THEN

        RETURN TRUE;
Line: 5797

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

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

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

            ,   'Dw_Update_Advice'
            );
Line: 5823

END Dw_Update_Advice;
Line: 5825

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

    IF p_wh_update_date IS NULL OR
        p_wh_update_date = FND_API.G_MISS_DATE
    THEN

        RETURN TRUE;
Line: 5854

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

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

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

            ,   'Wh_Update_Date'
            );
Line: 5880

END Wh_Update_Date;
Line: 5912

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    SELECT  'VALID'
    INTO    l_dummy
    FROM    OE_RA_RULES_V
    WHERE   RULE_ID = p_accounting_rule_id
    AND     ROWNUM=1;
Line: 9940

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

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

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

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

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

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

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

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

    SELECT  'VALID'
    INTO    l_dummy
    FROM    OE_LOOKUPS
    WHERE   LOOKUP_CODE = p_order_date_type_code
    AND     LOOKUP_TYPE = l_lookup_type
    AND     ROWNUM = 1;
Line: 10180

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

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

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

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

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

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

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

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

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

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

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

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

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

    IF p_auto_selected_quantity IS NULL OR
        p_auto_selected_quantity = FND_API.G_MISS_NUM
    THEN

        RETURN TRUE;
Line: 10528

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

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

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

            ,   'Auto_Selected_Quantity'
            );
Line: 10554

END Auto_Selected_Quantity;
Line: 10585

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    SELECT  'VALID'
    INTO    l_dummy
    FROM    OE_AR_LOOKUPS_V
    WHERE   LOOKUP_CODE = p_return_reason_code
    AND     LOOKUP_TYPE = l_lookup_type;
Line: 17719

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    SELECT  'VALID'
    INTO    l_dummy
    FROM    OE_LOOKUPS
    WHERE   LOOKUP_CODE = p_payment_type_code
    AND     LOOKUP_TYPE = l_lookup_type
    AND     ROWNUM = 1;
Line: 18273

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

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

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

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

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

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

    SELECT  'VALID'
    INTO    l_dummy
    FROM    OE_LOOKUPS
    WHERE   LOOKUP_CODE = p_credit_card_code
    AND     LOOKUP_TYPE = l_lookup_type
    AND     ROWNUM = 1;
Line: 18457

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    SELECT  'VALID'
    INTO    l_dummy
    FROM    OE_LOOKUPS
    WHERE   LOOKUP_CODE = p_flow_status_code
    AND     LOOKUP_TYPE = l_lookup_type
    AND     ROWNUM = 1;
Line: 19918

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

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

    SELECT  'VALID'
    INTO    l_dummy
    FROM    OE_LOOKUPS
    WHERE   LOOKUP_CODE = p_flow_status_code
    AND     LOOKUP_TYPE = l_lookup_type
    AND     ROWNUM = 1;
Line: 19982

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

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

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

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

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

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

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

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

    SELECT  'VALID'
    INTO     l_dummy
    FROM     QP_CHARGE_LOOKUP
    WHERE    LOOKUP_CODE = p_charge_type_code
    AND      ROWNUM=1;
Line: 20211

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

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

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

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

        SELECT  'VALID'
        INTO    l_dummy
        FROM    RA_CUSTOMER_TRX
        WHERE   customer_trx_id = p_commitment_id
        AND     ROWNUM = 1;
Line: 20325

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

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

    SELECT  'VALID'
    INTO     l_dummy
    FROM     OE_LOOKUPS
    WHERE    LOOKUP_CODE = p_credit_or_charge_flag
    AND      LOOKUP_TYPE = l_lookup_type
    AND      ROWNUM = 1;
Line: 20388

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

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

    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      ROWNUM = 1;
Line: 20451

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

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

    SELECT  'VALID'
    INTO     l_dummy
    FROM     OE_LOOKUPS
    WHERE    LOOKUP_CODE = p_sales_channel_code
    AND      LOOKUP_TYPE = l_lookup_type
    AND      ROWNUM = 1;
Line: 20526

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

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

    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';
Line: 20582

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

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);