109:
110: END IF;
111: elsif (l_transaction_type_tbl(i) = 'CSISOSHP') then
112:
113: debug(' Calling csi_order_ship_pub.order_shipment for Order Line '||l_line_id_tbl(i));
114: csi_order_ship_pub.order_shipment(
115: p_mtl_transaction_id => l_transaction_id_tbl(i),
116: p_message_id => NULL,
117: x_return_status => l_return_status,
110: END IF;
111: elsif (l_transaction_type_tbl(i) = 'CSISOSHP') then
112:
113: debug(' Calling csi_order_ship_pub.order_shipment for Order Line '||l_line_id_tbl(i));
114: csi_order_ship_pub.order_shipment(
115: p_mtl_transaction_id => l_transaction_id_tbl(i),
116: p_message_id => NULL,
117: x_return_status => l_return_status,
118: px_trx_error_rec => l_error_rec);
116: p_message_id => NULL,
117: x_return_status => l_return_status,
118: px_trx_error_rec => l_error_rec);
119:
120: debug(' After Calling csi_order_ship_pub.order_shipment for Order Line: '||l_line_id_tbl(i)||' with Return Status '||l_return_status);
121: IF (l_return_status is null OR l_return_status <> fnd_api.g_ret_sts_success) THEN
122: fnd_file.put_line(fnd_file.log,'Error Occured while processing Order Line '||l_line_id_tbl(i));
123: debug('Call to csi_order_ship_pub.order_shipment fails with status '||l_return_status);
124:
119:
120: debug(' After Calling csi_order_ship_pub.order_shipment for Order Line: '||l_line_id_tbl(i)||' with Return Status '||l_return_status);
121: IF (l_return_status is null OR l_return_status <> fnd_api.g_ret_sts_success) THEN
122: fnd_file.put_line(fnd_file.log,'Error Occured while processing Order Line '||l_line_id_tbl(i));
123: debug('Call to csi_order_ship_pub.order_shipment fails with status '||l_return_status);
124:
125: UPDATE CSI_BATCH_TXN_LINES
126: SET processed_flag = 4,last_update_date = sysdate,last_updated_by = fnd_global.user_id
127: WHERE batch_id = p_batch_id