DBA Data[Home] [Help]

APPS.WSMPJUPD dependencies on WSM_RESERVATIONS_PVT

Line 7403: 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,

7399: --Start Sales Order LBJ Reservation Changes -- (Commented out as waiting for INV Changes
7400: If p_wltx_header.transaction_type_id in (WSMPCNST.SPLIT,WSMPCNST.UPDATE_ASSEMBLY,
7401: WSMPCNST.UPDATE_QUANTITY,WSMPCNST.UPDATE_ROUTING,WSMPCNST.UPDATE_LOT_NAME) then
7402: l_rep_sj_index := p_wltx_starting_jobs_tbl.first;
7403: 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,
7404: P_org_id => p_wltx_header.organization_id,
7405: P_inventory_item_id => p_wltx_starting_jobs_tbl(l_rep_sj_index).primary_item_id
7406: ) ;
7407: If l_rsv_exists then

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

7411: l_stmt_num := 520;
7412: l_ret_status := FND_API.G_RET_STS_SUCCESS;
7413: l_msg_count := 0;
7414: l_msg_data := null;
7415: WSM_RESERVATIONS_PVT.Modify_reservations_jobupdate(p_wip_entity_id => p_wltx_starting_jobs_tbl(l_rep_sj_index).wip_entity_id,
7416: P_old_net_qty => p_wltx_starting_jobs_tbl(l_rep_sj_index).net_quantity,
7417: P_new_net_qty => p_wltx_resulting_jobs_tbl(l_rj_index).net_quantity,
7418: P_inventory_item_id => p_wltx_starting_jobs_tbl(l_rep_sj_index).primary_item_id,
7419: P_org_id => p_wltx_header.organization_id,

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

7429: if( g_log_level_statement >= l_log_level ) then
7430:
7431: l_msg_tokens.delete;
7432: WSM_log_PVT.logMessage(p_module_name => l_module ,
7433: p_msg_text => 'WSM_RESERVATIONS_PVT.Modify_reservations_jobupdate failed:'||l_msg_data,
7434: p_stmt_num => l_stmt_num ,
7435: p_msg_tokens => l_msg_tokens,
7436: p_fnd_msg_level => G_MSG_LVL_ERROR ,
7437: p_fnd_log_level => G_LOG_LEVEL_ERROR ,

Line 7449: WSM_RESERVATIONS_PVT.modify_reservations_wlt (

7445: l_stmt_num := 530;
7446: l_ret_status := FND_API.G_RET_STS_SUCCESS;
7447: l_msg_count := 0;
7448: l_msg_data := null;
7449: WSM_RESERVATIONS_PVT.modify_reservations_wlt (
7450: p_txn_header => p_wltx_header,
7451: p_starting_jobs_tbl => p_wltx_starting_jobs_tbl,
7452: p_resulting_jobs_tbl => p_wltx_resulting_jobs_tbl,
7453: p_rep_job_index => 1,--l_ rep_job_index,

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

7460: if( g_log_level_statement >= l_log_level ) then
7461:
7462: l_msg_tokens.delete;
7463: WSM_log_PVT.logMessage(p_module_name => l_module ,
7464: p_msg_text => 'WSM_RESERVATIONS_PVT.modify_reservations_wlt failed:'||l_msg_data,
7465: p_stmt_num => l_stmt_num ,
7466: p_msg_tokens => l_msg_tokens,
7467: p_fnd_msg_level => G_MSG_LVL_ERROR ,
7468: p_fnd_log_level => G_LOG_LEVEL_ERROR ,

Line 7482: WSM_RESERVATIONS_PVT.modify_reservations_wlt (

7478: l_stmt_num := 540;
7479: l_ret_status := FND_API.G_RET_STS_SUCCESS;
7480: l_msg_count := 0;
7481: l_msg_data := null;
7482: WSM_RESERVATIONS_PVT.modify_reservations_wlt (
7483: p_txn_header => p_wltx_header,
7484: p_starting_jobs_tbl => p_wltx_starting_jobs_tbl,
7485: p_resulting_jobs_tbl => p_wltx_resulting_jobs_tbl,
7486: p_rep_job_index => l_rep_sj_index,

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

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