eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_HEADER_UTIL dependencies on OE_VALUE_TO_ID

Line 6200: p_x_header_rec.accounting_rule_id := OE_Value_To_Id.accounting_rule

6196: END IF;
6197:
6198: ELSE
6199:
6200: p_x_header_rec.accounting_rule_id := OE_Value_To_Id.accounting_rule
6201: ( p_accounting_rule => p_header_val_rec.accounting_rule
6202: );
6203:
6204: IF p_x_header_rec.accounting_rule_id = FND_API.G_MISS_NUM THEN

Line 6230: p_x_header_rec.agreement_id := OE_Value_To_Id.agreement

6226: END IF;
6227:
6228: ELSE
6229:
6230: p_x_header_rec.agreement_id := OE_Value_To_Id.agreement
6231: ( p_agreement => p_header_val_rec.agreement
6232: );
6233:
6234: IF p_x_header_rec.agreement_id = FND_API.G_MISS_NUM THEN

Line 6259: p_x_header_rec.conversion_type_code := OE_Value_To_Id.conversion_type

6255: END IF;
6256:
6257: ELSE
6258:
6259: p_x_header_rec.conversion_type_code := OE_Value_To_Id.conversion_type
6260: ( p_conversion_type => p_header_val_rec.conversion_type
6261: );
6262:
6263: IF p_x_header_rec.conversion_type_code = FND_API.G_MISS_CHAR THEN

Line 6288: p_x_header_rec.fob_point_code := OE_Value_To_Id.fob_point

6284: END IF;
6285:
6286: ELSE
6287:
6288: p_x_header_rec.fob_point_code := OE_Value_To_Id.fob_point
6289: ( p_fob_point => p_header_val_rec.fob_point
6290: );
6291:
6292: IF p_x_header_rec.fob_point_code = FND_API.G_MISS_CHAR THEN

Line 6317: p_x_header_rec.freight_terms_code := OE_Value_To_Id.freight_terms

6313: END IF;
6314:
6315: ELSE
6316:
6317: p_x_header_rec.freight_terms_code := OE_Value_To_Id.freight_terms
6318: ( p_freight_terms => p_header_val_rec.freight_terms
6319: );
6320:
6321: IF p_x_header_rec.freight_terms_code = FND_API.G_MISS_CHAR THEN

Line 6345: p_x_header_rec.shipping_method_code := OE_Value_To_Id.ship_method

6341: END IF;
6342:
6343: ELSE
6344:
6345: p_x_header_rec.shipping_method_code := OE_Value_To_Id.ship_method
6346: ( p_ship_method => p_header_val_rec.shipping_method
6347: );
6348:
6349: IF p_x_header_rec.shipping_method_code = FND_API.G_MISS_CHAR THEN

Line 6376: p_x_header_rec.freight_carrier_code := OE_Value_To_Id.freight_carrier

6372: END IF;
6373:
6374: ELSE
6375:
6376: p_x_header_rec.freight_carrier_code := OE_Value_To_Id.freight_carrier
6377: ( p_freight_carrier => p_header_val_rec.freight_carrier
6378: , p_ship_from_org_id => p_x_header_rec.ship_from_org_id
6379: );
6380:

Line 6406: p_x_header_rec.invoicing_rule_id := OE_Value_To_Id.invoicing_rule

6402: END IF;
6403:
6404: ELSE
6405:
6406: p_x_header_rec.invoicing_rule_id := OE_Value_To_Id.invoicing_rule
6407: ( p_invoicing_rule => p_header_val_rec.invoicing_rule
6408: );
6409:
6410: IF p_x_header_rec.invoicing_rule_id = FND_API.G_MISS_NUM THEN

Line 6435: p_x_header_rec.order_source_id := OE_Value_To_Id.order_source

6431: END IF;
6432:
6433: ELSE
6434:
6435: p_x_header_rec.order_source_id := OE_Value_To_Id.order_source
6436: ( p_order_source => p_header_val_rec.order_source
6437: );
6438:
6439: IF p_x_header_rec.order_source_id = FND_API.G_MISS_NUM THEN

Line 6464: p_x_header_rec.order_type_id := OE_Value_To_Id.order_type

6460: END IF;
6461:
6462: ELSE
6463:
6464: p_x_header_rec.order_type_id := OE_Value_To_Id.order_type
6465: ( p_order_type => p_header_val_rec.order_type
6466: );
6467:
6468: IF p_x_header_rec.order_type_id = FND_API.G_MISS_NUM THEN

Line 6493: p_x_header_rec.payment_term_id := OE_Value_To_Id.payment_term

6489: END IF;
6490:
6491: ELSE
6492:
6493: p_x_header_rec.payment_term_id := OE_Value_To_Id.payment_term
6494: ( p_payment_term => p_header_val_rec.payment_term
6495: );
6496:
6497: IF p_x_header_rec.payment_term_id = FND_API.G_MISS_NUM THEN

Line 6522: p_x_header_rec.price_list_id := OE_Value_To_Id.price_list

6518: END IF;
6519:
6520: ELSE
6521:
6522: p_x_header_rec.price_list_id := OE_Value_To_Id.price_list
6523: ( p_price_list => p_header_val_rec.price_list
6524: );
6525:
6526: IF p_x_header_rec.price_list_id = FND_API.G_MISS_NUM THEN

Line 6551: p_x_header_rec.return_reason_code := OE_Value_To_Id.return_reason

6547: END IF;
6548:
6549: ELSE
6550:
6551: p_x_header_rec.return_reason_code := OE_Value_To_Id.return_reason
6552: ( p_return_reason => p_header_val_rec.return_reason
6553: );
6554:
6555: IF p_x_header_rec.return_reason_code = FND_API.G_MISS_CHAR THEN

Line 6580: p_x_header_rec.salesrep_id := OE_Value_To_Id.salesrep

6576: END IF;
6577:
6578: ELSE
6579:
6580: p_x_header_rec.salesrep_id := OE_Value_To_Id.salesrep
6581: ( p_salesrep => p_header_val_rec.salesrep
6582: );
6583: IF p_x_header_rec.salesrep_id = FND_API.G_MISS_NUM THEN
6584: p_x_header_rec.return_status := FND_API.G_RET_STS_ERROR;

Line 6609: p_x_header_rec.sales_channel_code := OE_Value_To_Id.sales_channel

6605: END IF;
6606:
6607: ELSE
6608:
6609: p_x_header_rec.sales_channel_code := OE_Value_To_Id.sales_channel
6610: ( p_sales_channel => p_header_val_rec.sales_channel
6611: );
6612: IF p_x_header_rec.sales_channel_code = FND_API.G_MISS_CHAR THEN
6613: p_x_header_rec.return_status := FND_API.G_RET_STS_ERROR;

Line 6638: p_x_header_rec.shipment_priority_code := OE_Value_To_Id.shipment_priority

6634: END IF;
6635:
6636: ELSE
6637:
6638: p_x_header_rec.shipment_priority_code := OE_Value_To_Id.shipment_priority
6639: ( p_shipment_priority => p_header_val_rec.shipment_priority
6640: );
6641:
6642: IF p_x_header_rec.shipment_priority_code = FND_API.G_MISS_CHAR THEN

Line 6672: p_x_header_rec.ship_from_org_id := OE_Value_To_Id.ship_from_org

6668: END IF;
6669:
6670: ELSE
6671:
6672: p_x_header_rec.ship_from_org_id := OE_Value_To_Id.ship_from_org
6673: ( p_ship_from_address1 => p_header_val_rec.ship_from_address1
6674: , p_ship_from_address2 => p_header_val_rec.ship_from_address2
6675: , p_ship_from_address3 => p_header_val_rec.ship_from_address3
6676: , p_ship_from_address4 => p_header_val_rec.ship_from_address4

Line 6706: p_x_header_rec.tax_exempt_flag := OE_Value_To_Id.tax_exempt

6702: END IF;
6703:
6704: ELSE
6705:
6706: p_x_header_rec.tax_exempt_flag := OE_Value_To_Id.tax_exempt
6707: ( p_tax_exempt => p_header_val_rec.tax_exempt
6708: );
6709:
6710: IF p_x_header_rec.tax_exempt_flag = FND_API.G_MISS_CHAR THEN

Line 6735: p_x_header_rec.tax_exempt_reason_code := OE_Value_To_Id.tax_exempt_reason

6731: END IF;
6732:
6733: ELSE
6734:
6735: p_x_header_rec.tax_exempt_reason_code := OE_Value_To_Id.tax_exempt_reason
6736: ( p_tax_exempt_reason => p_header_val_rec.tax_exempt_reason
6737: );
6738:
6739: IF p_x_header_rec.tax_exempt_reason_code = FND_API.G_MISS_CHAR THEN

Line 6764: p_x_header_rec.tax_point_code := OE_Value_To_Id.tax_point

6760: END IF;
6761:
6762: ELSE
6763:
6764: p_x_header_rec.tax_point_code := OE_Value_To_Id.tax_point
6765: ( p_tax_point => p_header_val_rec.tax_point
6766: );
6767:
6768: IF p_x_header_rec.tax_point_code = FND_API.G_MISS_CHAR THEN

Line 6793: p_x_header_rec.payment_type_code := OE_Value_To_Id.payment_type

6789: END IF;
6790:
6791: ELSE
6792:
6793: p_x_header_rec.payment_type_code := OE_Value_To_Id.payment_type
6794: ( p_payment_type => p_header_val_rec.payment_type
6795: );
6796:
6797: IF p_x_header_rec.payment_type_code = FND_API.G_MISS_CHAR THEN

Line 6822: p_x_header_rec.credit_card_code := OE_Value_To_Id.credit_card

6818: END IF;
6819:
6820: ELSE
6821:
6822: p_x_header_rec.credit_card_code := OE_Value_To_Id.credit_card
6823: ( p_credit_card => p_header_val_rec.credit_card
6824: );
6825:
6826: IF p_x_header_rec.credit_card_code = FND_API.G_MISS_CHAR THEN

Line 6858: p_x_header_rec.invoice_to_customer_id:=OE_Value_To_Id.site_customer

6854: END IF;
6855:
6856: ELSE
6857: IF p_x_header_rec.invoice_to_org_id = FND_API.G_MISS_NUM then -- 4231603
6858: p_x_header_rec.invoice_to_customer_id:=OE_Value_To_Id.site_customer
6859: ( p_site_customer => p_header_val_rec.invoice_to_customer_name_oi
6860: ,p_site_customer_number=> p_header_val_rec.invoice_to_customer_number_oi
6861: ,p_type =>'INVOICE_TO'
6862: );

Line 6894: p_x_header_rec.ship_to_customer_id:=OE_Value_To_Id.site_customer

6890: END IF;
6891:
6892: ELSE
6893: IF p_x_header_rec.ship_to_org_id = FND_API.G_MISS_NUM then -- 4231603
6894: p_x_header_rec.ship_to_customer_id:=OE_Value_To_Id.site_customer
6895: ( p_site_customer => p_header_val_rec.ship_to_customer_name_oi
6896: ,p_site_customer_number=> p_header_val_rec.ship_to_customer_number_oi
6897: ,p_type =>'SHIP_TO'
6898: );

Line 6931: p_x_header_rec.deliver_to_customer_id:=OE_Value_To_Id.site_customer

6927: END IF;
6928:
6929: ELSE
6930: IF p_x_header_rec.deliver_to_org_id = FND_API.G_MISS_NUM then -- 4231603
6931: p_x_header_rec.deliver_to_customer_id:=OE_Value_To_Id.site_customer
6932: ( p_site_customer => p_header_val_rec.ship_to_customer_name_oi
6933: ,p_site_customer_number=> p_header_val_rec.ship_to_customer_number_oi
6934: ,p_type =>'DELIVER_TO'
6935: );

Line 6968: p_x_header_rec.sold_to_org_id := OE_Value_To_Id.sold_to_org

6964: END IF;
6965:
6966: ELSE
6967:
6968: p_x_header_rec.sold_to_org_id := OE_Value_To_Id.sold_to_org
6969: ( p_sold_to_org => p_header_val_rec.sold_to_org
6970: , p_customer_number => p_header_val_rec.customer_number
6971: );
6972:

Line 6983: -- For e.g. oe_value_to_id.ship_to_org_id requires sold_to_org_id

6979: END IF;
6980:
6981: -- Retrieve the sold_to_org_id if not passed on the header record. This
6982: -- will be needed by the value_to_id functions for related fields.
6983: -- For e.g. oe_value_to_id.ship_to_org_id requires sold_to_org_id
6984:
6985: IF p_x_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE
6986: AND p_x_header_rec.sold_to_org_id = FND_API.G_MISS_NUM
6987: THEN

Line 7017: p_x_header_rec.sold_to_contact_id := OE_Value_To_Id.sold_to_contact

7013: END IF;
7014:
7015: ELSE
7016:
7017: p_x_header_rec.sold_to_contact_id := OE_Value_To_Id.sold_to_contact
7018: ( p_sold_to_contact => p_header_val_rec.sold_to_contact
7019: , p_sold_to_org_id => l_sold_to_org_id
7020: );
7021:

Line 7052: p_x_header_rec.deliver_to_org_id := OE_Value_To_Id.deliver_to_org

7048: END IF;
7049:
7050: ELSE
7051: /*1621182*/
7052: p_x_header_rec.deliver_to_org_id := OE_Value_To_Id.deliver_to_org
7053: ( p_deliver_to_address1 => p_header_val_rec.deliver_to_address1
7054: , p_deliver_to_address2 => p_header_val_rec.deliver_to_address2
7055: , p_deliver_to_address3 => p_header_val_rec.deliver_to_address3
7056: , p_deliver_to_address4 => p_header_val_rec.deliver_to_address4

Line 7098: p_x_header_rec.invoice_to_org_id := OE_Value_To_Id.invoice_to_org

7094: END IF;
7095:
7096: ELSE
7097: /*1621182*/
7098: p_x_header_rec.invoice_to_org_id := OE_Value_To_Id.invoice_to_org
7099: ( p_invoice_to_address1 => p_header_val_rec.invoice_to_address1
7100: , p_invoice_to_address2 => p_header_val_rec.invoice_to_address2
7101: , p_invoice_to_address3 => p_header_val_rec.invoice_to_address3
7102: , p_invoice_to_address4 => p_header_val_rec.invoice_to_address4

Line 7144: p_x_header_rec.ship_to_org_id := OE_Value_To_Id.ship_to_org

7140: END IF;
7141:
7142: ELSE
7143: /*1621182*/
7144: p_x_header_rec.ship_to_org_id := OE_Value_To_Id.ship_to_org
7145: ( p_ship_to_address1 => p_header_val_rec.ship_to_address1
7146: , p_ship_to_address2 => p_header_val_rec.ship_to_address2
7147: , p_ship_to_address3 => p_header_val_rec.ship_to_address3
7148: , p_ship_to_address4 => p_header_val_rec.ship_to_address4

Line 7190: p_x_header_rec.sold_to_site_use_id := OE_Value_To_Id.Customer_Location

7186:
7187: END IF;
7188:
7189: ELSE
7190: p_x_header_rec.sold_to_site_use_id := OE_Value_To_Id.Customer_Location
7191: ( p_sold_to_location_address1 => p_header_val_rec.sold_to_location_address1
7192: , p_sold_to_location_address2 => p_header_val_rec.sold_to_location_address2
7193: , p_sold_to_location_address3 => p_header_val_rec.sold_to_location_address3
7194: , p_sold_to_location_address4 => p_header_val_rec.sold_to_location_address4

Line 7217: -- For e.g. oe_value_to_id.ship_to_contact_id requires ship_to_org_id

7213: -- QUOTING changes
7214:
7215: -- Retrieve the org_ids if not passed on the header record. These
7216: -- IDs will be needed by the value_to_id functions for CONTACT fields.
7217: -- For e.g. oe_value_to_id.ship_to_contact_id requires ship_to_org_id
7218:
7219: IF p_x_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE
7220: AND ( p_x_header_rec.ship_to_org_id = FND_API.G_MISS_NUM
7221: OR p_x_header_rec.invoice_to_org_id = FND_API.G_MISS_NUM

Line 7269: p_x_header_rec.deliver_to_contact_id := OE_Value_To_Id.deliver_to_contact

7265: END IF;
7266:
7267: ELSE
7268:
7269: p_x_header_rec.deliver_to_contact_id := OE_Value_To_Id.deliver_to_contact
7270: ( p_deliver_to_contact => p_header_val_rec.deliver_to_contact
7271: , p_deliver_to_org_id => l_deliver_to_org_id
7272: );
7273:

Line 7299: p_x_header_rec.invoice_to_contact_id := OE_Value_To_Id.invoice_to_contact

7295: END IF;
7296:
7297: ELSE
7298:
7299: p_x_header_rec.invoice_to_contact_id := OE_Value_To_Id.invoice_to_contact
7300: ( p_invoice_to_contact => p_header_val_rec.invoice_to_contact
7301: , p_invoice_to_org_id => l_invoice_to_org_id
7302: );
7303:

Line 7329: p_x_header_rec.ship_to_contact_id := OE_Value_To_Id.ship_to_contact

7325: END IF;
7326:
7327: ELSE
7328:
7329: p_x_header_rec.ship_to_contact_id := OE_Value_To_Id.ship_to_contact
7330: ( p_ship_to_contact => p_header_val_rec.ship_to_contact
7331: , p_ship_to_org_id => l_ship_to_org_id
7332: );
7333:

Line 7361: p_x_header_rec.end_customer_id:=OE_Value_To_Id.end_customer

7357: END IF;
7358:
7359: ELSE
7360: IF p_x_header_rec.end_customer_site_use_id = FND_API.G_MISS_NUM THEN -- 4231603
7361: p_x_header_rec.end_customer_id:=OE_Value_To_Id.end_customer
7362: ( p_end_customer => p_header_val_rec.end_customer_name
7363: ,p_end_customer_number=> p_header_val_rec.end_customer_number
7364: );
7365:

Line 7392: p_x_header_rec.end_customer_contact_id := OE_Value_To_Id.end_customer_contact

7388: END IF;
7389:
7390: ELSE
7391: oe_debug_pub.add('before calling aend customer contact value to id');
7392: p_x_header_rec.end_customer_contact_id := OE_Value_To_Id.end_customer_contact
7393: ( p_end_customer_contact => p_header_val_rec.end_customer_contact
7394: ,p_end_customer_id =>p_x_header_rec.end_customer_id
7395: );
7396: oe_debug_pub.add('End customer contact id is '||p_x_header_rec.end_customer_contact_id);

Line 7432: p_x_header_rec.end_customer_site_use_id := OE_Value_To_Id.end_customer_site

7428: END IF;
7429:
7430: ELSE
7431: oe_debug_pub.add('Before calling End custoemr site use value to id');
7432: p_x_header_rec.end_customer_site_use_id := OE_Value_To_Id.end_customer_site
7433: ( p_end_customer_site_address1 => p_header_val_rec.end_customer_site_address1
7434: , p_end_customer_site_address2 => p_header_val_rec.end_customer_site_address2
7435: , p_end_customer_site_address3 => p_header_val_rec.end_customer_site_address3
7436: , p_end_customer_site_address4 => p_header_val_rec.end_customer_site_address4

Line 7475: p_x_header_rec.ib_owner:=OE_Value_To_Id.ib_owner

7471: END IF;
7472:
7473: ELSE
7474:
7475: p_x_header_rec.ib_owner:=OE_Value_To_Id.ib_owner
7476: ( p_ib_owner => p_header_val_rec.ib_owner_dsp
7477: );
7478:
7479: oe_Debug_pub.add('ib owner id is '||p_x_header_rec.ib_owner);

Line 7504: p_x_header_rec.ib_installed_at_location:=OE_Value_To_Id.ib_installed_at_location

7500: END IF;
7501:
7502: ELSE
7503:
7504: p_x_header_rec.ib_installed_at_location:=OE_Value_To_Id.ib_installed_at_location
7505: ( p_ib_installed_at_location => p_header_val_rec.ib_installed_at_location_dsp
7506: );
7507: oe_Debug_pub.add('installed at location'||p_x_header_rec.ib_installed_at_location);
7508:

Line 7532: p_x_header_rec.ib_current_location:=OE_Value_To_Id.ib_current_location

7528: END IF;
7529:
7530: ELSE
7531:
7532: p_x_header_rec.ib_current_location:=OE_Value_To_Id.ib_current_location
7533: ( p_ib_current_location => p_header_val_rec.ib_current_location_dsp
7534: );
7535:
7536: IF p_x_header_rec.ib_current_location = FND_API.G_MISS_CHAR THEN