[Home] [Help]
37: l_msg_count NUMBER :=0;
38: l_msg_data VARCHAR2(2000);
39: l_return_status VARCHAR2(1);
40:
41: --l_wdd_rec wsh_delivery_details%rowtype;
42: l_wdd_id NUMBER;
43: l_so_line_id NUMBER;
44: l_api_return_status VARCHAR2(1);
45: l_api_error_code NUMBER;
71: p_run_id => p_migration_run_id
72: , p_log_level => FND_LOG.LEVEL_PROCEDURE
73: , p_app_short_name => 'WSH'
74: , p_message_token => 'WSH_MIGRATION_TABLE_STARTED'
75: , p_table_name => 'wsh_delivery_details'
76: , p_context => 'LOT_NUMBER_UPDATES'
77: );
78:
79: l_table_name := 'WSH_DELIVERY_DETAILS';
75: , p_table_name => 'wsh_delivery_details'
76: , p_context => 'LOT_NUMBER_UPDATES'
77: );
78:
79: l_table_name := 'WSH_DELIVERY_DETAILS';
80: l_opm_table_name := 'IC_TRAN_PND';
81:
82: /* Get all the transaction record related to OM lines to be processed */
83: FOR opm_trans_rec IN get_opm_trans LOOP
105: GMI_RESERVATION_UTIL.println('ODM parent lot number '||l_parent_lot_number);
106: /* update wdd with the new lot_number */
107: /* if the API get_odm_lot can not get the odm lot number, these wdds would not be updated */
108: if (l_odm_lot_number is not null) and nvl(l_wdd_id, 0) <> 0 then
109: Update wsh_delivery_details
110: set lot_number = l_odm_lot_number
111: where delivery_detail_id = l_wdd_id
112: and lot_number is not null
113: ;
124: , p_log_level => FND_LOG.LEVEL_UNEXPECTED
125: , p_app_short_name =>'WSH'
126: , p_message_token => 'WSH_MIGRATION_DB_ERROR'
127: , p_db_error => sqlerrm
128: , p_table_name => 'wsh_delivery_details'
129: , p_context => 'LOT_NUMBER_UPDATES'
130: );
131: End;
132: End Loop;