DBA Data[Home] [Help]

APPS.WSH_DELIVERY_DETAILS_INV dependencies on SERIAL_CHECK

Line 2020: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit SERIAL_CHECK.INV_MARK_SERIAL',WSH_DEBUG_SV.C_PROC_LEVEL);

2016: -- Debug Statements
2017: --
2018: IF l_debug_on THEN
2019: WSH_DEBUG_SV.log(l_module_name,'transaction_temp_id',l_transaction_temp_id);
2020: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit SERIAL_CHECK.INV_MARK_SERIAL',WSH_DEBUG_SV.C_PROC_LEVEL);
2021: END IF;
2022: --
2023: -- bug 5028993
2024: -- if serial_number is not null, while calling mark_serial,

Line 2026: Serial_Check.Inv_Mark_Serial(

2022: --
2023: -- bug 5028993
2024: -- if serial_number is not null, while calling mark_serial,
2025: -- need to use l_transaction_temp_id and not the delivery_detail_id
2026: Serial_Check.Inv_Mark_Serial(
2027: p_serial_number,
2028: p_serial_number,
2029: l_inv_item_id,
2030: l_org_id,

Line 2073: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit SERIAL_CHECK.INV_MARK_SERIAL',WSH_DEBUG_SV.C_PROC_LEVEL);

2069: --
2070: -- Debug Statements
2071: --
2072: IF l_debug_on THEN
2073: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit SERIAL_CHECK.INV_MARK_SERIAL',WSH_DEBUG_SV.C_PROC_LEVEL);
2074: END IF;
2075: --
2076: -- Fix for bug 2762219.
2077: -- if transaction_Temp_id is not null, while calling mark_serial,

Line 2079: Serial_Check.Inv_Mark_Serial(

2075: --
2076: -- Fix for bug 2762219.
2077: -- if transaction_Temp_id is not null, while calling mark_serial,
2078: -- need to Use p_transaction_Temp_id and not the delivery_detail_id
2079: Serial_Check.Inv_Mark_Serial(
2080: c.fm_serial_number,
2081: c.to_serial_number,
2082: l_inv_item_id,
2083: l_org_id,

Line 2255: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit SERIAL_CHECK.INV_UNMARK_SERIAL',WSH_DEBUG_SV.C_PROC_LEVEL);

2251: --
2252: -- Debug Statements
2253: --
2254: IF l_debug_on THEN
2255: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit SERIAL_CHECK.INV_UNMARK_SERIAL',WSH_DEBUG_SV.C_PROC_LEVEL);
2256: END IF;
2257: --
2258: Serial_Check.Inv_Unmark_Serial(
2259: p_serial_number,

Line 2258: Serial_Check.Inv_Unmark_Serial(

2254: IF l_debug_on THEN
2255: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit SERIAL_CHECK.INV_UNMARK_SERIAL',WSH_DEBUG_SV.C_PROC_LEVEL);
2256: END IF;
2257: --
2258: Serial_Check.Inv_Unmark_Serial(
2259: p_serial_number,
2260: p_serial_number,
2261: NULL,
2262: NULL,

Line 2296: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit SERIAL_CHECK.INV_UNMARK_SERIAL',WSH_DEBUG_SV.C_PROC_LEVEL);

2292: --
2293: -- Debug Statements
2294: --
2295: IF l_debug_on THEN
2296: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit SERIAL_CHECK.INV_UNMARK_SERIAL',WSH_DEBUG_SV.C_PROC_LEVEL);
2297: END IF;
2298: --
2299: Serial_Check.Inv_Unmark_Serial(
2300: c.fm_Serial_number ,

Line 2299: Serial_Check.Inv_Unmark_Serial(

2295: IF l_debug_on THEN
2296: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit SERIAL_CHECK.INV_UNMARK_SERIAL',WSH_DEBUG_SV.C_PROC_LEVEL);
2297: END IF;
2298: --
2299: Serial_Check.Inv_Unmark_Serial(
2300: c.fm_Serial_number ,
2301: c.to_Serial_number ,
2302: NULL,
2303: NULL,

Line 4453: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit MTL_SERIAL_CHECK.INV_SERIAL_INFO',WSH_DEBUG_SV.C_PROC_LEVEL);

4449: END IF;
4450: END IF;
4451:
4452: IF l_debug_on THEN
4453: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit MTL_SERIAL_CHECK.INV_SERIAL_INFO',WSH_DEBUG_SV.C_PROC_LEVEL);
4454: END IF;
4455:
4456: IF NOT MTL_SERIAL_CHECK.INV_SERIAL_INFO(p_from_serial_number => p_from_serial_number ,
4457: p_to_serial_number => p_to_serial_number ,

Line 4456: IF NOT MTL_SERIAL_CHECK.INV_SERIAL_INFO(p_from_serial_number => p_from_serial_number ,

4452: IF l_debug_on THEN
4453: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit MTL_SERIAL_CHECK.INV_SERIAL_INFO',WSH_DEBUG_SV.C_PROC_LEVEL);
4454: END IF;
4455:
4456: IF NOT MTL_SERIAL_CHECK.INV_SERIAL_INFO(p_from_serial_number => p_from_serial_number ,
4457: p_to_serial_number => p_to_serial_number ,
4458: x_prefix => x_prefix,
4459: x_quantity => x_quantity,
4460: x_from_number => l_from_number,

Line 5063: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit SERIAL_CHECK.INV_UPDATE_MARKED_SERIAL',WSH_DEBUG_SV.C_PROC_LEVEL);

5059: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
5060: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
5061: WSH_DEBUG_SV.log(l_module_name,'P_TRANSACTION_TEMP_ID',
5062: P_TRANSACTION_TEMP_ID);
5063: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit SERIAL_CHECK.INV_UPDATE_MARKED_SERIAL',WSH_DEBUG_SV.C_PROC_LEVEL);
5064: END IF;
5065: --
5066: Serial_Check.Inv_Update_Marked_Serial (
5067: from_serial_number => p_from_serial_number,

Line 5066: Serial_Check.Inv_Update_Marked_Serial (

5062: P_TRANSACTION_TEMP_ID);
5063: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit SERIAL_CHECK.INV_UPDATE_MARKED_SERIAL',WSH_DEBUG_SV.C_PROC_LEVEL);
5064: END IF;
5065: --
5066: Serial_Check.Inv_Update_Marked_Serial (
5067: from_serial_number => p_from_serial_number,
5068: to_serial_number => p_to_serial_number, -- this should be NULL for single serial
5069: item_id => p_inventory_item_id,
5070: org_id => p_organization_id,