DBA Data[Home] [Help]

APPS.OE_VALIDATE_LINE dependencies on OE_ID_TO_VALUE

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

969: IF l_debug_level > 0 then
970: OE_DEBUG_PUB.Add('item is config related with decimal qty',2);
971: END IF;
972: FND_MESSAGE.SET_NAME('ONT', 'OE_CONFIG_NO_DECIMALS');
973: FND_MESSAGE.SET_TOKEN('ITEM', nvl(OE_Id_To_Value.Inventory_Item(p_item_id),p_item_id));
974: FND_Message.Set_Token('LINE_NUM', p_line_num);
975: OE_MSG_PUB.Add;
976: x_return_status := FND_API.G_RET_STS_ERROR;
977: END IF;

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

982: IF l_debug_level > 0 then
983: OE_DEBUG_PUB.Add('item is config related with decimal qty',2);
984: END IF;
985: FND_MESSAGE.SET_NAME('ONT', 'OE_CONFIG_NO_DECIMALS');
986: FND_MESSAGE.SET_TOKEN('ITEM', nvl(OE_Id_To_Value.Inventory_Item(p_item_id),p_item_id));
987: FND_Message.Set_Token('LINE_NUM', p_line_num);
988: OE_MSG_PUB.Add;
989: x_return_status := FND_API.G_RET_STS_ERROR;
990: END IF;

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

2705: IF NOT OE_GLOBALS.EQUAL(nvl(l_agreement_id, p_line_rec.agreement_id), p_line_rec.agreement_id)
2706: AND p_line_rec.agreement_id IS NOT NULL THEN
2707: x_return_status := FND_API.G_RET_STS_ERROR;
2708: fnd_message.set_name('ONT','ONT_COM_AGREEMENT_MISMATCH');
2709: FND_MESSAGE.SET_TOKEN('AGREEMENT',OE_Id_To_Value.Agreement(p_line_rec.agreement_id));
2710: OE_MSG_PUB.Add;
2711: END IF;
2712:
2713: IF NOT OE_GLOBALS.EQUAL(nvl(l_inventory_item_id, p_line_rec.inventory_item_id), p_line_rec.inventory_item_id) THEN

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

2712:
2713: IF NOT OE_GLOBALS.EQUAL(nvl(l_inventory_item_id, p_line_rec.inventory_item_id), p_line_rec.inventory_item_id) THEN
2714: x_return_status := FND_API.G_RET_STS_ERROR;
2715: fnd_message.set_name('ONT','ONT_COM_ITEM_MISMATCH');
2716: FND_MESSAGE.SET_TOKEN('ITEM', OE_Id_To_Value.Inventory_Item(p_line_rec.inventory_item_id));
2717: OE_MSG_PUB.Add;
2718: END IF;
2719: IF l_debug_level > 0 then
2720: oe_debug_pub.add('OEXLLINB: commitment end date is: '||l_comm_end_date, 3);

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

3294: end if;
3295: FND_MESSAGE.SET_NAME('ONT', 'OE_BLKT_INVALID_ATTRIBUTE');
3296: fnd_message.set_token('ATTRIBUTE', OE_Order_Util.Get_Attribute_Name('INVENTORY_ITEM_ID'));
3297: --for bug 3257240
3298: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE', OE_Id_To_Value.Inventory_Item(l_item_id));
3299: OE_MSG_PUB.Add;
3300: x_return_status := FND_API.G_RET_STS_ERROR;
3301: END IF;
3302: ELSIF l_item_context = 'CUST' THEN

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

3308: end if;
3309: FND_MESSAGE.SET_NAME('ONT', 'OE_BLKT_INVALID_ATTRIBUTE');
3310: fnd_message.set_token('ATTRIBUTE', OE_Order_Util.Get_Attribute_Name('CUSTOMER_ITEM_ID'));
3311: --for bug 3257240
3312: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE', OE_Id_To_Value.Inventory_Item(l_item_id));
3313: OE_MSG_PUB.Add;
3314: x_return_status := FND_API.G_RET_STS_ERROR;
3315: END IF;
3316:

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

3344: end if;
3345: FND_MESSAGE.SET_NAME('ONT', 'OE_BLKT_INVALID_ATTRIBUTE');
3346: fnd_message.set_token('ATTRIBUTE', OE_Order_Util.Get_Attribute_Name('INVENTORY_ITEM_ID'));
3347: --for bug 3257240
3348: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE', OE_Id_To_Value.Inventory_Item(l_item_id));
3349: OE_MSG_PUB.Add;
3350: x_return_status := FND_API.G_RET_STS_ERROR;
3351: END;
3352:

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

3359: end if;
3360: FND_MESSAGE.SET_NAME('ONT', 'OE_BLKT_INVALID_ATTRIBUTE');
3361: fnd_message.set_token('ATTRIBUTE', OE_Order_Util.Get_Attribute_Name('ORDERED_ITEM'));
3362: --for bug 3257240
3363: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE', OE_Id_To_Value.Inventory_Item(l_item_id));
3364: OE_MSG_PUB.Add;
3365: x_return_status := FND_API.G_RET_STS_ERROR;
3366: END IF;
3367: END IF;

Line 3402: OE_Id_To_Value.Sold_To_Org

3398: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_ATTRIBUTE');
3399: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name
3400: ('SOLD_TO_ORG_ID'));
3401: --for bug 3257240
3402: OE_Id_To_Value.Sold_To_Org
3403: ( p_sold_to_org_id => l_sold_to_org_id
3404: , x_org => l_customer_name
3405: , x_customer_number => l_customer_number
3406: );

Line 3416: OE_Id_To_Value.Sold_To_Org

3412: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_ATTRIBUTE');
3413: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name
3414: ('SOLD_TO_ORG_ID'));
3415: --for bug 3257240
3416: OE_Id_To_Value.Sold_To_Org
3417: ( p_sold_to_org_id => l_sold_to_org_id
3418: , x_org => l_customer_name
3419: , x_customer_number => l_customer_number
3420: );

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

3505: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_ATTRIBUTE');
3506: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name
3507: ('PRICE_LIST_ID'));
3508: --for bug 3257240
3509: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE',OE_Id_To_Value.Price_List(l_price_list_id));
3510: OE_MSG_PUB.ADD;
3511: x_return_status := FND_API.G_RET_STS_ERROR;
3512: END IF;
3513: END IF;

Line 3528: OE_ID_TO_VALUE.ship_to_Org

3524: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_ATTRIBUTE');
3525: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name
3526: ('SHIP_TO_ORG_ID'));
3527: --for bug 3257240
3528: OE_ID_TO_VALUE.ship_to_Org
3529: ( p_ship_to_org_id => p_line_rec.ship_to_org_id
3530: , x_ship_to_address1 => l_address1
3531: , x_ship_to_address2 => l_address2
3532: , x_ship_to_address3 => l_address3

Line 3560: OE_ID_TO_VALUE.Invoice_To_Org

3556: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_ATTRIBUTE');
3557: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name
3558: ('INVOICE_TO_ORG_ID'));
3559: --for bug 3257240
3560: OE_ID_TO_VALUE.Invoice_To_Org
3561: ( p_invoice_to_org_id => p_line_rec.invoice_to_org_id
3562: , x_invoice_to_address1 => l_address1
3563: , x_invoice_to_address2 => l_address2
3564: , x_invoice_to_address3 => l_address3

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

3588: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_ATTRIBUTE');
3589: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name
3590: ('FREIGHT_TERMS_CODE'));
3591: --for bug 3257240
3592: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE',OE_Id_To_Value.Freight_Terms(l_freight_terms_code));
3593: OE_MSG_PUB.ADD;
3594: x_return_status := FND_API.G_RET_STS_ERROR;
3595: END IF;
3596: END IF;

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

3607: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_ATTRIBUTE');
3608: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name
3609: ('SHIPPING_METHOD_CODE'));
3610: --for bug 3257240
3611: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE',OE_Id_To_Value.Ship_Method(l_shipping_method_code));
3612: OE_MSG_PUB.ADD;
3613: x_return_status := FND_API.G_RET_STS_ERROR;
3614: END IF;
3615: END IF;

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

3626: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_ATTRIBUTE');
3627: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name
3628: ('PAYMENT_TERM_ID'));
3629: --for bug 3257240
3630: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE',OE_Id_To_Value.Payment_Term(l_payment_term_id));
3631: OE_MSG_PUB.ADD;
3632: x_return_status := FND_API.G_RET_STS_ERROR;
3633: END IF;
3634: END IF;

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

3645: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_ATTRIBUTE');
3646: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name
3647: ('ACCOUNTING_RULE_ID'));
3648: --for bug 3257240
3649: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE',OE_Id_To_Value.Accounting_Rule(l_accounting_rule_id));
3650: OE_MSG_PUB.ADD;
3651: x_return_status := FND_API.G_RET_STS_ERROR;
3652: END IF;
3653: END IF;

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

3664: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_ATTRIBUTE');
3665: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name
3666: ('INVOICING_RULE_ID'));
3667: --for bug 3257240
3668: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE',OE_Id_To_Value.Invoicing_Rule(l_invoicing_rule_id));
3669: OE_MSG_PUB.ADD;
3670: x_return_status := FND_API.G_RET_STS_ERROR;
3671: END IF;
3672: END IF;