DBA Data[Home] [Help]

APPS.WSH_PICK_LIST dependencies on WSH_PICKING_BATCHES_PKG

Line 5658: WSH_PICKING_BATCHES_PKG.Insert_Row (

5654: -- create pack/ship batch for this group.
5655: l_del_batch_id := NULL;
5656: l_del_batch_name := NULL;
5657:
5658: WSH_PICKING_BATCHES_PKG.Insert_Row (
5659: X_Rowid => l_tmp_row_id,
5660: X_Batch_Id => l_del_batch_id,
5661: P_Creation_Date => NULL,
5662: P_Created_By => NULL,

Line 6747: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PICKING_BATCHES_PKG.INSERT_ROW',WSH_DEBUG_SV.C_PROC_LEVEL);

6743: wsh_debug_sv.log(l_module_name, 'calc. requested end date', l_reqEndDate);
6744: END IF;
6745: --
6746: IF l_debug_on THEN
6747: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PICKING_BATCHES_PKG.INSERT_ROW',WSH_DEBUG_SV.C_PROC_LEVEL);
6748: END IF;
6749:
6750: -- bug5117876, insert statement is replace with the following call
6751: WSH_PICKING_BATCHES_PKG.Insert_Row(

Line 6751: WSH_PICKING_BATCHES_PKG.Insert_Row(

6747: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PICKING_BATCHES_PKG.INSERT_ROW',WSH_DEBUG_SV.C_PROC_LEVEL);
6748: END IF;
6749:
6750: -- bug5117876, insert statement is replace with the following call
6751: WSH_PICKING_BATCHES_PKG.Insert_Row(
6752: X_Rowid => l_rowid,
6753: X_Batch_Id => l_batch_id,
6754: P_Creation_Date => SYSDATE,
6755: P_Created_By => l_user_id,

Line 6942: -- 3. Create picking batch by calling WSH_PICKING_BATCHES_PKG.Insert_Row.

6938: -- Pre-reqs : None.
6939: -- Procedure: API to launch pick Release process based on input entity passed. Api dose
6940: -- 1. Get the Entity name for the passed entity
6941: -- 2. Get the entity status.
6942: -- 3. Create picking batch by calling WSH_PICKING_BATCHES_PKG.Insert_Row.
6943: -- 4. Update the detail lines with batch id.
6944: -- 5. Submit request to release batch created by calling WSH_PICKING_BATCHES_PKG.Submit_Release_Request
6945: -- Parameters :
6946: -- IN:

Line 6944: -- 5. Submit request to release batch created by calling WSH_PICKING_BATCHES_PKG.Submit_Release_Request

6940: -- 1. Get the Entity name for the passed entity
6941: -- 2. Get the entity status.
6942: -- 3. Create picking batch by calling WSH_PICKING_BATCHES_PKG.Insert_Row.
6943: -- 4. Update the detail lines with batch id.
6944: -- 5. Submit request to release batch created by calling WSH_PICKING_BATCHES_PKG.Submit_Release_Request
6945: -- Parameters :
6946: -- IN:
6947: -- p_trip_ids IN Trip id.
6948: -- p_stop_ids IN Stop Id.

Line 7434: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PICKING_BATCHES_PKG.INSERT_ROW',WSH_DEBUG_SV.C_PROC_LEVEL);

7430: END IF;
7431: CLOSE c_batch_info;
7432: --
7433: IF l_debug_on THEN
7434: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PICKING_BATCHES_PKG.INSERT_ROW',WSH_DEBUG_SV.C_PROC_LEVEL);
7435: END IF;
7436: --
7437: WSH_PICKING_BATCHES_PKG.Insert_Row(
7438: X_Rowid => l_rowid,

Line 7437: WSH_PICKING_BATCHES_PKG.Insert_Row(

7433: IF l_debug_on THEN
7434: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PICKING_BATCHES_PKG.INSERT_ROW',WSH_DEBUG_SV.C_PROC_LEVEL);
7435: END IF;
7436: --
7437: WSH_PICKING_BATCHES_PKG.Insert_Row(
7438: X_Rowid => l_rowid,
7439: X_Batch_Id => l_batch_id,
7440: P_Creation_Date => NULL,
7441: P_Created_By => NULL,

Line 7522: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PICKING_BATCHES_PKG.INSERT_ROW',WSH_DEBUG_SV.C_PROC_LEVEL);

7518: ELSE
7519: --
7520: --
7521: IF l_debug_on THEN
7522: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PICKING_BATCHES_PKG.INSERT_ROW',WSH_DEBUG_SV.C_PROC_LEVEL);
7523: END IF;
7524: --
7525: WSH_PICKING_BATCHES_PKG.Insert_Row(
7526: X_Rowid => l_rowid,

Line 7525: WSH_PICKING_BATCHES_PKG.Insert_Row(

7521: IF l_debug_on THEN
7522: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PICKING_BATCHES_PKG.INSERT_ROW',WSH_DEBUG_SV.C_PROC_LEVEL);
7523: END IF;
7524: --
7525: WSH_PICKING_BATCHES_PKG.Insert_Row(
7526: X_Rowid => l_rowid,
7527: X_Batch_Id => l_batch_id,
7528: P_Creation_Date => NULL,
7529: P_Created_By => NULL,

Line 7694: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PICKING_BATCHES_PKG.SUBMIT_RELEASE_REQUEST',WSH_DEBUG_SV.C_PROC_LEVEL);

7690: END IF;
7691:
7692:
7693: IF l_debug_on THEN
7694: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PICKING_BATCHES_PKG.SUBMIT_RELEASE_REQUEST',WSH_DEBUG_SV.C_PROC_LEVEL);
7695: END IF;
7696: --Submit request to release batch created.
7697: x_request_ids(l_index) := WSH_PICKING_BATCHES_PKG.Submit_Release_Request(
7698: p_batch_id => l_batch_id,

Line 7697: x_request_ids(l_index) := WSH_PICKING_BATCHES_PKG.Submit_Release_Request(

7693: IF l_debug_on THEN
7694: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PICKING_BATCHES_PKG.SUBMIT_RELEASE_REQUEST',WSH_DEBUG_SV.C_PROC_LEVEL);
7695: END IF;
7696: --Submit request to release batch created.
7697: x_request_ids(l_index) := WSH_PICKING_BATCHES_PKG.Submit_Release_Request(
7698: p_batch_id => l_batch_id,
7699: p_log_level => l_log_level,
7700: p_num_workers => 1, -- Always 1
7701: p_commit => 'N');