DBA Data[Home] [Help]

APPS.OE_BULK_PROCESS_LINE dependencies on OE_GLOBALS

Line 136: <> OE_GLOBALS.G_RETURN_CATEGORY_CODE THEN

132: -- Ship To and Payment Term required on ORDER lines,
133: -- NOT on RETURN lines
134:
135: IF p_line_rec.line_category_code(p_index)
136: <> OE_GLOBALS.G_RETURN_CATEGORY_CODE THEN
137:
138: IF p_line_rec.ship_to_org_id(p_index) IS NULL THEN
139: x_return_status := FND_API.G_RET_STS_ERROR;
140: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');

Line 335: p_line_rec.item_type_code(p_index) IN ( OE_GLOBALS.G_ITEM_OPTION,

331: -- ATO checks for config support
332:
333: IF p_line_rec.ato_line_id(p_index) is not null AND
334: NOT(p_line_rec.ato_line_id(p_index) = p_line_rec.line_id(p_index) AND
335: p_line_rec.item_type_code(p_index) IN ( OE_GLOBALS.G_ITEM_OPTION,
336: OE_GLOBALS.G_ITEM_STANDARD,
337: OE_GLOBALS.G_ITEM_INCLUDED)) --9775352
338: THEN
339: IF MSC_ATP_GLOBAL.GET_APS_VERSION <> 10 AND

Line 336: OE_GLOBALS.G_ITEM_STANDARD,

332:
333: IF p_line_rec.ato_line_id(p_index) is not null AND
334: NOT(p_line_rec.ato_line_id(p_index) = p_line_rec.line_id(p_index) AND
335: p_line_rec.item_type_code(p_index) IN ( OE_GLOBALS.G_ITEM_OPTION,
336: OE_GLOBALS.G_ITEM_STANDARD,
337: OE_GLOBALS.G_ITEM_INCLUDED)) --9775352
338: THEN
339: IF MSC_ATP_GLOBAL.GET_APS_VERSION <> 10 AND
340: p_line_rec.ship_from_org_id(p_index) is NULL

Line 337: OE_GLOBALS.G_ITEM_INCLUDED)) --9775352

333: IF p_line_rec.ato_line_id(p_index) is not null AND
334: NOT(p_line_rec.ato_line_id(p_index) = p_line_rec.line_id(p_index) AND
335: p_line_rec.item_type_code(p_index) IN ( OE_GLOBALS.G_ITEM_OPTION,
336: OE_GLOBALS.G_ITEM_STANDARD,
337: OE_GLOBALS.G_ITEM_INCLUDED)) --9775352
338: THEN
339: IF MSC_ATP_GLOBAL.GET_APS_VERSION <> 10 AND
340: p_line_rec.ship_from_org_id(p_index) is NULL
341: THEN

Line 934: IF p_item_type_code = OE_GLOBALS.G_ITEM_INCLUDED OR

930: AND org.organization_id= p_ship_from_org_id
931: AND rownum=1;
932:
933: ELSE /* other orders except Internal*/
934: IF p_item_type_code = OE_GLOBALS.G_ITEM_INCLUDED OR
935: p_item_type_code = OE_GLOBALS.G_ITEM_CONFIG OR
936: p_item_type_code = OE_GLOBALS.G_ITEM_CLASS OR
937: p_item_type_code = OE_GLOBALS.G_ITEM_OPTION OR
938: (p_item_type_code = OE_GLOBALS.G_ITEM_KIT AND

Line 935: p_item_type_code = OE_GLOBALS.G_ITEM_CONFIG OR

931: AND rownum=1;
932:
933: ELSE /* other orders except Internal*/
934: IF p_item_type_code = OE_GLOBALS.G_ITEM_INCLUDED OR
935: p_item_type_code = OE_GLOBALS.G_ITEM_CONFIG OR
936: p_item_type_code = OE_GLOBALS.G_ITEM_CLASS OR
937: p_item_type_code = OE_GLOBALS.G_ITEM_OPTION OR
938: (p_item_type_code = OE_GLOBALS.G_ITEM_KIT AND
939: nvl(p_top_model_line_id, -1) <> p_line_id)

Line 936: p_item_type_code = OE_GLOBALS.G_ITEM_CLASS OR

932:
933: ELSE /* other orders except Internal*/
934: IF p_item_type_code = OE_GLOBALS.G_ITEM_INCLUDED OR
935: p_item_type_code = OE_GLOBALS.G_ITEM_CONFIG OR
936: p_item_type_code = OE_GLOBALS.G_ITEM_CLASS OR
937: p_item_type_code = OE_GLOBALS.G_ITEM_OPTION OR
938: (p_item_type_code = OE_GLOBALS.G_ITEM_KIT AND
939: nvl(p_top_model_line_id, -1) <> p_line_id)
940: THEN

Line 937: p_item_type_code = OE_GLOBALS.G_ITEM_OPTION OR

933: ELSE /* other orders except Internal*/
934: IF p_item_type_code = OE_GLOBALS.G_ITEM_INCLUDED OR
935: p_item_type_code = OE_GLOBALS.G_ITEM_CONFIG OR
936: p_item_type_code = OE_GLOBALS.G_ITEM_CLASS OR
937: p_item_type_code = OE_GLOBALS.G_ITEM_OPTION OR
938: (p_item_type_code = OE_GLOBALS.G_ITEM_KIT AND
939: nvl(p_top_model_line_id, -1) <> p_line_id)
940: THEN
941: --perf bug 5121218, replace org_organization_definitions with

Line 938: (p_item_type_code = OE_GLOBALS.G_ITEM_KIT AND

934: IF p_item_type_code = OE_GLOBALS.G_ITEM_INCLUDED OR
935: p_item_type_code = OE_GLOBALS.G_ITEM_CONFIG OR
936: p_item_type_code = OE_GLOBALS.G_ITEM_CLASS OR
937: p_item_type_code = OE_GLOBALS.G_ITEM_OPTION OR
938: (p_item_type_code = OE_GLOBALS.G_ITEM_KIT AND
939: nvl(p_top_model_line_id, -1) <> p_line_id)
940: THEN
941: --perf bug 5121218, replace org_organization_definitions with
942: --hr_all_organization_units

Line 1133: IF p_item_type_code = OE_GLOBALS.G_ITEM_INCLUDED OR

1129: RETURN FALSE;
1130: END IF;
1131: ELSE /* other orders except Internal*/
1132:
1133: IF p_item_type_code = OE_GLOBALS.G_ITEM_INCLUDED OR
1134: p_item_type_code = OE_GLOBALS.G_ITEM_CONFIG OR
1135: p_item_type_code = OE_GLOBALS.G_ITEM_CLASS OR
1136: p_item_type_code = OE_GLOBALS.G_ITEM_OPTION OR
1137: (p_item_type_code = OE_GLOBALS.G_ITEM_KIT AND

Line 1134: p_item_type_code = OE_GLOBALS.G_ITEM_CONFIG OR

1130: END IF;
1131: ELSE /* other orders except Internal*/
1132:
1133: IF p_item_type_code = OE_GLOBALS.G_ITEM_INCLUDED OR
1134: p_item_type_code = OE_GLOBALS.G_ITEM_CONFIG OR
1135: p_item_type_code = OE_GLOBALS.G_ITEM_CLASS OR
1136: p_item_type_code = OE_GLOBALS.G_ITEM_OPTION OR
1137: (p_item_type_code = OE_GLOBALS.G_ITEM_KIT AND
1138: nvl(p_top_model_line_id, -1) <> p_line_id)

Line 1135: p_item_type_code = OE_GLOBALS.G_ITEM_CLASS OR

1131: ELSE /* other orders except Internal*/
1132:
1133: IF p_item_type_code = OE_GLOBALS.G_ITEM_INCLUDED OR
1134: p_item_type_code = OE_GLOBALS.G_ITEM_CONFIG OR
1135: p_item_type_code = OE_GLOBALS.G_ITEM_CLASS OR
1136: p_item_type_code = OE_GLOBALS.G_ITEM_OPTION OR
1137: (p_item_type_code = OE_GLOBALS.G_ITEM_KIT AND
1138: nvl(p_top_model_line_id, -1) <> p_line_id)
1139: THEN

Line 1136: p_item_type_code = OE_GLOBALS.G_ITEM_OPTION OR

1132:
1133: IF p_item_type_code = OE_GLOBALS.G_ITEM_INCLUDED OR
1134: p_item_type_code = OE_GLOBALS.G_ITEM_CONFIG OR
1135: p_item_type_code = OE_GLOBALS.G_ITEM_CLASS OR
1136: p_item_type_code = OE_GLOBALS.G_ITEM_OPTION OR
1137: (p_item_type_code = OE_GLOBALS.G_ITEM_KIT AND
1138: nvl(p_top_model_line_id, -1) <> p_line_id)
1139: THEN
1140: RETURN TRUE;

Line 1137: (p_item_type_code = OE_GLOBALS.G_ITEM_KIT AND

1133: IF p_item_type_code = OE_GLOBALS.G_ITEM_INCLUDED OR
1134: p_item_type_code = OE_GLOBALS.G_ITEM_CONFIG OR
1135: p_item_type_code = OE_GLOBALS.G_ITEM_CLASS OR
1136: p_item_type_code = OE_GLOBALS.G_ITEM_OPTION OR
1137: (p_item_type_code = OE_GLOBALS.G_ITEM_KIT AND
1138: nvl(p_top_model_line_id, -1) <> p_line_id)
1139: THEN
1140: RETURN TRUE;
1141: ELSE /* item type is MODEL,STANDARD,SERVICE,KIT in top most level*/

Line 1836: p_line_rec.item_type_code(p_index) := OE_GLOBALS.G_ITEM_STANDARD;

1832: p_line_rec.item_type_code(p_index) := 'OPTION';
1833: oe_debug_pub.add( 'Populate_Internal_Fields bb' ) ;
1834: ELSE
1835: -- Standard Item
1836: p_line_rec.item_type_code(p_index) := OE_GLOBALS.G_ITEM_STANDARD;
1837: END IF;
1838: END IF; --bom_item_type = 4
1839:
1840: END IF; -- item_type_code IS NULL

Line 1941: p_line_rec.item_type_code(p_index) := OE_GLOBALS.G_ITEM_KIT;

1937: oe_debug_pub.add( 'Populate_Internal_Fields 6a' ) ;
1938: -- KIT Item
1939: IF OE_BULK_CACHE.G_ITEM_TBL(l_c_index).pick_components_flag = 'Y' THEN
1940: oe_debug_pub.add( 'Populate_Internal_Fields 7a' ) ;
1941: p_line_rec.item_type_code(p_index) := OE_GLOBALS.G_ITEM_KIT;
1942: p_line_rec.component_code(p_index) := to_char(l_inventory_item_id);
1943: p_line_rec.top_model_line_id(p_index)
1944: := p_line_rec.line_id(p_index);
1945: p_line_rec.ship_model_complete_flag(p_index)

Line 1953: p_line_rec.item_type_code(p_index) := OE_GLOBALS.G_ITEM_STANDARD;

1949: p_line_rec.ship_tolerance_below(p_index) := 0;
1950:
1951: -- Standard Item
1952: ELSE
1953: p_line_rec.item_type_code(p_index) := OE_GLOBALS.G_ITEM_STANDARD;
1954: END IF;
1955: END IF;
1956: oe_debug_pub.add( 'Populate_Internal_Fields 8a' ) ;
1957: p_line_rec.shippable_flag(p_index)

Line 2837: IF ( p_line_rec.item_type_code(l_index) = OE_GLOBALS.G_ITEM_MODEL OR

2833: ,x_return_status => p_line_rec.lock_control(l_index)
2834: );
2835:
2836: -- Validate UOM
2837: IF ( p_line_rec.item_type_code(l_index) = OE_GLOBALS.G_ITEM_MODEL OR
2838: p_line_rec.item_type_code(l_index) = OE_GLOBALS.G_ITEM_CLASS OR
2839: p_line_rec.item_type_code(l_index) = OE_GLOBALS.G_ITEM_OPTION OR
2840: p_line_rec.item_type_code(l_index) = OE_GLOBALS.G_ITEM_KIT OR
2841: p_line_rec.item_type_code(l_index) = OE_GLOBALS.G_ITEM_INCLUDED OR

Line 2838: p_line_rec.item_type_code(l_index) = OE_GLOBALS.G_ITEM_CLASS OR

2834: );
2835:
2836: -- Validate UOM
2837: IF ( p_line_rec.item_type_code(l_index) = OE_GLOBALS.G_ITEM_MODEL OR
2838: p_line_rec.item_type_code(l_index) = OE_GLOBALS.G_ITEM_CLASS OR
2839: p_line_rec.item_type_code(l_index) = OE_GLOBALS.G_ITEM_OPTION OR
2840: p_line_rec.item_type_code(l_index) = OE_GLOBALS.G_ITEM_KIT OR
2841: p_line_rec.item_type_code(l_index) = OE_GLOBALS.G_ITEM_INCLUDED OR
2842: p_line_rec.item_type_code(l_index) = OE_GLOBALS.G_ITEM_CONFIG)

Line 2839: p_line_rec.item_type_code(l_index) = OE_GLOBALS.G_ITEM_OPTION OR

2835:
2836: -- Validate UOM
2837: IF ( p_line_rec.item_type_code(l_index) = OE_GLOBALS.G_ITEM_MODEL OR
2838: p_line_rec.item_type_code(l_index) = OE_GLOBALS.G_ITEM_CLASS OR
2839: p_line_rec.item_type_code(l_index) = OE_GLOBALS.G_ITEM_OPTION OR
2840: p_line_rec.item_type_code(l_index) = OE_GLOBALS.G_ITEM_KIT OR
2841: p_line_rec.item_type_code(l_index) = OE_GLOBALS.G_ITEM_INCLUDED OR
2842: p_line_rec.item_type_code(l_index) = OE_GLOBALS.G_ITEM_CONFIG)
2843: THEN

Line 2840: p_line_rec.item_type_code(l_index) = OE_GLOBALS.G_ITEM_KIT OR

2836: -- Validate UOM
2837: IF ( p_line_rec.item_type_code(l_index) = OE_GLOBALS.G_ITEM_MODEL OR
2838: p_line_rec.item_type_code(l_index) = OE_GLOBALS.G_ITEM_CLASS OR
2839: p_line_rec.item_type_code(l_index) = OE_GLOBALS.G_ITEM_OPTION OR
2840: p_line_rec.item_type_code(l_index) = OE_GLOBALS.G_ITEM_KIT OR
2841: p_line_rec.item_type_code(l_index) = OE_GLOBALS.G_ITEM_INCLUDED OR
2842: p_line_rec.item_type_code(l_index) = OE_GLOBALS.G_ITEM_CONFIG)
2843: THEN
2844:

Line 2841: p_line_rec.item_type_code(l_index) = OE_GLOBALS.G_ITEM_INCLUDED OR

2837: IF ( p_line_rec.item_type_code(l_index) = OE_GLOBALS.G_ITEM_MODEL OR
2838: p_line_rec.item_type_code(l_index) = OE_GLOBALS.G_ITEM_CLASS OR
2839: p_line_rec.item_type_code(l_index) = OE_GLOBALS.G_ITEM_OPTION OR
2840: p_line_rec.item_type_code(l_index) = OE_GLOBALS.G_ITEM_KIT OR
2841: p_line_rec.item_type_code(l_index) = OE_GLOBALS.G_ITEM_INCLUDED OR
2842: p_line_rec.item_type_code(l_index) = OE_GLOBALS.G_ITEM_CONFIG)
2843: THEN
2844:
2845: BEGIN

Line 2842: p_line_rec.item_type_code(l_index) = OE_GLOBALS.G_ITEM_CONFIG)

2838: p_line_rec.item_type_code(l_index) = OE_GLOBALS.G_ITEM_CLASS OR
2839: p_line_rec.item_type_code(l_index) = OE_GLOBALS.G_ITEM_OPTION OR
2840: p_line_rec.item_type_code(l_index) = OE_GLOBALS.G_ITEM_KIT OR
2841: p_line_rec.item_type_code(l_index) = OE_GLOBALS.G_ITEM_INCLUDED OR
2842: p_line_rec.item_type_code(l_index) = OE_GLOBALS.G_ITEM_CONFIG)
2843: THEN
2844:
2845: BEGIN
2846: SELECT primary_uom_code

Line 3041: IF ( NVL( p_line_rec.item_type_code(l_index),OE_GLOBALS.G_ITEM_STANDARD) = OE_GLOBALS.G_ITEM_STANDARD

3037: END IF;
3038:
3039: --Item Orderability
3040: --Validate Item Orderability Rules
3041: IF ( NVL( p_line_rec.item_type_code(l_index),OE_GLOBALS.G_ITEM_STANDARD) = OE_GLOBALS.G_ITEM_STANDARD
3042: OR ( p_line_rec.item_type_code(l_index) = OE_GLOBALS.G_ITEM_MODEL )
3043: ) then
3044:
3045: oe_debug_pub.add(' Checking Validate_item_orderability ');

Line 3042: OR ( p_line_rec.item_type_code(l_index) = OE_GLOBALS.G_ITEM_MODEL )

3038:
3039: --Item Orderability
3040: --Validate Item Orderability Rules
3041: IF ( NVL( p_line_rec.item_type_code(l_index),OE_GLOBALS.G_ITEM_STANDARD) = OE_GLOBALS.G_ITEM_STANDARD
3042: OR ( p_line_rec.item_type_code(l_index) = OE_GLOBALS.G_ITEM_MODEL )
3043: ) then
3044:
3045: oe_debug_pub.add(' Checking Validate_item_orderability ');
3046: --oe_debug_pub.add(' org id :' || p_line_rec.org_id(l_index));

Line 3099: AND (NOT OE_GLOBALS.Equal(p_line_rec.agreement_id(l_index),

3095:
3096:
3097: -- Agreement related validation
3098: IF p_line_rec.agreement_id(l_index) IS NOT NULL
3099: AND (NOT OE_GLOBALS.Equal(p_line_rec.agreement_id(l_index),
3100: p_header_rec.agreement_id(header_counter))
3101: OR NOT OE_GLOBALS.Equal(p_line_rec.pricing_date(l_index),
3102: p_header_rec.pricing_date(header_counter))
3103: OR NOT OE_GLOBALS.Equal(p_line_rec.price_list_id(l_index),

Line 3101: OR NOT OE_GLOBALS.Equal(p_line_rec.pricing_date(l_index),

3097: -- Agreement related validation
3098: IF p_line_rec.agreement_id(l_index) IS NOT NULL
3099: AND (NOT OE_GLOBALS.Equal(p_line_rec.agreement_id(l_index),
3100: p_header_rec.agreement_id(header_counter))
3101: OR NOT OE_GLOBALS.Equal(p_line_rec.pricing_date(l_index),
3102: p_header_rec.pricing_date(header_counter))
3103: OR NOT OE_GLOBALS.Equal(p_line_rec.price_list_id(l_index),
3104: p_header_rec.price_list_id(header_counter))
3105: )

Line 3103: OR NOT OE_GLOBALS.Equal(p_line_rec.price_list_id(l_index),

3099: AND (NOT OE_GLOBALS.Equal(p_line_rec.agreement_id(l_index),
3100: p_header_rec.agreement_id(header_counter))
3101: OR NOT OE_GLOBALS.Equal(p_line_rec.pricing_date(l_index),
3102: p_header_rec.pricing_date(header_counter))
3103: OR NOT OE_GLOBALS.Equal(p_line_rec.price_list_id(l_index),
3104: p_header_rec.price_list_id(header_counter))
3105: )
3106: THEN
3107:

Line 3127: AND NOT OE_GLOBALS.Equal(p_line_rec.price_list_id(l_index),

3123:
3124: -- Price List related validations
3125:
3126: IF p_line_rec.price_list_id(l_index) IS NOT NULL
3127: AND NOT OE_GLOBALS.Equal(p_line_rec.price_list_id(l_index),
3128: p_header_rec.price_list_id(header_counter))
3129: THEN
3130:
3131: -- Error messages are populated in Validate_Price_List

Line 3150: AND NOT OE_GLOBALS.Equal(p_line_rec.invoice_to_org_id(l_index),

3146:
3147: -- Validate Customer , customer contact and Sites
3148: -- Validate Bill-to for customer
3149: IF p_line_rec.invoice_to_org_id(l_index) IS NOT NULL
3150: AND NOT OE_GLOBALS.Equal(p_line_rec.invoice_to_org_id(l_index),
3151: p_header_rec.invoice_to_org_id(header_counter))
3152: THEN
3153:
3154: IF NOT OE_BULK_PROCESS_HEADER.Validate_Bill_To

Line 3173: AND NOT OE_GLOBALS.Equal(p_line_rec.ship_to_org_id(l_index),

3169: END IF; -- Invoice to is not null
3170:
3171: -- Validate ship-to for customer
3172: IF p_line_rec.ship_to_org_id(l_index) IS NOT NULL
3173: AND NOT OE_GLOBALS.Equal(p_line_rec.ship_to_org_id(l_index),
3174: p_header_rec.ship_to_org_id(header_counter))
3175: THEN
3176:
3177: IF NOT OE_BULK_PROCESS_HEADER.Validate_Ship_To

Line 3195: AND NOT OE_GLOBALS.Equal(p_line_rec.deliver_to_org_id(l_index),

3191:
3192: END IF; -- ship to is not null
3193:
3194: IF p_line_rec.deliver_to_org_id(l_index) IS NOT NULL
3195: AND NOT OE_GLOBALS.Equal(p_line_rec.deliver_to_org_id(l_index),
3196: p_header_rec.deliver_to_org_id(header_counter))
3197: THEN
3198:
3199: IF NOT OE_BULK_PROCESS_HEADER.Validate_Deliver_To

Line 3224: IF NOT OE_GLOBALS.EQUAL(p_line_rec.invoice_to_org_id(l_index),

3220: -- Validate Bill to contact
3221: IF p_line_rec.invoice_to_contact_id(l_index) IS NOT NULL
3222: THEN
3223:
3224: IF NOT OE_GLOBALS.EQUAL(p_line_rec.invoice_to_org_id(l_index),
3225: p_header_rec.invoice_to_org_id(
3226: header_counter))
3227: OR
3228: NOT OE_GLOBALS.EQUAL(p_line_rec.invoice_to_contact_id(l_index),

Line 3228: NOT OE_GLOBALS.EQUAL(p_line_rec.invoice_to_contact_id(l_index),

3224: IF NOT OE_GLOBALS.EQUAL(p_line_rec.invoice_to_org_id(l_index),
3225: p_header_rec.invoice_to_org_id(
3226: header_counter))
3227: OR
3228: NOT OE_GLOBALS.EQUAL(p_line_rec.invoice_to_contact_id(l_index),
3229: p_header_rec.invoice_to_contact_id(
3230: header_counter))
3231: THEN
3232:

Line 3253: IF NOT OE_GLOBALS.EQUAL(p_line_rec.Ship_to_org_id(l_index),

3249: -- Validate Ship to contact
3250: IF p_line_rec.Ship_to_contact_id(l_index) IS NOT NULL
3251: THEN
3252:
3253: IF NOT OE_GLOBALS.EQUAL(p_line_rec.Ship_to_org_id(l_index),
3254: p_header_rec.Ship_to_org_id(
3255: header_counter)) OR
3256: NOT OE_GLOBALS.EQUAL(p_line_rec.Ship_to_contact_id(l_index),
3257: p_header_rec.Ship_to_contact_id(

Line 3256: NOT OE_GLOBALS.EQUAL(p_line_rec.Ship_to_contact_id(l_index),

3252:
3253: IF NOT OE_GLOBALS.EQUAL(p_line_rec.Ship_to_org_id(l_index),
3254: p_header_rec.Ship_to_org_id(
3255: header_counter)) OR
3256: NOT OE_GLOBALS.EQUAL(p_line_rec.Ship_to_contact_id(l_index),
3257: p_header_rec.Ship_to_contact_id(
3258: header_counter))
3259: THEN
3260:

Line 3280: IF NOT OE_GLOBALS.EQUAL(p_line_rec.Deliver_to_org_id(l_index),

3276: -- Validate Deliver to contact
3277: IF p_line_rec.Deliver_to_contact_id(l_index) IS NOT NULL
3278: THEN
3279:
3280: IF NOT OE_GLOBALS.EQUAL(p_line_rec.Deliver_to_org_id(l_index),
3281: p_header_rec.Deliver_to_org_id(
3282: header_counter)) OR
3283: NOT OE_GLOBALS.EQUAL(p_line_rec.Deliver_to_contact_id(l_index),
3284: p_header_rec.Deliver_to_contact_id(

Line 3283: NOT OE_GLOBALS.EQUAL(p_line_rec.Deliver_to_contact_id(l_index),

3279:
3280: IF NOT OE_GLOBALS.EQUAL(p_line_rec.Deliver_to_org_id(l_index),
3281: p_header_rec.Deliver_to_org_id(
3282: header_counter)) OR
3283: NOT OE_GLOBALS.EQUAL(p_line_rec.Deliver_to_contact_id(l_index),
3284: p_header_rec.Deliver_to_contact_id(
3285: header_counter))
3286: THEN
3287:

Line 3306: AND NOT OE_GLOBALS.Equal(p_line_rec.end_Customer_id(l_index),p_header_rec.end_customer_id(header_counter))THEN

3302:
3303: --{Bug 5054618
3304: --End customer changes
3305: IF p_line_rec.end_Customer_id(l_index) IS NOT NULL
3306: AND NOT OE_GLOBALS.Equal(p_line_rec.end_Customer_id(l_index),p_header_rec.end_customer_id(header_counter))THEN
3307: IF NOT OE_BULK_PROCESS_HEADER.Validate_End_Customer(p_line_rec.end_customer_id(l_index)) THEN
3308: p_line_rec.lock_control(l_index) := -99;
3309: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
3310: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name('end_customer_id'));

Line 3316: NOT OE_GLOBALS.Equal(p_line_rec.end_Customer_Contact_id(l_index),p_header_rec.end_customer_Contact_id(header_counter)) THEN

3312: END IF;
3313: END IF;
3314:
3315: IF p_line_rec.end_Customer_Contact_id(l_index) IS NOT NULL AND
3316: NOT OE_GLOBALS.Equal(p_line_rec.end_Customer_Contact_id(l_index),p_header_rec.end_customer_Contact_id(header_counter)) THEN
3317: IF NOT OE_BULK_PROCESS_HEADER.Validate_End_Customer_Contact(p_line_rec.end_customer_contact_id(l_index)) THEN
3318: p_line_rec.lock_control(l_index) := -99;
3319: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
3320: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name('end_customer_contact_id'));

Line 3327: OE_GLOBALS.Equal(p_line_rec.end_Customer_site_use_id(l_index),p_header_rec.end_customer_site_use_id(header_counter)) THEN

3323: END IF;
3324:
3325:
3326: IF p_line_rec.end_Customer_site_use_id(l_index) IS NOT NULL AND NOT
3327: OE_GLOBALS.Equal(p_line_rec.end_Customer_site_use_id(l_index),p_header_rec.end_customer_site_use_id(header_counter)) THEN
3328: IF NOT OE_BULK_PROCESS_HEADER.Validate_End_Customer_site_use(p_line_rec.end_customer_site_use_id(l_index),
3329: p_line_rec.end_customer_id(l_index)) THEN
3330: p_line_rec.lock_control(l_index) := -99;
3331: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');

Line 3338: OE_GLOBALS.Equal(p_line_rec.IB_owner(l_index),p_header_rec.IB_owner(header_counter))THEN

3334: END IF;
3335: END IF;
3336:
3337: IF p_line_rec.IB_owner(l_index) IS NOT NULL AND NOT
3338: OE_GLOBALS.Equal(p_line_rec.IB_owner(l_index),p_header_rec.IB_owner(header_counter))THEN
3339: IF NOT OE_BULK_PROCESS_HEADER.Validate_IB_Owner(p_line_rec.IB_owner(l_index)) THEN
3340: p_line_rec.lock_control(l_index) := -99;
3341: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
3342: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name('IB_owner'));

Line 3348: OE_GLOBALS.Equal(p_line_rec.IB_current_location(l_index),p_header_rec.IB_current_location(header_counter)) THEN

3344: END IF;
3345: END IF;
3346:
3347: IF p_line_rec.IB_current_location(l_index) IS NOT NULL AND NOT
3348: OE_GLOBALS.Equal(p_line_rec.IB_current_location(l_index),p_header_rec.IB_current_location(header_counter)) THEN
3349: IF NOT OE_BULK_PROCESS_HEADER.Validate_IB_current_Location (p_line_rec.IB_current_location(l_index)) THEN
3350: p_line_rec.lock_control(l_index) := -99;
3351: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
3352: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name('IB_location'));

Line 3358: OE_GLOBALS.Equal(p_line_rec.IB_Installed_at_location(l_index),p_header_rec.IB_Installed_at_location(header_counter)) THEN

3354: END IF;
3355: END IF;
3356:
3357: IF p_line_rec.IB_Installed_at_location(l_index) IS NOT NULL AND NOT
3358: OE_GLOBALS.Equal(p_line_rec.IB_Installed_at_location(l_index),p_header_rec.IB_Installed_at_location(header_counter)) THEN
3359: IF NOT OE_BULK_PROCESS_HEADER.Validate_IB_Inst_loc(p_line_rec.IB_Installed_at_location(l_index)) THEN
3360: p_line_rec.lock_control(l_index) := -99;
3361: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
3362: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name('Installed_at_location'));

Line 3499: l_AR_Sys_Param_Rec := OE_Sys_Parameters_Pvt.Get_AR_Sys_Params(OE_GLOBALS.G_ORG_ID);

3495: -- EBTax Changes
3496: /*
3497: IF oe_code_control.code_release_level >= '110510' THEN
3498:
3499: l_AR_Sys_Param_Rec := OE_Sys_Parameters_Pvt.Get_AR_Sys_Params(OE_GLOBALS.G_ORG_ID);
3500: l_sob_id := l_AR_Sys_Param_Rec.set_of_books_id;
3501:
3502: SELECT 'VALID'
3503: INTO l_dummy