APPS.WSH_DELIVERY_DETAILS_INV dependencies on SERIAL_CHECK

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

2247: -- Debug Statements
2248: --
2249: IF l_debug_on THEN
2250: WSH_DEBUG_SV.log(l_module_name,'transaction_temp_id',l_transaction_temp_id);
2251: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit SERIAL_CHECK.INV_MARK_SERIAL',WSH_DEBUG_SV.C_PROC_LEVEL);
2252: END IF;
2253: --
2254: -- bug 5028993
2255: -- if serial_number is not null, while calling mark_serial,

Line 2259: Serial_Check.Inv_Mark_Serial(

2255: -- if serial_number is not null, while calling mark_serial,
2256: -- need to use l_transaction_temp_id and not the delivery_detail_id
2257: --RTV changes
2258: IF l_source_code = 'RTV' THEN
2259: Serial_Check.Inv_Mark_Serial(
2260: p_serial_number,
2261: p_serial_number,
2262: l_inv_item_id,
2263: l_org_id,

Line 2269: Serial_Check.Inv_Mark_Serial(

2265: l_transaction_temp_id,
2266: l_source_line_id,
2267: l_success);
2268: ELSE
2269: Serial_Check.Inv_Mark_Serial(
2270: p_serial_number,
2271: p_serial_number,
2272: l_inv_item_id,
2273: l_org_id,

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

2313: --
2314: -- Debug Statements
2315: --
2316: IF l_debug_on THEN
2317: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit SERIAL_CHECK.INV_MARK_SERIAL',WSH_DEBUG_SV.C_PROC_LEVEL);
2318: END IF;
2319: --
2320: -- Fix for bug 2762219.
2321: -- if transaction_Temp_id is not null, while calling mark_serial,

Line 2325: Serial_Check.Inv_Mark_Serial(

2321: -- if transaction_Temp_id is not null, while calling mark_serial,
2322: -- need to Use p_transaction_Temp_id and not the delivery_detail_id
2323: --RTV changes
2324: IF l_source_code = 'RTV' THEN
2325: Serial_Check.Inv_Mark_Serial(
2326: c.fm_serial_number,
2327: c.to_serial_number,
2328: l_inv_item_id,
2329: l_org_id,

Line 2335: Serial_Check.Inv_Mark_Serial(

2331: p_transaction_temp_id,
2332: l_source_line_id,
2333: l_success);
2334: ELSE
2335: Serial_Check.Inv_Mark_Serial(
2336: c.fm_serial_number,
2337: c.to_serial_number,
2338: l_inv_item_id,
2339: l_org_id,

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

2555: --
2556: -- Debug Statements
2557: --
2558: IF l_debug_on THEN
2559: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit SERIAL_CHECK.INV_UNMARK_SERIAL',WSH_DEBUG_SV.C_PROC_LEVEL);
2560: END IF;
2561: --
2562: Serial_Check.Inv_Unmark_Serial(
2563: p_serial_number,

Line 2562: Serial_Check.Inv_Unmark_Serial(

2558: IF l_debug_on THEN
2559: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit SERIAL_CHECK.INV_UNMARK_SERIAL',WSH_DEBUG_SV.C_PROC_LEVEL);
2560: END IF;
2561: --
2562: Serial_Check.Inv_Unmark_Serial(
2563: p_serial_number,
2564: p_serial_number,
2565: NULL,
2566: NULL,

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

2605: --
2606: -- Debug Statements
2607: --
2608: IF l_debug_on THEN
2609: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit SERIAL_CHECK.INV_UNMARK_SERIAL',WSH_DEBUG_SV.C_PROC_LEVEL);
2610: END IF;
2611: --
2612: Serial_Check.Inv_Unmark_Serial(
2613: c.fm_Serial_number ,

Line 2612: Serial_Check.Inv_Unmark_Serial(

2608: IF l_debug_on THEN
2609: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit SERIAL_CHECK.INV_UNMARK_SERIAL',WSH_DEBUG_SV.C_PROC_LEVEL);
2610: END IF;
2611: --
2612: Serial_Check.Inv_Unmark_Serial(
2613: c.fm_Serial_number ,
2614: c.to_Serial_number ,
2615: NULL,
2616: NULL,

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

4800: END IF;
4801: END IF;
4802:
4803: IF l_debug_on THEN
4804: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit MTL_SERIAL_CHECK.INV_SERIAL_INFO',WSH_DEBUG_SV.C_PROC_LEVEL);
4805: END IF;
4806:
4807: IF NOT MTL_SERIAL_CHECK.INV_SERIAL_INFO(p_from_serial_number => p_from_serial_number ,
4808: p_to_serial_number => p_to_serial_number ,

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

4803: IF l_debug_on THEN
4804: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit MTL_SERIAL_CHECK.INV_SERIAL_INFO',WSH_DEBUG_SV.C_PROC_LEVEL);
4805: END IF;
4806:
4807: IF NOT MTL_SERIAL_CHECK.INV_SERIAL_INFO(p_from_serial_number => p_from_serial_number ,
4808: p_to_serial_number => p_to_serial_number ,
4809: x_prefix => x_prefix,
4810: x_quantity => x_quantity,
4811: x_from_number => l_from_number,

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

5449: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
5450: WSH_DEBUG_SV.log(l_module_name,'P_TRANSACTION_TEMP_ID',
5451: P_TRANSACTION_TEMP_ID);
5452: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_DETAIL_ID',P_DELIVERY_DETAIL_ID);
5453: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit SERIAL_CHECK.INV_UPDATE_MARKED_SERIAL',WSH_DEBUG_SV.C_PROC_LEVEL);
5454: END IF;
5455: --
5456: --RTV changes
5457: OPEN Fetch_Detail_Info;

Line 5477: Serial_Check.Inv_Update_Marked_Serial (

5473: CLOSE Fetch_Detail_Info;
5474: END IF;
5475:
5476: IF l_source_code = 'RTV' THEN
5477: Serial_Check.Inv_Update_Marked_Serial (
5478: from_serial_number => p_from_serial_number,
5479: to_serial_number => p_to_serial_number, -- this should be NULL for single serial
5480: item_id => p_inventory_item_id,
5481: org_id => p_organization_id,

Line 5488: Serial_Check.Inv_Update_Marked_Serial (

5484: lot_temp_id => l_source_line_id,
5485: success => l_success);
5486: --RTV changes
5487: ELSE
5488: Serial_Check.Inv_Update_Marked_Serial (
5489: from_serial_number => p_from_serial_number,
5490: to_serial_number => p_to_serial_number, -- this should be NULL for single serial
5491: item_id => p_inventory_item_id,
5492: org_id => p_organization_id,