DBA Data[Home] [Help]

APPS.OE_VALIDATE_LINE dependencies on OE_ID_TO_VALUE

Line 949: FND_MESSAGE.SET_TOKEN('ITEM', nvl(OE_Id_To_Value.Inventory_Item(p_item_id),p_item_id));

945: IF l_debug_level > 0 then
946: OE_DEBUG_PUB.Add('item is config related with decimal qty',2);
947: END IF;
948: FND_MESSAGE.SET_NAME('ONT', 'OE_CONFIG_NO_DECIMALS');
949: FND_MESSAGE.SET_TOKEN('ITEM', nvl(OE_Id_To_Value.Inventory_Item(p_item_id),p_item_id));
950: FND_Message.Set_Token('LINE_NUM', p_line_num);
951: OE_MSG_PUB.Add;
952: x_return_status := FND_API.G_RET_STS_ERROR;
953: END IF;

Line 962: FND_MESSAGE.SET_TOKEN('ITEM', nvl(OE_Id_To_Value.Inventory_Item(p_item_id),p_item_id));

958: IF l_debug_level > 0 then
959: OE_DEBUG_PUB.Add('item is config related with decimal qty',2);
960: END IF;
961: FND_MESSAGE.SET_NAME('ONT', 'OE_CONFIG_NO_DECIMALS');
962: FND_MESSAGE.SET_TOKEN('ITEM', nvl(OE_Id_To_Value.Inventory_Item(p_item_id),p_item_id));
963: FND_Message.Set_Token('LINE_NUM', p_line_num);
964: OE_MSG_PUB.Add;
965: x_return_status := FND_API.G_RET_STS_ERROR;
966: END IF;

Line 2584: FND_MESSAGE.SET_TOKEN('AGREEMENT',OE_Id_To_Value.Agreement(p_line_rec.agreement_id));

2580: IF NOT OE_GLOBALS.EQUAL(nvl(l_agreement_id, p_line_rec.agreement_id), p_line_rec.agreement_id)
2581: AND p_line_rec.agreement_id IS NOT NULL THEN
2582: x_return_status := FND_API.G_RET_STS_ERROR;
2583: fnd_message.set_name('ONT','ONT_COM_AGREEMENT_MISMATCH');
2584: FND_MESSAGE.SET_TOKEN('AGREEMENT',OE_Id_To_Value.Agreement(p_line_rec.agreement_id));
2585: OE_MSG_PUB.Add;
2586: END IF;
2587:
2588: IF NOT OE_GLOBALS.EQUAL(nvl(l_inventory_item_id, p_line_rec.inventory_item_id), p_line_rec.inventory_item_id) THEN

Line 2591: FND_MESSAGE.SET_TOKEN('ITEM', OE_Id_To_Value.Inventory_Item(p_line_rec.inventory_item_id));

2587:
2588: IF NOT OE_GLOBALS.EQUAL(nvl(l_inventory_item_id, p_line_rec.inventory_item_id), p_line_rec.inventory_item_id) THEN
2589: x_return_status := FND_API.G_RET_STS_ERROR;
2590: fnd_message.set_name('ONT','ONT_COM_ITEM_MISMATCH');
2591: FND_MESSAGE.SET_TOKEN('ITEM', OE_Id_To_Value.Inventory_Item(p_line_rec.inventory_item_id));
2592: OE_MSG_PUB.Add;
2593: END IF;
2594: IF l_debug_level > 0 then
2595: oe_debug_pub.add('OEXLLINB: commitment end date is: '||l_comm_end_date, 3);

Line 3173: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE', OE_Id_To_Value.Inventory_Item(l_item_id));

3169: end if;
3170: FND_MESSAGE.SET_NAME('ONT', 'OE_BLKT_INVALID_ATTRIBUTE');
3171: fnd_message.set_token('ATTRIBUTE', OE_Order_Util.Get_Attribute_Name('INVENTORY_ITEM_ID'));
3172: --for bug 3257240
3173: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE', OE_Id_To_Value.Inventory_Item(l_item_id));
3174: OE_MSG_PUB.Add;
3175: x_return_status := FND_API.G_RET_STS_ERROR;
3176: END IF;
3177: ELSIF l_item_context = 'CUST' THEN

Line 3187: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE', OE_Id_To_Value.Inventory_Item(l_item_id));

3183: end if;
3184: FND_MESSAGE.SET_NAME('ONT', 'OE_BLKT_INVALID_ATTRIBUTE');
3185: fnd_message.set_token('ATTRIBUTE', OE_Order_Util.Get_Attribute_Name('CUSTOMER_ITEM_ID'));
3186: --for bug 3257240
3187: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE', OE_Id_To_Value.Inventory_Item(l_item_id));
3188: OE_MSG_PUB.Add;
3189: x_return_status := FND_API.G_RET_STS_ERROR;
3190: END IF;
3191:

Line 3223: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE', OE_Id_To_Value.Inventory_Item(l_item_id));

3219: end if;
3220: FND_MESSAGE.SET_NAME('ONT', 'OE_BLKT_INVALID_ATTRIBUTE');
3221: fnd_message.set_token('ATTRIBUTE', OE_Order_Util.Get_Attribute_Name('INVENTORY_ITEM_ID'));
3222: --for bug 3257240
3223: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE', OE_Id_To_Value.Inventory_Item(l_item_id));
3224: OE_MSG_PUB.Add;
3225: x_return_status := FND_API.G_RET_STS_ERROR;
3226: END;
3227:

Line 3238: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE', OE_Id_To_Value.Inventory_Item(l_item_id));

3234: end if;
3235: FND_MESSAGE.SET_NAME('ONT', 'OE_BLKT_INVALID_ATTRIBUTE');
3236: fnd_message.set_token('ATTRIBUTE', OE_Order_Util.Get_Attribute_Name('ORDERED_ITEM'));
3237: --for bug 3257240
3238: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE', OE_Id_To_Value.Inventory_Item(l_item_id));
3239: OE_MSG_PUB.Add;
3240: x_return_status := FND_API.G_RET_STS_ERROR;
3241: END IF;
3242: END IF;

Line 3277: OE_Id_To_Value.Sold_To_Org

3273: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_ATTRIBUTE');
3274: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name
3275: ('SOLD_TO_ORG_ID'));
3276: --for bug 3257240
3277: OE_Id_To_Value.Sold_To_Org
3278: ( p_sold_to_org_id => l_sold_to_org_id
3279: , x_org => l_customer_name
3280: , x_customer_number => l_customer_number
3281: );

Line 3291: OE_Id_To_Value.Sold_To_Org

3287: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_ATTRIBUTE');
3288: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name
3289: ('SOLD_TO_ORG_ID'));
3290: --for bug 3257240
3291: OE_Id_To_Value.Sold_To_Org
3292: ( p_sold_to_org_id => l_sold_to_org_id
3293: , x_org => l_customer_name
3294: , x_customer_number => l_customer_number
3295: );

Line 3384: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE',OE_Id_To_Value.Price_List(l_price_list_id));

3380: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_ATTRIBUTE');
3381: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name
3382: ('PRICE_LIST_ID'));
3383: --for bug 3257240
3384: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE',OE_Id_To_Value.Price_List(l_price_list_id));
3385: OE_MSG_PUB.ADD;
3386: x_return_status := FND_API.G_RET_STS_ERROR;
3387: END IF;
3388: END IF;

Line 3403: OE_ID_TO_VALUE.ship_to_Org

3399: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_ATTRIBUTE');
3400: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name
3401: ('SHIP_TO_ORG_ID'));
3402: --for bug 3257240
3403: OE_ID_TO_VALUE.ship_to_Org
3404: ( p_ship_to_org_id => p_line_rec.ship_to_org_id
3405: , x_ship_to_address1 => l_address1
3406: , x_ship_to_address2 => l_address2
3407: , x_ship_to_address3 => l_address3

Line 3435: OE_ID_TO_VALUE.Invoice_To_Org

3431: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_ATTRIBUTE');
3432: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name
3433: ('INVOICE_TO_ORG_ID'));
3434: --for bug 3257240
3435: OE_ID_TO_VALUE.Invoice_To_Org
3436: ( p_invoice_to_org_id => p_line_rec.invoice_to_org_id
3437: , x_invoice_to_address1 => l_address1
3438: , x_invoice_to_address2 => l_address2
3439: , x_invoice_to_address3 => l_address3

Line 3467: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE',OE_Id_To_Value.Freight_Terms(l_freight_terms_code));

3463: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_ATTRIBUTE');
3464: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name
3465: ('FREIGHT_TERMS_CODE'));
3466: --for bug 3257240
3467: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE',OE_Id_To_Value.Freight_Terms(l_freight_terms_code));
3468: OE_MSG_PUB.ADD;
3469: x_return_status := FND_API.G_RET_STS_ERROR;
3470: END IF;
3471: END IF;

Line 3486: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE',OE_Id_To_Value.Ship_Method(l_shipping_method_code));

3482: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_ATTRIBUTE');
3483: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name
3484: ('SHIPPING_METHOD_CODE'));
3485: --for bug 3257240
3486: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE',OE_Id_To_Value.Ship_Method(l_shipping_method_code));
3487: OE_MSG_PUB.ADD;
3488: x_return_status := FND_API.G_RET_STS_ERROR;
3489: END IF;
3490: END IF;

Line 3505: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE',OE_Id_To_Value.Payment_Term(l_payment_term_id));

3501: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_ATTRIBUTE');
3502: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name
3503: ('PAYMENT_TERM_ID'));
3504: --for bug 3257240
3505: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE',OE_Id_To_Value.Payment_Term(l_payment_term_id));
3506: OE_MSG_PUB.ADD;
3507: x_return_status := FND_API.G_RET_STS_ERROR;
3508: END IF;
3509: END IF;

Line 3524: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE',OE_Id_To_Value.Accounting_Rule(l_accounting_rule_id));

3520: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_ATTRIBUTE');
3521: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name
3522: ('ACCOUNTING_RULE_ID'));
3523: --for bug 3257240
3524: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE',OE_Id_To_Value.Accounting_Rule(l_accounting_rule_id));
3525: OE_MSG_PUB.ADD;
3526: x_return_status := FND_API.G_RET_STS_ERROR;
3527: END IF;
3528: END IF;

Line 3543: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE',OE_Id_To_Value.Invoicing_Rule(l_invoicing_rule_id));

3539: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_ATTRIBUTE');
3540: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name
3541: ('INVOICING_RULE_ID'));
3542: --for bug 3257240
3543: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE',OE_Id_To_Value.Invoicing_Rule(l_invoicing_rule_id));
3544: OE_MSG_PUB.ADD;
3545: x_return_status := FND_API.G_RET_STS_ERROR;
3546: END IF;
3547: END IF;