DBA Data[Home] [Help]

APPS.WSH_PICK_LIST dependencies on WSH_PICKING_BATCHES_PKG

Line 5792: WSH_PICKING_BATCHES_PKG.Insert_Row (

5788: -- create pack/ship batch for this group.
5789: l_del_batch_id := NULL;
5790: l_del_batch_name := NULL;
5791:
5792: WSH_PICKING_BATCHES_PKG.Insert_Row (
5793: X_Rowid => l_tmp_row_id,
5794: X_Batch_Id => l_del_batch_id,
5795: P_Creation_Date => NULL,
5796: P_Created_By => NULL,

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

6883: wsh_debug_sv.log(l_module_name, 'calc. requested end date', l_reqEndDate);
6884: END IF;
6885: --
6886: IF l_debug_on THEN
6887: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PICKING_BATCHES_PKG.INSERT_ROW',WSH_DEBUG_SV.C_PROC_LEVEL);
6888: END IF;
6889:
6890: -- bug5117876, insert statement is replace with the following call
6891: WSH_PICKING_BATCHES_PKG.Insert_Row(

Line 6891: WSH_PICKING_BATCHES_PKG.Insert_Row(

6887: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PICKING_BATCHES_PKG.INSERT_ROW',WSH_DEBUG_SV.C_PROC_LEVEL);
6888: END IF;
6889:
6890: -- bug5117876, insert statement is replace with the following call
6891: WSH_PICKING_BATCHES_PKG.Insert_Row(
6892: X_Rowid => l_rowid,
6893: X_Batch_Id => l_batch_id,
6894: P_Creation_Date => SYSDATE,
6895: P_Created_By => l_user_id,

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

7080: -- Pre-reqs : None.
7081: -- Procedure: API to launch pick Release process based on input entity passed. Api dose
7082: -- 1. Get the Entity name for the passed entity
7083: -- 2. Get the entity status.
7084: -- 3. Create picking batch by calling WSH_PICKING_BATCHES_PKG.Insert_Row.
7085: -- 4. Update the detail lines with batch id.
7086: -- 5. Submit request to release batch created by calling WSH_PICKING_BATCHES_PKG.Submit_Release_Request
7087: -- Parameters :
7088: -- IN:

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

7082: -- 1. Get the Entity name for the passed entity
7083: -- 2. Get the entity status.
7084: -- 3. Create picking batch by calling WSH_PICKING_BATCHES_PKG.Insert_Row.
7085: -- 4. Update the detail lines with batch id.
7086: -- 5. Submit request to release batch created by calling WSH_PICKING_BATCHES_PKG.Submit_Release_Request
7087: -- Parameters :
7088: -- IN:
7089: -- p_trip_ids IN Trip id.
7090: -- p_stop_ids IN Stop Id.

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

7573: END IF;
7574: CLOSE c_batch_info;
7575: --
7576: IF l_debug_on THEN
7577: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PICKING_BATCHES_PKG.INSERT_ROW',WSH_DEBUG_SV.C_PROC_LEVEL);
7578: END IF;
7579: --
7580: WSH_PICKING_BATCHES_PKG.Insert_Row(
7581: X_Rowid => l_rowid,

Line 7580: WSH_PICKING_BATCHES_PKG.Insert_Row(

7576: IF l_debug_on THEN
7577: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PICKING_BATCHES_PKG.INSERT_ROW',WSH_DEBUG_SV.C_PROC_LEVEL);
7578: END IF;
7579: --
7580: WSH_PICKING_BATCHES_PKG.Insert_Row(
7581: X_Rowid => l_rowid,
7582: X_Batch_Id => l_batch_id,
7583: P_Creation_Date => NULL,
7584: P_Created_By => NULL,

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

7663: ELSE
7664: --
7665: --
7666: IF l_debug_on THEN
7667: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PICKING_BATCHES_PKG.INSERT_ROW',WSH_DEBUG_SV.C_PROC_LEVEL);
7668: END IF;
7669: --
7670: WSH_PICKING_BATCHES_PKG.Insert_Row(
7671: X_Rowid => l_rowid,

Line 7670: WSH_PICKING_BATCHES_PKG.Insert_Row(

7666: IF l_debug_on THEN
7667: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PICKING_BATCHES_PKG.INSERT_ROW',WSH_DEBUG_SV.C_PROC_LEVEL);
7668: END IF;
7669: --
7670: WSH_PICKING_BATCHES_PKG.Insert_Row(
7671: X_Rowid => l_rowid,
7672: X_Batch_Id => l_batch_id,
7673: P_Creation_Date => NULL,
7674: P_Created_By => NULL,

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

7836: END IF;
7837:
7838:
7839: IF l_debug_on THEN
7840: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PICKING_BATCHES_PKG.SUBMIT_RELEASE_REQUEST',WSH_DEBUG_SV.C_PROC_LEVEL);
7841: END IF;
7842: --Submit request to release batch created.
7843: x_request_ids(l_index) := WSH_PICKING_BATCHES_PKG.Submit_Release_Request(
7844: p_batch_id => l_batch_id,

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

7839: IF l_debug_on THEN
7840: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PICKING_BATCHES_PKG.SUBMIT_RELEASE_REQUEST',WSH_DEBUG_SV.C_PROC_LEVEL);
7841: END IF;
7842: --Submit request to release batch created.
7843: x_request_ids(l_index) := WSH_PICKING_BATCHES_PKG.Submit_Release_Request(
7844: p_batch_id => l_batch_id,
7845: p_log_level => l_log_level,
7846: p_num_workers => 1, -- Always 1
7847: p_commit => 'N');