DBA Data[Home] [Help]

APPS.WSMPJUPD dependencies on INV_KANBAN_PVT

Line 2496: INV_Kanban_PVT.Update_Card_Supply_Status (X_Return_Status => l_ret_status,

2492: l_sub_loc_change_flag := 1;
2493:
2494: l_stmt_num := 30;
2495:
2496: INV_Kanban_PVT.Update_Card_Supply_Status (X_Return_Status => l_ret_status,
2497: p_Kanban_Card_Id => p_kanban_card_id,
2498: p_Supply_Status => INV_Kanban_PVT.G_Supply_Status_Exception
2499: );
2500:

Line 2498: p_Supply_Status => INV_Kanban_PVT.G_Supply_Status_Exception

2494: l_stmt_num := 30;
2495:
2496: INV_Kanban_PVT.Update_Card_Supply_Status (X_Return_Status => l_ret_status,
2497: p_Kanban_Card_Id => p_kanban_card_id,
2498: p_Supply_Status => INV_Kanban_PVT.G_Supply_Status_Exception
2499: );
2500:
2501: if ( l_ret_status <> fnd_api.g_ret_sts_success ) then
2502: x_err_code := -1;

Line 3560: INV_Kanban_PVT.Update_Card_Supply_Status(X_Return_Status => l_return_status,

3556: if l_job_kanban_card_id is not null then
3557:
3558: l_return_status := null;
3559:
3560: INV_Kanban_PVT.Update_Card_Supply_Status(X_Return_Status => l_return_status,
3561: p_Kanban_Card_Id => l_job_kanban_card_id,
3562: p_Supply_Status => INV_Kanban_PVT.G_Supply_Status_Exception
3563: );
3564:

Line 3562: p_Supply_Status => INV_Kanban_PVT.G_Supply_Status_Exception

3558: l_return_status := null;
3559:
3560: INV_Kanban_PVT.Update_Card_Supply_Status(X_Return_Status => l_return_status,
3561: p_Kanban_Card_Id => l_job_kanban_card_id,
3562: p_Supply_Status => INV_Kanban_PVT.G_Supply_Status_Exception
3563: );
3564:
3565: if ( l_return_status <> fnd_api.g_ret_sts_success ) then
3566: x_err_code := -1;

Line 5255: p_msg_text => 'Calling INV_Kanban_PVT.Update_Card_Supply_Status',

5251: -- do not set the kanban card to Exception just because the qties of the starting jobs have become 0
5252: if( g_log_level_statement >= l_log_level ) then
5253: l_msg_tokens.delete;
5254: WSM_log_PVT.logMessage(p_module_name => l_module ,
5255: p_msg_text => 'Calling INV_Kanban_PVT.Update_Card_Supply_Status',
5256: p_stmt_num => l_stmt_num ,
5257: p_msg_tokens => l_msg_tokens,
5258: p_fnd_log_level => g_log_level_statement,
5259: p_run_log_level => l_log_level

Line 5263: INV_Kanban_PVT.Update_Card_Supply_Status( X_Return_Status => l_ret_status,

5259: p_run_log_level => l_log_level
5260: );
5261: End if;
5262:
5263: INV_Kanban_PVT.Update_Card_Supply_Status( X_Return_Status => l_ret_status,
5264: p_Kanban_Card_Id => l_kanban_card_id,
5265: p_Supply_Status => INV_Kanban_PVT.G_Supply_Status_InProcess,
5266: p_Document_type => inv_kanban_pvt.G_Doc_type_lot_job,
5267: p_Document_Header_Id => p_wltx_resulting_jobs_tbl(l_job_counter).wip_entity_id,

Line 5265: p_Supply_Status => INV_Kanban_PVT.G_Supply_Status_InProcess,

5261: End if;
5262:
5263: INV_Kanban_PVT.Update_Card_Supply_Status( X_Return_Status => l_ret_status,
5264: p_Kanban_Card_Id => l_kanban_card_id,
5265: p_Supply_Status => INV_Kanban_PVT.G_Supply_Status_InProcess,
5266: p_Document_type => inv_kanban_pvt.G_Doc_type_lot_job,
5267: p_Document_Header_Id => p_wltx_resulting_jobs_tbl(l_job_counter).wip_entity_id,
5268: p_Document_detail_Id => '',
5269: p_replenish_quantity => p_wltx_resulting_jobs_tbl(l_job_counter).start_quantity

Line 5266: p_Document_type => inv_kanban_pvt.G_Doc_type_lot_job,

5262:
5263: INV_Kanban_PVT.Update_Card_Supply_Status( X_Return_Status => l_ret_status,
5264: p_Kanban_Card_Id => l_kanban_card_id,
5265: p_Supply_Status => INV_Kanban_PVT.G_Supply_Status_InProcess,
5266: p_Document_type => inv_kanban_pvt.G_Doc_type_lot_job,
5267: p_Document_Header_Id => p_wltx_resulting_jobs_tbl(l_job_counter).wip_entity_id,
5268: p_Document_detail_Id => '',
5269: p_replenish_quantity => p_wltx_resulting_jobs_tbl(l_job_counter).start_quantity
5270: );

Line 5630: p_msg_text => ' Calling INV_Kanban_PVT.Update_Card_Supply_Status...',

5626: l_stmt_num := 120;
5627: if( g_log_level_statement >= l_log_level ) then
5628: l_msg_tokens.delete;
5629: WSM_log_PVT.logMessage(p_module_name => l_module ,
5630: p_msg_text => ' Calling INV_Kanban_PVT.Update_Card_Supply_Status...',
5631: p_stmt_num => l_stmt_num ,
5632: p_msg_tokens => l_msg_tokens,
5633: p_fnd_log_level => g_log_level_statement,
5634: p_run_log_level => l_log_level

Line 5639: INV_Kanban_PVT.Update_Card_Supply_Status ( X_Return_Status => l_ret_status,

5635: );
5636: End if;
5637:
5638: -- SpUA .. so remove it...
5639: INV_Kanban_PVT.Update_Card_Supply_Status ( X_Return_Status => l_ret_status,
5640: p_Kanban_Card_Id => p_wltx_starting_jobs_tbl(l_rep_sj_index).kanban_card_id,
5641: p_Supply_Status => INV_Kanban_PVT.G_Supply_Status_Exception
5642: );
5643:

Line 5641: p_Supply_Status => INV_Kanban_PVT.G_Supply_Status_Exception

5637:
5638: -- SpUA .. so remove it...
5639: INV_Kanban_PVT.Update_Card_Supply_Status ( X_Return_Status => l_ret_status,
5640: p_Kanban_Card_Id => p_wltx_starting_jobs_tbl(l_rep_sj_index).kanban_card_id,
5641: p_Supply_Status => INV_Kanban_PVT.G_Supply_Status_Exception
5642: );
5643:
5644: if ( l_ret_status <> fnd_api.g_ret_sts_success ) then
5645:

Line 5719: p_msg_text => ' Calling INV_Kanban_PVT.Update_Card_Supply_Status...',

5715: l_stmt_num := 147;
5716: if( g_log_level_statement >= l_log_level ) then
5717: l_msg_tokens.delete;
5718: WSM_log_PVT.logMessage(p_module_name => l_module ,
5719: p_msg_text => ' Calling INV_Kanban_PVT.Update_Card_Supply_Status...',
5720: p_stmt_num => l_stmt_num ,
5721: p_msg_tokens => l_msg_tokens,
5722: p_fnd_log_level => g_log_level_statement,
5723: p_run_log_level => l_log_level

Line 5728: INV_Kanban_PVT.Update_Card_Supply_Status( x_return_status => l_ret_Status,

5724: );
5725: End if;
5726:
5727:
5728: INV_Kanban_PVT.Update_Card_Supply_Status( x_return_status => l_ret_Status,
5729: p_Kanban_Card_Id => l_kanban_card_id,
5730: p_Supply_Status => INV_Kanban_PVT.G_Supply_Status_InProcess,
5731: p_Document_type => inv_kanban_pvt.G_Doc_type_lot_job,
5732: p_Document_Header_Id => p_wltx_starting_jobs_tbl(l_job_counter).wip_entity_id,

Line 5730: p_Supply_Status => INV_Kanban_PVT.G_Supply_Status_InProcess,

5726:
5727:
5728: INV_Kanban_PVT.Update_Card_Supply_Status( x_return_status => l_ret_Status,
5729: p_Kanban_Card_Id => l_kanban_card_id,
5730: p_Supply_Status => INV_Kanban_PVT.G_Supply_Status_InProcess,
5731: p_Document_type => inv_kanban_pvt.G_Doc_type_lot_job,
5732: p_Document_Header_Id => p_wltx_starting_jobs_tbl(l_job_counter).wip_entity_id,
5733: p_Document_detail_Id => '',
5734: p_replenish_quantity => p_wltx_resulting_jobs_tbl(l_sj_also_rj_index).start_quantity

Line 5731: p_Document_type => inv_kanban_pvt.G_Doc_type_lot_job,

5727:
5728: INV_Kanban_PVT.Update_Card_Supply_Status( x_return_status => l_ret_Status,
5729: p_Kanban_Card_Id => l_kanban_card_id,
5730: p_Supply_Status => INV_Kanban_PVT.G_Supply_Status_InProcess,
5731: p_Document_type => inv_kanban_pvt.G_Doc_type_lot_job,
5732: p_Document_Header_Id => p_wltx_starting_jobs_tbl(l_job_counter).wip_entity_id,
5733: p_Document_detail_Id => '',
5734: p_replenish_quantity => p_wltx_resulting_jobs_tbl(l_sj_also_rj_index).start_quantity
5735: );

Line 5838: INV_Kanban_PVT.Update_Card_Supply_Status ( x_return_status => l_ret_status,

5834: (p_wltx_resulting_jobs_tbl(p_wltx_resulting_jobs_tbl.first).kanban_card_id IS NOT NULL AND
5835: p_wltx_resulting_jobs_tbl(p_wltx_resulting_jobs_tbl.first).kanban_card_id <> l_kanban_card_id)
5836: then
5837:
5838: INV_Kanban_PVT.Update_Card_Supply_Status ( x_return_status => l_ret_status,
5839: p_Kanban_Card_Id => p_wltx_starting_jobs_tbl(l_job_counter).kanban_card_id,
5840: p_Supply_Status => INV_Kanban_PVT.G_Supply_Status_Exception
5841: );
5842:

Line 5840: p_Supply_Status => INV_Kanban_PVT.G_Supply_Status_Exception

5836: then
5837:
5838: INV_Kanban_PVT.Update_Card_Supply_Status ( x_return_status => l_ret_status,
5839: p_Kanban_Card_Id => p_wltx_starting_jobs_tbl(l_job_counter).kanban_card_id,
5840: p_Supply_Status => INV_Kanban_PVT.G_Supply_Status_Exception
5841: );
5842:
5843: if ( l_ret_Status <> fnd_api.g_ret_sts_success ) then
5844: IF g_log_level_error >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR) THEN

Line 6705: INV_Kanban_PVT.Update_Card_Supply_Status( x_return_status => l_ret_Status,

6701: if l_sub_loc_change = 0 then -- reflect the updated quantity in the card
6702:
6703: l_stmt_num := 147;
6704:
6705: INV_Kanban_PVT.Update_Card_Supply_Status( x_return_status => l_ret_Status,
6706: p_Kanban_Card_Id => l_kanban_card_id,
6707: p_Supply_Status => INV_Kanban_PVT.G_Supply_Status_InProcess,
6708: p_Document_type => inv_kanban_pvt.G_Doc_type_lot_job,
6709: p_Document_Header_Id => p_wltx_starting_jobs_tbl(l_rep_sj_index).wip_entity_id,

Line 6707: p_Supply_Status => INV_Kanban_PVT.G_Supply_Status_InProcess,

6703: l_stmt_num := 147;
6704:
6705: INV_Kanban_PVT.Update_Card_Supply_Status( x_return_status => l_ret_Status,
6706: p_Kanban_Card_Id => l_kanban_card_id,
6707: p_Supply_Status => INV_Kanban_PVT.G_Supply_Status_InProcess,
6708: p_Document_type => inv_kanban_pvt.G_Doc_type_lot_job,
6709: p_Document_Header_Id => p_wltx_starting_jobs_tbl(l_rep_sj_index).wip_entity_id,
6710: p_Document_detail_Id => '',
6711: p_replenish_quantity => p_wltx_resulting_jobs_tbl(l_rj_index).start_quantity

Line 6708: p_Document_type => inv_kanban_pvt.G_Doc_type_lot_job,

6704:
6705: INV_Kanban_PVT.Update_Card_Supply_Status( x_return_status => l_ret_Status,
6706: p_Kanban_Card_Id => l_kanban_card_id,
6707: p_Supply_Status => INV_Kanban_PVT.G_Supply_Status_InProcess,
6708: p_Document_type => inv_kanban_pvt.G_Doc_type_lot_job,
6709: p_Document_Header_Id => p_wltx_starting_jobs_tbl(l_rep_sj_index).wip_entity_id,
6710: p_Document_detail_Id => '',
6711: p_replenish_quantity => p_wltx_resulting_jobs_tbl(l_rj_index).start_quantity
6712: );