DBA Data[Home] [Help]

APPS.WSH_SHIPMENT_REQUEST_PKG dependencies on OE_VALUE_TO_ID

Line 1550: -- Package OE_Value_To_Id does not fail.

1546: END IF; --}
1547:
1548: IF l_transaction_rec.action_type in ( 'A', 'C' ) THEN
1549: -- Setting Org Id before calling Derive_Header_Rec so that APIs in OM
1550: -- Package OE_Value_To_Id does not fail.
1551: MO_GLOBAL.Set_Policy_Context('S', l_org_id);
1552: --
1553: IF l_debug_on THEN
1554: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling Derive_Header_Rec', WSH_DEBUG_SV.C_PROC_LEVEL);

Line 4218: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling OE_Value_To_Id.Sold_To_Org', WSH_DEBUG_SV.C_PROC_LEVEL);

4214: p_del_interface_rec.customer_name is not null )
4215: THEN
4216: --
4217: IF l_debug_on THEN
4218: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling OE_Value_To_Id.Sold_To_Org', WSH_DEBUG_SV.C_PROC_LEVEL);
4219: END IF;
4220: --
4221: l_sold_to := OE_Value_To_Id.Sold_To_Org(
4222: p_sold_to_org => p_del_interface_rec.customer_name,

Line 4221: l_sold_to := OE_Value_To_Id.Sold_To_Org(

4217: IF l_debug_on THEN
4218: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling OE_Value_To_Id.Sold_To_Org', WSH_DEBUG_SV.C_PROC_LEVEL);
4219: END IF;
4220: --
4221: l_sold_to := OE_Value_To_Id.Sold_To_Org(
4222: p_sold_to_org => p_del_interface_rec.customer_name,
4223: p_customer_number => NULL );
4224:
4225: --

Line 4270: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling OE_Value_To_Id.Sold_To_Org to derive Ship-To customer', WSH_DEBUG_SV.C_PROC_LEVEL);

4266: p_del_interface_rec.ship_to_customer_id := p_del_interface_rec.customer_id;
4267: ELSE
4268: --
4269: IF l_debug_on THEN
4270: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling OE_Value_To_Id.Sold_To_Org to derive Ship-To customer', WSH_DEBUG_SV.C_PROC_LEVEL);
4271: END IF;
4272: --
4273: l_ship_to := OE_Value_To_Id.Sold_To_Org(
4274: p_sold_to_org => p_del_interface_rec.ship_to_customer_name,

Line 4273: l_ship_to := OE_Value_To_Id.Sold_To_Org(

4269: IF l_debug_on THEN
4270: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling OE_Value_To_Id.Sold_To_Org to derive Ship-To customer', WSH_DEBUG_SV.C_PROC_LEVEL);
4271: END IF;
4272: --
4273: l_ship_to := OE_Value_To_Id.Sold_To_Org(
4274: p_sold_to_org => p_del_interface_rec.ship_to_customer_name,
4275: p_customer_number => NULL );
4276:
4277: IF nvl(l_ship_to, FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN

Line 4307: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling OE_Value_To_Id.Sold_To_Org to derive Invoice-To customer', WSH_DEBUG_SV.C_PROC_LEVEL);

4303: p_om_header_rec.invoice_to_changed = FALSE )
4304: THEN
4305: --
4306: IF l_debug_on THEN
4307: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling OE_Value_To_Id.Sold_To_Org to derive Invoice-To customer', WSH_DEBUG_SV.C_PROC_LEVEL);
4308: END IF;
4309: --
4310: l_invoice_to := OE_Value_To_Id.Sold_To_Org(
4311: p_sold_to_org => p_del_interface_rec.invoice_to_customer_name,

Line 4310: l_invoice_to := OE_Value_To_Id.Sold_To_Org(

4306: IF l_debug_on THEN
4307: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling OE_Value_To_Id.Sold_To_Org to derive Invoice-To customer', WSH_DEBUG_SV.C_PROC_LEVEL);
4308: END IF;
4309: --
4310: l_invoice_to := OE_Value_To_Id.Sold_To_Org(
4311: p_sold_to_org => p_del_interface_rec.invoice_to_customer_name,
4312: p_customer_number => NULL );
4313:
4314: IF nvl(l_invoice_to, FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN

Line 4354: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling OE_Value_To_Id.Sold_To_Org to derive Deliver-To customer', WSH_DEBUG_SV.C_PROC_LEVEL);

4350: p_om_header_rec.deliver_to_changed = FALSE )
4351: THEN
4352: --
4353: IF l_debug_on THEN
4354: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling OE_Value_To_Id.Sold_To_Org to derive Deliver-To customer', WSH_DEBUG_SV.C_PROC_LEVEL);
4355: END IF;
4356: --
4357: l_deliver_to := OE_Value_To_Id.Sold_To_Org(
4358: p_sold_to_org => p_del_interface_rec.deliver_to_customer_name,

Line 4357: l_deliver_to := OE_Value_To_Id.Sold_To_Org(

4353: IF l_debug_on THEN
4354: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling OE_Value_To_Id.Sold_To_Org to derive Deliver-To customer', WSH_DEBUG_SV.C_PROC_LEVEL);
4355: END IF;
4356: --
4357: l_deliver_to := OE_Value_To_Id.Sold_To_Org(
4358: p_sold_to_org => p_del_interface_rec.deliver_to_customer_name,
4359: p_customer_number => NULL );
4360:
4361: IF nvl(l_deliver_to, FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN

Line 4392: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling OE_Value_To_Id.Ship_To_Org', WSH_DEBUG_SV.C_PROC_LEVEL);

4388: p_om_header_rec.ship_to_changed = FALSE )
4389: THEN -- { Ship-To
4390: --
4391: IF l_debug_on THEN
4392: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling OE_Value_To_Id.Ship_To_Org', WSH_DEBUG_SV.C_PROC_LEVEL);
4393: END IF;
4394: --
4395: l_ship_to_site :=
4396: OE_Value_To_Id.Ship_To_Org(

Line 4396: OE_Value_To_Id.Ship_To_Org(

4392: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling OE_Value_To_Id.Ship_To_Org', WSH_DEBUG_SV.C_PROC_LEVEL);
4393: END IF;
4394: --
4395: l_ship_to_site :=
4396: OE_Value_To_Id.Ship_To_Org(
4397: p_ship_to_address1 => p_del_interface_rec.ship_to_address1,
4398: p_ship_to_address2 => p_del_interface_rec.ship_to_address2,
4399: p_ship_to_address3 => p_del_interface_rec.ship_to_address3,
4400: p_ship_to_address4 => p_del_interface_rec.ship_to_address4,

Line 4445: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling OE_Value_To_Id.Invoice_To_Org', WSH_DEBUG_SV.C_PROC_LEVEL);

4441: p_om_header_rec.invoice_to_changed = FALSE )
4442: THEN -- { Invoice-To
4443: --
4444: IF l_debug_on THEN
4445: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling OE_Value_To_Id.Invoice_To_Org', WSH_DEBUG_SV.C_PROC_LEVEL);
4446: END IF;
4447: --
4448: l_invoice_to_site :=
4449: OE_Value_To_Id.Invoice_To_Org(

Line 4449: OE_Value_To_Id.Invoice_To_Org(

4445: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling OE_Value_To_Id.Invoice_To_Org', WSH_DEBUG_SV.C_PROC_LEVEL);
4446: END IF;
4447: --
4448: l_invoice_to_site :=
4449: OE_Value_To_Id.Invoice_To_Org(
4450: p_invoice_to_address1 => p_del_interface_rec.invoice_to_address1,
4451: p_invoice_to_address2 => p_del_interface_rec.invoice_to_address2,
4452: p_invoice_to_address3 => p_del_interface_rec.invoice_to_address3,
4453: p_invoice_to_address4 => p_del_interface_rec.invoice_to_address4,

Line 4499: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling OE_Value_To_Id.Deliver_To_Org', WSH_DEBUG_SV.C_PROC_LEVEL);

4495: p_om_header_rec.deliver_to_changed = FALSE )
4496: THEN -- { Deliver-To
4497: --
4498: IF l_debug_on THEN
4499: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling OE_Value_To_Id.Deliver_To_Org', WSH_DEBUG_SV.C_PROC_LEVEL);
4500: END IF;
4501: --
4502: l_deliver_to_site :=
4503: OE_Value_To_Id.Deliver_To_Org(

Line 4503: OE_Value_To_Id.Deliver_To_Org(

4499: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling OE_Value_To_Id.Deliver_To_Org', WSH_DEBUG_SV.C_PROC_LEVEL);
4500: END IF;
4501: --
4502: l_deliver_to_site :=
4503: OE_Value_To_Id.Deliver_To_Org(
4504: p_deliver_to_address1 => p_del_interface_rec.deliver_to_address1,
4505: p_deliver_to_address2 => p_del_interface_rec.deliver_to_address2,
4506: p_deliver_to_address3 => p_del_interface_rec.deliver_to_address3,
4507: p_deliver_to_address4 => p_del_interface_rec.deliver_to_address4,

Line 4567: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling OE_Value_To_Id.Sold_To_Contact Ship-To-Contact', WSH_DEBUG_SV.C_PROC_LEVEL);

4563: p_del_interface_rec.ship_to_contact_name is not null )
4564: THEN -- {
4565: --
4566: IF l_debug_on THEN
4567: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling OE_Value_To_Id.Sold_To_Contact Ship-To-Contact', WSH_DEBUG_SV.C_PROC_LEVEL);
4568: END IF;
4569: --
4570: l_ship_to_contact :=
4571: OE_Value_To_Id.Sold_To_Contact (

Line 4571: OE_Value_To_Id.Sold_To_Contact (

4567: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling OE_Value_To_Id.Sold_To_Contact Ship-To-Contact', WSH_DEBUG_SV.C_PROC_LEVEL);
4568: END IF;
4569: --
4570: l_ship_to_contact :=
4571: OE_Value_To_Id.Sold_To_Contact (
4572: p_sold_to_contact => p_del_interface_rec.ship_to_contact_name,
4573: p_sold_to_org_id => p_del_interface_rec.ship_to_customer_id );
4574:
4575: --

Line 4625: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling OE_Value_To_Id.Sold_To_Contact Invoice-To-Contact', WSH_DEBUG_SV.C_PROC_LEVEL);

4621: p_om_header_rec.invoice_to_contact_changed = FALSE )
4622: THEN -- {
4623: --
4624: IF l_debug_on THEN
4625: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling OE_Value_To_Id.Sold_To_Contact Invoice-To-Contact', WSH_DEBUG_SV.C_PROC_LEVEL);
4626: END IF;
4627: --
4628: l_invoice_to_contact :=
4629: OE_Value_To_Id.Sold_To_Contact (

Line 4629: OE_Value_To_Id.Sold_To_Contact (

4625: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling OE_Value_To_Id.Sold_To_Contact Invoice-To-Contact', WSH_DEBUG_SV.C_PROC_LEVEL);
4626: END IF;
4627: --
4628: l_invoice_to_contact :=
4629: OE_Value_To_Id.Sold_To_Contact (
4630: p_sold_to_contact => p_del_interface_rec.invoice_to_contact_name,
4631: p_sold_to_org_id => p_del_interface_rec.invoice_to_customer_id );
4632:
4633: --

Line 4691: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling OE_Value_To_Id.Sold_To_Contact for Deliver-To-Contact', WSH_DEBUG_SV.C_PROC_LEVEL);

4687: p_om_header_rec.deliver_to_contact_changed = FALSE )
4688: THEN -- {
4689: --
4690: IF l_debug_on THEN
4691: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling OE_Value_To_Id.Sold_To_Contact for Deliver-To-Contact', WSH_DEBUG_SV.C_PROC_LEVEL);
4692: END IF;
4693: --
4694: l_deliver_to_contact :=
4695: OE_Value_To_Id.Sold_To_Contact (

Line 4695: OE_Value_To_Id.Sold_To_Contact (

4691: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling OE_Value_To_Id.Sold_To_Contact for Deliver-To-Contact', WSH_DEBUG_SV.C_PROC_LEVEL);
4692: END IF;
4693: --
4694: l_deliver_to_contact :=
4695: OE_Value_To_Id.Sold_To_Contact (
4696: p_sold_to_contact => p_del_interface_rec.deliver_to_contact_name,
4697: p_sold_to_org_id => p_del_interface_rec.deliver_to_customer_id );
4698:
4699: --

Line 6198: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling OE_Value_To_Id.Sold_To_Org', WSH_DEBUG_SV.C_PROC_LEVEL);

6194: -- Derive Customer Id, if its null
6195: IF l_customer_id is null THEN -- {
6196: --
6197: IF l_debug_on THEN
6198: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling OE_Value_To_Id.Sold_To_Org', WSH_DEBUG_SV.C_PROC_LEVEL);
6199: END IF;
6200: --
6201: l_customer_id := OE_Value_To_Id.Sold_To_Org(
6202: p_sold_to_org => p_del_interface_rec.customer_name,

Line 6201: l_customer_id := OE_Value_To_Id.Sold_To_Org(

6197: IF l_debug_on THEN
6198: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling OE_Value_To_Id.Sold_To_Org', WSH_DEBUG_SV.C_PROC_LEVEL);
6199: END IF;
6200: --
6201: l_customer_id := OE_Value_To_Id.Sold_To_Org(
6202: p_sold_to_org => p_del_interface_rec.customer_name,
6203: p_customer_number => NULL );
6204:
6205: IF nvl(l_customer_id, FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN

Line 6225: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling OE_Value_To_Id.Ship_To_Org', WSH_DEBUG_SV.C_PROC_LEVEL);

6221: p_del_interface_rec.ship_to_address1 is not null )
6222: THEN -- {
6223: --
6224: IF l_debug_on THEN
6225: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling OE_Value_To_Id.Ship_To_Org', WSH_DEBUG_SV.C_PROC_LEVEL);
6226: END IF;
6227: --
6228: l_ship_to_org_id :=
6229: OE_Value_To_Id.Ship_To_Org(

Line 6229: OE_Value_To_Id.Ship_To_Org(

6225: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling OE_Value_To_Id.Ship_To_Org', WSH_DEBUG_SV.C_PROC_LEVEL);
6226: END IF;
6227: --
6228: l_ship_to_org_id :=
6229: OE_Value_To_Id.Ship_To_Org(
6230: p_ship_to_address1 => p_del_interface_rec.ship_to_address1,
6231: p_ship_to_address2 => p_del_interface_rec.ship_to_address2,
6232: p_ship_to_address3 => p_del_interface_rec.ship_to_address3,
6233: p_ship_to_address4 => p_del_interface_rec.ship_to_address4,