DBA Data[Home] [Help]

APPS.OE_LINE_UTIL dependencies on OE_ID_TO_VALUE

Line 14227: l_line_val_rec.calculate_price_descr := OE_Id_To_Value.Calculate_price_Flag ( p_calculate_price_flag => p_line_rec.calculate_price_flag

14223: p_line_rec.calculate_price_flag <> FND_API.G_MISS_CHAR) AND
14224: NOT OE_GLOBALS.Equal(p_line_rec.calculate_price_flag,
14225: p_old_line_rec.calculate_price_flag)
14226: THEN
14227: l_line_val_rec.calculate_price_descr := OE_Id_To_Value.Calculate_price_Flag ( p_calculate_price_flag => p_line_rec.calculate_price_flag
14228: );
14229:
14230: if l_debug_level > 0 then
14231: oe_debug_pub.add('Geresh ' || l_line_val_rec.calculate_price_descr );

Line 14241: l_line_val_rec.accounting_rule := OE_Id_To_Value.Accounting_Rule

14237: p_line_rec.accounting_rule_id <> FND_API.G_MISS_NUM) AND
14238: NOT OE_GLOBALS.Equal(p_line_rec.accounting_rule_id,
14239: p_old_line_rec.accounting_rule_id)
14240: THEN
14241: l_line_val_rec.accounting_rule := OE_Id_To_Value.Accounting_Rule
14242: ( p_accounting_rule_id => p_line_rec.accounting_rule_id
14243: );
14244: END IF;
14245:

Line 14251: l_line_val_rec.agreement := OE_Id_To_Value.Agreement

14247: p_line_rec.agreement_id <> FND_API.G_MISS_NUM) AND
14248: NOT OE_GLOBALS.Equal(p_line_rec.agreement_id,
14249: p_old_line_rec.agreement_id)
14250: THEN
14251: l_line_val_rec.agreement := OE_Id_To_Value.Agreement
14252: ( p_agreement_id => p_line_rec.agreement_id
14253: );
14254: END IF;
14255:

Line 14261: l_line_val_rec.deliver_to_contact := OE_Id_To_Value.Deliver_To_Contact

14257: p_line_rec.deliver_to_contact_id <> FND_API.G_MISS_NUM) AND
14258: NOT OE_GLOBALS.Equal(p_line_rec.deliver_to_contact_id,
14259: p_old_line_rec.deliver_to_contact_id)
14260: THEN
14261: l_line_val_rec.deliver_to_contact := OE_Id_To_Value.Deliver_To_Contact
14262: ( p_deliver_to_contact_id => p_line_rec.deliver_to_contact_id
14263: );
14264: END IF;
14265:

Line 14296: l_line_val_rec.demand_bucket_type := OE_Id_To_Value.Demand_Bucket_Type

14292: p_line_rec.demand_bucket_type_code <> FND_API.G_MISS_CHAR) AND
14293: NOT OE_GLOBALS.Equal(p_line_rec.demand_bucket_type_code,
14294: p_old_line_rec.demand_bucket_type_code)
14295: THEN
14296: l_line_val_rec.demand_bucket_type := OE_Id_To_Value.Demand_Bucket_Type
14297: ( p_demand_bucket_type_code => p_line_rec.demand_bucket_type_code
14298: );
14299: END IF;
14300:

Line 14306: l_line_val_rec.fob_point := OE_Id_To_Value.Fob_Point

14302: p_line_rec.fob_point_code <> FND_API.G_MISS_CHAR) AND
14303: NOT OE_GLOBALS.Equal(p_line_rec.fob_point_code,
14304: p_old_line_rec.fob_point_code)
14305: THEN
14306: l_line_val_rec.fob_point := OE_Id_To_Value.Fob_Point
14307: ( p_fob_point_code => p_line_rec.fob_point_code
14308: );
14309: END IF;
14310:

Line 14316: l_line_val_rec.freight_terms := OE_Id_To_Value.Freight_Terms

14312: p_line_rec.freight_terms_code <> FND_API.G_MISS_CHAR) AND
14313: NOT OE_GLOBALS.Equal(p_line_rec.freight_terms_code,
14314: p_old_line_rec.freight_terms_code)
14315: THEN
14316: l_line_val_rec.freight_terms := OE_Id_To_Value.Freight_Terms
14317: ( p_freight_terms_code => p_line_rec.freight_terms_code
14318: );
14319: END IF;
14320:

Line 14326: l_line_val_rec.freight_carrier := OE_Id_To_Value.Freight_Carrier

14322: p_line_rec.freight_carrier_code <> FND_API.G_MISS_CHAR) AND
14323: NOT OE_GLOBALS.Equal(p_line_rec.freight_carrier_code,
14324: p_old_line_rec.freight_carrier_code)
14325: THEN
14326: l_line_val_rec.freight_carrier := OE_Id_To_Value.Freight_Carrier
14327: ( p_freight_carrier_code => p_line_rec.freight_carrier_code
14328: , p_ship_from_org_id => p_line_rec.ship_from_org_id
14329: );
14330: END IF;

Line 14336: l_line_val_rec.shipping_method := OE_Id_To_Value.ship_method

14332: p_line_rec.shipping_method_code <> FND_API.G_MISS_CHAR) AND
14333: NOT OE_GLOBALS.Equal(p_line_rec.shipping_method_code,
14334: p_old_line_rec.shipping_method_code)
14335: THEN
14336: l_line_val_rec.shipping_method := OE_Id_To_Value.ship_method
14337: ( p_ship_method_code => p_line_rec.shipping_method_code
14338: );
14339: END IF;
14340:

Line 14346: l_line_val_rec.intermed_ship_to_contact := OE_Id_To_Value.Intermed_Ship_To_Contact

14342: p_line_rec.intermed_ship_to_contact_id <> FND_API.G_MISS_NUM) AND
14343: NOT OE_GLOBALS.Equal(p_line_rec.intermed_ship_to_contact_id,
14344: p_old_line_rec.intermed_ship_to_contact_id)
14345: THEN
14346: l_line_val_rec.intermed_ship_to_contact := OE_Id_To_Value.Intermed_Ship_To_Contact
14347: ( p_intermed_ship_to_contact_id => p_line_rec.intermed_ship_to_contact_id
14348: );
14349: END IF;
14350:

Line 14357: OE_Id_To_Value.Intermed_Ship_To_Org

14353: p_line_rec.intermed_ship_to_org_id <> FND_API.G_MISS_NUM) AND
14354: NOT OE_GLOBALS.Equal(p_line_rec.intermed_ship_to_org_id,
14355: p_old_line_rec.intermed_ship_to_org_id)
14356: THEN
14357: OE_Id_To_Value.Intermed_Ship_To_Org
14358: ( p_intermed_ship_to_org_id => p_line_rec.intermed_ship_to_org_id
14359: , x_intermed_ship_to_address1 => l_line_val_rec.intermed_ship_to_address1
14360: , x_intermed_ship_to_address2 => l_line_val_rec.intermed_ship_to_address2
14361: , x_intermed_ship_to_address3 => l_line_val_rec.intermed_ship_to_address3

Line 14378: l_line_val_rec.inventory_item := OE_Id_To_Value.Inventory_Item

14374: p_line_rec.inventory_item_id <> FND_API.G_MISS_NUM) AND
14375: NOT OE_GLOBALS.Equal(p_line_rec.inventory_item_id,
14376: p_old_line_rec.inventory_item_id)
14377: THEN
14378: l_line_val_rec.inventory_item := OE_Id_To_Value.Inventory_Item
14379: ( p_inventory_item_id => p_line_rec.inventory_item_id
14380: );
14381: END IF;
14382:

Line 14388: l_line_val_rec.invoice_to_contact := OE_Id_To_Value.Invoice_To_Contact

14384: p_line_rec.invoice_to_contact_id <> FND_API.G_MISS_NUM) AND
14385: NOT OE_GLOBALS.Equal(p_line_rec.invoice_to_contact_id,
14386: p_old_line_rec.invoice_to_contact_id)
14387: THEN
14388: l_line_val_rec.invoice_to_contact := OE_Id_To_Value.Invoice_To_Contact
14389: ( p_invoice_to_contact_id => p_line_rec.invoice_to_contact_id
14390: );
14391: END IF;
14392:

Line 14424: l_line_val_rec.invoicing_rule := OE_Id_To_Value.Invoicing_Rule

14420: p_line_rec.invoicing_rule_id <> FND_API.G_MISS_NUM) AND
14421: NOT OE_GLOBALS.Equal(p_line_rec.invoicing_rule_id,
14422: p_old_line_rec.invoicing_rule_id)
14423: THEN
14424: l_line_val_rec.invoicing_rule := OE_Id_To_Value.Invoicing_Rule
14425: ( p_invoicing_rule_id => p_line_rec.invoicing_rule_id
14426: );
14427: END IF;
14428:

Line 14434: l_line_val_rec.item_type := OE_Id_To_Value.Item_Type

14430: p_line_rec.item_type_code <> FND_API.G_MISS_CHAR) AND
14431: NOT OE_GLOBALS.Equal(p_line_rec.item_type_code,
14432: p_old_line_rec.item_type_code)
14433: THEN
14434: l_line_val_rec.item_type := OE_Id_To_Value.Item_Type
14435: ( p_item_type_code => p_line_rec.item_type_code
14436: );
14437: END IF;
14438:

Line 14444: l_line_val_rec.line_type := OE_Id_To_Value.Line_Type

14440: p_line_rec.line_type_id <> FND_API.G_MISS_NUM) AND
14441: NOT OE_GLOBALS.Equal(p_line_rec.line_type_id,
14442: p_old_line_rec.line_type_id)
14443: THEN
14444: l_line_val_rec.line_type := OE_Id_To_Value.Line_Type
14445: ( p_line_type_id => p_line_rec.line_type_id
14446: );
14447: END IF;
14448:

Line 14454: l_line_val_rec.over_ship_reason := OE_Id_To_Value.over_ship_reason

14450: p_line_rec.over_ship_reason_code <> FND_API.G_MISS_CHAR) AND
14451: NOT OE_GLOBALS.Equal(p_line_rec.over_ship_reason_code,
14452: p_old_line_rec.over_ship_reason_code)
14453: THEN
14454: l_line_val_rec.over_ship_reason := OE_Id_To_Value.over_ship_reason
14455: ( p_over_ship_reason_code => p_line_rec.over_ship_reason_code
14456: );
14457: END IF;
14458:

Line 14464: l_line_val_rec.payment_term := OE_Id_To_Value.Payment_Term

14460: p_line_rec.payment_term_id <> FND_API.G_MISS_NUM) AND
14461: NOT OE_GLOBALS.Equal(p_line_rec.payment_term_id,
14462: p_old_line_rec.payment_term_id)
14463: THEN
14464: l_line_val_rec.payment_term := OE_Id_To_Value.Payment_Term
14465: ( p_payment_term_id => p_line_rec.payment_term_id
14466: );
14467: END IF;
14468:

Line 14474: l_line_val_rec.price_list := OE_Id_To_Value.Price_List

14470: p_line_rec.price_list_id <> FND_API.G_MISS_NUM) AND
14471: NOT OE_GLOBALS.Equal(p_line_rec.price_list_id,
14472: p_old_line_rec.price_list_id)
14473: THEN
14474: l_line_val_rec.price_list := OE_Id_To_Value.Price_List
14475: ( p_price_list_id => p_line_rec.price_list_id
14476: );
14477: END IF;
14478:

Line 14484: l_line_val_rec.project := OE_Id_To_Value.Project

14480: p_line_rec.project_id <> FND_API.G_MISS_NUM) AND
14481: NOT OE_GLOBALS.Equal(p_line_rec.project_id,
14482: p_old_line_rec.project_id)
14483: THEN
14484: l_line_val_rec.project := OE_Id_To_Value.Project
14485: ( p_project_id => p_line_rec.project_id
14486: );
14487: END IF;
14488:

Line 14496: l_line_val_rec.source_type := OE_Id_To_Value.source_type

14492: NOT OE_GLOBALS.Equal(p_line_rec.source_type_code,
14493: p_old_line_rec.source_type_code)
14494: THEN
14495:
14496: l_line_val_rec.source_type := OE_Id_To_Value.source_type
14497: ( p_source_type_code => p_line_rec.source_type_code
14498: );
14499: END IF;
14500:

Line 14508: l_line_val_rec.return_reason := OE_Id_To_Value.return_reason

14504: NOT OE_GLOBALS.Equal(p_line_rec.return_reason_code,
14505: p_old_line_rec.return_reason_code)
14506: THEN
14507:
14508: l_line_val_rec.return_reason := OE_Id_To_Value.return_reason
14509: ( p_return_reason_code => p_line_rec.return_reason_code
14510: );
14511: END IF;
14512:

Line 14518: OE_Id_To_Value.reference_line

14514: p_line_rec.reference_line_id <> FND_API.G_MISS_NUM) AND
14515: NOT OE_GLOBALS.Equal(p_line_rec.reference_line_id,
14516: p_old_line_rec.reference_line_id)
14517: THEN
14518: OE_Id_To_Value.reference_line
14519: ( p_reference_line_id => p_line_rec.reference_line_id
14520: , x_ref_order_number => l_line_val_rec.ref_order_number
14521: , x_ref_line_number => l_line_val_rec.ref_line_number
14522: , x_ref_shipment_number => l_line_val_rec.ref_shipment_number

Line 14534: OE_Id_To_Value.Reference_Cust_Trx_Line

14530: p_line_rec.reference_customer_trx_line_id <> FND_API.G_MISS_NUM) AND
14531: NOT OE_GLOBALS.Equal(p_line_rec.reference_customer_trx_line_id,
14532: p_old_line_rec.reference_customer_trx_line_id)
14533: THEN
14534: OE_Id_To_Value.Reference_Cust_Trx_Line
14535: ( p_reference_cust_trx_line_id => p_line_rec.reference_customer_trx_line_id
14536: , x_ref_invoice_number => l_line_val_rec.ref_invoice_number
14537: , x_ref_invoice_line_number => l_line_val_rec.ref_invoice_line_number
14538: );

Line 14547: := OE_Id_To_Value.credit_invoice_line

14543: NOT OE_GLOBALS.Equal(p_line_rec.credit_invoice_line_id,
14544: p_old_line_rec.credit_invoice_line_id)
14545: THEN
14546: l_line_val_rec.credit_invoice_number
14547: := OE_Id_To_Value.credit_invoice_line
14548: ( p_credit_invoice_line_id => p_line_rec.credit_invoice_line_id
14549: );
14550: END IF;
14551:

Line 14557: l_line_val_rec.rla_schedule_type := OE_Id_To_Value.Rla_Schedule_Type

14553: p_line_rec.rla_schedule_type_code <> FND_API.G_MISS_CHAR) AND
14554: NOT OE_GLOBALS.Equal(p_line_rec.rla_schedule_type_code,
14555: p_old_line_rec.rla_schedule_type_code)
14556: THEN
14557: l_line_val_rec.rla_schedule_type := OE_Id_To_Value.Rla_Schedule_Type
14558: ( p_rla_schedule_type_code => p_line_rec.rla_schedule_type_code
14559: );
14560: END IF;
14561:

Line 14567: l_line_val_rec.salesrep := OE_Id_To_Value.salesrep

14563: p_line_rec.salesrep_id <> FND_API.G_MISS_NUM) AND
14564: NOT OE_GLOBALS.Equal(p_line_rec.salesrep_id,
14565: p_old_line_rec.salesrep_id)
14566: THEN
14567: l_line_val_rec.salesrep := OE_Id_To_Value.salesrep
14568: ( p_salesrep_id => p_line_rec.salesrep_id
14569: );
14570: END IF;
14571:

Line 14577: l_line_val_rec.commitment := OE_Id_To_Value.Commitment

14573: p_line_rec.commitment_id <> FND_API.G_MISS_NUM) AND
14574: NOT OE_GLOBALS.Equal(p_line_rec.commitment_id,
14575: p_old_line_rec.commitment_id)
14576: THEN
14577: l_line_val_rec.commitment := OE_Id_To_Value.Commitment
14578: ( p_commitment_id => p_line_rec.commitment_id
14579: );
14580: END IF;
14581:

Line 14588: l_line_val_rec.shipment_priority := OE_Id_To_Value.Shipment_Priority

14584: p_line_rec.shipment_priority_code <> FND_API.G_MISS_CHAR) AND
14585: NOT OE_GLOBALS.Equal(p_line_rec.shipment_priority_code,
14586: p_old_line_rec.shipment_priority_code)
14587: THEN
14588: l_line_val_rec.shipment_priority := OE_Id_To_Value.Shipment_Priority
14589: ( p_shipment_priority_code => p_line_rec.shipment_priority_code
14590: );
14591: END IF;
14592:

Line 14598: l_line_val_rec.demand_class := OE_Id_To_Value.Demand_Class

14594: p_line_rec.demand_class_code <> FND_API.G_MISS_CHAR) AND
14595: NOT OE_GLOBALS.Equal(p_line_rec.demand_class_code,
14596: p_old_line_rec.demand_class_code)
14597: THEN
14598: l_line_val_rec.demand_class := OE_Id_To_Value.Demand_Class
14599: ( p_demand_class_code => p_line_rec.demand_class_code
14600: );
14601: END IF;
14602:

Line 14608: OE_Id_To_Value.Ship_From_Org

14604: p_line_rec.ship_from_org_id <> FND_API.G_MISS_NUM) AND
14605: NOT OE_GLOBALS.Equal(p_line_rec.ship_from_org_id,
14606: p_old_line_rec.ship_from_org_id)
14607: THEN
14608: OE_Id_To_Value.Ship_From_Org
14609: ( p_ship_from_org_id => p_line_rec.ship_from_org_id
14610: , x_ship_from_address1 => l_line_val_rec.ship_from_address1
14611: , x_ship_from_address2 => l_line_val_rec.ship_from_address2
14612: , x_ship_from_address3 => l_line_val_rec.ship_from_address3

Line 14624: l_line_val_rec.ship_to_contact := OE_Id_To_Value.Ship_To_Contact

14620: p_line_rec.ship_to_contact_id <> FND_API.G_MISS_NUM) AND
14621: NOT OE_GLOBALS.Equal(p_line_rec.ship_to_contact_id,
14622: p_old_line_rec.ship_to_contact_id)
14623: THEN
14624: l_line_val_rec.ship_to_contact := OE_Id_To_Value.Ship_To_Contact
14625: ( p_ship_to_contact_id => p_line_rec.ship_to_contact_id
14626: );
14627: END IF;
14628:

Line 14660: OE_Id_To_Value.Sold_To_Org

14656: p_line_rec.sold_to_org_id <> FND_API.G_MISS_NUM) AND
14657: NOT OE_GLOBALS.Equal(p_line_rec.sold_to_org_id,
14658: p_old_line_rec.sold_to_org_id)
14659: THEN
14660: OE_Id_To_Value.Sold_To_Org
14661: ( p_sold_to_org_id => p_line_rec.sold_to_org_id
14662: , x_org => l_line_val_rec.sold_to_org
14663: , x_customer_number => l_customer_number
14664: );

Line 14672: l_line_val_rec.task := OE_Id_To_Value.Task

14668: p_line_rec.task_id <> FND_API.G_MISS_NUM) AND
14669: NOT OE_GLOBALS.Equal(p_line_rec.task_id,
14670: p_old_line_rec.task_id)
14671: THEN
14672: l_line_val_rec.task := OE_Id_To_Value.Task
14673: ( p_task_id => p_line_rec.task_id
14674: );
14675: END IF;
14676:

Line 14682: l_line_val_rec.tax_exempt := OE_Id_To_Value.Tax_Exempt

14678: p_line_rec.tax_exempt_flag <> FND_API.G_MISS_CHAR) AND
14679: NOT OE_GLOBALS.Equal(p_line_rec.tax_exempt_flag,
14680: p_old_line_rec.tax_exempt_flag)
14681: THEN
14682: l_line_val_rec.tax_exempt := OE_Id_To_Value.Tax_Exempt
14683: ( p_tax_exempt_flag => p_line_rec.tax_exempt_flag
14684: );
14685: END IF;
14686:

Line 14692: l_line_val_rec.tax_exempt_reason := OE_Id_To_Value.Tax_Exempt_Reason

14688: p_line_rec.tax_exempt_reason_code <> FND_API.G_MISS_CHAR) AND
14689: NOT OE_GLOBALS.Equal(p_line_rec.tax_exempt_reason_code,
14690: p_old_line_rec.tax_exempt_reason_code)
14691: THEN
14692: l_line_val_rec.tax_exempt_reason := OE_Id_To_Value.Tax_Exempt_Reason
14693: ( p_tax_exempt_reason_code => p_line_rec.tax_exempt_reason_code
14694: );
14695: END IF;
14696:

Line 14702: l_line_val_rec.tax_point := OE_Id_To_Value.Tax_Point

14698: p_line_rec.tax_point_code <> FND_API.G_MISS_CHAR) AND
14699: NOT OE_GLOBALS.Equal(p_line_rec.tax_point_code,
14700: p_old_line_rec.tax_point_code)
14701: THEN
14702: l_line_val_rec.tax_point := OE_Id_To_Value.Tax_Point
14703: ( p_tax_point_code => p_line_rec.tax_point_code
14704: );
14705: END IF;
14706:

Line 14712: l_line_val_rec.tax_group := OE_Id_To_Value.Tax_Group

14708: p_line_rec.tax_code <> FND_API.G_MISS_CHAR) AND
14709: NOT OE_GLOBALS.Equal(p_line_rec.tax_code,
14710: p_old_line_rec.tax_code)
14711: THEN
14712: l_line_val_rec.tax_group := OE_Id_To_Value.Tax_Group
14713: ( p_tax_code => p_line_rec.tax_code
14714: );
14715: END IF;*/
14716:

Line 14722: l_line_val_rec.veh_cus_item_cum_key := OE_Id_To_Value.veh_cus_item_cum_key

14718: p_line_rec.veh_cus_item_cum_key_id <> FND_API.G_MISS_NUM) AND
14719: NOT OE_GLOBALS.Equal(p_line_rec.veh_cus_item_cum_key_id,
14720: p_old_line_rec.veh_cus_item_cum_key_id)
14721: THEN
14722: l_line_val_rec.veh_cus_item_cum_key := OE_Id_To_Value.veh_cus_item_cum_key
14723: ( p_veh_cus_item_cum_key_id => p_line_rec.veh_cus_item_cum_key_id
14724: );
14725: END IF;
14726:

Line 14731: OE_ID_TO_VALUE.Ordered_Item

14727:
14728: IF (p_line_rec.Original_inventory_item_id IS NOT NULL OR
14729: p_line_rec.original_inventory_item_id <> FND_API.G_MISS_NUM)
14730: THEN
14731: OE_ID_TO_VALUE.Ordered_Item
14732: (p_Item_Identifier_type => p_line_rec.original_item_identifier_Type
14733: ,p_inventory_item_id => p_line_rec.original_Inventory_Item_Id
14734: ,p_organization_id => l_organization_id
14735: ,p_ordered_item_id => p_line_rec.original_ordered_item_id

Line 14745: OE_ID_TO_VALUE.item_identifier

14741:
14742: IF (p_line_rec.original_item_identifier_type IS NOT NULL OR
14743: p_line_rec.original_item_identifier_type <> FND_API.G_MISS_CHAR)
14744: THEN
14745: OE_ID_TO_VALUE.item_identifier
14746: (p_Item_Identifier_type => p_line_rec.Original_item_identifier_Type
14747: ,x_Item_Identifier => l_line_val_rec.Original_item_identifier_type);
14748: END IF;
14749:

Line 14753: OE_ID_TO_VALUE.item_relationship_type

14749:
14750: IF (p_line_rec.item_relationship_type IS NOT NULL OR
14751: p_line_rec.item_relationship_type <> FND_API.G_MISS_NUM)
14752: THEN
14753: OE_ID_TO_VALUE.item_relationship_type
14754: (p_Item_relationship_type => p_line_rec.item_relationship_type
14755: ,x_Item_relationship_type_dsp => l_line_val_rec.item_relationship_type_dsp);
14756: END IF;
14757:

Line 14761: OE_ID_TO_VALUE.End_Customer(

14757:
14758: IF (p_line_rec.end_customer_id IS NOT NULL AND
14759: p_line_rec.end_customer_id <> FND_API.G_MISS_NUM)
14760: THEN
14761: OE_ID_TO_VALUE.End_Customer(
14762: p_end_customer_id => p_line_rec.end_customer_id
14763: ,x_end_customer_name => l_line_val_rec.end_customer_name
14764: ,x_end_customer_number => l_line_val_rec.end_customer_number);
14765: END IF;

Line 14771: OE_ID_TO_VALUE.end_customer_Contact(p_end_customer_contact_id => p_line_rec.end_customer_contact_id);

14767: IF (p_line_rec.end_customer_contact_id IS NOT NULL AND
14768: p_line_rec.end_customer_contact_id <> FND_API.G_MISS_NUM)
14769: THEN
14770: l_line_val_rec.end_customer_contact :=
14771: OE_ID_TO_VALUE.end_customer_Contact(p_end_customer_contact_id => p_line_rec.end_customer_contact_id);
14772: END IF;
14773:
14774: IF (p_line_rec.end_customer_site_use_id IS NOT NULL AND
14775: p_line_rec.end_customer_site_use_id <> FND_API.G_MISS_NUM)

Line 14777: OE_ID_TO_VALUE.end_customer_site_use(

14773:
14774: IF (p_line_rec.end_customer_site_use_id IS NOT NULL AND
14775: p_line_rec.end_customer_site_use_id <> FND_API.G_MISS_NUM)
14776: THEN
14777: OE_ID_TO_VALUE.end_customer_site_use(
14778: p_end_customer_site_use_id => p_line_rec.end_customer_site_use_id
14779: ,x_end_customer_address1 => l_line_val_rec.end_customer_site_address1
14780: ,x_end_customer_address2 => l_line_val_rec.end_customer_site_address2
14781: ,x_end_customer_address3 => l_line_val_rec.end_customer_site_address3

Line 14803: OE_ID_TO_VALUE.ib_owner(p_ib_owner => p_line_rec.ib_owner);

14799: IF (p_line_rec.ib_owner IS NOT NULL AND
14800: p_line_rec.ib_owner <> FND_API.G_MISS_CHAR)
14801: THEN
14802: l_line_val_rec.ib_owner_dsp :=
14803: OE_ID_TO_VALUE.ib_owner(p_ib_owner => p_line_rec.ib_owner);
14804: END IF;
14805:
14806: IF (p_line_rec.ib_current_location IS NOT NULL AND
14807: p_line_rec.ib_current_location <> FND_API.G_MISS_CHAR)

Line 14810: OE_ID_TO_VALUE.ib_current_location(p_ib_current_location => p_line_rec.ib_current_location);

14806: IF (p_line_rec.ib_current_location IS NOT NULL AND
14807: p_line_rec.ib_current_location <> FND_API.G_MISS_CHAR)
14808: THEN
14809: l_line_val_rec.ib_current_location_dsp :=
14810: OE_ID_TO_VALUE.ib_current_location(p_ib_current_location => p_line_rec.ib_current_location);
14811: END IF;
14812:
14813: IF (p_line_rec.ib_installed_at_location IS NOT NULL AND
14814: p_line_rec.ib_installed_at_location <> FND_API.G_MISS_CHAR)

Line 14817: OE_ID_TO_VALUE.ib_installed_at_location(p_ib_installed_at_location => p_line_rec.ib_installed_at_location);

14813: IF (p_line_rec.ib_installed_at_location IS NOT NULL AND
14814: p_line_rec.ib_installed_at_location <> FND_API.G_MISS_CHAR)
14815: THEN
14816: l_line_val_rec.ib_installed_at_location_dsp :=
14817: OE_ID_TO_VALUE.ib_installed_at_location(p_ib_installed_at_location => p_line_rec.ib_installed_at_location);
14818: END IF;
14819: --Macd
14820: /*3605052*/
14821: IF (p_line_rec.service_period IS NOT NULL AND

Line 14827: OE_ID_TO_VALUE.subscription_period(p_service_period => p_line_rec.service_period);

14823: THEN
14824: -- sol_ord_er #16014165
14825: If p_line_rec.subscription_enable_flag='Y' then
14826: l_line_val_rec.service_period_dsp :=
14827: OE_ID_TO_VALUE.subscription_period(p_service_period => p_line_rec.service_period);
14828: else
14829: -- sol_ord_er #16014165 end
14830: l_line_val_rec.service_period_dsp :=
14831: OE_ID_TO_VALUE.service_period(p_service_period => p_line_rec.service_period

Line 14831: OE_ID_TO_VALUE.service_period(p_service_period => p_line_rec.service_period

14827: OE_ID_TO_VALUE.subscription_period(p_service_period => p_line_rec.service_period);
14828: else
14829: -- sol_ord_er #16014165 end
14830: l_line_val_rec.service_period_dsp :=
14831: OE_ID_TO_VALUE.service_period(p_service_period => p_line_rec.service_period
14832: ,p_inventory_item_id => p_line_rec.inventory_item_id);
14833: End If;--sol_ord_er #16014165
14834: END IF;
14835: /*3605052*/

Line 14843: OE_ID_TO_VALUE.service_reference_type(p_service_reference_type_code => p_line_rec.service_reference_type_code);

14839: IF (p_line_rec.service_reference_type_code IS NOT NULL AND
14840: p_line_rec.service_reference_type_code <> FND_API.G_MISS_CHAR)
14841: THEN
14842: l_line_val_rec.service_reference_type :=
14843: OE_ID_TO_VALUE.service_reference_type(p_service_reference_type_code => p_line_rec.service_reference_type_code);
14844: END IF;
14845: -- 5701246 end
14846:
14847: --sol_ord_er #16014165 (used in Defaulting)

Line 14852: OE_ID_TO_VALUE.Billing_Profile(p_service_bill_profile_id => p_line_rec.service_bill_profile_id);

14848: IF (p_line_rec.service_bill_profile_id IS NOT NULL AND
14849: p_line_rec.service_bill_profile_id <> FND_API.G_MISS_NUM)
14850: THEN
14851: l_line_val_rec.service_bill_profile :=
14852: OE_ID_TO_VALUE.Billing_Profile(p_service_bill_profile_id => p_line_rec.service_bill_profile_id);
14853: END IF;
14854:
14855: IF (p_line_rec.service_bill_option_code IS NOT NULL AND
14856: p_line_rec.service_bill_option_code <> FND_API.G_MISS_CHAR)

Line 14859: OE_ID_TO_VALUE.Billing_Option(p_service_bill_option_code => p_line_rec.service_bill_option_code);

14855: IF (p_line_rec.service_bill_option_code IS NOT NULL AND
14856: p_line_rec.service_bill_option_code <> FND_API.G_MISS_CHAR)
14857: THEN
14858: l_line_val_rec.service_bill_option :=
14859: OE_ID_TO_VALUE.Billing_Option(p_service_bill_option_code => p_line_rec.service_bill_option_code);
14860: END IF;
14861:
14862: IF (p_line_rec.service_subs_template_id IS NOT NULL AND
14863: p_line_rec.service_subs_template_id <> FND_API.G_MISS_NUM)

Line 14866: OE_ID_TO_VALUE.Subscription_Template(p_service_subs_template_id => p_line_rec.service_subs_template_id);

14862: IF (p_line_rec.service_subs_template_id IS NOT NULL AND
14863: p_line_rec.service_subs_template_id <> FND_API.G_MISS_NUM)
14864: THEN
14865: l_line_val_rec.service_subs_template :=
14866: OE_ID_TO_VALUE.Subscription_Template(p_service_subs_template_id => p_line_rec.service_subs_template_id);
14867: END IF;
14868:
14869: IF (p_line_rec.service_cov_template_id IS NOT NULL AND
14870: p_line_rec.service_cov_template_id <> FND_API.G_MISS_NUM)

Line 14873: OE_ID_TO_VALUE.Coverage_Template(p_service_cov_template_id => p_line_rec.service_cov_template_id);

14869: IF (p_line_rec.service_cov_template_id IS NOT NULL AND
14870: p_line_rec.service_cov_template_id <> FND_API.G_MISS_NUM)
14871: THEN
14872: l_line_val_rec.service_cov_template :=
14873: OE_ID_TO_VALUE.Coverage_Template(p_service_cov_template_id => p_line_rec.service_cov_template_id);
14874: END IF;
14875: --sol_ord_er #16014165
14876: --Customer Acceptance
14877: IF (p_line_rec.contingency_id IS NOT NULL AND

Line 14880: OE_ID_TO_VALUE.Get_Contingency_Attributes(

14876: --Customer Acceptance
14877: IF (p_line_rec.contingency_id IS NOT NULL AND
14878: p_line_rec.contingency_id <> FND_API.G_MISS_NUM)
14879: THEN
14880: OE_ID_TO_VALUE.Get_Contingency_Attributes(
14881: p_contingency_id => p_line_rec.contingency_id
14882: , x_contingency_name => l_line_val_rec.contingency_name
14883: , x_contingency_description => l_line_val_rec.contingency_description
14884: , x_expiration_event_attribute => l_line_val_rec.expiration_event_attribute);

Line 14890: l_line_val_rec.Revrec_Event:= OE_ID_TO_VALUE.Revrec_Event(

14886: END IF;
14887: IF (p_line_rec.revrec_event_code IS NOT NULL AND
14888: p_line_rec.revrec_event_code <> FND_API.G_MISS_CHAR)
14889: THEN
14890: l_line_val_rec.Revrec_Event:= OE_ID_TO_VALUE.Revrec_Event(
14891: p_Revrec_Event_code => p_line_rec.Revrec_Event_code);
14892:
14893: END IF;
14894:

Line 14898: l_line_val_rec.accepted_by_dsp:= OE_ID_TO_VALUE.accepted_by(

14894:
14895: IF (p_line_rec.accepted_by IS NOT NULL AND
14896: p_line_rec.accepted_by <> FND_API.G_MISS_NUM)
14897: THEN
14898: l_line_val_rec.accepted_by_dsp:= OE_ID_TO_VALUE.accepted_by(
14899: p_accepted_by => p_line_rec.accepted_by);
14900:
14901: END IF;
14902: --

Line 23016: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');

23012:
23013: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
23014: THEN
23015:
23016: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
23017: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','get_customer_details');
23018: OE_MSG_PUB.Add;
23019:
23020: END IF;