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 3566: INV_Kanban_PVT.Update_Card_Supply_Status(X_Return_Status => l_return_status,

3562: if l_job_kanban_card_id is not null then
3563:
3564: l_return_status := null;
3565:
3566: INV_Kanban_PVT.Update_Card_Supply_Status(X_Return_Status => l_return_status,
3567: p_Kanban_Card_Id => l_job_kanban_card_id,
3568: p_Supply_Status => INV_Kanban_PVT.G_Supply_Status_Exception
3569: );
3570:

Line 3568: p_Supply_Status => INV_Kanban_PVT.G_Supply_Status_Exception

3564: l_return_status := null;
3565:
3566: INV_Kanban_PVT.Update_Card_Supply_Status(X_Return_Status => l_return_status,
3567: p_Kanban_Card_Id => l_job_kanban_card_id,
3568: p_Supply_Status => INV_Kanban_PVT.G_Supply_Status_Exception
3569: );
3570:
3571: if ( l_return_status <> fnd_api.g_ret_sts_success ) then
3572: x_err_code := -1;

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

5315: -- do not set the kanban card to Exception just because the qties of the starting jobs have become 0
5316: if( g_log_level_statement >= l_log_level ) then
5317: l_msg_tokens.delete;
5318: WSM_log_PVT.logMessage(p_module_name => l_module ,
5319: p_msg_text => 'Calling INV_Kanban_PVT.Update_Card_Supply_Status',
5320: p_stmt_num => l_stmt_num ,
5321: p_msg_tokens => l_msg_tokens,
5322: p_fnd_log_level => g_log_level_statement,
5323: p_run_log_level => l_log_level

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

5323: p_run_log_level => l_log_level
5324: );
5325: End if;
5326:
5327: INV_Kanban_PVT.Update_Card_Supply_Status( X_Return_Status => l_ret_status,
5328: p_Kanban_Card_Id => l_kanban_card_id,
5329: p_Supply_Status => INV_Kanban_PVT.G_Supply_Status_InProcess,
5330: p_Document_type => inv_kanban_pvt.G_Doc_type_lot_job,
5331: p_Document_Header_Id => p_wltx_resulting_jobs_tbl(l_job_counter).wip_entity_id,

Line 5329: p_Supply_Status => INV_Kanban_PVT.G_Supply_Status_InProcess,

5325: End if;
5326:
5327: INV_Kanban_PVT.Update_Card_Supply_Status( X_Return_Status => l_ret_status,
5328: p_Kanban_Card_Id => l_kanban_card_id,
5329: p_Supply_Status => INV_Kanban_PVT.G_Supply_Status_InProcess,
5330: p_Document_type => inv_kanban_pvt.G_Doc_type_lot_job,
5331: p_Document_Header_Id => p_wltx_resulting_jobs_tbl(l_job_counter).wip_entity_id,
5332: p_Document_detail_Id => '',
5333: p_replenish_quantity => p_wltx_resulting_jobs_tbl(l_job_counter).start_quantity

Line 5330: p_Document_type => inv_kanban_pvt.G_Doc_type_lot_job,

5326:
5327: INV_Kanban_PVT.Update_Card_Supply_Status( X_Return_Status => l_ret_status,
5328: p_Kanban_Card_Id => l_kanban_card_id,
5329: p_Supply_Status => INV_Kanban_PVT.G_Supply_Status_InProcess,
5330: p_Document_type => inv_kanban_pvt.G_Doc_type_lot_job,
5331: p_Document_Header_Id => p_wltx_resulting_jobs_tbl(l_job_counter).wip_entity_id,
5332: p_Document_detail_Id => '',
5333: p_replenish_quantity => p_wltx_resulting_jobs_tbl(l_job_counter).start_quantity
5334: );

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

5690: l_stmt_num := 120;
5691: if( g_log_level_statement >= l_log_level ) then
5692: l_msg_tokens.delete;
5693: WSM_log_PVT.logMessage(p_module_name => l_module ,
5694: p_msg_text => ' Calling INV_Kanban_PVT.Update_Card_Supply_Status...',
5695: p_stmt_num => l_stmt_num ,
5696: p_msg_tokens => l_msg_tokens,
5697: p_fnd_log_level => g_log_level_statement,
5698: p_run_log_level => l_log_level

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

5699: );
5700: End if;
5701:
5702: -- SpUA .. so remove it...
5703: INV_Kanban_PVT.Update_Card_Supply_Status ( X_Return_Status => l_ret_status,
5704: p_Kanban_Card_Id => p_wltx_starting_jobs_tbl(l_rep_sj_index).kanban_card_id,
5705: p_Supply_Status => INV_Kanban_PVT.G_Supply_Status_Exception
5706: );
5707:

Line 5705: p_Supply_Status => INV_Kanban_PVT.G_Supply_Status_Exception

5701:
5702: -- SpUA .. so remove it...
5703: INV_Kanban_PVT.Update_Card_Supply_Status ( X_Return_Status => l_ret_status,
5704: p_Kanban_Card_Id => p_wltx_starting_jobs_tbl(l_rep_sj_index).kanban_card_id,
5705: p_Supply_Status => INV_Kanban_PVT.G_Supply_Status_Exception
5706: );
5707:
5708: if ( l_ret_status <> fnd_api.g_ret_sts_success ) then
5709:

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

5779: l_stmt_num := 147;
5780: if( g_log_level_statement >= l_log_level ) then
5781: l_msg_tokens.delete;
5782: WSM_log_PVT.logMessage(p_module_name => l_module ,
5783: p_msg_text => ' Calling INV_Kanban_PVT.Update_Card_Supply_Status...',
5784: p_stmt_num => l_stmt_num ,
5785: p_msg_tokens => l_msg_tokens,
5786: p_fnd_log_level => g_log_level_statement,
5787: p_run_log_level => l_log_level

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

5788: );
5789: End if;
5790:
5791:
5792: INV_Kanban_PVT.Update_Card_Supply_Status( x_return_status => l_ret_Status,
5793: p_Kanban_Card_Id => l_kanban_card_id,
5794: p_Supply_Status => INV_Kanban_PVT.G_Supply_Status_InProcess,
5795: p_Document_type => inv_kanban_pvt.G_Doc_type_lot_job,
5796: p_Document_Header_Id => p_wltx_starting_jobs_tbl(l_job_counter).wip_entity_id,

Line 5794: p_Supply_Status => INV_Kanban_PVT.G_Supply_Status_InProcess,

5790:
5791:
5792: INV_Kanban_PVT.Update_Card_Supply_Status( x_return_status => l_ret_Status,
5793: p_Kanban_Card_Id => l_kanban_card_id,
5794: p_Supply_Status => INV_Kanban_PVT.G_Supply_Status_InProcess,
5795: p_Document_type => inv_kanban_pvt.G_Doc_type_lot_job,
5796: p_Document_Header_Id => p_wltx_starting_jobs_tbl(l_job_counter).wip_entity_id,
5797: p_Document_detail_Id => '',
5798: p_replenish_quantity => p_wltx_resulting_jobs_tbl(l_sj_also_rj_index).start_quantity

Line 5795: p_Document_type => inv_kanban_pvt.G_Doc_type_lot_job,

5791:
5792: INV_Kanban_PVT.Update_Card_Supply_Status( x_return_status => l_ret_Status,
5793: p_Kanban_Card_Id => l_kanban_card_id,
5794: p_Supply_Status => INV_Kanban_PVT.G_Supply_Status_InProcess,
5795: p_Document_type => inv_kanban_pvt.G_Doc_type_lot_job,
5796: p_Document_Header_Id => p_wltx_starting_jobs_tbl(l_job_counter).wip_entity_id,
5797: p_Document_detail_Id => '',
5798: p_replenish_quantity => p_wltx_resulting_jobs_tbl(l_sj_also_rj_index).start_quantity
5799: );

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

5898: (p_wltx_resulting_jobs_tbl(p_wltx_resulting_jobs_tbl.first).kanban_card_id IS NOT NULL AND
5899: p_wltx_resulting_jobs_tbl(p_wltx_resulting_jobs_tbl.first).kanban_card_id <> l_kanban_card_id)
5900: then
5901:
5902: INV_Kanban_PVT.Update_Card_Supply_Status ( x_return_status => l_ret_status,
5903: p_Kanban_Card_Id => p_wltx_starting_jobs_tbl(l_job_counter).kanban_card_id,
5904: p_Supply_Status => INV_Kanban_PVT.G_Supply_Status_Exception
5905: );
5906:

Line 5904: p_Supply_Status => INV_Kanban_PVT.G_Supply_Status_Exception

5900: then
5901:
5902: INV_Kanban_PVT.Update_Card_Supply_Status ( x_return_status => l_ret_status,
5903: p_Kanban_Card_Id => p_wltx_starting_jobs_tbl(l_job_counter).kanban_card_id,
5904: p_Supply_Status => INV_Kanban_PVT.G_Supply_Status_Exception
5905: );
5906:
5907: if ( l_ret_Status <> fnd_api.g_ret_sts_success ) then
5908: IF g_log_level_error >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR) THEN

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

6765: if l_sub_loc_change = 0 then -- reflect the updated quantity in the card
6766:
6767: l_stmt_num := 147;
6768:
6769: INV_Kanban_PVT.Update_Card_Supply_Status( x_return_status => l_ret_Status,
6770: p_Kanban_Card_Id => l_kanban_card_id,
6771: p_Supply_Status => INV_Kanban_PVT.G_Supply_Status_InProcess,
6772: p_Document_type => inv_kanban_pvt.G_Doc_type_lot_job,
6773: p_Document_Header_Id => p_wltx_starting_jobs_tbl(l_rep_sj_index).wip_entity_id,

Line 6771: p_Supply_Status => INV_Kanban_PVT.G_Supply_Status_InProcess,

6767: l_stmt_num := 147;
6768:
6769: INV_Kanban_PVT.Update_Card_Supply_Status( x_return_status => l_ret_Status,
6770: p_Kanban_Card_Id => l_kanban_card_id,
6771: p_Supply_Status => INV_Kanban_PVT.G_Supply_Status_InProcess,
6772: p_Document_type => inv_kanban_pvt.G_Doc_type_lot_job,
6773: p_Document_Header_Id => p_wltx_starting_jobs_tbl(l_rep_sj_index).wip_entity_id,
6774: p_Document_detail_Id => '',
6775: p_replenish_quantity => p_wltx_resulting_jobs_tbl(l_rj_index).start_quantity

Line 6772: p_Document_type => inv_kanban_pvt.G_Doc_type_lot_job,

6768:
6769: INV_Kanban_PVT.Update_Card_Supply_Status( x_return_status => l_ret_Status,
6770: p_Kanban_Card_Id => l_kanban_card_id,
6771: p_Supply_Status => INV_Kanban_PVT.G_Supply_Status_InProcess,
6772: p_Document_type => inv_kanban_pvt.G_Doc_type_lot_job,
6773: p_Document_Header_Id => p_wltx_starting_jobs_tbl(l_rep_sj_index).wip_entity_id,
6774: p_Document_detail_Id => '',
6775: p_replenish_quantity => p_wltx_resulting_jobs_tbl(l_rj_index).start_quantity
6776: );