2168: END Validate_ShipLinImport;
2169:
2170: -- Utility name : Delete_Ship
2171: -- Type : Private
2172: -- Function : Delete a LCM Shipment from inl_ship_holds, inl_associations,
2173: -- inl_allocations, inl_tax_lines, inl_charge_lines,
2174: -- inl_ship_lines_all, inl_ship_line_groups and inl_ship_headers_all
2175: -- Pre-reqs : None
2176: -- Parameters :
2194: p_procedure_name => l_proc_name
2195: ) ;
2196: -- Initialize API return status to success
2197: x_return_status := FND_API.G_RET_STS_SUCCESS;
2198: l_debug_info := 'Delete from inl_ship_holds';
2199: INL_LOGGING_PVT.Log_Statement(
2200: p_module_name => g_module_name,
2201: p_procedure_name => l_proc_name,
2202: p_debug_info => l_debug_info
2201: p_procedure_name => l_proc_name,
2202: p_debug_info => l_debug_info
2203: ) ;
2204:
2205: DELETE FROM inl.inl_ship_holds
2206: WHERE ship_header_id = p_ship_header_id;
2207:
2208: l_debug_info := 'Delete from inl_allocations';
2209: INL_LOGGING_PVT.Log_Statement(