DBA Data[Home] [Help]

APPS.WSMPJUPD dependencies on WSM_RESERVATIONS_PVT

Line 7467: l_rsv_exists := WSM_RESERVATIONS_PVT.check_reservation_exists(p_wip_entity_id => p_wltx_starting_jobs_tbl(l_rep_sj_index).wip_entity_id,

7463: --Start Sales Order LBJ Reservation Changes -- (Commented out as waiting for INV Changes
7464: If p_wltx_header.transaction_type_id in (WSMPCNST.SPLIT,WSMPCNST.UPDATE_ASSEMBLY,
7465: WSMPCNST.UPDATE_QUANTITY,WSMPCNST.UPDATE_ROUTING,WSMPCNST.UPDATE_LOT_NAME) then
7466: l_rep_sj_index := p_wltx_starting_jobs_tbl.first;
7467: l_rsv_exists := WSM_RESERVATIONS_PVT.check_reservation_exists(p_wip_entity_id => p_wltx_starting_jobs_tbl(l_rep_sj_index).wip_entity_id,
7468: P_org_id => p_wltx_header.organization_id,
7469: P_inventory_item_id => p_wltx_starting_jobs_tbl(l_rep_sj_index).primary_item_id
7470: ) ;
7471: If l_rsv_exists then

Line 7479: WSM_RESERVATIONS_PVT.Modify_reservations_jobupdate(p_wip_entity_id => p_wltx_starting_jobs_tbl(l_rep_sj_index).wip_entity_id,

7475: l_stmt_num := 520;
7476: l_ret_status := FND_API.G_RET_STS_SUCCESS;
7477: l_msg_count := 0;
7478: l_msg_data := null;
7479: WSM_RESERVATIONS_PVT.Modify_reservations_jobupdate(p_wip_entity_id => p_wltx_starting_jobs_tbl(l_rep_sj_index).wip_entity_id,
7480: P_old_net_qty => p_wltx_starting_jobs_tbl(l_rep_sj_index).net_quantity,
7481: P_new_net_qty => p_wltx_resulting_jobs_tbl(l_rj_index).net_quantity,
7482: P_inventory_item_id => p_wltx_starting_jobs_tbl(l_rep_sj_index).primary_item_id,
7483: P_org_id => p_wltx_header.organization_id,

Line 7497: p_msg_text => 'WSM_RESERVATIONS_PVT.Modify_reservations_jobupdate failed:'||l_msg_data,

7493: if( g_log_level_statement >= l_log_level ) then
7494:
7495: l_msg_tokens.delete;
7496: WSM_log_PVT.logMessage(p_module_name => l_module ,
7497: p_msg_text => 'WSM_RESERVATIONS_PVT.Modify_reservations_jobupdate failed:'||l_msg_data,
7498: p_stmt_num => l_stmt_num ,
7499: p_msg_tokens => l_msg_tokens,
7500: p_fnd_msg_level => G_MSG_LVL_ERROR ,
7501: p_fnd_log_level => G_LOG_LEVEL_ERROR ,

Line 7513: WSM_RESERVATIONS_PVT.modify_reservations_wlt (

7509: l_stmt_num := 530;
7510: l_ret_status := FND_API.G_RET_STS_SUCCESS;
7511: l_msg_count := 0;
7512: l_msg_data := null;
7513: WSM_RESERVATIONS_PVT.modify_reservations_wlt (
7514: p_txn_header => p_wltx_header,
7515: p_starting_jobs_tbl => p_wltx_starting_jobs_tbl,
7516: p_resulting_jobs_tbl => p_wltx_resulting_jobs_tbl,
7517: p_rep_job_index => 1,--l_ rep_job_index,

Line 7528: p_msg_text => 'WSM_RESERVATIONS_PVT.modify_reservations_wlt failed:'||l_msg_data,

7524: if( g_log_level_statement >= l_log_level ) then
7525:
7526: l_msg_tokens.delete;
7527: WSM_log_PVT.logMessage(p_module_name => l_module ,
7528: p_msg_text => 'WSM_RESERVATIONS_PVT.modify_reservations_wlt failed:'||l_msg_data,
7529: p_stmt_num => l_stmt_num ,
7530: p_msg_tokens => l_msg_tokens,
7531: p_fnd_msg_level => G_MSG_LVL_ERROR ,
7532: p_fnd_log_level => G_LOG_LEVEL_ERROR ,

Line 7546: WSM_RESERVATIONS_PVT.modify_reservations_wlt (

7542: l_stmt_num := 540;
7543: l_ret_status := FND_API.G_RET_STS_SUCCESS;
7544: l_msg_count := 0;
7545: l_msg_data := null;
7546: WSM_RESERVATIONS_PVT.modify_reservations_wlt (
7547: p_txn_header => p_wltx_header,
7548: p_starting_jobs_tbl => p_wltx_starting_jobs_tbl,
7549: p_resulting_jobs_tbl => p_wltx_resulting_jobs_tbl,
7550: p_rep_job_index => l_rep_sj_index,

Line 7562: p_msg_text => 'WSM_RESERVATIONS_PVT.modify_reservations_wlt failed:'||l_msg_data,

7558: if( g_log_level_statement >= l_log_level ) then
7559:
7560: l_msg_tokens.delete;
7561: WSM_log_PVT.logMessage(p_module_name => l_module ,
7562: p_msg_text => 'WSM_RESERVATIONS_PVT.modify_reservations_wlt failed:'||l_msg_data,
7563: p_stmt_num => l_stmt_num ,
7564: p_msg_tokens => l_msg_tokens,
7565: p_fnd_msg_level => G_MSG_LVL_ERROR ,
7566: p_fnd_log_level => G_LOG_LEVEL_ERROR ,